OneRoster: demographics.csv

This file supplies additional demographics information for each user.  You can view an example of the demographics.csv file in CSV form or the demographics.csv file in spreadsheet form.

Note:  Quaver does not use any information from the demographics.csv file.  We prefer that you submit this file with only the field header titles and no other values.  You may upload a complete data set if you wish, but the values you supply will have no bearing on the user’s experience within the Quaver program.

Field HeaderQuaver Requires?Format (max chars)Description/Guidance
userSourcedIdnostring (75)sourcedId of the user to which the demographics refer. This value must reference a sourcedId in the users.csv file.
statusnostring (0)Leave this field blank. This should appear as two consecutive commas in the .csv file: ,,
dateLastModifiednodate (0)Leave this field blank. This should appear as two consecutive commas in the .csv file: ,,
birthdatenodate (10)User’s date of birth.
sexnostring (6)Sex of user. Each value MUST be one of either: “Female” or “Male”.
americanIndianOrAlaskaNativenoBoolean (5)Value MUST be one of either: “true” or “false”.
asiannoBoolean (5)Value MUST be one of either: “true” or “false”.
blackOrAfricanAmericannoBoolean (5)Value MUST be one of either: “true” or “false”.
nativeHawaiianOrOtherPacificIslandernoBoolean (5)Value MUST be one of either: “true” or “false”.
whitenoBoolean (5)Value MUST be one of either: “true” or “false”.
demographicRaceTwoOrMoreRacesnoBoolean (5)Value MUST be one of either: “true” or “false”.
hispanicOrLatinoEthnicitynoBoolean (5)Value MUST be one of either: “true” or “false”.
countryOfBirthCodenostring (2)Vocabulary –
https://ceds.ed.gov/CEDSElementDetails.aspx?TermxTopicId=20002
stateOfBirthAbbreviationnostring (2)Vocabulary –
https://ceds.ed.gov/CEDSElementDetails.aspx?TermxTopicId=20837
NOTE: For territories outside of the US, disregard this field.
cityOfBirthnostring (75)The city in which the user was born.
publicSchoolResidenceStatusnostring (75)Vocabulary -
https://ceds.ed.gov/CEDSElementDetails.aspx?TermxTopicId=20863