Review Timesheet Data From UI

Products

• Clarity PPM On Premise

Issue/Introduction

This article can assist in reviewing timesheet and time entries associated with a particular resource or time period.

 

Environment

Release : 15.8

Component : CA PPM APPLICATION

Resolution

1. Obtain the timesheet id, resource id, time period id from the browser URL address.

Example: 

http://<server>/niku/nu#action:timeadmin.editTimesheet&id=5033000&resid=5009005&tpid=5003007
where
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

Additional Information

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