Data Handling for School Data Sync (Classic) Sync Profiles as a source
Insights & Analytics scenarios
When the data source is SDS (Classic) Sync Profiles the only scenarios supported for using the data are Sync with Insights for Education Leaders or Education Data Lake Export offerings.
Academic year
We recommend the sync end date is set between SDS (Classic) and SDS inbound flow, when SDS (Classic) is the data source, before providing data for the next academic year.
If you want to update SDS (Classic) for a new academic year while the current year is still active, then you shouldn't edit your Inbound data flow until ready. If you're getting ‘Ready for a new academic year’ see Academic year transition
For more information on academic year, see Academic year handling
Matching and Validation Rules by Data Type
This table shows the matching and validation rules by data type and how the values are stored.
Data type | Matching rule | Validation rule | Value stored |
---|---|---|---|
Unique ID * | Case sensitive | As received | |
ENUM ** | Case Insensitive | Match to lower case | As camelCase |
String * | Case sensitive | As received | |
To lower case | RFC 5532 (3.4.1) | To lower case | |
Date or DateTime | ISO8601 | ISO8601 | ISO8601 |
Phone | E.164 | E.164 | As received |
Phone | E.164 | E.164 | As received |
Boolean | Case insensitive | Match to ‘true’ or ‘false’ | To lower case |
*States that the record is unique across all records. Globally unique identifier, though it may or may not take the form of a universal unique identifier (UUID).
** Leading zeros ‘0’ missing on incoming value for Grade Level ENUM, for example ‘1’, will match defined List of Value (ENUM) ‘01’ and will be stored as ‘01’.
For more information on the Default List of Values supported, see default list of values.
For more information on validation rules, see Validation Rules and Descriptions.
Field to data types for all non-V2/2.1 CSV formats
This table shows how the date found in the various formats are treated when processing SDS (Classic) Sync Profile data for use with Insights & Analytics scenarios regarding data type association.
By Format File / Filed to Data Type
SDS v1 CSV * | SDS UK CSV | Clever | To data type |
---|---|---|---|
school.csv / SIS ID | school.csv / DfE Number | schools.csv / School_id | Unique ID |
student.csv / SIS ID | student.csv / ID | student.csv / Student_Id | Unique ID |
student.csv / School SIS ID | student.csv / School DfE Number | student.csv / School_id | Unique ID |
student.csv / Grade | student.csv / Grade | student.csv / Grade | Enum |
student.csv / Secondary Email | student.csv / Secondary Email | student.csv / Secondary Email | |
student.csv / Birthdate | student.csv / Birthdate | student.csv / DOB | Date |
teacher.csv / SIS ID | teacher.csv / ID | teachers.csv / Teacher_id | Unique ID |
teacher.csv / School SIS ID | teacher.csv / School DfE Number | teachers.csv / School_id | Unique ID |
teacher.csv / Grade | teacher.csv / Grade | N/A | Enum |
teacher.csv / Secondary Email | teacher.csv / Secondary Email | teachers.csv / Secondary Email | |
section.csv / SIS ID | section.csv / ID | section.csv / Section_id | Unique ID |
section.csv / School SIS ID | section.csv / School DfE Number | section.csv / School_id | Unique ID |
section.csv / Course SIS ID | section.csv / Course SIS ID | section.csv / Course_number | Unique ID |
section.csv / Course Subject | section.csv / Course Subject | section.csv / Subject | Enum |
studentenrollment.csv / Section SIS ID | studentenrollment.csv / Section ID | enrollments.csv / Section_id | Unique ID |
studentenrollment.csv / SIS ID | studentenrollment.csv / ID | enrollments.csv / Student_id | Unique ID |
teacherroster.csv / Section SIS ID | teacherroster.csv / Section ID | section.csv / Section_id | Unique ID |
teacherroster.csv / SIS ID | teacherroster.csv / ID | section.csv / Teacher_Id (2,3,4) | Unique ID |
*Data from OneRoster CSV, PowerSchool API, OneRoster API are converted to SDS v1 CSV format before provisioning processing. The converted format is what is sent for processing SDS (Classic) Sync Profile data for use with Insights & Analytics scenarios.
**If not listed here, then it's treated as a String.
Data that is not synchronized from SDS (Classic) sync profiles
By Format File / Field
SDS v1 CSV | SDS UK CSV | Clever |
---|---|---|
school.csv / School Number | school.csv / School Number | schools.csv / School_Number |
school.csv / Grade Low | school.csv / Grade Low | schools.csv / Low_grade |
school.csv / Grade High | school.csv / Grade High | schools.csv / High_grade |
school.csv / State ID | school.csv / State ID | schools.csv / State_id |
school.csv / Principal SIS ID | school.csv / Principal SIS ID | schools.csv / Principal |
school.csv / Principal Name | school.csv / Principal Name | schools.csv / Principal_email |
school.csv / Principal Secondary Email | school.csv / Principal Secondary Email | schools.csv / School_address |
school.csv / Address | school.csv / Address | schools.csv / School_city |
school.csv / City | school.csv / City | schools.csv / School_state |
school.csv / State | school.csv / State | schools.csv / School_zip |
school.csv / Zip | school.csv / Zip | schools.csv / School_phone |
school.csv / Country | school.csv / Country | student.csv / State_id |
school.csv / Phone | school.csv / Phone | student.csv / Status |
school.csv / Zone | school.csv / Zone | student.csv / Password |
student.csv / Status | student.csv / Status | teachers.csv / Status |
student.csv / Password | student.csv / Password | teachers.csv / Password |
student.csv / Graduation Year | student.csv / Graduation Year | teachers.csv / Title |
student.csv / State ID | student.csv / State ID | section.csv / Term_name ** |
teacher.csv / Status | teacher.csv / Status | section.csv / Term_start ** |
teacher.csv / Password | teacher.csv / Password | section.csv / Term_end ** |
teacher.csv / State ID | teacher.csv / State ID | section.csv / Status |
teacher.csv / Qualification | teacher.csv / Qualification | section.csv / Periods |
section.csv / Term SIS ID ** | section.csv / Term SIS ID ** | section.csv / School_id |
section.csv / Term Name ** | section.csv / Term Name ** | |
section.csv / Term Start Date ** | section.csv / Term Start Date ** | |
section.csv / Term End Date ** | section.csv / Term End Date ** | |
section.csv / Course Description | section.csv / Course Description | |
section.csv / Status | section.csv / Status | |
section.csv / Periods | section.csv / Periods |
*Data from OneRoster CSV, PowerSchool API, OneRoster API are converted to SDS v1 CSV format before provisioning processing. The converted format is what's sent to SDS if enabled.
**Data from section | Term fields are dropped due to inconsistencies in implementations found across customers use.