Custom Payroll Transfer Time Card report query

Summary:

We have a custom-built Timecards Payroll Transfer and Processing Status Report which provides users with approved timecards and two statuses:

• Transfer Status – Status of transferring data from timecards to payroll.
• Payroll Processing Status – Status of payroll processing for the timecard data.

While the Transfer Status is accurately reflected in the report, the Payroll Processing Status does not align with what is displayed on the form for certain records, specifically those involving absence hours.

The report utilizes the function:

pay_interface_time.get_payroll_process_status(htr.TM_REC_ROW_ID, NULL, NULL)

This function successfully retrieves the payroll processing status for regular working hours but does not return a status for absences. To account for missing status values, the report applies the following logic: