Employee Ledger Report - File Layout and Data Mapping - Employee Distribution Data Section - Deductions (Record Type 2)
The names of the Deduction Codes are retrieved from the Code field in the Detail Distribution records. This corresponds to the deduction code used during payroll processing.
Deduction records are selected from the Detail Distribution table where rec_type = D (Deduction). The system maps this to internal record type 2 for processing.
For Record Type 2 (Deductions), individual deduction detail lines ARE printed on the report, followed by a TOT DED subtotal line and a NET PAY calculated line.
The following table lists the columns, descriptions, and data sources or valid values for the Deductions record (Type 2) in the Employee Distribution Data section of the Employee Ledger report.
Column | Description | Data source and Valid values |
|---|---|---|
1-14 | Deduction code description | Retrieved from the Title field on the Deduction Table page using the deduction code. If not found, the deduction 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, rec_type = D, and matching deduction code. |
24-32 | February amount | Calculated during report generation. Sum of all Amount values from Detail Distribution records where the pay date month is February, rec_type = D, and matching deduction code. |
33-41 | March amount | Calculated during report generation. Sum of all Amount values from Detail Distribution records where the pay date month is March, rec_type = D, and matching deduction code. |
42-50 | April amount | Calculated during report generation. Sum of all Amount values from Detail Distribution records where the pay date month is April, rec_type = D, and matching deduction code. |
51-59 | May amount | Calculated during report generation. Sum of all Amount values from Detail Distribution records where the pay date month is May, rec_type = D, and matching deduction code. |
60-68 | June amount | Calculated during report generation. Sum of all Amount values from Detail Distribution records where the pay date month is June, rec_type = D, and matching deduction code. |
69-77 | July amount | Calculated during report generation. Sum of all Amount values from Detail Distribution records where the pay date month is July, rec_type = D, and matching deduction code. |
78-86 | August amount | Calculated during report generation. Sum of all Amount values from Detail Distribution records where the pay date month is August, rec_type = D, and matching deduction code. |
87-95 | September amount | Calculated during report generation. Sum of all Amount values from Detail Distribution records where the pay date month is September, rec_type = D, and matching deduction code. |
96-104 | October amount | Calculated during report generation. Sum of all Amount values from Detail Distribution records where the pay date month is October, rec_type = D, and matching deduction code. |
105-113 | November amount | Calculated during report generation. Sum of all Amount values from Detail Distribution records where the pay date month is November, rec_type = D, and matching deduction code. |
114-122 | December amount | Calculated during report generation. Sum of all Amount values from Detail Distribution records where the pay date month is December, rec_type = D, and matching deduction code. |
123-132 | Annual total | Calculated during report generation. Sum of all monthly amounts for the deduction code. |
Subtotal Line: " TOT DED" followed by monthly and annual totals
Net Pay Line: " NET PAY" followed by monthly net pay (Gross Pay - Deductions) and annual net total