Project and Portfolio Management Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

Time Sheet Query - Time Sheet Status Code

SOLVED
Go to Solution
Frequent Advisor

Time Sheet Query - Time Sheet Status Code

Hello PPM experts,

 

We're trying to get time sheet totals using the View: ktmg_time_sheets_v, and we noticed some time sheets with a STATUS_CODE of: "RELEASED".

 

Does anyone know the meaning of "RELEASED"?

 

Thank you all in advance.

2 REPLIES
Honored Contributor

Re: Time Sheet Query - Time Sheet Status Code

Hi Dan,

 

The status were years ago

 

1 = ACTIVE,

2 = RELEASED,

3 = REJECTED,

4 = APPROVED,

5 = CANCELLED,

6 = FROZEN,

7 = CLOSED

 

The status that you refer to as ‘released’ and buttons referred to as ‘release’ have been replaced with:
Status: Submitted
Button: Submit.

 

If there is still that status present in your tables, it is possible that this was an upgraded instance from way back`? Especially if these timesheets showing the status were frozen prior to the upgrade and change of the status.


This is documented in PPM 7.0 Time Management User and / or Configuration Guide.
In PPM 7.1, a product enhancement was also raised to change the Actual Time Summary Report option from ‘include unreleased time sheets’ to ‘include unsubmitted time sheets’.

 

HOpe this helps. If so, please 'solve' this thread.

Best regards,

Dirk

 

-- Kudos always welcome --

Highlighted
Frequent Advisor

Re: Time Sheet Query - Time Sheet Status Code

Thanks Dirk!