Verifying Employment Insurance History Integrity
From EI Integrity (G77311), choose EI Integrity Validation
You run the EI Integrity Validation program to find discrepancies between the Unemployment Insurance History (F06176) and Tax History Summary (F0713) tables. This program ensures that the gross earning and EI contribution amounts are the same in the two tables.
This program summarizes all records for each employee in the Unemployment Insurance History table by tax type CC and compares the results with the amounts in the Tax History Summary table.
If the yearly totals for EI insurable earnings in the Unemployment Insurance History table do not match the gross earnings minus excludables minus in-excess in the Tax History Summary table, the program marks the records. The program then compares the records in the Unemployment Insurance History table with the records in the Tax Ledger table (F0716) by cheque control number to locate specific records that do not match. The program then produces an exception report, the EI Integrity F0716/F06176 Exceptions report.
The EI Integrity Validation program produces a second exception report, the EI Integrity Validation report, if any of the following conditions exist:
The amount of insurable earnings is greater than the maximum EI earnings.
The tax ID in the Unemployment Insurance History table does not match any of the corporate tax IDs that are set up for the company in the Tax Area Constants table (F069016).
The employee number does not exist in the Employee Master table (F060116).
The company number does not exist in the Corporate Tax ID table (F069086).
The maximum EI earnings do not exist for the company.
The employee record does not exist in the Tax Ledger table (F0716).
The amount of insurable earnings or tax does not match the amount in the Tax Ledger table.
The EI Integrity Validation program reads information from the Unemployment Insurance History, Tax History Summary, and Tax Ledger tables. It does not update these tables.
What You Should Know About Processing Options
Processing Option | Description |
---|---|
EI Integrity Year | The year that you enter must match the calendar year that you use in the data selection. If it does not, the program produces a blank report. |
Processing Options
Data Selection for EI Integrity Validation
The data selection must be Check Date EQ (is equal to) *RANGE, where the range is the beginning and ending dates of the reporting year.