Changed Resource 'Hire Date'' Causes Opened/Returned Timesheets To Not Be Editable

Products

• Clarity PPM On Premise

Issue/Introduction

Timesheet users still have access to the Classic portlet: Timesheet Review.
Even though they are able to see the past time period, they are not able to edit or submit the 0-hour timesheet.

Can the unneeded timesheet be removed or fixed?

Cause

This is by design. When the 'My Timesheet' time period is selected, a timesheet id is automatically created.
If there is a change in the resource's hire date, where it is no longer intersecting with the time period and moves beyond the time period in question, 
the timesheet will not allow the timesheet to be editable.

Resolution

The following query can be used to find out all the resource timesheet/timeperiods that are affected.

SELECT
    b.id,
    b.unique_name,
    b.DATE_OF_HIRE,
    a.prid,
    a.pruid,
    a.prtimeperiodid,
    c.pruid,
    c.prstart,
    c.prfinish
FROM
    prtimesheet a
INNER JOIN
    srm_resources b ON a.PRRESOURCEID = b.id
INNER JOIN
    prtimeperiod c ON c.prid = a.PRTIMEPERIODID
WHERE
    a.prstatus < 4 
    -- AND a.prresourceid = 5xxxxxx --provide resource id 
    AND b.DATE_OF_HIRE > c.prstart
ORDER BY
    a.prtimeperiodid DESC;

Please contact Support if there are further questions.