Importing Race Values from PowerSchool API into Enroll – SchoolMint Enroll

When using an API connection to import student race data from PowerSchool into Enroll, use the transformation below if your PowerSchool race data is stored in different formats for a single student.

PowerSchool: StudentsRace.RaceCD to Enroll: students.race

Scenario: Multiple race codes for a student are permitted with 5 race options:

1 = American Indian or Alaskan Native
2 = Asian
3 = Black or African American
4 = Native Hawaiian or Other Pacific Islander
5 = White

In this scenarios, race data was stored in the SIS inconsistently in both numbers and text formats. When imported into Enroll, reporting is difficult with multiple formats, and the multiple formats are then exported back to the SIS.

Examples:

Student A race codes: 2, 5
Student B race codes: 5, White
Student C race codes: White, Asian
Student D race code: 1, 2

Root Cause:

Form changes from year to year varied how race data was captured in Enroll. When race data was exported out of Enroll back to PowerSchool each year, the new format of race would be added to the existing race code.

Solution:

Ensure that the data coming from PowerSchool into Enroll is consistently formatted upon import using a concatenation with codes matches and indexes. This will ensure consistency upon both import and export.

1) Create a "Code Match Set" for race

For the race field on your mapping, select Match Codes as the type (note: fields must be identified in both the From and To columns)
Enter the value coming from the SIS and the value going into Enroll
Click “+” to enter the next set of values
Click Save Match Set when all values are accounted for in the match set