When entering timesheet data, users enter the hours by day. Where in the database are these daily hours stored for Clarity? Additionally, how would one determine what is the status of the timesheet that those daily hours are? associated to?
Release : All
Component : CLARITY TIME SLICING
The DAILYRESOURCETIMECURVE (ID:55555) time slice can be used for this.
This will show daily timesheet entry slices. The PRJ_OBJECT_ID column on this table then refers to the time entry id from the PRTIMEENTRY table. Joining the PRTIMEENTRY table to the PRTIMESHEET table will help distinguish between the different timesheet statuses (Open, Submitted, Approved, Posted...).