This article can assist in reviewing timesheet and time entries associated with a particular resource or time period.
Release : 15.8
Component : CA PPM APPLICATION
1. Obtain the timesheet id, resource id, time period id from the browser URL address.
x = editTimesheet&id
y = resid
z = tpid
2. The following queries can be used to examine the timesheet.
select * from prtimesheet
where prid = x
and prresourceid = y
and prtimeperiodid = z
3. Review the timesheet properties and the associated time entries
For timesheet and time entry notes, the following query can be used:
select * from PRNOTE
where prrecordid in (select prid from PRTIMEENTRY where prtimesheetid = xxxxxx)
and prtablename = 'PRTimeEntry'
order by PRRECORDID