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) ref


Y
   **   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" for E0724; "LEA Course Code" for E1194

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
         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
   **
   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
         E0266CAMPUS-IDStateOrganizationIdLOC.SCSchool OptionsCampusY
   **   ClassPeriodReferenceType
ClassPeriodReference


Y
      **      ClassPeriodIdentityTypeClassPeriodIdentity


Y
         E1074CLASS-PERIODClassPeriodNameMST.PDMaster SchedulePeriodY
         E0266CAMPUS-IDStateOrganizationIdLOC.SCSchool OptionsCampusY
SectionExtension
E0948COURSE-SEQUENCE-CODETX-CourseSequenceCRS.CSQCoursesCrs SeqY



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
   **   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
   E1390LIMITED-ENGLISH-PROFICIENCYLimitedEnglishProficiency
STU.LFDemographicsLangFluY
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-DATEBeginDateCAR.DS
Course Attendance
Start DateY
E1070STUDENT-END-DATEEndDateCAR.DECourse AttendanceStop DateY
E1440HOME-ROOM-INDICATORHomeroomIndicatorLOC.J / DAY.PDSchool Options / CalendarAttendance PeriodY
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
      E0705LAST-NAMELastSurnameSTF.LNStaff
Last NameY
StaffExtension
**
EducationalOrgReferenceTypeTX-LEAReference


Y
   **   EducationalOrgIdentityTypeEducationalOrgIdentity


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


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-POSITIONClassroomPositionMST.TP1
Master Schedule
PositionY
   E1065ASSIGNMENT-BEGIN-DATEBeginDateCAR.DS
Course AttendanceStart DateY
   E1066ASSIGNMENT-END-DATEEndDateCAR.DECourse AttendanceStop DateY
TeacherSectionAssociationExtension
E0948
COURSE-SEQUENCE-TYPETX-CourseSequenceCRS.CSQCoursesCrs SeqY