How to determine the originating Reported Time record for a Payable Time record?
PeopleSoft PT 8.6, HCM 9.2, MS SQL
Is there a "best practice" method, when writing Time & Labor rules that create new Payable Time records, to link those back to the originating Reported Time record?
I would use PT.ORIG_SEQ_NBR but that appears to be only used for system generated offsets. The PT.INITIAL_SEQ_NBR appears to be automatically created as the original Payable time sequence number.
For example, we have a rule that adjusts the leave type when an employee requests more leave than they have available. When the employee requests Sick leave and exceeds their balance amount, the rule attempts to use other leave types in a specified sequence. An employee with 4 hours of Sick leave requests 8 hours, the rule will change the Sick leave request to 4 hours and then create a new payable time record for Personal leave for the other 4 hours.