The following table provides the specific TREx elements organized by complex type, including the source of the data in the Aeries tables and pages.


See Configurations information on Texas - Student Academic Achievement Record (AAR)/Transcript.


* Fields with an asterisk may need to be mapped on Texas State Reporting > Code Translations.


Complex Type: Student Identification

Complex Type: Parent

Complex Type: StudentDemographic

Complex Type: School

Complex Type: Enrollment

Complex Type: SpecialPrograms

Complex Type: Assessment

Complex Type: Attendance

Complex Type: Immunizations

Complex Type: DisciplineAction

Complex Type: AcademicStatus

Complex Type: CurrentCourseWork

Complex Type: AcademicSession

Complex Type: AcademicSummary


Complex Type: Student Identification

TREx Element
(X) = Extracted
(I) = Imported
TREx ID & Code Table XML Name
(SR) = Student Record 
(TR) = AAR/Transcript
Aeries Table.FieldAeries PageLabelPEIMS ID & Code Table
TX-UNIQUE -STUDENT-ID (X) (I)

TE099

StudentUniqueID (SR)STU.CIDDemographics > Student Data 2Unique IDE1523

<StudentIdentification>

<StudentUniqueID>UUUUUUUUUU</StudentUniqueID>

</StudentIdentification>


where UUUUUUUUUU = STU.CID
FIRST-NAME (X) (I) TE039FirstName (SR) (TR)STU.FNDemographicsFirst NameE0703
<StudentIdentification>

<Name>

<FirstName>First</FirstName>

</Name>

</StudentIdentification>


where First = STU.FN

MIDDLE-NAME (X) (I) 

TE059

MiddleName (SR) (TR)STU.MNDemographicsMiddle NameE0704
<StudentIdentification>

<Name>

<MiddleName>Middle</MiddleName>

</Name>

</StudentIdentification>


where Middle = STU.MN

LAST-NAME (X) (I) 

TE055

LastName (SR) (TR)STU.LNDemographicsLast NameE0705

<StudentIdentification>

<Name>

<LastName>Last</LastName>

</Name>

</StudentIdentification>


where Last = STU.LN

GENERATION-CODE (X) (I) TE041

(TC11)

Suffix (SR) (TR)STU.SF *DemographicsSuffixE0706 (C012)
<StudentIdentification>

<Name>

<Suffix>X</Suffix>

</Name>

</StudentIdentification>


where X = STU.SF if present; otherwise omitted

PRIOR-ID (X)

TE065

PriorID (SR)ESD.EDDemographics > Student Data 2Prior SSN/StateIDE0990
<StudentIdentification>

<PriorID>XXXXXXXXX</PriorID>

</StudentIdentification>

STUDENT-ID (X) (I) TE072StudentID (SR) (TR)ESD.EDDemographics > Student Data 2Soc-Sec-Num/S-NumberE0001
<StudentIdentification>

<StudentID>CCCCCCCCC</StudentID>

</StudentIdentification>


where CCCCCCCCC = ESD.ED

LOCAL-STUDENT-ID (X)

TE058


LocalID (SR) (TR)STU.IDDemographicsStudent IDE0923
<StudentIdentification>

<LocalID>XXXXXXXX</LocalID>

</StudentIdentification>


where XXXXXXXX = STU.ID

ADDRESS (X) (I) TE002Address (SR) (TR)STU.ADDemographicsAddress (Mailing)N/A
<StudentIdentification>

<Address>

<Address>Address</Address>

</Address>

</StudentIdentification>


where Address = STU.AD

CITY (X) (I) TE016City (SR) (TR) STU.CYDemographicsCity (Mailing)N/A
<StudentIdentification>

<Address>

<City>City</City>

</Address>

</StudentIdentification>


where City = STU.CY

STATE (X) (I) TE071 (TC20)StateProvince (SR) (TR) STU.STDemographicsState (Mailing)N/A
<StudentIdentification>

<Address>

<StateProvince>XX</StateProvince>

</Address>

</StudentIdentification>


where XX = STU.ST

COUNTRY (X) (I) TE020 (TC04)Country (TR)STU.CNDemographicsCountry (Mailing)N/A

<StudentIdentification>

<Address>

<Country>XX</Country>

</Address>

</StudentIdentification>


where XX = STU.CN
ZIP-CODE (X) (I) TE079PostalCode (SR) (TR)STU.ZCDemographicsZip (Mailing)N/A
STU.ZXExtn (Mailing)

<StudentIdentification>

<Address>

<PostalCode>NNNNN-XXXX</PostalCode>

</Address>

</StudentIdentification>


where:
  • NNNNN = STU.ZC
  • XXXX = STU.ZX if present


Complex Type: Parent ↑

  • Up to nine are extracted.
TREx Element
(X) = Extracted
(I) = Imported
TREx ID & Code Table XML Name
(SR) = Student Record 
(TR) = AAR/Transcript
Aeries Table.FieldAeries PageLabelPEIMS ID & Code Table
FIRST-NAME (X)
TE039
FirstName (SR)
CON.FN
ContactsFirst NameN/A
CON.LW = Y, orLives With
CON.ERH = Y, orEd Rights Holder
CON.PC = Y, orPrimary Contact
CON.AP = YPortal

<Parent>

<Name>

<FirstName>First</FirstName>

</Name>

</Parent>


where First = CON.FN if:
  • CON.LW = Y, or
  • CON.ERN = Y, or
  • CON.PC = Y, or 
  • CON.AP = Y
MIDDLE-NAME (X) TE059
MiddleName (SR) CON.MN
ContactsMiddle NameN/A
CON.LW = Y, orLives With
CON.PC = Y, orPrimary Contact
CON.ERH = Y, orEd Rights Holder
CON.AP = YPortal
<Parent>

<Name>

<MiddleName>Middle</MiddleName>

</Name>

</Parent>


where First = CON.MN if:
  • CON.LW = Y, or
  • CON.ERN = Y, or
  • CON.PC = Y, or 
  • CON.AP = Y
LAST-NAME (X) TE055
LastName (SR)CON.LNContactsLast NameN/A
CON.LW = Y, orLives With
CON.PC = Y, orPrimary Contact
CON.ERH = Y, orEd Rights Holder
CON.AP = YPortal
<Parent>

<Name>

<LastName>Last</LastName>

</Name>

</Parent>


where First = CON.LN if:
  • CON.LW = Y, or
  • CON.ERN = Y, or
  • CON.PC = Y, or 
  • CON.AP = Y
GENERATION-CODE (X)
TE041) (TC11)
Suffix (SR) CON.SFContactsSuffixN/A
CON.LW = Y, or
Lives With
CON.PC = Y, orPrimary Contact
CON.ERH = Y, orEd Rights Holder
CON.AP = YPortal
<Parent>

<Name>

<Suffix>X</Suffix>

</Name>

</Parent>


where X = CON.SF if:
  • CON.LW = Y, or
  • CON.ERN = Y, or
  • CON.PC = Y, or 
  • CON.AP = Y; omitted if blank


Complex Type: StudentDemographic ↑

TREx Element
(X) = Extracted
(I) = Imported
TREx ID & Code Table XML Name
(SR) = Student Record 
(TR) = AAR/Transcript
Aeries Table.FieldAeries PageLabelPEIMS ID & Code Table
MIGRANT-INDICATOR (X)

TE060 (TC16)


Migrant (SR)SSD.SUS
DemographicsUS Schl < 3 Yrs
E0784 (C088)

<StudentDemographic>

<Migrant>0/1</Migrant>
</StudentDemographic>


where 0/1 = 1 if SSD.SUS = Yes; otherwise omitted
DYSLEXIA-INDICATOR-CODE (X) TE102 (TC16)Dyslexia (SR) PGM.CD = 400 *Special ProgramsProgram CodeE1530 (C088)
<StudentDemographic>

<Dyslexia>0/1</Dyslexia>
</StudentDemographic>


where 0/1 = 1 if PGM.CD=400; otherwise omitted
DYSLEXIA-RISK-CODE (X) TE141 (TC24)DyslexiaRiskCodeTypePGM.CD = 399 *Special Programs > Current ProgramsProgram CodeE1644 (C222)
PGR.CD = 399Special Programs > Program Screenings
<StudentDemographic>

<DyslexiaRiskCode>01/02/03</DyslexiaRiskCode>
</StudentDemographic>


where  XX = 

  • 02 if PGM.CD = 399, otherwise
  • 01 if PGR.CD = 399, otherwise
  • 03 (not screened/default)

Only reported for students in KG and 1st grade. For all other grade levels, must be blank/not reported.  

ETHNICITY-CODE 

TE038 (TC09)

Race (SR) (TR)------E0005 (C014)

Required for students prior to 2010-2011 school year.

FOSTER-CARE-INDICATOR-CODE (X)TE100 (TC33)FosterCare (SR)PGM.CD = 190 *Special ProgramsProgram CodeE1528 (C196)
PGM.TYProgram Type

<StudentDemographic>

<FosterCare>X</FosterCare>

</StudentDemographic>



where X = PGM.TY if PGM.CD=190; otherwise 0 
HOME-LANGUAGE-CODE (X) (I)TE048 (TC14)HomeLanguage (SR)STU.CLDemographicsHome LanguageE0895 (C092)

<StudentDemographic>

<HomeLanguage>XX</HomeLanguage>
</StudentDemographic>


where XX = STU.CL
HOME-LANGUAGE-SURVEY-DATE-ADMINISTERED (X) TE127

HomeLanguageSurveyDateAdministered (SR)

LAC.HLDDemographicsSurvey Completed DateN/A

<StudentDemographic>

<HomeLanguageSurveyDateAdministered>YYYY-MM-DD</HomeLanguageSurveyDateAdministered>
</StudentDemographic>


where YYYY-MM-DD = LAC.HLD
HOMELESS-INDICATOR (X)TE049 (TC32)Homeless (SR)PGM.CD = 191 *Special ProgramsProgram CodeE1082 (C189)
PGM.HDT *Homeless Dwelling Type
where X = PGM.HDT if PGM.CD=191; otherwise 0
MILITARY-CONNECTED (X)TE101 (TC34)


MilitaryConnected (SR)PGM.CD = 192 *Special ProgramsProgram CodeE1529 (C197)
PGM.TYProgram Type

<StudentDemographic>

<MilitaryConnected>X</MilitaryConnected>
</StudentDemographic>


where X = PGM.TY if PGM.CD=192; otherwise omitted
STUDENT-LANGUAGE-CODE (X) TE126 (TC14)StudentLanguage (SR)STU.HLDemographicsStudent Language

E1590 (C092)


<StudentDemographic>

<StudentLanguage>XX</StudentLanguage>
</StudentDemographic>


where XX = STU.HL
UNSCHOOLED-ASYLEE-REFUGEE (X)TE097 (TC30)AsyleeRefugeeCode (SR)PGM.CD = 406 *Special ProgramsProgram CodeE1076 (C183)
PGM.TYProgram Type

<StudentDemographic>

<AsyleeRefugeeCode>X</AsyleeRefugeeCode>
</StudentDemographic>


where X = PGM.TY if PGM.CD=406; otherwise omitted 
DATE-OF-BIRTH (X) (I)TE028BirthDate (SR) (TR)STU.BDDemographicsBirthdateE0006

<StudentDemographic>

<BirthDate>YYYY-MM-DD</BirthDate>
</StudentDemographic>


where YYYY-MM-DD = STU.BD

GENDER-CODE (X) (I)

TE040 (TC10)

Gender (SR) (TR)STU.GN *DemographicsGenderE0004 (C013)

<StudentDemographic>

<Gender>X</Gender>
</StudentDemographic>


where X = STU.GN
PK-ELIGIBLE-PREVIOUS-YEAR-INDICATOR-CODE (X) TE138 (TC16)

PkEligiblePreviousYear

ECD.PREEarly Childhood DevelopmentPK Eligible Previous YearE1649 (C088)

<StudentDemographic>

<PkEligiblePreviousYear>0/1</PkEligiblePreviousYear>

</StudentDemographic>


where 0/1 = 1 if ECD.PRE = Y; otherwise omitted


Complex Type: School ↑

TREx Element
(X) = Extracted
(I) = Imported
TREx ID & Code Table XML Name
(SR) = Student Record 
(TR) = AAR/Transcript
Aeries Table.FieldAeries PageLabelPEIMS ID & Code Table
CAMPUS-ID (X)TE011SchoolID (SR) (TR)LOC.CC + LOC.DC + LOC.SCSchool OptionsCounty + District + CampusE0266
<School>

<SchoolID>CCCDDDSSS</SchoolID>

</School>


where:
  • CCC = LOC.CC
  • DDD = LOC.DC
  • SSS = LOC.SC
CAMPUS-NAME (X)TE012SchoolName (SR) (TR)LOC.NMSchool OptionsSchool NameE0267
<School>

<SchoolName>Name</SchoolName>
</School>


where Name = LOC.NM
DISTRICT-ID (X)TE034DistrictID (SR) (TR)LOC.CC + LOC.DCSchool OptionsCounty + DistrictE0212

<School>

<DistrictID>CCCDDD</DistrictID>

</School>


where:
  • CCC = LOC.CC
  • DDD = LOC.DC
DISTRICT-NAME (X)TE035DistrictName (SR) (TR)LOC.NMSchool Options (district)District NameE0213

<School>

<DistrictName>Name</DistrictName>
</School>


where Name = LOC.NM

ADDRESS (X)TE002

Address (SR) (TR)LOC.ADSchool OptionsStreet AddressN/A
<School>

<Address>

<Address>Address</Address>
</Address>

</School>


where Address = LOC.AD
CITY (X)TE016City (SR) (TR)LOC.CYSchool OptionsCityN/A
<School>

<Address>

<City>City</City>

</Address>

</School>


where City = LOC.CY
STATE (X)TE071 (TC20)StateProvince (SR) (TR)
LOC.STSchool OptionsStateN/A

<School>

<Address>

<StateProvince>XX</StateProvince>

</Address>

</School>


where XX = LOC.ST
ZIP-CODE (X)TE079 PostalCode (SR) (TR)
LOC.ZCSchool OptionsZipN/A

<School>

<Address>

<PostalCode>NNNNN-NNNN</PostalCode>

</Address>

</School>


where NNNNN-NNNN = LOC.ZC
CAMPUS-PHONE (X)TE013PhoneNumber (SR) (TR)LOC.TLSchool OptionsTelephoneN/A
<School>
<PhoneNumber>NNNNNNNNNN</PhoneNumber>

</School>


where NNNNNNNNNN = LOC.TL
CAMPUS-FAX (X)TE010Fax (SR)LOC.FXSchool OptionsFaxN/A
<School>
<Fax>NNNNNNNNNN</Fax>

</School>


where NNNNNNNNNN = LOC.FX
Omitted if blank


Complex Type: Enrollment ↑

TREx Element
(X) = Extracted
(I) = Imported
TREx ID & Code Table XML Name
(SR) = Student Record 
(TR) = AAR/Transcript
Aeries Table.FieldAeries PageLabelPEIMS ID & Code Table
GRADE-LEVEL (X) (I)

TE043 (TC12)


GradeLevel (SR)ENR.GREnrollment HistoryGrdE0017 (C050)

<Enrollment>

<GradeLevel>XX</GradeLevel>

</Enrollment>


where XX = ENR.GR (most recent year)

GRADE-OF-RETENTION


TE044 (TC12)


GradeRetained (SR)
------N/A

<Enrollment>

<GradeRetained>NN</GradeRetained>

</Enrollment>


not currently extracted
LAST-DATE-OF-ATTENDANCE (X)
TE054
ExitDate (SR)STU.LDDemographicsSchl Leave Dt
N/A

<Enrollment>

<ExitDate>YYYY-MM-DD</ExitDate>

</Enrollment>


where YYYY-MM-DD = STU.LD
LAST-WITHDRAWAL-DATE (X)
TE056WithdrawDate (SR)
STU.LDDemographicsSchl Leave DtN/A

<Enrollment>

<WithdrawDate>YYYY-MM-DD</WithdrawDate>

</Enrollment>


where YYYY-MM-DD = STU.LD + 1
ORIGINAL-ENTRY-DATE (X)TE062 EntryDate (SR)
STU.EDDemographics
Schl Enter DtN/A

<Enrollment>

<EntryDate>YYYY-MM-DD</EntryDate>

</Enrollment>


where YYYY-MM-DD = STU.ED of the student's original entry for this school and year
PLACED-IN-GRADE TE064 (TC12)GradePlaced (SR)
------N/A

<Enrollment>

<GradePlaced>XX</GradePlaced>

</Enrollment>


not currently extracted
PROMOTED-TO-GRADETE066 (TC12)
GradePromoted (SR)
------(C050)

<Enrollment>

<GradePromoted>NN</GradePromoted>

</Enrollment>


not currently extracted
WITHDRAWAL-REASON (X)

TE078 (TC23)

WithdrawReason (SR)
ENR.ER * Enrollment HistoryExit ReasonE1001 (C162)

<Enrollment>

<WithdrawReason>XX</WithdrawReason>

</Enrollment>


where XX ENR.ER (last ENR record at the school)


Complex Type: SpecialPrograms ↑

  • Only programs records that do not have an end date before the current date are extracted.
TREx Element
(X) = Extracted
(I) = Imported
TREx ID & Code Table XML Name
(SR) = Student Record 
(TR) = AAR/Transcript
Aeries Table.FieldAeries PageLabelPEIMS ID & Code Table
LEP-INDICATOR-CODE (X)

TE057

(TC15)

LEP (SR)PGM.TY
Special ProgramsType
E0790 (C061)
PGM.CD = 148Code
<SpecialPrograms>

<LEP>X</LEP>
</SpecialPrograms>


where X = PGM.TYP if PGM.CD = 148

ALTERNATIVE-LANGUAGE-PROGRAM-CODE (X) 
TE125 (TC41)AlternativeLanguage (SR)PGM.ALPSpecial ProgramsAlt Lang PrgmE1642 (C221)
PGM.CD = 145, 146, or 147 *Program Code

<SpecialPrograms>

<AlternativeLanguage>XX</AlternativeLanguage>

</SpecialPrograms>


where XX = PGM.ALP if PGM.CD = 145, 146, or 147; otherwise omitted
DUAL-LANGUAGE-IMMERSION-COMPLETION-SCHOOL-YEAR (X)
TE131
CompletionSchoolYear (SR)
DLH.YRLanguage Assessment > Dual Language ImmersionYearN/A
DLH.CFCompleted
<SpecialPrograms>

<DualLanguageImmersion>

<CompletionSchoolYear>YYYY-YYYY</CompletionSchoolYear>

</DualLanguageImmersion>

</SpecialPrograms>


where YYYY-YYYY = DLH.YR if DLH.CF is selected

DUAL-LANGUAGE-IMMERSION-YEAR (X) TE128 (TC42)ImmersionYear (SR)DLH.YRLanguage Assessment > Dual Language Immersion
YearN/A
<SpecialPrograms>

<DualLanguageImmersion>

<ImmersionYear>YYYY-YYYY</ImmersionlYear>

</DualLanguageImmersion>

</SpecialPrograms>


where YYYY-YYYY = DLH.YR 

DUAL-LANGUAGE-IMMERSION-LANGUAGE-CODE (X) TE129 (TC43)
ImmersionLanguage (SR)
DLH.HL*Language Assessment > Dual Language Immersion
Language
N/A
<SpecialPrograms>

<DualLanguageImmersion>

<ImmersionLanguage>XX</ImmersionLanguage>

</DualLanguageImmersion>

</SpecialPrograms>


where XX = DLH.HL

DUAL-LANGUAGE-IMMERSION-ASSESSMENT-MET-DATE (X) TE130
AssessmentMetDate (SR)
DLH.PDTLanguage Assessment > Dual Language Immersion
Proficient DateN/A
<SpecialPrograms>

<DualLanguageImmersion>

<AssessmentMetDate>YYYY-MM</AssessmentMetDate>

</DualLanguageImmersion>

</SpecialPrograms>


where YYYY-MM = DLH.PDT (converted to YYYY-MM format)

AT-RISK-INDICATOR (X) 
TE008 (TC16)
AtRisk (SR)PGM.CD = 409 *
Special ProgramsProgram Code
E0919 (C088)

<SpecialPrograms>

<AtRisk>0/1</AtRisk>

</SpecialPrograms>


where 0/1 = 1 if PGM.CD = 409; otherwise 0
TITLE-I-PART-A-INDICATOR (X) 
TE074 (TC22)




TitleI (SR)


PGM.TYSpecial ProgramsProgram TypeE0894 (C122)


PGM.CD = 121 or 122 *Program Code
or
LOC.T1
School OptionsTitle I Part A

<SpecialPrograms>
<TitleI>X</TitleI>
</SpecialPrograms>


where X = PGM.TY when PGM.CD = 121 or 122; or X = LOC.T1
SPECIAL-ED-INDICATOR (X) 

TE069 (TC16)


SpecialEd (SR)
CSE.DI (originates in DHS.DI)
Special Education > General
Primary DisabilityE0794 (C088)
CSE.ED/ CSE.XDEntry Date/Exit Date
DHS.DISpecial Education > Disabilities History
STU.LDDemographicsSchl Leave Dt
<SpecialPrograms>

<SpecialEd>0/1</SpecialEd>

</SpecialPrograms>


where 0/1 = 1 if:

  • CSE.DI and CSE.ED are populated, and 
  • CSE.XD is either NULL or >= STU.LD;
  • otherwise 0
IEP-INDICATOR (X)TE050 (TC16)
IEP (SR)CSE.ED/CSE.XDSpecial Education > GeneralEntry Date/Exit DateN/A
STU.LDDemographicsSchl Leave Dt
<SpecialPrograms>

<IEP>0/1</IEP>

</SpecialPrograms>


where 0/1 = 1 if:

  • CSE.ED is populated, and 
  • CSE.XD is either NULL or >= STU.LD; 
  • otherwise omitted
BILINGUAL-INDICATOR (X)
TE009 (TC26) Bilingual (SR) PGM.TYSpecial Programs

Program TypeE1042 (C175)


PGM.CD = 146 *Program Code

<SpecialPrograms>

<Bilingual>X</Bilingual>

</SpecialPrograms>


where X = PGM.TY when PGM.CD = 146; otherwise omitted

ESL-INDICATOR (X)

TE037 (TC28) ESL (SR)

PGM.TY
Special Programs

Program TypeE1043 (C176)


PGM.CD = 147 *
Program Code

<SpecialPrograms>

<ESL>X</ESL>

</SpecialPrograms>


where X = PGM.TY when PGM.CD = 147; otherwise omitted

GIFTED-TALENTED-INDICATOR (X)





TE042 (TC27)




GiftedTalented (SR)


PGM.CD = 127 * orSpecial ProgramsProgram CodeE0034 (C088)


GTE.SD/GTE.EDGifted/TalentedStart Date/End Date

<SpecialPrograms>

<GiftedTalented>0/1</GiftedTalented>

</SpecialPrograms>


where 0/1 = 1 if:

  • current date is between GTE.SD and GTE.ED; otherwise
  • PGM.CD = 127
otherwise omitted
PERSONAL-GRADUATION-PLAN
TE063 (TC16)
PersonalGradPlan (SR)
------N/A
CAREER-TECH-ED-INDICATOR (X) 
TE014 (TC03)
CTE (SR)PGM.CD = 154 *
Special ProgramsProgram CodeE0031 (C142)
PGM.TY
Program Type

<SpecialPrograms>

<CTE>X</CTE>

</SpecialPrograms>


where X = PGM.TY when PGM.CD = 154

PGM.TY = 5, E, 6, or 7, with default value of 4.

A student's CTE participation indicator can be recorded in Aeries on the Special Programs page; however, the calculated CTE indicator is provided by the TEA in a CSV file which can be imported info Aeries to populate the PGM.CD and PGM.TY fields. See Texas - Import CTE Indicator for TREx.

ECONOMIC-DISADVANTAGE-CODE (X)
TE036 (TC08)

EconomicDisadvantag

ed (SR)


FRE.CD * Free and Reduced
NSLP Lunch Type Code
E0785 (C054)

<SpecialPrograms>

<EconomicDisadvantaged>XX</EconomicDisadvantaged>

</SpecialPrograms>


where XX = FRE.CD if CD =  01, 02, or 99; otherwise omitted
SAT-ACT-TSIA-REIMBURSEMENT-INDICATOR (X) TE134

SATACTReimbursement (SR)

SSD.TFRSecondary Stu DataTest Fee ReimbursementN/A

<SpecialPrograms>

<SATACTReimbursement>X</SATACTReimbursement>

</SpecialPrograms>


where X = SSD.TRF if present; otherwise omitted
IBC-REIMBURSEMENT-INDICATOR (X) TE132IBCReimbursement (SR)ACT.IBSActivities and AwardsReimbursement StatusN/A
ACT.TY = 3Type
ACT.CD *Code

<SpecialPrograms>

<IBCReimbursement>XXX</IBCReimbursement>

</SpecialPrograms>


where XXX = ACT.IBS if:
POST-SECONDARY-CERTIFICATION-LICENSURE-EARNED (X) 

TE133 (TC44)

IBCEarned (SR)ACT.TY = 3Activities and AwardsTypeE1640 (C214)
ACT.CD *Code

<SpecialPrograms>

<IBCEarned>XXX</IBCEarned>

</SpecialPrograms>


where XXX = ACT.CD when ACT.TY = 3-Certifications, Licenses, and Program Completions
See Texas - Industry-Based Certifications & Performance Acknowledgements.
NOTE: ACT.CD values must be mapped to code values on Texas State Reporting > Options > Special Indicators Mappings. 


Complex Type: Assessment ↑

Most recent assessment is extracted and imported for:

  • STAAR EOC (TST.ID = STREOC%)
  • STAAR 3-8 (TST.ID = STR38%)
  • TELPAS Listening, Speaking, Reading and Writing (TST.ID = TELPAS%)

where % represents additional characters identifying specific versions of the test

TREx Element
(X) = Extracted
(I) = Imported
TREx ID & Code Table XML Name
(SR) = Student Record 
(TR) = AAR/Transcript
Aeries Table.FieldAeries Page Label
PEIMS ID & Code Table
ASSESSMENT-NAME (X) (I)TE004 (TC01)TestName (SR) (TR)
CTL.C0-CTL.C18
Testing Control TableC0-C18N/A
CTL.IDTest-ID
TST.IDTest ScoresTest ID
TST.GRGrade

<Assessment>

<TestName>XX</TestName>

</Assessment>


where XX = CTL.C0-CTL.C18 if:

  • The appropriate CTL.C## field corresponds to a test in the TC01 list for the appropriate grade level
    NOTE: CTL.C0-CTL.C18 correspond to grade levels
  • TST.ID corresponds to CTL.ID that has the corresponding CTL.C## fields set to a TC01 test
  • TST.GR corresponds to the CTL.C## grade
  • For all other tests, the <AdditionalTestName> element is extracted instead of <TestName>
ADDITIONAL-TEST-NAME (X) (I)
TE085 

AdditionalTestName (SR) (TR)

CTL.NMTesting Control TableTest Part TitleN/A
<Assessment>

<AdditionalTestName>Name</AdditionalTestName>

</Assessment>


where Name = CTL.NM

The <AdditionalTestName> element is extracted instead of <> for any test that is not part of the standard assessment code table TC01

ASSESSMENT-GRADE-LEVEL (X) (I) 

TE083 (TC12)



TestLevel (SR) (TR)TST.GRTest ScoresGrd Lvl(C050)

<Assessment>

<TestLevel>NN</TestLevel>

</Assessment>


where NN = TST.GR (zero padded)

ASSESSMENT-DATE (X) (I)TE003TestDate (SR) (TR)TST.TDTest ScoresDateN/A

<Assessment>

<TestDate>YYYY-MM</TestDate>

</Assessment>


where YYYY-MM = TST.TD (converted to YYYY-MM format)

ASSESSMENT-DATE-EXIT-REQUIREMENT-METTE095

ExitRequirementMetDate 

------N/A

not extracted

ASSESSMENT-SCORE (X) (I)TE005TestScore (SR) (TR)TST.SSTest Scores Scale ScoreN/A

<Assessment>

<TestScore>NNNNNN</TestScore>

</Assessment>


where NNNNNN = TST.SS

ASSESSMENT-SCORE-CODE (X) (I) TE006 (TC02)TestCode (SR) (TR)TEX.SPC * Testing ExclusionsSpecial ConditionsN/A

<Assessment>

<TestCode>X</TestCode>

</Assessment>


where X = TEX.SPC

TEX.SPC must be mapped on Texas State Reporting > Code Translations for code B.

STAAR-PERFORMANCE-LEVEL (X) (I)TE098 (TC31)PerformanceLevel (SR) (TR)TST.PLTest ScoresPerf LevelN/A
TEX.SPC = *Testing Exclusions

Special

Conditions

<Assessment>

<PerformanceLevel>X</PerformanceLevel>

</Assessment>


where X = TST.PL

For EOC, X = 

  • A if TST.PL > 3.99
  • 9 if TST.PL = 2.99-3.99
  • 8 if TST.PL = 1.99-2.99
  • 7 if TST.PL = .99-1.99

NOTE: For STAAR EOC tests, if TEX.SPC = B, the performance level will be set to indicate that the test was waived due to the 2020 COVID school year.

ASSESSMENT-SUBTESTTE007SubTestName (SR)------N/A
ASSESSMENT-SUBTEST-SCORETE086SubTestScore (SR)------N/A


Complex Type: Attendance ↑

TREx Element
(X) = Extracted
(I) = Imported
TREx ID & Code Table XML Name
(SR) = Student Record 
(TR) = AAR/Transcript
Aeries Table.FieldAeries PageLabelPEIMS ID & Code Table
TOTAL-DAYS-PRESENT (X)

TE076

DaysAttended (SR)
STU.DPAttendance HistoryPresentE0937

<Attendance>

<DaysAttended>NNN.N</DaysAttended>

</Attendance>


where NNN.N =STU.DP
Calculated when Attendance History Configuration is run with the Include Enrollment Totals in Nightly Attendance Processing option selected.
TOTAL-DAYS-ABSENT (X)

TE075


DaysAbsent (SR)
STU.DAAttendance History--E0036

<Attendance>

<DaysAbsent>NNN.N</DaysAbsent>

</Attendance>


where NNN.N = STU.DA
Calculated when Attendance History Configuration is run with the Include Enrollment Totals in Nightly Attendance Processing option selected.
RS-TOTAL-DAYS-PRESENT (X)

TE136


RSDaysAttended (SR)
AHS.RS
Attendance HistoryRemote Sync
 E16XX

<Attendance>
<RSDaysAttended>NNN.N</RSDaysAttended>

</Attendance>


where NNN.N = AHS.RS

RA-TOTAL- DAYS-PRESENT (X)

TE137


RADaysAttended (SR)
AHS.RA
Attendance HistoryRemote Async
E16XX

<Attendance>

<RADaysAttended>NNN.N</RADaysAttended>

</Attendance>


where NNN.N = AHS.RA


Complex Type: Immunizations ↑

TREx Element
(X) = Extracted
(I) = Imported
TREx ID & Code Table XML Name
(SR) = Student Record 
(TR) = AAR/Transcript
Aeries Table.FieldAeries PageLabelPEIMS ID & Code Table
IMMUNIZATION-NAME (X) TE053ImmunizationCode (SR)IMMImmunizationsDate 1-5N/A

<Immunization>

<ImmunizationCode>Immunization</ImmunizationCode>

</Immunization>


where Immunization =
  • 'Polio' if IMM.P1-IMM.P5 is populated
  • 'DTP' if IMM.D1-IMM.DB is populated 
  • 'MMR' if IMM.A1-IMM.A3 is populated 
  • 'Haemophilus influenzae type B' if IMM.Y1-IMM.Y4 is populated 
  • 'Hepatitis B' if IMM.I1-IMM.I4 is populated 
  • 'Varicella' if IMM.V1-IMM.VD is populated 
  • 'Hepatitis A' if IMM.HA1-IMM.HA2 is populated 
  • 'Physical' if IMM.H1 is populated 
  • 'PCV' if IMM.PC1-IMM.PC4 is populated
  • 'MCV4' if IMM.MC1-IMM.MC2 is populated 
  • 'Tdap' if IMM.TB is populated 
IMMUNIZATION-DATE (X) 

TE051 


ImmunizationDate (SR)IMM
ImmunizationsDate 1-5
N/A

<Immunization>

<ImmunizationDate>YYYY-MM-DD</ImmunizationDate>

</Immunization>


where YYYY-MM-DD = 

  • IMM.P1-IMM.P5 for Polio
  • IMM.D1-IMM.DB for Diphtheria, Tetanus, Pertussis 
  • IMM.A1-IMM.A3 for Measles, Mumps, Rubella 
  • IMM.Y1-IMM.Y4 for Haemophilus influenzae type b 
  • IMM.I1-IMM.I4 for Hepatitis B
  • IMM.V1-IMM.VD for Varicella
  • IMM.HA1-IMM.HA2 for Hepatitis A
  • IMM.H1 for Physical
  • IMM.PC1 for Pneumococcal (PCV)
  • IMM.MC1-IMM.MC2 for Meningococcal (MCV4) 
  • IMM.TB for Tdap
IMMUNIZATION-DOSE (X) TE052ImmunizationDose (SR)IMMImmunizationsDate 1-5N/A

<Immunization>

<ImmunizationDose>N</ImmunizationDose>

</Immunization>


where N =
  • 1 if IMM.P1, IMM.D1, IMM.A1, IMM.Y1, IMM.I1, IMM.V1, IMM.HA1, IMM.H1, IMM.MC1, or IMM.TB is populated
  • 2 if IMM.P2, IMM.D2, IMM.A2, IMM.Y2, IMM.I2, IMM.V2, IMM.H2, IMM.MC2, or IMM.PC2 is populated
  • 3 if IMM.P3, IMM.D3, IMM.A3, IMM.Y3, IMM.I3, or IMM.PC3 is populated
  • 4 if IMM.P4, IMM.D4, IMM.Y4, IMM.I4, or IMM.PC1 is populated
  • 5 if IMM.P5 or IMM.D5 is populated
  • Booster, if applicable
  • Contracted, if applicable


Complex Type: DisciplineAction ↑

  • Only unexpired Assertive Discipline records are extracted.
TREx Element
(X) = Extracted
(I) = Imported
TREx ID & Code Table XML Name
(SR) = Student Record 
(TR) = AAR/Transcript
Aeries Table.FieldAeries PageLabelPEIMS ID & Code Table
DISCIPLINARY-ACTION-END-DATE (X)
TE031
DisciplineActionDate (SR)
DSP.EDAssertive DisciplineServed - End DateN/A

<DisciplineAction>

<DisciplineActionDate>YYYY-MM-DD</DisciplineActionDate>

</DisciplineAction>


where YYYY-MM-DD = DSP.ED, only if DSP.ED > current date
DISCIPLINARY-ACTION-NUMBER (X)

TE032


DisciplineActionNum (SR)
DSP.SQ, DSP.SQ1
Assertive Discipline
sequence number - not displayedE1004

<DisciplineAction>

<DisciplineActionNum>NNN</DisciplineActionNum>

</DisciplineAction>


where NNN = DSP.SQ-DSP.SQ1
DISCIPLINARY-ACTION-CODE (X)

TE030

(TC06)


DisciplineActionCode (SR)
DSP.DS *
Assertive Discipline
Administrative DecisionE1005 (C164)
COD.DEUpdate Code Table

<DisciplineAction>

<DisciplineActionCode>XX</DisciplineActionCode>

</DisciplineAction>


where XX = DSP.DS

DSP.DS must be mapped on Texas State Reporting > Code Translations.
DISCIPLINARY-ACTION-REASON (X)

TE033

(TC07)

DisciplineActionReason (SR)
ADS.CD *
Assertive DisciplineViolationsE1006 (C165)
<DisciplineAction>

<DisciplineActionReason>XX</DisciplineReason>

</DisciplineAction>


where XX = ADS.CD

ADS.CD must be mapped on Texas State Reporting > Code Translations.


Complex Type: AcademicStatus ↑


TREx Element
(X) = Extracted
(I) = Imported
TREx ID & Code Table XML Name
(SR) = Student Record 
(TR) = AAR/Transcript
Aeries Table.FieldAeries PageLabelPEIMS ID & Code Table
GRADUATION-DATE (X) 

TE046


GraduationDate (TR)STU.DGDemographics > Student Data 2Grad Type - DateE0791

<AcademicStatus>

<GraduationDate>YYYY-MM</GraduationDate>

</AcademicStatus>


where YYYY-MM = STU.DG (converted to YYYY-MM format)
SPEECH-REQUIREMENT-MET-DATE (X) TE116SpeechMetDate (SR) (TR)ACT.DTActivities and AwardsDateN/A
ACT.TY = 5Type
ACT.CD = G01 *Code

<AcademicStatus>

<SpeechMetDate>YYYY-MM</SpeechMetDate>
</AcademicStatus>


where YYYY-MM = ACT.DT (converted to YYYY-MM format) if:
  • ACT.TY = 5-Other, and
  • ACT.CD = G01

ACT.CD must be mapped on Texas State Reporting > Code Translations.

GRADUATION-PROGRAM-TYPE (X) 

TE047 (TC13)


GraduationDiplomaType (TR-final)STU.HSG *Demographics > Student Data 2Grad Type - CodeE0806 

(C062)

<AcademicStatus>

<GraduationDiplomaType>XX</GraduationDiplomaType>

</AcademicStatus>


where XX = STU.HSG
CERTIFICATE-COMPLETION-DATE (X) TE015CertificateDate (TR)STU.CDTDemographics > Student Data 2Certificate of Completion - DateN/A

<AcademicStatus>

<CertificateDate>YYYY-MM-DD</CertificateDate>

</AcademicStatus>


where YYYY-MM-DD = STU.CDT
TEXAS-GRANT-INDICATOR (X) TE073 (TC21)TexasGrant (TR)ACT.TY = 2Activites and AwardsTypeN/A
ACT.CD = Texas Grant *Code

<AcademicStatus>

<TexasGrant>X</TexasGrant>

</AcademicStatus>


Not extracted for any student graduating under FHSP
ADVANCED-MEASURE (X)
TE096 (TC29)

AdvancedMeasure (SR) (TR)

------N/A
Obsolete. No longer extracted
FHSP-PARTICIPANT-CODE (X) TE103 (TC35)



FHSPParticipationCode (SR) (TR) STU.HSG * Demographics > Student Demo 2Grad Type - CodeE1541 (C199)
STU.GRT *Graduation StatusGraduation Track
REQ.GRT *Graduation RequirementsTrack

<AcademicStatus>
<FHSPParticipationCode>X</FHSPParticipationCode>

</AcademicStatus>


where X = 

  • 2 if STU.HSG = 34, 35, 55-57
  • 1 if:
    • STU.HSG <> 34, 35, 55-57, and
    • STU.GRT = 34, 35, 55-57, or blank
  • 0 if:
    • STU.HSG <> 34, 35, 55-57, and 
    • STU.GRT <> 34, 35, 55-57

REQ.GRT/STU.GRT values must be added on the Graduation Requirements page (Track > New).

REQ.GRT/STU.GRT values must be mapped on Texas State Reporting > Code Translations (Graduation Plan Type Descriptor (REQ.GRT)).

FHSP-DISTING-LEVEL-ACHIEVE-INDICATOR-CODE (X) TE104 (TC35)

FHSPDistingIndicatorCode (SR) (TR)

ACT.TY = 4Activities and AwardsTypeE1542 (C199)
ACT.CD = DLA *Code
ACT.RS *Reason

<AcademicStatus>
<FHSPDistingIndicatorCode>X</FHSPDistingIndicatorCode>

</AcademicStatus>


where X = 

  • 2 if:
    • ACT.TY = 4-Performance Acknowledgement, and 
    • ACT.CD = DLA/FHSP Distinguished Level Achievement, and 
    • ACT.RS = 2
  • 1 if:
    • ACT.TY = 4-Performance Acknowledgement, and 
    • ACT.CD = DLA/FHSP Distinguished Level Achievement, and 
    • ACT.RS = 1
  • otherwise 0

The following must be mapped on Texas State Reporting > Code Translations:

  • Distinguished Achievements (ACT.RS) 
  • Activities and Awards (ACT.CD) 
STEM-ENDORSEMENT-INDICATOR-CODE (X) 

TE105 (TC35)



STEMEndorsementCode (SR) (TR)GES.EC = ST *Graduation Status > Endorsement (Manage)Endorsement E1544 (C199)

GES.ST

Status
STU.EOOProfile > Endorsement (Manage), orOpt-out (11th and 12th grade only)
Graduation Status > Endorsement (Manage) 

<AcademicStatus>
<STEMEndorsementCode>X</STEMEndorsementCode>

</AcademicStatus>


where X = 

  • 0 if:
    • STEM Endorsement is not Selected on Graduation Status page, and 
    • No GES.EC = "ST" record exists 
  • 1 if:
    • STU.EOO is not selected, and  
    • STEM Endorsement is Selected on Graduation Status page, and 
    • GES.EC = "ST" record exists, and 
    • Current Status <> Complete (GES.ST <> CP) 
  • 2 if:
    • STU.EOO is not selected, and 
    • STEM Endorsement is Selected on Graduation Status page, and 
    • GES.EC = "ST" record exists, and
    • Current Status = Complete (GES.ST = CP)

On Update Code Tables

  • GES.EC must contain code ST (STEM).
  • GES.ST must contain code CP (complete).
GES.EC must be mapped on Texas State Reporting > Code Translations. 
BUSINESS-AND-INDUSTRY-ENDORSEMENT-INDICATOR-CODE (X) 

TE106 (TC35)


BusinessEndorsementCode (SR) (TR)


GES.EC = BI *

Graduation Status > Endorsement (Manage)EndorsementE1545 (C199)

GES.ST

Status
STU.EOOProfile > Endorsement (Manage), or Opt-out (11th and 12th grade only)
Graduation Status > Endorsement (Manage)

<AcademicStatus>
<BusinessEndorsementCode>X</BusinessEndorsementCode>

</AcademicStatus>


where X = 

  • 0 if:
    • Business Industry Endorsement is not Selected on Graduation Status page, and 
    • No GES.EC = "BI" record exists 
  • 1 if:
    • STU.EOO is not selected, and  
    • Business Industry Endorsement is Selected on Graduation Status page, and 
    • GES.EC = "BI" record exists, and 
    • Current Status <> Complete (GES.ST <> CP) 
  • 2 if:
    • STU.EOO is not selected, and 
    • Business Industry Endorsement is Selected on Graduation Status page, and 
    • GES.EC = "BI" record exists, and
    • Current Status = Complete (GES.ST = CP)

On Update Code Tables

  • GES.EC must contain code BI (Business Industry).
  • GES.ST must contain code CP (complete).
GES.EC must be mapped on Texas State Reporting > Code Translations.
PUBLIC-SERVICES-ENDORSEMENT-INDICATOR-CODE (X) 

TE107 (TC35)


PublicServicesEndorsementCode (SR) (TR)GES.EC = PS *Graduation Status > Endorsement (Manage)EndorsementE1546 (C199)
GES.STStatus
STU.EOOProfile > Endorsement (Manage), or Opt-out (11th and 12th grade only)
Graduation Status > Endorsement (Manage)

<AcademicStatus>

<PublicServicesEndorsementCode>X</PublicServicesEndorsementCode>

</AcademicStatus>


where X =

  • 0 if:
    • Public Service Endorsement is not Selected on Graduation Status page, and 
    • No GES.EC = "PS" record exists 
  • 1 if:
    • STU.EOO is not selected, and  
    • Public Service Endorsement is Selected on Graduation Status page, and 
    • GES.EC = "PS" record exists, and 
    • Current Status <> Complete (GES.ST <> CP) 
  • 2 if:
    • STU.EOO is not selected, and 
    • Public Service Endorsement is Selected on Graduation Status page, and 
    • GES.EC = "PS" record exists, and
    • Current Status = Complete (GES.ST = CP)

On Update Code Tables

  • GES.EC must contain code PS (Public Service).
  • GES.ST must contain code CP (complete).

GES.EC must be mapped on Texas State Reporting > Code Translations.

ARTS-AND-HUMANITIES-ENDORSEMENT-INDICATOR-CODE (X) 

TE108 (TC35)

ArtsEndorsementCode (SR) (TR)GES.EC = AH *Graduation Status > Endorsement (Manage)EndorsementE1547 (C199)

GES.ST


Status
STU.EOO


Profile > Endorsement (Manage) orOpt-out (11th and 12th grade only)
Graduation Status > Ensorsement (Manage)

<AcademicStatus>

<ArtsEndorsementCode>X</ArtsEndorsementCode>

</AcademicStatus>


where X =

  • 0 if:
    • Arts and Humanities is not Selected on Graduation Status page, and 
    • No GES.EC = "AH" record exists 
  • 1 if:
    • STU.EOO is not selected, and  
    • Arts and Humanities is Selected on Graduation Status page, and 
    • GES.EC = "AH" record exists, and 
    • Current Status <> Complete (GES.ST <> CP) 
  • 2 if:
    • STU.EOO is not selected, and 
    • Arts and Humanities is Selected on Graduation Status page, and 
    • GES.EC = "AH" record exists, and
    • Current Status = Complete (GES.ST = CP)

On Update Code Tables

  • GES.EC must contain code AH (Arts and Humanities).
  • GES.ST must contain code CP (complete).
GES.EC must be mapped on Code Translations.
MULTI-DISCIPLINARY-STUDIES-ENDORSEMENT-INDICATOR-CODE (X) 

TE109 (TC35)

MultiStudiesEndorsementCode (SR) (TR)GES.EC = MS *Graduation Status > Endorsement (Manage)EndorsementE1548 (C199)

GES.ST


Status
STU.EOOProfile > Endorsement (Manage) orOpt-out (11th and 12th grade only)
Graduation Status > Endorsement (Manage)

<AcademicStatus>

<ArtsEndorsementCode>X</ArtsEndorsementCode>

</AcademicStatus>


where X =

  • 0 if:
    • Multidisciplinary Studies is not Selected on Graduation Status page, and 
    • No GES.EC = "MS" record exists 
  • 1 if:
    • STU.EOO is not selected, and  
    • Multidisciplinary Studies is Selected on Graduation Status page, and 
    • GES.EC = "MS" record exists, and 
    • Current Status <> Complete (GES.ST <> CP) 
  • 2 if:
    • STU.EOO is not selected, and 
    • Multidisciplinary Studies is Selected on Graduation Status page, and 
    • GES.EC = "MS" record exists, and
    • Current Status = Complete (GES.ST = CP)

On Update Code Tables

  • GES.EC must contain code MS (Multidisciplinary Studies).
  • GES.ST must contain code CP (complete).
GES.EC must be mapped on Texas State Reporting > Code Translations.
PERFORMANCE-ACKNOWLEDGMENT-DUAL-CREDIT (X) TE114 (TC039)DualCreditCode (SR) (TR)ACT.TY = 4Activities and AwardsTypeN/A
ACT.CD = PA1 *Code
ACT.RS = PA1-1 or PA1-2 *Reason

<AcademicStatus>

<DualCreditType>

<DualCreditCode>X</DualCreditCode>

</DualCreditType>

</AcademicStatus>


where X = 

  • 2 if:
    • ACT.TY = 4-Performance Acknowledgement, and 
    • ACT.CD = PA1-Performance Acknowledgement Dual Credit, and
    • ACT.RS = PA1-2-Acknowledgement for college Credit hours
  • 1 if:
    • ACT.TY = 4-Performance Acknowledgement, and 
    • ACT.CD = PA1-Performance Acknowledgement Dual Credit 
    • ACT.RS =  PA1-1-Acknowledgement for Associates degree
  • otherwise omitted

The following must be mapped on Texas State Reporting > Code Translations:

  • Dual Credit (ACT.RS) 
  • Activities and Awards (ACT.CD)  
PERFORMANCE- ACKNOWLEGEMENT-MET-DATE (X) TE115MetDate (SR) (TR)ACT.DTActivities and AwardsDateN/A

<AcademicStatus>

<DualCreditType>

<MetDate>YYYY-MM</MetDate>

</DualCreditType>

</AcademicStatus>


where YYYY-MM = ACT.DT (converted to YYYY-MM format) when:

  • ACT.TY = 4
  • ACT.CD = PA1
  • ACT.RS = PA1-1 or PA1-2
PERFORMANCE-ACKNOWLEDGMENT-BILINGUALISM-BILITERACY (X) TE111 (TC37)BilingBilitCode (SR) (TR)ACT.TY = 4Activities and AwardsTypeN/A
ACT.CD = PA2 *Code

<AcademicStatus>

<BilingBilitType>

<BilingBilitCode>X</BilingBilitCode>

</BilingBilitType>

</AcademicStatus>


where X = 1 if:
  • ACT.TY = 4-Performance Acknowledgement, and
  • ACT.CD = PA2-Acknowledgement for Bilingualism/Biliteracy
  • otherwise omitted
PERFORMANCE- ACKNOWLEGEMENT-MET-DATE (X) TE115MetDate (SR) (TR)ACT.DTActivities and AwardsDateN/A

<AcademicStatus>

<BilingBilitType>

<MetDate>YYYY-MM</MetDate>

</BilingBilitType>

</AcademicStatus>


where YYYY-MM = ACT.DT (converted to YYYY-MM format) if:
  • ACT.TY = 4
  • ACT.CD = PA2
  • otherwise omitted
PERFORMANCE-ACKNOWLEDGMENT-COLLEGE-READINESS-ASSESSMENTS (X) TE113 (TC38)CollegeAssessCode (SR) (TR)
ACT.TY = 4Activities and AwardsTypeN/A
ACT.CD = PA5 * Code
ACT.RS *Reason

<AcademicStatus>

<CollegeAssessType>

<CollegeAssessCode>X</CollegeAssessCode>

</CollegeAssessType>

</AcademicStatus>


where X = 
  • 2 if:
    • ACT.TY= 4-Performance Acknowledgement, and 
    • ACT.CD = PA5-Performance Acknowledgement College Readiness Assessments
    • ACT.RS = PSAT-Acknowledgment for PSAT: Commended scholar or higher 
  • 3 if:
    • ACT.TY= 4-Performance Acknowledgement, and 
    • ACT.CD = PA5-Performance Acknowledgement College Readiness Assessments 
    • ACT.RS = ACT-Acknowledgment for ACT: Composite score 28 or higher 
  • 4 if:
    • ACT.TY= 4-Performance Acknowledgement, and 
    • ACT.CD = PA5-Performance Acknowledgement College Readiness Assessments 
    • ACT.RS = SAT1-Acknowledgment for SAT: Combined reading and math score 1250 or higher 
  • 5 if:
    • ACT.TY= 4-Performance Acknowledgement, and 
    • ACT.CD = PA5-Performance Acknowledgement College Readiness Assessments 
    • ACT.RS = SAT2-Acknowledgment for SAT: Scores of at least 410 on reading and 520 on math 
  • 6 if:
    • ACT.TY= 4-Performance Acknowledgement, and 
    • ACT.CD = PA5-Performance Acknowledgement College Readiness Assessments 
    • ACT.RS = SAT3-Acknowledgment for SAT: total score of at least 1310 
  • 7 if:
    • ACT.TY= 4-Performance Acknowledgement, and 
    • ACT.CD = PA5-Performance Acknowledgement College Readiness Assessments 
    • ACT.RS = ASPIRE-Acknowledgment for ASPIRE: College readiness benchmark met on 3 or more of the 5 subject tests 
  • otherwise omitted


The following must be mapped on Texas State Reporting > Code Translations:

  • Performance Acknowledgement College Readiness Assessments (ACT.RS) 
  • Activities and Awards (ACT.CD)  

PERFORMANCE- ACKNOWLEGEMENT-MET-DATE (X) 

TE115MetDate (SR) (TR)ACT.DTActivities and AwardsDateN/A

<AcademicStatus>

<CollegeAssessType>

<MetDate>YYYY-MM</MetDate>

</CollegeAssessType>

</AcademicStatus>


where YYYY-MM = ACT.DT (converted to YYYY-MM format) if:
  • ACT.TY = 4
  • ACT.CD = PA5
  • ACT.RS = ACT, PSAT, SAT1, SAT2, SAT3, or ASPIRE
  • otherwise omitted
PERFORMANCE-ACKNOWLEDGMENT-AP-IB-EXAMS (X) TE110 (TC36)ApIbCode (SR) (TR)ACT.TY = 4Activities and AwardsTypeN/A
ACT.CD = PA3 or PA4 *Code
ACT.RS *Reason

<AcademicStatus>

<ApIbType>

<ApIbCode>XX</ApIbCode>

</ApIbType>

</AcademicStatus>


where XX =ACT.RS if:
  • ACT.TY = 4-Performance Acknowledgement
  • ACT.CD = PA3-Performance Acknowledgement AP Exams, or PA4-Performance Acknowledgement IB Exams
  • ACT.RS = PA1-PA36 for AP exams, or PA37-PA186 for IB exams

The following must be mapped on Texas State Reporting > Code Translations:

  • Performance Acknowledgement AP Exams (ACT.RS)
  • Performance Acknowledgement IB Exams (ACT.RS) 
  • Activities and Awards (ACT.CD)  
PERFORMANCE- ACKNOWLEGEMENT-MET-DATE (X) TE115

MetDate (SR) (TR)

ACT.DT

Activities and Awards

Date

N/A

<AcademicStatus>

<ApIbType>

<MetDate>YYYY-MM</MetDate>

</ApIbType>

</AcademicStatus>


where YYYY-MM = ACT.DT (converted to YYYY-MM format) if: 
  • ACT.TY = 4
  • ACT.CD = PA3 or PA4
  • ACT.RS = PA1-PA186
PERFORMANCE-ACKNOWLEDGMENT-CERTIFICATION-LICENSURES (X) TE112CertLicCode (SR) (TR)ACT.TY = 4Activities and AwardsTypeN/A
ACT.CD = PA6 *Code
ACT.RS *Reason

<AcademicStatus>

<CertLicType>

<CertLicCode>Code</CertLicCode>

</CertLicType>

</AcademicStatus>


where Code = ACT.RS if:
  • ACT.TY = 4-Performance Acknowledgement
  • ACT.CD = PA6-Performance Acknowledgement Certifications/Licensures
PERFORMANCE- ACKNOWLEGEMENT-MET-DATE (X) 

TE115

MetDate (SR) (TR)ACT.DT


Activities and AwardsDate


N/A

<AcademicStatus>

<CertLicType>

<MetDate>YYYY-MM</MetDate>

</CertLicType>

</AcademicStatus>


where YYYY-MM = ACT.DT (converted to YYYY-MM format) if:
  • ACT.TY = 4-Performance Acknowledgement
  • ACT.CD = PA6-Performance Acknowledgement Certifications/Licensures
INDIVIDUAL-GRADUATION-COMMITTEE-REVIEW-CODE (X) 

TE117 (TC40)


IGCGradReview (SR)STU.IGGDemographics > Student Data 2Individual Graduation Committee - Grad CodeE1562 (C201)

<AcademicStatus>

<IGCGradReview>XX</IGCGradReview>

</AcademicStatus>


where XX = 01 if STU.IGG = 00, 01, or 02; otherwise omitted
FHSP-COLLEGE-CAREER-INSTRUCTION-INDICATOR-CODE

TE118 (TC16)


FHSPCollegeCareerInstructionIndicator (SR)

------E1574 (C088)
Obsolete; not extracted
ASSOCIATE-DEGREE-INDICATOR-CODE (X) 

TE119 (TC16)

AssociateDegree (SR)
SSD.ADG
Secondary Student Data
Achievements Associates Degree
E1596 (C088)

<AcademicStatus>

<AssociateDegree>0/1</AssociateDegree>

</AcademicStatus>


where 0/1 = 1 if SSD.ADG = Y; otherwise 0

NOTE: Code values must be added on Update Code Table for SSD.ADG.

ONRAMPS-DUAL-ENROLLMENT-INDICATOR-CODE (X) 

TE120 (TC16)

OnRamps (SR)CRS.OD = YesCourses > OtherOnRamps Dual EnrE1597 (C088)

<AcademicStatus>
<OnRamps>0/1</OnRamps>

</AcademicStatus>


where 0/1 = 1 if student has completed a course where CRS.OD = Yes; otherwise omitted
SECTION-504 INDICATOR-CODE (X) 

TE124 (TC16)

Section504 (SR)FOF.SD/FOF.ED504 PlansEffective Date/Leave DateE1603 (C088)

<AcademicStatus>
<Section504>0/1</Section504>
</AcademicStatus>


where 0/1 = 1 if FOF.SD/FOF.ED indicate participation any time during the school year; otherwise omitted
PEACE-OFFICER-INTERACTION-INSTRUCTION-MET-DATE (X) TE123POIIMetDate (SR) (TR)ACT.TY = 5Activities and AwardsTypeN/A
ACT.CD = G03 *Code
ACT.DTDate

<AcademicStatus>
<POIIMetDate>YYYY-MM</POIIMetDate>
</AcademicStatus>


where YYYY-MM = ACT.DT (converted to YYYY-MM format) if:
  • ACT.TY = 5
  • ACT.CD = G03
CPR-INSTRUCTION-MET-DATE (X) TE122CPRMetDate (SR) (TR)ACT.TY = 5Activities and AwardsTypeN/A
ACT.CD = G02 *Code
ACT.DTDate

<AcademicStatus>
<CPRMetDate>YYYY-MM</CPRMetDate>
</AcademicStatus>


where YYYY-MM = ACT.DT (converted to YYYY-MM format) if:
  • ACT.TY = 5
  • ACT.CD = G02
STAR-OF-TEXAS-INDICATOR-CODE (X) 

TE121 (TC16)


StarofTexas (SR)ACT.TY = 2Activities and AwardsTypeE1601 (C088)
ACT.CD = STX *Code

<AcademicStatus>

<StarofTexas>0/1</StarofTexas>

</AcademicStatus>


where 0/1 = 1 if ACT.CD = STX; otherwise omitted
NOTE: Program does not consider grade level. It is up to school to award to appropriate students.
FINANCIAL-AID-APPLICATION-CODE (X) TE139 (TC46)FinancialAidApplicationACT.TYActivities and AwardsTypeN/A
ACT.CD *Code
ACT.RS *Reason

<AcademicStatus>

<FinancialAidApplication>01/02</FinancialAidApplication>

</AcademicStatus>


where 01/02 = 

  • 01 if:
    • ACT.TY = 5-Other Graduation Requirements
    • ACT.CD = G04-Financial Aid Application
    • ACT.RS = FA1-Financial Aid Form Completed
  • 02 if:
    • ACT.TY = 5-Other Graduation Requirements
    • ACT.CD = G04-Financial Aid Application
    • ACT.RS = FA1-Completed; FA2-Exception Submitted
FINANCIAL-AID-APPLICATION-MET-DATE (X) TE140FinancialAidApplicationMetDateACT.DTActivities and AwardsDateN/A
<AcademicStatus>

<FinancialAidApplicationMetDate>YYYY-MM</FinancialAidApplicationMetDate>

</AcademicStatus>


where YYYY-MM = ACT.DT (converted to YYYY-MM format) if:

  • ACT.TY = 5-Other Graduation Requirements
  • ACT.CD = G04-Financial Aid Application


Complex Type: CurrentCourseWork ↑

  • Be sure Low Grade and High Grade are set correctly on Transcript Definition > Record Details. as this affects the data extracted.
  • For Student Record (SR) extracts, this complex includes courses that were completed but credit was not received.
TREx Element
(X) = Extracted
(I) = Imported
TREx ID & Code Table XML Name
(SR) = Student Record 
(TR) = AAR/Transcript
Aeries Table.FieldAeries PageLabelPEIMS ID & Code Table
COURSE-NAME (X)

TE025

CourseTitle (SR) (TR)CRS.CO

CoursesTitleE0724 (C022)
<CurrentCoursework >

<Course>

<CourseTitle>Title</CourseTitle>

</Course>

</CurrentCoursework >


where Title = CRS.CO

COURSE-NUMBER (X) (I)

TE026

CourseID (SR) (TR)
CRS.SVCCourses > OtherService IDE0724 (C022)
<CurrentCoursework >

<Course>

<CourseID>NNNNNNNN</CourseID>

</Course>

</CurrentCoursework >


where NNNNNNNNN = CRS.SVC if service ID exists, otherwise CRS.CN (first 64 characters).

Length is 8 characters for public schools. Up to 64 characters are allowed for private schools.

COURSE-ABBREVIATION (X)

TE081

Abbreviation (SR) (TR)CRS.SVC
Courses > Other
Service ID
E0724 (C022)
<CurrentCoursework >

<Course>

<Abbreviation>Abbreviation</Abbreviation>

</Course>

</CurrentCoursework >


where Abbreviation is a fixed code based on C022 (Course Abbreviation)

COURSE-SEMESTER (X)
TE082
Semester (SR) (TR)MST.SMMaster ScheduleSemN/A
<CurrentCoursework>

<Course>

<Semester>N</Semester>

</Course>

</CurrentCoursework>


where N = MST.SM

CLASS-PERIODTE017ClassPeriod (SR)
MST.FSQMaster ScheduleFlex PeriodN/A
<CurrentCoursework>

<Course>

<ClassPeriod>N</ClassPeriod>

</Course>

</CurrentCoursework>


where N = MST.FSQ

COURSE-CATEGORY (X)
TE021 (TC05)SubjectArea (SR) (TR)
CRS.S1 *CoursesSubject Area CodeN/A
REQ.CDGraduation RequirementsCode


<CurrentCoursework>

<Course>

<SubjectArea>Subject</SubjectArea>

</Course>

</CurrentCoursework>


where Subject = CRS.S1

  • CRS.S1 must be mapped on Texas State Reporting > Code Translations.
  • Codes must be added on Graduation Requirements (rather than Update Code Table).
COURSE-GRADETE023CourseGrade (SR) (TR)GRD.M#Gradesmark--
<CurrentCoursework>

<Course>

<CourseGrade>XXX</CourseGrade>

</Course>

</CurrentCoursework>


where XXX = the latest value found for a grading period
  • Omitted if no marks are found for a current course
WITHDRAWAL-COURSE-GRADETE077

WithdrawGrade (SR)
--------
not extracted
COURSE-GRADE-AVERAGE (X)

TE024

GradeAverage (SR) (TR)
GRD.M#
Gradesmark--
<CurrentCoursework>

<Course>

<GradeAverage>XXX</GradeAverage>

</Course>

</CurrentCoursework>


where XXX = calculated according to latest values found for a grading period
  • Omitted if no marks are found for a current course
COURSE-CREDIT (X)TE022
CourseCredit (SR) (TR)HIS.CCTranscriptsComp--

<CurrentCoursework>

<Course>

<CourseCredit>X</CourseCredit>

</Course>

</CurrentCoursework>


where X = HIS.CC
PASS/FAIL-CREDIT-INDICATOR (X)

TE084 (TC25)

PassFailCredit (SR) (TR)
--------
not extracted
SPECIAL-EXPLANATION-CODE (X)TE070 (TC19)
Explanation (TR)
--------
not extracted
COURSE-TEACHER (X)
TE027
CourseTeacher (SR)STF.LNStaffLast NameN/A
STF.FNFirst Name
SSM.IDMaster ScheduleStaff Member
<CurrentCoursework>

<Course>

<CourseTeacher>F Last</CourseTeacher>

</Course>

</CurrentCoursework>


where F Last = STF.FN + STF.LN (first initial, last name) based on SSM.ID

CAMPUS-AWARDING-CREDIT (X)TE080
CreditCampus (SR) (TR)
CAR.SC

N/A
CHI.IDCourse History InstitutionsID Number
LOC.CC + LOC.DC = LOC.SCSchool OptionsCounty + District + Campus
<CurrentCoursework>

<Course>

<CreditCampus>CCCDDDSSS</CreditCampus>

</Course>

</CurrentCoursework>


where CCCDDDSSS = 

  • CHI.ID if CAR.SC matches school where CHI.TY = 1 and school is public; 
  • otherwise LOC fields
SEMESTER-SEQUENCE (X)

TE068 (TC18)

SemesterSeq (SR)
CRS.CSQ *
Courses > OtherCrs Seq
E0948 (C135)
<CurrentCoursework>

<Course>

<SemesterSeq>N</SemesterSeq>

</Course>

</CurrentCoursework>


where N = CRS.CSQ

ACADEMIC-YEAR  (X)

TE001

SchoolYear (SR) (TR)



N/A
<CurrentCoursework>

<SchoolYear>YYYY-YYYY</SchoolYear>

</CurrentCoursework>


where YYYY-YYYY = Current School Year

Required if student has not graduated.

GRADE-LEVEL (X)

TE043 (TC12)

GradeLevel (SR)STU.GR
DemographicsGradeE0017 (C050)
<CurrentCoursework>

<GradeLevel>NN</GradeLevel>

</CurrentCoursework>


where NN = STU.GR

SESSION-TYPE (X)TE087
SessionType (SR) (TR)



N/A
<CurrentCoursework>

<SessionType>Semester</SessionType>

</CurrentCoursework>



Complex Type: AcademicSession ↑

  • This is only included for students who have courses taken for high school credit.
  • For Student Record (SR) extracts, this complex includes courses that were completed but credit was not received.
TREx Element
(X) = Extracted
(I) = Imported
TREx ID & Code Table XML Name
(SR) = Student Record 
(TR) = AAR/Transcript
Aeries Table.FieldAeries PageLabelPEIMS ID & Code Table
ACADEMIC-YEAR  (X)

TE001


SchoolYear (SR) (TR)
HIS.YRTranscripts > Course HistoryYearN/A

<AcademicSession>

<SchoolYear>YYYY-YYYY</SchoolYear>

</AcademicSession>


where YYYY-YYYY = HIS.YR

Required element if student has not graduated. 

GRADE-LEVEL (X)

TE043 (TC12)



GradeLevel (SR)HIS.GR
TranscriptsGrdE0017 (C050)
<AcademicSession>

<GradeLevel>NN</GradeLevel>

</AcademicSession>


where NN = HIS.GR

SESSION-TYPE (X)
TE087
SessionType (SR) (TR)
HIS.TETranscriptsTermN/A
<AcademicSession>

<SessionType>Semester/Trimester/Quarter</SessionType>

</AcademicSession>


where Semester/Trimester/Quarter = 

  • 'Trimester' if HIS.TE = 4, 5, or 6
  • 'Quarter' if HIS.TE = 8
  • Otherwise, 'Semester'
COURSE-NAME (X)

TE025

CourseTitle (SR) (TR)HIS.CO orTranscriptsSpecial Crs TitleE0724 (C022)
CRS.COStd Course Title
CoursesTitle
<AcademicSession>

<Course>

<CourseTitle>Title</CourseTitle>

</Course>

</AcademicSession>


where Title = HIS.CO if populated; otherwise CRS.CO

COURSE-NUMBER (X) (I)

TE026

CourseID (SR) (TR)
CRS.SVCCourses > OtherService IDE0724 (C022)
HIS.CNTranscriptsCourse ID
<AcademicSession>

<Course>

<CourseID>NNNNNNNN</CourseID>

</Course>

</AcademicSession>


where NNNNNNNNN = CRS.SVC if service ID exists, otherwise HIS.CN (first 64 characters).

Length is 8 characters for public schools. Up to 64 characters are allowed for private schools.

COURSE-ABBREVIATION (X)

TE081

Abbreviation (SR) (TR)CRS.SVC
Courses > Other
Service ID
E0724 (C022)
<AcademicSession>

<Course>

<Abbreviation>Abbreviation</Abbreviation>

</Course>

</AcademicSession>


where Abbreviation is a fixed code based on C022 (Course Abbreviation)

COURSE-CATEGORY (X)
TE021 (TC05)
SubjectArea (SR) (TR)
CRS.S1 * CoursesSubject Area CodeN/A
REQ.CDGraduation RequirementsCode
<AcademicSession>

<Course>

<SubjectArea>Subject</SubjectArea>

</Course>

</AcademicSession>


where Subject = CRS.S1

  • CRS.S1 must be mapped on Texas State Reporting > Code Translations.
  • Codes must be added on Graduation Requirements (rather than Update Code Table).
COURSE-SEMESTER (X)
TE082
Semester (SR) (TR)HIS.TETranscriptsTermN/A
<AcademicSession>

<Course>

<Semester>N</Semester>

</Course>

</AcademicSession>


where N = HIS.TE

COURSE-TEACHER (X)
TE027
CourseTeacher (SR)STF.LNStaffLast NameN/A
STF.FNFirst Name
HIS.SIDTranscript > Course HistoryStaff
<AcademicSession>

<Course>

<CourseTeacher>F Last</CourseTeacher>

</Course>

</AcademicSession>


where F Last = STF.FN + STF.LN (first initial, last name) based on HIS.SID

COURSE-GRADE (X)
TE023
CourseGrade (SR) (TR)
HIS.MKTranscripts > Course HistoryMarkN/A
<AcademicSession>

<Course>

<CourseGrade>NNN</CourseGrade>

</Course>

</AcademicSession>


where NNN = HIS.MK

COURSE-GRADE-AVERAGE (X)

TE024

GradeAverage (SR) (TR)
HIS.MKTranscripts > Course History
Mark
E1075
<AcademicSession>

<Course>

<GradeAverage>NNN</GradeAverage>

</Course>

</AcademicSession>


where NNN = HIS.MK

COURSE-CREDIT (X)

TE022
CourseCredit (SR) (TR)
HIS.CCTranscripts > Course HistoryCompN/A
<AcademicSession>

<Course>

<CourseCredit>N.NNNN</CourseCredit>