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: StudentDemographic
Complex Type: AcceleratedInstruction
Complex Type: CurrentCourseWork
Complex Type: DisciplineAction
Complex Type: Student Identification
TREx Element (X) = Extracted (I) = Imported | TREx ID & Code Table | XML Name (SR) = Student Record (TR) = AAR/Transcript | Aeries Table.Field | Aeries Page | Label | PEIMS ID & Code Table |
TX-UNIQUE -STUDENT-ID (X) (I) | TE099 | StudentUniqueID (SR) | STU.CID | Demographics > Student Data 2 | Unique ID | E1523 |
<StudentIdentification> <StudentUniqueID>UUUUUUUUUU</StudentUniqueID> </StudentIdentification> where UUUUUUUUUU = STU.CID | ||||||
FIRST-NAME (X) (I) | TE039 | FirstName (SR) (TR) | STU.FN | Demographics | First Name | E0703 |
<StudentIdentification> <Name> <FirstName>First</FirstName> </Name> </StudentIdentification> where First = STU.FN | ||||||
MIDDLE-NAME (X) (I) | TE059 | MiddleName (SR) (TR) | STU.MN | Demographics | Middle Name | E0704 |
<StudentIdentification> <Name> <MiddleName>Middle</MiddleName> </Name> </StudentIdentification> where Middle = STU.MN | ||||||
LAST-NAME (X) (I) | TE055 | LastName (SR) (TR) | STU.LN | Demographics | Last Name | E0705 |
<StudentIdentification> <Name> <LastName>Last</LastName> </Name> </StudentIdentification> where Last = STU.LN | ||||||
GENERATION-CODE (X) (I) | TE041 (TC11) | Suffix (SR) (TR) | STU.SF * | Demographics | Suffix | E0706 (C012) |
<StudentIdentification> <Name> <Suffix>X</Suffix> </Name> </StudentIdentification> where X = STU.SF if present; otherwise omitted | ||||||
PRIOR-ID (X) | TE065 | PriorID (SR) | ESD.ED | Demographics > Student Data 2 | Prior SSN/StateID | E0990 |
<StudentIdentification> <PriorID>XXXXXXXXX</PriorID> </StudentIdentification> | ||||||
STUDENT-ID (X) (I) | TE072 | StudentID (SR) (TR) | ESD.ED | Demographics > Student Data 2 | Soc-Sec-Num/S-Number | E0001 |
<StudentIdentification> <StudentID>CCCCCCCCC</StudentID> </StudentIdentification> where CCCCCCCCC = ESD.ED | ||||||
LOCAL-STUDENT-ID (X) | TE058 | LocalID (SR) (TR) | STU.ID | Demographics | Student ID | E0923 |
<StudentIdentification> <LocalID>XXXXXXXX</LocalID> </StudentIdentification> where XXXXXXXX = STU.ID | ||||||
ADDRESS (X) (I) | TE002 | Address (SR) (TR) | STU.AD | Demographics | Address (Mailing) | N/A |
<StudentIdentification> <Address> <Address>Address</Address> </Address> </StudentIdentification> where Address = STU.AD | ||||||
CITY (X) (I) | TE016 | City (SR) (TR) | STU.CY | Demographics | City (Mailing) | N/A |
<StudentIdentification> <Address> <City>City</City> </Address> </StudentIdentification> where City = STU.CY | ||||||
STATE (X) (I) | TE071 (TC20) | StateProvince (SR) (TR) | STU.ST | Demographics | State (Mailing) | N/A |
<StudentIdentification> <Address> <StateProvince>XX</StateProvince> </Address> </StudentIdentification> where XX = STU.ST | ||||||
COUNTRY (X) (I) | TE020 (TC04) | Country (TR) | STU.CN | Demographics | Country (Mailing) | N/A |
<StudentIdentification> <Address> <Country>XX</Country> </Address> </StudentIdentification> where XX = STU.CN | ||||||
ZIP-CODE (X) (I) | TE079 | PostalCode (SR) (TR) | STU.ZC | Demographics | Zip (Mailing) | N/A |
STU.ZX | Extn (Mailing) | |||||
<StudentIdentification> <Address> <PostalCode>NNNNN-XXXX</PostalCode> </Address> </StudentIdentification> where:
|
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.Field | Aeries Page | Label | PEIMS ID & Code Table |
FIRST-NAME (X) | TE039 | FirstName (SR) | CON.FN | Contacts | First Name | N/A |
CON.LW = Y, or | Lives With | |||||
CON.ERH = Y, or | Ed Rights Holder | |||||
CON.PC = Y, or | Primary Contact | |||||
CON.AP = Y | Portal | |||||
<Parent> <Name> <FirstName>First</FirstName> </Name> </Parent> where First = CON.FN if:
| ||||||
MIDDLE-NAME (X) | TE059 | MiddleName (SR) | CON.MN | Contacts | Middle Name | N/A |
CON.LW = Y, or | Lives With | |||||
CON.PC = Y, or | Primary Contact | |||||
CON.ERH = Y, or | Ed Rights Holder | |||||
CON.AP = Y | Portal | |||||
<Parent> <Name> <MiddleName>Middle</MiddleName> </Name> </Parent> where First = CON.MN if:
| ||||||
LAST-NAME (X) | TE055 | LastName (SR) | CON.LN | Contacts | Last Name | N/A |
CON.LW = Y, or | Lives With | |||||
CON.PC = Y, or | Primary Contact | |||||
CON.ERH = Y, or | Ed Rights Holder | |||||
CON.AP = Y | Portal | |||||
<Parent> <Name> <LastName>Last</LastName> </Name> </Parent> where First = CON.LN if:
| ||||||
GENERATION-CODE (X)> | (TE041) (TC11) | Suffix (SR) | CON.SF | Contacts | Suffix | N/A |
CON.LW = Y, or | Lives With | |||||
CON.PC = Y, or | Primary Contact | |||||
CON.ERH = Y, or | Ed Rights Holder | |||||
CON.AP = Y | Portal | |||||
<Parent> <Name> <Suffix>X</Suffix> </Name> </Parent> where X = CON.SF if:
|
Complex Type: StudentDemographic ↑
TREx Element (X) = Extracted (I) = Imported | TREx ID & Code Table | XML Name (SR) = Student Record (TR) = AAR/Transcript | Aeries Table.Field | Aeries Page | Label | PEIMS ID & Code Table |
MIGRANT-INDICATOR (X) | TE060 (TC16) | Migrant (SR) | SSD.SUS | Demographics | US Schl < 3 Yrs | E0784 (C088) |
<StudentDemographic> <Migrant>0/1</Migrant> where 0/1 = 1 if SSD.SUS = Yes; otherwise omitted | ||||||
DYSLEXIA-INDICATOR-CODE (X) | TE102 (TC16) | Dyslexia (SR) | PGM.CD = 400 * | Special Programs | Program Code | E1530 (C088) |
<StudentDemographic> <Dyslexia>0/1</Dyslexia> where 0/1 = 1 if PGM.CD=400; otherwise omitted | ||||||
DYSLEXIA-RISK-CODE (X) | TE141 (TC24) | DyslexiaRiskCodeType | PGM.CD = 399 * | Special Programs > Current Programs | Program Code | E1644 (C222) |
PGR.CD = 399 | Special Programs > Program Screenings | |||||
<StudentDemographic> <DyslexiaRiskCode>01/02/03</DyslexiaRiskCode> where XX =
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 Programs | Program Code | E1528 (C196) |
PGM.TY | Program 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.CL | Demographics | Home Language | E0895 (C092) |
<StudentDemographic> <HomeLanguage>XX</HomeLanguage> where XX = STU.CL | ||||||
HOME-LANGUAGE-SURVEY-DATE-ADMINISTERED (X) | TE127 | HomeLanguageSurveyDateAdministered (SR) | LAC.HLD | Demographics | Survey Completed Date | N/A |
<StudentDemographic> <HomeLanguageSurveyDateAdministered>YYYY-MM-DD</HomeLanguageSurveyDateAdministered> where YYYY-MM-DD = LAC.HLD | ||||||
HOMELESS-INDICATOR (X) | TE049 (TC32) | Homeless (SR) | PGM.CD = 191 * | Special Programs | Program Code | E1082 (C189) |
PGM.HDT * | Homeless Dwelling Type | |||||
<StudentDemographic> <Homeless>X</Homeless> where X = PGM.HDT if PGM.CD=191; otherwise 0 | ||||||
MILITARY-CONNECTED (X)< | TE101 (TC34) | MilitaryConnected (SR) | PGM.CD = 192 * | Special Programs | Program Code | E1529 (C197) |
PGM.TY | Program Type | |||||
<StudentDemographic> <MilitaryConnected>X</MilitaryConnected> | ||||||
STUDENT-LANGUAGE-CODE (X) | TE126 (TC14) | StudentLanguage (SR) | STU.HL> | Demographics | Student Language | E1590 (C092) |
<StudentDemographic> <StudentLanguage>XX</StudentLanguage> where XX = STU.HL | ||||||
UNSCHOOLED-ASYLEE-REFUGEE (X) | TE097 (TC30) | AsyleeRefugeeCode (SR) | PGM.CD = 406 * | Special Programs | Program Code | E1076 (C183) |
PGM.TY | Program Type | |||||
<StudentDemographic> <AsyleeRefugeeCode>X</AsyleeRefugeeCode> where X = PGM.TY if PGM.CD=406; otherwise omitted | ||||||
DATE-OF-BIRTH (X) (I) | TE028 | BirthDate (SR) (TR) | STU.BD | Demographics | Birthdate | E0006 |
<StudentDemographic> <BirthDate>YYYY-MM-DD</BirthDate> where YYYY-MM-DD = STU.BD | ||||||
GENDER-CODE (X) (I) | TE040 (TC10) | Gender (SR) (TR) | STU.GN * | Demographics | Gender | E0004 (C013) |
<StudentDemographic> <Gender>X</Gender> where X = STU.GN | ||||||
PK-ELIGIBLE-PREVIOUS-YEAR-INDICATOR-CODE (X) | TE138 (TC16) | PkEligiblePreviousYear (SR) | ECD.PRE | Early Childhood Development | PK Eligible Previous Year | E1649 (C088) |
<StudentDemographic> <PkEligiblePreviousYear>0/1</PkEligiblePreviousYear> </StudentDemographic> where 0/1 = 1 if ECD.PRE = Y; otherwise omitted | ||||||
BEHAVIORAL-THREAT-ASSESSMENT (X) | TE154 (TC16) | TX-BehavioralThreatAssessment (SR) | INV.CD * | Interventions | Code | N/A |
<StudentDemographic> <TX-BehavioralThreatAssessment>0/1</TX-BehavioralThreatAssessment> </StudentDemographic> where 0/1 = 1 if INV.CD = BTA; otherwise 0 * On Update Code Table, the following code must be added to Table = INV and Field = CD: BTA - Behavioral Threat Assessment |
Complex Type: School ↑
TREx Element (X) = Extracted (I) = Imported | TREx ID & Code Table | XML Name (SR) = Student Record (TR) = AAR/Transcript | Aeries Table.Field | Aeries Page | Label | PEIMS ID & Code Table |
CAMPUS-ID (X) | TE011 | SchoolID (SR) (TR) | LOC.CC + LOC.DC + LOC.SC | School Options | County + District + Campus | E0266 |
<School> <SchoolID>CCCDDDSSS</SchoolID> </School> where:
| ||||||
CAMPUS-NAME (X) | TE012 | SchoolName (SR) (TR) | LOC.NM | School Options | School Name | E0267 |
<School> <SchoolName>Name</SchoolName> where Name = LOC.NM | ||||||
DISTRICT-ID (X) | TE034 | DistrictID (SR) (TR) | LOC.CC + LOC.DC | School Options | County + District | E0212 |
<School> <DistrictID>CCCDDD</DistrictID> </School> where:
| ||||||
DISTRICT-NAME (X) | TE035 | DistrictName (SR) (TR) | LOC.NM | School Options (district) | District Name | E0213 |
<School> <DistrictName>Name</DistrictName> where Name = LOC.NM | ||||||
ADDRESS (X) | TE002 | Address (SR) (TR) | LOC.AD | School Options | Street Address | N/A |
<School> <Address> <Address>Address</Address> ></School> where Address = LOC.AD | ||||||
CITY (X) | TE016 | City (SR) (TR) | LOC.CY | School Options | City | N/A |
<School> <Address> <City>City</City> </Address> </School> where City = LOC.CY | ||||||
STATE (X) | TE071 (TC20) | StateProvince (SR) (TR) | LOC.ST | School Options | State | N/A |
<School> <Address><StateProvince>XX</StateProvince> </Address> </School> where XX = LOC.ST | ||||||
ZIP-CODE (X) | TE079 | PostalCode (SR) (TR) | LOC.ZC | School Options | Zip | N/A |
<School> <Address> <PostalCode>NNNNN-NNNN</PostalCode> </Address> </School> where NNNNN-NNNN = LOC.ZC | ||||||
CAMPUS-PHONE (X) | TE013 | PhoneNumber (SR) (TR) | LOC.TL | School Options | Telephone | N/A |
<School> <PhoneNumber>NNNNNNNNNN</PhoneNumber> ></School> where NNNNNNNNNN = LOC.TL | ||||||
CAMPUS-FAX (X) | TE010 | Fax (SR) | LOC.FX | School Options | Fax | N/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.Field | Aeries Page | Label | PEIMS ID & Code Table |
GRADE-LEVEL (X) (I) | TE043 (TC12) | GradeLevel (SR) | ENR.GR | Enrollment History | Grd | E0017 (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.LD | Demographics | Schl Leave Dt | N/A |
<Enrollment> <ExitDate>YYYY-MM-DD</ExitDate> </Enrollment> where YYYY-MM-DD = STU.LD | ||||||
LAST-WITHDRAWAL-DATE (X) | TE056 | WithdrawDate (SR) | STU.LD | Demographics | Schl Leave Dt | N/A |
<Enrollment> <WithdrawDate>YYYY-MM-DD</WithdrawDate> </Enrollment> where YYYY-MM-DD = STU.LD + 1 | ||||||
ORIGINAL-ENTRY-DATE (X) | TE062 | EntryDate (SR) | STU.ED | Demographics | Schl Enter Dt | N/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> lt;GradePlaced>XX</GradePlaced> </Enrollment> not currently extracted | ||||||
PROMOTED-TO-GRADE | TE066 (TC12) | GradePromoted (SR) | -- | -- | -- | (C050) |
<Enrollment> <GradePromoted>NN</GradePromoted> </Enrollment> not currently extracted | ||||||
WITHDRAWAL-REASON (X) | TE078 (TC23) | WithdrawReason (SR) | ENR.ER * | Enrollment History | Exit Reason | E1001 (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.Field | Aeries Page | Label | PEIMS ID & Code Table |
LEP-INDICATOR-CODE (X) | TE057 (TC15) | LEP (SR) | PGM.TY | Special Programs | Type | E0790 (C061) |
PGM.CD = 148 | Code | |||||
<SpecialPrograms> <LEP>X</LEP> where X = PGM.TYP if PGM.CD = 148 | ||||||
ALTERNATIVE-LANGUAGE-PROGRAM-CODE (X) | TE125 (TC41) | AlternativeLanguage (SR) | PGM.ALP | Special Programs | Alt Lang Prgm | E1642 (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.YR | Language Assessment > Dual Language Immersion | Year | N/A |
DLH.CF | Completed | |||||
<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.YR | Language Assessment > Dual Language Immersion | Year | N/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.PDT | Language Assessment > Dual Language Immersion | Proficient Date | N/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 Programs | Program 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) | Title I (SR) | PGM.TY | Special Programs | Program Type | E0894 (C122) |
PGM.CD = 121 or 122 * | Program Code | |||||
or LOC.T1 | School Options | Title I Part A | ||||
<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 Disability | E0794 (C088) |
CSE.ED/ CSE.XD | Entry Date/Exit Date | |||||
DHS.DI | Special Education > Disabilities History | -- | ||||
STU.LD | Demographics | Schl Leave Dt | ||||
<SpecialPrograms> <SpecialEd>0/1</SpecialEd> </SpecialPrograms> where 0/1 = 1 if:
| ||||||
IEP-INDICATOR (X) | TE050 (TC16) | IEP (SR) | CSE.ED/CSE.XD | Special Education > General | Entry Date/Exit Date | N/A |
STU.LD | Demographics | Schl Leave Dt | ||||
<SpecialPrograms> <IEP>0/1</IEP> </SpecialPrograms> where 0/1 = 1 if:
| ||||||
BILINGUAL-INDICATOR (X) | TE009 (TC26) | Bilingual (SR) | PGM.TY | Special Programs | Program Type | E1042 (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 Type | E1043 (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 * or | Special Programs | Program Code | E0034 (C088) |
GTE.SD/GTE.ED | Gifted/Talented | Start Date/End Date | ||||
<SpecialPrograms> <GiftedTalented>0/1</GiftedTalented> </SpecialPrograms> where 0/1 = 1 if:
| ||||||
PERSONAL-GRADUATION-PLAN | TE063 (TC16) | PersonalGradPlan (SR) | -- | -- | -- | N/A |
CAREER-TECH-ED-INDICATOR (X) | TE014 (TC03) | CTE (SR) | PGM.CD = 154 * | Special Programs | Program Code | E0031 (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) | EconomicDisadvantaged (SR) | FRE.CD * | Free and Reduced | - | E0785 (C054) |
<SpecialPrograms> <EconomicDisadvantaged>XX</EconomicDisadvantaged> </SpecialPrograms> where XX = FRE.CD if CD = 01, 02, or 99; otherwise omitted | ||||||
IBC-REIMBURSEMENT-INDICATOR (X) | TE132 | IBCReimbursement (SR) | ACT.IBS | Activities and Awards | Reimbursement Status | N/A |
ACT.TY = 3 | Type | |||||
ACT.CD * | Code | |||||
<SpecialPrograms> <IBCReimbursement>XXX</IBCReimbursement> </SpecialPrograms> where XXX = ACT.IBS if:
|
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.Field | Aeries Page | Label | PEIMS ID & Code Table |
ASSESSMENT-NAME (X) (I) | TE004 (TC01) | TestName (SR) (TR) | CTL.C0-CTL.C18 | Testing Control Table | C0-C18 | N/A |
CTL.ID | Test-ID | |||||
TST.ID | Test Scores | Test ID | ||||
TST.GR | Grade | |||||
<Assessment> <TestName>XX</TestName> </Assessment> where XX = CTL.C0-CTL.C18 if:
| ||||||
ADDITIONAL-TEST-NAME (X) (I) | TE085 | AdditionalTestName (SR) (TR) | CTL.NM | Testing Control Table | Test Part Title | N/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.GR | Test Scores | Grd Lvl | (C050) |
<Assessment> <TestLevel>NN</TestLevel> </Assessment> where NN = TST.GR (zero padded) | ||||||
ASSESSMENT-DATE (X) (I) | TE003 | TestDate (SR) (TR) | TST.TD | Test Scores | Date | N/A |
<Assessment> <TestDate>YYYY-MM</TestDate> </Assessment> where YYYY-MM = TST.TD (converted to YYYY-MM format) | ||||||
ASSESSMENT-DATE-EXIT-REQUIREMENT-MET | TE095 | ExitRequirementMetDate | -- | -- | -- | N/A |
not extracted | ||||||
ASSESSMENT-SCORE (X) (I) | TE005 | TestScore (SR) (TR) | TST.SS | Test Scores | Scale Score | N/A |
<Assessment> <TestScore>NNNNNN</TestScore> </Assessment> where NNNNNN = TST.SS | ||||||
ASSESSMENT-SCORE-CODE (X) (I) | TE006 (TC02) | TestCode (SR) (TR) | TEX.SPC * | Testing Exclusions | Special Conditions | N/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.PL | Test Scores | Perf Level | N/A |
TEX.SPC = B | Testing Exclusions | Special Conditions | ||||
<Assessment> <PerformanceLevel>X</PerformanceLevel> </Assessment> where X = TST.PL For EOC, X =
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-SUBTEST | TE007 | SubTestName (SR) | -- | -- | -- | N/A |
ASSESSMENT-SUBTEST-SCORE | TE086 | SubTestScore (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.Field | Aeries Page | Label | PEIMS ID & Code Table |
TOTAL-DAYS-PRESENT (X) | TE076 | DaysAttended (SR) | STU.DP | Attendance History | Present | E0937 |
<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.DA | Attendance 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 History | Remote Sync | E16XX |
<Attendance> </Attendance> where NNN.N = AHS.RS | ||||||
RA-TOTAL- DAYS-PRESENT (X) | TE137 | RADaysAttended (SR) | AHS.RA | Attendance History | Remote 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.Field | Aeries Page | Label | PEIMS ID & Code Table |
IMMUNIZATION-NAME (X) | TE053 | ImmunizationCode (SR) | IMM | Immunizations | Date 1-5 | N/A |
<Immunization> <ImmunizationCode>Immunization</ImmunizationCode> </Immunization> where Immunization =
| ||||||
IMMUNIZATION-DATE (X) | TE051 | ImmunizationDate (SR) | IMM | Immunizations | Date 1-5 | N/A |
<Immunization> <ImmunizationDate>YYYY-MM-DD</ImmunizationDate> </Immunization> where YYYY-MM-DD =
| ||||||
IMMUNIZATION-DOSE (X) | TE052 | ImmunizationDose (SR) | IMM | Immunizations | Date 1-5 | N/A |
<Immunization> <ImmunizationDose>N</ImmunizationDose> </Immunization> where N =
|
Complex Type: AcceleratedInstruction ↑
TREx Element (X) = Extracted (I) = Imported | TREx ID & Code Table | XML Name (SR) = Student Record (TR) = AAR/Transcript | Aeries Table.Field | Aeries Page | Label | PEIMS ID & Code Table |
ACCELERATED-SUBJECT(X) | TE150 (TC49) | (SR) | ACT.CD | Activities and Awards | Code | -- |
STUDENT-ACCELERATED-INSTRUCTION-PARTICIPATION | TE151 (TC50) | (SR) | ACT.RS | Activities and Awards | Reason | - |
ASSIGNED-HOURS-ACCELERATED-INSTRUCTION | TE152 | (SR) | ACT.HA | Activities and Awards | Hours Assigned | -- |
YTD-NUMBER-HOURS-COMPLETED | TE153 | (SR) | ACT.HR | Activities and Awards | Hours Completed | -- |
Complex Type: AcademicStatus ↑
TREx Element (X) = Extracted (I) = Imported | TREx ID & Code Table | XML Name (SR) = Student Record (TR) = AAR/Transcript | Aeries Table.Field | Aeries Page | Label | PEIMS ID & Code Table |
GRADUATION-DATE (X) | TE046 | GraduationDate (TR) | STU.DG | Demographics > Student Data 2 | Grad Type - Date | E0791 |
<AcademicStatus> <GraduationDate>YYYY-MM</GraduationDate> </AcademicStatus> where YYYY-MM = STU.DG (converted to YYYY-MM format) | ||||||
SPEECH-REQUIREMENT-MET-DATE (X) | TE116 | SpeechMetDate (SR) (TR) | ACT.DT | Activities and Awards | Date | N/A |
ACT.TY = 5 | Type | |||||
ACT.CD = G01 * | Code | |||||
<AcademicStatus> <SpeechMetDate>YYYY-MM</SpeechMetDate> where YYYY-MM = ACT.DT (converted to YYYY-MM format) if:
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 2 | Grad Type - Code | E0806 (C062) |
<AcademicStatus> <GraduationDiplomaType>XX</GraduationDiplomaType> </AcademicStatus> where XX = STU.HSG | ||||||
CERTIFICATE-COMPLETION-DATE (X) | TE015 | CertificateDate (TR) | STU.CDT | Demographics > Student Data 2 | Certificate of Completion - Date | N/A |
<AcademicStatus> <CertificateDate>YYYY-MM-DD</CertificateDate> </AcademicStatus> where YYYY-MM-DD = STU.CDT | ||||||
TEXAS-GRANT-INDICATOR (X) | TE073 (TC21) | TexasGrant (TR) | ACT.TY = 2 | Activities and Awards | Type | N/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 2 | Grad Type - Code | (C199) |
STU.GRT * | Graduation Status | Graduation Track | ||||
REQ.GRT * | Graduation Requirements | Track | ||||
<AcademicStatus> </AcademicStatus> where X =
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-PARTICIPANT (X) | TE165 (TC16) | FHSPDistingLevelParticipant (SR) (TR) | ACT.TY = 4 | Activities and Awards | Type | E3029 |
ACT.CD = DLA * | Code | |||||
ACT.RS = DLA-1* | Reason | |||||
<AcademicStatus> </AcademicStatus> where X = 1 if:
| ||||||
DISTING-LEVEL-ACHIEVEMENT-GRADUATE | TE164 (TC16) | DistingLevelAchievementGraduate (SR) (TR) | ACT.TY = 4 | Activities and Awards | Type | E3089 |
ACT.CD = DLA * | Code | |||||
ACT.RS = DLA-2 * | Reason | |||||
<AcademicStatus> </AcademicStatus> where X = 1 if:
| ||||||
STEM-ENDORSEMENT-INDICATOR-CODE (X) | TE105 (TC35) | STEMEndorsementCode (SR) (TR) | GES.EC = ST * | Graduation Status > Endorsement (Manage) | Endorsement | E1544 (C199) |
GES.ST | Status | |||||
STU.EOO | Profile > Endorsement (Manage), or | Opt-out (11th and 12th grade only) | ||||
Graduation Status > Endorsement (Manage) | ||||||
<AcademicStatus> </AcademicStatus> where X =
On Update Code Tables:
| ||||||
BUSINESS-AND-INDUSTRY-ENDORSEMENT-INDICATOR-CODE (X) | TE106 (TC35) | BusinessEndorsementCode (SR) (TR) | GES.EC = BI * | Graduation Status > Endorsement (Manage) | Endorsement | E1545 (C199) |
GES.ST | Status | |||||
STU.EOO | Profile > Endorsement (Manage), or | Opt-out (11th and 12th grade only) | ||||
Graduation Status > Endorsement (Manage) | ||||||
<AcademicStatus> </AcademicStatus> where X =
On Update Code Tables:
| ||||||
PUBLIC-SERVICES-ENDORSEMENT-INDICATOR-CODE (X) | TE107 (TC35) | PublicServicesEndorsementCode (SR) (TR) | GES.EC = PS * | Graduation Status > Endorsement (Manage) | Endorsement | E1546 (C199) |
GES.ST | Status | |||||
STU.EOO | Profile > Endorsement (Manage),or | Opt-out (11th and 12th grade only) | ||||
Graduation Status > Endorsement (Manage) | ||||||
<AcademicStatus> <PublicServicesEndorsementCode>X</PublicServicesEndorsementCode> </AcademicStatus> >where X =
On Update Code ables:
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) | Endorsement | E1547 (C199) |
GES.ST | Status | |||||
STU.EOO | Profile > Endorsement (Manage) ; or | Opt-out (11th and 12th grade only) | ||||
Graduation Status > Ensorsement (Manage) | ||||||
<AcademicStatus> <ArtsEndorsementCode>X</ArtsEndorsementCode> </AcademicStatus> where X =
On Update Code Tables:
| ||||||
MULTI-DISCIPLINARY-STUDIES-ENDORSEMENT-INDICATOR-CODE (X) | TE109 (TC35) | MultiStudiesEndorsementCode (SR) (TR) | GES.EC = MS * | Graduation Status > Endorsement (Manage) | Endorsement | E1548 (C199) |
GES.ST | Status | |||||
STU.EOO | Profile > Endorsement (Manage) or | Opt-out (11th and 12th grade only) | ||||
Graduation Status > Endorsement (Manage) | ||||||
<AcademicStatus> <MultiStudiesEndorsementCode>X</MultiStudiesEndorsementCode> </AcademicStatus> where X =
On Update Code Tables:
| ||||||
PERFORMANCE-ACKNOWLEDGMENT-DUAL-CREDIT (X) | TE114 (TC039) | DualCreditCode (SR) (TR) | ACT.TY = 4 | Activities and Awards | Type | N/A |
ACT.CD = PA1 * | Code | |||||
ACT.RS = PA1-1 or PA1-2 * | Reason | |||||
<AcademicStatus> <DualCreditType> <DualCreditCode>X</DualCreditCode> </DualCreditType> </AcademicStatus> where X =
The following must be mapped on Texas State Reporting > Code Translations:
| ||||||
PERFORMANCE- ACKNOWLEGEMENT-MET-DATE (X) | TE115 | MetDate (SR) (TR) | ACT.DT | Activities and Awards | Date | N/A |
<AcademicStatus> <DualCreditType> <MetDate>YYYY-MM</MetDate> </DualCreditType> </AcademicStatus> where YYYY-MM = ACT.DT (converted to YYYY-MM format) when:
| ||||||
PERFORMANCE-ACKNOWLEDGMENT-BILINGUALISM-BILITERACY (X) | TE111 (TC37) | BilingBilitCode (SR) (TR) | ACT.TY = 4 | Activities and Awards | Type/td> | N/A |
ACT.CD = PA2 * | Code | |||||
<AcademicStatus> <BilingBilitType> <BilingBilitCode>X</BilingBilitCode> </BilingBilitType> </AcademicStatus> where X = 1 if:
| ||||||
PERFORMANCE- ACKNOWLEGEMENT-MET-DATE (X) | TE115 | MetDate (SR) (TR) | ACT.DT | Activities and Awards | Date | N/A |
<AcademicStatus> <BilingBilitType> <MetDate>YYYY-MM</MetDate> </BilingBilitType> </AcademicStatus> where YYYY-MM = ACT.DT (converted to YYYY-MM format) if:
| ||||||
PERFORMANCE-ACKNOWLEDGMENT-COLLEGE-READINESS-ASSESSMENTS (X) | TE113 (TC38) | CollegeAssessCode (SR) (TR) | ACT.TY = 4 | Activities and Awards | Type | N/A |
ACT.CD = PA5 * | Code | |||||
ACT.RS * | Reason | |||||
<AcademicStatus> <CollegeAssessType> <CollegeAssessCode>X</CollegeAssessCode> </CollegeAssessType> </AcademicStatus> where X =
The following must be mapped on Texas State Reporting > Code Translations:
| ||||||
PERFORMANCE- ACKNOWLEGEMENT-MET-DATE (X) | TE115 | MetDate (SR) (TR) | ACT.DT | Activities and Awards | Date | N/A |
<AcademicStatus> <CollegeAssessType> <MetDate>YYYY-MM</MetDate> </CollegeAssessType> </AcademicStatus> where YYYY-MM = ACT.DT (converted to YYYY-MM format) if:
| ||||||
PERFORMANCE-ACKNOWLEDGMENT-AP-IB-EXAMS (X) | TE110 (TC36) | ApIbCode (SR) (TR) | ACT.TY = 4 | Activities and Awards | Type | N/A |
ACT.CD = PA3 or PA4 * | Code | |||||
ACT.RS * | Reason | |||||
<AcademicStatus> <ApIbType> <ApIbCode>XX</ApIbCode> </ApIbType> </AcademicStatus> where XX =ACT.RS if:
The following must be mapped on Texas State Reporting > Code Translations:
| ||||||
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:
| ||||||
PERFORMANCE-ACKNOWLEDGMENT-CERTIFICATION-LICENSURES (X) | TE112 | CertLicCode (SR) (TR) | ACT.TY = 4 | Activities and Awards | Type | N/A |
ACT.CD = PA6 * | Code | |||||
ACT.RS * | Reason | |||||
<AcademicStatus> <CertLicType> <CertLicCode>Code</CertLicCode> </CertLicType> </AcademicStatus> where Code = ACT.RS if:
| ||||||
PERFORMANCE- ACKNOWLEGEMENT-MET-DATE (X) | TE115 | MetDate (SR) (TR) | ACT.DT | Activities and Awards | Date | N/A |
<AcademicStatus> <CertLicType> <MetDate>YYYY-MM</MetDate> </CertLicType> </AcademicStatus> where YYYY-MM = ACT.DT (converted to YYYY-MM format) if:
| ||||||
INDIVIDUAL-GRADUATION-COMMITTEE-REVIEW-CODE (X) | TE117 (TC40) | IGCGradReview (SR) | STU.IGG | Demographics > Student Data 2 | Individual Graduation Committee - Grad Code | 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) | FHSPCollegeCareer InstructionIndicator (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 = Yes | Courses > Other | OnRamps Dual Enr | E1597 (C088) |
<AcademicStatus> </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.ED | 504 Plans | Effective Date/Leave Date | E1603 (C088) |
<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) | TE123 | POIIMetDate (SR) (TR) | ACT.TY = 5 | Activities and Awards | Type | N/A |
ACT.CD = G03 * | Code | |||||
ACT.DT | Date | |||||
<AcademicStatus> where YYYY-MM = ACT.DT (converted to YYYY-MM format) if:
| ||||||
CPR-AED-INSTRUCTION-MET-DATE (X) | TE122 | CPRAEDMetDate (SR) (TR) | ACT.TY = 5 | Activities and Awards | Type | N/A |
ACT.CD = G02 or G05 * | Code | |||||
ACT.DT | Date | |||||
<AcademicStatus> where YYYY-MM = ACT.DT (converted to YYYY-MM format) if:
| ||||||
STAR-OF-TEXAS-INDICATOR-CODE (X) | TE121 (TC16) | StarofTexas (SR) | ACT.TY = 2 | Activities and Awards | Type | E1601 (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. | ||||||
SAT-ACT-TSIA-REIMBURSEMENT-INDICATOR (X) | TE134 | SATACTReimbursement (SR) | SSD.TFR | Secondary Stu Data | Test Fee Reimbursement | N/A |
<AcademicStatus> <SATACTReimbursement>X</SATACTReimbursement> </AcademicStatus> where X = SSD.TRF if present; otherwise omitted | ||||||
IBC-REIMBURSEMENT-INDICATOR (X) | TE132 | IBCReimbursement (SR) | ACT.IBS | Activities and Awards | Reimbursement Status | N/A |
ACT.TY = 3 | Type | |||||
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 = 3 | Activities and Awards | Type | E1640 (C214) |
ACT.CD * | Code | |||||
<AcademicStatus> <IBCEarned>XXX</IBCEarned> </AcademicStatus> 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. | ||||||
POST-SECONDARY-CERTIFICATION-LICENSURE-RESULT | TE142 (TC47) | TX-PostSecondary CertificationLicensureResultCode | ACT.PCR | Activities and Awards | Post-Secondary Certification Licensure Result | E1733 (C232) |
ACT.TY | Type | |||||
<AcademicStatus> <IBCEarned> <IBCCode></IBCCode> <TX-PostSecondaryCertificationLicensureResultCode>XX</TX-PostSecondaryCertificationLicensureResultCode> </IBCEarned> </AcademicStatus> where XX = ACT.PCR if populated and ACT.TY = 3; otherwise omitted | ||||||
FINANCIAL-AID-APPLICATION-CODE (X) | TE139 (TC46) | FinancialAidApplication | ACT.TY | <Activities and Awards | Type | N/A |
ACT.CD * | Code | |||||
ACT.RS * | Reason | |||||
<AcademicStatus> <FinancialAidApplication>01/02</FinancialAidApplication> </AcademicStatus> where 01/02 =
| ||||||
FINANCIAL-AID-APPLICATION-MET-DATE (X) | TE140 | FinancialAidApplication MetDate | ACT.DT | Activities and Awards | Date | N/A |
<AcademicStatus> <FinancialAidApplicationMetDate>YYYY-MM</FinancialAidApplicationMetDate> </AcademicStatus> where YYYY-MM = ACT.DT (converted to YYYY-MM format) if:
|
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.Field | Aeries Page | Label | PEIMS ID & Code Table |
COURSE-NAME (X) | TE025 | CourseTitle (SR) (TR) | CRS.CO | Courses | Title | E0724 (C022) |
<CurrentCoursework> <Course> <CourseTitle>Title</CourseTitle> </Course> </CurrentCoursework> where Title = CRS.CO | ||||||
COURSE-NUMBER (X) (I) | TE026 | CourseID (SR) (TR) | CRS.SVC | Courses > Other | Service ID | E0724 (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.SM | Master Schedule | Sem | N/A |
<CurrentCoursework> <Course> <Semester>N</Semester> </Course> </CurrentCoursework> where N = MST.SM | ||||||
CLASS-PERIOD | TE017 | ClassPeriod (SR) | MST.FSQ | Master Schedule | Flex Period | N/A |
<CurrentCoursework> <Course> <ClassPeriod>N</ClassPeriod> </Course> <CurrentCoursework> where N = MST.FSQ | ||||||
COURSE-CATEGORY (X) | TE021 (TC05)> | SubjectArea (SR) (TR) | CRS.S1 * | Courses | Subject Area Code | N/A |
REQ.CD | Graduation Requirements | Code | ||||
-- | -- | <CurrentCoursework> <Course> <SubjectArea>Subject</SubjectArea> </Course> </CurrentCoursework> where Subject = CRS.S1
| ||||
COURSE-GRADE | TE023 | CourseGrade (SR) (TR) | GRD.M# | Grades | mark | -- |
<CurrentCoursework> ><Course> <CourseGrade>XXX</CourseGrade> </Course> </CurrentCoursework> where XXX = the latest value found for a grading period
| ||||||
WITHDRAWAL-COURSE-GRADE | TE077 | WithdrawGrade (SR) | -- | -- | -- | -- |
not extracted | ||||||
COURSE-GRADE-AVERAGE (X) | TE024 | GradeAverage (SR) (TR) | GRD.M# | Grades | mark | -- |
<CurrentCoursework> <Course> <GradeAverage>XXX</GradeAverage> </Course> <CurrentCoursework> where XXX = calculated according to latest values found for a grading period
| ||||||
COURSE-CREDIT (X) | TE022 | CourseCredit (SR) (TR) | HIS.CC | Transcripts | Comp | -- |
-- | <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.LN | Staff | Last Name | N/A |
STF.FN | First Name | |||||
SSM.ID | Master Schedule | Staff 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.ID | Course History Institutions | ID Number | ||||
LOC.CC + LOC.DC = LOC.SC | School Options | County + District + Campus | ||||
<CurrentCoursework> <Course> <CreditCampus>CCCDDDSSS</CreditCampus> </Course> </CurrentCoursework> where CCCDDDSSS =
| ||||||
SEMESTER-SEQUENCE (X) | TE068 (TC18) | SemesterSeq (SR) | CRS.CSQ * | Courses > Other | Crs 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 | Demographics | Grade | E0017 (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.Field | Aeries Page | Label | PEIMS ID & Code Table |
ACADEMIC-YEAR (X) | TE001 | SchoolYear (SR) (TR) | HIS.YR | Transcripts > Course History | Year | N/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 | Transcripts | Grd | E0017 (C050) |
<AcademicSession> <GradeLevel>NN</GradeLevel> </AcademicSession> where NN = HIS.GR | ||||||
SESSION-TYPE (X) | TE087 | SessionType (SR) (TR) | HIS.TE> | Transcripts | Term | N/A |
<AcademicSession> <SessionType>Semester/Trimester/Quarter </SessionType> </AcademicSession> where Semester/Trimester/Quarter =
| ||||||
COURSE-NAME (X) | TE025 | CourseTitle (SR) (TR) | HIS.CO or | Transcripts | Special Crs Title | E0724 (C022) |
CRS.CO | Std Course Title | |||||
Courses | Title | |||||
<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.SVC | Courses > Other | Service ID | E0724 (C022) |
HIS.CN | Transcripts | Course 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 * | Courses | Subject Area Code | N/A |
REQ.CD | Graduation Requirements | Code | ||||
<AcademicSession> <Course> <SubjectArea>Subject</SubjectArea> </Course> </AcademicSession> where Subject = CRS.S1
| ||||||
COURSE-SEMESTER (X) | TE082 | Semester (SR) (TR) | HIS.TE | Transcripts | Term | N/A |
<AcademicSession> <Course> <Semester>N</Semester> </Course>> </AcademicSession> where N = HIS.TE | ||||||
COURSE-TEACHER (X) | TE027 | CourseTeacher (SR) | STF.LN | Staff | Last Name | N/A |
STF.FN | First Name | |||||
HIS.SID | Transcript > Course History | Staff | ||||
<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.MK | Transcripts > Course History | Mark | N/A |
<AcademicSession> <Course> <CourseGrade>NNN</CourseGrade> </Course> </AcademicSession> where NNN = HIS.MK | ||||||
COURSE-GRADE-AVERAGE (X) | TE024 | GradeAverage (SR) (TR) | HIS.MK | Transcripts > Course History | Mark | E1075 |
<AcademicSession> <Course> <GradeAverage>NNN</GradeAverage> </Course> </AcademicSession> where NNN = HIS.MK | ||||||
COURSE-CREDIT (X) | TE022 | CourseCredit (SR) (TR) | HIS.CC | Transcripts > Course History | Comp | N/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.ST | Transcripts > Course History | Schl | N/A |
CHI.ID | Course History Institutions | ID Number | ||||
LOC.CC + LOC.DC = LOC.SC | School Options | County + District + Campus | ||||
<AcademicSession> <Course> <CreditCampus>CCCDDDSSS</CreditCampus> </Course> </AcademicSession> where CCCDDDSSS =
| ||||||
SEMESTER-SEQUENCE (X) | TE068 (TC18) | SemesterSeq (SR) | CRS.CSQ * | Courses > Other | Crs Seq | E0948 (C135) |
<AcademicSession> <Course> <SemesterSeq>N</SemesterSeq> </Course> </AcademicSession> where N = CRS.CSQ | ||||||
FINAL-GRADE-AVERAGE (X) | TE088 | FinalGradeAverage (SR) (TR) | HIS.MK | Transcripts > Course History | Mark | N/A |
<AcademicSession> <Course> <FinalGradeAverage>NNN</FinalGradeAverage> </Course> </AcademicSession> where NNN = HIS.MK | ||||||
CLASS-PERIOD | TE017 | ClassPeriod (SR) | -- | -- | -- | -- |
not extracted | ||||||
PASS/FAIL-CREDIT-INDICATOR (X) | TE084 (TC25) | PassFailCredit (SR) (TR) | HIS.PF * | Transcripts > Course History | Pass/Fail Credit Status | E0949 (C136) |
<AcademicSession> <Course> <PassFailCredit>NN</PassFailCredit> </Course> </AcademicSession> where NN = HIS.PF | ||||||
SPECIAL-EXPLANATION-CODE (X) | TE070 (TC19) | Explanation (TR) | XRF.CD CHC.CD | Transcripts > Course History | Indicators | N/A |
CCH.CD | Courses > Characteristics | Code | ||||
<AcademicSession> <Course> <Explanation>X</Explanation> </Course> </AcademicSession> where X = XRF.CD or CCH.CD For transcript records, Indicators must be defined on Transcript Indicator Definitions page (district level). | ||||||
WITHDRAWAL-COURSE-GRADE | TE077 | WithdrawGrade (SR) | -- | -- | -- | -- |
not extracted |
Complex Type: AcademicSummary ↑
TREx Element (X) = Extracted (I) = Imported | TREx ID & Code Table | XML Name (SR) = Student Record (TR) = AAR/Transcript | Aeries Table.Field | Aeries Page | Label | PEIMS ID & Code Table |
GRADE-POINT-AVERAGE (X) | TE045 | GPA (TR) | If using Aeries built-in GPA: | |||
STU.GP, or | Transcripts | Acad GPA (W) | N/A | |||
STU.GPN, or | Acad GPA | |||||
STU.TP, or | Total GPA (W) | |||||
STU.TPN, or | Total GPA | |||||
STU.CP, or | 10-12 GPA (W) | |||||
STU.CPN | 10-12 GPA | |||||
if using custom district GPA: | ||||||
GPA.GPW, or | Transcripts | GPA - Weighted | ||||
GPA.GPN | GPA - Nonweighted | |||||
<AcademicSummary> <GPA>N.NNNN</GPA> where N.NNNN = GPA according to the following settings:
| ||||||
NUMBER-IN-CLASS (X) | TE061 | ClassTotalNumber (TR) | STU.CS | Transcripts | Class Size | N/A |
<AcademicSummary> where NNNNN = STU.CS | ||||||
CLASS-RANK (X) | TE018 | ClassRank (TR)> | STU.CR or | Transcripts | Class Rank | N/A |
GPA.CR | ||||||
<AcademicSummary> <ClassRank>NNNNN</ClassRank> </AcademicSummary> where NNNNN =
| ||||||
DATE-OF-RANKING (X) | TE029 | ClassRankingDate (TR) | LOC.D3 | School Information | Class Rank DT | N/A |
<AcademicSummary> <ClassRankingDate>YYYY-MM-DD</ClassRankingDate> </AcademicSummary> where YYYY-MM-DD = LOC.D3 LOC.D3 is updated when Recompute Cumulative GPAs and Class Rank or Recompute Grade Reporting GPAs and Class Rank is run, or when you click Recompute GPA on the Transcripts page. | ||||||
QUARTILE (X) | TE067 (TC17) | Quartile (TR) | STU.CR | Transcripts | Class Rank | N/A |
STU.CS | Class Size | |||||
<AcademicSummary> <Quartile>X</Quartile> </AcademicSummary> where X =
| ||||||
COLLEGE-BOARD-CAMPUS-CODE (X) | TE019 | CollegeCampusCode (TR) | LOC.CBC | School Options | College Entrance Exam Board | N/A |
<AcademicSummary> <CollegeCampusCode>XXXXXX</Quartile> </AcademicSummary> where XXXXXX = LOC.CBC |
Complex Type: DisciplineAction ↑
- Only unexpired Assertive Discipline records are extracted.
- State-reportable discipline data must be sent in the TREx Student Record file for the current school year. Once the school year ends, discipline data continues to be extracted until the 4th Thursday of October in the new school year.
TREx Element (X) = Extracted (I) = Imported | TREx ID & Code Table | XML Name (SR) = Student Record (TR) = AAR/Transcript | Aeries Table.Field | Aeries Page | Label | PEIMS ID & Code Table |
DISCIPLINARY-INCIDENT-NUMBER (X) | TE156 | IncidentIdentifier (SR) | ADS.IID | Assertive Discipline | Incident ID | E1016 |
<DisciplineAction> <IncidentIdentifier>NNNNNN</IncidentIdentifier> </DisciplineAction> where NNNNNN = ADS.IID | ||||||
DISCIPLINE-SCHOOL-YEAR (X) | TE155 | SchoolYear (SR) | -- | -- | -- | N/A |
<DisciplineAction> <SchoolYear>YYYY-YYYY</SchoolYear> </DisciplineAction> where YYYY-YYYY = the current school year | ||||||
DATE-OF-DISCIPLINARY-ACTION (X) | TE157 | DisciplineDate (SR) | DSP.DA or | Assertive Discipline | Administrative Decisions - Action Decision Date | E1036 |
DSP.DD or | Administrative Decisions - Served - Start Date | |||||
DSP.IDD | Administrative Decisions - Assigned - Start Date | |||||
<DisciplineAction> <DisciplineDate>YYYT-MM-DD</DisciplineDate> </DisciplineAction> where YYYY-MM-DD = DSP.DA if populated; otherwise DSP.DD if populated; otherwise DSP.IDD | ||||||
ACTUAL-LENGTH-OF-DISCIPLINARY-ASSIGNMENT (X) | TE158 | ActualDisciplineActionLength (SR) | DSP.DY | Assertive Discipline | Administrative Decisions - Served - Days | E1008 |
<DisciplineAction> <ActualDisciplineActionLength>NNN</ActualDisciplineActionLength> </DisciplineAction> where NNN = DSP.DY | ||||||
CAMPUS-ID-OF-DISCIPLINARY-RESPONSIBILITY (X) | TE159 | StateOrganizationId (SR) | ADS.SCL | Assertive Discipline | School | E1037 |
LOC.CC + LOC.DC | School Options | County + District | ||||
<DisciplineAction> <StateOrganizationId>CCCDDDSSS</StateOrganizationId> </DisciplineAction> where CCCDDDSSS = LOC.CC + LOC.DC + ADS.SCL | ||||||
OFFICIAL-LENGTH-OF-DISCIPLINARY-ASSIGNMENT (X) | TE160 | TX-OfficialLengthOfDisciplinaryAssignment (SR) | DSP.IDY | Assertive Discipline | Administrative Decisions - Assigned - Days | E1007 |
<DisciplineAction> <TX-OfficialLengthOfDisciplinaryAssignment>NNN </DisciplineAction> where NNN = DSP.IDY | ||||||
DISCIPLINARY-LENGTH-DIFFERENCE-REASON-CODE (X) | TE161 (TC52) | TX-DisciplinaryLengthDifferenceReason (SR) | DSP.RDD | Assertive Discipline | Administrative Decisions - Reason Different | E1009 (C166) |
<DisciplineAction> <TX-DisciplinaryLengthDifferenceReason>XX</TXDisciplinaryLengthDifferenceReason> </DisciplineAction> where XX = DSP.RDD< | ||||||
INCONSISTENT-CODE-OF-CONDUCT-INDICATOR-CODE (X) | TE162 (TC16) | TX-InconsistentCodeOfConductIndicator (SR) | DSP.IC | Assertive Discipline | Administrative Decisions - Action Inconsistent With Code of Conduct Policy | E1656 (C088) |
<DisciplineAction> <TX-InconsistentCodeOfConductIndicator>X </DisciplineAction> where X = DSP.IC | ||||||
BEHAVIOR-LOCATION-CODE (X) | TE163 (TC51) | TX-BehaviorLocation (SR) | ADS.LCN | Assertive Discipline | Location | E1083 (C190) |
<DisciplineAction> <TX-BehaviorLocation>XX</TX-BehaviorLocation> </DisciplineAction> where XX = ADS.LCN | ||||||
SAFE-SUPPORTIVE-SCHOOL-PROGRAM-TEAM-REVIEW (X) | TE143 (TC16) | TX-SafeSupportiveSchoolProgramTeamReview (SR) | ADS.SSP | Assertive Discipline > Additional Info | SSSP Team Review | E1734 (C088) |
<DisciplineAction> <TX-SafeSupportiveSchoolProgramTeamReview>X </DisciplineAction> where X = ADS.SSP | ||||||
DISCIPLINARY-ACTION-CODE (X) | TE030 (TC06) | DisciplineActionCode (SR) | DSP.DS * | Assertive Discipline | Administrative Decision | E1005 (C164) |
<DisciplineAction> <DisciplineActionCode>XX</DisciplineActionCode> </DisciplineAction> where XX = DSP.DS | ||||||
DISCIPLINARY-ACTION-NUMBER (X) | TE032 | DisciplineActionNum (SR) | DSP.SQ | Assertive Discipline | sequence (not displayed) | E1004 |
<DisciplineAction> <DisciplineActionNum>NNN</DisciplineActionNum> </DisciplineAction> where NNN = DSP.SQ | ||||||
DISCIPLINARY-ACTION-REASON (X) | TE033 (TC07) | DisciplineActionReason (SR) | ADS.CD * | Assertive Discipline | Violations | E1006 (C165) |
<DisciplineAction> </DisciplineAction> where XX = ADS.CD |