S_TX_STU_TRUANCY_DETAILS_C (ver 21.4.2)
This table is a child of the S_TX_STU_TRUANCY_C table and captures unexcused class absence details as calculated by the Texas Student Truancy Tracking feature.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 21.4.2 | Number(10,0) | Primary key. |
| StudentsDCID | 21.4.2 | Number(10,0) | Foreign key. |
| ATTENDANCE_CODE | 21.4.2 | Varchar2(10) | The unexcused absence code for the class section. |
| COURSE_NAME | 21.4.2 | Varchar2(40) | The course name. |
| COURSE_NUMBER | 21.4.2 | Varchar2(11) | The course number. |
| ENROLL_GRADE_LEVEL | 21.4.2 | Number(11,0) | The student's grade level (not currently used). |
| EXPRESSION | 21.4.2 | Varchar2(100) | The class expression. |
| PERIOD | 21.4.2 | Varchar2(3) | The class period. |
| SCHOOLID | 21.4.2 | Varchar2(9) | The school ID for the class. |
| SECTION_NUMBER | 21.4.2 | Varchar2(10) | The class section number. |
| SERVICE_ID | 21.4.2 | Varchar2(8) | The Service ID for the class (not currently used). |
| TEACHER | 21.4.2 | Varchar2(40) | The lead teacher for the class. |
| UNX_DATE | 21.4.2 | Date | The date of the unexcused absence. |
| YEARID | 21.4.2 | Number(11,0) | The School Year for the class and unexcused absence; stored as the two-digit Term ID such as 30 for the 2020-21 school year. |