Employee Ledger Report - File Layout and Data Mapping - Employee Distribution Data Section - Pay Codes (Record Type 1 - Gross Pay)
The names of the Pay Codes are retrieved from the Code field in the Detail Distribution records. This corresponds to the pay code used during payroll processing.
Pay code records are selected from the Detail Distribution table where rec_type = O (Object/Pay code). The system maps this to internal record type 1 for processing.
FLSA overtime pay codes appear in the Detail Distribution table with rec_type = O. The FLSA-generated overtime pay will be listed by pay code with the associated amounts.
For Record Type 1 (Pay Codes/Gross Pay), individual pay code detail lines are not printed on the report. Only the GROSS PAY subtotal line is displayed, which represents the sum of all pay code amounts for each month.
The following table lists the columns, descriptions, and data sources or valid values for the Pay Codes record (Type 1 - Gross Pay) in the Employee Distribution Data section of the Employee Ledger report.
Column | Description | Data source and Valid values |
|---|---|---|
1-14 | Pay code description | Retrieved from the Title field on the Deduction Table page using the pay code. If not found, the pay code itself is displayed. |
15-23 | January amount | Calculated during report generation. Sum of all Amount values from Detail Distribution records where the pay date month is January and rec_type = O. |
24-32 | February amount | Calculated during report generation. Sum of all Amount values from Detail Distribution records where the pay date month is February and rec_type = O. |
33-41 | March amount | Calculated during report generation. Sum of all Amount values from Detail Distribution records where the pay date month is March and rec_type = O. |
42-50 | April amount | Calculated during report generation. Sum of all Amount values from Detail Distribution records where the pay date month is April and rec_type = O. |
51-59 | May amount | Calculated during report generation. Sum of all Amount values from Detail Distribution records where the pay date month is May and rec_type = O. |
60-68 | June amount | Calculated during report generation. Sum of all Amount values from Detail Distribution records where the pay date month is June and rec_type = O. |
69-77 | July amount | Calculated during report generation. Sum of all Amount values from Detail Distribution records where the pay date month is July and rec_type = O. |
78-86 | August amount | Calculated during report generation. Sum of all Amount values from Detail Distribution records where the pay date month is August and rec_type = O. |
87-95 | September amount | Calculated during report generation. Sum of all Amount values from Detail Distribution records where the pay date month is September and rec_type = O. |
96-104 | October amount | Calculated during report generation. Sum of all Amount values from Detail Distribution records where the pay date month is October and rec_type = O. |
105-113 | November amount | Calculated during report generation. Sum of all Amount values from Detail Distribution records where the pay date month is November and rec_type = O. |
114-122 | December amount | Calculated during report generation. Sum of all Amount values from Detail Distribution records where the pay date month is December and rec_type = O. |
123-132 | Annual total | Calculated during report generation. Sum of all monthly amounts for the record type. |
Subtotal Line: GROSS PAY followed by monthly and annual totals