Working with Employment Insurance Hour Integrity

You run the EI Hour Integrity program to find and correct discrepancies between the Unemployment Insurance History (F06176) and the Payroll Transaction History (F0618) tables. This allows you to ensure that no discrepancy exists in insurable hours worked for employment insurance.

When you run the EI Hour Integrity program in verification mode, the system identifies records with discrepancies so that it can resolve those discrepancies when you run the program in update mode. Before you run the program in update mode, you can manually reset the flag for certain records to prevent the program from updating them. This might be necessary if you have records that the system considers to be in error but, in fact, are not.

Working with employment insurance hour integrity includes the following tasks:

• Verifying employment insurance hour integrity

• Updating employment insurance flags

Verifying Employment Insurance Hour Integrity

From EI Integrity (G77311), choose EI F06176 Hour Validation

You run the EI Hour Integrity program (P077020) to locate and correct discrepancies between the Unemployment Insurance History (F06176) and the Payroll Transaction History (F0618) tables. This program ensures that no discrepancies exist in insurable hours worked for employment insurance.

You must run this program in verification mode before you can run it in update mode. Running the program in verification mode sets a flag that the program uses when you run it in update mode.

When you run the EI Hour Integrity program in verification mode, the system compares the number of hours for each employee in the Employment Insurance History and Payroll Transaction History tables. If the totals do not match, the system does one of the following:

• If no corresponding records exist in the Payroll Transaction History table, the system prints an error message on the report (No time card control record).

• If the totals differ, the program uses the pay type, employee number, and cheque control number to locate the corresponding record in the Payroll Month PDBA Summary History table. Data should exist for the record in either the Effect on Gross Pay or Effect on Net Pay field in the Payroll Month PDBA Summary History table. If both fields are blank, the program prints an error message on the report (Hours don't match). It also sets the ST field (Status Payroll 02) to H in the Employment Insurance History table to indicate that the program will correct the problem when you run it in update mode.

The system also produces an exception report. You can use this report to determine the cause of the discrepancy. Before you run the program in update mode, you can manually reset the flag for certain records to prevent the program from updating them.

When you run the program in update mode, the system locates the discrepancies that it identified in verification mode. For these records, the system adds the accumulated hours from the Payroll Transaction History table to the Employment Insurance History table. This resolves the discrepancy between the tables.

The system also prints a report that shows the changes that it made to the Employment Insurance History table.

Processing Options

See EI Hour Integrity Report (P077020)

Data Selection

You can exclude PDBAs that are exempt from employment insurance, such as leave without pay. For the excluded pay types, the system does not include hours in the report calculations.

You can enter a range of cheque dates to specify the reporting year.

Updating Employment Insurance Flags

When you run the EI Hour Integrity program in verification mode, the system sets a flag for each record that has a discrepancy. The flags indicate that the system should correct the discrepancies when you run the program in update mode. Before you run the program in update mode, you can manually reset the flag for certain records to prevent the program from updating them. You do this by changing the value of the Status field from H to blank.

This program resets flags for records in the Unemployment Insurance History table (F06176).

To update employment insurance flags

From EI Integrity (G77311), choose EI Insurance Flag Update

1. On EI Insurance Flag Update, complete the Employee Number field and click Enter.

   

2. Clear the ST (Status Payroll 02) field and click Change.

Field	Explanation
Status - Payroll 02	A code that indicates an error when you run the EI Hour Integrity program in verification mode. The valid value is: H – Hours do not match This program is the only one that allows you to remove the code for any record to bypass the record when you run the EI Hour Integrity program in update mode.