What are the different statuses of timesheets

Products

• Clarity PPM On Premise
• Clarity PPM SaaS
• ACF2 - DB2 Option

Issue/Introduction

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

Environment

Release : 15.9.1

Component :

Resolution

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.