The purpose of the Texas Early Childhood Data System (ECDS) submission is to report data that schools and parents can use to evaluate the preparation success of KG and PK students and compare results within region.


The reporting of KG program data for ECDS is mandatory for all public school districts and open-enrollment charter schools that administer the commissioner-approved TX-KEA or the identified alternate assessment. The data collection includes student demographics, classroom link information, special program data, and assessment data. LEAs must report assessment results to TEA for the Beginning of Year (BOY) administration. 


InterchangeEducationOrganizationExtension

InterchangeMasterScheduleExtension

InterchangeStudentParentExtension

InterchangeStudentEnrollmentExtension

InterchangeStaffAssociationExtension


NOTE:

AssessmentMetadata and StudentAssessment interchanges are supplied by the assessment vendor.


InterchangeEducationOrganizationExtension

LocalEducationAgencyExtension

Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
LocalEducationAgencyidLOC.CC + LOC.DCSchool OptionsCounty + District

<LocalEducationAgency id="LEA_CCCDDD">

</LocalEducationAgency>


where:
  • CCC = LOC.CC 
  • DDD = LOC.DC
E0212DISTRICT-IDStateOrganizationIdLOC.CC + LOC.DCSchool OptionsCounty + District

<LocalEducationAgency id="LEA_CCCDDD">

<StateOrganizationId>CCCDDD</StateOrganizationId>

</LocalEducationAgency>


where:
  • CCC = LOC.CC 
  • DDD = LOC.DC
Rule (FATAL):
  • 10010-000ADISTRICT-ID must be unique for each LEA.


SchoolExtension

  • 10020-0039: Excluding DAEPs and JJAEPs, for each campus registered with the TEA in the current school year as an active instructional campus that offers GRADE-LEVEL-CODE "KG", if at least one student is reported at that campus, then Campus data must be reported.
Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
SchoolidLOC.SCSchool OptionsCampus

<School id="SCH_SSS">

</School>


where: SSS = LOC.SC

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

<School id="SCH_SSS">

<StateOrganizationId>CCCDDDSSS</StateOrganizationId>

</School>


where:

  • CCC = LOC.CC 
  • DDD = LOC.DC 
  • SSS = LOC.SC
Rule (FATAL):
  • 10020-000ACAMPUS-ID must be unique for each campus.
LocalEducationAgencyReferencerefLOC.CC + LOC.DCSchool OptionsCounty + District
<School id="SCH_SSS">

<LocalEducationAgencyReference ref="LEA_CCCDDD"/>

</School>


where:

  • CCC = LOC.CC
  • DDD = LOC.DC
ClassPeriodReferencerefNon-flex:
MST.PD
Master SchedulePeriod
Flex: 
FTF.TT, or
Flex PeriodsTiny Title
FTF.STIShort Title
<School id="SCH_SSS">

<ClassPeriodReference ref="CP_SSS_nn" />

<ClassPeriodReference ref="CP_SSS_nn" />

<ClassPeriodReference ref="CP_SSS_nn" />

</School>


where:

  • SSS = hard coded school code
  • Non-flex schools: nn = MST.PD 
  • Flex schools: nn = FTF.TT if populated; otherwise first two characters of FTF.STI 


ClassPeriod

  • One complex type for each period offered at the school
Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
ClassPeriodidNon-flex:
MST.PD
Master SchedulePeriod
Flex: 
FTF.TT, or
Flex PeriodsTiny Title
FTF.STIShort Title
<ClassPeriod id="CP_SSS_nn">

</ClassPeriod>


where:

  • SSS = hard coded school code
  • Non-flex schools: nn = MST.PD 
  • Flex schools: nn = FTF.TT if populated; otherwise first two characters of FTF.STI
E1074CLASS-PERIODClassPeriodNameNon-flex:
MST.PD
Master SchedulePeriod
Flex: 
FTF.TT, or 
Flex PeriodsTiny Title
FTF.STIShort Title
<ClassPeriod id="CP_SSS_n">
<ClassPeriodName>NN</ClassPeriodName>

</ClassPeriod>


where N =

  • Non-flex schools: MST.PD 
  • Flex schools: FTF.TT if populated; otherwise first two characters of FTF.STI (zero padded)
  • GR1: The value for CLASS-PERIOD is a required field.
  • DR1: The value reported for CLASS-PERIOD may consist of any combination of letters (A-Z) and/or numbers (0-9). 


Course

  • GR1: Do not include course information for prior year courses.
Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
E1089 (DC036)COURSE-IDENTIFICATION-SYSTEMCourseCode IdentificationSystem"State course code"

<Course>

<CourseCode IdentificationSystem="State course code">

<ID>XXXXXXXXX</ID>

</CourseCode>

</Course>

  • GR1: For TSDS reporting, when reporting a SERVICE-ID, the IdentificationSystem should be "State course code".
E0724 (C022)
SERVICE-IDIDCRS.SVC
CoursesService ID

<Course>

<CourseCode IdentificationSystem="State course code">

<ID>XXXXXXXXX</ID>

</CourseCode>

</Course>


where XXXXXXXXX = CRS.SVC and SSS = LOC.SC
E1089 (DC036)COURSE-IDENTIFICATION-SYSTEMCourseCode IdentificationSystem"LEA course code"
<Course>

<CourseCode IdentificationSystem="LEA course code">

<ID>XXXXX</ID>

</CourseCode>

</Course>

  • GR1: For TSDS reporting, when reporting a LOCAL-COURSE-CODE, the IdentificationSystem should be "LEA course code". 
E1194LOCAL-COURSE-CODEIDCRS.CNCoursesCrsID#

<Course>

<CourseCode IdentificationSystem="LEA course code">

<ID>XXXXX</ID>

</CourseCode>

</Course>


where XXXXX = CRS.CN and SSS = LOC.SC
  • DR1: LOCAL-COURSE-CODE must be provided for non-PEIMS reporting.
EducationOrganizationReferencerefLOC.SCSchool OptionsCampus
<Course>

<EducationOrganizationReference ref="SCH_SSS"/>

</Course>


where SSS = LOC.SC


InterchangeMasterScheduleExtension

CourseOffering

  • 10050-000BThe combination of the following must be unique for each CourseOffering: SchoolReference and CourseReference.
Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
CourseOfferingidLOC.SC
School OptionsCampus
CRS.CNCoursesCrsID#



<CourseOffering id="CourseOffering_SSS_CCCC_XXXX">

<LocalCourseCode>CCCC</LocalCourseCode>

</CourseOffering>


where:

  • SSS = LOC.CD
  • CCCC = CRS.CN
  • XXXX = 
E1194LOCAL-COURSE-CODELocalCourseCodeCRS.CNCoursesCrsID#
<CourseOffering id="CourseOffering_SSS_CCCC_XXXX">

<LocalCourseCode>CCCC</LocalCourseCode>

</CourseOffering>


where CCCC = CRS.CN

E0266CAMPUS-IDStateOrganizationIdLOC.SCSchool OptionsCampus

<CourseOffering id="CourseOffering_SSS_CCCC_XXXX">

<SchoolReference>

<EducationalOrgIdentity>

<StateOrganizationId>CCCDDDSSS</StateOrganizationId>

</EducationalOrgIdentity>

</SchoolReference>

</CourseOffering>


where:
  • CCC = LOC.CC 
  • DDD = LOC.DC 
  • SSS = LOC.SC
E1089 (DC036)COURSE-IDENTIFICATION-SYSTEMCourseCode IdentificationSystem"LEA course Code"

<CourseOffering id="CourseOffering_SSS_CCCC_XXXX">

<CourseReference>

<CourseIdentity>

<CourseCode IdentificationSystem="LEA course code">

<ID>CCCC</ID>

</CourseCode>

</CourseIdentity>

</CourseReference>

  • 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.
E1194LOCAL-COURSE-CODEIDCRS.CNCoursesCrsId#

<CourseOffering id="CourseOffering_SSS_CCCC_XXXX">

<CourseReference>

<CourseIdentity>

<CourseCode IdentificationSystem="LEA course code">

<ID>CCCC</ID>

</CourseCode>

</CourseIdentity>

</CourseReference>


where CCCC = CRS.CN


SectionExtension

  • 10050-000C/50300-000AThe combination of the following fields must be unique for each Course Section: CLASS-ID-NUMBER, CAMPUS-ID, and COURSE-SEQUENCE-CODE.
  • 40110-0180For each StudentSectionAssociation, there must be a corresponding Course Section where CAMPUS-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE are the same.
  • 30305-0019For 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".
  • 50300-0002For each Course Section, there should be a corresponding StudentSectionAssociation where CAMPUS-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE are the same.
  • 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.
Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
E1056CLASS-ID-NUMBERUniqueSectionCodeLOC.CD School OptionsCode
MST.SEMaster ScheduleSection
<Section>

<UniqueSectionCode>CCCCCCCCCC_SSSS</UniqueSectionCode>

</Section>


where:
  • CCCCCCCCCC = LOC.CD (zero padded) 
  • XXXX = MST.SE
CourseOfferingReferenceref   
<Section>

<CourseOfferingReference ref="CourseOffering_SSS_CCCC_XXXX"/>

</Section>

E0266CAMPUS-IDStateOrganizationIdLOC.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
E1074CLASS-PERIODClassPeriodNameNon-Flex:
MST.PD
Master SchedulePeriod
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)
E0266CAMPUS-IDStateOrganizationIdLOC.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
E0948COURSE-SEQUENCE-CODETX-CourseSequenceCRS.CSQCoursesCrs Seq
<Section>

<TX-CourseSequence>X</TX-CourseSequence>

</Section>


where X = CRS.CSQ



InterchangeStudentParentExtension

StudentExtension

  • 40100-000AThe combination of the following fields must be unique for each student: DISTRICT-ID and TX-UNIQUE-STUDENT-ID.
  • 40100-0185For a student being reported for the ECDS collection, the following must not be blank: SEX, HISPANIC-LATINO-ETHNICITY, EMERGENT-BILINGUAL, and at least one RACIAL-CATEGORY.
Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
Studentid
LOC.CDSchool OptionsCode
STU.IDDemographicsStudent ID
<Student id="SCID_SSS_XXXXXX">

</Student>


where

  • SSS = LOC.CD
  • XXXXXX = STU.ID
E1523TX-UNIQUE-STUDENT-IDStudentUniqueStateIdSTU.CIDDemographics > Student Data 2Unique ID
<Student id="SCID_SSS_XXXXXX">

<StudentUniqueStateId>UUUUUUUUUU</StudentUniqueStateId>

</Student>


where UUUUUUUUUU = STU.CID

Rules (FATAL):
  • 40100-0099TX-UNIQUE-STUDENT-ID must match an entry in the TSDS Unique ID system.
  • 46010-0006If REPORT-ASSESSMENT-TYPE is ECDS-KG, there must be student data with a matching TX-UNIQUE-STUDENT-ID.
E1090STUDENT-IDENTIFICATION-SYSTEMStudentIdentificationCode IdentificationSystem"State"
<Student id="SCID_SSS_XXXXXX">

<StudentIdentificationCode IdentificationSystem="State">

<IdentificationCode>CCCCCCCCC</IdentificationCode>

</StudentIdentificationCode>

</Student>

E0001STUDENT-IDIdentificationCodeESD.EDDemographics > Student Data 2Soc-Sec-Num/S-Number
<Student id="SCID_SSS_XXXXXX">

<StudentIdentificationCode IdentificationSystem="State">

<IdentificationCode>CCCCCCCCC</IdentificationCode>

</StudentIdentificationCode>

</Student>


where CCCCCCCCC = ESC.ED

Rules (FATAL):
  • 40100-0101: For reporting student data, STUDENT-IDENTIFICATION-SYSTEM for STUDENT-ID must be "State".
  • 40100-0102: If STUDENT-IDENTIFICATION-SYSTEM is "State", the first character of STUDENT-ID must be S or 0-8.
  • 40100-0103: If STUDENT-IDENTIFICATION-SYSTEM is "State", each character of STUDENT-ID must not be the same number.
  • 40100-0104: If STUDENT-IDENTIFICATION-SYSTEM is "State", and the first character of STUDENT-ID is not S, the first three characters of STUDENT-ID must be between 001-899 (excluding 666).
  • 40100-0105: If STUDENT-IDENTIFICATION-SYSTEM is "State", and the first character of STUDENT-ID is not S, the fourth and fifth characters of STUDENT-ID must not be 00, and the last four characters of STUDENT-ID must not be 0000.
E1090 (DC126)STUDENT-IDENTIFICATION-SYSTEMStudentIdentificationCode IdentificationSystem"District"
<Student id="SCID_SSS_XXXXXX">

<StudentIdentificationCode IdentificationSystem="District">

<IdentificationCode>XXXXXX</IdentificationCode>

</StudentIdentificationCode>

</Student>

E0923
LOCAL-STUDENT-ID
IdentificationCodeSTU.IDDemographicsStudent ID
<Student id="SCID_SSS_XXXXXX">

<StudentIdentificationCode IdentificationSystem="District">

<IdentificationCode>XXXXXX</IdentificationCode>

</StudentIdentificationCode>

</Student>


where XXXXXX = STU.ID

E0703FIRST-NAMEFirstNameSTU.FNDemographicsFirst Name
<Student id="SCID_SSS_XXXXXX">

<Name>

<FirstName>First</FirstName>

</Name>

</Student>


where First = STU.FN

Special Warnings:
  • 40100-0079FIRST-NAME should not contain 0-9.
  • 40100-0080FIRST-NAME should not end with " JR", " SR", " I", " II", " III", " IV", " V", " VI", " VII", " VIII", " IX", or " X" (not case sensitive).
E0704MIDDLE-NAMEMiddleNameSTU.MNDemographicsMiddle Name
<Student id="SCID_SSS_XXXXXX">

<Name>

<MiddleName>Middle</MiddleName>

</Name>

</Student>


where Middle = STU.MN

Special Warnings:
  • 40100-0079MIDDLE-NAME should not contain 0-9.
  • 40100-0080MIDDLE-NAME should not end with " JR", " SR", " I", " II", " III", " IV", " V", " VI", " VII", " VIII", " IX", or " X" (not case sensitive).
E0705LAST-NAMELastSurnameSTU.LNDemographicsLast Name
<Student id="SCID_SSS_XXXXXX">

<Name>

<LastSurname>Last</LastSurname>

</Name>

</Student>


where Last = STU.LN

Special Warnings:
  • 40100-0079LAST-NAME should not contain 0-9.
  • 40100-0080LAST-NAME should not end with " JR", " SR", " I", " II", " III", " IV", " V", " VI", " VII", " VIII", " IX", or " X" (not case sensitive).
E1325 (DC119)SEXSexSTU.GNDemographicsGender
<Student id="SCID_SSS_XXXXXX">
<Sex>Gender</Sex>

</Student>


where Gender = STU.GN

Full DC119 Code Translation is used rather than code. 
E0006DATE-OF-BIRTHBirthDateSTU.BDDemographicsBirthdate
<Student id="SCID_SSS_XXXXXX">

<BirthData>

<BirthDate>YYYY-MM-DD</BirthDate>

</BirthData>

</Student>


where YYYY-MM-DD = STU.BD

Rule (FATAL):

  • 40100-0017DATE-OF-BIRTH must be a valid date.

Special Warning:

  • 40100-0173If the student assessment REPORT-ASSESSMENT-TYPE is ECDS-KG, the student's September 1 age should be at least 5.
E1375HISPANIC-LATINO-ETHNICITYHispanicLatinoEthnicitySTU.ETHDemographicsEthnicity
<Student id="SCID_SSS_XXXXXX">

<HispanicLatinoEthnicity>true/false</HispanicLatinoEthnicity>

</Student>


where true/false = true if STU.ETH = Y; otherwise false 

E1343 (DC097)RACIAL-CATEGORYRacialCategorySTU.RC1 * - STU.RC5DemographicsRace
<Student id="SCID_SSS_XXXXXX">

<Race>

<RacialCategory>Race</RacialCategory>

</Race>

</Student>


where Race = 

  • 'American Indian - Alaskan Native' if STU.RC1/RC2/RC3/RC4/RC5 = 01
  • 'Asian' if STU.RC1/RC2/RC3/RC4/RC5 = 02
  • 'Black - African American' if STU.RC1/RC2/RC3/RC4/RC5 = 03
  • 'Native Hawaiian - Pacific Islander' if STU.RC1/RC2/RC3/RC4/RC5 = 04
  • 'White' if STU.RC1/RC2/RC3/RC4/RC5 = 05

One entry for each race associated with the student.

Full DC097 Code Translation is used rather than code.

E1390 (DC079)EMERGENT-BILINGUAL LimitedEnglishProficiency
STU.LF *
DemographicsLangFlu
<Student id="SCID_SSS_XXXXXX">

<LimitedEnglishProficiency>Status</LimitedEnglishProficiency>

</Student>


where Status = STU.LF

Full DC079 Code Translation is used rather than code.

E0212DISTRICT-IDStateOrganizationIdLOC.CC + LOC.DCSchool OptionsCounty + District
<Student id="SCID_SSS_XXXXXX">

<TX-LEAReference>

<EducationalOrgIdentity>

<StateOrganizationId>CCCDDD</StateOrganizationId>

</EducationalOrgIdentity>

</TX-LEAReference>

</Student>


where:

  • CCC = LOC.CC
  • DDD = LOC.DC



InterchangeStudentEnrollmentExtension

StudentSchoolAssociationExtension

Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
E1523TX-UNIQUE-STUDENT-IDStudentUniqueStateIdSTU.CIDDemographics > Student Data 2Unique ID

<StudentSchoolAssociation>

<StudentReference>

<StudentIdentity>

<StudentUniqueStateId>UUUUUUUUUU</StudentUniqueStateId>

</StudentIdentity>

</StudentReference>

</StudentSchoolAssociation>


where UUUUUUUUUU = STU.CID
E0266CAMPUS-IDStateOrganizationIdLOC.CC + LOC.DC + LOC.SCSchool OptionsCounty + District + Campus

<StudentSchoolAssociation>

<SchoolReference>

<EducationalOrgIdentity>

<StateOrganizationId>CCCDDDSSS</StateOrganizationId>

</EducationalOrgIdentity>

</SchoolReference>

</StudentSchoolAssociation>


where:
  • CCC = LOC.CC
  • DDD = LOC.DC
  • SSS = LOC.SC
E1517 (DC063)ENTRY-GRADE-LEVEL-TYPEEntryGradeLevelENR.GREnrollment HistoryGrd

<StudentSchoolAssociation>

<EntryGradeLevel>Grade level</EntryGradeLevel>

</StudentSchoolAssociation>


where Grade level = ENR.GR

Full DC063 Code Translation is used rather than code.


StudentSectionAssociation

  • 40110-000E/50300-000EThe combination of the following fields must be unique for each StudentSectionAssociation: TX-UNIQUE-STUDENT-ID, CAMPUS-ID, CLASS-ID-NUMBER, COURSE-SEQUENCE-CODE, and STUDENT-BEGIN-DATE.
  • 40110-0180For each StudentSectionAssociation, there must be a corresponding Course Section where CAMPUS-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE are the same.
  • 40110-0184If the student assessment REPORT-ASSESSMENT-TYPE is ECDS-KG, for a particular TX-UNIQUE-STUDENT-ID, there must be one and only one StudentSectionAssociation where assessment ADMINISTRATION-DATE is greater than or equal to STUDENT-BEGIN-DATE and less than or equal to STUDENT-END-DATE, and HOME-ROOM-INDICATOR is TRUE.
Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
E1523TX-UNIQUE-STUDENT-IDStudentUniqueStateIdSTU.CIDDemographics > Student Data 2Unique ID

<StudentSectionAssociation>

<StudentReference>

<StudentIdentity>

<StudentUniqueStateId>UUUUUUUUUU</StudentUniqueStateId>

</StudentIdentity>

</StudentReference>

</StudentSectionAssociation>


where UUUUUUUUUU = STU.CID
E0266CAMPUS-IDStateOrganizationIdLOC.CC + LOC.DC + LOC.SCSchool OptionsCounty + District + Campus

<StudentSectionAssociation>

<SectionReference>

<SectionIdentity>

<StateOrganizationId>CCCDDDSSS</StateOrganizationId>

</SectionIdentity>

</SectionReference>

</StudentSectionAssociation>


where:
  • CCC = LOC.CC
  • DDD = LOC.DC
  • SSS = LOC.SC
E1056CLASS-ID-NUMBERUniqueSectionCodeLOC.CD + "_"School OptionsCode
MST.SEMaster ScheduleSection

<StudentSectionAssociation>

<SectionReference>

<SectionIdentity>

<UniqueSectionCode>CCCCCCCCC_SSSS</UniqueSectionCode>

</SectionIdentity>

</SectionReference>

</StudentSectionAssociation>


where:

  • CCCCCCCCCC = LOC.CD (zero padded) 
  • SSSS = MST.SE
  • Separated by underscore
E1069STUDENT-BEGIN-DATEBeginDateCAR.DS
Course Attendance
Start Date

<StudentSectionAssociation>

<BeginDate>YYYY-MM-DD</BeginDate>

</StudentSectionAssociation>


where YYYY-MM-DD = CAR.DS
Rules (FATAL):
  • 40110-0163STUDENT-BEGIN-DATE must be a valid date.
  • 40110-0081For a StudentSectionAssociation, STUDENT-END-DATE must be greater than or equal to STUDENT-BEGIN-DATE.
  • 40110-0165: (For the 2021-2022 school year) STUDENT-BEGIN-DATE must be between June 1, 2021 and August 31, 2022.
E1070STUDENT-END-DATEEndDateCAR.DECourse AttendanceStop Date

<StudentSectionAssociation>

<EndDate>YYYY-MM-DD</EndDate>

</StudentSectionAssociation>


where YYYY-MM-DD = CAR.DE
Rules (FATAL):
  • 40110-0164STUDENT-END-DATE must be a valid date.
  • 40110-0081For a StudentSectionAssociation, STUDENT-END-DATE must be greater than or equal to STUDENT-BEGIN-DATE.
  • 40110-0166: (For the 2021-2022 school year) STUDENT-END-DATE must be between June 1, 2021 and August 31, 2022.
E1440HOME-ROOM-INDICATORHomeroomIndicatorCAR.SQCourse Attendancesequence number - not displayed
CRS.SVC = 01020000Courses > OtherService ID

<StudentSectionAssociation>

<HomeroomIndicator>true/false</HomeroomIndicator>

</StudentSectionAssociation>


where true/false = true if CRS.SVC= 01020000
Based on course enrollment on the day extract is run.
If student has multiple CRS.SVC = 01020000 sections, the section with the lowest CAR.SQ is indicated as Homeroom.    
Rule (FATAL):
  • 40110-0173If the student assessment REPORT-ASSESSMENT-TYPE is ECDS-KG, then HOME-ROOM-INDICATOR must not be blank on StudentSectionAssociations.

Special Warning:

  • 40110-0179If HOME-ROOM-INDICATOR is TRUE, then there should be a student assessment with REPORT-ASSESSMENT-TYPE ECDS-KG.
E0948 (C135)COURSE-SEQUENCE-CODETX-CourseSequenceCRS.CSQ *Courses > OtherCrs Seq

<StudentSectionAssociation>

<TX-CourseSequence>X</TX-CourseSequence>

</StudentSectionAssociation>


where X = CRS.CSQ



InterchangeStaffAssociationExtension

StaffExtension

  • 30040-000CThe combination of the following fields must be unique for each staff person: TX-UNIQUE-STAFF-ID and DISTRICT-ID.
  • 30040-0002For each staff person, Teacher Class Assignment (TeacherSectionAssociation) data must be reported with a matching TX-UNIQUE-STAFF-ID.
Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
Staffidid


<Staff id="STF_SSS_CCC">

</Staff>


where 

  • SSS = 
  • CCC = 
E1524TX-UNIQUE-STAFF-IDStaffUniqueStateIdSTF.SIDStaffUnique ID
<Staff id="STF_SSS_CCC">

<StaffUniqueStateId>UUUUUUUUUU</StaffUniqueStateId>

</Staff>


where UUUUUUUUUU = STF.SID
Rules (FATAL):
  • 30040-0038TX-UNIQUE-STAFF-ID must match an entry in the TSDS Unique ID system.
  • 30305-0002: TX-UNIQUE-STAFF-ID for a TeacherSectionAssociation must match TX-UNIQUE-STAFF-ID for a staff person.
E1088STAFF-IDENTIFICATION-SYSTEMIdentificationSystem"State"
<Staff id="STF_SSS_CCC">

<StaffIdentificationCode IdentificationSystem="State">

<ID>SSSSSSSSS</ID>

</StaffIdentificationCode>

</Staff>

E0505STAFF-ID  IDESD.EDStaffSocial Security #
<Staff id="STF_SSS_CCC">

<StaffIdentificationCode IdentificationSystem="State">

<ID>SSSSSSSSS</ID>

</StaffIdentificationCode>

</Staff>


where SSSSSSSSS = ESD.ED
E0703FIRST-NAMEFirstNameSTF.FNStaffFirst Name
<Staff id="STF_SSS_CCC">

<Name>

<FirstName>First</FirstName>

</Name>

</Staff>


where First = STF.FN
Special Warning:
  • 30040-0050FIRST-NAME should not end with " JR", " SR", " I", " II", " III", " IV", " V", " VI", " VII", " VIII", " IX", or " X" (not case sensitive).
E0705LAST-NAMELastSurnameSTF.LNStaff
Last Name
<Staff id="STF_SSS_CCC">
<Name>

<LastSurname>Last</LastSurname>

</Name>

</Staff>


where Last = STF.LN
Special Warnings:
  • 30040-0050LAST-NAME should not end with " JR", " SR", " I", " II", " III", " IV", " V", " VI", " VII", " VIII", " IX", or " X" (not case sensitive).
E0212DISTRICT-IDStateOrganizationIdLOC.CC + LOC.DCSchool OptionsCounty + District
<Staff id="STF_SSS_CCC">

<TX-LEAReference>

<EducationalOrgIdentity>

<StateOrganizationId>CCCDDD</StateOrganizationId>

</EducationalOrgIdentity>

</TX-LEAReference>

</Staff>


where
  • CCC = LOC.CC
  • DDD = LOC.DC


TeacherSectionAssociationExtension

  • 30305-000A/50300-000H: The combination of the following fields must be unique for each TeacherSectionAssociation: TX-UNIQUE-STAFF-ID, CAMPUS-ID, CLASS-ID-NUMBER, COURSE-SEQUENCE-CODE, and ASSIGNMENT-BEGIN-DATE.
  • 30040-0002: For each staff person, Teacher Class Assignment (TeacherSectionAssociation) data must be reported with a matching TX-UNIQUE-STAFF-ID.
  • GR1: Teaching staff (ROLE-IDs 087, 047 and 033) that are providing instruction in course sections for grade level KG should be reported for ECDS. If more than one “Teacher of Record” is assigned to a class during the duration of the class, then all “Teachers of Record” must be reported on the TeacherSectionAssociationExtension complex type.
Element ID & Code Table Data ElementXML NameAeries Table.FieldAeries PageLabel
E1524TX-UNIQUE-STAFF-IDStaffUniqueStateIdSTF.SIDStaffUnique ID

<TeacherSectionAssociation>

<TeacherReference>

<StaffIdentity>

<StaffUniqueStateId>UUUUUUUUUU</StaffUniqueStateId>

</StaffIdentity>

</TeacherReference>

</TeacherSectionAssociation>


where UUUUUUUUUU = SID

Rules (FATAL):

  • 30305-0002: TX-UNIQUE-STAFF-ID for a TeacherSectionAssociation must match TX-UNIQUE-STAFF-ID for a staff person.
E0266CAMPUS-IDStateOrganizationIdLOC.CC + LOC.DC + LOC.SCSchool OptionsCounty + District + Campus

<TeacherSectionAssociation>

<SectionReference>

<SectionIdentity>

<StateOrganizationId>CCCDDDSSS</StateOrganizationId>

</SectionIdentity>

</SectionReference>

</TeacherSectionAssociation>


where CCC = LOC.CC and DDD = LOC.DC and SSS = LOC.SC

E1056CLASS-ID-NUMBERUniqueSectionCodeLOC.CD
School OptionsCode
MST.SEMaster ScheduleSection

<TeacherSectionAssociation>

<SectionReference>

<SectionIdentity>

<UniqueSectionCode>CCCCCCCCCCC_SSSS</UniqueSectionCode>

</SectionIdentity>

</SectionReference>

</TeacherSectionAssociation>


where:

  • CCCCCCCCCC = LOC.CD (zero padded)
  • SSSS = MST.SE
E1454 (CD143)
CLASSROOM-POSITIONClassroomPositionMST.TP1
Master Schedule
Position

<TeacherSectionAssociation>

<ClassroomPosition>Position</ClassroomPosition>

</TeacherSectionAssociation>


where Position = MST.TP1
IMPORTANT: Full DC143 Code Translation is used rather than code. 
Special Warning:
  • 30305-0019For 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".
E1065ASSIGNMENT-BEGIN-DATEBeginDateCAR.DS
Course Attendance
Start Date

<TeacherSectionAssociation>

<BeginDate>YYYY-MM-DD</BeginDate>

</TeacherSectionAssociation>


where YYYY-MM-DD = CAR.DS (the first date at least one student was enrolled in the teacher's class)
  • GR1: LEAs are required to report the actual ASSIGNMENT-BEGIN-DATEs and the ASSIGNMENT-END-DATEs for all teachers (Teachers of Record, Assistant Teachers, and Support Teachers) associated with a particular class. For example, if a particular section of Kindergarten homeroom I had two different “Teachers of Record” before the class ended, then the actual ASSIGNMENT-BEGIN-DATEs and ASSIGNMENT-END-DATEs for each teacher’s service would be reported on their respective TeacherSectionAssociationExtension complex type. This scenario also applies to assistant and support teachers as well.
  • DR1: ASSIGNMENT-BEGIN-DATE (E1065) identifies the first date a teacher was assigned to the class in the current school year. If more than one teacher is assigned to a course section during the duration of a course section, then there must be a TeacherSectionAssociationExtension complex type for each teacher that was assigned to the course section.  If a particular teacher is assigned to a course section, leaves that course section assignment, and then at a later date is reassigned to that course section (returns to that class at a later date), then there must be a TeacherSectionAssociationExtension complex type for each of these teacher ASSIGNMENT-BEGIN-DATEs.
Rules (FATAL):
  • 0305-0007: ASSIGNMENT-BEGIN-DATE must be a valid date.
  • 30305-0008: (For the 2021-2022 school year) ASSIGNMENT-BEGIN-DATE must be between June 1, 2021 and August 31, 2022.
  • 30305-0011: ASSIGNMENT-END-DATE must be greater than ASSIGNMENT-BEGIN-DATE.
  • 30305-0025: For a TeacherSectionAssociation being reported for the ECDS collection, the following must not be blank: ASSIGNMENT-BEGIN-DATE.
E1066ASSIGNMENT-END-DATEEndDateCAR.DECourse AttendanceStop Date

<TeacherSectionAssociation>

<EndDate>YYYY-MM-DD</EndDate>

</TeacherSectionAssociation>


where YYYY-MM-DD = CAR.DE (the last date at least one student was enrolled in the teacher's class) 
  • GR1: LEAs are required to report the actual ASSIGNMENT-BEGIN-DATEs and the ASSIGNMENT-END-DATEs for all teachers (Teachers of Record, Assistant Teachers, and Support Teachers) associated with a particular class. For example, if a particular section of Kindergarten homeroom I had two different “Teachers of Record” before the class ended, then the actual ASSIGNMENT-BEGIN-DATEs and ASSIGNMENT-END-DATEs for each teacher’s service would be reported on their respective TeacherSectionAssociationExtension complex type. This scenario also applies to assistant and support teachers as well. 
  • DR1: ASSIGNMENT-END-DATE (E1066) identifies the last date a teacher was assigned to the class in the current school year. If after being assigned to a particular course section a teacher leaves that course section, then there must be a TeacherSectionAssociationExtension complex type reflecting both the ASSIGNMENT-BEGIN-DATE and the Teacher Class Assignment for that particular teacher’s segment of service to that course section. If a particular teacher is assigned to a course section, leaves that course section assignment more than once, then there must be a TeacherSectionAssociationExtension complex type for each of these teachers ASSIGNMENT-BEGIN-DATE and ASSIGNMENT-END-DATEs. The teacher(s) that are assigned to a particular course section on the last date the course section meets must be reported on their TeacherSectionAssociationExtension complex type with an ASSIGNMENT-END-DATE that reflects the last date the class met.
Rules (FATAL):
  • 30305-0009: ASSIGNMENT-END-DATE must be a valid date.
  • 30305-0010: (For the 2021-2022 school year) ASSIGNMENT-END-DATE must be between June 1, 2021 and August 31, 2022.
  • 30305-0011: ASSIGNMENT-END-DATE must be greater than ASSIGNMENT-BEGIN-DATE.
  • 30305-0025: For a TeacherSectionAssociation being reported for the ECDS collection, the following must not be blank: ASSIGNMENT-END-DATE.
E0948 (C135)COURSE-SEQUENCE-TYPETX-CourseSequenceCRS.CSQ *Courses > OtherCrs Seq

<TeacherSectionAssociation>

<TX-CourseSequence>X</TX-CourseSequence>

</TeacherSectionAssociation>


where X = CRS.CSQ


* Must be mapped on Texas State Reporting > Code Translations