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
E1583FAMILY-ENGAGEMENT-PLAN-LINKTX-FamilyEngagementPlanLinkDPT.CD when DPT.NM = TX-FamilyEngagementPlanLink


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


Location

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


E1292CLASSROOM-IDENTIFICATION-CODEClassroomIdentificationCodeMST.SC + MST.RMMaster ScheduleRoom


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
E1182LOCAL-COURSE-TITLECourseTitleCRS.COCoursesTitle
E1183NUMBER-OF-PARTSNumberOfParts"1"

**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#
**CourseLevelCharacteristicsTypeCourseLevelCharacteristics


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


   **   Reference Type
(a) ref



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
**SessionReferenceTypeSessionReference


   **   SessionIdentityTypeSessionIdentity


      E0266CAMPUS-IDStateOrganizationIdLOC.SCSchool OptionsCampus
      E1093SCHOOL-YEARSchoolYearCalculated from current database year


      E1370SESSION-TERMTermMST.TMMaster ScheduleSem
**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
   **
   CourseOfferingReferenceTypeCourseOfferingReference


      **      CourseOfferingIdentityTypeCourseOfferingIdentity



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

         E0266CAMPUS-IDStateOrganizationIdLOC.SCSchool OptionsCampus
   **   EducationalOrgReferenceTypeSchoolReference


      **      EducationalOrgIdentityTypeEducationalOrgIdentity


      E0266CAMPUS-IDStateOrganizationIdLOC.SCSchool OptionsCampus
   **   LocationReferenceTypeLocationReference


      **      LocationIdentityType
LocationIdentity


         E1292CLASSROOM-IDENTIFICATION-CODEClassroomIdentificationCodeMST.SC + MST.RMMaster ScheduleRoom
         E0266CAMPUS-IDStateOrganizationId


   **   ClassPeriodReferenceType
ClassPeriodReference


      **      ClassPeriodIdentityTypeClassPeriodIdentity


         E1074CLASS-PERIODClassPeriodNameMST.PDMaster SchedulePeriod
         E0266CAMPUS-IDStateOrganizationIdLOC.SCSchool OptionsCampus
SectionExtension
E0948COURSE-SEQUENCE-CODETX-CourseSequenceCRS.CSQCoursesCrs Seq
E1579PK-CURRICULATX-PKCurriculaECD.CTEarly Childhood DevelopmentCurriculum
E1580HIGH-QUALITY-PK-PROGRAM-INDICATORTX-HighQualityPrekProgramIndicatorMST.HQP
Master ScheduleHigh Quality PK Program
E1558STUDENT-INSTRUCTIONTX-StudentInstructionECD.SIT
Early Childhood DevelopmentInstruction Type
E1555PK-SCHOOL-TYPETX-PKSchoolTypeLOC.PKT; overridden by MST.PKT
School Options; Master SchedulePK School Type; PK Schl Type
E1626PROGRAM-EVALUATION-TYPETX-ProgramEvaluationTypeMST.ETMaster ScheduleEvaluation Type



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
   E1387ECONOMIC-DISADVANTAGEEconomicDisadvantagedFRE.CDFree and ReducedNSLP Lunch Type Code
   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
E1078PK-PROGRAM-TYPE-CODETX-PKProgramTypeIndicatorECD.PTCEarly Childhood DevelopmentProgram Type
E1079PRIMARY-PK-FUNDING-SOURCETX-PrimaryPKFundingSourceECD.FT1Early Childhood DevelopmentPrimary Funding Type
E1080SECONDARY-PK-FUNDING-SOURCETX-SecondaryPKFundingSourceECD.FT2Early Childhood DevelopmentSecondary Funding Type


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 = 01010000. If student has multiple sections with CRS.SVC = 01010000, 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


InterchangeStudentProgramExtension

StudentProgramExtension

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


   **   StudentIdentityTypeStudentIdentity


   E1523TX-UNIQUE-STUDENT-IDStudentUniqueStateIdSTU.CIDDemographics > Student Data 2Unique ID
**ProgramReferenceType
ProgramReference


   **
   ProgramIdentityTypeProgramIdentity


      E1337PROGRAM-TYPEProgramTypePGM.CDSpecial ProgramsProgram Code
      E0266
CAMPUS-IDStateOrganizationIdLOC.CC + LOC.DC + LOC.SCSchool OptionsCounty + District + Campus
      E0212DISTRICT-IDStateOrganizationIdLOC.CC + LOC.DC
School OptionsCounty + District
**
EducationalOrgReferenceTypeEducationOrganizationReference



   **   EducationalOrgIdentityTypeEducationalOrgIdentity


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