search cancel

Daily timesheet hours in the database

book

Article ID: 133137

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

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?

Environment

Release : All

Component : CLARITY TIME SLICING

Resolution

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...).