TREx Bulk Export

Reports student parent information based on the buildings you select to process.

Reports student prior year academic summary based on the buildings you select to process. Students must be enrolled in the Entry/Withdrawal building as of the prompted Run date.

Gender Code

Gender

The student's gender.

Ethnicity Code

Race

Identifies the student’s ethnic origin. Used only for students before the 2010-11 school year.

Note that this is required for Students before the 2010-2011 school year.

American Indian - Alaska Native

AmericanIndianAlaskaNativeCode

Indicates whether the student's race is identified as American Indian or Alaska Native.

Asian

AsianCode

Black - African American

Hispanic - Latino

Native Hawaiian - Pacific Islander

White

Grade Level (Current)

The student's current grade level (EE, PK through 12). If the student is a graduate, it will be 12.

The student's most recent enrollment date for the campus that is transferring the TREx record.

Original Entry Date may be in the current or prior school year.

No Show records are excluded; the most recent Entry Date in the record that precedes the No Show record is reported.

The final instructional day on which the student attended the campus that is transferring the TREx record.

The Last Date of Attendance may be in the current school year or a prior school year.

The Last Date of Attendance is reported as the date of the student's final instructional day where attendance was recorded.

No Show records are excluded; if the student was actively enrolled at the end of the prior school year, the date corresponding to the last instructional/attendance day for the student is reported.

Last Withdrawal Date

The student’s withdrawal date at the campus that is transferring the TREx record.

Inactive Students: The most recent reportable withdrawal date is reported.

Active Students: WithdrawDate is suppressed.

No Show records are excluded.

Withdrawal Reason

The withdrawal reason for the student's most recent withdrawal.

The report outputs the State Exit Code if the Local Exit Code is mapped to a State Exit Code.

Inactive Students: The Exit Code in the most recent withdrawal record is reported using the value in the State Code field (if populated); otherwise, the regular Exit Code is reported. If the ExitCode contains a non-reportable code, then a default TREx code of '99' is reported.

Active Students: WithdrawReason is suppressed.

No Show records are excluded.

The grade level in which the student was retained at the campus transferring the student record or transcript, if applicable.

Note that the Grade of Retention is only reported for students in grades PK through 8.

Indicates whether the student is identified as limited English proficient by the Language Proficiency Assessment Committee (LPAC) or is identified as English proficient.

The code is reported if the student has an LEP Special Programs record in effect on the TREx run date where the state code = 0, 1, 3, 4, 5, F, or S.

Otherwise, if the student does not have a record in effect, or the state code is any value except 1, F, or S, a default of '0' is reported.

Alternative Language
Program Code

Dual Language
Immersion Year

The year in which the student participates in a dual language immersion program at the elementary campus.

If the student is not participating in a Dual Language Immersion program, a value of 00 is reported.

Dual Language
Immersion Language
Code

The language, other than English that the student is studying under the dual language immersion program.

If the student is not participating in a Dual Language Immersion program, then ImmersionLanguage is suppressed.

Required if the student is participating in a Dual Language Immersion program.

Dual Language
Immersion Assessment
Met Date

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

If the student is not participating in a Dual Language Immersion program, then AssessmentMetDate is suppressed.

Dual Language
Immersion Completion
School Year

The school year that the student completed the five-year dual language immersion program.

If the student is not participating in a Dual Language Immersion program, then CompletionSchoolYear is suppressed.

Indicates whether the student is identified as having an economically-disadvantaged status.

If the student has an Economic Disadvantage record in effect on the TREx run date where the state code = 00, 01, 02, or 99, the code is reported.

Otherwise, if the student has no record in effect, or the state code is any value except 01, 02, or 99, a default of '0' is reported.

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

If the student has an At-Risk Special Programs record in effect on the TREx run date, and the student's age is less than 20 as of the most recent September 1 date: '1'

Otherwise, a default of '0' is reported.

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

If the Title I Designation for the student's current or most recent reportable campus = "Schoolwide program": '6'.

The code is reported if the student Title I participation record is in effect on the TREx run date and if the short state code for Title I Part A Code = A, 6, 7, 8, or 9.

Otherwise, if no Title I Participation record is in effect, or the state code is any value other than A, 6, 7, 8, or 9, a default of '0' is reported.

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.

If the student has a Special Ed program record in effect on the TREx run date where the Instructional Setting is not "00" or blank: '1'.

Otherwise, a default of '0' is reported.

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

If the student has an IEP program record in effect on the TREx run date where the Instructional Setting is not "00" or blank: '1'.

Otherwise, a default of '0' is reported.

Indicates whether the student is participating in a state-approved bilingual education program.

The code is reported if the student has an LEP Special Programs record in effect on the TREx run date where the Bilingual Program Type state code = 0, 1, 2, 3, 4, or 5.

Otherwise, a default of '0' is reported.

Indicates whether the student is participating in a state-approved English as a Second Language (ESL) program.

The code is reported if the student has an LEP Special Programs record in effect on the TREx run date where the ESL Program Type state code = 0, 1, 2, 3, 4, or 5.

Otherwise, a default of '0' is reported.

Indicates whether the student is 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 the student has a Gifted and Talented Special Programs record in effect on the TREx run date with an Indicator of 1: '1'

Otherwise, a default of '0' is reported.

Indicates whether the student is working under a personal graduation plan.

If the student is not a graduate and has a value of 1 in the Personal Graduation Plan: '1'

Otherwise, a default of '0' is reported.

The name of the assessment instrument or test taken by the student. Note that:

• ACT and SAT assessments are reported under Additional Test Name and Assessment Subtest.
• If the assessment name is provided, then the Additional Test Name is blank within each assessment.
• TAKS Exit scores are reported for students who will graduate under TAKS.
• The Test Score Alpha Score field contains the version code for the assessment. This value is examined to determine the appropriate TREx Test Name code.

The test name for assessments that are not included in the standard assessment code table TC01. Note that:

• ACT and SAT assessments are reported under Additional Test Name and Assessment Subtest.
• AdditionalTestName is suppressed for TAKS Exit, STAAR, EOC, and TELPAS assessments.

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

Note that the Assessment Grade Level is reported for all assessments except ACT and SAT subtests.

The date (month and year) on which the student took an assessment instrument or test; also known as the Administration Date.

Note that the Assessment Date is reported for all assessments except ACT and SAT subtests.

The STAAR EOC assessment dates are output with the following conventions:

• yyyy = test year
• mm = testing period where 15 = Spring, 16 = Summer, and 13 = Fall

All other assessments are output in the following format:

• yyyy-mm format where mm = the actual month

The scale score (Numeric Score) earned by the student on the assessment instrument or test. Note that:

• The Assessment Score is reported for all assessments except ACT and SAT subtests.
• ACT and SAT composite scores are reported.
  • If there are multiple scores for the same test (ACT or SAT), the highest score is reported.

Test Exemptions for TAKS Exit and STAAR EOC
If a value of 1 exists in the Numeric Score field AND a value of E exists in the Alpha Score field, the Assessment Score is reported as 'Exempt' for TAKS and "Waived" for EOC.

Mastery for TAKS Exit Only
If the student has a Numeric Score value for a TAKS Exit test and an Alpha Score value of "+", the + sign is added after the numeric score to indicate Mastery.

The level that the student achieved (Percent Score) on the STAAR End of Course assessment.

Otherwise: If the Numeric Score is populated, but PercentScore is not populated, a default of '0' is reported.

For STAAR and EOC Assessments dated PRIOR to March 2017:

• A value of 1, 2, or 3 is reported, as entered in PowerSchool.

For STAAR and EOC Assessments dated AFTER March 2017:

• A value of 0-9 or A is reported.
• If the Percent Score value = 10: 'A'
• All other Percent Scores are reported as entered in PowerSchool.

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

Note that the SubtestName is only reported for the ACT and SAT subjects.

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

• SubtestScore is only reported for the ACT and SAT subjects.
• If there are multiple scores for the same test (ACT or SAT), the highest score is reported.

The total number of days the student was present during the current academic year in the student's current or most recent school of enrollment.

If the Official Attendance Period checkbox is selected for any period in the student's Bell Schedule, the report determines ADA periods based on this flag; otherwise, the Counts for ADA flag determines the reportable period.

If the normal ADA period is Period 3, attendance is reported based on the class assigned to that period. If a student does not have a class in the normal ADA Period 3, and the school has flagged an additional period as Counts for ADA or Official Attendance Period, the student's attendance is sourced from the class that meets in the additional flagged period.

If the student's ADA Eligibility Code is not 0, any student attendance days with no absence-type Attendance Code are considered days present. Days marked with the Funding Attendance Code Category are also considered present days. Days where the student's ADA Eligibility Code indicates half-day eligibility are calculated as half-days.

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

If the Official Attendance Period checkbox is selected for any period in the student's Bell Schedule, the report determines ADA periods based on this flag; otherwise, the Counts for ADA flag determines the reportable period.

If the normal ADA period is Period 3, attendance is reported based on the class assigned to that period. If a student does not have a class in the normal ADA Period 3, and the school has flagged an additional period as Counts for ADA or Official Attendance Period, the student's attendance is sourced from the class that meets in the additional flagged period.

DaysAbsent includes in-session, non-ADA 0 days where an Attendance code with an absence-type value has been recorded.

The total number of days the student was present in the Remote Asynchronous (RA) attendance option during the current academic year in the student's current or most recent school of enrollment.

The Attendance Contact Hours calculation is updated to calculate days present eligible and excess contact hours for In Person, Remote Synchronous (RS), and Remote Asynchronous (RA) attendance data fields that are part of the Basic Reporting Period Attendance and Special Reporting Period Attendance complex types. The Residential Facility complex type includes the In Person, RS, and RA counts.

In Person attendance is the membership value where attendance code SCE = 'P' and learning location = 'I'.
Remote Synchronous attendance is the membership value where attendance code SCE = 'P' and learning location = 'S'.
Remote Asynchronous attendance is the membership value where (attendance code SCE = 'P' and learning location = 'A') or (attendance code SCE in (RAE, RAU, RAP)).

The name or description of the immunization given to the student. The following Immunizations are supported.

Output: IMM_Name_1_Date

Note that Name equals the abbreviation for each immunization name.

Exemptions: If the student has a current Exemption for the immunization (where Exemption Expires after the current date), the Immunization Name is reported, with the following appended to the output:

• Immunization Name - Exempt - Exemption Reason (Medical or Conscience)

Examples:

• HEPA-Exempt-Conscience
• Polio-Exempt-Medical

Varicella: If the student has a Dose record and Date of Disease, the Date of Disease takes precedence.

Output: Varicella-Has had the disease

TB: A Test Date and Result are both required to be reported. If the student has a test result, the Test Date is reported in the Immunization Date field.

Output: TB-Result-Text

The date on which the student received an immunization.

Output: IMM_Name_1_Date

Note that Name equals the abbreviation for each immunization name.

Exemptions: The Exemption Expiration Date is reported.

Varicella: If the student has had the disease, the Date of Disease is reported.

TB: The Date of the Test is reported.

The dose in a series of an immunization received by the student.

Output: IMM_Name_1_Date

Note that Name equals the abbreviation for each immunization name.

The local disciplinary action number used to report an unexpired disciplinary event for a student. Calculated in sequential order.

The type of unexpired disciplinary action taken for a student.

The reason a student was subject to the unexpired disciplinary action.

Academic Status

The month and year that the student graduated from high school.

Output: E0791, if populated

Otherwise, GraduationDate is suppressed.

Indicates whether an Individual Graduation Committee (IGC) has been established for a student.

Note that the IGCGradReview code is only reported for students who are NOT graduates.

The type of graduation program or plan under which the student graduated or will graduate.

It is required in the final transcript (graduates).

Output: E0806, if populated

Otherwise, GraduationDiplomaType is suppressed.

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.

Note that CertificateDate is only reported for non-graduates.

Otherwise, CertificateDate is suppressed.

An indicator of whether a student in the Minimum / Recommended / Distinguished / High School Program (RHSP) is on track to graduate by completing the requirements of the State Board of Education.

Note that TexasGrantType is only reported for non-graduates with one of the former Graduation Program types: Minimum, Recommended, or Distinguished.

Indicates whether a student in grades seven or eight has received instruction in preparing for high school, college, and a career, including personal graduation plan, the distinguished level of achievement, endorsements, college readiness standards, and potential career choices and the education needed to enter those careers.

Note that FHSPCollegeCareerInstructionIndicator is only reported for students in grades 7 and 8.

Otherwise, a default value of 0 is reported.

Indicates whether a student is currently enrolled in (pursuing) the Foundation High School Program.

Note that the FHSP Participant Code applies only to students in grades 9 through 12 and graduates.

Valid Values:

• 0 = Not participating (default)
• 1 = Pursuing
• 2 = Completed

In all cases, the logic for Graduates is applied first.

Graduates:

• If Graduation Type Code =
  • 34, 54, 55, 56, or 57: ' 2'
  • Otherwise: '0'

Non-graduates:

• If Graduation Type Code =
  • 34, 54, 55, 56, or 57: '1'
  • Otherwise: '0'

Indicates whether a student is currently enrolled in (pursuing) or has completed the distinguished level of achievement program under the Foundation High School Program.

Note that FHSPDistingIndicatorCode is only reported for students in grades 9 through 12 and FHSP-type graduates. The student must have a value of 1 or 2 for the FHSP Participant Code and a value of 1 or 2 for the FHSP Distinguished Level Indicator.

Valid Values:

• 0 = Not participating (default)
• 1 = Pursuing
• 2 = Completed

Graduates:

• If Graduation Type Code = 34, 54, 55, 56, or 57 AND FHSP Distinguished Level = 2: '2'
• Otherwise: '0'

Non-graduates:

• If Graduation Type Code = 34, 54, 55, 56, or 57 AND FHSP Distinguished Level = 1 or 2: '1' or '2' as entered
• Otherwise: '0'

Indicates whether a student is currently enrolled in (pursuing) or has completed an Arts and Humanities Endorsement.

Note that ArtsEndorsementCode is only reported for students who are FHSP Participants or FHSP Graduates.

Graduates:

• If the student is a graduate with Graduation Type Code = 34, 54, 55, 56, or 57, AND one or more endorsements = 2 - Student Has Completed, then each endorsement is reported on a separate line.
• Otherwise, ArtsEndorsementCode is suppressed.

Non-graduates:

• If Graduation Type Code = 34, 54, 55, 56, or 57, OR FHSP Participant Code =1, AND one or more endorsements = 1 - Student is Pursuing or 2 - Student Has Completed then, each endorsement is reported on a separate line.
• Otherwise, ArtsEndorsementCode is suppressed.

Indicates whether a student is currently enrolled in (pursuing) or has completed a Business and Industry Endorsement.

Note that BusinessEndorsementCode is only reported for students who are FHSP Participants or FHSP Graduates.

Graduates:

• If the student is a graduate with Graduation Type Code = 34, 54, 55, 56, or 57, AND one or more endorsements = 2 - Student Has Completed, then each endorsement is reported on a separate line.
• Otherwise, BusinessEndorsementCode is suppressed.

Non-graduates:

• If Graduation Type Code = 34, 54, 55, 56, or 57, OR FHSP Participant Code =1, AND one or more endorsements = 1 - Student is Pursuing or 2 - Student Has Completed, then each endorsement is reported on a separate line.
• Otherwise, BusinessEndorsementCode is suppressed.

Indicates whether a student is currently enrolled in (pursuing) or has completed a Multi-Disciplinary Studies Endorsement.

Note that MultiStudiesEndorsementCode is only reported for students who are FHSP Participants or FHSP Graduates.

Graduates:

• If the student is a graduate with Graduation Type Code = 34, 54, 55, 56, or 57, AND one or more endorsements = 2 - Student Has Completed, then each endorsement is reported on a separate line.
• Otherwise, MultiStudiesEndorsementCode is suppressed.

Non-graduates:

• If Graduation Type Code = 34, 54, 55, 56, or 57, OR FHSP Participant Code =1, AND one or more endorsements = 1 - Student is Pursuing or 2 - Student Has Completed, then each endorsement is reported on a separate line.
• Otherwise, MultiStudiesEndorsementCode is suppressed.

Indicates whether a student is currently enrolled in (pursuing) or has completed a Public Services Endorsement.

Note that PublicServicesEndorsementCode is only reported for students who are FHSP Participants or FHSP Graduates.

Graduates:

• If the student is a graduate with Graduation Type Code = 34, 54, 55, 56, or 57, AND one or more endorsements = 2 - Student Has Completed, then each endorsement is reported on a separate line.
• Otherwise, PublicServicesEndorsementCode is suppressed.

Non-graduates:

• If Graduation Type Code = 34, 54, 55, 56, or 57, OR FHSP Participant Code =1, AND one or more endorsements = 1 - Student is Pursuing or 2 - Student Has Completed, then each endorsement is reported on a separate line.
• Otherwise, PublicServicesEndorsementCode is suppressed.

Indicates whether a student is currently enrolled in (pursuing) or has completed a Science, Technology, Engineering, and Mathematics Endorsement.

Note that STEMEndorsementCode is only reported for students who are FHSP Participants or FHSP Graduates.

Graduates:

• If the student is a graduate with Graduation Type Code = 34, 54, 55, 56, or 57, AND one or more endorsements = 2 - Student Has Completed, then each endorsement is reported on a separate line.
• Otherwise, STEMEndorsementCode is suppressed.

Non-graduates:

• If Graduation Type Code = 34, 54, 55, 56, or 57, OR FHSP Participant Code =1, AND one or more endorsements = 1 - Student is Pursuing or 2 - Student Has Completed, then each endorsement is reported on a separate line.
• Otherwise, STEMEndorsementCode is suppressed.

Indicates the student has earned a performance acknowledgment for outstanding performance on a College Board AP test or IB examination.

Output: Indicator_Value where Performance_Indicator is AP or IB.

If the AP or IB Exam value is populated and does NOT = 0, the code as entered in PowerSchool is reported.

Otherwise, ApIbType is suppressed.

Indicates the student has earned a performance acknowledgment for outstanding performance in bilingualism and biliteracy.

Output: Indicator_Value where Performance_Indicator is BB.

If Graduation Type Code = 34, 54, 55, 56, or 57, AND Bilingualism Biliteracy Indicator Value is populated and does NOT = 0: '1'.

Otherwise, BilingBilitType is suppressed.

Indicates the student has earned a nationally or internationally recognized business or industry certification or license.

Output: Indicator_Value where Performance_Indicator is CL with PEIMS Indicator_Code.

If the student has one or more TSDS / PEIMS reportable certifications (per Indicator Code), then each certification is reported on a separate line. If Indicator Code = 000, CertLicType is suppressed.

If the student also has certifications in the original text-based field (Indicator Value) that are different than those reported for PEIMS, then each certification is reported on a separate line.

If the student has no certifications or has only an indicator value of 000, CertLicType is suppressed.

Indicates the student has earned a performance acknowledgment for outstanding performance on the PSAT®, the ACT-PLAN®, the SAT®, or the ACT®.

Output: Indicator_Value where Performance_Indicator is CR.

If College Readiness Assessments Indicator Value is populated and does NOT = 0, the code as entered in PowerSchool is reported.

Otherwise, CollegeAssessType is suppressed.

Indicates the student has earned a performance acknowledgment for outstanding performance in a dual credit course.

Note that DualCreditType is only reported for students who are FHSP Participants or Graduates.

Output: Indicator_Value where Performance_Indicator is DC.

Otherwise, DualCreditType is suppressed.

Indicates the month and year that the student attained one of the FHSP Performance Acknowledgements.

Indicates the month and year that the student attained one of the FHSP Performance Acknowledgements.

Note that MetDate is reported for each Performance Acknowledgement.

Indicates the month and year the student attained one of the FHSP Performance Acknowledgements.

Indicates the month and year the student attained one of the FHSP Performance Acknowledgements.

Note that MetDate is reported for each Performance Acknowledgement.

Indicates that the student earned an associate degree before graduating from high school.

Note that AssociateDegree is only reported for students in grades 11, 12, or graduates.

Otherwise, AssociateDegree is suppressed.

Indicates that the student has completed an OnRamps dual enrollment course.

Output: E1597_OnRamps

If the student has a stored grades record for a course identified as an OnRamps course, and the OnRamps indicator = Yes/1: ' 1'.

Otherwise, OnRamps is suppressed.

Indicates the month and year the student completed CPR training.

Output: TE122_CPR_Instr_Date

If the CPR instruction date is populated and the student is in grades 7-12, the date is populated in YYYY-MM format.

Otherwise, CPR Instruction Met Date is suppressed.

Indicates the month and year the student completed Peace Officer Interaction training.

Output: TE123_Peace_Off_Instr_Date

If the Peace Officer Interaction date is populated and the student is in grades 9-12, the date is populated in YYYY-MM format.

Otherwise, Peace Officer Interaction Instruction Met Date is suppressed.

Indicates that the student successfully participated in the Special Programs with Section 504 Indicator Code (E1603).

Output: E1603_Indicator

If the student is participating in one or more Section 504 program: '1'.

Otherwise: '0'.

Indicates that the PK student successfully met the qualifications to be eligible for free public kindergarten.

Output: E1601_Star_Of_Texas

If the students Star of Texas indicator = 1: ' 1'.

Otherwise: '0'.

Indicates the month and year the student completed a financial aid application (FAFSA or TASFA) or submitted an exception.

The date is populated in YYYY-MM format.

Indicates the code corresponding to one of the six measures described in the 2009-2010 AAR Minimum Standards 1.13(k) and table TC29. A student must achieve any combination of four advanced measures as defined in TAC §74.13 to be recognized as part of the Distinguished Achievements Program – Advanced High School Program.

Note that Advanced Measure is only reported for students with a Graduation Program Type of 29.

If the student is assigned a Graduation Program Type 29, and their Advanced Measures is one or more, one record for each achieved Advanced Measure is reported.

Current Coursework

TREx Record Sorting

• Semester Sequence: Lowest to Highest
• State Course Number: Lowest to Highest

SchoolYear

Indicates the school year, for example, 2020-2021.

The TEA-assigned Service ID number for a course or a district / campus-assigned number for a locally-developed course.

Note that the course number in the Stored Grade record overrides the course number in the Section and Course records.

The TEA-assigned course abbreviation as entered on the Courses page.

The semester is based on the Term ID in a school year for the class:

• 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'

For year-long, non-HS Credit Courses (Course Seq A), Semester is always suppressed.

The semester is reported for courses of any type with a term less than a full year.

The sequence or portion of a course.

SemesterSeq is reported from the first populated field. If overrides are not populated, the Course Sequence Code logic is calculated based on the value in Courses.

When calculated from the value in Courses, the Semester Sequence logic is as follows:

• (A): 'Non-High School Credit' (Default)
• (1) One Semester: '0'
• (2) Semester: '1' or '2' based on Section Term ID
• (3) Trimester: '3', '4', or '5' based on Section Term ID
• (4) Quarter: '6', '7', '8', or '9' based on Section Term ID
• (X) Accelerated: '1' or '2' based on Section Term ID
• (F) First Half Of A Two Semester Course: '1'
• (S) Second Half Of A Two Semester Course: '2'

The actual or raw grade earned by the student for an academic marking period.

Note that these grades are reported if one or more Stored Grades records (Grades or Percent) exist with a store code that is not a final grade.

If the Percent option is selected at runtime, but Percent is not populated or equals zero (0), then the Letter Grade (such as P, F, or I) will be reported if available.

Output: Store Code - Grade Earned

The grade earned by the student for the course at the time of withdrawal. Note that:

• WithdrawGrade is only reported when the student transfers before completing a semester or grade reporting period.
• WithdrawGrade is sourced from the gradebook final grades based on the student's school exit date.

If the Percent option is selected at runtime, but Percent is not populated or equals zero (0), then the Letter Grade (such as P, F, or I) will be reported if available.

Output: Store Code - Grade Earned

The name of the teacher of record who provided instruction for the course.

Academic Session

TREx Record Sorting

• Academic Year: Earliest to Most Recent
• Semester Sequence: Lowest to Highest
• State Course Number: Lowest to Highest

The student's current grade level (EE, PK –12) applicable to coursework completed.

Note that the student's grade level is reported for each academic year included in the report.

The TEA-assigned Service ID number for a course or a district-assigned / campus-assigned number for a locally-developed course.

Note that the course number in the Stored Grade record overrides the course number in the Section and Course records.

The semester or academic term in which a course was taken.

The semester is based on the Term ID in a school year for the class:

• 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'

The course category or subject area designated and listed on the transcript.

The final course grade that the student received for a multi-part course (for example, a year-long course with credit and grades awarded for each of the two semesters).

The grades earned for Store Codes marked as Final Grade and mapped to a Final Grade Type of S1 or S2 on the Texas Store Code Mapping page are reported.

If the Percent option is selected at runtime, but Percent is not populated or equals zero (0), then the Letter Grade (such as P, F, or I) is reported if available.

GradeAverage is suppressed if there is no final grade mapped to S1 or S2 on the TX Store Code Mapping page, or if the student does not have a grade for a mapped store code.

The number of units awarded to the student for completion of a course.

The credit earned for Store Codes marked as Final Grade and mapped to a Final Grade Type of S1, S2, or AVG on the Texas Store Code Mapping page are reported.

The outcome for a course taken by the student.

If overrides are NOT populated, PassFailCredit is calculated based on the Stored Grades Percent or Stored Grades Grade.

The Explanation Code is 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.

The name of the teacher of record who provided instruction for the course.

Otherwise, CourseTeacher is suppressed.

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.

Otherwise, SchoolID is populated.

A sequence or portion of a course.

SemesterSeq is reported from the first populated field. If overrides are not populated, the Course Sequence Code is calculated based on the value in Courses.

When calculated from Courses, the Course Sequence value is reported in combination with the Section Term ID.

Default Course Setup:

• Year-Long Non-High School Credit: 'A'
• Courses scheduled as semesters: '1' or '2'
• Courses scheduled as trimesters: '3', '4', or '5'
• Courses scheduled as quarters: '6', '7', '8', or '9'

Specific Course Sequence Indicator:

• (1) One Semester: '0'
• (2) Semester: '1' or '2'
• (3) Trimester: '3', '4', or '5'
• (4) Quarter: '6', '7', '8', or '9'
• (X) Accelerated: '1' or '2'
• (F) First Half Of A Two Semester Course: '1'
• (S) Second Half Of A Two Semester Course: '2'

The average of the grades earned by the student for a year-long course. If the local policy allows schools to average two semesters for a full-year credit, then the final grade average column must be completed. This element, if present, will be sent to SPEEDE instead of COURSE-GRADE-AVERAGE.

If AAR_AVG_Override is not populated, the Stored Grade code that is the Final Grade and mapped to Final Grade Type of Average is reported.

If the Percent option is selected at runtime, but Percent is not populated or equals zero (0), then the Letter Grade (such as P, F, or I) is reported if available.

Otherwise, FinalGradeAverage is suppressed.

Academic Summary

Academic Summary applies only to students in grades 09 through 12 and graduates. This complex type is suppressed for all other students.

The calculation of the student’s cumulative grade point average for all coursework completed to date. The grade point average measures scholastic attainment computed by dividing the total number of grade points received by the total number of credits or hours of course work taken.

Note the following when TREx Export is run for a single student or a group of students:

• If GPA By Year is configured, the final Academic Summary will output GPA information based on the configuration used by the latest Academic Session from the GPA by Year table.

• If GPA By Year is not configured for one year but was for a prior year, then that GPA Type will be used.

• If GPA by Year is not configured, the final Academic Summary will output GPA information based on the GPA Type set on the building export configuration page.

Based on the values entered at runtime in the Use Class Rank/GPA Overrides, Exclude Class Rank, and Use Calculated Class Rank fields.

The total number of students within a grade level that are expected to comprise a graduating class.

Based on the values entered at runtime in the Use Class Rank / GPA Overrides, Exclude Class Rank, and Use Calculated Class Rank fields.

The academic ranking of the student within their grade level or graduating class. Class ranking is required by Grade 11.

Note that the default value of zero (0) is reported if your campus does not rank students.

Based on the values entered at runtime in the Use Class Rank/GPA Overrides, Exclude Class Rank, and Use Calculated Class Rank fields.

The date on which the campus or district calculated the class rank of students. Date of Ranking is required on the high school transcript by Grade 11.

Based on the value entered at runtime in the Class Rank Date Override parameter, if populated.

Indicates a quarter percent of the total class number in which the student is ranked. Quartiles divide the distribution of the class into four groups having an equal percentage (that is, top 25%, top 50%, lower 50%, lower 25%).

They are calculated based on Rank/Number in Class. If Class Rank is reported as any value other than 0, the Quartile is calculated and reported as Rank/Number in Class.

• If result is = or < 0.25: '1'
• If result is 0.26 - 0.50: '2'
• If result is 0.51 - 0.75: '3'
• If result is > 0.75: '4'

If runtime parameter Exclude Class Rank = Yes, or if Rank is reported with a default value of 0: Quartile is suppressed.