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