As-of-Status Calculations | X-User Help Sandbox

Add As-of-Status Calculations

This page helps you store As-of-Status Code calculations for the PEIMS Fall and Summer Submissions for both TEA Legacy and Ed-Fi reporting for the 2022-23 school year. Student As-of-Status Codes will no longer be calculated within the Student Interchange. Instead, the calculations will now run during a new Texas nightly process.

Navigation: Start Page > Student Selection > Texas State Information > As-of-Status Calculations

Data Element	Additional Information	[Table] Field Name	Used in these Reports
School Year	Enter the school year	[S_TX_STU_AOS_C]YearID	PEIMS Fall and Summer Submissions
Fall As of Status	Enter the Fall As-of Status: Not Applicable (equivalent of NULL) (A) Enrolled PY; Not Enrolled Current Year (B) Enrolled School-Start Window; Enrolled Fall As Of Date (C) Enrolled School-Start Window; Not Enrolled Fall As Of Date (D) Enrolled PY; Not Enrolled School-Start Window; Enrolled Fall As Of Date (E) Enrolled PY and CY; Not Enrolled School-Start Window; Not Enrolled Fall As Of Date (F) Not Enrolled PY; Not Enrolled School-Start Window; Enrolled Fall As Of Date (G) Not Enrolled PY; Enrolled CY; Not Enrolled School-Start Window; Not Enrolled Fall As Of Date (X) Students in Grades EE-06 and First Time 7th Graders	[S_TX_STU_AOS_C]AS_OF_STATUS_FALL	PEIMS Fall and Summer Submissions
Leaver School	Enter the leaver school ID (reportable campus ID of the Leaver record school)	[S_TX_STU_AOS_C]LEAVER_SCHOOL_FALL_R	PEIMS Fall and Summer Submissions
Leaver Reason	Enter the leaver reason.	[S_TX_STU_AOS_C]LEAVER_REASON_FALL	PEIMS Fall and Summer Submissions
EOY As-of-Status	Select the end of year as-of-status: (H) Enrolled on Final Day of School (I) Not Enrolled on Final Day of School (X) Student in Grades EE-06	[S_TX_STU_AOS_C]AS_OF_STATUS_EOY	PEIMS Fall and Summer Submissions
AOS Comment	Enter AOS comments if any.	[S_TX_STU_AOS_C]AOS_Comment	PEIMS Fall and Summer Submissions

Additional information

PEIMS General Record: Modified for 7th Grade Repeaters
- The existing As-Of Status Override field is hidden in all records dated 08/01/2022 and beyond.
- The purpose of this field was to override coding of students who were in 7th grade in the previous year in a previous district.
- A new 7th Grade Repeater field is added in its place: S_TX_STU_STATE_GEN_C.Grade_7_Repeater
  - This element displays a dropdown list with values of (0) No and (1) Yes - default is 0.
  - On-screen text: "7th Grade Repeater should be selected only when a current grade 7 student was enrolled in a different district in grade 7 in the prior year; used for the Fall As-of-Status calculation."
- The Fall As-of-Status Code calculation for 7th Grade Repeaters is also modified to reference the new field with the following logic:
  - If the value is set to (0) No or NULL, the field is ignored.
  - If the value is set to (1) Yes:
    - If the student's Fall Snapshot grade level is not 7, the field is ignored.
    - If the student's Fall Snapshot Grade Level is 7, the student's Fall as of Status is calculated and stored with a value of B-G.
Nightly Process for As-of-Status Code Calculations
- Fall As-of-Status is calculated for:
  - Prior Year Grade 7 Repeaters
  - All prior year leavers enrolled in grades 7-12 at some point in the prior year with no active enrollment in the current year on or before the Fall Snapshot Date.
  - All students enrolled in the current year in grades 8-12 with at least one day of enrollment on or before the Fall Snapshot Date
  - All students in grades EE-06 and first time 7th graders who are enrolled on the Fall Snapshot Date
- EOY As of Status Last Day of Enrollment is calculated for all students enrolled at least one day during the school year.
- As student enrollment records are updated in PowerSchool, the As-of-Status Code calculation is updated if applicable and the new value is stored in the database. If the student’s AOS Code has not changed, the existing record is left intact.