S_SC_STU_CHRONICABSENCE_C (ver 17.4.0)
This is a child table of the Students table.
Column Name | Version | Data Type | Description |
---|---|---|---|
ID | 17.4.0 | Number(10,0) | Primary key |
StudentID | 17.4.0 | Number(10,0) | The internal student ID included for state reporting needs. |
Chronic_Absence_Flag | 17.4.0 | Varchar2(1) | A Y/N flag for chronic absenteeism. |
Date_Updated | 17.4.0 | Date | The date the table was last updated. |
Excused_Days_Absent | 17.4.0 | Number(10,0) | The total of Attendance table days_Absent = Unexcused. |
History_Record | 17.4.0 | Varchar2(1) | Flag (Y/N) |
Membership_Days | 17.4.0 | Number(10,0) | The number of membership attendance days. |
OSS_Days_Absent | 17.4.0 | Number(10,0) | The total of Attendance table days_Absent = OSS. |
SchoolID | 17.4.0 | Number(10,0) | The school ID. |
StudentsDCID | 17.4.0 | Number(10,0) | The foreign key that links this record to the Students table. |
Unexcused_Days_Absent | 17.4.0 | Number(10,0) | The total of Attendance table days_Absent = Unexcused. |
YearID | 17.4.0 | Number(10,0) | The school year. |