Time and Labor: TCD Error Report - KTL119

DESCRIPTION:

This report is intended for Time and Labor Interface agencies only. It displays errors from the Time and Labor Interface files (also known as TCDs [Time Collection Devices]). This report produces both .pdf and .dat files. The .dat flat file results in a fixed width file that can be imported into a spreadsheet or database.

When importing the .dat flat file into Excel, choose the following:

Delimited
Semicolon
Text (for lengthy fields, such as Combo Code)

PARAMETERS TO SET:

TCD ID
Pay Period End Date

FIELDS:

(Note: All fields from the Payable Time Table display on the report; just a few are listed below)

Pay Period (Pay Period Begin Date - Pay Period End Date)
TCD ID
Employee Name
Department ID
Employee ID
Employee Record Number
DUR (Date Under Report)
TRC ( Time Reporting Code)
Quantity (Hours/ Amount per DUR)
Task Profile ID
Combo Code
Error Message
Seq (Sequence Number as sent on the Interface)
Template (Time Reporting template (TASK_PRFL_TMPLT_ID) as sent on the Interface)

SORT SEQUENCE:

TCD ID
Empl ID/ Empl Rcd
DUR (Date Under Report)
TRC (Time Reporting Code)

WHERE FOUND:

Time and Labor> Reports>TCD Errors