Security 

Test Settings 

Active Test Settings

Test Settings List (all) Tab

Special Education Alternate Assessment Qualification

Language Assessment

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 AreaAdministerConfigure 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)ReadTo 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:


Test Settings - no records


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:


Test Settings - a few records, read mode


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 LetterNumerical Column OrderHeader Label from Data File Format for Student RegistrationAeries Table and Field, if applicableAcceptable Values 
if specified 
in Data File Format
Notes
A1TSDS IDSTU.CID
Unique ID; required
B2Enrolled District IDLOC.DC + LOC.CC
Required
C3Enrolled Campus IDLOC.DC + LOC.CC + LOC.SC

Required 
D
4Testing District ID

Not currently loaded
E5Testing Campus ID

Not currently loaded
F6Last NameSTU.LN
Required 
G7First NameSTU.FN
Required
H8Middle NameSTU.MN

I
9GenderSTU.GNM/F/blank
J10Birthdate
STU.BDMMDDYYYYRequired
K11Grade Level Code
EE/PK/KG/01/02/03/
04/05/06/07/08/09/
10/11/12/OS
Required
L12PEIMS IDESD.ED

M13Local Student IDSTU.ID

N14Hispanic Latino Code (ETH)STU.ETHY/N/blank
O15American Indian Alaska Native Code (I)STU.RC1-5 = 01Y/N/blank 
P16Asian Code (A)STU.RC1-5 = 02Y/N/blank
Q17Black African American Code (B)STU.RC1-5 = 03Y/N/blank
R18Native Hawaiian Pacific Islander Code (P)STU.RC1-5 = 04Y/N/blank
S19White Code (W)STU.RC1-5 = 05Y/N/blank
T
20Emergent Bilingual Indicator Code (EL)
PGM.TY if PGM.CD = 1481/F/S/3/4/5/0For 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.
U21Bilingual 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.
V22ESL 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.
W23Migrant Indicator Code (MS)
PGM.CD = 135
Y/N/blank
Value will default to N if no data exists for the student.
X24Years in U.S. Schools
LAC.YUS
1-6
Language Assessment Page > Other Information > Yrs in US Schls. Applicable for TELPAS and TELPAS Alternate only.
Y25Parental 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.
Z26Unschooled 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.
AA27 Student with Interrupted Formal Education CodeLAC.IFEY/N/blankLanguage Assessment Page.
Applicable for TELPAS and TELPAS Alternate only.
Value will default to N if no data exists for the student.
AB28High School Equivalency Program (HSEP)
Y/N/blank

Not currently loaded
AC29Texas Migrant Interstate Program (TMIP)

Y/N/blank

Not currently loaded
AD30
New to Texas
Y/N/blank

Not currently loaded
AE31Special 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.

AF32Section 504 Indicator CodeFOF 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.
AG33Gifted 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.
AH34Economic Disadvantage Code (ED)
Current FRE.CD record

1/2/9/0


Value will default to 0 if no data exists for the student.
AI35Title 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.
AJ36At-Risk Indicator  (AR)
PGM.CD = 409
Y/N/blank
Value will default to N if no data exists for the student.
AK37TELPAS 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)


AL38STAAR 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)


AM39STAAR Alternate 2 EOC Eligibility - Algebra I
STS.CD
Y/N/blank

AN40
STAAR Alternate 2 EOC Eligibility - Biology
STS.CD
Y/N/blank

AO41STAAR Alternate 2 EOC Eligibility - English I
STS.CD
Y/N/blank

AP42STAAR Alternate 2 EOC Eligibility - English II
STS.CD
Y/N/blank

AQ43STAAR Alternate 2 EOC Eligibility - U.S. History
STS.CD
Y/N/blank

AR44STAAR 3-8 Above Grade - Mathematics
STS.CD
03/04/05/06/07/08

AS45STAAR 3-8 Above Grade - RLA
STS.CD
03/04/05/06/07/08


AT46STAAR 3-8 Above Grade - Science
STS.CD
05/08

AU47STAAR 3-8 Above Grade - Social Studies
STS.CD
08

AV48December EOC Eligibility - Algebra ISTS.CD
Y/N/blank

AW49December EOC Eligibility - Biology
STS.CD
Y/N/blank

AX50
December EOC Eligibility - English I
STS.CD
Y/N/blank

AY51December EOC Eligibility - English II
STS.CD
Y/N/blank

AZ52December EOC Eligibility - U.S. History
STS.CD
Y/N/blank

BA
53Spring EOC Eligibility - Algebra I
Based on Classes (SEC)Y/N/blank

BB54Spring EOC Eligibility - Biology
Based on Classes (SEC)Y/N/blank

BC55Spring EOC Eligibility - English I
Based on Classes (SEC)Y/N/blank

BD56Spring EOC Eligibility - English II
Based on Classes (SEC)Y/N/blank

BE57Spring EOC Eligibility - U.S. History
Based on Classes (SEC)Y/N/blank

BF58June EOC Eligibility - Algebra I
STS.CD
Y/N/blank

BG59June EOC Eligibility - Biology
STS.CD
Y/N/blank

BH60
June EOC Eligibility - English I
STS.CD
Y/N/blank

BI61June EOC Eligibility - English II
STS.CD
Y/N/blank

BJ62June EOC Eligibility - U.S. History
STS.CD
Y/N/blank

BK63Field for Local Use 1
0-9/blank
BL64Field for Local Use 2
0-9/blank
BM65Field for Local Use 3
0-9/blank
BN66Field for Local Use 4
0-9/blank
BO67
Action
ADD/DELETE/blank