Atrieve Payroll

Benefit Information Report

This report lists the employee's User Defined Benefit fields and/or employee Benefit deductions as defined under the User Defined Benefits Definition Profile.

This report includes an option to generate an export file, ######.CSV, where ###### is the job number. The export file is generated where the logical SRB$OPSWRK is defined. All fields within the export file have extra spaces removed from front and back of the fields and all fields are separated by a comma.

Report User Defined Fields, Benefit Deductions or Both

  • Enter 'B' to generate the report including both the user defined fields and the benefit deductions.

  • Enter 'U' to generate a report with only the user defined benefit fields.

  • Enter 'D' to generate a report with only the employee's benefit deductions.

When User Defined fields will be included on the report:

  • Enter to include all User Defined Benefit fields.

Use look-up for valid User Defined Benefit fields to report. Enter the User Defined Benefit fields to report, one at a time.

EMPLOYEE NUMBER

EM


Pay Code

PC

LOCATION CODE

LC


COST CENTER

CS

SALARY GRID

GR


OCCUPATION CODE

OC

PAY CYCLE CODE

CY


EMPLOYEE TYPE

ET

PAY TYPE

PT


SHIFT CODE

SC

  • Enter a 2-character code to define the field to use for employee/function line selection.

  • Enter 'EM' to select employees based on employee number.

When employee selection is by Employee Number:

Report All or Selected Employees

When employee selection is based on any field other than employee number, you are prompted to enter one or more of that code or value. You may enter valid codes or any combination using the wild card '?'. The list of values entered will determine if an employee is selected based on the values from the master function line.

Report Employees Terminated / On Leave / Both

Sort by Employee Number or Name

  • Enter 'E' to generate the report in employee number sequence.

  • Enter 'N' to generate the report in employee name sequence.

Page Break for Each Employee

  • Enter 'N' to generate the report omitting page breaks per employee.

  • Enter 'Y' to generate the report with a page break after each employee.

Include Generation of CSV Export File

  • Enter 'N' to omit the export file.

  • Enter 'Y' to include the generation of the export file.

The report lists the following:

  • Employee number and name

  • User Defined prompt and field value

  • Benefit deduction code, table code and description

  • Employee deduction amount

  • Coverage amount when Group 3 Type 5, 'F' or 'S'

  • Employee status

  • Total number of employees reported

The export file includes the following:

  • Payroll ID code.

  • Employee number and name.

  • The User Defined field prompt and employees’ values (repeated 10 times)

  • The employees benefit deduction code, deduction table code, description, frequency, employee deduction amount and coverage (when applicable) (repeated up to 8 times).