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.RaceCDto 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
2) Switch the race field type to Transformation and build a Concatenation / Split using Indexes following the pattern below:
Transformation:
The pattern to build the transformation will be the same for each index 1 - 5:
Concat
Code Match
Code match Set: select "Code Match - Code Matches - Race"
Field: Split
Source Data: StudentRace.RaceCD
Separator: ,
Index: 1
Value Input: ,
Repeat the pattern for indexes 2 - 5 (screenshots below)
Comments
0 comments
Article is closed for comments.