SDS (Classic) V2.1 CSV File Format
Core SDS capabilities and Microsoft 365 features by ingestion method
You can use CSV (comma-separated value) files in the SDS V2.1 format to sync your School Information System (SIS) with Office 365. Using the SDS V2.1 CSV file format to ingest the data categories enables you to light up core SDS capabilities for provisioning. It also helps you enhance experiences for the Microsoft 365 products and features listed.
Note
Current customers of CSV V2 format may continue to use until May, 2022. We recommend using the CSV V2.1 format with its additional capabilities.
SDS V2.1 files must be appropriately formatted. Upload all five files, named exactly as detailed. Files and column headers are case-sensitive. CSV files must be in UTF-8 format. To review and download sample set of SDS V2.1 CSV files, see the SDS GitHub Repository.
Each CSV file must contain all required fields highlighted in green. The fields not highlighted are optional. While the content of certain attributes may be optional, the column headers are required. The attributes with defined enumerated values as marked in the Types column have a specific set of values they support. The supported set of enumerated values for each attribute are in the next section.
*To filter on 'school' only
If creating users:
The username field requires the domain in order to be accepted by SDS. For example, cbean@domain.com.
FamilyName, givenName, and email are required for users that have guardian roles in relationships.csv. Users that are staff, but also contacts, it's recommended that they have two users records listed, with the contacts user record associated with their private email address.
Expect phone and sms to be in E.164. SDS provisioning will not error phone or sms if it isn't aligned with E.164. Validation strips out () -, spaces, periods (.), and preserve + if it's present at the front of the value provided.
*Syncs only one value with SDS Provisioning if multiple values are found on the record.
Enumerated Values Supported
In the SDS V2.1 format, there are attributes defined as enumerated values, which means you can only provide a selected set of values within the CSV files. Anything other than values specified will result in an error during sync processing. The section defines the enumerated values supported in the SDS V2.1 Format.
The users.csv contains the “role” attribute and supports the enum values.
User Org Roles | ||
---|---|---|
Student | TeacherAssistant | Principal |
Proctor | Staff | SpecialServices |
Teacher | Professor | Coach |
ItAdmin | Researcher | assistant |
OfficeStaff | Lecturer | Chair |
Nurse | Affiliate | Adjunct |
OccupationalTherapist | Alumni | Substitute |
Instructor | Advisor | Paraprofessional |
PhysicalTherapist | Faculty | Administrator |
SpeechTherapist | VisionTherapist | Other |
The orgs.csv contains the “type” attribute and supports the enum values.
Org Types | ||
---|---|---|
School | MinistryOfEducation | LocalAuthority |
Department | University | Region |
District | College | Division |
Local | Campus | Province |
State | AdultEducation | ResearchCenter |
National | Municipality | Program |
DepartmentOfEducation | AcademicTrust |
The demographics.csv contains the “birth state” attribute and supports the enum values.
State | ||
---|---|---|
AK | LA | OR |
AL | MA | PA |
AR | MD | PR |
AS | ME | PW |
AZ | MH | RI |
CA | MI | SC |
CO | MN | SD |
CT | MO | TN |
DC | MP | TX |
DE | MS | UT |
FL | MT | VA |
FM | NC | VI |
GA | ND | VT |
GU | NE | WA |
HI | NH | WI |
IA | NJ | WV |
ID | NM | WY |
IL | NV | AA |
IN | NY | AE |
KS | OH | AP |
KY | OK |
The academicSessions.csv contains the academic session “type” attribute and supports the enum values.
Academic Session Types | ||
---|---|---|
SchoolYear | Semester | Term |
The demographics.csv contains the “sex” attribute and supports the enum values.
Sex | ||
---|---|---|
Male | Female | NotSelected |
The academicSessions.csv contains the “school year” attribute and supports the enum values.
School Year | ||
---|---|---|
2021 | 2025 | 2029 |
2022 | 2026 | 2030 |
2023 | 2027 | 2031 |
2024 | 2028 |
The relationships.csv contains the “relationship role” attribute and supports the enum values.
Relationship Roles | ||
---|---|---|
Parent | Guardian | Aide |
Relative | Child | Administrator |
Doctor | Other |
The enrollments.csv contains the “role” attribute and supports the enum values.
Enrollment Roles | ||
---|---|---|
Student | VisionTherapist | Substitute |
Aide | Paraprofessional | Principal |
Proctor | TeacherAssistant | SpecialServices |
Teacher | Professor | Advisor |
Administrator | Lecturer | Coach |
OccupationalTherapist | Affiliate | Assistant |
PhysicalTherapist | Adjunct | Staff |
SpeechTherapist | Instructor |
The Courses.csv contains the academic session “subject” attribute and supports the enum values.
Course Subject | Description |
---|---|
01 | English Language and Literature |
02 | Mathematics |
03 | Life and Physical Sciences |
04 | Social Sciences and History |
05 | Visual and Performing Arts |
07 | Religious Education and Theology |
08 | Physical, Health, and Safety Education |
09 | Military Science |
10 | Information Technology |
11 | Communication and Audio/Visual Technology |
12 | Business and Marketing |
13 | Manufacturing |
14 | Health Care Sciences |
15 | Public, Protective, and Government Service |
16 | Hospitality and Tourism |
17 | Architecture and Construction |
18 | Agriculture, Food, and Natural Resources |
19 | Human Services |
20 | Transportation, Distribution, and Logistics |
21 | Engineering and Technology |
22 | Miscellaneous |
23 | Non-Subject-Specific |
24 | World Languages |
The userFlags.csv contains the “flag” attribute and supports the enum values.
User Flags | Description |
---|---|
FreeLunch | Free Lunch |
ReducedLunch | Reduced Lunch |
Homeless | Homeless |
GiftedOrTalented | Gifted or Talented |
504 | Section 504 Placement |
ELL | English Language Learner |
LEP | Limited English Proficiency |
IEP | Special Education Services / Independent Education Plan Eligible |
The demographics.csv contains the “ethnicity” attribute and supports the enum values.
Ethnicity | Description |
---|---|
HispanicOrLatinoEthnicity | Hispanic or Latino ethnicity |
The demographics.csv contains the “race” attribute and supports the enum values.
Race | Description |
---|---|
AmericanIndianOrAlaskaNative | American Indian or Alaska Native |
NativeHawaiianOrOtherPacificIslander | Native Hawaiian or Other Pacific Islander |
BlackOrAfricanAmerican | Black or African American |
DemographicRaceTwoOrMoreRaces | Designates multiple races |
Asian | Asian |
White | White |
The roles.csv contains the “grade” attribute and supports the enum values.
The Courses.csv contains the academic session “grade” attribute and supports the enum values.
Grade | Description |
---|---|
IT | Infant/toddler |
PR | Preschool |
PK | Prekindergarten |
TK | Transitional Kindergarten |
KG | Kindergarten |
01 | First grade |
02 | Second grade |
03 | Third grade |
04 | Fourth grade |
05 | Fifth grade |
06 | Sixth grade |
07 | Seventh grade |
08 | Eighth grade |
09 | Ninth grade |
10 | Tenth grade |
11 | Eleventh grade |
12 | Twelfth grade |
13 | Grade 13 |
14 | Grade 14 |
PS | Postsecondary |
UG | Ungraded |
Other | Other |
PS1 | Postsecondary freshman |
PS2 | Postsecondary sophomore |
PS3 | Postsecondary junior |
PS4 | Postsecondary senior |
Undergraduate | undergraduate |
Graduate | graduate |
Postgraduate | Graduate with an emphasis on research |
Alumni | alumni |
AdultEducation | Adult Education |