Demographics are optional, so data providers do not necessarily need to provide this information. If they do, this is the format to use. The dependencies of this file on other files when supporting bulk processing are:
This requires a reference to the associated user (user) using the 'sourcedId' attribute. This produces a dependency on the users.csv. This creates a corresponding dependency on the orgs.csv file.
| Column Field Header | Required | Format | Description |
|---|---|---|---|
| sourcedId | Yes | GUID Reference | SourcedId of the User to which the demographics refer. Typically this will be a student. Each user can only have one demographics record. |
| status | Yes for Delta | Enumeration | See section 4.13.8 (OneRoster, 20a) for the enumeration list. This must NOT be used for Bulk mode. |
| dateLastModified | Yes for Delta | DateTime | The date that this record was last modified. This must NOT be used for Bulk mode. |
| birthDate | No | Date | User's date of birth |
| sex | No | Enumeration | See section 4.13.8 (OneRoster, 20a) for the enumeration list. |
| americanIndianOrAlaskaNative | No | Enumeration | Permitted values: { "true" or "false" } |
| asian | No | Enumeration | Permitted values: { "true" or "false" } |
| blackOrAfricanAmerican | No | Enumeration | Permitted values: { "true" or "false" } |
| nativeHawaiianOrOtherPacificIslander | No | Enumeration | Permitted values: { "true" or "false" } |
| white | No | Enumeration | Permitted values: { "true" or "false" } |
| demographicRaceTwoOrMoreRaces | No | Enumeration | Permitted values: { "true" or "false" } |
| countryOfBirthCode | No | String | Country where the user was born. The permitted vocabulary is from CEDS (Version 5) for the "Country of Birth" element: https://ceds.ed.gov/elements.aspx |
| stateOfBirthAbbreviation | No | String | State where the user was born. The permitted vocabulary is from CEDS (Version 5) for the "State of Birth" element: https://ceds.ed.gov/elements.aspx |
| cityOfBirth | No | String | City where the user was born. |
| publicSchoolResidenceStatus | No | String | An indication of the location of the user's legal residence relative to (within or outside) the boundaries of the public school attended and its administrative unit. The permitted vocabulary is from CEDS (Version 5) for the "Public School Residence Status" element https://ceds.ed.gov/elements.aspx |