A quick explanation of the different columns expected in the academicSessions.csv tab.
| Column Field Header | Required | Format | Description |
|---|---|---|---|
| sourcedId | Yes | GUID | SourcedId of this academicSession |
| 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 or title of the academic Session |
| startDate | Yes | Date | Inclusive start date for the academic session |
| endDate | Yes | Date | Exclusive end date for the academic session |
| parentSourcedId | No | GUID Reference | SourcedId of the parent of this academic session |
| schoolYear | Yes | Year | The school year for which the academic session contributes. This year should be that in which the school year ends. (Format is: YYYY) |