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). |