Add the schoolNumber Field as an ID Hub Mapping

RapidIdentity Platform Documentation
Solution
Application
Content Type
Technical Documentation
Utilities & Services
ft:locale
en-US

Configure a schoolNumber field to use PowerSchool SIS school IDs in primary record filters.

If you want to create primary record filters using the school IDs from PowerSchool SIS that are included as the last part of the school_number value from the PowerSchool PowerQuery Studio Provider Application in a format such as 93805e31-e0f7-3a6e-ba31-0e16f3ac26c8-780 as a Record Key in the ID Hub, follow these steps.

  1. Create a schoolNumber Field Definition in the ID Hub's org record
    1. Click Add in the Field Definitions section of the org record
    2. Create the schoolNumber Field Definition
    3. Click Save

      The schoolNumber Field Definition should now be visible in the list of the Field Definitions for the ID Hub's org record.

  2. Navigate to the PowerSchool (PowerQuery) Provider application for configuration
  3. Configure the Record Mapping
    1. Scroll down to the Record Mappings section and click the action menu on org type with the schools to choose Details
    2. Scroll down to the Field Mappings and click Add to create a new schoolNumber field mapping
    3. Create an Expression named schoolNumber with the following value:
      function() {
                                const sourcedId = SRC.school_number[0];
                                const split = sourcedId.split('-');

                                return split[split.length-1]
                                }
    4. Ensure that On Create and On Update are both checked, and click Save
  4. Verify the transformation in Data Explorer after the ID Hub org mapping job runs

    Data Explorer BEFORE: The school id is the last part of the Record Key on the school record, but is not a filterable field.

    Data Explorer AFTER: The school id is now a field called schoolNumber in the school record and can now be used to filter results if needed.