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