search cancel

Task Showing Time Posted Against It Erroneously

book

Article ID: 230006

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

There is a task that is showing time posted against it for specific week, though the resource was terminated several weeks prior to that date.

I do not see the timesheet in the UI.  Why is the time showing up.

Environment

Release : 15.9.3

Component : CLARITY PROJECT MANAGEMENT

Cause

Timesheet was actually submitted and posted for a future period when the resource was still active.

In the UI, timesheets will only show for the resource up to their termination date.

Resolution

If possible, temporarily remove the termination date to see if there is actually a timesheet.

If this is not possible you can create an ad-hoc view on the Time Management Domain or run a timesheet report to find it or

you can query the database to see if there is actually a timesheet.

For this you would need the resource code (unique_name) and preferably the timeperiodid which you can get from the URL from another timesheet for the same week. If you do not have the

prtimeperiodid you could use something like this

and enter the resource's unique_name (resource code)

SELECT r.UNIQUE_NAME,
  tp.PRSTART,
  ts.POSTED_TIME
FROM prtimeperiod tp
INNER JOIN PRTIMESHEET ts
ON tp.PRID = ts.PRTIMEPERIODID
INNER JOIN SRM_RESOURCES r
ON ts.PRRESOURCEID = r.ID
where 
ts.prstatus = 4
and r.unique_name = <'Enter Resource Code'>
order by tp.prstart