Payroll Master Report

This report produces a listing of some of the employee's static information as well as lists all an employee's function line values. Employee selection based on the main function line elements allows you to report function lines for employees within selective groups. Employee selection by function line item will determine when an employee is selected for printing although the report will always display all function lines for an employee, once selected.

Report by Employee No or Name

• Enter 'N' to sort the report by employee name.

• Enter 'E' to sort the report by employee number.

Select Active / Terminated /On Leave/ On Leave with Benefits / Full Employees

The employee selection by employee status allows you to select one or more employee status's to be included.

• Enter 'A' to select Active employees.

• Enter 'T' to select Terminated employees.

• Enter 'O' to select On Leave employees.

• Enter 'B' to select On Leave with Benefits employees.

• Enter 'F' to select all employees.

Print Salary Totals

• Enter 'Y' to include salary and FTE employee totals.

• Enter 'N' to omit salary and FTE employee totals.

Summary or Full GL

• Enter 'S' to display the default GL costing from the function lines.

• Enter 'F' to display the GL's as related to costing. If there is not a GL on the costing distribution, then it will print the GL from the cost center, when applicable. Distributions details will also be listed, when applicable.

Select Employees by Code

Enter a 2-character code to define the field to use for employee 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's function line will be matched. Select clear icon to clear the selected codes.

When employee selection was not by em or lc the following prompt appears:

Select by All Function Lines or Master Only

• Enter A to select employees based on all function lines. Once any function line is a match, all the selected employees function lines will be printed.

• Enter M to select employees based on the master function line only.

Include Generation of CSV Export File

• Enter 'N' to omit the export file.

• Enter 'Y' to include the generation of the export file. The fields included on the export file are detailed below.

The report lists the following:

• Employee name and number

• Phone number, SIN/SSN, Birth date, Hire date, Seniority date, Termination date, Pay disposition, Sex, Marital status

• Federal/Provincial/State/Other exemption code

• Cycle code, Pay type, Pay code, Pay rate --for each function

• Base hours, Costing, Occupation code --for each function

• Employee type, Shift code, Salary grid --for each function

• Start/End dates, GL code                     --for each function

• Percentage Employed --for each function if applicable

• Total employees reported

The export file named ######.CSV where ###### is the job number, is created at the location pointed to be the logical SRB$OPSWRK (the WORK directory). The export file is a comma separated file with one record per function line per employee. The export file containing the following fields:

NOTE: Percentage employed, shown as a whole percentage, will only be included on the report if entry in user specific parameters for percentage employed contains a 'Y' (See Percentage Employed field in Users Specific Parameters Profile).