S_TX_STU_ATRISKOVR_X (Version 23.7.3)
This table is an extension of the Students table and is used to track At Risk Overrides used in the Texas At Risk Auto-Code routine for PEIMS Reporting.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 23.7.3 | Number(10,0) | The foreign key that relates the extended table to the [Students] table. |
ALT_ED | 23.7.3 | Number(1,0) | Alternative Ed Placement At Risk Override |
ALT_ED_EXP | 23.7.3 | Date | Alternative Ed Placement Override Expiration Date |
COMMENTS | 23.7.3 | Varchar2(250) | At Risk Override Comments |
DROPOUT | 23.7.3 | Number(1,0) | Dropout At Risk Override |
DROPREC_ADULTED | 23.7.3 | Number(1,0) | Dropout Recovery School/Adult Ed Program At Risk Override |
DROPREC_ADULTED_EXP | 23.7.3 | Date | Dropout Recovery School/Adult Ed Program Override Expiration Date |
EXPELLED | 23.7.3 | Number(1,0) | Expelled At Risk Override |
EXPELLED_EXP | 23.7.3 | Date | Expelled At Risk Override Expiration Date |
FAILED_STATE_ASMT | 23.7.3 | Number(1,0) | Failed State Assessment At Risk Override |
FAILED_STATE_ASMT_EXP | 23.7.3 | Date | Failed State Assessment Override Expiration Date |
FAILEDCRS_7_12 | 23.7.3 | Number(1,0) | Failed 7-12 Foundation Curriculum Courses Override |
FAILEDCRS_7_12_EXP | 23.7.3 | Date | Failed 7-12 Foundation Curriculum Courses Override Expiration Date |
INCARCERATION | 23.7.3 | Number(1,0) | Incarceration At Risk Override |
INCARCERATION_TYPE | 23.7.3 | Varchar2(2) | Incarceration Type: Parent, Student or Both Parent and Student |
PAROLE_PROB | 23.7.3 | Number(1,0) | Parole/Probation At Risk Override |
PAROLE_PROB_EXP | 23.7.3 | Date | Parole/Probation Override Expiration Date |
PK3_READINESS | 23.7.3 | Number(1,0) | PK-3 Readiness At Risk Override |
PK3_READINESS_EXP | 23.7.3 | Date | PK-3 Readiness Override Expiration Date |
PROTECTIVE_SVCS | 23.7.3 | Number(1,0) | Protective Services At Risk Override |
PROTECTIVE_SVCS_EXP | 23.7.3 | Date | Protective Services Override Expiration Date |
PROTECTIVE_SVCS_TYPE | 23.7.3 | Varchar2(2) | Protective Services Type: Referral or Custody |
RES_FACILITY | 23.7.3 | Number(1,0) | Residential Placement Facility At Risk Override |
RES_FACILITY_EXP | 23.7.3 | Date | Residential Placement Facility Override Expiration Date |
RES_FACILITY_TYPE | 23.7.3 | Varchar2(2) | Residential Facility Type |