Use the table below to format your orgs.csv file. Each row in the orgs.csv file should represent one organization (school or district). You can view an example of the orgs.csv file in CSV form or the orgs.csv file in spreadsheet form.
Note: Quaver does not use any information from the orgs.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 Header||Quaver Requires?||Format (max chars)||Description/Guidance|
|sourcedId||no||string (75)||The primary key. This value should assign a unique ID to each organization, school, district, etc. Orgs' sourcedIds will be used in other files to reference each unique organization listed here. This value must be unique for every row in this file.|
|status||no||string (0)||Leave this field blank. This should appear as two consecutive commas in the .csv file: ,,|
|dateLastModified||no||date (0)||Leave this field blank. This should appear as two consecutive commas in the .csv file: ,,|
|name||no||string (100)||The name of the organization.|
|type||no||string (75)||Describes the type of organization. MUST be one of the following: school | local | state | national|
|identifier||no||string (75)||NCES ID (National Center for Education Statistics) for the organization.|
|metadata.classification||no||string (7)||Describes the classification of the organization. MUST be one of the following values: charter | private | public|
|metadata.gender||no||string (6)||Describes whether the organization is co-ed or single sex. MUST be one of the following values: female | male | mixed|
|metadata.boarding||no||Boolean (5)||Determines whether or not the organization is a boarding school. “true” if school is boarding school, otherwise “false”.|
|parentSourcedId||no||string (75)||sourcedId of the parent organization. For example, the sourcedId of the district to which the school belongs.|