demographics.csv

Demographics are extended attributes that apply to students.

Column Order and Optionality

The columns of the classes.csv file must be in the following order:

	Column Name	Required?	Can be blank?
1	sourcedId	yes	no
2	status	yes	must be blank for bulk, must be populated for delta
3	dateModified	yes	must be blank for bulk, must be populated for delta
4	birthDate	yes	yes
5	sex	yes	yes
6	americanIndianOrAlaskaNative	yes	yes
7	asian	yes	yes
8	blackOrAfricanAmerican	yes	yes
9	nativeHawaiianOrOtherPacificIslander	yes	yes
10	white	yes	yes
11	demographicRaceTwoOrMoreRaces	yes	yes
12	hispanicOrLatinoEthnicity	yes	yes
13	countryOfBirthCode	yes	yes
14	stateOfBirthAbbreviation	yes	yes
15	cityOfBirth	yes	yes
16	publicSchoolResidenceStatus	yes	yes

Relational Columns

The sourcedId column resolves to a student in users.

Column Name	Description	On Import
sourcedId	Uniquely identifies the record	Matched to user.sourcedId

Core Columns

These columns represents extended attributes for the given student.

Column Name	Description	On Import
birthDate	birthday	Updates
sex	gender	Matches to Student ID, Parent ID or Teacher ID
enabledUser	Archived users are FALSE, active users are TRUE	Sets archived status accordingly

Non-core Columns

OneRoster includes the following columns, but do not match to a ManageBac attribute:

Column Name	Description	On Import
americanIndianOrAlaskaNative	-	Ignored
asian	-	Ignored
blackOrAfricanAmerican	-	Ignored
nativeHawaiianOrOtherPacificIslander	-	Ignored
demographicRaceTwoOrMoreRaces	-	Ignored
hispanicOrLatinoEthnicity	-	Ignored
countryOfBirthCode	-	Ignored
stateOfBirthAbbreviation	-	Ignored
cityOfBirth	-	Ignored
publicSchoolResidenceStatus		Ignored

The following columns values depend on the import or export mode:

Column Name	Bulk	Delta
status	Must be present but emtpy	Must be present and either "active" or "tobedeleted"
dateLastModified	Must be present but empty	Must be present and a date

Example file

sourcedId	status	dateLastModified	birthDate	sex	americanIndianOrAlaskaNative	asian	blackOrAfricanAmerican	nativeHawaiianOrOtherPacificIslander	white	demographicRaceTwoOrMoreRaces	hispanicOrLatinoEthnicity	countryOfBirthCode	stateOfBirthAbbreviation	cityOfBirth	publicSchoolResidenceStatus
4d74...ed70			2000-05-01	male
b403...558b			2003-09-13	female