MI Data hub Transformations for Enrollment.txt

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

Now that you have configured both available Core Data Specs, the integration for the MI Data Hub should be complete!