Overview

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.


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 are recorded and displayed on each student's Test Settings page. The Test Settings page includes two horizontal tabs and three vertical tabs. The horizontal tabs are Active Test Settings and Test Settings List (all). Accommodations can be quickly entered on the Active Test Settings tab, which will only display currently active accommodations. Accommodations and their settings (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 three vertical tabs (STAAR Grades 3-8, STAAR End-of-Course (EOC), and TELPAS) can each be expanded or closed with by clicking the chevronicon 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.



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 iconand the accommodations and/or their Start Dates and End Dates can be edited. An accommodation can also be deleted using the trashcanicon.


An accommodation 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. 



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
B2Current District CodeLOC.DC + LOC.CC
Required
C3Current Campus CodeLOC.DC + LOC.CC + LOC.SC

Required 
D4Last NameSTU.LN
Required 
E5First NameSTU.FN
Required
F6Middle NameSTU.MN

G7GenderSTU.GNM/F/blank
H8Date of BirthSTU.BDMMDDYYYYRequired
I9PEIMS-IDESD.ED

J10HISPANIC-LATINO-CODE (ETH)STU.ETHY/N/blank
K11AMERICAN-INDIAN-ALASKA-NATIVE-CODE (I)STU.RC1-5 = 01Y/N/blank 
L12ASIAN-CODE (A)STU.RC1-5 = 02Y/N/blank
M13BLACK-AFRICAN-AMERICAN-CODE (B)STU.RC1-5 = 03Y/N/blank
N14NATIVE-HAWAIIAN-PACIFIC-ISLANDER-CODE (P)STU.RC1-5 = 04Y/N/blank
O15WHITE-CODE (W)STU.RC1-5 = 05Y/N/blank
P16Entry / Exit Date (all entry / exit dates)not currently extracted


Q17Entry / Exit Type ( all entry / exit types)not currently extracted

R18Grade Level CodeSTU.GREE/PK/KG/01/02/03/
04/05/06/07/08/09/
10/11/12/OS 
Required
S19District NameLOC.NM for district

T20Campus NameLOC.NM for school

U21ECONOMIC-DISADVANTAGED-CODE (ED)Current FRE.CD record

1/2/9/0


V22TITLE-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


W23MIGRANT-INDICATOR-CODE (MS)PGM.CD = 135Y/N/blank
X24LEP-INDICATOR-CODE (L)STU.LF

1/F/S/3/4/5/0

For TELPAS and TELPAS Alternate, 1 is the only valid value.
Y25BILINGUAL-PROGRAM-TYPE-CODE (B)PGM.TY if PGM.CD = 146

2/3/4/5/0 


Z26ESL-PROGRAM-TYPE-CODE (ESL)PGM.TY if PGM.CD = 1472/3/0 
AA27SPECIAL-ED-INDICATOR-CODE (SE)CSE.DIY/N

The CSE record must have a Disability Code (CSE.DI) and must be active (CSE.XD is NULL or after the current date)


AB28GIFTED-TALENTED-INDICATOR-CODE (G/T)GTE record in current year or PGM.CD = 127Y/N/blank
AC29AT-RISK-INDICATOR-CODE (AR)PGM.CD = 409Y/N/blank
AD30Field for Local Use 1
0-9/blank
AE31Field for Local Use 2
0-9/blank
AF32Field for Local Use 3
0-9/blank
AG33Field for Local Use 4
0-9/blank
AH34TELPAS AlternateCSE.PA2 = YY/N/blankSpecial 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)

AI35STAAR Alternate 2CSE.PA2 = YY/N/blankSpecial 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)

AJ36CRISIS-CODEPGM.CRI if PGM.CD =  404

AK37STUDENT-ATTRIBUTION-CODESTU.IT

AL38Homeless StatusPGM.HDT if PGM.CD=1910/2/3/4/5
AM39Unaccompanied Youth StatusPGM.UY = 4/3 and PGM.CD = 1913/4
AN40MILITARY-CONNECTED-STUDENT-CODEPGM.TY where PGM.CD = 1920/1/2/3/4/5/6
AO41STUDENT-LANGUAGE-CODESTU.HLmany
AP42FOSTER-CARE-INDICATOR-CODEPGM.TY if PGM.CD = 1900/1/2
AQ43DYSLEXIA-INDICATOR-CODEPGM.CD = 4000/1
AR44LOCAL-STUDENT-IDSTU.ID

AS45YEARS IN U.S. SCHOOLSLAC.YUS1-6Language Assessment Page > Other Information > Yrs in US Schls
AT46PARENTAL DENIAL CODEPGM.PP if PGM.CD = 146 or 147Y/N/blankApplicable for TELPAS and TELPAS Alternate only.
AU47TEST FORMAT - READINGSTS.CDP/OApplicable for STAAR grades 3-8 only
AV48TEST FORMAT - MATHEMATICSSTS.CDP/OApplicable for STAAR grades 3-8 only
AW49TEST FORMAT - SCIENCESTS.CD
P/OApplicable for STAAR grades 3-8 only
AX50TEST FORMAT - SOCIAL STUDIESSTS.CD
P/OApplicable for STAAR grades 3-8 only
AY51TEST FORMAT - Algebra ISTS.CDP/OApplicable for STAAR only
AZ52TEST FORMAT - BiologySTS.CDP/OApplicable for STAAR only
BA53TEST FORMAT - U.S. HistorySTS.CDP/OApplicable for STAAR only
BB54TEST FORMAT - English ISTS.CDP/OApplicable for STAAR only
BC55TEST FORMAT - English IISTS.CDP/OApplicable for STAAR only
BD56TELPAS CodeSTS.CDH/O/A/NMandatory field for TELPAS; Test Settings > Active Test Settings tab > TELPAS tab > TELPAS Code 
BE57UNSCHOOLED ASYLEE/REFUGEE CODEPGM.CD = 406 and PGM.TY = 1/2Y/N/blankApplicable for TELPAS and TELPAS Alternate only
BF58STUDENTS WITH INTERRUPTED FORMAL EDUCATION (SIFE) CODELAC.IFEY/N/blankApplicable for TELPAS and TELPAS Alternate only
BG59HOME COUNTY/DISTRICT/CAMPUS CODESTU.HS
Valid for online tests only. Should only be provided if student is testing at different campus from campus of enrollment.
BH60INTERIM TEST OFF GRADE - Algebra I
Y/N/blankNot currently loaded
BI61INTERIM TEST OFF GRADE - Biology
Y/N/blankNot currently loaded
BJ62INTERIM TEST OFF GRADE - U.S. History
Y/N/blankNot currently loaded
BK63INTERIM TEST OFF GRADE - English I
Y/N/blankNot currently loaded
BL64INTERIM TEST OFF GRADE - English II
Y/N/blankNot currently loaded
BM65INTERIM TEST OFF GRADE - Reading
03/04/05/06/07/08Not currently loaded
BN66INTERIM TEST OFF GRADE - Mathematics
03/04/05/06/07/08Not currently loaded
BO67INTERIM TEST OFF GRADE - Science
05/08Not currently loaded
BP68INTERIM TEST OFF GRADE - Social Studies
08Not currently loaded
BQ69STAAR 3-8 Above Grade - ReadingSTS.CD
04/05/06/07/08
BR70STAAR 3-8 Above Grade - MathematicsSTS.CD
04/05/06/07/08
BS71STAAR 3-8 Above Grade - ScienceSTS.CD
05/08
BT72STAAR 3-8 Above Grade - Social StudiesSTS.CD
08
BU73EOC Flag - Algebra I

Based on Classes (SEC)

Y/N/blank
BV74EOC Flag - English I

Based on Classes (SEC)

Y/N/blank
BW75EOC Flag - English II

Based on Classes (SEC)

Y/N/blank
BX76EOC Flag - Biology

Based on Classes (SEC)

Y/N/blank
BY77EOC Flag - U.S. History

Based on Classes (SEC)

Y/N/blank
BZ78Action
ADD/DELETE/blank