Project and Portfolio Management Practitioners Forum
cancel

Notes in Time sheets

Highlighted
Bhuvan_563
Valued Contributor.

Notes in Time sheets

Hi,

 

could any one please let me know where does "Notes" in the time sheets store and also the relation with the tm_time sheets table. Please find the attachment. Notes seen at the time sheet level not in the time sheet lines.

3 REPLIES
Mohit_Agrawal
Outstanding Contributor.

Re: Notes in Time sheets

Hi Bhuvan,

You can use KNTA_NOTES table to get the notes of any entity in PPM.
Celil
Acclaimed Contributor.

Re: Notes in Time sheets

Hi Bhuvan,

 

KNTA_NOTE_ENTRIES : This table stores the notes for all entities

 

relations:

PARENT_ENTITY_ID = KNTA_ENTITIES_NLS.ENTITY_ID

parent_entity_primary_key = KCRT_REQUESTS.request_id

parent_entity_primary_key = PM_PROJECTS.project_id

parent_entity_primary_key = WP_TASKS.task_id

 

PS: If the post resolves your issue, please click KUDOS star icon and mark it as Accepted Solution.

 

Celil

IT Governance Professional
& PPM Solution Architect
d4y4n4
Honored Contributor.

Re: Notes in Time sheets

Hi,

You can find these details in the data model guide

http://support.openview.hp.com/selfsolve/document/KM1014814

We have an ER to include notes at the lines level QCCR1L37773

Regards,
Dayana Campos