...
Field Name | Description | Mandatory Field | Max Field Length | Data Type | Example |
---|---|---|---|---|---|
SIN | Social Insurance Number No hyphens or spaces | Yes | 9 | Integer | 123456789 |
Title | Title of employee | No | 4 | Code | Mr. |
LastName | Last name of employee | Yes | 40 | Character | Smith |
MiddleInitial | Middle initial of employee | No | 2 | Character | AC |
FirstName | First name of employee | Yes | 40 | Character | John |
DateOfBirth | Birth date of employee | Yes | 8 | Date | 10302015 |
Gender | Gender of employee | Yes | 1 | Code | M |
LanguagePreference | Preferred language of the employee | Yes | 1 | Code | F |
HireDate | Date employee was hired at specific employer | Yes | 8 | Date | 10302015 |
EnrolmentDate | Date employee was enrolled in the plan | Yes | 8 | Date | 10302015 |
EmploymentType | Code that indicates employee’s type of employment | Yes | 2 | Code | PT |
EmploymentType EffectiveDate | Effective date of the employment type | Yes | 8 | Date | 10302015 |
AnnualizedEarnings | Annualized earnings associated to the year of enrollment | Yes | 8 | Integer | 52000 |
UnionDesignation | Code identifying member's union designation at that specific employer | Yes | 7 | Code | OPSEU |
TelephoneNumber | Employee’s primary contact number | Yes | 15 | Character | 4165555555 |
EmailAddress | Email address of employee | NoYes | 80 | Character | johndoe@email.com |
AddressLine1 | First line of the employee’s address | Yes | 40 | Character | 123 Street |
AddressLine2 | Second line of the employee’s address | No | 40 | Character | Apt. #805 |
AddressLine3 | Third line of the employee’s address | No | 40 | Character | PO BOX 456 |
City | City of the employee’s address | Yes | 40 | Character | Toronto |
ProvinceState | Province of the employee’s address | Yes | 2 | Code | ON |
PostalCodeZipCode | Postal code/Zip code of the employee’s address | Yes | 12 | Character | M5C 3B2 |
Country | Country of the employee’s address | Yes | 2 | Code | CA |
...