Attendance Data
The following describes how to provide the fields that are needed for this dataset. If you have questions on how to provide a particular value or other concerns please contact your Kinvolved service representative.
File format guidelines
Filenames can include a base suffix to distinguish them from other files of the same type (e.g. attendance_1034.csv or attendance_20220301.csv). However, the filename should always begin with the name of the entity it contains and have a .csv suffix.
The file should always include a header row with the columns matching specified Field names.
Column values should be comma-separated and enclosed in double-quotes (at minimum the string values should be double-quoted).
All the Required fields must be provided. Other values may be left blank or the column may be omitted altogether.
Absence Codes
Filename: absenceCodes.csv
| Field | Required | Format | Description/Guidance |
|---|---|---|---|
| sourcedId | Yes | GUID | Unique identifier for this attendance event. |
| status | Yes for Delta | Enumeration | See section 4.13.8 [OneRoster, 20a] for the enumeration list. This MUST NOT be used for the Bulk mode. |
| dateLastModified | Yes for Delta | DateTime | The date that this record was last modified. This MUST NOT be used for the Bulk mode. |
| title | Yes | String | Name of this class. |
| absent | Yes | Enumeration | Whether to count this as an absence |
| absent | Yes | Enumeration | Whether parent or guardian approved this absence |
| description | No | String | Description of the event type |
Attendance
Filename: attendance.csv
| Field | Required | Format | Description/Guidance |
|---|---|---|---|
| sourcedId | Yes | GUID | Unique identifier for this attendance event. |
| status | Yes for Delta | Enumeration | See section 4.13.8 [OneRoster, 20a] for the enumeration list. This MUST NOT be used for the Bulk mode. |
| dateLastModified | Yes for Delta | DateTime | The date that this record was last modified. This MUST NOT be used for the Bulk mode. |
| classSourcedId | No | GUID Reference | SourcedId of the Class. |
| schoolSourcedId | No | GUID Reference | SourcedId of an Org with type 'school'. |
| userSourcedId | Yes | GUID Reference | SourcedId of the Student with the attendance event |
| 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" |
| absenceDate | Yes | Date | The date for the attendance event. |
| absenceCodeSourceId | Yes | GUID Reference | The code for the attendance event (absence code) |