Track WIP Back to Timesheets

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

When timesheets post to WIP there are links back to the timesheet so you can validate the hours between the two.

 

The major components are

PPA_WIP.EXTERNALBATCHID = PRTIMESHEET.PRID

PPA_WIP.EXTTERNAL_ID = PRTIMEENTRY.PRID

PPA_WIP.EXTERNALTRANSNO = PPA_TRANSCONTROL.TRANSNO

 

Note: If a timesheet gets adjusted and hours are added to an existing row, WIP will show the new timesheetID to match to PPA_WIP.EXTERNALBATCHID however the time entries will point to the original timesheet timeentry table.

So here PPA_WIP.EXTTERNAL_ID = PRTIMEENTRY.PRID will be the timeentry lines from the  original timesheet

PPA_WIP.EXTERNALBATCHID will be the new timesheet.

 

 

 

Environment

Release : 16.0.2

Component : Clarity Financial Management

Resolution

Here are screenshots of the original timesheet 

EXTERNALBATCH_ID = 5003004 which is the original timesheet.

EXTERNAL_ID are the related entries in PRTIMEENTRY table

Adjusted the timesheet and added 1 hour to each of these tasks:

EXTERNALBATCH_ID = 5006001 which is the adjustment timesheet

EXTERNAL_ID are the same (pointing to the original timesheet)

 

Additional Information

Entity Relationship Diagrams (ERD)  - Go to the Transactions ERD