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 and Homeless.
-
EB and Homeless must be coded in the standard PowerSchool source fields in the EB student program record and PEIMS General record in order to meet other PEIMS reporting requirements.
-
EB and Homeless Reasons do not have overrides. EB students must have a special program code; Homeless must be coded in the PEIMS General record.
-
-
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) |
|
Truant Override |
Truant override |
[S_TX_STU_ATRISKOVR_X]TRUANT |
1 |
|
Truant Override Expiration Date |
Truant override expiration date |
[S_TX_STU_ATRISKOVR_X]TRUANT_EXP |
10 |
|
Chronic Absenteeism Override |
Chronic absenteeism override |
[S_TX_STU_ATRISKOVR_X]CHRONIC_ABSENT |
1 |
|
Chronic Absenteeism Override Expiration Date |
Chronic absenteeism override expiration date |
[S_TX_STU_ATRISKOVR_X]CHRONIC_ABSENT_EXP |
10 |
|
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) |