The ASEBP Export Process provides the ability to send Salary update information to the Alberta School Employee Benefit Plan (ASEBP) administrators. There is an automated method that runs each evening or the interactive process you run and submit any changes.
The Automated ASEBP Process has been automated within the atrieve system and can be setup once to allow the system to send salary changes on a nightly basis to ASEBP. A successful transmission of the salary information to ASEBP is recorded on the employee's ABEBP record in atrieve with a date and time stamp. A report is created so all transmitted information can be reviewed and validated. An automated email can also be generated with a link to the report and sent to a designated email address. Contact SRB for assistance with this implementation.
The Interactive ASEBP Process generates a comma separated value extract file of those employees whose salary has changed (only changes) and a separate report of the same employees. This CSV extract file, PAYID_ASEBP_YYYYMMDDHHMM.CSV, is generated at the location defined by the logical SRB$Export: where PAYID is the Payroll ID (e.g. TEAC) where the Export is being run from.
Report All or Selected Employees
Report Employees On Leave/On Leave & Benefits/Both
-
Enter 'N' to exclude On Leave and On Leave with benefit employees.
-
Enter 'L' to include On Leave employees.
-
Enter 'O' to include On Leave With Benefit employees.
Export All Salaries or Selected Employees
-
Enter 'N' to only report those employees where the salary has changed.
-
Enter 'Y' to export all employees even those whose salary has not changed
When Yes Export All Salary Have Been Entered:
Override Effective Date if Salary Has Not Changed
-
Enter 'N' to report the employees existing effective date.
-
Enter Y to override the salary effective date on the employees whose salary has not changed
Enter Salary Effective Date
-
Enter the effective date of the salary change.
Sort by Employee Number or Employee Name
-
Enter E to sort by the Employee Number.
-
Enter N to sort by the Employee Name.
Report Only or Process Employees
-
Enter 'R' to only generate the Export report. No Extract file will be produced, and no employee records will be updated.
-
Enter 'P' to update the employee's ASEBP record and produce the CSV export file.
Override and Include SIN IN Export
-
Enter 'N' when the SIN should not be included in the ASEBP export file.
-
Enter 'Y' to include the SIN in the ASEBP export file.
The export file will contain the following information:
-
Employee payroll number and employee name
-
Employee Group
-
ASEBP ID Number
-
Salary
-
Salary Effective Date
-
SIN – when override was selected
The process includes a report of the employees being exported:
-
Employee payroll number and employee name
-
Employee Group
-
ASEBP ID Number
-
Old Salary
-
New Salary
-
Effective Date