...
| Req ID | Requirement Description |
|---|---|
| G1 | Files must be encoded in ANSI format. |
| G2 | Files must have a “.csv” extension. |
| G3 | Data is delimited by a comma. |
| G4 | Files must contain a header record in the first row of the data field and delimited by a comma. All headers are mandatory, and each file must contain all specified headers even if no data is being reported under that header. The header names are listed in the “Field Name” of the specific file layouts in the sections that follow. |
| G5 | All fields must follow the order as specified in the file layouts in the sections that follow. |
| G6 | Each field must follow the supported data types as indicated in the file layouts. Data formats supported include:
|
| G7 | The following file types must NOT contain multiple lines for the same SIN. Enrolments
|
| G8 | The following file types may contain multiple lines for the same SIN.
For example, if one member has a retro payment that impacts multiple years, the member record will be repeated for each year of retro data. |
| G9 | SIN, Last Name and First Name are mandatory fields in all files. The SIN will be used as the “key identifier” in each file to match reported data to the associated member record that HOOPP has on file. If the SIN, Last Name and/or First Name values are different from what HOOPP has on file, the reported values will not be used to update the members information that HOOPP has on file. SIN, Last Name, Middle Initial, and First Name can be updated as part of the Member Basic Info file only. SIN and name changes reported via the Member Basic Info data process (either through file upload or via manual entry) will update the Member’s information that HOOPP has on file. |
| G10 | You must only report net new data changes for the following in-year data files:
Employee information should not be duplicated file over file. For example, an employee’s termination information must only be provided once in a single file. |
...