InterchangeEducationOrganizationExtension

LocalEducationAgencyExtension

Element IDData ElementXML NameAeries Table and FieldAeries PageLabel
LocalEducationAgency
   **Reference Type(a) id



   E0212DISTRICT-IDStateOrganizationIdLOC.CC + LOC.DCSchool OptionsCounty + District
   **   ProgramReferenceProgramReference


      **Reference Type(a) ref


LocalEducationAgencyExtension


SchoolExtension

Element ID Data ElementXML NameAeries Table.FieldAeries Page or ReportLabel on Page
School
   **Reference Type(a) id



   E0266CAMPUS-IDStateOrganizationIdLOC.CC + LOC.DC + LOC.SCSchool OptionsCounty + District + Campus
   **   LocalEducationAgencyReferenceLocalEducationAgencyReference



      **      ReferenceTypeReferenceType


         **Reference Type(a) ref


   **   ClassPeriodReferenceClassPeriodReference


      **Reference Type(a) ref


SchoolExtension


ClassPeriod

Element ID Data ElementXML NameAeries Table and FieldAeries PageLabel
ClassPeriod
**Reference Type(a) id


E1074CLASS-PERIODClassPeriodNameMST.PDMaster SchedulePeriod


Course

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


   E1089COURSE-IDENTIFICATION-SYSTEM(a) IdentificationSystem"State Course Code" for E0724; "LEA Course Code" for E1194

   E0724
SERVICE-IDIDCRS.SVC
CoursesService ID
   E1194LOCAL-COURSE-CODEIDCRS.CNCoursesCrsID#


Program

Element ID Data ElementXML NameAeries Table and FieldAeries PageLabel
Program
**Reference Type(a) id


E1337PROGRAM-TYPEProgramTypeSPR.CD
School ProgramsProgram Type



InterchangeMasterScheduleExtension

CourseOffering

Element ID Data ElementXML NameAeries Table.FieldAeries Page or ReportLabel on Page
CourseOffering
**Reference Type(a) id


E1194LOCAL-COURSE-CODELocalCourseCodeCRS.CNCoursesCrsID#
**EducationalOrgReferenceTypeSchoolReference


   **   EducationalOrgIdentityTypeEducationalOrgIdentity


      E0266
CAMPUS-IDStateOrganizationIdLOC.SCSchool OptionsCampus
**CourseReferenceTypeCourseReference



   **   CourseIdentityTypeCourseIdentity


      **      CourseCodeCourseCode


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


         E1194LOCAL-COURSE-CODEIDCRS.CNCoursesCrsId#


SectionExtension

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


      **Reference Type(a) ref   
   **   EducationalOrgReferenceTypeSchoolReference


      **      EducationalOrgIdentityTypeEducationalOrgIdentity


      E0266CAMPUS-IDStateOrganizationIdLOC.SCSchool OptionsCampus
   **   ClassPeriodReferenceType
ClassPeriodReference


      **      ClassPeriodIdentityTypeClassPeriodIdentity


         E1074CLASS-PERIODClassPeriodNameMST.PDMaster SchedulePeriod
         E0266CAMPUS-IDStateOrganizationIdLOC.SCSchool OptionsCampus
SectionExtension
E0948COURSE-SEQUENCE-CODETX-CourseSequenceCRS.CSQCoursesCrs Seq



InterchangeStudentParentExtension

StudentExtension

Element IDData ElementXML NameAeries Table.FieldAeries Page or ReportLabel on Page
Student
   **Reference Type(a) id



   E1523TX-UNIQUE-STUDENT-IDStudentUniqueStateIdSTU.CID
Demographics > Student Data 2 tabUnique ID
   **   StudentIdentificationCodeStudentIdentificationCode


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

      E0001STUDENT-IDIdentificationCodeESD.ED
Demographics > Student Data 2 tabSoc-Sec-Num / S-Number
   **   NameName


      E0703FIRST-NAMEFirstNameSTU.FN
DemographicsFirst Name
      E0704MIDDLE-NAMEMiddleNameSTU.MN
DemographicsMiddle Name
      E0705LAST-NAMELastSurnameSTU.LN
DemographicsLast Name
   E1325SEXSexSTU.GNDemographicsGender
   **   BirthDataBirthData


     E0006DATE-OF-BIRTHBirthDateSTU.BDDemographicsBirthdate
   E1375HISPANIC-LATINO-ETHNICITYHispanicLatinoEthnicitySTU.ETHDemographicsEthnicity
   **   RaceTypeRace


      E1343RACIAL-CATEGORYRacialCategorySTU.RC1 - STU.RC5DemographicsRace
   E1390LIMITED-ENGLISH-PROFICIENCYLimitedEnglishProficiency
STU.LFDemographicsLangFlu
StudentExtension
**EducationalOrgReferenceTypeTX-LEAReference


   **   EducationalOrgIdentityTypeEducationalOrgIdentity


      E0212DISTRICT-IDStateOrganizationIdLOC.CC + LOC.DCSchool OptionsCounty + District



InterchangeStudentEnrollmentExtension

StudentSchoolAssociationExtension

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


      **      StudentIdentityTypeStudentIdentity


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


      **   EducationalOrgIdentityTypeEducationalOrgIdentity


         E0266CAMPUS-IDStateOrganizationIdLOC.CC + LOC.DC + LOC.SCSchool OptionsCounty + District + Campus
   E1517ENTRY-GRADE-LEVEL-TYPEEntryGradeLevelENR.GREnrollment HistoryGrd
StudentSchoolAssociationExtension


StudentSectionAssociation

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


   **   StudentIdentityType
StudentIdentity


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


   **SectionIdentityTypeSectionIdentity


      E0266CAMPUS-IDStateOrganizationIdLOC.CC + LOC.DC + LOC.SC
School OptionsCounty + District + Campus
      E1056CLASS-ID-NUMBERUniqueSectionCodeMST.SC + "_" + MST.SEMaster ScheduleSection
E1069STUDENT-BEGIN-DATEBeginDateCAR.DS
Course Attendance
Start Date
E1070STUDENT-END-DATEEndDateCAR.DECourse AttendanceStop Date
E1440HOME-ROOM-INDICATORHomeroomIndicatorBased on course enrollment on the day extract is run, the section with a CRS.SVC = 01020000. If student has multiple sections with CRS.SVC = 01020000, the section with the lowest CAR.SQ will be indicated as Homeroom.    
Course Attendance
E0948COURSE-SEQUENCE-CODETX-CourseSequenceCRS.CSQCoursesCrs Seq



InterchangeStaffAssociationExtension

StaffExtension

Element ID Data ElementXML NameAeries Table.FieldAeries Page or ReportLabel on Page
Staff
   **Reference Type(a) id


   E1524TX-UNIQUE-STAFF-IDStaffUniqueStateIdSTF.SIDStaffUnique ID
   **StaffIdentificationCodeStaffIdentificationCode


      E1088STAFF-IDENTIFICATION-SYSTEM(a) IdentificationSystem"07" for State

      E0505STAFF-ID  IDESD.EDStaffSocial Security #
   **
   Name
Name


      E0703FIRST-NAMEFirstNameSTF.FNStaffFirst Name
      E0705LAST-NAMELastSurnameSTF.LNStaff
Last Name
StaffExtension
**
EducationalOrgReferenceTypeTX-LEAReference


   **   EducationalOrgIdentityTypeEducationalOrgIdentity


      E0212DISTRICT-IDStateOrganizationIdLOC.CC + LOC.DCSchool OptionsCounty + District


TeacherSectionAssociationExtension

Element ID Data ElementXML NameAeries Table.FieldAeries Page or ReportLabel on Page
TeacherSectionAssociation
   **   StaffReferenceTypeTeacherReference


      **      StaffIdentityTypeStaffIdentity


         E1524TX-UNIQUE-STAFF-IDStaffUniqueStateIdSTF.SIDStaffUnique ID
   **   SectionReferenceTypeSectionReference


      **      SectionIdentityTypeSectionIdentity


         E0266CAMPUS-IDStateOrganizationIdLOC.SCSchool OptionsCampus
         E1056CLASS-ID-NUMBERUniqueSectionCodeMST.SC + "_" + MST.SE
Master ScheduleSection
   E1454
CLASSROOM-POSITIONClassroomPositionMST.TP1
Master Schedule
Position
   E1065ASSIGNMENT-BEGIN-DATEBeginDateCAR.DS
Course AttendanceStart Date
   E1066ASSIGNMENT-END-DATEEndDateCAR.DECourse AttendanceStop Date
TeacherSectionAssociationExtension
E0948
COURSE-SEQUENCE-TYPETX-CourseSequenceCRS.CSQCoursesCrs Seq