Project and Portfolio Management Practitioners Forum
cancel

Time Sheet Transaction History

Highlighted
bukem909
Valued Contributor.

Time Sheet Transaction History

Hi all

 

I hope someone can help me here!

 

I'm creating a portlet that needs to show the Time Sheet Transaction History. I can see this data being available when I click the Approvals / Transaction details button on the Time Sheet. However, I cannot see in the data model guide as to get this information out.

 

Can anyone point me onto the right table(s) or view(s)?

 

Thanks

2 REPLIES
Utkarsh_Mishra
Acclaimed Contributor.

Re: Time Sheet Transaction History

Time sheet Transaction history is stored in   ITG_AUDIT_EVENTS

 

Here Timehseet entity can be identified by ENTITY_ID = TTS.TIME_SHEET_ID (i.e. Timesheet ID)
       

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
bukem909
Valued Contributor.

Re: Time Sheet Transaction History

Thank you very much Utkarsh. That's helped me out a lot.

 

I should also add:

ENTITY_ID = TTS.TIME_SHEET_ID AND
EVENT_TYPE_CODE = 4 AND -- Field Change
ENTITY_NAME = TTS.DESCRIPTION -- Need time sheet description to match audit event