Special Education Alternate Assessment Qualification
Texas Assessment Precode Extracts
Student Registration File Format
Overview
Navigate to School Info > Imports and Exports > Texas Assessment Precode Extracts (BETA).
The Texas Assessment and Precode Extracts page allows for configuration, creation, and downloading of STAAR and TELPAS roster files. Multiple student pages contain records that will be extracted if existing, including Test Settings, Special Education, and Language Assessment. Code translations on the Texas State Reporting page will be honored for applicable records. Additionally, the Test Settings page allows for recording of student accommodations and December or June EOC test assignment.
Security ↑
Table | Permission | Description |
---|---|---|
State Reporting Security Area | Administer | Configure or extract precode files |
Test Settings (STS) | Read Insert Update Delete | View page Add new record Update records Delete Records |
Texas Assessment Precode Accommodations (PRE) | Read | To query PRE table, which contains roster extract data |
Test Settings ↑
Accommodations and December or June EOC test assignments are recorded and displayed on each student's Test Settings page. The Test Settings page includes two horizontal tabs and five vertical tabs. The horizontal tabs are Active Test Settings and Test Settings List (all). Accommodations and December or June EOC assignments can be quickly entered on the Active Test Settings tab, which will only display currently active settings. Test Settings records (including Start and End Dates) can be modified on the Test Settings List (all) tab, which displays all accommodations (including non-current).
Active Test Settings ↑
The Active Test Settings tab is displayed below:
The five vertical tabs (STAAR Grades 3-8, STAAR End-of-Course (EOC), EOC Eligibility, Interim Tests and TELPAS) can each be expanded or closed with by clicking the chevron icon at the right. Once expanded, the tab displays current accommodations and other test information that will be included in extracts:
To add an accommodation, press the Change button:
Dropdowns and checkboxes will be provided for each accommodation. The December EOC and June EOC checkboxes should be populated to identify the students that will be participating in these testing administrations. The Texas Assessment Precode Extract uses these Test Settings records to populate the precode files for the December and June 2023-2024 precode extracts.
Press the Save button to save the selections or press Cancel to cancel adding the selections.
Once saved, the accommodations will appear on the Active Test Settings tab. Note that the Active Test Settings tab is also included as a tab on each Special Education page:
Test Settings List (all) Tab ↑
On the Test Settings List (all) tab, press the Edit icon to modify the Test Setting Code, Start Date or End Date. A test setting can also be deleted using the Trashcan icon.
A Test Setting can be added on the Test Settings List(all) tab by pressing Add New Record.
Special Education Alternate Assessment Qualification ↑
On a student's Special Education page, the Test Participation (CSE.PA2) field should be used to record that the student can participate in an alternate assessment (STAAR Alternate 2 or TELPAS Alternate). The Special Education record must have a Disability (CSE.DI) and must be active, i.e. there is no Exit Date (CSE.XD) or the Exit Date is in the future. For the TELPAS Alternate, a student must also be coded as Emergent Bilingual (EB) on the Special Programs page (PGM.CD = 148).
Language Assessment ↑
Two fields on the Language Assessment page will be extracted for students if existing: Students with Interrupted Formal Education (SIFE) and Years in US Schools. Both fields are reported in the TELPAS and TELPAS Alternate extracts.
Texas Assessment Precode Extracts ↑
Filter Pages by "precode" or navigate to School Info > Imports and Exports > Texas Assessment Precode Extracts (currently in BETA status).
The Texas Assessment Precode Extracts page contains four tabs: Schools, Courses, Create Extract, and Compare Run Data. At the bottom of the page, a list contains the created extracts.
On the Schools tab, select each school whose students should be included in the extract that will be created and click Save to save your selections:
The Default button will restore the default set of schools (any school not tagged as DNR for Do Not Report on School Options). The All/None buttons will check all/none of the schools, respectively.
After schools have been selected, click Save at the bottom of the tab:
An informational message will be displayed at top right of the tab:
Click Next to continue.
The Courses tab contains two horizontal tabs: Subject Areas/Departments and Courses. The Subject Areas/Departments tab is used to select corresponding groups of courses for the STAAR End-of-Course (EOC) subject test. After the groups of courses are selected, individual courses will be selected next. Subject Area and Department fields are tagged on the Courses page for each course. Subject Area is based on the Subject Area Code field CRS.S1 and Department is the Dept field CRS.DC.
Select whether the lists should be displayed by Subject Area or Department (depending upon your school's practices) and then select the correct Subject Area or Department for each of the four subjects: Math (Algebra I and II), English (I, II, and III), Biology, and US History.
After selections have been made, click Save Subject Areas/Departments at the bottom of the tab.
An information message will appear at the top right of the tab:
Click Next to continue to the Courses tab:
The Courses tab will display all courses in the corresponding Subject Area or Department selected on the Subject Area/Departments tab. Check the checkbox by each course whose students should be included in the corresponding STAAR EOC extract:
Click Save Course Settings at the bottom of the tab to save the selections.
An information message will be displayed at the top right of the tab:
Click Next to continue to the Create Extract tab:
On the Create Extract tab, select the extract that should be created. The December STAAR End-of-Course Eligibility and the June STAAR End-of-Course Eligibility layouts should be used to identify the students taking December or June EOC tests in the 2023-2024 testing administration.
If selected, Honor Reporting Home School will make students roster in their Reporting Home School (STU.HS on Demographics - Student Data 2) instead of the school where they are currently enrolled.
After selecting the extract to create, click Create Precode File.
When the file has completed processing, it will appear in File Download list:
Click the download button to download the csv file.
Click the Compare Run Data tab to run a comparison of existing Precode extract files (PRE table data) against student data in Aeries. This allows you to identify if any student demographic information has changed since the precode file was sent to the vendor so that it can be updated.
The Compare Run Data tab contains two horizontal tabs:
- Texas Assessment Precode Comparison Filter - Make selections for the comparison
- Texas Assessment Precode Comparison Results - View the comparison results. This heading is not displayed until there are comparison results to view.
From the Texas Assessment Precode Comparison Filter horizontal tab:
- Specify the comparison criteria:
- (Required) Test Administration - Select the test administration (PRE.TID). The drop-down list includes test administrations that have been extracted and stored in PRE. The file must contain at least one student record.
- (Required) Comparison Run - Select the date on which the extract file was created (PRE.RD).
- Grade Level - Only grade levels stored in PRE that are associated with the selected test administration are listed. Select a grade level, or leave it set to the default to select all applicable grade levels.
- If you selected an EOC Test Administration, the EOC Type field will display the list of corresponding EOC tests. Select the appropriate test type, or leave blank to include all test types.
- Only Differences - Select to see only records where the PRE data is inconsistent with the data stored in Aeries. If not selected, all records are listed, and differing records are highlighted.
If the extract file contains a large number of records, it is recommended that you select Only Differences; otherwise the process will take a lot of time.
- Click Run Comparison.
The Texas Assessment Precode Comparison Results section appears and results are displayed.
If you selected Only Differences, only students whose data has changed are listed. Otherwise, all students are listed and changed records are highlighted.- For each student listed, the top row displays the data in Aeries. The bottom row displays extracted data.
- The row is highlighted if any data element differs between the two.
- The differing element is highlighted.
Student Registration File Format ↑
The Data File Format for Student Registration file layout is provided at the Texas Assessment website. The file is a comma-delimited .csv file, so while the file can be viewed in Excel for convenience, editing or saving the file using Excel may have unintended consequences and should be avoided for files that will be submitted.
Available mappings to tables and fields in Aeries for the fields in the Student Registration file are provided below. Existing code translations will be used, if applicable. Required fields are identified in the Notes column.
Excel Column Letter | Numerical Column Order | Header Label from Data File Format for Student Registration | Aeries Table and Field, if applicable | Acceptable Values if specified in Data File Format | Notes |
A | 1 | TSDS ID | STU.CID | Unique ID; required | |
B | 2 | Enrolled District ID | LOC.DC + LOC.CC | Required | |
C | 3 | Enrolled Campus ID | LOC.DC + LOC.CC + LOC.SC | Required | |
D | 4 | Testing District ID | Not currently loaded | ||
E | 5 | Testing Campus ID | Not currently loaded | ||
F | 6 | Last Name | STU.LN | Required | |
G | 7 | First Name | STU.FN | Required | |
H | 8 | Middle Name | STU.MN | ||
I | 9 | Gender | STU.GN | M/F/blank | |
J | 10 | Birthdate | STU.BD | MMDDYYYY | Required |
K | 11 | Grade Level Code | EE/PK/KG/01/02/03/ 04/05/06/07/08/09/ 10/11/12/OS | Required | |
L | 12 | PEIMS ID | ESD.ED | ||
M | 13 | Local Student ID | STU.ID | ||
N | 14 | Hispanic Latino Code (ETH) | STU.ETH | Y/N/blank | |
O | 15 | American Indian Alaska Native Code (I) | STU.RC1-5 = 01 | Y/N/blank | |
P | 16 | Asian Code (A) | STU.RC1-5 = 02 | Y/N/blank | |
Q | 17 | Black African American Code (B) | STU.RC1-5 = 03 | Y/N/blank | |
R | 18 | Native Hawaiian Pacific Islander Code (P) | STU.RC1-5 = 04 | Y/N/blank | |
S | 19 | White Code (W) | STU.RC1-5 = 05 | Y/N/blank | |
T | 20 | Emergent Bilingual Indicator Code (EL) | PGM.TY if PGM.CD = 148 | 1/F/S/3/4/5/0 | For TELPAS and TELPAS Alternate, 1 is the only valid value. For all other extracts, the value will default to 0 if no data exists for the student. |
U | 21 | Bilingual Program Type Code (B) | PGM.TY if PGM.CD = 146 | 2/3/4/5/0 | Value will default to 0 if no data exists for the student. |
V | 22 | ESL Program Type Code (ESL) | PGM.TY if PGM.CD = 147 | 2/3/0 | Value will default to 0 if no data exists for the student. |
W | 23 | Migrant Indicator Code (MS) | PGM.CD = 135 | Y/N/blank | Value will default to N if no data exists for the student. |
X | 24 | Years in U.S. Schools | LAC.YUS | 1-6 | Language Assessment Page > Other Information > Yrs in US Schls. Applicable for TELPAS and TELPAS Alternate only. |
Y | 25 | Parental Denial Code | PGM.PP if PGM.CD = 145 or 146 or 147 | Y/N/blank | Applicable for TELPAS and TELPAS Alternate only. Value will default to N if no data exists for the student. |
Z | 26 | Unschooled Asylee/Refugee Code | PGM.CD = 406 and PGM.TY = 1/2 | Y/N/blank | Applicable for TELPAS and TELPAS Alternate only. Value will default to N if no data exists for the student. |
AA | 27 | Student with Interrupted Formal Education Code | LAC.IFE | Y/N/blank | Language Assessment Page. Applicable for TELPAS and TELPAS Alternate only. Value will default to N if no data exists for the student. |
AB | 28 | High School Equivalency Program (HSEP) | Y/N/blank | Not currently loaded | |
AC | 29 | Texas Migrant Interstate Program (TMIP) | Y/N/blank | Not currently loaded | |
AD | 30 | New to Texas | Y/N/blank | Not currently loaded | |
AE | 31 | Special Ed Indicator Code (SE) | CSE.DI | Y/N/blank | The CSE record must have a Disability Code (CSE.DI) and must be active (CSE.XD is NULL or after the current date). Value will default to N if no data exists for the student. |
AF | 32 | Section 504 Indicator Code | FOF or PGM.CD = 101 | Y/N/blank | Field is now being populated on the extracts, beginning 2023-2024. Value will default to N if no data exists for the student. |
AG | 33 | Gifted Talented Indicator Code (G/T) | GTE record in current year or PGM.CD = 127 | Y/N/blank | Value will default to N if no data exists for the student. |
AH | 34 | Economic Disadvantage Code (ED) | Current FRE.CD record | 1/2/9/0 | Value will default to 0 if no data exists for the student. |
AI | 35 | Title I Part A Indicator Code (TIA) | LOC.TI <> 01 or PGM.TY when PGM.CD = 121 or 122; or LOC.T1 | 6/7/8/9/0 | Value will default to 0 if no data exists for the student. |
AJ | 36 | At-Risk Indicator (AR) | PGM.CD = 409 | Y/N/blank | Value will default to N if no data exists for the student. |
AK | 37 | TELPAS Alternate | CSE.PA2 = Y | Y/N/blank | Special Education page > General tab > Test Participation The CSE record must have a Disability Code (CSE.DI) and must be active (CSE.XD is NULL or after the current date) |
AL | 38 | STAAR Alternate 2 | CSE.PA2 = Y | Y/N/blank | Special Education page > General tab > Test Participation The CSE record must have a Disability Code (CSE.DI) and must be active (CSE.XD is NULL or after the current date) |
AM | 39 | STAAR Alternate 2 EOC Eligibility - Algebra I | STS.CD | Y/N/blank | |
AN | 40 | STAAR Alternate 2 EOC Eligibility - Biology | STS.CD | Y/N/blank | |
AO | 41 | STAAR Alternate 2 EOC Eligibility - English I | STS.CD | Y/N/blank | |
AP | 42 | STAAR Alternate 2 EOC Eligibility - English II | STS.CD | Y/N/blank | |
AQ | 43 | STAAR Alternate 2 EOC Eligibility - U.S. History | STS.CD | Y/N/blank | |
AR | 44 | STAAR 3-8 Above Grade - Mathematics | STS.CD | 03/04/05/06/07/08 | |
AS | 45 | STAAR 3-8 Above Grade - RLA | STS.CD | 03/04/05/06/07/08 | |
AT | 46 | STAAR 3-8 Above Grade - Science | STS.CD | 05/08 | |
AU | 47 | STAAR 3-8 Above Grade - Social Studies | STS.CD | 08 | |
AV | 48 | December EOC Eligibility - Algebra I | STS.CD | Y/N/blank | |
AW | 49 | December EOC Eligibility - Biology | STS.CD | Y/N/blank | |
AX | 50 | December EOC Eligibility - English I | STS.CD | Y/N/blank | |
AY | 51 | December EOC Eligibility - English II | STS.CD | Y/N/blank | |
AZ | 52 | December EOC Eligibility - U.S. History | STS.CD | Y/N/blank | |
BA | 53 | Spring EOC Eligibility - Algebra I | Based on Classes (SEC) | Y/N/blank | |
BB | 54 | Spring EOC Eligibility - Biology | Based on Classes (SEC) | Y/N/blank | |
BC | 55 | Spring EOC Eligibility - English I | Based on Classes (SEC) | Y/N/blank | |
BD | 56 | Spring EOC Eligibility - English II | Based on Classes (SEC) | Y/N/blank | |
BE | 57 | Spring EOC Eligibility - U.S. History | Based on Classes (SEC) | Y/N/blank | |
BF | 58 | June EOC Eligibility - Algebra I | STS.CD | Y/N/blank | |
BG | 59 | June EOC Eligibility - Biology | STS.CD | Y/N/blank | |
BH | 60 | June EOC Eligibility - English I | STS.CD | Y/N/blank | |
BI | 61 | June EOC Eligibility - English II | STS.CD | Y/N/blank | |
BJ | 62 | June EOC Eligibility - U.S. History | STS.CD | Y/N/blank | |
BK | 63 | Field for Local Use 1 | 0-9/blank | ||
BL | 64 | Field for Local Use 2 | 0-9/blank | ||
BM | 65 | Field for Local Use 3 | 0-9/blank | ||
BN | 66 | Field for Local Use 4 | 0-9/blank | ||
BO | 67 | Action | ADD/DELETE/blank |