In this lesson you will review how to structure and provide the enrollment.txt file to successfully be pulled from the Michigan Data Hub.
The column order structured below, is the order that the column should be in your Core Data configuration.
Enrollment.txt
Field | Order | Data Hub Endpoint | Data Hub Field | Transformation |
---|---|---|---|---|
Import Student ID | 1 | students | studentUniqueId |
No need to transform. |
State Student ID | 2 | students | studentUniqueId | No need to transform. |
Student Last Name | 3 | students | lastSurname | No need to transform. |
Student First Name | 4 | students | firstName | No need to transform. |
Student Middle Name | 5 | students | middleName | No need to transform. |
Birth Date | 6 | students | birthDate | Find and Replace T00:00:00 with (blank) |
Site ID | 7 | studentSchoolAssociations |
schoolReference { schoolId } |
|
Enrollment Start | 8 | studentSchoolAssociations |
entryDate |
|
Enrollment End | 9 |
studentSchoolAssociations |
exitWithdrawDate |
|
Students Grade Level ID | 10 | studentSchoolAssociations |
entryGradeLevelDescriptor |
|
Academic Year | 11 | studentSchoolAssociations |
schoolYearTypeReference { schoolYear } |
|
Is Primary ADA | 12 | studentSchoolAssociations |
primarySchool |
If this field is not in the record it defaults to True |
Enrollment Category | 13 | Defaults to "Regular Attendance" |
||
Enrollment Exit Code | 14 | studentSchoolAssociations |
exitWithdrawTypeDescriptor |
|
Session Type | 15 | Defaults to "1" |
||
Enrollment Entry Code | 16 | studentSchoolAssociations |
entryTypeDescriptor |
Next Steps
Now that you have configured both available Core Data Specs, the integration for the MI Data Hub should be complete!
Comments
0 comments
Please sign in to leave a comment.