At-Risk Overrides
Introduction
This data collection is intended to provide additional options for districts and to fill gaps in the existing At Risk Auto-Code process so that each TEA At Risk Reason has at least one corresponding PowerSchool data source.
This data collection also eliminates the need for users to enter overrides directly into the At Risk Special Program record, which is no longer a recommended practice.
All manually-coded reasons and overrides can now be entered and managed on this page.
At Risk Reason
New manual entry/override fields are provided for each of the TEA At-Risk Reasons with the exception of EB/EL and Homeless.
EB/EL and Homeless must be coded in the standard PowerSchool source fields in the EB/EL student program record and PEIMS General record in order to meet other PEIMS reporting requirements.
Expiration Date
End dates for each At Risk Reason are also provided with the exception of Dropout, Incarceration, and Retained, which are considered permanent factors.
If the user codes the student for an override, validation requires that the corresponding Expiration Date also be entered.
Some At Risk Reasons can remain in effect for multiple school years while others apply to a single school year. Districts should manage the Expiration Dates as they see fit based on TEA guidance and the district’s own processes.
In general, as overrides remain in effect for at least one school year, the Expiration Date should be the day after the last day of the school year. The At Risk Auto-Code logic will use the expiration date to re-set the reasons and/or At Risk status in the At Risk special program record at the start of the new year.
Type: Additional dropdown list fields for the Protective Services, Residential Placement Facility and Incarceration reasons capture optional details about the reason for the manual entry/override.
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.
Data Element | Description | Table[FieldName] | Data Type |
|---|---|---|---|
Retained | Retained Override | [S_TX_STU_ATRISKOVR_X]RETAINED | Number(1,0) |
7-12 Failed Course | Failed 7-12 Course Override | [S_TX_STU_ATRISKOVR_X]FAILEDCRS_7_12 | Number(1,0) |
Failed 7-12 Expiration | Failed 7-12 Course Override Expiration Date | [S_TX_STU_ATRISKOVR_X]FAILEDCRS_7_12_EXP | Date |
Failed State Assessment | Failed State Assessment Override | [S_TX_STU_ATRISKOVR_X]FAILED_STATE_ASMT | Number(1,0) |
Failed State Assessment Expiration Date | Failed State Assessment Override Expiration Date | [S_TX_STU_ATRISKOVR_X]FAILED_STATE_ASMT_EXP | Date |
PK3 Readiness | PK-3 Readiness Override | [S_TX_STU_ATRISKOVR_X]PK3_READINESS | Number(1,0) |
PK-3 Readiness Expiration Date | PK-3 Readiness Override Expiration Date | [S_TX_STU_ATRISKOVR_X]PK3_READINESS_EXP | Date |
Pregnant/Parent | Pregnant/Parent Override | [S_TX_STU_ATRISKOVR_X]PREG_PARENT | Number(1,0) |
Pregnant/Parent Expiration Date | Pregnant/Parent Override Expiration Date | [S_TX_STU_ATRISKOVR_X]PREG_PARENT_EXP | Date |
Alternative Ed Placement | Alternative Ed Placement Override | [S_TX_STU_ATRISKOVR_X]ALT_ED | Number(1,0) |
Alternative Ed Placement Expiration Date | Alternative Ed Placement Override Expiration Date | [S_TX_STU_ATRISKOVR_X]ALT_ED_EXP | Date |
Expelled | Expelled Override | [S_TX_STU_ATRISKOVR_X]EXPELLED | Number(1,0) |
Expelled Override Expiration Date | Expelled Override Expiration Date | [S_TX_STU_ATRISKOVR_X]EXPELLED_EXP | Date |
Parole/Probation | Parole/Probation Override | [S_TX_STU_ATRISKOVR_X]PAROLE_PROB | Number(1,0) |
Parole/Probation Expiration Date | Parole/Probation Override Expiration Date | [S_TX_STU_ATRISKOVR_X]PAROLE_PROB_EXP | Date |
Dropout | Dropout | [S_TX_STU_ATRISKOVR_X]DROPOUT | Number(1,0) |
Protective Services | Protective Services Override | [S_TX_STU_ATRISKOVR_X]PROTECTIVE_SVCS | Number(1,0) |
Protective Services Expiration Date | Protective Services Override Expiration Date | [S_TX_STU_ATRISKOVR_X]PROTECTIVE_SVCS_EXP | Date |
Protective Services Type | Protective Services Type (optional)
| [S_TX_STU_ATRISKOVR_X]PROTECTIVE_SVCS_TYPE | Varchar2(2) |
Residential Placement Facility | Residential Placement Facility Override | [S_TX_STU_ATRISKOVR_X]RES_FACILITY | Number(1,0) |
Residential Placement Facility Expiration Date | Residential Placement Facility Override Expiration Date | [S_TX_STU_ATRISKOVR_X]RES_FACILITY_EXP | Date |
Residential Facility Type | Residential Facility Type (optional)
| [S_TX_STU_ATRISKOVR_X]RES_FACILITY_TYPE | Varchar2(2) |
Incarceration | Incarceration Override | [S_TX_STU_ATRISKOVR_X]INCARCERATION | Number(1,0) |
Incarceration Type | Incarceration Type (optional)
| [S_TX_STU_ATRISKOVR_X]INCARCERATION_TYPE | Varchar2(2) |
Dropout Recovery Schedule/Adult Ed Program | Dropout Recovery School/Adult Ed Program Override | [S_TX_STU_ATRISKOVR_X]DROPREC_ADULTED | Number(1,0) |
Dropout Recovery Schedule/Adult Ed Program Expiration Date | Dropout Recovery School/Adult Ed Program Override Expiration Date | [S_TX_STU_ATRISKOVR_X]DROPREC_ADULTED_EXP | Date |
Comments | At Risk Override Comments | [S_TX_STU_ATRISKOVR_X]Comments | Varchar2(250) |