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


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)

Submitted:     prstatus = 1

Returned:      prstatus = 2  (timesheet can be edited)

Approved:     prstatus = 3

Posted:         prstatus = 4

Adjusted:      prstatus  = 5


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.