Import Roster Data page

Click through the following tabs to view CSV file layouts and file names. Fields included in the Most Common Fields table are not listed within the other tables.

The Most Common Fields table lists fields that appear within multiple CSV file types.
Field NameCSV File TypeColumnDescription/Value Options
updateIndicator

Parents/Guardians

Students

Users

Classes

Courses

Organizations

Accommodations

AMust include D, U, I, or leave blank
customerCode


Students

Users

Classes

Courses

Accommodations

B

Organizations

C
orgCode

Students

Users

Classes

Courses

C

Organizations

E
firstName

Parents/Guardians

C
UsersD
StudentsF
lastNameParents/GuardiansD
UsersE
StudentsG

There are multiple CSV files for organizational data. Organizations (Individual) refers to the individual LEA, District, and School CSV files that are exported from the UI. Organizations (Bulk) refers to one CSV file that holds a combination of LEA, District, and School data. CSV file names are listed below.

Organizations (Bulk): orgs.csv

Organizations (Individual)

    • LEAs: LEAImportTemplate.csv
    • Districts: DistrictImportTemplate.csv
    • Schools: SchoolsImportTemplate.csv

Field names marked with ** represent fields that appear within the Organizations (Individual) CSVs, but do not appear in the Organizations (Bulk) file.

Field NameColumnDescription/Value Options
orgTypeB
parentOrgCodeD
orgNameF
ncesCodeG
phoneH
requestOptionalReports**I
shipMaterialsToSchools**J
shipReportsToSchools**K
addressline1

I (Bulk)

L (Individual)


addressline2

J (Bulk)

M (Individual)


city

K (Bulk)

N (Individual)


stateOrProvinceOrRegion

L (Bulk)

O (Individual)


zipOrPostalCode

P (Bulk)

M (Individual)


countryCode

N (Bulk)

Q (Individual)


contactType

O (Bulk)

R (Individual)


contactName

P (Bulk)

S (Individual)


contactPhone

Q (Bulk)

T (Individual)


contactEmail

R (Bulk)

U (Individual)


There are multiple CSV files for student data. Students (Individual) refers to the individual student CSV file that is exported from the UI, which differs slightly from the Students (Bulk) file layout. CSV file names are listed below.

Students (Bulk): students.csv

Students (Individual): StudentImportTemplate.csv

Field names marked with ** represent fields that appear within the Students (Individual) CSV, but do not appear in the Students (Bulk) file.

The Students (Individual) CSV includes accommodations fields that are not listed in this table. See the Accommodations tab to view examples of possible accommodation fields.

Field NameColumnDescription/Value Options
studentidD
localId

E


middleName

H


dateOfBirthI

mm/dd/yyyy

m/d/yyyy

enrolledGradeJ
studentEmailK
reportingSchool**L
sex

L (Bulk)

M (Individual)


americanIndian

M (Bulk)

N (Individual)


asian

N (Bulk)

O (Individual)


blackAfricanAmerican

O (Bulk)

P (Individual)


nativeHawaiianPacificIslander

P (Bulk)

Q (Individual)


white

Q (Bulk)

R (Individual)


multiRace

R (Bulk)

S (Individual)


hispanicLatino

S (Bulk)

T (Individual)


iep

T (Bulk)

U (Individual)


ell

U (Bulk)

V (Individual)


lep

V (Bulk)

W (Individual)


giftedTalented

W (Bulk)

X (Individual)


section504

X (Bulk)

Y (Individual)


migrant

Y (Bulk)

Z (Individual)


economicDisadvantage

Z (Bulk)

AA (Individual)


otherAccommodations

AA (Bulk)

AB (Individual)


homeless

AB (Bulk)

AC (Individual)


parentMilitary

AC (Bulk)

AD (Individual)


inFosterCare

AD (Bulk)

AE (Individual)


nativeLanguage

AE (Bulk)

AF (Individual)


There are two CSV files for user data, which follow the same layout. File names are listed below.

Users (Bulk): users.csv

Users (Individual): UserImportTemplate.csv

Field NameColumnDescription/Value Options
permissionRoleF
emailG



You can export the Parents/Guardians CSV file from the Export Parents/Guardians tab on the Parents/Guardians page.

Parents/Guardians: ParentImportTemplate.csv

Field NameColumnDescription/Value Options
emailE
phoneF
studentIDG
Manifest: manifest.csv
Field NameColumnDescription/Value Options
pearsonstandard.versionA
2B

There are two CSV files for class data, which follow the same layout. File names are listed below.

Classes (Bulk): classes.csv

Classes (Individual): ClassImportTemplate.csv

Field NameColumnDescription/Value Options
classidD
classNameE
classGradeF
classSubjectG
roleH
idI
courseIdJ

There are two CSV files for course data, which follow the same layout. File names are listed below.

Courses (Bulk): courses.csv

Courses (Individual): CourseImportTemplate.csv

Field NameColumnDescription/Value Options
courseidD
courseName

E


departmentNameF



You can export the Sessions CSV file from the Export Sessions tab on the Sessions page.

Sessions: TestSessionTemplate.csv

Field NameColumnDescription/Value Options
IndicatorA
Student SID

B


Student First NameC
Student Last NameD
Org CodeE
Session

F


AdministrationG
Test CodeH
ModeI
Start DateJ
End DateK
Start TimeL
End TimeM
Days of TestingN
TimezoneO



Available accommodations vary by program. Valid import values for common accommodation options are listed on the Accommodations Data Import page.