Master File Audit Report

The Master File Audit Report lists all the changes that have been made to the employee's records. The audit trail allows you to track when and who made changes to various employees.  When Archiving of payroll reports is active, the Master File Audit Report will be automatically archived when the Payroll Update is run. The archived report will cover the time period since the end of the last pay period Payroll Update.

Enter the Starting Date Range

• Enter to report starting at the earliest entry in the audit trail.

Enter the Ending Date Range

• Enter the ending date for a range of dates to report to report up to the most recent entry in the audit trail.

Select Employees

• Enter a 2-character code to indicate how employee selection will be processed. Only employees that meet the selection criteria will be included on the report. Employee selection criteria is based only on the employee's master or first function line, except for the employee number.

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

• Enter 'CY' to select employees based on cycle codes.

• Enter 'PT' to select employees based on pay type.

• Enter 'PC' to select employees based on pay code.

• Enter 'ET' to select employees based on employee type.

• Enter 'OC' to select employees based on occupation code.

• Enter 'GR' to select employees based on salary grid.

When employee selection by employee number (EM) is chosen:

Report All or Selected Employees

When employee selection by cycle code (CY) is chosen:

Enter Cycle Codes for Employee Selection

• Enter a valid cycle code which will be used for selection of employees. Employee selection based on cycle code is determined by the master or first function line only. You are re-prompted for up to 25 different cycle codes.

• Entering without first entering at least one cycle code for selection will cancel this process and return you to the menu.

When employee selection by pay types (PT) is chosen:

Enter Pay Types for Employee Selection

• Enter a valid pay type to use for employee selection. Employee selection based on pay type is determined by the master or first function line only. You are re-prompted for multiple pay types up to the maximum number of valid pay types.

• Entering without first entering at least one valid pay type will cancel this process and return you to the menu.

When employee selection by pay codes (PC) was chosen:

Enter Pay Codes for Employee Selection

• Enter a valid pay code to be used for selection of an employee. Employee selection based on pay code is determined by the master or first function line only. You are re-prompted for up to 25 different pay codes.

• Entering without first entering at least one valid pay code, will cancel this process and return you to the menu.

When employee selection by employee types (ET) was chosen:

Enter Employee Types for Employee Selection

• Enter a valid employee type to be used for selection of employees. Employee selection based on employee type is determined by the master or first function line only. You are re-prompted for up to 25 valid employee types.

• Entering without first entering at least one valid employee type will cancel this process and return you to the menu.

When employee selection by occupation codes (OC) is chosen:

Enter Occupation Codes for Employee Selection

• Enter a valid occupation code to be used for selection of employees. Employee selection based on occupation code is determined by the master or first function line only. You are re-prompted for up to 15 different occupation codes.

• Entering without first entering at least one valid occupation code will cancel this process and return you to the menu.

When employee selection by salary grid (GR) is chosen:

Enter Salary Grids for Employee Selection

• Enter a valid salary grid to be used for selection of employees. Employee selection based on salary grid is determined by the master or first function line only. You are re-prompted for up to 11 different salary grids.

• Entering without first entering at least one valid salary grid will cancel this process and return you to the menu.

Report Selective or All Audit Categories

• Enter 'A' to produce the audit report including all audit categories.

• Enter 'S' to select which audit categories should be reported.

When report selective audit categories is chosen:

Enter audit category to be reported

Use look-up for valid audit categories. Enter one or more categories to be reported.

• Enter 'M' to report on master audit fields.

• Enter 'A' to report on email address audit fields.

• Enter 'F to report on function line audit fields.

• Enter 'D' to report on deduction code audit fields.

• Enter 'E' to report on earning codes audit fields.

• Enter 'O' to report on memo audit fields.

• Enter 'B' to report on storage bank audit fields.

Sort by Date/Employee #

• Enter 'D' to produce the audit report in date sequence then employee number within each date.

• Enter 'E' to produce the audit report in employee number sequence and then date order within each employee.

This report lists the following:

Employee's number and name

Field affected, date and time of audit entry

The action that generated the audit entry

'ADD'               - employee was added to the payroll

'CHA'               - employee was changed through Employee Record Changes

'DEL'               - employee was deleted from the payroll

'MOV'              - employee record movement or function line move

'INS'                - function line inserted

'KIL'                 - function line or deduction code deleted or removed

CCCC              - global program identifier

§          The Username (or login identification) of the person who did the entry.

§          Value of the field before and after Summary of all name or pay rate changes

§          Message 'End of Master File Audit Report' to ensure the report completed

Global program identifier legend: