TREx Extract (Texas)

Last Modified on 10/22/2022 10:38 am CDT

Classic View: Student Information > General > TREx Extract

Search Terms: TREx

TREx is a web-based application hosted by the Texas Education Agency (TEA) for transferring student records electronically between Texas public school districts and open enrollment charter schools, as well as transmitting high school transcripts to Texas public colleges and universities that use the UT SPEEDE server.

TREx Extract

Record Types

Student Report (SR) - This report is an individual student record sent between one Texas public school district/campus and another Texas public school district/campus.
- If a student drops a section and then re-enrolls, only one grade reports. A withdrawal grade is not reported for sections where the student re-enrolls at a later date within the reporting window.
- The following are excluded:
  - Calendar State Exclude
  - Grade Level State Exclude
  - Enrollment State Exclude
  - Lack of a State ID / Student State ID
- Reported enrollment records are looked at in this order:
  1. “P” Primary Enrollment
  2. “S” Partial Enrollment
  3. “N” Special Ed Enrollment
  4. If there are no active year enrollment records, the most recent “P” Primary Enrollment Record
- No Show enrollments can be selected if they meet all other reporting criteria.
Academic Achievement Record (AAR) - This is the official high school transcript or academic achievement record (AAR) for grades 9-12. This transcript is an official and permanent record of a student's academic performance during high school and, in some cases, of high school courses completed in middle school or junior high school.
Student Withdrawal/Record Transfer Form - This form is used by students transferring from one Texas district to another Texas district. It provides preliminary enrollment information for the district to which the student is transferring. It is followed-up by the formal electronic SR which has complete transfer information for each student.
- If a student has an applicable assessment on their record the most recently taken assessment will report in the Most Recent State Standardized Test Results section on the Withdrawal form.
- The LEP field will report "yes" if the student has an active EL status at the time of reporting. If the student's first or second year monitoring status is Existed, the LEP field reports "No."
- The student will report "yes" for Special Education if they have an active and locked IEP in Student Information > Special Ed > Documents.
- If the student has a Grading Task of CG or F in any in-progress course in their current schedule that grade will report in the Current Six Weeks Grade section of the withdrawal form.
- If no CG or F grading task is available, the most recent six/nine weeks grade reports regardless of the code on the grading task. If neither is available, the course with "Incomplete" for the grade reports.

Generate the Academic Achievement Record (AAR)

Mark the Academic Achievement Record (AAR) radio button.

TREx Extract Editor
Enter the Effective Date. Student record information as of this date reports.
Select Exclude Class Rank Data (optional). If selected, Class Rank and Class Rank Date will not report.
Click the Generate Report button. The report appears in a separate window in XML format.

Generate the Student Record (SR)

Mark the Student Report (SR) radio button.
Select the Enrollment used for reporting data in the extract. Grade, Type, Calendar, Start Date, and End Date data will auto-populate based on the enrollment record selected.
No Show enrollment records are available for selection if they meet report criteria.
Enter an Effective Date. Student record information as of this date reports.
Enter the Withdrawal Date.
Select an End Status value. The value selected here will be reported in the Withdrawal Reason field on the report.
Click the Generate Report button.The report appears in a separate window in XML format.

Generate the Student Withdrawal/Record Transfer Form

Mark the Student Withdrawal/Record Transfer Form radio button.
Select the Enrollment used for reporting data in the extract.
Enter an Effective Date. Student record information as of this date reports.
Select a Report Format of PDF or DOCX.
Click the Generate Report button. The report appears in a separate window in the designated format.

Current Six Weeks Grades Logic

The following logic is used to determine report Six Weeks Grades on the Withdrawal Form:

Determine which Term the Effective Date entered on the extract editor falls into.
Find all Course/Sections the student is enrolled in during that Term.
Find all Terms tied to that Course/Section.
Only consider terms that contain the Effective Date or prior and are tied to the section.
Do not consider courses that have been completed prior to the Effective Date (i.e., the Course End Date is prior to the Effective Date).
For each Period, report the most recent grade.
- Report the grade from the Grading Task marked CG/F with a Pass/Fail Indicator.
- If there is no Grading Task as described in the previous bullet point, report the most recent Grading Task whose name starts with 'Six' or 'Nin' and contains a score and report this score.
- If neither of these scenarios elicits more than one applicable grading task, use the most recently entered score.
- If none of the bullet points above apply, report all Course/Sections with a grade of 'Incomplete'.

Viewing a Student's TREx Upload History

You can view a student's TREx import history by clicking the View History link. When selected, a breakdown of all data within the import file displays in a separate window, identifying which pieces of data were imported.

This list is populated by TREx data imported via the TREx Import tool.

Viewing a Student's Import History

Understanding the SR and AAR Report XML

The following tables describe each object reported in TREx extracts.

Student Identification

Student Identification Object

Data Element	Description	Location
StudentUniqueID	The unique number assigned to the student by the Texas Education Agency. Report: SR	Census > People > Demographics > Person Information > Unique State ID
Name
Name/FirstName	The first name of the student reporting data. Only one student's first name may be associated with a record. Report: SR AAR	Census > People > Demographics > Person Information > First Name
Name/MiddleName	The middle name or initial of the reporting student. Only one student's first name may be associated with a record. If there is no middle name, reports element as NULL. Report: SR AAR	Census > People > Demographics > Person Information > Middle Name
Name/LastName	The last name of the reporting student. Report: SR AAR	Census > People > Demographics > Person Information > Last Name
Name/Suffix	The generation suffix attached to the student's name. The only acceptable value is a single character in a rank from 1 to 9 OR A-C. Suffix code values: JR = 1, SR - 2, I = A, II = 3, III = 4, IV = 5, V = 6, VI = 7, VII = 8, VIII = 9, IX = B, X = C Report: SR AAR	Census > People > Demographics > Person Information > Suffix
PriorID	The identification number under which the student was reported in the past if that number has since changed. Not currently reported.
LocalID	The student's local identification number as assigned by the district and used only within that district for identification. If Local Student Number is null, this element will not report. Report: SR AAR	Census > People > Demographics > Person Identifiers > Local Student Number
Address
Address/Address	Indicates the street address information for the student. If the student has multiple addresses or households, the primary household's street address is reported. If the student has two primary addresses and one is a PO Box, the non-PO box primary address is reported. If the student has two primary addresses and neither are PO boxes, the address that comes first in the table is reported. Report: SR AAR	Census > People > Address
Address/City	Indicates the name of the city in which the student resides. If the student has multiple addresses or multiple households, only the primary household's city is reported. If City is blank, this element is reported as blank. Report: SR AAR	Census > People > Address > City
Address/ StateProvince	Indicates the state in which the student resides. If State is blank, a value of TX is reported. Report: SR AAR	Census > People > Address > State
Address/PostalCode	Indicates the zip in which the student resides. Report: SR AAR	Census > People > Demographics > Person Information > Zip

Parent

Parent Object

SIF Data Element	Description	Location
Name
Name/FirstName	The first name of the student's parent/guardian. May be repeated for more than one parent/guardian in a student record. Only report records identified as a parent/guardian. The primary parent/guardian is reported first. If the guardian record has any naming data, then both FirstName and LastName must be reported. If no guardian record naming data exists, then ParentType will not report at all. Report: SR AAR	Census > Households > Parent/Guardian > First Name
Name/MiddleName	The middle name of the student's parent/guardian. May be repeated for more than one parent/guardian in a student record. Only report records identified as a parent/guardian. The primary parent/guardian is reported first. If there is no parent/legal guardian data, report element as NULL. Report: SR AAR	Census > Households > Parent/Guardian > Middle Name
Name/LastName	The last name of the student's parent/guardian. May be repeated for more than one parent/guardian in a student record. Only report records identified as a parent/guardian. The primary parent/guardian is reported first. If the guardian record has any naming data, then both FirstName and LastName must be reported. If no guardian record naming data exists, then ParentType will not report at all. Report: SR AAR	Census > Households > Parent/Guardian > Last Name
Name/Suffix	The suffix of the student's parent/guardian. The only acceptable value is a single character in a rank from 1 to 9 OR A-C. Suffix code values: JR = 1, SR - 2, I = A, II = 3, III = 4, IV = 5, V = 6, VI = 7, VII = 8, VIII = 9, IX = B, X = C. Report: SR AAR	Census > Households > Parent/Guardian > Suffix

Student Demographic

Student Demographic Object

SIF Data Element	Description	Location
Gender	The gender of the reporting student. Report: SR AAR	Census > People > Demographics > Person Information > Gender
Race	The reporting student's ethnic origin. Ethnicity is an optional element, but if any race data exists, then all ethnicities must be reported (as "0" or "1", with "0" = NULL and "1" = Yes). Report: SR AAR	Census > People > Demographics > Person Information > State Race Ethnicity
Ethnicity	The reporting student's race ethnicity. If Is the student Hispanic/Latino = Yes, a value of 1 is reported. Separate data elements are reported for each of the student's race ethnicities. Report: SR AAR	Census > People > Demographics > Race/Ethnicity
BirthDate	The reporting student's date of birth. The only acceptable value is a valid date with a minimum value greater than or equal to 1957-01-01 and less than 2040-01-01. Report: SR AAR	Census > People > Demographics > Person Information > Birth Date
Home Language	The language spoken in the student's home, as determined by the student's home language survey. The student's Home Language Code from their most current identity is reported. Otherwise, the two-digit State Code is reported. Report: SR	Census > People > Demographics > Home Primary Language
Home Language Survey Date Administered	Indicates the date the original Home Language Survey was administered to a student upon initial enrollment in a Texas public school. Report: SR	Census > People > Demographics > Home Language Survey Date
Migrant	Indicates that the student, student's parent, spouse or guardian has a Migrant Status. A value of 1 is reported if the Migrant checkbox is marked on the student's enrollment record. Report: SR	Student Information > General > Enrollments > State Reporting Fields > Migrant
Homeless	Indicates whether the student is homeless. If the student has a Homeless record with a Homeless Nighttime Residence value of 1, 2, 3, or 4 with at least one day in the reporting window, then 1 reports. Otherwise, 0 reports. If multiple records exist, then the most recent record reports. Report: SR	Student Information > Program Participation > Homeless > Homeless Nighttime Residence
Student Language	Indicates the language spoken by the student most of the time, as determined by the student’s home language survey. Report: SR	Census > People > Demographics > Student Primary Language
Dyslexia	Indicates whether a student is identified as having dyslexia or related disorders. 1 reports if a student has a an active dyslexia record on the Effective Date with a Dyslexia Indicator = 1 (Yes). Nothing reports if Dyslexia Indicator = 0 (No). Only the most recently entered record reports when multiple dyslexia records exist. Report: SR	Student Information > General > Enrollments > State Reporting Fields > Dyslexia Indicator Code
DyslexiaRiskCode	If student's grade level is KG or 01 AND the student has an active Dyslexia record with a Dyslexia Risk Code containing a value, then report that value. If no value, report 03. If multiple applicable Dyslexia records exist, only the most recent record reports. All others, do not report. Report: SR	Student Information > Program Participation > State Program > Dyslexia
Military Connected	Indicates a student enrolled in a school district or open-enrollment charter school who is a dependent of a member of the United States military service in the Army, Navy, Air Force, Marine Corps, or Coast Guard on active duty, the Texas National Guard, or a reserve force of the United States military. Report: SR	Student Information > General > Enrollments > State Reporting Fields > Military Connected Student Code
Foster Care	Indicates whether a student is currently or previously in the conservatorship of the Department of Family and Protective Services (DFPS). If the student has a Foster Care record with at least one day within the reporting window then the Foster Care Indicator Code reports. If multiple records meet this criteria, then the code reports from the most recent record. 0 - Not in the conservatorship of DFPS 1 - In the conservatorship of DFPS 2 - PK previously in the conservatorship of DFPS Report: SR	Student Information > Program Participation > Foster Care > Foster Care Indicator Code
Homeless/ AsyleeRefugeeCode	Indicates whether a student's initial enrollment in a school in the United States in grades 7 through 12 was as an unschooled asylee or refugee. Report: SR	Census > People > Demographics > Person Information > Asylee Refugee
CrisisCode
CrisisCodeCode	If student has a Crisis Event record that is active at any time during the reporting period, report the code. Repeat for additional codes. Report: SR	Student Information > Program Participation > State Programs > Crisis Event
PkEligiblePreviousYear	If student is PK AND... PK Eligible Previous Year box is checked, 1 reports. PK Eligible Previous Year box is not checked, 0 reports. Otherwise, field does not report. Report: SR	Student Information > General > Enrollments > State Reporting Fields > PK Eligible Previous Year

School

School Object

SIF Data Element	Description	Location
SchoolID	Indicates the unique campus identification number registered with the Texas Education Agency. Report County-District number (6 digits) + State School Number (3 digits) of the campus/school where the teacher performs their services. Report: SR AAR	System Administration > Resources > School > School Detail > State School Number System Administration > Resources > District Information > State District Number
SchoolName	The name of the campus registered with the Texas Education Agency. Report: SR AAR	System Administration > Resources > School > School Detail > Name
DistrictID	Indicates the district Identification number registered with the TEA. Report: SR AAR	System Administration > Resources > District Information > State District Number
DistrictName	Identifies the name of the school district as registered with the Texas Education Agency. NOTE: The District Name cannot be longer than 34 characters. Any characters beyond 34 characters will be truncated from the right. Report: SR AAR	System Administration > Resources > District Information > Name
Address
Address/Address	The address of the campus from the student's most current enrollment. Report: SR AAR	System Administration > Resources > School > School Detail > Address
Address/City	The name of the city in which the campus/school resides. If City is blank, this element is reported as blank. Report: SR AAR	System Administration > Resources > School > School Detail > City
Address/StateProvince	The name of the state in which the campus/school resides. If State is blank, a value of TX is reported. Report: SR AAR	System Administration > Resources > School > School Detail > State
Address/Country	The country in which the campus/school resides. Default value reports as US. Report: AAR	System Administration > Resources > School > School Detail > Country
Address/PostalCode	The zip code of the campus/school reporting data. Report: SR AAR	System Administration > Resources > School > School Detail > Zip
PhoneNumber	The phone number of the school. Report: SR AAR	System Administration > Resources > School > School Detail > Phone Number
Fax	The fax number of the school. Report: SR AAR	System Administration > Resources > School > School Detail > Fax

Enrollment

Enrollment Object

SIF Data Element	Description	Location
GradeLevel	Indicates the current grade level (EE, PK - 12) of the student. Reports the students Grade Level from the enrollment and the associated State Grade Level code. AAR reports if the student has not graduated; i.e.; the Graduation Date is after the extract effective date or null. Report: SR AAR	Student Information > General > Enrollments Tab > General Enrollment Information > Grade OR Enrollment Information > Grade / System Administration > Resources > Grade Level Definitions > Code
EntryDate	Indicates the first day of enrollment for the student at the campus/school that is transferring the student record. Report: SR	Student Information > General > Enrollments Tab > General Enrollment Information > Start Date
ExitDate	Indicates the last day on which the student attended the campus/school that is transferring the student record or transcript. Report: SR	Student Information > General > Enrollments Tab > General Enrollment Information > End Date
Withdraw Date	Indicates the students withdrawal date from the campus/school that is transferring the student record or transcript. Report: SR	Student Information > General > Enrollments Tab > General Enrollment Information > Withdrawal Date
Withdraw Reason	Indicates the reason a student in grades 7-12 withdrew from school. Report: SR	Student Information > General > Enrollments Tab > General Enrollment Information > End Status

Special Programs

Special Programs

SIF Data Element

Description

Location

LEP

Indicates whether the student has been identified as limited English proficient by the Language Proficiency Assessment Committee (LPAC), or English proficient (19 TAC §89.1220), according to criteria established in 19 TAC §89.1225.

If the student has any EL status, as of the effective date of the extract, then the EL value reports. If there are multiple EL records as of the effective date, then a single value reports based on the following:

Not EL = 0
EL = 1
Exited = F, S, 3, 4 or 5

If the EL Program Status as of the extract date is "Exited EL" and the current date is....	Then...
prior or equal to the First Year Monitoring date	F reports
after the First Year Monitoring date, but prior or equal to the Second Year Monitoring date	S reports
after the Second Year Monitoring date, but prior or equal to the Third Year Monitoring date	3 reports
after the Third Year Monitoring date, but prior or equal the Fourth Year Monitoring date	4 reports
after the Fourth Year Monitoring date	5 reports

Pending = 0

Report:
SR

Student Information > Program Participation > English Learners (EL) > EL

Alternative Language

Indicates the type of alternative language program participated in by the student.

If student has an EL Program Status of EL that is active at the time of the report effective date AND has an EL Service record with code AB that is active at the time of the report effective date, then report 01.
If student has an EL Program Status of EL that is active at the time of the report effective date AND has an EL Service record with code AE that is active at the time of the report effective date, then report 02.
If student has multiple applicable services records, report from the record with the most recent effective date.
All others, report 00.

Report:
SR

Student Information > Program Participation > English Learners (EL) > EL > AND EL Services

Dual Language Immersion

Immersion Year

Identifies which number in a series of school years a student is participating in a dual language immersion program.

Report the Immersion Year. If no value exists, report 00.
If no Dual Language record exists, report 00.

Report:
SR

Student Information > Program Participation > State Programs > Dual Language Immersion > Immersion Year

Immersion Language

Indicates the language other than English that the student studied under the dual language immersion program.

Report:
SR

Student Information > Program Participation > State Programs > Dual Language Immersion > Immersion Language

Assessment Met Date

Indicates the date that a student achieved proficiency in both English and a language other than English as demonstrated by scores of proficient or higher in the reading and speaking domains on language proficiency or achievement tests in both languages.

Report:
SR

Student Information > Program Participation > State Programs > Dual Language Immersion > Assessment Met Date

Completion School Year

Indicates the school year the student successfully completed a five-year dual language immersion program offered at an elementary campus.

Report:
SR

Student Information > Program Participation > State Programs > Dual Language Immersion > Date Completed

Economic Disadvantaged

Indicates the student is identified as having being economically-disadvantaged.

If the Code 99 checkbox is marked on the student's enrollment record, a value of 99 is reported.

Otherwise, the student's FRAM Eligibility is identified and a value is reported as follows:

Free = 01
Reduced = 02
Paid = 00
Non-reimbursable = 00

Report:
SR

Student Information > General > Enrollments > State Reporting > Code 99

FRAM > Eligibility

AtRisk

Indicates whether a student is currently identified as at-risk of dropping out of school using state-defined criteria.

A value of 1 is reported if the At-risk checkbox is marked on the student's enrollment record.

Report:
SR

Student Information > General > Enrollment > State Reporting Fields > At Risk

Title1

Indicates whether the student is participating in a program authorized under ESEA, Title I, Part A of the Improving America’s Schools Act.

If Title 1 is selected in the School History tab, this element reports 6 regardless of any Title I records.

If there is no school-wide program, then this element reports from Student Information > Program Participation > Title 1.

The value reports from the most recent active record on the Effective Date.
- If multiple records exist, the value reports from the record with no end date.
- If all records are end dated then use record with the highest ID (last created).
If the student's reporting record contains the value A, then 0 reports.

Report:
SR

System Administration > Resources > School > School History > Title 1

Student Information > Program Participation > Title 1

SpecialEd

Indicates whether the student is participating in a special education instructional and related services program or a general education program using special education support services, supplementary aids, or other special arrangements.

A value of 1 is reported if the student has an active, locked IEP as of the effective date selected on the extract editor.

Report:
SR

Student Information > Special Ed > Documents > Plan Outline TXIEP / Education Plan

IEP

Indicates that the student has an Individual Education Plan on record.

A value of 1 is reported if the student has an active, locked IEP as of the effective date selected on the extract editor.

Student Information > Special Ed > Documents > Plan Outline TXIEP / Education Plan

Bilingual

Indicates if the student participates in a Bilingual EL service.

If the student has an Service Type = B0, B2, B3, B4 or B5 in an EL Service record that is active as of the end date of the enrollment indicated on the extract editor, the Service Code is reported. If the student has multiple active EL service types, all of them are reported.

Report:
SR

Student Information > Program Participation > English Learners (EL) > EL Services > Service Type

ESL

Indicates if the student participates in an ESL EL service.

If the student has an Service Type = E2 or E3 in an EL Service record that is active as of the end date of the enrollment indicated on the extract editor, the Service Code is reported. If the student has multiple active EL service types, all of them are reported.

Report:
SR

Student Information > Program Participation > English Learners (EL) > EL Services > Service Type

GiftedTalented

Indicates whether the student has been identified as participating in a state-approved gifted and talented program (as defined in 19 TAC §89.1), or is furloughed from the program.

If student has a flag that is active as of the most recent enrollment record with a Service Type of P that is equal to GT: Gifted & Talented, a value of 1 is reported.

Report:
SR

Student Information > General > Flags > Student Flag Editor > Flag

CTE

Does not report.

N/A

Assessment

Assessment Object

Each assessment is pulled once and only pulls assessments when they are organized under a parent record that does not contain a score.

Student Report (SR) ONLY:

Assessments for the Student Report (SR) will only report when they contain one item from each of the following:

Test Name OR Additional Test Name
Test Date or Comment
- If the comment field contains a date value in MMYY format, report output will display as 20YY-MM (Ex.1521 will report as 2021-15). Refer to the TestDate element for month logic.
- Comment will only report if TestDate is null.
Test Score or Test Code

SIF Data Element

Description

Location

TestName

The name of the assessment reporting data.

If the assessment is tied to an active State Code value found in test.stateCode dictionary, report the TestName element in this complex type and do not report the AdditionalTestName.

Report:
SR

Assessment/Assessment Subtest > Test Detail > Test Name

AdditionalTestName

The name of the assessment reporting data.

If the assessment is NOT tied to an active State Code value found in test.stateCode dictionary report the AdditionalTestName element in this complex type and do not report the TestName.

Report:
SR

Assessment/Assessment Subtest > Test Detail > Test Name

TestLevel

The grade level associated with the Assessment taken by the student.

First the Test Grade Level is identified, if null the student's active Grade Level from their enrollment is reported.

Report:
SR
AAR

Assessment > Test Setup > assessment > Test Detail > Test Grade Level

Student Information > General > Enrollment > Grade Level

TestDate

The date the assessment was taken by the student. The SR record type reports dates for all Assessment records.

The AAR record type reports dates for all saved Assessment records.

If the Assessment is STAAR EOC, this field reports as follows:

If the month the assessment took place in is....	Then the month reports as...
April or May	15
July	16
October, November or December	13

If the STAAR EOC assessment date does not fall into these date ranges, the assessment does not report.

Assessments with the following codes are considered STAAR EOC assessments.

All numerical codes between 41 and 52
All numerical codes between 71 and 76
All 2 digit codes that begin with E
All 2 digit codes that begin with F
All 2 digit codes that begin with G
All 2 digit codes that begin with H

Report:
SR
AAR

Assessment > Test Score Detail > Date

ExitRequirement
MetDate

The date (month and year) the student met the graduation requirement on each of the TAKS exit exams.

For each of the four TAKS exams (ELA, Math, Science, and Social Studies) logic find the most recent exam with a "result" value of "1: Met Standard(1.000)", and reports the date associated with that record.

If one of the four TAKS exams does not have a result value of "1: Met Standard(1.000)", that particular TAKS exam is not reported.

Each TAKS exam is reported only once.

Logic calculates the most recent based on the End Date of the enrollment record selected in the extract editor.

Report:
SR
AAR

Assessment > TAKS Exam > Test Score Detail > Result

TestScore

The scale score earned by the student on the assessment instrument or test.

Report:
SR

Assessment > Test Score Detail > Scale Score

TestCode

An explanation or notation related to the score earned by the student for the assessment instrument or test.

If assessment score code is provided, then the test name and test date are required. This may be repeated for each assessment.

Code	Description
A	Absent
B	Score code defaulted to B (Reading, grades K-1)
C	No match
D	No information for this subject
E	Extenuating circumstances, do not score (Reading, grades K-1)
G	Information provided from TAKS-Alt
I	TAKS Inclusive test was administered
L	LEP-exempt
M	Medical Exemption
N	No Authentic Academic Response
O	Other
P	Previously met standards
Q	Did not take TAKS reading test
R	TAKS reading not appropriate
S	Test was scored
T	Alternate assessment to TAKS reading
W	Parental Waiver
X	ARD-exempt
Y	Did not take English-version reading test
Z	Did not take Spanish-version reading test

Reports:
SR

Assessment > Test Score Detail > Score Code

PerformanceLevel

Not being reported at this time.

N/A

AssessmentSubTest

The subtype of the reporting assessment type.

Reports:
SR

Assessment > Test Score Detail

AssessmentSubTest/
SubTestName

The name of any subtest that is part of an assessment instrument.

Reports:
SR

Assessment > Test Score Detail > Subtest Name

AssessmentSubTest/
SubTestScore

The scale score earned by the student on any subtest that is part of an assessment instrument.

Reports:
SR

Assessment > Test Score Detail > Subtest > Scale Score

Attendance

Attendance Object

SIF Data Element

Description

Location

DaysAttended

Indicates the total number of days the student was present during the current academic year.

Days Attended = Total Membership - Total Days Absent

Reports:
SR

Calculated

DaysAbsent

Indicates the total number of days the student was absent during the current academic year.

Reports:
SR

Calculated

RSDaysAttended

If a day is counted for this field, it IS NOT counted in standard attendance (Total-Days-Present).

For every day a student is present, the following count logic applies:

Attendance Code	Count Logic (for this field)
RS	Day is counted
RA or IP	Day is not counted
No applicable attendance code for that day	Looks for Virtual > Synchronous mark on the Blended Learning Group Assignment
Blended Learning Group Assignment Mark
Virtual > Synchronous	The day is included in this calculation.

If none of the above are true, the day is not counted for this field.

Reports:
SR

Calculated

RADaysAttended

If a day is counted for this field, it IS NOT counted in standard attendance (Total-Days-Present).

For every day a student is present, the following count logic applies:

Attendance Code	Count Logic (for this field)
RA	Day is counted
RS or IP	Day is not counted
No applicable attendance code for that day	Looks for Virtual > Asynchronous mark on the Blended Learning Group Assignment
Blended Learning Group Assignment mark
Virtual > Asynchronous	Day is counted

If none of the above are true, the day is not counted for this field.

Reports:
SR

Calculated

Immunization

Immunization Object

SIF Element	Description	Location
ImmunizationCode	The code from any vaccine in a student's record that has any dose information saved. Codes are reported for each vaccine in the student's vaccine record. Reports: SR	System Administration > Health > Vaccines > Vaccine Detail > Code Student Information > Health > Immunizations
ImmunizationDate	The date for the reporting vaccine for the student. Dates are reported for each vaccine in the student's vaccine record in ascending order. Reports: SR	Student Information > Health > Immunizations
ImmunizationDose	The dose for the reporting vaccine for the student. Doses are reported for each vaccine in the student's vaccine record. Reports: SR	Student Information > Health > Immunizations

SIF Element

Description

Location

ImmunizationCode

The code from any vaccine in a student's record that has any dose information saved. Codes are reported for each vaccine in the student's vaccine record.

Reports:
SR

System Administration > Health > Vaccines > Vaccine Detail > Code

Student Information > Health > Immunizations

ImmunizationDate

The date for the reporting vaccine for the student. Dates are reported for each vaccine in the student's vaccine record in ascending order.

Reports:
SR

Student Information > Health > Immunizations

ImmunizationDose

The dose for the reporting vaccine for the student. Doses are reported for each vaccine in the student's vaccine record.

Reports:
SR

Student Information > Health > Immunizations

Discipline Action

Discipline Action Object

SIF Data Element	Description	Location
DisciplineActionDate	Indicates the date on which the unexpired disciplinary assignment will end. This must be a valid date occurring after the record transfer (in the future). This disciplinary event must be unexpired, i.e., the event must be applicable to the time frame in which the student record is being transferred to another district/campus. Reports: SR	Student Information > General > Behavior > Resolution Details > Resolution End Date
DisciplineActionNum	Indicates the local disciplinary action number used to report an unexpired disciplinary event for a student. This disciplinary event must be unexpired, i.e., the event must be applicable to the time-frame in which the student record is being transferred to another district/campus. Reports: SR	Calculated
DisciplineActionCode	Indicates the type of an unexpired disciplinary action taken for a student. This disciplinary event must be unexpired, i.e., the event must be applicable to the time-frame in which the student record is being transferred to another district/campus. Reports: SR	Behavior > Behavior Management/Referral > Add a Resolution > Resolution Details > Resolution Type
DisciplineActionReason	Indicates the reason a student was subject to the unexpired disciplinary action. If the Event Code is more than 2 digits, the last two digits of the code is reported. This disciplinary event must be unexpired, i.e., the event must be applicable to the time frame in which the student record is being transferred to another district/campus. Reports: SR	Behavior > Behavior Management/Referral > Add Event/Participant > Event Details > Event Type

Academic Status

Academic Status Object

SIF Data Element	Description	Location
GraduationDate	Indicates the month and year that the student graduated from high school or is expected to graduate from high school (Grades 11-12). If Graduation Date is null, the Projected Graduation Date value is reported. Reports: SR AAR	Student Information > General > Graduation > General Graduation Information > Graduation Date Student Information > General > Graduation > State Reporting Graduation Fields > Projected Graduation Date
Speech Requirement Met Date	The month and year the student met the speech requirement for the Foundation High School Program. AAR Only If a student has an Advanced Measure of Y: FHSP Speech Requirement Met with a date then it will report regardless of what additional records exist. Reports: SR AAR	Student Information > Academic Planning > Advanced Measures
Graduation DiplomaType	Indicates the type of graduation program or plan under which the student graduated or will graduate. Reports: SR AAR	Student Information > General > Graduation > General Graduation Information > Graduation Type
CertificateDate	The date on which the district awards a certificate of coursework completion to a student. Districts have the option of awarding a certificate of coursework completion to a student who successfully completes all coursework requirements but who fails to perform satisfactorily on the statewide exit-level assessment. Reports: SR AAR	Student Information > General > Graduation > State Reporting Graduation Fields > Coursework Completion Date
Texas Grant	Indicates the student is on track to graduate by completing the requirements of the State Board of Education-approved Minimum/ Recommended/ Distinguished/ High School Program (RHSP). If the FSHPParticipation Code is 1, then this field does not report. Reports: SR AAR	Student Information > General > Graduation > State Reporting Graduation Fields > Texas Grant
FHSP Participation Code	Indicates whether a student is currently enrolled in or pursuing the Foundation High School Program. This element only reports for students with a Graduation Type of 34. Reports: SR AAR	Student Information > General > Graduation tab > Graduation Type
FHSP Disting Code	Indicates whether a student is currently pursuing or has successfully completed the distinguished level of achievement program under the Foundation High School Program as provided by TEC 28.025 (b-15). If the student has a Graduation Endorsement record of FHSP Distinguished with a Status other than 0, then reports as entered. All others, do not report. Reports: SR AAR	Student Information > General > Graduation tab > State Reporting Graduation Fields > FHSP Distinguished
STEM Endorsement Code	Indicates whether a student is currently enrolled in, pursuing, or has successfully completed a Science, Technology, Engineering, and Mathematics Endorsement. If the FHSP Participant Code is 1 or 2 AND the student has a Graduation Endorsement record of STEM with a Status other than 0, then reports as entered. All others, do not report. Reports: SR AAR	Student Information > General > Graduation Tab > State Reporting Graduation Fields > STEM
Business Endorsement Code	Indicates whether a student is currently enrolled in, pursuing, or has successfully completed a Business and Industry Endorsement. If the FHSP Participant Code is 1 or 2 AND the student has a Graduation Endorsement record of Business & Industry with a Status other than 0, then reports as entered. All others, do not report. Reports: SR AAR	Student Information > General > Graduation Tab > State Reporting Graduation Fields > Business & Industry
Public Services Endorsement Code	Indicates whether a student is currently enrolled in, pursuing, or has successfully completed a Public Services Endorsement. If the FHSP Participant Code is 1 or 2 AND the student has a Graduation Endorsement record of Public Services with a Status other than 0, then reports as entered. All others, do not report. Reports: SR AAR	Student Information > General > Graduation Tab > State Reporting Graduation Fields > Public Services
Arts Endorsement Code	Indicates whether a student is currently enrolled in, pursuing, or has successfully completed an Arts and Humanities Endorsement. If the FHSP Participant Code is 1 or 2 AND the student has a Graduation Endorsement record of Arts & Humanities with a Status other than 0, then reports as entered. All others, do not report. Reports: SR AAR	Student Information > General > Graduation Tab > State Reporting Graduation Fields > Arts & Humanities
Multi-Studies Endorsement Code	Indicates whether a student is currently enrolled in (pursuing) or has successfully completed a Multi-Disciplinary Studies Endorsement. If the FHSP Participant Code is 1 or 2 AND the student has a Graduation Endorsement record of Multi Disciplinary with a Status other than 0, then reports as entered. All others, do not report. Reports: SR AAR	Student Information > General > Graduation Tab > State Reporting Graduation Fields > Multi Disciplinary
DualCreditType	Performance Acknowledgment Dual Credit indicates the student has earned a performance acknowledgment for outstanding performance in a dual credit course. Reports: SR AAR	Student Information > Academic Planning > Advanced Measures > Performance Acknowledgment
BilingBilitType	Performance Acknowledgment Bilingualism Biliteracy indicates the student has earned a performance acknowledgment for outstanding performance in a bilingualism and biliteracy. Reports: SR AAR	Student Information > Academic Planning > Advanced Measures > Performance Acknowledgment Bilingualism Biliteracy
CollegeAssessType	Performance Acknowledgment College Readiness Assessments indicates the student has earned a performance acknowledgment for outstanding performance on the PSAT, the ACT-PLAN, the SAT, or the ACT. Reports: SR AAR	Student Information > Academic Planning > Advanced Measures > Performance Acknowledgment College Readiness Assessments
ApIbType	Performance Acknowledgment AP IP Exams indicates the student has earned a performance acknowledgment for outstanding performance on a College Board AP test or IB examination. Reports: SR AAR	Student Information > Academic Planning > Advanced Measures > Performance Acknowledgment AP IP Exams
CertLicType	Performance Acknowledgment Certification Licensures indicates the student has earned a nationally or internationally recognized business or industry certification or license. Reports: SR AAR	Student Information > Academic Planning > Advanced Measures > Performance Acknowledgment Bilingualism Biliteracy
IGCGradReview	Indicates whether an Individual Graduation Committee (IGC) was established for the student. Reports: SR	Student Information > General > Graduation > State Reporting Graduation Fields > Ind Grad Committee
FHSPCollegeCareerInstructionIndicator	Indicates whether a student in grades seven or eight has received instruction in preparing for high school, college, career, and a graduation plan. If the FHSP Participant Code is 1 or 2 AND the student has a Graduation Endorsement record of FHSP College Career with a Status of 1, then 1 reports. All others, do not report. Reports: SR	Student Information > General > Graduation > State Reporting Graduation Fields > FHSP College Career
AssociateDegree	Indicates the student earned an associate degree prior to graduation from high school. If the Associate Degree Earned checkbox is marked, 1 reports. Otherwise, 0 reports. Reports: SR	Student Information > General > Graduation > Associate Degree Earned
OnRamps	Indicates the student has successfully completed an OnRamps dual enrollment course. If the student completed a course where the Onramps Dual Credit box is marked, 1 reports. Otherwise, 0 reports. The course can occur in any enrollment. Reports: SR	Course/Section > Course > Onramps Dual Credit
Section504	Indicates whether the student received assistance through an aid, accommodation, or service under Section 504 Rehabilitation Act of 1973 at any time during the school year. If the student has a Section 504 record that overlaps the enrollment year selected in the extract, for any section504 status, then 1 reports. Otherwise, this element does not report. Reports: SR	Student Information > Program Participation > Section 504
POllMetDate	The date (month and year) the student completed the instruction regarding appropriate interactions with peace officers. If the student has an Advanced Measures record of "Peace Officer Interaction Instruction" dated on or prior to the extract's Effective Date, then the date reports in the specified format. Otherwise, this element does not report. Reports: SR AAR	Student Information > Academic Planning > Advanced Measures
CPRMetDate	The date (month and year) the student completed CPR instruction. If the student has an Advanced Measure record of "CPR Instruction" dated on or prior to the extract's Effective Date, then the date reports in the specified format. Otherwise, this element does not report. Reports: SR AAR	Student Information > Academic Planning > Advanced Measures
StarofTexas	Indicates whether the student is eligible for free public prekindergarten because they are the child of a person awarded the Star of Texas Award. If the Star of Texas checkbox is marked on the student's enrollment for the specified year, then 1 reports. Otherwise, this element does not report. Reports: SR	Student Information > General > Enrollments > State Reporting Fields
IBCReimbursement	"1" Reports if student has a Certification record that contains a value in the IBC Exam Fee. Reports: SR	Student Information > General > Graduation > Graduation Certification and Licensure
IBCCode	If student has a Certification record that contains a value in Certification, report that value. Repeat element for every applicable record. Reports: SR	Student Information > General > Graduation > Graduation Certification and Licensure
FinancialAidApplication	Reports the value found in the Financial Aid Met Date field. Otherwise, this element does not report. Reports: SR AAR	Student Information > General > Graduation > Financial Aid Application
FinancialAidApplicationMetDate	Reports the value from the Financial Aid Met Date field for the student. Otherwise, this element does not report. Reports: SR AAR	Student Information > General > Graduation > Financial Aid Met Date

Distinguished Achievements

SIF Data Element	Description	Location
Advanced Measure	A code corresponding to one of the six measures described in the 2009-2010 AAR Minimum Standards 1.13(k) and in table TC29. In order to be recognized as part of the Distinguished Achievements Program – Advanced High School Program, a student must achieve any combination of four advanced measures as defined in TAC §74.13. The measures must focus on demonstrated student performance at the college or professional level. Reports: SR AAR	Student Information > Academic Planning > Advance Measures > DAP Advanced Measures

SIF Data Element

Description

Location

Advanced Measure

A code corresponding to one of the six measures described in the 2009-2010 AAR Minimum Standards 1.13(k) and in table TC29. In order to be recognized as part of the Distinguished Achievements Program – Advanced High School Program, a student must achieve any combination of four advanced measures as defined in TAC §74.13. The measures must focus on demonstrated student performance at the college or professional level.

Reports:

AAR

Student Information > Academic Planning > Advance Measures > DAP Advanced Measures

Current Coursework

If a student has a Grading Task of CG or F in any in-progress course in their current schedule, that course and grade will report.

If a course is in the active year, the course reports under Current Coursework. All other courses report under Academic Session.

SIF Data Element	Location	Description
Course
Course/CourseTitle	Indicates the name of the course taken or being taken by the student. Reports: ARR SR	Student Information > General > Transcript > Name
Course/CourseID	Indicates the TEA-assigned number for a course or a district/campus-assigned number for a locally-developed course. Reports: ARR SR	Student Information > General > Transcript > State Code
Course/Abbreviation	The TEA-assigned course abbreviation. If no value in Course > Name, then any value in Abbreviated Course Name is reported. OR The State Code from the course being reported. Reports: ARR SR	Student Information > General > Transcript > Abbreviated Course Name OR Course/Section > Course Information > State Code
Course/Semester	Indicates the semester or academic term in which a course was taken. For example: Semester 1 = 1, Semester 2 = 2, Trimester 1 = 1, Trimester 2 = 2, Trimester 3 = 3, Quarter 1 = 1, Quarter 2 = 2, Quarter 3 = 3, Quarter 4 = 4. Reports: ARR SR	Student Information > General > Transcript > Course Record > Course Sequence
Course/ClassPeriod	Indicates the class instructional period in which the course was taken by the student. Reports: SR	Calendar > Calendar > Period > Sequence
Course/SubjectArea	The course category or subject area designated and listed on the transcript. For example, English Language Arts, Health, and Speech, etc. The subject area reports when the the grading task has a code of CG or F. Reports: SR	Student Information > General > Transcript > Course Record > Transcript Credit > Credit Name
Course/CourseGrade	The actual or raw grade earned by the student for an academic reporting period (e.g. six-week or nine-week grading period). This grade should not reflect any type of weighting for course type. The score assigned to a course reports when the grading task or standard has a code of CG or F AND the "State Reported" checkbox is selected. Reports: SR AAR	Grading and Standards > Grading Tasks > Grading Task Detail > 'Code' and 'State Reported' Student Information > General > Transcript > Transcript Course Editor > Current Score
Course/WithdrawGrade	The grade earned by the student for the course at the time of withdrawal. This is used only when the student transfers before completing a semester or grade reporting period. If more than one grading task fits the criteria, then the most recently saved value reports. Reports: SR	Course/Section > Grading By Student > Task (grading task with a code of either CG or F Grading & Standards > Grading Task Detail > Code)
Course/GradeAverage	Identifies the final course grade that the student received for a multi-part course. (e.g. a year long course with credit and grades awarded for each of the two semesters). Reports the Percent's value if one exists. Reports: SR AAR	Student Information > General > Transcript > Transcript Course Editor > Percent
Course/CourseCredit	Indicates the number of units awarded to the student for completion of a course. Reports: SR AAR	Student Information > General > Transcript > Transcript Record > Transcript Credit > Earned
Course/PassFailCredit	Indicates the outcome for a course taken by a particular student. Reports: SR	Student Information > General > Transcript > transcript record > Transcript Credit > TX Pass/Fail Credit
Course/Explanation	A description authorized by TEA as a means to document on the transcript (AAR) specific information regarding the course to which the code is associated. Examples include explanation codes for course credit earned in middle school or at a college-level. One line reports for each character selected in the Special Explanation field on the transcript. Example For example, if codes A, C, and D were selected in the Special Explanation field the following would report: <Explanation>A</Explanation> <Explanation>C</Explanation> <Explanation>D</Explanation> Reports: AAR	Student Information > General > Transcript > Special Explanation
Course/CourseTeacher	Indicates the last name of the Primary teacher who provided instruction for a course. Reports: SR	Course > Section > Staff History > Primary Teacher > Last Name
Course/CreditCampus	Campus-Awarding-Credit indicates the TEA- assigned Campus ID of the Texas public school confirming and awarding credit for coursework completed at a non-public school or a school outside of Texas. Reports: SR AAR	Transcript > District No AND School No AND School Name System Administration > Resources > District > Number AND School > Number
Course/SemesterSeq	Indicates a sequence or portion of a course. Reports: SR	Student Information > General > Transcript > Course Record > Course Sequence
Course/ FinalGradeAverage	The average of the grades earned by the student for a year long course. If local policy allows schools to average two semesters for a full-year credit, then this column must be completed. Logic only reports for a course record on a student's Transcript that have a Course Sequence value of '0' or 'A'. Reports: SR AAR	Student Information > General > Transcript > Course Record > Course Sequence, Current Score
SchoolYear	Indicates a school year of the course being reported. Student Record - The current academic year tied to the chosen enrollment in the extract editor is reported. AAR - The academic year tied to when the course was taken by the student is reported. Reports: SR AAR	System Administration > Calendar > Academic Year
GradeLevel	Indicates the current grade level (EE, PK - 12) of the student, the grade level associated with an assessment test, or grade level applicable to coursework completed or in progress. Logic identifies the students Grade Level from the enrollment and reports the associated State Grade Level code. Reports: SR	Student Information > General > Enrollments Tab > General Enrollment Information > Grade System Administration > Resources > Grade Level Definitions > Code
SessionType	Indicates the number of academic terms within a school year (e.g., Semester, Trimester, Quarter). 0 = Annual 1 = Semester (Reports for Course Sequences 0 or A) 2 = Semester 3 = Trimester 4 = Trimester 5 = Trimester 6 = Quarter Reports: SR AAR	Student Information > General > Transcript > Course Record > Course Sequence

Academic Session

Academic Session Object

SIF Data Element	Description	Location
SchoolYear	The school year of the course reporting data. Reports: SR AAR	System Administration > Calendar > Academic Year
GradeLevel	The grade level of the student at the time in which the reporting course was completed. Reports: SR	Student Information > General > Enrollments Tab > General Enrollment Information > Grade System Administration > Resources > Grade Level Definitions > Code
Course
Course/CourseTitle	The name of the reporting course. Reports: SR AAR	Student Information > General > Transcript > Name
Course/CourseID	The TEA-assigned number for a course or a district/campus-assigned number for a locally-developed course. Reports: SR AAR	Student Information > General > Transcript > State Code
Course/Abbreviation	The TEA-assigned course abbreviation. OR The State Code from the course being reported. Reports: SR AAR	Student Information > General > Transcript > Abbreviated Course Name OR Course/Section > Course Information > State Code
Course/Semester	Indicates the semester or academic term in which a course was taken. For example: Semester 1 = 1, Semester 2 = 2, Trimester 1 = 1, Trimester 2 = 2, Trimester 3 = 3, Quarter 1 = 1, Quarter 2 = 2, Quarter 3 = 3, Quarter 4 = 4. Reports: SR AAR	Student Information > General > Transcript > Course Record > Course Sequence
Course/ClassPeriod	Indicates the class instructional period in which the course was taken by the student. Reports: SR	System Administration > Calendar > Calendar > Period > Sequence
Course/SubjectArea	The course category or subject area designated and listed on the transcript. For example, English Language Arts, Health, and Speech, etc. The subject area reports when the the grading task has a code of CG or F. Reports: SR AAR	Student Information > General > Transcript > Course Record > Transcript Credit > Credit Name
Course/CourseGrade	The actual or raw grade earned by the student for an academic reporting period (e.g. six-week or nine-week grading period). This grade should not reflect any type of weighting for course type. Logic reports the score assigned to a course where the grading task or standard has a code of CG or F AND the "State Reported" checkbox is selected. Reports: SR AAR	Grading and Standards > Grading Tasks > Grading Task Detail > 'Code' and 'State Reported' Student Information > General > Transcript > Transcript Course Editor > Current Score
Course/WithdrawGrade	Not being reported at this time.
Course/GradeAverage	Identifies the final course grade that the student received for a multi-part course. (e.g. a year long course with credit and grades awarded for each of the two semesters). Reports the Percent's value if one exists. Reports: SR AAR	Student Information > General > Transcript > Transcript Course Editor > Percent
Course/CourseCredit	Indicates the number of units awarded to the student for completion of the reporting course. Reports: SR AAR	Student Information > General > Transcript > Transcript Record > Transcript Credit > Earned
Course/PassFailCredit	Indicates the outcome for a course taken by a particular student. Reports: SR AAR	Student Information > General > Transcript > transcript record > Transcript Credit > TX Pass/Fail Credit
Course/Explanation	A description authorized by TEA as a means to document on the transcript (AAR) specific information regarding the course to which the code is associated. Examples include explanation codes for course credit earned in middle school or at a college-level. Reports: AAR	Student Information > General > Transcript > Special Explanation
Course/CourseTeacher	Indicates the last name of the Primary teacher who provided instruction for a course. Reports: SR	Course > Section > Staff History > Primary Teacher > Last Name
Course/CreditCampus	Not being reported at this time.
Course/SemesterSeq	Indicates a sequence or portion of a course. Reports: SR	Student Information > General > Transcript > Course Record > Course Sequence
Course/ FinalGradeAverage	The average of the grades earned by the student for a year long course. If local policy allows schools to average two semesters for a full-year credit, then this column must be completed. Logic only reports for a course record on a student's Transcript that have a Course Sequence value of '0' or 'A'. Reports: SR AAR	Student Information > General > Transcript > Course Record > Course Sequence, Current Score

Academic Summary

AcademicSummary Object

SIF Data Element	Description	Location
GPA	Indicates the calculation of the student’s cumulative grade point average for all coursework completed to date. Reports: AAR	Student Information > General > Credit Summary > Transcript Credit Summary > Cum GPA
ClassTotalNumber	The total number of students within a grade level that are expected to comprise a graduating class. Reports: AAR	Calculated
ClassRank	Not being reported at this time. Reports: AAR
ClassRankingDate	Not being reported at this time. Reports: AAR
Quartile	Not being reported at this time. Reports: AAR
CollegeCampusCode	The College Board Campus Code is used when students register for SAT or ACT tests to have test score reports sent to college and scholarship programs. This field reports the value from the CBCC Number field. Reports: AAR	Resources > School > School Detail > CBCC Number

Was this helpful?

TREx Extract (Texas)

Record Types

Generate the Academic Achievement Record (AAR)

Generate the Student Record (SR)

Generate the Student Withdrawal/Record Transfer Form

Current Six Weeks Grades Logic

Viewing a Student's TREx Upload History

Understanding the SR and AAR Report XML

Student Identification

Parent

Student Demographic

School

Enrollment

Special Programs

Assessment

Attendance

Immunization

Discipline Action

Academic Status

Distinguished Achievements

Current Coursework

Academic Session

Academic Summary

Related Articles