InterchangeEducationOrganizationExtension

LocalEducationAgencyExtension

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



Y
   E0212DISTRICT-IDStateOrganizationIdLOC.CC + LOC.DCSchool OptionsCounty + DistrictY
   **   ProgramReferenceProgramReference


Y
      **Reference Type(a) ref


Y
LocalEducationAgencyExtension


SchoolExtension

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



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



Y
      **      ReferenceTypeReferenceType


Y
      **Reference Type(a) refY
   **   ClassPeriodReferenceClassPeriodReference


Y
      **Reference Type(a) ref


Y
SchoolExtension


Location

Element ID Data ElementXML NameAeries Table and FieldAeries PageLabelMandatory
Location
**Reference Type(a) id


Y1
E1292CLASSROOM-IDENTIFICATION-CODEClassroomIdentificationCodeMST.SC + MST.RMMaster ScheduleRoomY1


ClassPeriod

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



E1074CLASS-PERIODClassPeriodNameMST.PDMaster SchedulePeriodY1


Course

Element ID Data ElementXML NameAeries Table.FieldAeries Page or ReportLabel on PageMandatory
Course
E1182LOCAL-COURSE-TITLECourseTitleCRS.COCoursesTitleY1
E1183NUMBER-OF-PARTSNumberOfParts"1"

Y1
**CourseCode
CourseCode


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

Y1
 E0724
SERVICE-IDIDCRS.SVC
CoursesService IDY1
   E1194LOCAL-COURSE-CODEIDCRS.CNCoursesCrsID#Y1
**CourseLevelCharacteristicsTypeCourseLevelCharacteristics


Y1
   E1193COURSE-LEVEL-CHARACTERISTICSCourseLevelCharacteristicCRS.CLCoursesCrs LvlY1
E1186SUBJECT-AREASubjectAreaCRS.S1CoursesSubject Area Code
Y1
**EducationOrganizationReferenceEducationOrganizationReference


Y1
   **   Reference Type
(a) ref


Y1



Program

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



E1337PROGRAM-TYPEProgramTypeSPR.CD
School ProgramsProgram TypeY1



InterchangeMasterScheduleExtension

CourseOffering

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


Y
E1194LOCAL-COURSE-CODELocalCourseCodeCRS.CNCoursesCrsID#Y
**EducationalOrgReferenceTypeSchoolReference


Y
   **   EducationalOrgIdentityTypeEducationalOrgIdentity


Y
      E0266
CAMPUS-IDStateOrganizationIdLOC.SCSchool OptionsCampusY
**SessionReferenceTypeSessionReference


Y
   **   SessionIdentityTypeSessionIdentity


Y
      E0266CAMPUS-IDStateOrganizationIdLOC.SCSchool OptionsCampusY
      E1093SCHOOL-YEARSchoolYearCalculated from current database year


Y
      E1370SESSION-TERMTermMST.TMMaster ScheduleSemY
**CourseReferenceTypeCourseReference



Y
   **   CourseIdentityTypeCourseIdentity


Y
      **      CourseCodeCourseCode


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


Y
         E0724SERVICE-IDIDCRS.SVCCoursesService IDY
      E1194LOCAL-COURSE-CODEIDCRS.CNCoursesCrsId#Y


SectionExtension

Element ID Data ElementXML NameAeries Table.FieldAeries Page or ReportLabel on PageMandatory
Section
   E1056CLASS-ID-NUMBERUniqueSectionCodeMST.SC + "_" + MST.SEMaster ScheduleSectionY
   E1362POPULATION-SERVEDPopulationServedMST.PSVMaster SchedulePopulation ServedY
   **
   CourseOfferingReferenceTypeCourseOfferingReference


Y
      **      CourseOfferingIdentityTypeCourseOfferingIdentity



Y
         E1194LOCAL-COURSE-CODELocalCourseCodeCRS.CNCourseCrsID#Y
         E1503COURSE-OFFERING-TERMTermCRS.TM
CoursesTermY
         E1498COURSE-OFFERING-SCHOOL-YEARSchoolYearCalculated from current database year

Y
         E0266CAMPUS-IDStateOrganizationIdLOC.SCSchool OptionsCampusY
   **   EducationalOrgReferenceTypeSchoolReference


Y
      **      EducationalOrgIdentityTypeEducationalOrgIdentity


Y
      E0266CAMPUS-IDStateOrganizationIdLOC.SCSchool OptionsCampusY
   **   LocationReferenceTypeLocationReference


Y
      **      LocationIdentityType
LocationIdentity


Y
         E1292CLASSROOM-IDENTIFICATION-CODEClassroomIdentificationCodeMST.SC + MST.RMMaster ScheduleRoomY
   **   ClassPeriodReferenceType
ClassPeriodReference


Y
      **      ClassPeriodIdentityTypeClassPeriodIdentity


Y
         E1074CLASS-PERIODClassPeriodNameMST.PDMaster SchedulePeriodY
         E0266CAMPUS-IDStateOrganizationIdLOC.SCSchool OptionsCampusY
SectionExtension
E0948COURSE-SEQUENCE-CODETX-CourseSequenceCRS.CSQCoursesCrs SeqY
E1072NON-CAMPUS-BASED-INSTRUCTION-CODETX-NonCampusBasedInstructionCRS.NCICourses > Other tabNon-Campus InstY



InterchangeStudentParentExtension

StudentExtension

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



Y
   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
   E1325SEXSexSTU.GNDemographicsGenderY
   **   BirthDataBirthData


Y
     E0006DATE-OF-BIRTHBirthDateSTU.BDDemographicsBirthdateY
   E1375HISPANIC-LATINO-ETHNICITYHispanicLatinoEthnicitySTU.ETHDemographicsEthnicityY
   **   RaceTypeRace


Y
      E1343RACIAL-CATEGORYRacialCategorySTU.RC1 - STU.RC5DemographicsRaceY
StudentExtension
**EducationalOrgReferenceTypeTX-LEAReference


Y
   **   EducationalOrgIdentityTypeEducationalOrgIdentity


Y
      E0212DISTRICT-IDStateOrganizationIdLOC.CC + LOC.DCSchool OptionsCounty + DistrictY



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
   E1517ENTRY-GRADE-LEVEL-TYPEEntryGradeLevelENR.GREnrollment HistoryGrdY
StudentSchoolAssociationExtension


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-DATEBeginDateSSE.SD if using Section Staff (if un-populated then first day in Calendar); else CAR.DS
Master Schedule; Course Attendance
Start DateY
E1070STUDENT-END-DATEEndDateSSE.ED if using Section Staff (if un-populated then last day in Calendar); else CAR.DEMaster Schedule; Course AttendanceEnd Date; Stop DateY
E0948COURSE-SEQUENCE-CODETX-CourseSequenceCRS.CSQCoursesCrs Seq
Y



InterchangeStaffAssociationExtension

StaffExtension

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


Y
   E1524TX-UNIQUE-STAFF-IDStaffUniqueStateIdSTF.SIDStaffUnique IDY
   **StaffIdentificationCodeStaffIdentificationCode


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

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


Y
      E0703FIRST-NAMEFirstNameSTF.FNStaffFirst NameY
      E0704MIDDLE-NAMEMiddleNameSTF.MNStaffMiddle NameY
      E0705LAST-NAMELastSurnameSTF.LNStaff
Last NameY
      E1303GENERATION-CODE-SUFFIXGenerationCodeSuffixSTF.SFStaffSuffix
Y
   E1325SEXSexSTF.SXStaffGenderY
   E0006DATE-OF-BIRTHBirthDateSTF.BDStaffBirthdateY
   E1375HISPANIC-LATINO-ETHNICITYHispanicLatinoEthnicitySTF.ETHStaffEthnicityY
   **RaceTypeRace


Y
      E1343RACIAL-CATEGORYRacialCategorySTF.RC1 - STF.RC5StaffRace - Race 5Y
   E1460HIGHEST-LEVEL-OF-EDUCATION-COMPLETEDHighestLevelOfEducationCompletedSTF.ELStaffEducationLevelY
StaffExtension
**
EducationalOrgReferenceTypeTX-LEAReference


Y
   **   EducationalOrgIdentityTypeEducationalOrgIdentity


Y
      E0212DISTRICT-IDStateOrganizationIdLOC.CC + LOC.DCSchool OptionsCounty + DistrictY
E1073STAFF-TYPE-CODETX-StaffTypeCodeSTF.TYStaff
Y


TeacherSectionAssociationExtension

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


Y
      **      StaffIdentityTypeStaffIdentity


Y
         E1524TX-UNIQUE-STAFF-IDStaffUniqueStateIdSTF.SIDStaffUnique IDY
   **   SectionReferenceTypeSectionReference


Y
      **      SectionIdentityTypeSectionIdentity


Y
         E0266CAMPUS-IDStateOrganizationIdLOC.SCSchool OptionsCampusY
         E1056CLASS-ID-NUMBERUniqueSectionCodeMST.SC + "_" + MST.SE
Master ScheduleSectionY
   E1454
CLASSROOM-POSITIONClassroomPositionSSE.TP if using Section Staff (SSE); MST.TP1 if using TCH table
Master Schedule
PositionY
   E1065ASSIGNMENT-BEGIN-DATEBeginDateSSE.SD if using Section Staff; CAR.DS if using TCH
Master Schedule; Course AttendanceStart DateY
   E1066ASSIGNMENT-END-DATEEndDateSSE.ED if using Section Staff; CAR.DE if using TCHMaster Schedule; Course AttendanceEnd Date; Stop DateY
TeacherSectionAssociationExtension
E0948
COURSE-SEQUENCE-CODETX-CourseSequenceCRS.CSQCoursesCrs SeqY
E0721ROLE-IDTX-StaffRole

SSE.SR if using Section Staff; else STJ.JC; "87" will be extracted for "Teacher"

Master Schedule; StaffStaff Role; Role DescriptionY