OneRoster: academicSessions.csv

Use the table below to format your academicSessions.csv file. Each row in the academicSessions.csv file represents a term with a start and end date. These start and end dates will determine the start and end dates of classes that refer to them. You can view an example of the academicSessions.csv file in CSV form or the academicSessions.csv file in spreadsheet form.

Blue rows denote required fields.

Field HeaderQuaver Requires?Format (max chars)Description/Guidance
sourcedIdyesstring (75)The primary key. This value should assign a unique ID to each academic session (term, school year, semester, etc.). Academic session sourcedIds will be used in other files to reference each unique academic session listed here. This value must be unique for every row in this file.
statusnostring (0)Leave this field blank. This should appear as two consecutive commas in the .csv file: ,,
dateLastModifiednodate (0)Leave this field blank. This should appear as two consecutive commas in the .csv file: ,,
titleyesstring (75)Name or title of the date range.
typeyesstring (13)Describes the type of academic session. Each value MUST be one of the following: term | gradingPeriod | schoolYear | semester
startDateyesdate (10)
YYYY-MM-DD
The date on which the session begins, formatted as YYYY-MM-DD. This value defines the start date of classes in the Quaver program that reference this session. All classes with a start date in the future are visible to users.
endDateyesdate (10)
YYYY-MM-DD
The date on which the session ends, formatted as YYYY-MM-DD. This value defines the end date of classes in the Quaver program that reference this session. Classes in Quaver become archived after this end date has passed.
parentSourcedIdnostring (75)sourcedId of the parent academic session. You can use this value to nest sessions, for example, the sourcedId of the school year to which the semester belongs.