Employee Ledger Report - File Layout and Data Mapping - Employee Distribution Data Section - Fringe Benefits (Record Type 3)
The names of the Fringe Benefit Codes are retrieved from the Code field in the Detail Distribution records. This corresponds to the fringe benefit code used during payroll processing.
Fringe benefit records are selected from the Detail Distribution table where rec_type = F (Fringe). The system maps this to internal record type 3 for processing.
For Record Type 3 (Fringe Benefits), individual fringe benefit detail lines are printed on the report, followed by a TOT FRG subtotal line.
The following table lists the columns, descriptions, and data sources or valid values for the Fringe Benefits record (Type 3) in the Employee Distribution Data section of the Employee Ledger report.
Column | Description | Data source and Valid values |
|---|---|---|
1-14 | Fringe code description | Retrieved from the Title field on the Deduction Table page using the fringe code. If not found in the Deduction Table, the fringe 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 = F, and matching fringe 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 = F, and matching fringe 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 = F, and matching fringe 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 = F, and matching fringe 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 = F, and matching fringe 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 = F, and matching fringe 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 = F, and matching fringe 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 = F, and matching fringe 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 = F, and matching fringe 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 = F, and matching fringe 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 = F, and matching fringe 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 = F, and matching fringe code. |
123-132 | Annual total | Calculated during report generation. Sum of all monthly amounts for the fringe code. |
Subtotal Line: TOT FRG followed by monthly and annual totals.