Default List of Values
- Article
-
-
The following is the list of default List of Values or ENUMS that are supported with SDS v1, SDS v2.1 CSV or OneRoster API Inbound flows.
Organization Types
|
|
|
Source File / API Endpoint |
orgs.csv |
/orgs |
Source Field |
type |
type |
Destination Data Lake Table |
Organization |
Organization |
Destination Data Lake Field |
RefOrganizationTypeId |
RefOrganizationTypeId |
Default values supported below
Values |
|
|
school |
ministryOfEducation |
localAuthority |
department |
university |
region |
district |
college |
division |
local |
campus |
province |
state |
adultEducation |
researchCenter |
national |
municipality |
program |
departmentOfEducation |
academicTrust |
|
Organization user roles
|
|
|
Source file/API endpoint |
roles.csv |
/users |
Source field |
role |
role |
Destination data lake table |
PersonOrganizationRole |
PersonOrganizationRole |
Destination data lake field |
RefRoleId |
RefRoleId |
Default values supported below
Values |
Sort order |
Default role group |
principal |
10 |
Staff |
chair |
20 |
Staff |
professor |
30 |
Staff |
researcher |
40 |
Staff |
adjunct |
50 |
Staff |
affiliate |
60 |
Staff |
occupationalTherapist |
70 |
Staff |
physicalTherapist |
80 |
Staff |
speechTherapist |
90 |
Staff |
visionTherapist |
100 |
Staff |
paraprofessional |
110 |
Staff |
specialServices |
120 |
Staff |
advisor |
130 |
Staff |
proctor |
140 |
Staff |
nurse |
150 |
Staff |
officeStaff |
160 |
Staff |
lecturer |
170 |
Staff |
itAdmin |
180 |
Staff |
administrator |
190 |
Staff |
teacher |
200 |
Staff |
faculty |
210 |
Staff |
staff |
220 |
Staff |
teacherAssistant |
230 |
Staff |
assistant |
240 |
Staff |
instructor |
250 |
Staff |
substitute |
260 |
Staff |
coach |
270 |
Staff |
alumni |
280 |
Staff |
student |
|
Student |
other |
|
|
|
|
|
Grade levels
|
|
|
|
|
Source file/API endpoint |
roles.csv |
student.csv |
teacher.csv |
courses.csv |
Source field |
grade |
Grade |
Grade |
grade |
Destination data lake table |
PersonOrganizationRole |
PersonOrganizationRole |
PersonOrganizationRole |
CourseGradeLevel |
Destination data lake field |
RefGradeLevelId |
RefGradeLevelId |
RefGradeLevelId |
RefGradeLevelId |
|
|
|
|
|
Source file/API endpoint |
/users |
/courses |
/classes |
courses.csv |
Source field |
grades |
grade |
grade |
grade |
Destination data lake table |
PersonOrganizationRole |
CourseGradeLevel |
SectionGradeLevel |
CourseGradeLevel |
Destination data lake field |
RefGradeLevelId |
RefGradeLevelId |
RefGradeLevelId |
RefGradeLevelId |
Default values supported below
Values |
|
it |
Infant/toddler |
pr |
Preschool |
pk |
Prekindergarten |
tk |
Transitional Kindergarten |
kg |
Kindergarten |
'01' or'1' |
First grade |
'02' or '2' |
Second grade |
'03' or '3' |
Third grade |
'04' or '4' |
Fourth grade |
'05' or '5' |
Fifth grade |
'06' or '6' |
Sixth grade |
'07' or '7' |
Seventh grade |
'08' or '8' |
Eighth grade |
'09' or '9' |
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 alumni |
Graduate with an emphasis on research alumni |
adultEducation |
Adult Education |
Academic session types
|
|
|
Source file/API endpoint |
academicSessions.csv |
/academicSessions |
Source field |
type |
type |
Destination data lake table |
Session |
Session |
Destination data lake field |
RefSessionTypeId |
RefSessionTypeId |
Default values supported below
Values |
|
|
schoolYear |
semester |
term |
gradingPeriod |
quarter |
|
Academic sessions school year
|
|
|
Source file/ API endpoint |
academicSessions.csv |
/academicSessions |
Source field |
schoolYear |
schoolYear |
Destination data lake table |
Session |
Session |
Destination data lake field |
RefAcademicYearId |
RefAcademicYearId |
Default values supported below
Values |
|
|
2022 |
2026 |
2030 |
2023 |
2027 |
2031 |
2024 |
2028 |
|
2025 |
2029 |
|
|
|
|
Source file/ API endpoint |
relationships.csv |
/users |
Source field |
relationshipRole |
role (for a student's agent's user record) |
Destination data lake table |
PersonRelationship |
PersonRelationship |
Destination data lake field |
RefPersonRelationshipId |
RefPersonRelationshipId |
Default values supported below
Values |
|
parent |
guardian |
relative |
other |
doctor |
aide |
Enrollment roles
|
|
|
Source file/ API endpoint |
enrollments.csv |
/enrollments |
Source field |
role |
role |
Destination data lake table |
Enrollment |
Enrollment |
Destination data lake field |
RefSectionRoleId |
RefSectionRoleId |
Default values supported below
Values |
|
|
student |
visionTherapist |
substitute |
aid |
paraprofessional |
principal |
proctor |
teacherAssistant |
specialServices |
teacher |
professor |
advisor |
administrator |
lecturer |
coach |
occupationalTherapist |
affiliate |
assistant |
physicalTherapist |
adjunct |
staff |
speechTherapist |
instructor |
alumni |
chair |
itAdmin |
officeStaff |
Person flags
|
|
|
Source file/ API endpoint |
userFlags.csv |
/users |
Source field |
Flags [] |
metadata (where metadata microsoft.userFlags = {value}) |
Destination data lake table |
PersonDemographicPersonFlag |
PersonDemographicPersonFlag |
Destination data lake field |
RefPersonFlagId |
RefPersonFlagId |
Default values supported below
Values |
Description |
freeLunch |
Free lunch |
reducedLunch |
Reduced lunch |
homeless |
Homeless |
giftOrTalented |
Gifted or talented |
504 |
Section 504 placement |
ell |
English language learner |
lep |
Limited English proficiency |
iep |
Special education services/ Independent education plan eligible |
Subjects
|
|
|
|
|
Source file/API endpoint |
courses.csv |
section.csv |
/courses |
/classes |
Source field |
subject |
Course Subject |
subjectCodes |
subjectCodes |
Destination data lake table |
CourseSubject |
CourseSubject |
CourseSubject |
SectionSubject |
Destination data lake field |
RefAcademicSubjectId |
RefAcademicSubjectId |
RefAcademicSubjectId |
RefAcademicSubjectId |
Default values supported below
Values |
Description |
'01' or '51037' |
English language and literature |
'02' or '52039' |
Mathematics |
'03' or '51999' |
Life and physical sciences |
'04' or '54999' |
Social sciences and history |
'05' or '55199' |
Visual and performing arts |
'07' or '57999' |
Religious education and theology |
'08' or '58999' |
Physical, health, and safety education |
'09' or '09999' |
Military science |
'10' or '10999' |
Information technology |
'11' or '11999' |
Communication and audio/video technology |
'12' or '62999' |
Business and marketing |
'13' or '13999' |
Manufacturing |
'14' or '14999' |
Health care sciences |
'15' or '65999' |
Public, protective, and government service |
'16' or '66999' |
Hospitality and tourism |
'17' or '67997' |
Architecture and construction |
'18' or '68999' |
Agriculture, food, and natural resources |
'19' or '69001' |
Human services |
'20' or '70999' |
Transportation, distribution, and logistics |
'21' or '71999' |
Engineering and technology |
'22' or '22999' |
Miscellaneous |
'23' or '72999' |
Non-subject-specific |
'24' or '24039' |
World language |
Demographic ethnicity
|
|
|
Source file/ API endpoint |
demographics.csv |
/demographics |
Source field |
ethnicity |
hispanicOrLatinoEthnicity |
Destination data lake table |
PersonDemographicEthnicity |
PersonDemographicEthnicity |
Destination data lake field |
RefEthnicityId |
RefEthnicityId |
Default values supported below
Values |
Description |
hispanicOrLatinoEthnicity |
Hispanic or Latino ethnicity |
Demographic race
Demographic race |
|
|
|
Source file/ API endpoint |
demographics.csv |
|
|
Source field |
race [] |
|
|
Destination data lake table |
PersonDemographicRace |
|
|
Destination data lake field |
RefRaceId |
|
|
Demographic race |
|
|
Source file/ API endpoint |
/demographics |
/demographics |
Source field |
americanIndianOrAlaskaNative |
asian |
Destination data lake table |
PersonDemographicRace |
PersonDemographicRace |
Destination data lake field |
RefRaceId |
RefRaceId |
Demographic race |
|
|
Source file/ API endpoint |
/demographics |
/demographics |
Source field |
blackOrAfricanAmerican |
nativeHawaiianOrOtherPacificIslander |
Destination data lake table |
PersonDemographicRace |
PersonDemographicRace |
Destination data lake field |
RefRaceId |
RefRaceId |
Demographic race |
|
|
Source file/ API endpoint |
/demographics |
/demographics |
Source field |
white |
demographicRaceTwoOrMoreRace |
Destination data lake table |
PersonDemographicRace |
PersonDemographicRace |
Destination data lake field |
RefRaceId |
RefRaceId |
Default values supported below
Values |
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 |
Demographic gender
|
|
|
Source file/ API endpoint |
demographics.csv |
/demographics |
Source field |
sex |
sex |
Destination data lake table |
PersonDemographic |
PersonDemographic |
Destination data lake field |
RefSexId |
RefSexId |
Default values supported below
Values |
|
|
male |
female |
notSelected |
Demographic birth state
|
|
|
Source file/ API endpoint |
demographics.csv |
/demographics |
Source field |
birthState |
stateofBirthAbbreviation |
Destination data lake table |
PersonDemographic |
PersonDemographic |
Destination data lake field |
BirthState |
BirthState |
Default values supported below
Values |
|
|
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 |
IL |
NV |
AA |
IN |
NY |
AE |
KS |
OH |
AP |
KY |
OK |
|