School Data Sync required attributes for PowerSchool SyncSchool Data Sync required attributes for PowerSchool Sync

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 sync method, you use the REST-based API Endpoints provided byPowerSchool to sync data directly from your SIS to Office 365. When you're creating a sync profile using the PowerSchool sync method, you must have the required attributes listed below, fully populated in the PowerSchool SIS. Any object that does not contain the required attributes will fail to sync and generate an error within the SDS portal. . You can add optional attributes as well.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 sync method, you use the REST-based API Endpoints provided byPowerSchool to sync data directly from your SIS to Office 365. When you're creating a sync profile using the PowerSchool sync method, you must have the required attributes listed below, fully populated in the PowerSchool SIS. Any object that does not contain the required attributes will fail to sync and generate an error within the SDS portal. . You can add optional attributes as well.

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

School attributesSchool attributes

Attributes associated with the School in the PowerSchool SIS.Attributes associated with the School in the PowerSchool SIS.

  • SIS ID- SIS ID of the School. This value must be unique.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 First Name- First name of the School's Principal.

  • Principal Middle Name- Middle 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.Principal Last Name- Last name of the School's Principal.

Section attributesSection attributes

Attributes associated with the Section in the PowerSchool SIS.Attributes associated with the Section in the PowerSchool SIS.

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

  • School SIS ID - 學校的 SIS 識別碼。School SIS ID- SIS ID of the School.

  • Section Number- Number of the Section.Section Number- Number of the Section.

  • Course SIS ID- SIS ID of the Course.Course SIS ID- SIS ID of the Course.

  • Course Name- Name of the Course.Course Name- Name of the Course.

Teacher attributesTeacher attributes

Attributes associated with the Teacher in the PowerSchool SIS.Attributes associated with the Teacher in the PowerSchool SIS.

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

  • School SIS ID - 學校的 SIS 識別碼。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.First Name- Not available for use if either synced identity option is selected in the profile creation.

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

  • Username- Username of the teacher in the PowerSchool SIS. This attribute can be used in the identity matching configuration within the sync profile. This value may also be used if creating new users via SDS.Username- Username of the teacher in the PowerSchool SIS. This attribute can be used in the identity matching configuration within the sync profile. This value may also be used if creating new users via SDS.

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

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

Student attributesStudent attributes

Attributes associated with the Student in the PowerSchool SIS.Attributes associated with the Student in the PowerSchool SIS.

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

  • School SIS ID - 學校的 SIS 識別碼。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.First Name- Not available for use if either synced identity option is selected in the profile creation.

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

  • Username- Username of the student in the PowerSchool SIS. This attribute can be used in the identity matching configuration within the sync profile. This value may also be used if creating new users via SDS.Username- Username of the student in the PowerSchool SIS. This attribute can be used in the identity matching configuration within the sync profile. This value may also be used if creating new users via SDS.

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

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

TeacherRoster attributesTeacherRoster attributes

Attributes used for Teacher to Section mappings.Attributes used for Teacher to Section mappings.

  • Section SIS ID - 區段的 SIS 識別碼。Section SIS ID- SIS ID of the Section.

  • SIS ID - 教師的 SIS 識別碼。SIS ID- SIS ID of the Teacher.

StudentEnrollment attributesStudentEnrollment attributes

Attributes used for Student to Section mappings.Attributes used for Student to Section mappings.

  • Section SIS ID - 區段的 SIS 識別碼。Section SIS ID- SIS ID of the Section.

  • SIS ID - 學生的 SIS 識別碼。SIS ID- SIS ID of the Student.

School Data Sync 的概觀Overview of School Data Sync

如何使用 PowerSchool Sync 部署 School Data SyncHow to deploy School Data Sync by using PowerSchool Sync