School Data Sync required attributes for PowerSchool Sync

School Data Sync Required Attributes for PowerSchool Sync


Applies To: Office 365 Admin

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.

School Data Sync Deployment Guidance

  1. Overview of School Data Sync and Classroom
  2. CSV Files for School Data Sync
  3. School Data Sync required attributes for PowerSchool Sync
  4. How to deploy School Data Sync by using CSV files
  5. How to deploy School Data Sync by using PowerSchool Sync
  6. How to deploy School Data Sync using Clever Sync
  7. School Data Sync errors and troubleshooting
  8. School Data Sync - One Roster
  9. School Data Sync Toolkit
  10. My Power School Connection Fails
  11. What SISes and MISes does School Data Sync support?
  12. What is School Data Sync?
  13. What is the rostering schema?
  14. How do I deploy School Data Sync?
  15. What apps work with School Data sync?
  16. Where is School Data Sync available?
  17. How does School Data Sync protect student information?
  18. Why doesn't my Customer Preview promo code link work?
  19. I received a 403 error when uploading CSV file using the Sync tool. How do I fix this?
  20. I received error 404 when running the School Data Sync Toolkit cmds. How do I fix this?
  21. Can I store and/or upload my CSV files if they are in a ZIP file format?
  22. Are the header names within the CSV files case sensitive?
  23. What are the requirements for accessing the SDS portal, and managing Sync?
  24. What happens with sync when my data changes in my SIS, or within my CSV files?
  25. Adding a Secondary Teacher
  26. Is there a character limitation for the SIS ID in the Section CSV file?
  27. Do I need to create more than 1 sync profile if my teachers and students are associated with different domains?
  28. Can I use both alpha and numeric characters for the School SIS ID?
  29. Why are Teachers or Students missing in the Organization tab?
  30. What attributes are synced with SDS?
  31. How can we export data from the SIS to Microsoft’s required CSV format?
  32. Can the SIS ID field for Sections contain spaces?
  33. What is the proper format for the Term StartDate and Term EndDate?
  34. Can I include optional attributes for sync if only some objects have a value populated for that attribute?
  35. Can I include empty columns in my CSV files?
  36. Do I need to remove the FirstName, LastName, and Password column if I’m not creating users through SDS?
  37. Does Microsoft provide extractor tools for my SIS data?
  38. Can a teacher sync if they are assigned to multiple schools?
  39. Can we export the sync issues/errors?
  40. Can we hide Sections from the GAL? If so, how?
  41. Will the standard welcome email be generated when users are synced/added to each sections/groups through SDS?
  42. If a class is set to inactive status manually through Classroom, will SDS change that status on the next sync if the CSV or SIS is different?
  43. Will SDS automatically sync student changes or do we have to restart sync on a regular basis?
  44. If we remove a user or section from Classroom will they reappear when we sync again?
  45. Why is there a character limitation on email addresses in SDS?
  46. How to sync objects with a sis id or attribute value less than 3 characters, or are less than 3 characters and start with a 0.
  47. Object limitations when synchronizing with SDS
  48. Migrate from Classroom Preview to Teams

Feedback and Knowledge Base