The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

ppm 7.1 sp5 time sheet line transaction history

Highlighted
tony sanchez_1
Super Collector

ppm 7.1 sp5 time sheet line transaction history

I'm having a thicky moment and can't locate the table(s) name(s) that stores the time sheet and time sheet line transaction history.

Can anyone help ?
2 REPLIES
Darshan Bavisi
Occasional Visitor

Re: ppm 7.1 sp5 time sheet line transaction history

Hello Tony,

You can find the time sheet audit history in the ITG_AUDIT_EVENTS table. In this table, look for the column 'CONTAINER0_TYPE'. This column refers to the entity in the KNTA_ENTITIES table. In the KNTA_ENTITIES table you can look for the ENTITY_ID column for the entities Timesheet and Timesheet Line (stored in the ENTITY_NAME column in the KNTA_ENTITIES table). Once you have the ENTITY_ID then use the same id in the ITG_AUDIT_EVENTS table in the 'CONTAINER0_TYPE' column and you will be able to find the timesheet audit history.
tony sanchez_1
Super Collector

Re: ppm 7.1 sp5 time sheet line transaction history

thank you very much.

It works a treat
//Add this to "OnDomLoad" event