S_SC_STU_Truancy_Detail_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. |
| Att_Date | 17.12.1 | Date | The date of attendance. |
| Date_Updated | 17.12.1 | Date | The date the update process was last run. |
| Daily_Early_Dismissal_Count | 17.12.1 | Number(11,0) | The number of early dismissals. |
| Daily_Dismissal_Count | 17.12.1 | Number(11,0) | The number of dismissals. |
| Daily_Excused_Absent_Value | 17.12.1 | Number(11,0) | The number of full-day absences that are excused. |
| Daily_OSS_Absent_Value | 17.12.1 | Number(11,0) | The number of full-day absences that are out of school suspension days. |
| Daily_Tardy_Count | 17.12.1 | Number(11,0) | The number of tardies. |
| Daily_Absent_Value | 17.12.1 | Number(11,0) | The total number of full-day absences (includes excused, unexcused, and OSS). |
| Daily_Unexcused_Absent_Value | 17.12.1 | Number(11,0) | The number of full-day absences that are unexcused. |
| 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. |
| Daily_UEDM_Count | 18.8.0 | Number(11,0) | The number of unexcused early dismissals (attendance code SC-UEDM). |