Map data attributes from your SIS to SchoolDay

Attribute (field) mappings define how field names in your data source correspond to SchoolDay attributes (fields). This ensures data from your Student Information System imports into the correct SchoolDay fields.

For example, if your SIS labels student emails as "Primary_Email" but SchoolDay expects "Email Address", attribute mapping links these fields so data flows correctly during import.

You'll complete field mappings during your initial SIS integration setup and anytime you add or restructure data in your organization.

Requirements

• Primary District Admin permissions
• An Import application already configured in SchoolDay

Access attribute mappings

1. In SchoolDay Connect, select your import application.
2. Click the Settings icon.
3. Select the Attributes Mapping tab.

The screen displays entities (Students, Teachers, Classes) with two columns:

1. Field names from your data source
2. Field names in SchoolDay

Create an attribute mapping

1. Under Attributes Mapping, select an entity.
2. Find the SchoolDay field that should receive data.
3. Click New Attribute Mapping.
4. Select the matching data source field.
5. Click Save.
6. Click Run Import to apply changes.

Mapping rules:

• One data source field can map to multiple SchoolDay fields
• One SchoolDay field can only map to one data source field

Note: If a SchoolDay field is unavailable, it's already mapped. Delete the existing mapping to reuse the field.

Delete an attribute mapping

Mappings with an asterisk (*) are required and cannot be deleted.

1. Go to Application Settings > Attributes Mapping.
2. Select an entity tab.
3. Click Delete Attribute Mapping next to the attribute.
4. Click Save.
5. Click Run Import to verify changes.

Verify the configuration

After creating, editing, or deleting mappings:

1. Click Run Import.
2. Go to the relevant record page (student, teacher, etc.).
3. Confirm the mapped attributes display correct data.

Advanced: Map metadata fields

Metadata fields are additional data fields available only with OneRoster format or Native API. See OneRoster File Format for details.

Metadata field names must match exactly as provided in the specification.

Use metadata mappings to:

• Import custom fields from your SIS that don't have standard SchoolDay equivalents
• Store additional data in SchoolDay's Extra Attributes section
• Map specific metadata values to unused SchoolDay attributes

Import all metadata

This mapping imports all metadata from your data source into SchoolDay.

1. Go to Application Settings > Attributes Mapping.
2. Select an entity tab.
3. Click New Attribute Mapping.
4. Select Metadata from both the data source and SchoolDay attribute lists.
5. Click Save.
6. Click Run Import.

After import, all metadata appears in the Extra Attributes section on each record.

Map one metadata field to another

Transfers one specific metadata value to a specific SchoolDay metadata field.

1. Go to Application Settings > Attributes Mapping.
2. Select an entity tab.
3. Click New Attribute Mapping.
4. Select Metadata Extension from both attribute lists.
   
5. Enter the metadata attribute names you want to map.
6. Click Save.
7. Click Run Import.

After import, the mapped value appears in the Extra Attributes section on the record page.

Map metadata to a standard SchoolDay field

Populates a regular SchoolDay field (like Middle Name or Grade Level) with metadata.

1. Go to Application Settings > Attributes Mapping.
2. Select an entity tab.
3. Click New Attribute Mapping.
4. In the data source attribute list, select Metadata Extension and enter the metadata attribute name.
5. In the SchoolDay attribute list, select the unused attribute you want to use.
6. Click Save.
7. Click Run Import.

After import, the metadata value appears in the standard field you selected.

Map a standard SchoolDay field to metadata

Transfers a regular data source attribute into SchoolDay's metadata section.

1. Go to Application Settings > Attributes Mapping.
2. Select an entity tab.
3. Click New Attribute Mapping.
4. In the data source attribute list, select the attribute you want to map.
5. In the SchoolDay attribute list, select Metadata Extension and enter the metadata attribute name.
6. Click Save.
7. Click Run Import.

After import, the value appears in Extra Attributes under the metadata name you specified.

Troubleshooting

• Manage school mappings
• Configure duplicate detection