If you need to submit demographic data for your students, GG4L Connect can ingest values for 18 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 10 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.

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.

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.

To ingest the remaining 10 student demographic categories into GG4L Connect, you must add headers to 10 columns and then provide a Common Education Data Standards (CEDS)-aligned 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. Please note that the headers should follow the format presented in the table, including capitalization.

A completed demographics.csv file will follow this example:
​

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.

After uploading your demographics.csv file, you can verify student demographics in the GG4L Connect data browser.