What are the different statuses of timesheets
search cancel

What are the different statuses of timesheets


Article ID: 225258


Updated On:


Clarity PPM On Premise Clarity PPM SaaS ACF2 - DB2 Option


There are five different timesheet statuses, what are they and how are they related in the database?


Release : 15.9.1

Component :


The timesheet statuses and related value in table prtimesheet.prstatus

Open:             prstatus = 0  (timesheet can be edited and can be submitted for approval)

Submitted:     prstatus = 1 (timesheet can be approved or returned)

Returned:      prstatus = 2  (timesheet can be edited and resubmitted for approval)

Approved:     prstatus = 3  (timesheet can be returned)

Posted:         prstatus = 4 (If timesheet is adjusted, an adjustment timesheet is created)

Adjusted:      prstatus  = 5 (Adjustment timesheet is created, adjusted timesheet is referenced)


Additional Information

Descriptions of fields for each table in both PPM and DWH can be found by running the Out of the Box Jaspersoft reports

PPM Schema or

DWH Schema

You can choose which table(s) you want in the Options.

If there is a process that auto-approves submitted timesheets, the timesheet can be returned.
If returned, the timesheet can be resubmitted for auto-approval.