This article provides information on how data in Aeries are mapped to OneRoster. These data elements are shared between the OneRoster API and the CSV extract.


Note: OneRoster extracts and OneRoster API calls require a current class enrollment record (ATT/ENR). Students not having current enrollment at the time the extract is created will not be included in the extract results


Academic Session

OneRoster ElementAeries FieldComment/Example
sourcedIdTRM.SC + "_" + TRM.TM994_F
dateLastModifiedTRM.DTSConverted to UTC time
title
Determined by TRM.TM and whether the school is semester or trimester
startDateTRM.D1
endDateTRM.D2
type
"term"
schoolYear
The current school year


Class / Classes - Secondary (and elementary w/ MST)

OneRoster ElementAeries FieldComment/Example
sourcedIdMST.SC + "_" + MST.SE994_1001
dateLastModifiedMST.DTSConverted to UTC time
titleCRS.CO
classType
"scheduled" or "homeroom". Homeroom applies only to elementary w/ MST
locationMST.RM
gradesMST.LO, MST.HILists all grades from LO to HI. Ex: "09", "10", "11", "12"
courseMST.CN
schoolMST.SC
termsMST.SC + "_" + MST.SM994_F
periodsNonFlex
MST.PD, MST.BL

For Flex
FTF.STI FTF.ST FTF.ET		Lists all periods in a block section. Ex: "2", "3", "4"


Class / Classes - Elementary

OneRoster ElementAeries FieldComment/Example
sourcedIdTCH.SC + "_TN_" + TCH.TN (beginning 2019-2020)
TCH.SC + "_" + TCH.ID (2018-2019 format)		990_TN_421 (beginning in 2019-2020)
990_990421 (2018-2019 format)
dateLastModifiedSTF.DTSConverted to UTC time
title(blank)
classType
"scheduled"
locationTCH.RM
gradesTCH.LO, TCH.HILists all grades from LO to HI. Ex: "KG", "01"
course"TCH_" + TCH.IDTCH_990421
schoolTCH.SC
termsTCH.SC + "_Y990_Y
periods
0


Course - Secondary (and elementary w/ MST)

OneRoster ElementAeries FieldComment/Example
sourcedIdCRS.CN
dateLastModifiedCRS.DTSConverted to UTC time
titleCRS.CO
courseCodeCRS.CN
gradesCRS.LO, CRS.HILists all grades from LO to HI. Ex: "09", "10", "11", "12"


Course - Elementary

OneRoster ElementAeries FieldComment/Example
sourcedId"TCH_" + TCH.ID
TCH_990421
dateLastModifiedTCH.DTSConverted to UTC time
titleTCH.TEAcosta
courseCode"TCH_" + TCH.ID

gradesTCH.LO, TCH.HILists all grades from LO to HI. Ex: "09", "10", "11", "12"


Demographics

OneRoster ElementAeries FieldComment/Example
sourcedId"STU_" + STU.IDSTU_99400001. Will use the custom sourcedId field (e.g., STU.NID) instead of STU.ID if configured.
dateLastModifiedSTU.DTSConverted to UTC time
birthDateSTU.BD
sexSTU.GNOneRoster only supports values of "male" and "female".  Other gender values will be returned as null (API) or blank (CSV).
americanIndianOrAlaskaNative
STU.RC1 - RC5
asian
STU.RC1 - RC5

blackOrAfricanAmerican
STU.RC1 - RC5

nativeHawaiianOrOtherPacificIslander
STU.RC1 - RC5

white
STU.RC1 - RC5

demographicRaceTwoOrMoreRaces

false
hispanicOrLatinoEthnicity
STU.ETH
countryOfBirthCode
STU.BCU
stateOfBirthAbbreviation
STU.BST
cityOfBirth
STU.BCY


Enrollment - Secondary (and elementary w/ MST) - Student

OneRoster ElementAeries FieldComment/Example
sourcedIdSEC.SC + "_STU_" + STU.ID + "_" + SEC.SE994_STU_99400001_1001
dateLastModifiedSEC.DTSConverted to UTC time
userSee "User - Student"
STU_99400001
classSee "Class"
994_1001
schoolSee "Org"
994
role
"student"
primary
false
beginDateCAR.DS
endDateCAR.DE


Enrollment - Secondary (and elementary w/ MST) - Teacher

OneRoster ElementAeries FieldComment/Example
sourcedIdFor Non-Flex
MST.SC + "_TCH_" + TCH.ID + "_" + MST.SE

For FLEX/SSE
MST.SC + "_TCH_" + STF.ID + "_" + MST.SE
994_TCH_994005_1001
dateLastModifiedSEC.DTSConverted to UTC time
userSee "User - Teacher"
TCH_994605
classSee "Class"
994_1001
schoolSee "Org"
994
role
"teacher"
primary
true


Enrollment - Elementary - Student

OneRoster ElementAeries FieldComment/Example
sourcedIdSTU.SC + "_STU_" + STU.ID + "_0"990_STU_99000007_0
dateLastModifiedSTU.DTSConverted to UTC time
userSee "User - Student"
STU_99000007
classSee "Class"
990_990421 or 990_TN_421
schoolSee "Org"
990
role
"student"
primary
false
beginDateTRM.D1Uses the current term
endDateTRM.D2Uses the current term


Enrollment - Elementary - Teacher

OneRoster ElementAeries FieldComment/Example
sourcedIdTCH.SC + "_TCH_" + TCH.ID + "_0"990_TCH_990421_0
dateLastModifiedSTU.DTSConverted to UTC time
userSee "User - Teacher"
TCH_990421
classSee "Class"
990_990421
schoolSee "Org"
990
role
"teacher"
primary
true


Line Item

OneRoster ElementAeries FieldComment/Example
sourcedIdGBA.UI
dateLastModifiedGBA.DTSConverted to UTC time
metadata.vendorIdGBA.EI
titleGBA.AD
descriptionGBA.COM
assignDate
GBA.DAIf GBA.DA is not populated, use GBA.DD
Converted to UTC time
dueDateGBA.DDConverted to UTC time
classSee "Class". Based on GBE.SC and GBE.SE
categorySee "Category". Based on GBA.GN and GBA.AT
gradingPeriodSee "Academic Session". Based on GBE.SC and GBR.CD

resultValueMin
0
resultValueMaxGBA.NP


Category

OneRoster ElementAeries FieldComment/Example
sourcedIdGBT.GN + "_" + GBT.AT4366926_1
dateLastModifiedGBT.DTSConverted to UTC time
metadata.classIdGBE.SC + "_" + GBE.SE
titleGBT.TD


Org

OneRoster ElementAeries FieldComment/Example
sourcedIdLOC.CD
dateLastModifiedLOC.DTSConverted to UTC time
nameLOC.NM
type
"district" or "school"
parent
For schools, this is a reference to the district (school 0)
children
For the district, this is a list of references to all schools


Result

OneRoster ElementAeries FieldComment/Example
sourcedIdSTU.SC + "_STU_" + STU.ID + "_" + GBA.UI994_STU_99400001_538f1dcf-ba96-4678-86fd-b7abcd43bb82
dateLastModifiedGBS.DTSConverted to UTC time
lineItemSee "Line Item"
538f1dcf-ba96-4678-86fd-b7abcd43bb82
studentSee "User - Student"STU_99400001
scoreStatusBased on GBS.MK and GBA.GC"exempt", "notsubmitted", "submitted", "fullygraded"
scoreGBS.NC
scoreDateGBS.DC
commentGBS.CO


User - Student

OneRoster ElementAeries FieldComment/Example
sourcedId"STU_" + STU.IDSTU_99400001. Will use a different sourcedId field (e.g., STU.NID) instead of STU.ID if configured.
dateLastModifiedSTU.DTSConverted to UTC time
usernameSTU.SEMWill use a different username field (e.g., STU.NID) if configured
userIds
Uses the configured option for userIds.
enabledUser
true
givenNameSTU.FN
familyNameSTU.LN
middleNameSTU.MN
role
"student"
identifierSTU.SC + "_STU_" + STU.ID994_STU_99400001
emailSTU.SEM
phoneSTU.TL
agentsSee "User - Parent"List of references to parent accounts linked to this student
orgsSTU.SCList of all schools where this student is enrolled
gradesSTU.GR


User - Teacher

OneRoster ElementAeries FieldComment/Example
sourcedId"TCH_" + STF.IDTCH_994605. Will use a different sourcedId field (e.g., STF.NID) instead of STF.ID if configured.
dateLastModifiedSTF.DTSConverted to UTC time
usernameTCH.EMWill use a different username field (e.g., STF.NID) if configured
userIds
Uses the configured option for userIds.
enabledUser
true
givenNameSTF.FN
familyNameSTF.LN
middleNameSTF.MN
role
"teacher"
identifierFor Non Flex
TCH.SC + "_TCH_" + STF.ID
For Flex
SSE.SC + "_TCH_" + STF.ID
994_TCH_994605
emailSTF.EM
phoneSTF.TL
orgsTCH.SCList of all schools where this teacher has a record
gradesTCH.LO, TCH.HILists all grades from LO to HI. Ex: "09", "10", "11", "12"
This includes teacher grade levels when teaching at multiple schools.


User - Parent

OneRoster ElementAeries FieldComment/Example
sourcedId"PAT_" + PWA.AIDPAT_23
dateLastModifiedPWA.DTSConverted to UTC time
usernamePWA.EM
enabledUser
true
givenNameCON.FN
familyNameCON.LN
middleNameCON.MN
role
"parent"
identifier"0_PAT_" + PWA.AID0_PAT_23
emailCON.EMUse PWA.EM if CON.EM is not populated
smsCON.CP
phoneCON.TL
agentsSee "User - Student"List of references to students linked to this parent account
orgsSTU.SCDisplays as a 0 for parent accounts.