The OMERS AVC Extract Process module is used to generate the OMERS AVC Extract file and report. This process prompts for the pay period range and AVC deduction codes to be reported as well as pulls the corresponding AVC Effective From Date & AVC Effective To Date from the memo field on the employee’s payroll deduction screen.
Deduction memos containing the text ‘AVC Start DD-MMM-YYYY’ or ‘AVC End DD-MMM-YYYY’ will be extracted for reporting. For example, ‘AVC Start 01-Jan-2020’ will denote the AVC Effective From Date of 01-JAN-2020 and ‘AVC End 03-Mar-2020’ will denote the AVC Effective To Date of 03-MAR-2020.
This option includes an excel report option for reporting the AVC Current contribution to OMERS along with the Employee details.
The excel csv file contains the following columns:
Employee last name & first name
Membership Number
SIN
Employee Number
Effective from date
Effective to date
Current contribution
This process includes the option to maintain multiple sets of stored prompts.
Name the prompt sets by defining a title up to 10 characters, with a 30-character description.
On the first prompt click the Report Defaults icon to select an existing set of prompt values. You can delete prompt sets or change the description from the Report Default icon.
AVC Reporting Starting Pay Period
Enter the starting pay period in a range of pay periods to be reported.
AVC Reporting Ending Pay Period
Enter the ending pay period in a range of pay periods to be reported.
AVC Deduction Codes To Report
Enter deduction codes to be included on the report.
Report All Or Selected Employees
Sort By Employee Name, Employee Number or SIN
Enter 'N' to produce the report in employee name sequence.
Enter 'E' to produce the report in employee number sequence.
Enter ‘S’ to produce the report in employee SIN sequence.
The report lists the following:
Employee number
Employee last name & first name
SIN
Effective from date
Effective to date
Current contribution
Total number of employees & grand total of current contribution