Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Time Sheet Query - Time Sheet Status Code

SOLVED
Go to solution
kintanadan
Regular Collector

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
Highlighted
dirkf
Honored Contributor
Solution

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

kintanadan
Regular Collector

Re: Time Sheet Query - Time Sheet Status Code

Thanks Dirk!

//Add this to "OnDomLoad" event