The following extensions are included in InterchangeMasterScheduleExtension:


CourseOffering

SectionExtension


Submissions:

(3) = Summer PEIMS (Submission 3)

(4) = Extended PEIMS (Submission 4)

(CR) = Class Roster - Fall & Winter

(ECDS-PK) = TSDS ECDS Prekindergarten

(ECDS-KG) = TSDS ECDS Kindergarten


* Aeries Table.Fields that have an asterisk must be mapped on Texas State Reporting > Code Translations.


CourseOffering

SubmissionElement ID
(Code Table)
Data ElementAeries Table.FieldAeries PageLabel
(3) (4)
(CR)
(ECDS-PK)
(ECDS-KG)
CourseOffering id

LOC.SCSchool OptionsCampus
MST.CNMaster ScheduleCourse
MST.SESection
 <CourseOffering id="CourseOffering_SSS_NNNN_XXXX">
 </CourseOffering>

where:

  • SSS = LOC.SC
  • NNNN = MST.CN
  • XXXX = MST.SE
(CR)
(ECDS-PK)
(ECDS-KG)
E1194

LOCAL-COURSE-CODECRS.CNCoursesCrsID#

<CourseOffering id="CourseOffering_SSS_NNNN_XXXX">

<LocalCourseCode>NNNN</LocalCourseCode>

</CourseOffering>


where NNNN = CRS.CN

  • DR1: LOCAL-COURSE-CODE must be provided for non-PEIMS reporting.
(3) (4)
(CR)
(ECDS-PK)
(ECDS-KG)
E0266

CAMPUS-IDLOC.CC + LOC.DC + LOC.SCSchool OptionsCounty + District + Campus
<CourseOffering id="CourseOffering_SSS_NNNN_XXXX">
<SchoolReference>
<EducationalOrgIdentity>
<StateOrganizationId>CCCDDDSSS</StateOrganizationId>
</EducationalOrgIdentity>
</SchoolReference>
</CourseOffering>

where:
  • CCC = LOC.CC
  • DDD = LOC.DC
  • SSS = LOC.SC
(3) (4)
E1089 (DC036) 

COURSE-IDENTIFICATION-SYSTEM"State course code"
<CourseOffering id="CourseOffering_SSS_NNNN_XXXX">
<CourseReference>
<CourseIdentity>
<CourseCode IdentificationSystem="State course code">
<ID>XXXXXXXX</ID>
</CourseCode>
</CourseIdentity>
</CourseReference>
</CourseOffering>
(3) (4)
E0724 (C022)

SERVICE-IDCRS.SVCCourses > OtherService ID
CRS.TY = R (Summer school course) (Submission 4 only)
Type
CRS.CSQ = D0-D9 (Part of a dual credit course) (Submission 4 only)
Crs Seq
CRS.CL - 24 (Dual Credit) (Submission 4 only)
Crs Lvl
CRS.PSV = 05 (CTE students) (Submission 4 only)
Population Served
HIS.MK <> blank (Submission 4 only)
TranscriptsMark
<CourseOffering id="CourseOffering_SSS_NNNN_XXXX">
<CourseReference>
<CourseIdentity>
<CourseCode IdentificationSystem="State course code">
<ID>UUUUUUUU</ID>
</CourseCode>

</CourseIdentity>
</CourseReference>
</CourseOffering>

where UUUUUUUU = CRS.SVC
Service IDs that begin with SA, SE, SR, SS, or 8 (i.e., local service IDs) are not extracted.

  • (4) For Submission 4 a course is extracted when HIS.MK is not blank, and CRS.TYP = R, and one of the following:
    • Course is dual credit (CRS.CSQ=D0-D9 and CRS.CL=24)
    • College Prep Language Arts/Math (CRS.SVC = CP110100 or CP111200)
    • Course is CTE (CRS.PSV = 05)
Rules (FATAL):
  • 50300-0006/43415-0028: If SERVICE-ID is a high school course, then COURSE-SEQUENCE-CODE must not be A.
  • 50300-0004: SERVICE-ID must not begin with SA, SE, SR, SS, or 8.
(CR)
(ECDS-PK)

(ECDS-KG)
E1089 (DC036)

COURSE-IDENTIFICATION-SYSTEM"LEA course Code"

<CourseOffering id="CourseOffering_SSS_NNNN_XXXX">

<CourseReference>

<CourseIdentity>

<CourseCode IdentificationSystem="LEA course code">

<ID>CCCC</ID>

</CourseCode>

</CourseIdentity>

</CourseReference>

</CourseOffering>

  • DR2: When submitting the COURSE-IDENTIFICATION-SYSTEM data element for LOCAL-COURSE-CODE, this value will be "LEA course code".
  • DR2: LOCAL-COURSE-CODE must be provided for non-PEIMS reporting.
(CR)
(ECDS-PK)

(ECDS-KG)
E1194

LOCAL-COURSE-CODECRS.CNCoursesCrsId#

<CourseOffering id="CourseOffering_SSS_NNNN_XXXX">

<CourseReference>

<CourseIdentity>

<CourseCode IdentificationSystem="LEA course code">

<ID>CCCC</ID>

</CourseCode>

</CourseIdentity>

</CourseReference>

</CourseOffering>


where CCCC = CRS.CN

Additional Rules:

  • (3) (4) 10050-000A: The combination of the following fields must be unique for each CourseOffering: CAMPUS-ID and SERVICE-ID.
  • (TSDS) 10050-000B: For TSDS submissions, the combination of the following must be unique for each CourseOffering: SchoolReference and CourseReference.
  • (3) (4) 10050-000E: For a CourseOffering, the following must be provided: id, CAMPUS-ID, COURSE-IDENTIFICATION-SYSTEM, and SERVICE-ID.

SectionExtension

SubmissionElement ID
(Code Table)
Data ElementAeries Table.FieldAeries PageLabel
(3) (4)
(CR)
(ECDS-PK)
(ECDS-KG)
E1056

CLASS-ID-NUMBERLOC.CD School OptionsCode
MST.SEMaster ScheduleSection

<Section>

<UniqueSectionCode>CCCCCCCCCC_SSSS</UniqueSectionCode>

</Section>


where:
  • CCCCCCCCCC = LOC.CD (zero padded)
  • SSSS = MST.SE
Rule (FATAL): 
  • 40110-0180: For each StudentSectionAssociation, there must be a corresponding Course Section where CLASS-ID-NUMBER is the same.
(CR)
E1362 (DC091)

POPULATION-SERVED
MST.PSV
or
Master Schedule orPopulation Served
CRS.PSV
Courses > OtherPopulation Served

<Section>

<TX-PopulationServed>Description</TX-PopulationServed>

 </Section>


where Description = MST.PSV if populated; otherwise CRS.PSV if populated; otherwise blank

Full DC091 Code Translation is used rather than code.

Rule (FATAL):
  • (CR) 10050-0003: For a Course Section being reported for the Class Roster collection, POPULATION-SERVED must not be blank.
(3) (4)
(CR)
(ECDS-PK)
(ECDS-KG)
CourseOfferingReference ref

LOC.SCSchool OptionsCampus
MST.CNMaster ScheduleCourse
MST.SESection
 <Section>
<CourseOfferingReference ref="CourseOffering_SSS_NNNN_XXXX" />
 </Section>

where:
  • SSS = LOC.SC (zero padded)
  • NNNN = MST.CN
  • XXXX = MST.SE

Service IDs that begin with SA, SE, SR, SS, or 8 (i.e., local service IDs) are not extracted.

(3) (4)
(CR)
(ECDS-PK)
(ECDS-KG)
E0266

CAMPUS-IDLOC.CC + LOC.DC + LOC.SCSchool OptionsCounty + District + Campus
<Section>
<SchoolReference>
<EducationalOrgIdentity>
<StateOrganizationId>CCCDDDSSS</StateOrganizationId>
</EducationalOrgIdentity>
</SchoolReference>
</Section>

where:
  • CCC = LOC.CC
  • DDD = LOC.DC
  • SSS = LOC.SC
Rule (FATAL): 
  • 40110-0180: For each StudentSectionAssociation, there must be a corresponding Course Section where CAMPUS-ID is the same.
Special Warnings:
  • (TSDS) 10020-0022: For each campus registered with TEA as an active instructional campus, there should be at least one Course SectionExtension with a matching CAMPUS-ID.
  • (3)10020-0065: For Submission 3, for each campus registered with TEA as an active instructional campus serving any of the grade levels 09-12, or TxVSN campuses 236902048 or 236902108, there should be at least one Course SectionExtension with a matching CAMPUS-ID.
(3)
(CR)
(ECDS-PK)
(ECDS-KG)
E1074

CLASS-PERIOD

Non-Flex:

MST.PD

Master SchedulePeriod
Flex:
MST.FSQ
Flex Period

Flex:

FTF.TT, or

Flex PeriodsTiny Title
FTF.STIShort Title
<Section>
<ClassPeriodReference>
<ClassPeriodIdentity>
<ClassPeriodName>XX</ClassPeriodName>
</ClassPeriodIdentity>
</ClassPeriodReference>
 </Section>

where XX =
  • Non-flex schools: MST.PD 
  • Flex schools: FTF.TT if populated; otherwise first two characters of FTF.STI (zero padded)
For sections that span multiple periods, only the first period of the range is extracted.
(3)
(CR)
(ECDS-PK)
(ECDS-KG)
E0266

CAMPUS-IDLOC.CC + LOC.DC + LOC.SCSchool OptionsCounty + District + Campus
 <Section>
<ClassPeriodReference>
<ClassPeriodIdentity>
<StateOrganizationId>CCCDDDSSS</StateOrganizationId>
</ClassPeriodIdentity>
</ClassPeriodReference>
 </Section>

where:
  • CCC = LOC.CC
  • DDD = LOC.DC
  • SSS = LOC.SC
(3) (4)
E1093 (C193)

SCHOOL-YEARCalculated from current database year

<Section>

<TX-SchoolYear>YYYY-YYYY</TX-SchoolYear>

</Section>


where YYYY-YYYY is the beginning and ending years of the current school year
(3)
E0747 (C030)

POPULATION-SERVED-CODEMST.PSV orMaster Schedule orPopulation Served
CRS.PSVCourses > OtherPopulation Served
 <Section>
<TX-PopulationServed>XX</TX-PopulationServed>
 </Section>

where XX = MST.PSV if populated; otherwise CRS.PSV if populated; otherwise blank
NOTE: Blank will generate a validation error.
Special Warning:
  • (3) 50300-0012: For this Course SectionExtension, if the Course is for SERVICE-ID 127XXXXX, 130XXXXX, N127XXXX, or N130XXXX, then POPULATION-SERVED-CODE should be 05 or 06.
(3) (4)
(CR)
(ECDS-PK)
(ECDS-KG)
E0948 (C135)

COURSE-SEQUENCE-CODECRS.CSQCourses > OtherCrs Seq
<Section>
<TX-CourseSequence>XX</TX-CourseSequence>
</Section>

where XX = CRS.CSQ
Rules (FATAL):
  • 40110-0180: For each StudentSectionAssociation, there must be a corresponding Course Section where COURSE-SEQUENCE-CODE is the same.
  • 50300-0006/43415-0028: If SERVICE-ID is a high school course, then COURSE-SEQUENCE-CODE must not be A.
(3)
(CR)
E1072 (C182)

NON-CAMPUS-BASED-INSTRUCTION-CODEMST.NCIMaster ScheduleNon-Campus Inst
CRS.NCI *
Course > Other
Non-Campus Inst
 <Section>
<TX-NonCampusBasedInstruction>XX</TX-NonCampusBasedInstruction>
 </Section>

where XX = MST.NCI if populated; otherwise CRS.NCI if populated; otherwise blank
Rules (FATAL):
  • (CR) 10050-0003: For a Course Section being reported for the Class Roster collection, NON-CAMPUS-BASED-INSTRUCTION-CODE must not be blank.
  • (3) 42500-0046: If FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE is 6, there must be at least one StudentSectionAssociation with a matching TX-UNIQUE-STUDENT-ID for a Course SectionExtension with NON-CAMPUS-BASED-INSTRUCTION-CODE of 11.
  • (3) 43415-0055: If NON-CAMPUS-BASED-INSTRUCTION-CODE is 08, then STUDENT-END-DATE must equal STUDENT-BEGIN-DATE on the corresponding StudentSectionAssociation.
  • (3) 50300-0007: If NON-CAMPUS-BASED-INSTRUCTION-CODE is 10 (i.e., non-district PE substitution program), then SERVICE-ID must be PES00008-PES00011 (i.e., a PE substitution non-district program).
  • (3) 50300-0008: If NON-CAMPUS-BASED-INSTRUCTION-CODE is 09 (i.e., out of district DAEP program), then CAMPUS-ID must be registered with TEA as a DAEP campus type.
  • (3) 50300-0010: If CAMPUS-ID is 019907006, 072801145, 101912100, 102904010, 220906007, 221801022, 236902008, 236902048, or 236902108 (i.e., a TxVSN Online Schools campus), then NON-CAMPUS-BASED-INSTRUCTION-CODE must be 04 (i.e., TxVSN Online Schools Program).
  • (3) 50300-0014: If NON-CAMPUS-BASED-INSTRUCTION-CODE is 04 (i.e., TxVSN Online Schools Program), then CAMPUS-ID must be 019907006, 072801145, 101912100, 102904010, 220906007, 221801022, 236902008, 236902048, or 236902108 (i.e., a TxVSN Online Schools campus).

Special Warnings:

  • (3) 40110-0161: If COURSE-COMPLETION-INDICATOR is 1 on a StudentSectionAssociation, and NON-CAMPUS-BASED-INSTRUCTION-CODE on the corresponding Course SectionExtension is not 08, then STUDENT-END-DATE should be greater than STUDENT-BEGIN-DATE.
  • (3) 50300-0009: If SERVICE-ID is a CTE course (CTE Course = H or M in code table C022), then NON-CAMPUS-BASED-INSTRUCTION-CODE should be 00.
(ECDS-PK)
E1579 (C206)

PK-CURRICULAMST.CTMaster SchedulePK Curricula
ECD.CT
Early Childhood DevelopmentCurriculum

<Section>

<TX-PKCurricula>XX</TX-PKCurricula>

</Section>


where XX= MST.CT or EDC.CT
Rule (FATAL):
  • 10050-0002: If SERVICE-ID is 01010000, then PK-CURRICULA must not be blank.
(ECDS-PK)
E1580 (C088)

HIGH-QUALITY-PK-PROGRAM-INDICATORMST.HQP
Master ScheduleHigh Quality PK Program

<Section>

<TX-HighQualityPrekProgramIndicator>0/1</TX-HighQualityPrekProgramIndicator>

</Section>


where 0/1 = 1 if MST.HQP is selected; otherwise 0
Rules (FATAL):
  • 10050-0002: If SERVICE-ID is 01010000, then HIGH-QUALITY-PK-PROGRAM-INDICATOR must not be blank.
  • 30040-0057: If PK-TEACHER-REQUIREMENT is not blank, this staff person should have a TeacherSectionAssociation with a CLASSROOM-POSITION of "Teacher of Record" for a Course Section where HIGH-QUALITY-PK-PROGRAM-INDICATOR is 1.
(ECDS-PK) E1558 (DC153)

STUDENT-INSTRUCTIONMST.SIT
Master ScheduleInstruction Type
ECD.SIT
Early Childhood DevelopmentInstruction Type

<Section>

<TX-StudentInstruction>Description</TX-StudentInstruction>

</Section>


where Description = MST.SIT or ECD
Full DC153 Code Translation is used rather than code.
Rules (FATAL):
  • 10050-0002: If SERVICE-ID is 01010000, then STUDENT-INSTRUCTION must not be blank.
  • 40110-0133: If the last three digits of DISTRICT-ID are 960 (Private PK data), then STUDENT-INSTRUCTION must not be blank. 
(ECDS-PK)
E1555 (DC152)

PK-SCHOOL-TYPEMST.PKT * or

Master Schedule

PK Schl Type
LOC.PKT *School OptionsPK School Type
ECD.PKTEarly Childhood Development
PK School Type

<Section>

<TX-PKSchoolType>Description</TX-PKSchoolType>

</Section>


where Description is MST.PKT if present; otherwise LOC.PKT * if present; otherwise ECD.PKT
Full DC152 Code Translation is used rather than code.
Rules (FATAL):
  • 10050-0002: If SERVICE-ID is 01010000, then PK-SCHOOL-TYPE must not be blank.
  • 40110-0133: If the last three digits of DISTRICT-ID are "960" (Private PK data), then the following field must not be blank: PK-SCHOOL-TYPE.

Special Warning:

  • 10050-0004 : For a Course Section being reported for the ECDS PK submission, if PK-SCHOOL-TYPE is "Public Pre-K Licensed Child Care", "Public Pre-K Head Start", or "In-District Charter Partnership", then the Local Education Agency should be reported with at least one CHILD-CARE-OPERATION-NUMBER.
(ECDS-PK) E1626 (C216)

PROGRAM-EVALUATION-TYPEMST.ET * Master ScheduleEvaluation Type
ECD.ET
Early Childhood DevelopmentEvaluation Type

<Section>

<TX-ProgramEvaluationType>XX</TX-ProgramEvaluationType>

</Section>


where XX = MST.ET
Rule (FATAL):
  • 10050-0002: If SERVICE-ID is 01010000, then PROGRAM-EVALUATION-TYPE must not be blank.

Additional Rules:

  • 10050-000C/50300-000A: For ECDS- KG: The combination of the following fields must be unique for each Course Section: CLASS-ID-NUMBER, CAMPUS-ID, and COURSE-SEQUENCE-CODE.
  • (CR) 30305-0001: For each TeacherSectionAssociation, there must be a Course SectionExtension with a matching CAMPUS-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE. 
  • (ECDS-KG) 30305-0019: For ECDS - KG, for a given Course Section, if the Course is for a Kindergarten SERVICE-ID, there should be at least one TeacherSectionAssociation with CLASSROOM-POSITION of "Teacher of Record".
  • 40110-0180: For each StudentSectionAssociation, there must be a corresponding Course Section where CAMPUS-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE are the same. 
  • (4) 43415-000D/50300-000A/10050-000C: The combination of the following fields must be unique for each Course SectionExtension: CLASS-ID-NUMBER, CAMPUS-ID, and COURSE-SEQUENCE-CODE.
  • (3) 43415-000E/50300-000B/10050-000F: For a Course SectionExtension, the following must be provided: CLASS-ID-NUMBER, CourseOfferingReference, CAMPUS-ID (SchoolReference), CLASS-PERIOD, CAMPUS-ID (ClassPeriodReference), SCHOOL-YEAR, POPULATION-SERVED-CODE, COURSE-SEQUENCE-CODE, and NON-CAMPUS-BASED-INSTRUCTION-CODE.
  • (3) (4) 43415-0008: For each CourseTranscript, there must be a corresponding Course SectionExtension where CAMPUS-ID-OF-ENROLLMENT matches CAMPUS-ID, and SERVICE-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE are the same.
  • 50300-0002: For each Course SectionExtension, there should be a corresponding StudentSectionAssociation where CAMPUS-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE are the same.
  • 40110-0180: For each StudentSectionAssociation, there must be a corresponding Course SectionExtension where CAMPUS-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE are the same.
  • (4) 43415-000F/50300-000C/10050-000G: For a Course Section, the following must be provided: CLASS-ID-NUMBER, CourseOfferingReference, CAMPUS-ID, SCHOOL-YEAR and COURSE-SEQUENCE-CODE.
  • (3) (4) For a Course Section, the following must be provided: CLASS-ID-NUMBER, CourseOfferingReference, CAMPUS-ID (SchoolReference), SCHOOL-YEAR and COURSE-SEQUENCE-CODE.
  • (ECDS) GR1: For the ECDS collection, each campus that enrolls and serves KG students must report at least one SectionExtension Complex Type for every KG course taught. Course sections for students in grade level EE are not reported. LEAs must begin tracking the course sections for reporting purposes as of the first day of school.
  • (CR) GR1: For the Class Roster collection, each SectionExtension complex type should have at least one corresponding TeacherSectionAssociationExtension Complex Type for the teacher and a corresponding StudentSectionAssociation Complex Type for each student assigned to that course.