If you need to submit demographic data for your students, GG4L Connect can ingest values for 20 standard demographic categories. Eight of these categories can be ingested through the default demographic categories in the OneRoster demographics.csv exported from your student information system (SIS). The remaining 12 categories are ingested via metadata fields that can be appended to your OneRoster demographics.csv file. After uploading your updated demographics.csv file, you can verify these demographics in student records.
Ingesting default student demographics in demographics.csv
This OneRoster specification shows all the values that can be submitted in a OneRoster demographics.csv. The information in this section shows the columns in demographics.csv used by default to associate demographic data with a student. Each student should have one row in the demographics.csv file; the student’s sourcedId in demographics.csv should map to the sourcedId in your district’s OneRoster users.csv file. Only the sourcedId value is required; the rest of the columns are optional. Demographic values are not required to ingest student records into GG4L Connect, but they must be provided if your district requires demographic data for Amplify aggregate reporting. While other values can be captured in a OneRoster demographics.csv file, the values in the table that follows are the ones relevant to Amplify Enrollment.
Column Field Header | Supported Values |
sourcedId | The student’s sourcedId from the users.csv file. |
sex | male, female |
americanIndianOrAlaskaNative | true, false |
asian | true, false |
blackOrAfricanAmerican | true, false |
nativeHawaiianOrOtherPacificIslander | true, false |
white | true, false |
demographicRaceTwoOrMoreRaces | true, false |
hispanicOrLatinoEthnicity | true, false* |
*This will display in mCLASS enrollment and reporting later this school year.
Ingesting student demographics metadata in demographics.csv
Ingesting additional demographics categories with GG4L Connect requires two steps. First, you must add the metadata fields to your demographics.csv file, and then you must upload the demographics.csv file to GG4L Connect.
Adding metadata fields to demographics.csv
To ingest the remaining 12 student demographic categories into GG4L Connect, you must add headers to 12 columns and then provide a value for the students when you want that demographic to be associated with their record. The headers and links to the descriptions and accepted codes/values for each category can be found in the table that follows. (The last two demographics are not Common Education Data Standards -aligned; accepted values are displayed.) Please note that the headers should follow the format presented in the table, including capitalization.
Column Field Header | Descriptions and Accepted Values |
metadata.otherRaceIndicator | |
metadata.homeLanguage | |
metadata.englishLearnerStatus | |
metadata.ideaIndicator | |
metadata.disabilityStatus | |
metadata.primaryDisabilityType | |
metadata.section504Status | |
metadata.economicDisadvantageStatus | |
metadata.eligibilityStatusForSchoolFoodServicePrograms | |
metadata.migrantStatus | |
metadata.titleI | The student receives services through a Title I-funded program: true or false* |
metadata.iepStatus | The student has an Individualized Education Program (IEP) in effect for the current school year: true or false* |
*This will display in mCLASS enrollment and reporting later this school year.
A completed demographics.csv file will follow this example:
Uploading demographics.csv to GG4L Connect
To include the metadata fields you’ve added for your students, you must upload your updated demographics.csv file with the rest of your OneRoster enrollment files via your chosen upload method (CSV Upload or SFTP). Once you have uploaded your demographics.csv file, the metadata fields and their associated student demographics data are ingested.
Verifying metadata fields and demographics
After uploading your demographics.csv file, you can verify student demographics in the GG4L Connect data browser.
Log on to GG4L Connect, and click Data Browsing.
In the ribbon that shows the different enrollment data types, click Students.
In the table of students that displays, click the row for a student with demographics added via the metadata fields.
In the student record, scroll down to the Extra Attributes field. The metadata columns with submitted values display in this field, along with the demographic value indicated for that student.