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 2022-2023 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 LEP on the Demographics page. 


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 2022-2023 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 CodeLOC.DC + LOC.CC
Required
C3Enrolled Campus CodeLOC.DC + LOC.CC + LOC.SC

Required 
D
4Testing District Code

Not currently loaded
E5Testing Campus Code

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
STU.LF1/F/S/3/4/5/0For TELPAS and TELPAS Alternate, 1 is the only valid value.
U21BILINGUAL PROGRAM TYPE CODE (B)
PGM.TY if PGM.CD = 146
2/3/4/5/0

V22ESL PROGRAM TYPE CODE (ESL)
PGM.TY if PGM.CD = 147
2/3/0

W23MIGRANT INDICATOR CODE (MS)
PGM.CD = 135
Y/N/blank

X24YEARS IN U.S. SCHOOLS
LAC.YUS
1-6
Language Assessment Page > Other Information > Yrs in US Schls
Y25PARENTAL DENIAL CODE
PGM.PP if PGM.CD = 145 or 146 or 147
Y/N/blank
Applicable for TELPAS and TELPAS Alternate only.
Z26UNSCHOOLED ASYLEE/REFUGEE CODE
PGM.CD = 406 and PGM.TY = 1/2
Y/N/blank
Applicable for TELPAS and TELPAS Alternate only
AA27High School Equivalency Program (HSEP)
Y/N/blank

Not currently loaded
AB28Texas Migrant Interstate Program (TMIP)

Y/N/blank

Not currently loaded
AC29New to Texas
Y/N/blank

Not currently loaded
AD30SPECIAL 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)

AE31Section 504 Indicator Code
Y/N/blank


AF32GIFTED TALENTED INDICATOR CODE (G/T)
GTE record in current year or PGM.CD = 127
Y/N/blank

AG33ECONOMIC DISADVANTAGED CODE (ED)
Current FRE.CD record

1/2/9/0



AH34TITLE 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



AI35AT RISK INDICATOR CODE (AR)
PGM.CD = 409
Y/N/blank

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


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


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

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

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

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

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

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

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


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

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

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

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

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

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

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

AZ52Spring EOC Eligibility - Algebra I
Based on Classes (SEC)Y/N/blank

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

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

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

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

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

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

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

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

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

BJ62Field for Local Use 1
0-9/blank
BK63Field for Local Use 2
0-9/blank
BL64Field for Local Use 3
0-9/blank
BM65Field for Local Use 4
0-9/blank
BN66INTERIM TEST GRADE - Algebra I
Y/N/blankNot currently loaded
BO67INTERIM TEST GRADE - Biology
Y/N/blankNot currently loaded
BP68INTERIM TEST GRADE - English I
Y/N/blankNot currently loaded
BQ69INTERIM TEST GRADE - English II
Y/N/blankNot currently loaded
BR70INTERIM TEST GRADE - U.S. History

Y/N/blank
Not currently loaded

BS
71INTERIM TEST GRADE - Mathematics

03/04/05/06/07/08
Not currently loaded

BT72
INTERIM TEST GRADE - Reading
03/04/05/06/07/08Not currently loaded
BU73
INTERIM TEST GRADE - Science
05/08Not currently loaded
BV74
INTERIM TEST GRADE - Social Studies
08Not currently loaded
BW75Action
ADD/DELETE/blank