S_SC_STU_Truancy_C (ver 17.12.1)
This table is a child of the Students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 17.12.1 | Number(11,0) | A foreign key that relates the extended table to the [Students] table. |
| Date_Updated | 17.12.1 | Date | The date that the update process was last run. |
| Truancy_Date | 17.12.1 | Date | The attendance date when the student was flagged as truant. |
| Truancy_Level | 17.12.1 | Number(11,0) | The level of truancy reached (1, 2, 3 or 4). |
| SchoolId | 17.12.1 | Number(11,0) | The school number associated with the student when truant. |
| YearId | 17.12.1 | Number(11,0) | The term year ID for the truancy. |