TREx Extract

Choose which school(s) to include in the report by selecting one of the following options:

At the school level:

• The currently selected school is the default.

At the district level:

• Select Multiple Schools – Use the Ctrl or SHIFT key on your keyboard to click each school for which you want to run the extract.
• All Schools (default) – The report includes all student records on the PowerSchool server that meet the selection criteria.

Choose which students to include in the report by selecting one of the following options:

• The Selected [number] Students Only – Run the report for students in the current selection.
• All students – Run the report for all students in the current school or district that meet the selection criteria.

Note: If you are running the TREx Extract by Student Number, enter up to ten student numbers for which to run the report.

Choose an option for which historical grades to include.

• All (default)
• High School Credit Courses Only

Choose how to display the grade.

• Percent (default)
• Letter

Choose which calculated class rank overrides to use:

• Graduates Only  (default) – The report outputs the class rank data previously copied to the Graduation Information page for graduated students only.
• All Students – The report outputs the class rank data previously copied to the Graduation Information page for all students who meet the selection criteria.
• Do Not Use – The report outputs class rank based on the current values stored in the Class Rank table or, if blank, the report calculates rank at runtime.

Choose Yes or No (default) to indicate whether to exclude the Class Rank.

Note: If Yes, the Class Size, Class Rank, Class Rank Date, and Quartile are suppressed.

Choose the Class Rank/GPA Method. This list is populated from School > Class Rank > Class Rank Methods.

Choose Yes or No (default) to indicate whether to use GPA Override.

If No, the GPA from the Class Rank table is used. If Yes, the GPA Override on the Graduation Information page is used. If the GPA Override is blank, the GPA is calculated on the fly using the GPA defined in the Class Rank Method.

Select Yes or No (default) to indicate whether to use class rank overrides.

Enter the class rank override date. If populated, this date will override the Class Rank Date stored in the Class Rank table.

Note: This field is required if Use Class Rank Overrides is Yes. 

[Students]Father

[Students]Mother

[Students]Father

[Students]Mother

[Students]Father

[Students]Mother

Gender Code

Gender

The student's gender.

[Students]Gender

Ethnicity Code

Race

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

Note: Required for Students prior to 2010-2011 School Year.

[Students]Ethnicity

American Indian/Alaska Native

AmericanIndianAlaskaNativeCode

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

[StudentRace]RaceCD

Asian

AsianCode

Black/African American

Hispanic/ Latino

Native Hawaiian/Pacific Islander

White

[S_TX_STU_X]Home_Language_Survey_Date, if populated

The number for the student's current or most recent school of enrollment.

[Schools]Alternate_School_Number

[Schools]School_Number

Grade Level

The student's current grade level.

[S_TX_STU_X]State_Grade_Level, if populated

Otherwise: [Students]Grade_Level

If the student is a graduate: '12'

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

[Students]EntryDate

Original Entry Date may be in the current school year or in a 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.

[Students]ExitDate

Last Date of Attendance may be in the current school year or in 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.

[Students]ExitDate

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. 

If the Local Exit Code is mapped to a State Exit Code, the report outputs the State Exit Code.

[Students]ExitCode

[Gen]Value2

[Gen]Cat=exitcodes

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 [Students]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: Grade of Retention is only reported for students in grades K - 8.

[Students]Grade_Level

[Reenrollments]Grade_Level

[S_TX_SEN_ESL_X]E0790_LEP_Indicator

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, the code is reported. 

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

[S_TX_SEN_ESL_X]Dual_Lang_Year

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

Dual Language
Immersion Language
Code

[S_TX_SEN_ESL_X]Dual_Lang_Language

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

[S_TX_SEN_ESL_X]Dual_Lang_Assmt_Met_Date

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

Dual Language
Immersion Completion
School Year

[S_TX_SEN_ESL_X]Dual_Lang_Completion_Year

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.

[S_TX_SEN_ECON_X]E0785_Econ_Disadvantaged

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.

[S_TX_SEN_ATRISK_X]E0919_AtRisk_Ind

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.

School: [Schools]E0894

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

Otherwise:

Student: [S_TX_SEN_TTITLE1_X]E0894_Title1_Ind

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

Otherwise: If there is no Title I Participation record 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.  

Calculated from [S_TX_SEN_SPD_X]E0173_InstrSetting

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.  

Calculated from [S_TX_SEN_SPD_X]E0173_InstrSetting 

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.

[S_TX_SEN_ESL_X]E1042_Bilingual_Program 

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, the code is reported.
 
Otherwise: A default of '0' is reported.

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

[S_TX_SEN_ESL_X]E1043_ESL_Program

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, the code is reported.
 
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.

[S_TX_SEN_GT_X]E0034_GT

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 enrolled in a state-approved Career and Technical Education course as an elective, as a participant in the district’s career and technical coherent sequence of courses, or as a participant in the district’s technical prep program.

[S_TX_SEN_CTE_X]E0031_CTE_Override, if populated and in effect on the TREx run date.

[S_TX_SEN_CTE_X]E0031_CTE_Ind if in effect on the TREx run date.

Otherwise: A default of '0' is reported.

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

[S_TX_STU_X]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.  

Notes:

• ACT and SAT assessments are reported under Additional Test Name and Assessment Subtest.
• If the assessment name is provided, then 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.

Derived from:

[Test]Code

[TestScore]Name

[StudentTestScore]AlphaScore

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

Notes:

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

[Test]Name

[TestScore]Name

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

Note: The Assessment Grade Level is reported for all assessments except ACT and SAT subtests.

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

Note: The Assessment Date is reported for all assessments except ACT and SAT subtests.

[StudentTest]Test_Date

Note: 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

[S_TX_STU_X]Assessment_Exit_Date_LArts

[S_TX_STU_X]Assessment_Exit_Date_Math

[S_TX_STU_X]Assessment_Exit_Date_SStudies

[S_TX_STU_X]Assessment_Exit_Date_Science

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

Notes :

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

[StudentTestScore]NumScore, if populated.

Test exemptions for TAKS Exit and STAAR EOC also reference: [StudentTestScore]AlphaScore

Waived EOC assessments also reference:
[S_TX_SGR_X]Alt_Course_Number
[S_TX_SGR_X]Explanation_Code_Combined = 3
[S_TX_SGR_X]E0948
[S_TX_CRS_X]Course_Sequence
Refer to STARR EOC Assessments for more information on EOC waiver criteria.

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.

[StudentTestScore]PercentScore, if populated.

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

For STAAR & EOC Assessments dated PRIOR to March 2017:
A value of 1, 2, or 3 is reported, as entered in PowerSchool.

For STAAR & 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: SubtestName is only reported for ACT and SAT subjects.

[TestScore]Name

Where [StudentTestScore]NumScore is not blank or null.

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

Notes:

• SubtestScore is only reported for 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

Calculated

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. 

Calculated

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.

Derived from:

[S_TX_STU_IMM_X]IMM_Name_1_Date

Note: Name equals the abbreviation for each immunization name.

Exemptions:

If the student has a current Exemption for the immunization (where Exemption Expires > 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 both a Dose record & Date of Disease, the Date of Disease ([S_TX_STU_IMM_X]Varicella_Date_Of_Disease) takes precedence.

Output: Varicella-Has had 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.

[S_TX_STU_IMM_X]IMM_Name_1_Date

[S_TX_STU_IMM_X]IMM_ Name _2_Date

[S_TX_STU_IMM_X]IMM_ Name _3_Date

[S_TX_STU_IMM_X]IMM_ Name _4_Date

[S_TX_STU_IMM_X]IMM_ Name _5_Date

[S_TX_STU_IMM_X]IMM_ Name _6_Date

[S_TX_STU_IMM_X]IMM_ Name _7_Date

[S_TX_STU_IMM_X]IMM_ Name _8_Date

[S_TX_STU_IMM_X]IMM_ Name _9_Date

[S_TX_STU_IMM_X]IMM_ Name _10_Date

Note: 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 ([S_TX_STU_IMM_X]Varicella_Date_Of_Disease) is reported.

TB: The Date of the Test is reported.

[S_TX_STU_IMM_X]IMM_Name_1_Date

[S_TX_STU_IMM_X]IMM_Name_2_Date

[S_TX_STU_IMM_X]IMM_Name_3_Date

[S_TX_STU_IMM_X]IMM_Name_4_Date

[S_TX_STU_IMM_X]IMM_Name_5_Date

[S_TX_STU_IMM_X]IMM_Name_6_Date

[S_TX_STU_IMM_X]IMM_Name_7_Date

[S_TX_STU_IMM_X]IMM_Name_8_Date

[S_TX_STU_IMM_X]IMM_Name_9_Date

[S_TX_STU_IMM_X]IMM_Name_10_Date

Note: Name equals the abbreviation for each immunization name.

The local disciplinary action number used to report an unexpired disciplinary event for a student.

The type of unexpired disciplinary action taken for a student. 

[Incident_Action]Incident_ID

[Incident_Detail]LU_Code_ID

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

[Incident_Detail]LU_Code_ID where

[Incident_Detail]Primary_Indicator = 1

Academic Status

The month and year that the student graduated from high school

[S_TX_STU_X]E0791, if populated

Otherwise: GraduationDate is suppressed

The month and year that the student met the speech requirement for an FHSP diploma.

[S_TX_STU_X]FHSP_Sp_Req_Met

Only applies to, and is required for, students participating in the FHSP program where Graduation Program Type = 34.

Otherwise: SpeechMetDate is suppressed.

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

Required in the final transcript (graduates).

[Students]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: CertificateDate is only reported for non-graduates.

[S_TX_STU_X]Cert_Course_Compl_Date, if populated

Otherwise: CertificateDate is suppressed.

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

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

[S_TX_STU_X]Grant_Ind

If Grad Plan =

• 15, 19, 22, 25, or 28: '1'
• 20, 23, 26, or 29: '2'
• 04, 05, 06, 07, 13, 18, 21, 24, or 27: '3'

Note: AdvancedMeasure is only reported for students with a Graduation Program Type of 29.

[S_TX_STU_X]Advanced_Measures

[S_TX_STU_X]Advanced_Measures2

[S_TX_STU_X]Advanced_Measures3

[S_TX_STU_X]Advanced_Measures4

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

Note: The FHSP Participant Code applies only to students in grades 9-12 and to graduates.

Valid Values:

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

[S_TX_STU_X]E1541_FHSP_Part

In all cases, 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 5: '1'
  • Otherwise: '0'

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

 Valid Values:

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

[S_TX_STU_X]E1542_FHSP_Dist

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'

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

[S_TX_STU_X]E1547_AH_End

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 successfully completed a Business and Industry Endorsement.

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

[S_TX_STU_X]E1545_BI_End

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 successfully completed a Multi-Disciplinary Studies Endorsement.

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

[S_TX_STU_X]E1548_MS_End

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 successfully completed a Public Services Endorsement.

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

[S_TX_STU_X]E1546_PS_End

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 successfully completed a Science, Technology, Engineering, and Mathematics Endorsement.

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

 [S_TX_STU_X]E1544_STEM_End

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.

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

If Graduation Type Code = 34, 54, 55, 56, or 57 AND Dual Credit Performance Acknowledgement Indicator is populated and does NOT = 0: [S_TX_STU_PERF_ACKN_C]Indicator_Value where
[S_TX_STU_PERF_ACKN_C]Performance_Indicator = DC

Otherwise: DualCreditType is suppressed.

The month and year that the student attained one of the Foundation High School Program Performance Acknowledgements.

Note: MetDate is reported for each Performance Acknowledgement.

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

[S_TX_STU_PERF_ACKN_C]Indicator_Value where
[S_TX_STU_PERF_ACKN_C]Performance_Indicator = 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.

The month and year that the student attained one of the Foundation High School Program Performance Acknowledgements.

[S_TX_STU_PERF_ACKN_C]Status_Date

[S_TX_STU_PERF_ACKN_C] Indicator_Value where
[S_TX_STU_PERF_ACKN_C] 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.

[S_TX_STU_PERF_ACKN_C]Status_Date

[S_TX_STU_PERF_ACKN_C] Indicator_Value where
[S_TX_STU_PERF_ACKN_C] 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.

The month and year that the student attained one of the Foundation High School Program Performance Acknowledgements.

[S_TX_STU_PERF_ACKN_C]Status_Date

PEIMS:
[S_TX_STU_PERF_ACKN_C] Indicator_Code  

FREE-FORM:
[S_TX_STU_PERF_ACKN_C] Indicator_Value where
[S_TX_STU_PERF_ACKN_C] Performance_Indicator is CL

If the student has one or more of 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.

The month and year that the student attained one of the Foundation High School Program Performance Acknowledgements.

Note: MetDate is reported for each Performance Acknowledgement.

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

[S_TX_STU_X]E1563

If IGC Review Code field = 01: '01'.

Otherwise: IGCGradReview is suppressed.

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: FHSPCollegeCareerInstructionIndicator is only reported for students in grades 7 and 8.

[S_TX_STU_X]FHSP_College_Career_Inst

If the student is in grades 7 or 8, AND FHSP College Career Instruction = Yes/1: '1'.

Otherwise: A default value of 0 is reported.

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

[S_TX_STU_X]E1596_Associate_Degree

If a student is in grade 11, grade 12, or Graduate has a value of Yes/1: ' 1'.

Otherwise: AssociateDegree is suppressed.

[S_TX_SGR_X]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.

[S_TX_SEN_504_X]E1603_Indicator

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

Otherwise: '0'.

[S_TX_STU_X]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.

[S_TX_STU_X]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.

[S_TX_STU_STATE_GEN_C]E1601_Star_Of_Texas

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

Otherwise: '0'.

Current Coursework

TREx Record Sorting

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

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

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

CourseID is reported from the first populated field:

[S_TX_SGR_X]Alt_Course_Number

[S_TX_SEC_MIXGRD_C]SERVICE_ID

[S_TX_SEC_X]Alt_Course_Number

[CoursesCoreFields]Alt_Course_Number

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

[S_TX_SEC_X]Abbrev_Course_Name

[S_TX_CRS_X]Abbrev_Course_Name

[Sections]TermID

Semester is based on Term ID 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.

For courses of any type with a term less than a full year, the semester is reported.

[Sections]Expression

[S_TX_SEC_X]AAR_Subject_Category

[S_TX_CRS_X]AAR_Subject_Category

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

Note: If one or more Stored Grades records exist with a store code that is not a final grade, these grades are reported. 

[StoredGrades]Grade

[StoredGrades]Percent

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 Format: Store Code -  Grade Earned

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

Notes:

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

[PGFinalGrades]Grade

[PGFinalGrades]Percent

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 Format: Store Code -  Grade Earned

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

[S_TX_SGR_X]Teacher_Name, if populated

Otherwise: [Sections]Teacher_Name

A sequence or portion of a course.

SemesterSeq is reported from the first populated field:

[S_TX_SGR_X]E0948

[S_TX_CC_X]E0948Course_Seq_Override

[S_TX_SEC_X]E0948_Course_Seq_Override

[S_TX_CRS_X]Course_Sequence

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:

• Default (A): 'Non-High School Credit'
• (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 student's current grade level (EE, PK –12).

[S_TX_STU_X]State_Grade_Level, if populated.

Otherwise: [Students]Grade_Level

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: 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/campus-assigned number for a locally-developed course. 

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

CourseID is reported from the first populated field:

[S_TX_SGR_X]Alt_Course_Number

[S_TX_SEC_X]Alt_Course_Number

[CoursesCoreFields]Alt_Course_Number

[S_TX_SGR_X]Abbrev_Course_Name

[S_TX_SEC_X]Abbrev_Course_Name

[S_TX_CRS_X]Abbrev_Course_Name

[StoredGrades]TermID

Semester is based on Term ID 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. 

[S_TX_SGR_X]AAR_Subject_Category

[S_TX_SEC_X]AAR_Subject_Category

[S_TX_CRS_X]AAR_Subject_Category

[StoredGrades]Grade

[StoredGrades]Percent

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. 
 

[StoredGrades]EarnedCrHrs

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.

PassFailCredit is reported from the first populated field:

[StoredGrades]GPA_Custom2

[S_TX_CC_X]PASS_FAIL_IND

If overrides are NOT populated, PassFailCredit is calculated based on [StoredGrades]Percent or [StoredGrades]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. 

[S_TX_SGR_X]Explanation_Code_Combined

[S_TX_SEC_X]Explanation_Code_Combined

[S_TX_CRS_X]Explanation_Code_Combined

[S_TX_SGR_X]Teacher_Name, if populated.

Otherwise: CourseTeacher is suppressed.

[StoredGrades]Alternate_CDC, if populated.

Otherwise: [StoredGrades]SchoolID

A sequence or portion of a course.

SemesterSeq is reported from the first populated field

[S_TX_SGR_X]E0948

[S_TX_CC_X]E0948Course_Seq_Override

[S_TX_SEC_X]E0948_Course_Seq_Override

[S_TX_CRS_X]Course_Sequence

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'

[S_TX_SGR_X]AAR_AVG_Override

[StoredGrades]Grade

[StoredGrades]Percent

If [S_TX_SGR_X]AAR_AVG_Override is not populated, the Stored Grade code that is the Final Grade and mapped to Final Grade Type of Average in TX Store Code Mapping 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 - 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 is a measure of scholastic attainment computed by dividing the total number of grade points received by the total number of credits or hours of course work taken.

Notes:

• GPA is reported based on the selection made in the report parameters.
• If the student does not have a GPA value, this field is not visible in the report.

Based on the values entered at runtime in the Use Class Rank/GPA Overrides, Exclude Class Rank, and Use Calculated Class Rank Fields from Class Rank Tab parameters.

If Use Calculated Class Rank Fields from Class Rank Tab parameter applies for this student: [S_TX_STU_X]Calc_Class_Rank_GPA

If Use Class Rank/GPA Overrides = No:

• [ClassRank]GPA, if populated.
• Otherwise: GPA is suppressed.  

If Use Class Rank/GPA Overrides = Yes:

• [S_TX_STU_X]GPA_Override, if populated.
• Otherwise: GPA is suppressed. 

If Exclude Class Rank = No, and Use Class Rank/GPA Overrides = Yes:

• [S_TX_STU_X]GPA_Override, if populated.
• Otherwise: GPA is calculated using the Class Rank/GPA Method selected at runtime.   
• If Class Rank/GPA Method is blank, GPA is suppressed.  

If Exclude Class Rank = No, and Use Class Rank/GPA Overrides = No:

• [ClassRank]GPA, it populated.
• Otherwise: GPA is calculated using the Class Rank/GPA Method selected at runtime.
• If Class Rank/GPA Method is blank, GPA is suppressed. 

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 from Class Rank Tab parameters.

If Use Calculated Class Rank Fields from Class Rank Tab parameter applies for this student: [S_TX_STU_X]Calc_Class_Size

If Exclude Class Rank = No, and Use Class Rank/GPA Overrides = Yes:

• [S_TX_STU_X]Class_Size, if populated.
• Otherwise: All Rank elements (ClassTotalNumber, ClassRank, ClassRankingDate, and Quartile) are suppressed.

If Exclude Class Rank = No, and Use Class Rank/GPA Overrides = No

• [ClassRank]OutOf, if populated.
• Otherwise: All Rank elements (ClassTotalNumber, ClassRank, ClassRankingDate, and Quartile) are suppressed.

If Exclude Class Rank = Yes

• All Rank elements (ClassTotalNumber, ClassRank, ClassRankingDate, and Quartile) are suppressed.

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

Note: 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 from Class Rank Tab parameters.

If Use Calculated Class Rank Fields from Class Rank Tab parameter applies for this student: [S_TX_STU_X]Calc_Class_Rank

If Class Ranks have not been calculated for the current school year and no value is found in the Class Rank Override field, the report extracts the most recent value in the [ClassRank]Rank field.

If Exclude Class Rank = No, and Use Class Rank/GPA Overrides = Yes

• [S_TX_STU_X]Class_Rank, if populated
• Otherwise: All Rank elements (ClassTotalNumber, ClassRank, ClassRankingDate, and Quartile) are suppressed.

If Exclude Class Rank = No, and Use Class Rank/GPA Overrides = No:

• [ClassRank]Rank, if populated
• Otherwise: A default value of zero (0) is reported, and the ClassTotalNumber, ClassRankingDate, and Quartile are suppressed.

If Exclude Class Rank = Yes

• All Rank elements (ClassTotalNumber, ClassRank, ClassRankingDate, and Quartile) are suppressed.

The date on which the class rank of students was calculated by the campus or district. 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.

Otherwise, if Use Calculated Class Rank Fields from Class Rank Tab parameter applies for this student: [S_TX_STU_X]Calc_Class_Rank_Date

Otherwise: [S_TX_STU_X]Class_Rank_Date_Override, if populated.

Otherwise: [ClassRank]DateRanked

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

Indicates a quarter percentage 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 (i.e., top 25%, top 50%, lower 50%, lower 25%). 

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.

The unique, six-digit ID assigned by the College Board to a high school campus.  

[S_TX_SCH_SCHOOLS_X]CBCC_Number, if populated.

Otherwise: CollegeCampusCode is suppressed.