InterchangeEducationOrganizationExtension

LocalEducationAgencyExtension

Element IDData ElementXML NameAeries Table and FieldAeries PageLabelMandatory
LocalEducationAgency
   E0212DISTRICT-IDStateOrganizationIdLOC.CC + LOC.DCSchool OptionsCounty + DistrictY
LocalEducationAgencyExtension


SchoolExtension

Element ID Data ElementXML NameAeries Table.FieldAeries Page or ReportLabel on PageMandatory?
School
   E0266CAMPUS-IDStateOrganizationIdLOC.CC + LOC.DC + LOC.SCSchool OptionsCounty + District + CampusY
   **EducationalOrgReferenceTypeLocalEducationAgencyReference



Y
      **   EducationalOrgIdentityType
EducationalOrgIdentity


Y
      E0212DISTRICT-IDStateOrganizationIdLOC.CC + LOC.DCSchool OptionsCounty + DistrictY
SchoolExtension
E1613EXPANDED-LEARNING-OPPORTUNITY-INDICATOR-CODETX-ExpandedLearningOpportunityIndicatorif ELO record exists
Expanded Learning Opportunities
Y
**TX-SchoolELOSTX-SchoolELOS


Y
   **   TX-SchoolELOTypeTX-SchoolELO


Y
      E1614ELO-TYPE-CODETX-ELOTypeELO.TYExpanded Learning OpportunitiesELO TypeY
      E1621ELO-MINUTES-SCHEDULED-PER-DAYTX-ELOMinutesScheduledPerDayELO.MDExpanded Learning Opportunities
Minutes Scheduled Per DayY
      E1615ELO-RIGOROUS-COURSEWORK-INDICATOR-CODETX-ELORigorousCourseworkIndicatorELO.RCExpanded Learning Opportunities
Rigorous CourseworkY
      E1616ELO-MENTORING-INDICATOR-CODETX-ELOMentoringIndicatorELO.MIExpanded Learning Opportunities
MentoringY
      E1617ELO-TUTORING-INDICATOR-CODETX-ELOTutoringIndicatorELO.TIExpanded Learning Opportunities
TutoringY
      E1618ELO-PHYSICAL-ACTIVITY-INDICATOR-CODETX-ELOPhysicalActivityIndicatorELO.PAExpanded Learning Opportunities
Physical ActivityY
      E1619ELO-ACADEMIC-SUPPORT-INDICATOR-CODETX-ELOAcademicSupportIndicatorELO.AI
Expanded Learning Opportunities
Academic SupportY
      E1620ELO-EDUCATIONAL-ENRICHMENT-INDICATOR-CODETX-ELOEducationalEnrichmentIndicatorELO.EEExpanded Learning Opportunities
Educational EnrichmentY


Course

Element ID Data ElementXML NameAeries Table.FieldAeries Page or ReportLabel on PageMandatory?
Course
**CourseCode
CourseCode


Y
   E1089COURSE-IDENTIFICATION-SYSTEM(a) IdentificationSystem"State Course Code"

Y
   E0724
SERVICE-IDIDCRS.SVC
CoursesService IDY
**EducationalOrgReferenceTypeEducationOrganizationReference


Y
   **   EducationalOrgIdentityType
EducationalOrgIdentity


Y
      E0266CAMPUS-IDStateOrganizationIdLOC.CC + LOC.DC + LOC.SCSchool OptionsCounty + District + CampusY



InterchangeMasterScheduleExtension

CourseOffering

Element ID Data ElementXML NameAeries Table.FieldAeries Page or ReportLabel on PageMandatory?
CourseOffering
   **EducationalOrgReferenceTypeSchoolReference


Y
   **   EducationalOrgIdentityTypeEducationalOrgIdentity


Y
      E0266
CAMPUS-IDStateOrganizationIdLOC.SCSchool OptionsCampusY
**CourseReferenceTypeCourseReference


Y
   **   CourseIdentityTypeCourseIdentity
Y
      **      CourseCodeCourseCode

Y
         E1089COURSE-IDENTIFICATION-SYSTEM
(a) IdentificationSystem"State Course Code"


Y
         E0724SERVICE-IDIDCRS.SVCCoursesService IDY


SectionExtension

Element ID Data ElementXML NameAeries Table.FieldAeries Page or ReportLabel on PageMandatory?
Section
   E1056CLASS-ID-NUMBERUniqueSectionCodeMST.SC + "_" + MST.SEMaster ScheduleSectionY
   **
   CourseOfferingReferenceCourseOfferingReference

Y
      **Reference Type(a) ref


Y
   **   EducationalOrgReferenceTypeSchoolReference
Y
      **      EducationalOrgIdentityTypeEducationalOrgIdentity


Y
      E0266CAMPUS-IDStateOrganizationIdLOC.SCSchool OptionsCampusY
SectionExtension
E1093SCHOOL-YEARTX-SchoolYearCalculated from current database year

Y
E0948COURSE-SEQUENCE-CODETX-CourseSequenceCRS.CSQCoursesCrs SeqY



InterchangeStudentExtension

StudentExtension

Element IDData ElementXML NameAeries Table.FieldAeries Page or ReportLabel on PageMandatory?
Student
   E1523TX-UNIQUE-STUDENT-IDStudentUniqueStateIdSTU.CID
Demographics > Student Data 2 tabUnique IDY
   **   StudentIdentificationCodeStudentIdentificationCode

Y
      E1090STUDENT-IDENTIFICATION-SYSTEM(a) IdentificationSystem"State"

Y
      E0001STUDENT-IDIdentificationCodeESD.ED
Demographics > Student Data 2 tabSoc-Sec-Num / S-NumberY
      E0923LOCAL-STUDENT-IDIdentificationCodeSTU.ID
DemographicsPerm ID#Y
   **   NameName


Y
      E0703FIRST-NAMEFirstNameSTU.FN
DemographicsFirst NameY
      E0704MIDDLE-NAMEMiddleNameSTU.MN
DemographicsMiddle NameY
      E0705LAST-NAMELastSurnameSTU.LN
DemographicsLast NameY
   **   BirthDataBirthData

Y
     E0006DATE-OF-BIRTHBirthDateSTU.BDDemographicsBirthdateY
StudentExtension
**EducationalOrgReferenceTypeTX-LEAReference

Y
   **   EducationalOrgIdentityTypeEducationalOrgIdentity

Y
      E0212DISTRICT-IDStateOrganizationIdLOC.CC + LOC.DCSchool OptionsCounty + DistrictY
E0706GENERATION-CODETX-GenerationCodeSTU.SF
DemographicsSuffixY
E0004SEX-CODETX-SexSTU.GN
DemographicsGenderY
E1064HISPANIC-LATINO-CODETX-HispanicLatinoEthnicitySTU.ETH
DemographicsEthnicityY
**TX-RaceTypeTX-Race

Y
   E1059AMERICAN-INDIAN-ALASKA-NATIVE-CODETX-AmericanIndianAlaskaNativeSTU.RC1 - STU.RC5DemographicsRace - Race5Y
   E1060ASIAN-CODETX-AsianSTU.RC1 - STU.RC5DemographicsRace - Race5Y
   E1061BLACK-AFRICAN-AMERICAN-CODETX-BlackAfricanAmericanSTU.RC1 - STU.RC5DemographicsRace - Race5Y
   E1062NATIVE-HAWAIIAN-PACIFIC-ISLANDER-CODETX-NativeHawaiianPacificIslanderSTU.RC1 - STU.RC5
DemographicsRace - Race5
Y
   E1063WHITE-CODETX-WhiteSTU.RC1 - STU.RC5
DemographicsRace - Race5Y
**TX-StudentCharacteristicsTypeTX-StudentCharacteristics


Y
   E0790LEP-INDICATOR-CODETX-LEPIndicatorSTU.LF
Demographics
LangFluY
   E0984MIGRANT-INDICATOR-CODETX-MigrantIndicatorPGM.CD = 135
Special ProgramsProgram Code
Y
   E1528FOSTER-CARE-INDICATOR-CODETX-FosterCareIndicatorPGM.CD = 190
Special ProgramsProgram CodeY
   E1559T-STEM-INDICATOR-CODETX-TSTEMIndicatorLOC.STI; if not set, PGM.CD = 403
School Options; Special ProgramsT-STEM Indicator; Program Code
Y
   E1560ECHS-INDICATOR-CODETX-ECHSIndicatorLOC.ECI; if not set, PGM.CD = 410 is used
School Options; Special ProgramsECHS Indicator; Program CodeY
   E1612P-TECH-INDICATOR-CODETX-PTECHIndicatorLOC.PTI; if not set, PGM.CD = 411
School Options; Special ProgramsP-TECH Indicator; Special ProgramsY
   E1647NEW-TECH-INDICATOR-CODETX-NewTechIndicatorOPT.NM = New_Tech_Network
School OptionsNew Tech NetworkY
E1054CRISIS-CODETX-CrisisIndicatorPGM.CD = 404; PGM.CR contains COD defined value
Special ProgramsProgram Code; Indicator CodeY



InterchangeStudentEnrollmentExtension

StudentSchoolAssociationExtension

Element ID Data ElementXML NameAeries Table.FieldAeries Page or ReportLabel on PageMandatory?
StudentSchoolAssociation
   **   StudentReferenceType
StudentReference


Y
      **      StudentIdentityTypeStudentIdentity


Y
         E1523TX-UNIQUE-STUDENT-IDStudentUniqueStateIdSTU.CIDDemographics > Student Data 2 tabUnique IDY
   **
 EducationalOrgReferenceType
SchoolReference


Y
      **   EducationalOrgIdentityTypeEducationalOrgIdentity


Y
         E0266CAMPUS-IDStateOrganizationIdLOC.CC + LOC.DC + LOC.SCSchool OptionsCounty + District + CampusY
StudentSchoolAssociationExtension
E0017GRADE-LEVEL-CODETX-GradeLevelENG.GR
Enrollment HistoryGrdY
E0782CAMPUS-ID-OF-ENROLLMENTTX-CampusIdOfEnrollmentENR.SC, ENR.HSEnrollment HistorySchool, Rptg SchoolY
E0903CAMPUS-ID-OF-RESIDENCETX-CampusIdOfResidenceSTU.RSDemographicsResSchlY
E1000STUDENT-ATTRIBUTION-CODETX-AttributionSTU.IT, ATT.IT, ENR.ITDemographics, Attendance Enrollment, Enrollment History
Attr Code, AttrCd, Attr CodeY


StudentSectionAssociation

Element ID Data ElementXML NameAeries Table.FieldAeries Page or ReportLabel on PageMandatory?
StudentSectionAssociation
**StudentReferenceTypeStudentReference


Y
   **   StudentIdentityType
StudentIdentity


Y
      E1523TX-UNIQUE-STUDENT-IDStudentUniqueStateIdSTU.CID
Demographics > Student Data 2 tabUnique IDY
**SectionReferenceTypeSectionReference


Y
   **SectionIdentityTypeSectionIdentity


Y
      E0266CAMPUS-IDStateOrganizationIdLOC.CC + LOC.DC + LOC.SC
School OptionsCounty + District + CampusY
      E1056CLASS-ID-NUMBERUniqueSectionCodeMST.SC + "_" + MST.SEMaster ScheduleSectionY
E1069STUDENT-BEGIN-DATEBeginDateCAR.DS
Course Attendance
Start DateY
E1070STUDENT-END-DATEEndDateCAR.DECourse AttendanceStop DateY
E0948COURSE-SEQUENCE-CODETX-CourseSequenceCRS.CSQCoursesCrs Seq
Y
E1068COURSE-COMPLETION-INDICATORTX-CourseCompletionIndicatorHIS.DCTranscriptsDate of CompletionY



InterchangeStudentAttendanceExtension

SpecialProgramsReportingPeriodAttendanceExtension contents below good up to the Excel check

Element ID Data ElementXML NameAeries Table.FieldAeries Page or ReportLabel on PageMandatory?
SpecialProgramsReportingPeriodAttendanceExtension
**StudentReferenceTypeTX-StudentReference


Y
   **   StudentIdentityTypeStudentIdentity


Y
      E1523TX-UNIQUE-STUDENT-IDStudentUniqueStateIdSTU.CIDDemographics > Student Data 2 tabUnique IDY
E0782CAMPUS-ID-OF-ENROLLMENTTX-CampusIdOfEnrollmentLOC.CC + LOC.DC + LOC.SC
School OptionsCounty + District + CampusY
E1085ATTENDANCE-EVENT-INDICATORTX-AttendanceEventIndicator"Regular"

Y
E0975INSTRUCTIONAL-TRACK-INDICATOR-CODETX-InstructionalTrackARP.TR
Attendance Reporting PeriodsTrackY
E0934REPORTING-PERIOD-INDICATOR-CODETX-ReportingPeriodARP.RPAttendance Reporting PeriodsReporting PeriodY
E0935NUMBER-DAYS-TAUGHTTX-NumberDaysTaughtARS.DTStudent Attendance Detail report
Days Taught
Y
E0017GRADE-LEVEL-CODETX-GradeLevelSTU.GR (source for ARS.GR)DemographicsGrdY
E1651
BILINGUAL/ESL-FUNDING-CODETX-BilingualESLFundingCodePGM.FT when PGM.CD = 145, 146, or 147Special ProgramsFunding TypeY
E1049FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLETX-TotalEligibleDaysPresentARS.PRS
Student Attendance Detail report
PresentY
E1050FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLETX-TotalEligibleDaysPresentARS.PRS
Student Attendance Detail report
Present Y
E1653FLEX-ATTEND-TOTAL-RESIDENTIAL-FACILITY-DAYS-ELIGIBLETX-TotalEligibleDaysPresentARS.PRS
Student Attendance Detail report PresentY
E1051FLEX-ATTEND-DAYS-ELIGIBLE-IN-INSTR-SETTINGTX-TotalEligibleDaysPresentARS.PRS
Student Attendance Details report
PresentY
E1048FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLETX-TotalEligibleDaysPresent
ARS.ELG
Student Attendance Detail report
PresentY
E0173INSTRUCTIONAL-SETTING-CODETX-InstructionalSettingCSH.INS
Special Education > Instructional Settings tabInstructional SettingsY
E1046FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENTTX-TotalEligibleMinutesPresentARS.MPStudent Attendance Detail report
Y
E1053FLEX-ATTEND-TOTAL-CAREER-TECH-MINUTES-PRESENTTX-TotalEligibleMinutesPresent
ARS.MPStudent Attendance Detail report

Y
E1047FLEX-ATTEND-TOTAL-INELIGIBLE-MINUTES-PRESENTTX-TotalIneligibleMinutesPresentARS.MIStudent Attendance Detail report

Y
E1052FLEX-ATTEND-EXCESS-MINUTES-IN-INSTR-SETTINGTX-ExcessMinutesInstrSettingARS.MEStudent Attendance Detail report

Y
**TX-FlexibleAttendanceProgramTX-FlexibleAttendance


Y
   E1045FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODETX-FlexibleAttendanceProgramARS.FA, which originates in ATT.FA / ENR.FAStudent Attendance Summary report; Attendance Enrollment / Enrollment HistoryFlex-AttY



InterchangeStudentTranscriptExtension

StudentAcademicRecord

Element ID Data ElementXML NameAeries Table.FieldAeries Page or ReportLabel on PageMandatory?
StudentAcademicRecord
**Reference Type(a) idY
**StudentReferenceTypeStudentReference


Y
   **
   StudentIdentityType
StudentIdentity

Y
      E1523TX-UNIQUE-STUDENT-IDStudentUniqueStateIdSTU.CIDDemographics > Student Data 2 tabUnique IDY


CourseTranscriptExtension

Element ID Data ElementXML NameAeries Table.FieldAeries Page or ReportLabel on PageMandatory?
CourseTranscript
   **   CourseReferenceTypeCourseReference
Y
      **      CourseIdentityTypeCourseIdentity


Y
         **         CourseCodeCourseCode
 

Y
            E1089COURSE-IDENTIFICATION-SYSTEM(a) IdentificationSystem"State course code"

Y
            E0724SERVICE-IDIDCRS.SVCCoursesService IDY
  **   EducationalOrgReferenceTypeEducationOrganizationReference


Y
      **      EducationalOrgIdentityType   EducationalOrgIdentity


Y
         E0266CAMPUS-IDStateOrganizationIdLOC.CC + LOC.DC + LOC.SC
School OptionsCounty + District + CampusY
   **   StudentAcademicRecordStudentAcademicRecordReference


Y
      **Reference Type(a) ref


Y
CourseTranscriptExtension
E0017GRADE-LEVEL-CODETX-GradeLevelHIS.GR
TranscriptsGrdY
E0949PASS/FAIL-CREDIT-INDICATOR-CODETX-PassFailCreditIndicatorHIS.PFTranscriptsPass/Fail CreditY
E1011DUAL-CREDIT-INDICATOR-CODETX-DualCreditIndicatorCRS.CL = 24
Courses > Other tabCrs LvlY
E1058ATC-INDICATOR-CODETX-ATCIndicatorMST.ACMaster ScheduleArticulated CrsY
E1081COLLEGE-CREDIT-HOURSTX-CollegeCreditHoursHIS.CH
TranscriptsCollege Credit HoursY
E0782CAMPUS-ID-OF-ENROLLMENTTX-CampusIdOfEnrollmentHIS.STTranscriptsSchlY
E0948COURSE-SEQUENCE-CODETX-CourseSequenceCRS.CSQCoursesCrs SeqY
E1056CLASS-ID-NUMBERUniqueSectionCodeMST.SC + "_" + MST.SEMaster ScheduleSectionY
E1597ONRAMPS-DUAL-ENROLLMENT-INDICATOR-CODETX-OnRampsDualEnrollmentIndicatorCRS.ODCourses > Other tabOnRamps Dual EnrY (only used for 2019-2020 year)



InterchangeStudentProgramExtension

StudentProgramExtension

Element ID Data ElementXML NameAeries Table.FieldAeries Page or ReportLabel on PageMandatory?
StudentProgramExtension
**StudentReferenceTypeTX-StudentReferenceY
   **   StudentIdentityType
StudentIdentity


Y
      E1523TX-UNIQUE-STUDENT-IDStudentUniqueStateIdSTU.CIDDemographics > Student Data 2 tabUnique IDY
E1028BILINGUAL/ESL-SUMMER-SCHOOL-INDICATOR-CODETX-BilingualESLSummerPGM.CD = 145Special Programs
Program CodeY
E0034GIFTED-TALENTED-INDICATOR-CODETX-GiftedAndTalentedGTE record or PGM.CD = 127
GATE or Special Programs
Program Code
Y


StudentESYProgramAssociationExtension

Element ID Data ElementXML NameAeries Table.FieldAeries Page or ReportLabel on PageMandatory?
StudentProgramAssociation
   **   StudentReferenceTypeStudentReferenceY
      **      StudentIdentityTypeStudentIdentity


Y
      E1523TX-UNIQUE-STUDENT-IDStudentUniqueStateIdSTU.CIDDemographics > Student Data 2 tabUnique IDY
   **   EducationalOrgReferenceTypeEducationOrganizationReference


Y
      **      EducationalOrgIdentityTypeEducationalOrgIdentity


Y
         E0212DISTRICT-IDStateOrganizationIdLOC.CC + LOC.DCSchool OptionsCounty + DistrictY
StudentESYProgramAssociationExtension
E0782CAMPUS-ID-OF-ENROLLMENTTX-CampusIdOfEnrollmentENR.SC, ENR.HS
Enrollment HistorySchool, Rptg SchoolY
E0017GRADE-LEVEL-CODETX-GradeLevelENR.GR
Enrollment HistoryGrdY
E0173INSTRUCTIONAL-SETTING-CODETX-InstructionalSettingCSH.INS
Special Education > Instructional Settings tabInstructional SettingY
E1013TOTAL-ESY-CONTACT-HRS-IN-INSTR-SETTINGTX-TotalESYContactHoursInstructionalSettingCSH.EHSpecial Education > Instructional Settings tabESY Contact HrsY
E0173INSTRUCTIONAL-SETTING-CODETX-InstructionalSetting_2CSH.EH
Special Education > Instructional Settings tabInstructional Setting
Y
E1013TOTAL-ESY-CONTACT-HRS-IN-INSTR-SETTINGTX-TotalESYContactHoursInstructionalSetting_2CSH.EHSpecial Education > Instructional Settings tabESY Contact Hrs
Y