Time Reporting Period Weekly Actuals versus Daily Actuals

Document ID : KB000055258
Last Modified Date : 14/02/2018
Show Technical Document Details
Description:
I am trying to create a portlet that looks at Daily Timesheet Entry Data.  Which Time Slice Request should I use?
  
  
Solution:  
If you need Timesheet Daily Time Entry data, use a Time Slice Definition that is configured for Daily Slices for the 'Time entries' item.
The application has a pre-defined Daily Resource Time Curve.  Check this definition for the date ranges of available data to query.
 
DAILYRESOURCETIMECURVE
 

Below is an example, simplified query that shows the daily Timesheet Actual Hours for all the days within the selected Time Reporting Period for a specific Resource.

SELECT 'Timeentries' Slice_Object, Slice, slice_date, r.full_name resource_name, 
tp.prstart Timeperiod_start, ts.prid TimesheetID, ts.prstatus 
FROM prj_blb_slices s, prtimeentry te, prtimesheet ts, prtimeperiod tp, srm_resources r
WHERE s.prj_object_id = te.prid and te.prtimesheetid = ts.prid and
ts.prtimeperiodid = tp.prid and ts.prresourceid = r.id AND
r.unique_name like 'Replace with Resource Code' AND
tp.prstart = 'Replace with a valid Time Reporting Start Date DD-MMM-YYYY' AND 
slice_request_id = 55555