A quick explanation of the different columns expected in the classes.csv tab.
| Column Field Header | Required | Format | Description |
|---|---|---|---|
| sourcedId | Yes | GUID | Unique ID for the class. SourcedId is used in other files and must be unique across classes. |
| status | Yes for Delta | Enumeration | See section 4.13.8 (OneRoster, 20a) for the enumeration list. This must NOT be used for Bulk mode. |
| dateLastModified | Yes for Delta | DateTime | The date that this record was last modified. **This must NOT be used for Bulk mode. ** |
| title | Yes | String | Name of this class. |
| grades | No | List of Strings | Grade(s) for which the class is attended. The permitted vocabulary is from CEDS (Version 5) and the Entry Grade Level element. |
| courseSourcedId | Yes | GUID Reference | SourcedId of the course of which this class is an instance. |
| classCode | No | String | Human readable code used to help identify this class. |
| classType | Yes | Enumeration | See section 4.13.1 (OneRoster, 20a) for the enumeration list. |
| location | No | String | Human readable description of where the class is physically located. |
| schoolSourcedId | Yes | GUID Reference | SourcedId of the Org that teaches this class of OrgType "school" |
| termSourcedIds | Yes | List of GUID Reference | SourcedId of the terms (the academicSessions) in which the class is taught. |
| subjects | No | List of Strings | Subject name(s) in human readable form. If the 'subjectCodes' attribute is present, then the subjects and subjectCodes list must have the same length and have order significance. The vocabulary is from SCED (School Codes for the Exchange of Data) (Version 4) for the "Course Title" field: http://nces.ed.gov/forum/SCED.asp. If the value of the Course Title contains commas, then those commas must be removed. For example, the "Course Title" for "SCED Course Code" "03210" is "Science, Technology, and Society", this must be represented as "Science Technology and Society". |
| subjectCodes | No | List of Strings | Subject code(s) in machine readable form. If more than one subject code is needed, use double quotes and separate with commas (per RFC 4180). If the 'subjects' attribute is present, the two lists must have the same length and have order significance. For deployments in the USA, this vocabulary should be a School Courses for the Exchange of Data (SCED) code: https://nces.ed.gov/scedfinder. |
| periods | No | List of Strings | The time slots in the day that the class will be given. If more than one period is needed, use double quotes and separate with commas (per RFC 4180). Examples: 1; "1,3,5". |