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


Fields with an asterisk must 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)

TE011


SchoolID (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)

TE034

DistrictID (SR) (TR)LOC.CC + LOC.DCSchool OptionsCounty + DistrictE0212

<School>

<DistrictID>CCCDDD</DistrictID>

</School>


where:
  • CCC = LOC.CC
  • DDD = LOC.DC
DISTRICT-NAME (X)

TE035


DistrictName (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)STU.LF *
DemographicsLangFlu
E0790 (C061)
<SpecialPrograms>

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


where X = STU.LF

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

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) TE004 (TC01)TestName (SR)
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)
TE085 

AdditionalTestName (SR)

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) 

TE083 (TC12)



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

<Assessment>

<TestLevel>NN</TestLevel>

</Assessment>


where NN = TST.GR (zero padded)

ASSESSMENT-DATE (X) 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) TE005TestScore (SR)TST.SSTest Scores Scale ScoreN/A

<Assessment>

<TestScore>NNNNNN</TestScore>

</Assessment>


where NNNNNN = TST.SS

Currently only extracted for STAAR EOC

ASSESSMENT-SCORE-CODE (X) TE006 (TC02)TestCode (SR)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) TE098 (TC31)PerformanceLevel (SR) (TR)TST.PLTest ScoresPerf LevelN/A
TEX.SPC = *Testing Exclusions

Special

Conditions

<Assessment>

<PerformanceLevel>X</PerformanceLevel>

</Assessment>


where 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

only extracted for STAAR EOC

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
STU.LDDemographicsSchl Leave Dt

<DisciplineAction>

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

</DisciplineAction>


where YYYY-MM-DD = DSP.ED, only if DSP.ED > STU.LD, and STU.LD is not blank
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 = 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

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)--------
not extracted
WITHDRAWAL-COURSE-GRADETE077

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

TE024

GradeAverage (SR) (TR)
--------
not extracted
COURSE-CREDIT (X)TE022
CourseCredit (SR) (TR)--------

not extracted
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

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

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

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.MKTranscript > Course HistoryMarkN/A
<AcademicSession>

<Course>

<CourseGrade>NNN</CourseGrade>

</Course>

</AcademicSession>


where NNN = HIS.MK

COURSE-GRADE-AVERAGE (X)

TE024

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

<Course>

<GradeAverage>NNN</GradeAverage>

</Course>

</AcademicSession>


where NNN = HIS.MK

COURSE-CREDIT (X)

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

<Course>

<CourseCredit>N.NNNN</CourseCredit>

</Course>

</AcademicSession>


where N.NNNN = HIS.CC (zero padded to 4 decimal places)

CAMPUS-AWARDING-CREDIT (X)TE080
CreditCampus (SR) (TR)
HIS.STTranscript > Course HistorySchlN/A
CHI.IDCourse History InstitutionsID Number
LOC.CC + LOC.DC = LOC.SCSchool OptionsCounty + District + Campus
<AcademicSession>

<Course>

<CreditCampus>CCCDDDSSS</CreditCampus>

</Course>

</AcademicSession>


where CCCDDDSSS = 

  • CHI.ID if HIS.ST 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)
<AcademicSession>

<Course>

<SemesterSeq>N</SemesterSeq>

</Course>

</AcademicSession>


where N = CRS.CSQ

FINAL-GRADE-AVERAGE (X)
TE088