School Data Sync Required Attributes for PowerSchool Sync

Note: This topic is pre-release documentation and is subject to change in future releases.

Instead of using CSV (comma separated value) files to synchronize School Information System (SIS) data with Office 365, you can use School Data Sync to connect directly to your PowerSchool SIS. With this tool, you use the REST-based API Endpoints that PowerSchool provides to extract and import data from your SIS into Office 3655, in a single inline Sync process. PowerSchool Sync extracts the data directly from your PowerSchool SIS and imports the attributes into the School Data Sync profile.

When you're creating the profile, you must have the required attributes (listed below) populated in the PowerSchool SIS, so the Azure AD objects can be correctly provisioned by School Data Sync. You can add optional attributes as well, if you like.

This topic lists the required attributes. Learn more about how to deploy School Data Sync by using PowerSchool Sync.

School attributes

Attributes associated with the School in the PowerSchool SIS.

  • SIS ID   – SIS ID of the School. This value must be unique.

  • Name   – Name of the School.

  • Principal First Name   – First name of the School’s Principal.

  • Principal Middle Name   – Middle name of the School’s Principal.

  • Principal Last Name   – Last name of the School’s Principal.

Section attributes

Attributes associated with the Section in the PowerSchool SIS.

  • SIS ID   – SIS ID of the Section. This value must be unique.

  • School SIS ID   – SIS ID of the School.

  • Section Number   – Number of the Section.

  • Course SIS ID   – SIS ID of the Course.

  • Course Name   – Name of the Course.

Teacher attributes

Attributes associated with the Teacher in the PowerSchool SIS.

  • SIS ID   – SIS ID of the Teacher. This value must be unique.

  • School SIS ID   – SIS ID of the School.

  • First Name   – Not available for use if either synced identity option is selected in the profile creation.

  • Username   – Should match the Alias (UPN prefix) attribute in Azure AD for the user being synced. See How to deploy School Data Sync by using CSV files for more detail on the appropriate value to use. This attribute will be required if you selected “Existing users synced with alias (no domain assigned)” option in the sync profile. Since this value is populated with the Alias, the alias + domain selection in the sync profile must match the corresponding Azure AD UserPrincipalName, and the UPN must be unique.

  • Secondary Email Address    – Should match the UserPrincipalName in Azure AD for the user being synced. See How to deploy School Data Sync by using CSV files for more detail on the appropriate value to use. This attribute will be required if you selected “Existing users synced with email data” option in the sync profile.

  • Password   – Not Available for use if either synced identity option is selected in the profile creation.

  • Status   – Status of the Teacher. Active or Inactive.

Student attributes

Attributes associated with the Student in the PowerSchool SIS.

  • SIS ID   – SIS ID of the Student. This value must be unique.

  • School SIS ID   – SIS ID of the School.

  • First Name   – Not available for use if either synced identity option is selected in the profile creation.

  • Username   – Should match the Alias (UPN prefix) attribute in Azure AD for the user being synced. See How to deploy School Data Sync by using CSV files for more detail on the appropriate value to use. This attribute will be required if you selected “Existing users synced with alias (no domain assigned)” option in the sync profile. Since this value is populated with the Alias, the alias + domain selection in the sync profile must match the corresponding Azure AD UserPrincipalName, and the UPN must be unique.

  • Secondary Email Address    – Should match the UserPrincipalName in Azure AD for the user being synced. See How to deploy School Data Sync by using CSV files for more detail on the appropriate value to use. This attribute will be required if you selected “Existing users synced with email data” option in the sync profile.

  • Password   – Not Available for use if either synced identity option is selected in the profile creation.

  • Status   – Status of the Student. Active or Inactive.

TeacherRoster attributes

Attributes used for Teacher to Section mappings.

  • Section SIS ID   – SIS ID of the Section.

  • SIS ID   – SIS ID of the Teacher.

StudentEnrollment attributes

Attributes used for Student to Section mappings.

  • Section SIS ID   – SIS ID of the Section.

  • SIS ID   – SIS ID of the Student.

See Also

Overview of School Data Sync and Classroom

How to deploy School Data Sync by using PowerSchool Sync

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×