Project and Portfolio Management Practitioners Forum
cancel

ppm 7.1 sp5 time sheet line transaction history

Highlighted
tony sanchez_1
Valued Contributor.

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
Outstanding Contributor.

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
Valued Contributor.

Re: ppm 7.1 sp5 time sheet line transaction history

thank you very much.

It works a treat