The PEBT Payroll Interface Summary Report generates a report detailing the values from the PEBT Payroll interface file, BAMPYRLxxx.TXT , where xxx is are an internal number generated by Morneau. The import file can be stored at the location defined on the Location Of PEBT Import Files of the PEBT Profile or by default the system will look at the location defined by the logical SRB$Export.
The PEBT values printed on this report are as of the PEBT Payroll Interface file, not the employee's Payroll settings.
Enter District Number for File Name
-
Enter the two-digit district number for the import file name to be accessed. By default, the district number as defined under the Human Resources Master Profile will be displayed.
Enter Name of PEBT Payroll File
-
Enter the full PEBT Payroll Interface file name. Automatically, all PEBT Payroll Interface files for the defined district number will be displayed, as shown below. You may scroll up and down to select the correct file. Use look-up to access the PEBT Payroll Interface file list.
Enter Payroll Location ID
-
Enter the payroll location IDs, one at a time, that relate to this PEBT Payroll Interface file. Selected payroll IDs must have the PEBT Profile defined and active.
Report Summary Totals Only
-
Enter 'N' to report the employee details.
-
Enter 'Y' to generate a report that only includes the summarized deduction totals per Benefit Type code.
The report lists the following:
-
The report header includes the PEBT Payroll Interface file used.
-
Payroll Id code
-
Employee number and name
-
B.A.G., Benefit Administration Group
-
Employee Group Code
-
Benefit Type code
-
Employee deduction amount
-
Employer deduction amount
-
Taxable benefit portion
-
Deduction start date
-
Deduction end date, if applicable.
-
'R' – retro marker for onetime adjustments.
-
Total number of entries reported and report totals
-
Total errors such as unknown employees, invalid numeric. Errors are included in the processing log.
-
File Trailer values, the totals as defined by the import file trailer record.
The report includes a Benefit Type Summary:
-
Payroll Id and Benefit Type code and description.
-
Total employee deduction amount per Benefit Type code.
-
Total employer deduction amount per Benefit Type code.
-
Total taxable benefit amount per Benefit Type code.
-
Total Retro adjustment values per Benefit Type code.