Ontario Teachers Insurance Plan (OTIP) exports
The Ontario Teachers Insurance Plan (OTIP) provides group and individual insurance products to education employees and other union organizations in Ontario. School boards are responsible for providing data to OTIP on a regular basis. This data identifies when a member is eligible to enrol in the plan or if there are eligibility changes.
Sparkrock 365 includes support for the following OTIP exports:
OTIP MPL export: Includes data elements that OTIP uses to determine eligibility for employees under all trusts.
MPL stands for Member, Position, Leave and consists of the following data sets:- Member File: Includes employee demographic information and is the primary file for reporting terminations. There is only one-member record for each employee.
- Position File: Includes position information for each employee. Employees that hold more than one position have multiple position records in the file. Positions that have ended remain in the file for a 16-month school year period where a 16-month school year is defined as July 1st year one to Oct 31st year two. For example, a 16-month school year for 2019/2020 would be July 1, 2019 to Oct. 31, 2020.
- Leave File: Includes information about employees that are on a leave from their regular active duties. Records include both paid and unpaid leaves of absences. If an employee is on leave from multiple positions, there is one leave record for each position. For example, if a member has two position records and is on leave from both, there are two corresponding leave records.
OTIP HRIS export: Includes Human Resource Information System (HRIS) data that OTIP uses to identify when a member is eligible to enrol in the plan or if there are eligibility changes.
To learn more about the Sparkrock 365 OTIP export functionality, in the following table, select the links.
| To | See |
|---|---|
| Learn about how to set up the OTIP MPL export. | Set up the Ontario Teachers Insurance Plan (OTIP) Member, Position, Leave (MPL) export |
| Learn about OTIP MPL export file administration. | Ontario Teachers Insurance Plan (OTIP) Member, Position, Leave (MPL) export file administration |
| Learn about how to set up the OTIP HRIS export. | Set up the Ontario Teachers Insurance Plan (OTIP) Human Resources Information System (HRIS) export |
| Learn about OTIP HRIS export file administration. | Ontario Teachers Insurance Plan (OTIP) Human Resources Information System (HRIS) export file administration |
Feedback
To send feedback about this page, select the following link: