S_TX_STU_TRUANCY_C (ver 21.4.2)
This table is a child of the Students table and captures student truancy records for the Summer PEIMS Attendance Interchange.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 21.4.2 | Number(10,0) | Primary key. |
| StudentsDCID | 21.4.2 | Number(10,0) | Foreign key. |
| E0017_TRUANCY_GRADE_LEVEL | 21.4.2 | Number(11,0) | The student's grade level in the current year when the student first met the TEA truancy threshold of 10 unexcused absences in a six month period. Calculated element. |
| E0782_TRUANCY_CAMPUS_ID | 21.4.2 | Varchar2(9) | The student's campus of enrollment when the student met the TEA truancy threshold. Calculated element. |
| E0782_TRU_PREV_CAMPUS_ID | 21.4.2 | Varchar2(9) | The student's campus of enrollment where a Truancy Prevention Measure was initiated, if the student has not yet met the TEA truancy threshold. Manually entered element. |
| E1657_TRUANCY_ABS_IND | 21.4.2 | Number(1,0) | PEIMS Excessive Absence Indicator for the TEA threshold of 10 unexcused absences in a six month period. Calculated element |
| E1657_TRUANCY_ABS_IND_OVR | 21.4.2 | Number(1,0) | Override for the PEIMS Excessive Absence Indicator. Manually entered element. |
| E1658_TRUANCY_PREV_MEAS_IND | 21.4.2 | Number(1,0) | PEIMS Truancy Prevention Measure Indicator. Manually entered element. |
| E1659_TRUANCY_COMPLAINT_IND | 21.4.2 | Number(1,0) | PEIMS Truancy Complaint Indicator. Manually entered element. |
| STATE_REPORTABLE | 21.4.2 | Number(1,0) | Field for internal use indicating that the record is state-reportable. Calculated element. |
| TOTAL_TRUANCY_ABS | 21.4.2 | Number(11,0) | The total days with at least one unexcused absence, year-to-date for the school year. Calculated element. |
| TRU_PREV_DATE | 23.7.3 | Date | The date the of the truancy prevention measure. |
| TRU_COMPLAINT_DATE | 23.7.3 | Date | The date the truancy complaint was filed. |
| TRUANCY_COMMENTS | 21.4.2 | Varchar2(500) | Optional comments entered by the user for the truancy record. |
| TRUANCY_THRESHOLD_DATE | 21.4.2 | Date | The date the student met one of the truancy thresholds: 3 unexcused absences in four weeks or 10 unexcused absences in six months. Calculated element. |
| TRUANCY_THRESHOLD_TYPE | 21.4.2 | Varchar2(30) | Indicates the truancy threshold met by the student. Calculated element. |
| YEARID | 21.4.2 | NUMBER(11,0) | The School Year to which the truancy record belongs; stored as the two-digit Term ID such as 30 for the 2020-21 school year. |