ETL9.x: PY_PYBL_TM_WRK Table

(Doc ID 2169936.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

This PY_PYBL_TM_WRK is more like a shadow table for TL_PAYABLE_TIME.

Can anyone explain to me how this table is populated (INSERT INTO PS_PY_PYBL_TM_WRK ...) at the TL Load to Payroll process. I have done a "Find In .." in Peoplecodes and SQLs and also a search in the *.DMS for the cobols. Nothing has come up as how this table is populated to begin with for the cobol processing in PSPLDTL1/2/3 later.

We have found an issue in our HCM91 environment in which a monthly employee who was terminated on 2016-04-02 and later on rehired on 2016-04-11. The first employment was paid from T&L to Payroll using an on cycle. Then the second employment was paid from T&L to Payroll and then using an off cycle of the same run id. Yet it was found that the some T&L hours from 2016-04-11+ were recorded in the off cycle pay with earnings begin/end dates on 2016-04-02. We are trying to follow the cobol PSPLDTL2 and would like to know what is in the PY_PYBL_TM_WRK at the time.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms