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 public PK program data is mandatory for all LEAs that administer a PK program, whether or not the LEA administers one or more of the assessments included in the Commissioner’s List of Approved Prekindergarten Assessment Instruments. LEAs that administer one or more of the approved assessments are required to collect and report the Beginning of Year (BOY) and/or End of Year (EOY) assessment results data to TEA (provided by assessment vendor). 


InterchangeEducationOrganizationExtension

InterchangeMasterScheduleExtension

InterchangeStudentParentExtension

InterchangeStudentEnrollmentExtension

InterchangeStaffAssociationExtension

InterchangeStudentProgramExtension


NOTES:

AssessmentMetadata and StudentAssessment interchanges are supplied by the assessment vendor.

The StudentCohort interchange is only required for private PK schools.


InterchangeEducationOrganizationExtension

LocalEducationAgencyExtension

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

<LocalEducationAgency id="LEA_CCCDDD">

<StateOrganizationId>CCCDDD</StateOrganizationId>

</LocalEducationAgency>


where:
  • CCC = LOC.CC
  • DDD = LOC.DC
ProgramReferenceProgramReference
SPR.CD = 33 * 
SPR.SD
SPR.ED
School Programs (school)Program Type, Start Date, End Date
<LocalEducationAgency id="LEA_CCCDDD">

<ProgramReference ref="PGRM_XX"/>

</LocalEducationAgency>


where:
  • XX = SPR.CD (33) 
  • extract date is between SPR.SD and SPR.ED
Only the Special Education program (33) should be included.
Only one entry for the LEA
Program must be mapped under Code Translations (Program Type (SPR.CD)).
E1583FAMILY-ENGAGEMENT-PLAN-LINKTX-FamilyEngagementPlanLinkDPT.NMDistrict OptionsState Reporting - Family Engagement Plan Link

<LocalEducationAgency id="LEA_CCCDDD">

<TX-FamilyEngagementPlanLink>URL</TX-FamilyEngagementPlanLink

</LocalEducationAgency>


where:
  • CCC = LOC.CC
  • DDD = LOC.DC
  • URL = DPT.NM
Omitted if blank.


SchoolExtension

One extension for each school that offers the PK grade level, based on the Low Grade (LOC.LO) and High Grade (LOC.HI) fields on School Options.


Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
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
LocalEducationAgencyReferenceLocalEducationAgencyReference
LOC.CC + LOC.DCSchool OptionsCounty + District

<School id="SCH_SSS">

<LocalEducationAgencyReference ref="LEA_CCCDDD" />

</School>


where:
  • SSS = LOC.SC
  • CCC = LOC.CC 
  • DDD = LOC.DC 
ClassPeriodReference
ClassPeriodReference
MST.PDMaster SchedulePeriod

<School id="SCH_SSS">

<ClassPeriodReference ref="CP_SSS_p" />

</School>


where:
  • SSS = LOC.SC 
  • p = MST.PD
One ClassPeriodReference for each ClassPeriod complex type


ClassPeriod

One complex for each period where at least one PK student (STU.GR = -1) was ever enrolled in that section this school year (based on CAR records), including inactive students.

NOTE: The extract automatically attaches the homeroom indicator (E1440) to periods that meet this criteria.


Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
E1074CLASS-PERIODClassPeriodNameMST.PDMaster SchedulePeriod

<ClassPeriod id="CP_SSS_p">

<ClassPeriodName>PP</ClassPeriodName>

</ClassPeriod>


where:
  • SSS = LOC.SC
  • p = MST.PD 
  • PP = MST.PD (zero padded)


Course

One complex for each course where at least one PK students was ever enrolled in any section of the course this school year (based on CAR records), including inactive students. 


Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
E1089 (DC036)COURSE-IDENTIFICATION-SYSTEM(a) IdentificationSystem"State course code"

<Course>

<CourseCode IdentificationSystem="State course code">

<ID>CCCCCCCC</ID>

</CourseCode>

</Course>

E0724 (C022)
SERVICE-IDIDCRS.SVC
CoursesService ID

<Course>

<CourseCode IdentificationSystem="State course code">

<ID>CCCCCCCC</ID>

</CourseCode>

</Course>


where CCCCCCCC = CRS.SVC
Business Rule (FATAL):
  • 10050-0002: If SERVICE-ID is 01010000, the following fields must not be blank: PK-CURRICULA, HIGH-QUALITY-PK-PROGRAM-INDICATOR, STUDENT-INSTRUCTION, PK-SCHOOL-TYPE, and PROGRAM-EVALUATION-TYPE.
E1089 (DC036)COURSE-IDENTIFICATION-SYSTEM(a) IdentificationSystem"LEA Course Code"
<Course>

<CourseCode IdentificationSystem="LEA course code">

<ID>CCCC</ID>

</CourseCode>

</Course>

E1194LOCAL-COURSE-CODEIDCRS.CNCoursesCrsID#

<Course>

<CourseCode IdentificationSystem="LEA course code">

<ID>CCCC</ID>

</CourseCode>

</Course>


where CCCC = CRS.CN
EducationOrganizationReference
EducationOrganizationReference
LOC.SC
School OptionsCampus

<Course>

<EducationOrganizationReference ref="SCH_SSS" />

</Course>


where SSS = LOC.SC





Program

Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
E1337 (DC096)PROGRAM-TYPEProgramTypeSPR.CD = 33 *
SPR.SD
SPR.ED
School Programs (school)Program Type, 
Start Date,
End Date

<Program id="PGRM_XX">

<ProgramType>Program</ProgramType>

</Program>


where:
  • XX = SPR.CD (33) 
  • extract date is between SPR.SD and SPR.ED
  • Program = Special Education
Program must be mapped under Code Translations (Program Type (SPR.CD)).


InterchangeMasterScheduleExtension

Only classes where student CAR records exist any time during the school year with the following conditions are extracted:

  • CRS.SVC = 01010000
  • STU.GR = -1 (PK)

CourseOffering

Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
E1194LOCAL-COURSE-CODELocalCourseCodeCRS.CNCoursesCrsID#

<CourseOffering id="CourseOffering_SSS_NNNN_s">

<LocalCourseCode>NNNN</LocalCourseCode>

</CourseOffering>


where:
  • SSS = LOC.SC 
  • NNNN = CRS.CN 
  • s = MST.SE 
E0266CAMPUS-IDStateOrganizationIdLOC.CC + LOC.DC + LOC.SCSchool OptionsCounty + District + Campus

<CourseOffering id="CourseOffering_SSS_NNNN_s">

<SchoolReference>

<EducationalOrgIdentity>

<StateOrganizationId>CCCDDDSSS</StateOrganizationId>

</EducationalOrgIdentity>

</SchoolReference>

</CourseOffering>


where:
  • SSS = LOC.SC
  • NNNN = CRS.CN 
  • s = MST.SE 
  • CCC = LOC.CC 
  • DDD = LOC.DC
E1089 (DC036)COURSE-IDENTIFICATION-SYSTEM
(a) IdentificationSystem"LEA course code"

<CourseOffering id="CourseOffering_SSS_NNNN_s">

<CourseReference>

<CourseIdentity>

<CourseCode IdentificationSystem="LEA course code">

<ID>NNNN</ID>

</CourseCode>

</CourseIdentity>

</CourseReference>

</CourseOffering>


where:
  • SSS = LOC.SC
  • NNNN = CRS.CN 
  • s = MST.SE
E1194LOCAL-COURSE-CODEIDCRS.CNCoursesCrsId#

<CourseOffering id="CourseOffering_SSS_NNNN_s">

<CourseReference>

<CourseIdentity>

<CourseCode IdentificationSystem="LEA course code">

<ID>NNNN</ID>

</CourseCode>

</CourseIdentity>

</CourseReference>

</CourseOffering>


where:
  • SSS = LOC.SC 
  • NNNN = CRS.CN
  • s = MST.SE


SectionExtension

Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
E1056CLASS-ID-NUMBERUniqueSectionCodeMST.SCL + "_" + MST.SEMaster ScheduleSchool, Section

<Section>

<UniqueSectionCode>CCCCCCCCCC _SSSS</UniqueSectionCode>

</Section>


where:
  • CCCCCCCCCC = MST.SCL (zero padded) 
  • SSSS = MST.SE
  • separated by underscore 
Business Rule (FATAL): 
  • 40110-0180: For each Student Section Association, there must be a corresponding Course Section where CLASS-ID-NUMBER is the same.
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
Business Rule (FATAL): 
  • 40110-0180: For each Student Section Association, there must be a corresponding Course Section where CAMPUS-ID is the same.
E1074CLASS-PERIODClassPeriodNameMST.PDMaster SchedulePeriod

<Section>

<ClassPeriodReference>

<ClassPeriodIdentity>

<ClassPeriodName>NN</ClassPeriodName>

</ClassPeriodIdentity>

</ClassPeriodReference>

</Section>


where NN = MST.PD
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
E0948 (C135)COURSE-SEQUENCE-CODETX-CourseSequenceCRS.CSQ *Courses > OtherCrs Seq

<Section>

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

</Section>


where X = CRS.CSQ
Business Rule (FATAL): 
  • 40110-0180: For each Student Section Association, there must be a corresponding Course Section where COURSE-SEQUENCE-CODE is the same.
E1579 (C206)PK-CURRICULATX-PKCurriculaMST.CTMaster SchedulePK Curricula

<Section>

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

</Section>


where XX= MST.CT
Business Rule (FATAL):
  • 10050-0002: If SERVICE-ID is 01010000, then PK-CURRICULA must not be blank.
E1580 (C088)HIGH-QUALITY-PK-PROGRAM-INDICATORTX-HighQualityPrekProgramIndicatorMST.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
Business Rule (FATAL):
  • 10050-0002: If SERVICE-ID is 01010000, then HIGH-QUALITY-PK-PROGRAM-INDICATOR must not be blank.
E1558 (DC153)STUDENT-INSTRUCTIONTX-StudentInstructionMST.SIT
Master ScheduleInstruction Type

<Section>

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

</Section>


where Description = MST.SIT
Full DC153 Code Translation is used rather than code.
Business Rule (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. 
E1555 (DC152)PK-SCHOOL-TYPETX-PKSchoolTypeMST.PKT * or
Master Schedule or

PK Schl Type or
LOC.PKT *School OptionsPK School Type

<Section>

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

</Section>


where Description is MST.PKT if present; otherwise LOC.PKT *
Full DC152 Code Translation is used rather than code.
Business Rule (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.
E1626 (D216)PROGRAM-EVALUATION-TYPETX-ProgramEvaluationTypeMST.ET * Master ScheduleEvaluation Type

<Section>

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

</Section>


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


InterchangeStudentParentExtension

StudentExtension

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

<Student id="SCID_SSS_UUUUUUUUUU">

<StudentUniqueStateId>UUUUUUUUUU</StudentUniqueStateId>

</Student>


where:
  • SSS = LOC.SC 
  • UUUUUUUUUU = STU.CID 
E1090 (DC126)STUDENT-IDENTIFICATION-SYSTEM(a) IdentificationSystem"State"

<Student id="SCID_SSS_UUUUUUUUUU">

<StudentIdentificationCode IdentificationSystem="State">

<IdentificationCode>SSSSSSSSS</IdentificationCode>

</StudentIdentificationCode>

</Student>


where:
  • SSS = LOC.SC 
  • UUUUUUUUUU = STU.CID 
  • SSSSSSSSS = ESC.ED 

Business 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", then the first character of STUDENT-ID must be S or 0-8.
  • 40100-0103: If STUDENT-IDENTIFICATION-SYSTEM is "State", then 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, then the first three characters of STUDENT-ID must be between 001 and 899 (excluding 666).
  • 40100-0105: If STUDENT-IDENTIFICATION-SYSTEM is "State", and the first character of STUDENT-ID is not S, then the fourth and fifth characters of STUDENT-ID must not be 00, and the last four characters of STUDENT-ID must not be 0000.
E0001STUDENT-IDIdentificationCodeESD.ED
Demographics > Student Data 2Soc-Sec-Num / S-Number

<Student id="SCID_SSS_UUUUUUUUUU">

<StudentIdentificationCode IdentificationSystem="State">

<IdentificationCode>SSSSSSSSS</IdentificationCode>

</StudentIdentificationCode>

</Student>


where:
  • SSS = LOC.SC 
  • UUUUUUUUUU = STU.CID 
  • SSSSSSSSS = ESC.ED
Business 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", then the first character of STUDENT-ID must be S or 0-8.
  • 40100-0103: If STUDENT-IDENTIFICATION-SYSTEM is "State", then 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, then the first three characters of STUDENT-ID must be between 001 and 899 (excluding 666).
  • 40100-0105: If STUDENT-IDENTIFICATION-SYSTEM is "State", and the first character of STUDENT-ID is not S, then 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-SYSTEM(a) IdentificationSystem"District"

<Student id="SCID_SSS_UUUUUUUUUU">

<StudentIdentificationCode IdentificationSystem="District">

<IdentificationCode>DDDDDD</IdentificationCode>

</StudentIdentificationCode>


where:
  • SSS = LOC.SC 
  • UUUUUUUUUU = STU.CID 
  • DDDDDD = STU.ID
E0923LOCAL-STUDENT-IDIdentificationCode
STU.IDDemographicsStudent ID

<Student id="SCID_SSS_UUUUUUUUUU">

<StudentIdentificationCode IdentificationSystem="District">

<IdentificationCode>DDDDDD</IdentificationCode>

</StudentIdentificationCode>


where:
  • SSS = LOC.SC 
  • UUUUUUUUUU = STU.CID
  • DDDDDD = STU.ID
This element is optional.
E0703FIRST-NAMEFirstNameSTU.FN
DemographicsFirst Name

<Student id="SCID_SSS_UUUUUUUUUU">

<Name>

<FirstName>FIRST</FirstName>

</Name>

</Student>


where:
  • SSS = LOC.SC 
  • UUUUUUUUUU = STU.CID 
  • FIRST = STU.FN
E0704MIDDLE-NAMEMiddleNameSTU.MN
DemographicsMiddle Name

<Student id="SCID_SSS_UUUUUUUUUU">

<Name>

<MiddleName>MIDDLE</MiddleName>

</Name>

</Student>


where:
  • SSS = LOC.SC 
  • UUUUUUUUUU = STU.CID 
  • MIDDLE = STU.MN 
E0705LAST-NAMELastSurnameSTU.LN
DemographicsLast Name

<Student id="SCID_SSS_UUUUUUUUUU">

<Name>

<LastSurname>LAST</LastSurname>

</Name>

</Student>


where:
  • SSS = LOC.SC 
  • UUUUUUUUUU = STU.CID 
  • LAST = STU.LN 
E1325 (DC119)SEXSexSTU.GNDemographicsGender

<Student id="SCID_SSS_UUUUUUUUUU">

<Sex>Male/Female</Sex>

</Student>


where:
  • SSS = LOC.SC
  • UUUUUUUUUU = STU.CID
  • Male/Female = STU.GN
    Full DC119 Code Translation is used rather than code 
E0006DATE-OF-BIRTHBirthDateSTU.BDDemographicsBirthdate

<Student id="SCID_SSS_UUUUUUUUUU">

<BirthData>

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

</BirthData>

</Student>


where:
  • SSS = LOC.SC 
  • UUUUUUUUUU = STU.CID
  • YYYY-MM-DD = STU.BD
E1375HISPANIC-LATINO-ETHNICITYHispanicLatinoEthnicitySTU.ETHDemographicsEthnicity

<Student id="SCID_SSS_UUUUUUUUUU">

<HispanicLatinoEthnicity>true/false</HispanicLatinoEthnicity>

</Student>


where:
  • SSS = LOC.SC 
  • UUUUUUUUUU = STU.CID 
  • true/false = true if STU.ETH = Y; otherwise false
Business Rule (FATAL):
  • 40100-0185: For a student being reported for the ECDS collection, the following must not be blank: HISPANIC-LATINO-ETHNICITY.
E1343 (DC097)RACIAL-CATEGORYRacialCategorySTU.RC1 - STU.RC5 *DemographicsRace

<Student id="SCID_SSS_UUUUUUUUUU">

<Race>

<RacialCategory>Race</RacialCategory>

</Race>

</Student>


where:
  • SSS = LOC.SC
  • UUUUUUUUUU = STU.CID 
  • 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.

Business Rule (FATAL):
  • 40100-0185: For a student being reported for the ECDS collection, the following must not be blank: at least one RACIAL-CATEGORY.
E1387ECONOMIC-DISADVANTAGEEconomicDisadvantagedFRE.CD *Free and ReducedNSLP Lunch Type Code

<Student id="SCID_SSS_UUUUUUUUUU">

<TX-EconomicDisadvantaged>true/false</TX-EconomicDisadvantaged>

</Student>


where:
  • SSS = LOC.SC 
  • UUUUUUUUUU = STU.CID 
  • true/false = true if FRE.CD is mapped to TSDS/PEIMS Code 01, 02, or 99. 
E1390 (DC079)LIMITED-ENGLISH-PROFICIENCYLimitedEnglishProficiency
STU.LF * DemographicsLangFlu

<Student id="SCID_SSS_UUUUUUUUUU">

<LimitedEnglishProficiency>Description</LimitedEnglishProficiency>

</Student>


where:
  • SSS = LOC.SC
  • UUUUUUUUUU = STU.CID 
  • Description = 
    • 'NotLimited' if STU.LF = 0, 01, or blank
    • 'Limited' if STU.LF = 1 or 02
    • 'Limited Monitored 1' if STU.LF = 03 or F
    • 'Limited Monitored 2' if STU.LF = 04 or 5
Business Rule (FATAL):
  • 40100-0185: For a student being reported for the ECDS collection, the following must not be blank: LIMITED-ENGLISH-PROFICIENCY.
E0212DISTRICT-IDStateOrganizationIdLOC.CC + LOC.DCSchool OptionsCounty + District

<Student id="SCID_SSS_UUUUUUUUUU">

<TX-LEAReference>

<EducationalOrgIdentity>

<StateOrganizationId>CCCDDD</StateOrganizationId>

</EducationalOrgIdentity>

</TX-LEAReference>

</Student>


where:
  • SSS = LOC.SC
  • UUUUUUUUUU = STU.CID 
  • 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</EntryGradeLevel>

</StudentSchoolAssociation>


where Grade = ENR.GR
Full DC063 Code Translation is used rather than code
Business Rules (FATAL):
  • 0110-0216: If ENTRY-GRADE-LEVEL-TYPE is "Preschool/Prekindergarten", then PK-PROGRAM-TYPE-CODE must not be blank.
  • 40110-0217: If ENTRY-GRADE-LEVEL-TYPE is "Preschool/Prekindergarten" and PK-PROGRAM-TYPE-CODE is 00, 02, 04, or 05, then PRIMARY-PK-FUNDING-SOURCE must not be blank.
  • 40110-0218: If ENTRY-GRADE-LEVEL-TYPE is "Preschool/Prekindergarten" and PK-PROGRAM-TYPE-CODE is 01 or 03, then PRIMARY-PK-FUNDING-SOURCE must be blank.
E1078 (C185)PK-PROGRAM-TYPE-CODETX-PKProgramTypeIndicatorECD.PTCEarly Childhood DevelopmentProgram Type

<StudentSchoolAssociation>

<TX-PKProgramTypeIndicator>XX</TX-PKProgramTypeIndicator>

</StudentSchoolAssociation>


where XX = ECD.PTC
Omitted if blank.
C185 code is used rather than full Code Translation.
Business Rules (FATAL):
  • 0110-0216: If ENTRY-GRADE-LEVEL-TYPE is "Preschool/Prekindergarten", then PK-PROGRAM-TYPE-CODE must not be blank.
  • 40110-0217: If ENTRY-GRADE-LEVEL-TYPE is "Preschool/Prekindergarten" and PK-PROGRAM-TYPE-CODE is 00, 02, 04, or 05, then PRIMARY-PK-FUNDING-SOURCE must not be blank.
  • 40110-0218: If ENTRY-GRADE-LEVEL-TYPE is "Preschool/Prekindergarten" and PK-PROGRAM-TYPE-CODE is 01 or 03, then PRIMARY-PK-FUNDING-SOURCE must be blank.
E1079 (C186)PRIMARY-PK-FUNDING-SOURCETX-PrimaryPKFundingSourceECD.FT1Early Childhood DevelopmentPrimary Funding Type

<StudentSchoolAssociation>

<TX-PrimaryPKFundingSource>X</TX-PrimaryPKFundingSource>

</StudentSchoolAssociation>


where X = ECD.FT1
Omitted if blank.
C186 code is used rather than full Code Translation.
Business Rules (FATAL):
  • 40110-0034: If SECONDARY-PK-FUNDING-SOURCE is not blank, then PRIMARY-PK-FUNDING-SOURCE must not be blank, and PRIMARY-PK-FUNDING-SOURCE must not be the same as SECONDARY-PK-FUNDING-SOURCE.
  • 40110-0217: If ENTRY-GRADE-LEVEL-TYPE is "Preschool/Prekindergarten" and PK-PROGRAM-TYPE-CODE is 00, 02, 04, or 05, then PRIMARY-PK-FUNDING-SOURCE must not be blank.
  • 40110-0218: If ENTRY-GRADE-LEVEL-TYPE is "Preschool/Prekindergarten" and PK-PROGRAM-TYPE-CODE is 01 or 03, then PRIMARY-PK-FUNDING-SOURCE must be blank.
E1080 (C186)SECONDARY-PK-FUNDING-SOURCETX-SecondaryPKFundingSourceECD.FT2Early Childhood DevelopmentSecondary Funding Type

<StudentSchoolAssociation>

<TX-SecondaryPKFundingSource>X</TX-SecondaryPKFundingSource>

</StudentSchoolAssociation>


where X = ECD.FT2
Omitted if blank.
C186 code is used rather than full Code Translation.
Business Rule (FATAL):
  • 40110-0034: If SECONDARY-PK-FUNDING-SOURCE is not blank, then PRIMARY-PK-FUNDING-SOURCE must not be blank, and PRIMARY-PK-FUNDING-SOURCE must not be the same as SECONDARY-PK-FUNDING-SOURCE.


StudentSectionAssociation

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

<StudentSectionAssociation>

<StudentReference>

<StudentIdentity>

<StudentUniqueStateId>UUUUUUUUUU</StudentUniqueStateId>

</StudentIdentity>

</StudentReference>

</StudentSectionAssociation>


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

<StudentSectionAssociation>

<SectionReference>

<SectionIdentity>

<StateOrganizationId>CCCDDDSSS</StateOrganizationId>

</SectionIdentity>

</SectionReference>

</StudentSectionAssociation>


where:
  • CCC = LOC.CC
  • DDD = LOC.DC
  • SSS = LOC.SC 
Business Rule (FATAL): 
  • 40110-0180: For each Student Section Association, there must be a corresponding Course Section where CAMPUS-ID is the same.
E1056CLASS-ID-NUMBERUniqueSectionCodeMST.SCL + "_" + MST.SEMaster Schedule
School
Section

<StudentSectionAssociation>

<SectionReference>

<SectionIdentity>

<UniqueSectionCode>CCCCCCCCCCCC_SSSS</UniqueSectionCode>

</SectionIdentity>

</SectionReference>

</StudentSectionAssociation>


where:
  • CCCCCCCCCC = MST.SCL (zero padded) 
  • SSSS = MST.SE
  • separated by underscore 
Business Rule (FATAL): 
  • 40110-0180: For each Student Section Association, there must be a corresponding Course Section where CLASS-ID-NUMBER is the same.
E1069STUDENT-BEGIN-DATEBeginDateCAR.DS
Course Attendance
Start Date

<StudentSectionAssociation>

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

</StudentSectionAssociation>


where YYYY-MM-DD = CAR.DS

Business Rules (FATAL): 

  • 40110-0081: For a student section association, STUDENT-END-DATE must be greater than or equal to STUDENT-BEGIN-DATE.
  • 40110-0165: STUDENT-BEGIN-DATE must be between June 1, 2020 and August 31, 2021.
E1070STUDENT-END-DATEEndDateCAR.DECourse AttendanceStop Date

<StudentSectionAssociation>

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

</StudentSectionAssociation>


where YYYY-MM-DD = CAR.DE 
Business Rules (FATAL): 
  • 40110-0081: For a student section association, STUDENT-END-DATE must be greater than or equal to STUDENT-BEGIN-DATE.
  • 40110-0166: STUDENT-END-DATE must be between June 1, 2020 and August 31, 2021.
E1440HOME-ROOM-INDICATORHomeroomIndicatorCRS.SVC
Courses > Other
Service ID
CAR.SQ
Course Attendance
Sequence Number (not displayed)

<StudentSectionAssociation>

<HomeroomIndicator>true/false</HomeroomIndicator>

</StudentSectionAssociation>


where true/false = true if CRS.SVC = 01010000
The extract automatically attaches the homeroom indicator to sections that meet the ECDS PK criteria. 

E0948 (C135) COURSE-SEQUENCE-CODETX-CourseSequenceCRS.CSQ *Courses > OtherCrs Seq

<StudentSectionAssociation>

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

</StudentSectionAssociation>


where X = CRS.CSQ
C135 code is used rather than full Code Translation.
Business Rule (FATAL): 
  • 40110-0180: For each Student Section Association, there must be a corresponding Course Section where COURSE-SEQUENCE-CODE is the same.


InterchangeStaffAssociationExtension


Extracts all teachers and their sections based on schools selected for the extract where at least one PK student (STU.GR = -1) was ever enrolled in that section this school year (based on CAR records), including inactive students. 


StaffExtension

Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
E1524TX-UNIQUE-STAFF-IDStaffUniqueStateIdSTF.SIDStaffUnique ID

<Staff id="STF_SSS_XXX">

<StaffUniqueStateId>UUUUUUUUUU</StaffUniqueStateId>

<StaffIdentificationCode IdentificationSystem="State">

</StaffIdentificationCode>

</Staff>


where:
  • SSS = LOC.SC
  • XXX = STF.ID
  • UUUUUUUUUU = STF.SID

Business Rules (FATAL):

  • 30040-0002: For each staff person, Teacher Class Assignment (Teacher Section Association) data must be reported with a matching TX-UNIQUE-STAFF-ID.
  • 30305-0002: TX-UNIQUE-STAFF-ID for a Teacher Section Association must match TX-UNIQUE-STAFF-ID for a staff person.
E1088 (C191)STAFF-IDENTIFICATION-SYSTEM(a) IdentificationSystem"State"

<Staff id="STF_SSS_XXX">

<StaffUniqueStateId>UUUUUUUUUU</StaffUniqueStateId>

<StaffIdentificationCode IdentificationSystem="State">

</StaffIdentificationCode>

</Staff>


where:
  • SSS = LOC.SC
  • XXX = STF.ID
  • UUUUUUUUUU = STF.SID
E0505STAFF-ID  IDESD.EDStaffSocial Security #

<Staff id="STF_SSS_XXX">

<StaffIdentificationCode IdentificationSystem="State">

<ID>SSSSSSSSS</ID>

</StaffIdentificationCode>

</Staff>


where:
  • SSS = LOC.SC 
  • XXX = STF.ID 
  • SSSSSSSSS = ESD.ED
E0703FIRST-NAMEFirstNameSTF.FNStaffFirst Name

<Staff id="STF_SSS_XXX">

<Name>

<FirstName>FIRST</FirstName>

</Name>

</Staff>


where:
  • SSS = LOC.SC 
  • XXX = STF.ID 
  • FIRST = STF.FN
E0705LAST-NAMELastSurnameSTF.LNStaff
Last Name

<Staff id="STF_SSS_XXX">

<Name>

<LastSurname>LAST</LastSurname>

</Name>

</Staff>


where:
  • SSS = LOC.SC
  • XXX = STF.ID
  • LAST = STF.LN 
E0212DISTRICT-IDStateOrganizationIdLOC.CC + LOC.DCSchool OptionsCounty + District

<Staff id="STF_SSS_XXX">

<TX-LEAReference>

<EducationalOrgIdentity>

<StateOrganizationId>CCCDDD</StateOrganizationId>

</EducationalOrgIdentity>

</TX-LEAReference>

</Staff>


where:
  • SSS = LOC.SC
  • XXX = STF.ID
  • CCC = LOC.DD
  • DDD = LOC.DC
E1581 (C207)
PK-TEACHER-REQUIREMENT
TX-PKTeacherRequirement
STF.ECCStaffEarly Childhood Cert

<Staff id="STF_SSS_XXX">

<TX-PKTeacherRequirement>RR</TX-PKTeacherRequirement>

</Staff>


where:
  • SSS = LOC.SC 
  • XXX = STF.ID
  • RR = STF.ECC 
C207 code is used rather than the full Code Translation. 


TeacherSectionAssociationExtension

Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
E1524TX-UNIQUE-STAFF-IDStaffUniqueStateIdSTF.SIDStaffUnique ID

<TeacherSectionAssociation>

<TeacherReference>

<StaffIdentity>

<StaffUniqueStateId>UUUUUUUUUU</StaffUniqueStateId>

</StaffIdentity>

</TeacherReference>

</TeacherSectionAssociation>


where UUUUUUUUUU  = STF.SID 
Business Rules (FATAL):
  • 30040-0002: For each staff person, Teacher Class Assignment (Teacher Section Association) data must be reported with a matching TX-UNIQUE-STAFF-ID.
  • 30305-0002: TX-UNIQUE-STAFF-ID for a Teacher Section Association 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 
  • DDD = LOC.DC
  • SSS = LOC.SC
E1056CLASS-ID-NUMBERUniqueSectionCodeMST.SCL + "_" + MST.SE
Master ScheduleSchool, Section

<TeacherSectionAssociation>

<SectionReference>

<SectionIdentity>

<UniqueSectionCode>CCCCCCCCCC _SSSS</UniqueSectionCode>

</SectionIdentity>

</SectionReference>

</TeacherSectionAssociation>


where:
  • CCCCCCCCCC = MST.SCL (zero padded)
  • SSSS = MST.SE
  • separated by underscore 
E1454 (DC143)
CLASSROOM-POSITIONClassroomPositionMST.TP1
Master Schedule
Position

<TeacherSectionAssociation>

<ClassroomPosition>Position</ClassroomPosition>

</TeacherSectionAssociation>


where Position = MST.TP1
Full DC143 Code Translation is used rather than code.
E1065ASSIGNMENT-BEGIN-DATEBeginDateCAR.DS
Course AttendanceStart Date

<TeacherSectionAssociation>

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

</TeacherSectionAssociation>


where YYYY-MM-DD = CAR.DS
Business Rules (FATAL):
  • ASSIGNMENT-BEGIN-DATE must be between June 1, 2020 and August 31, 2021.
  • 30305-0011: ASSIGNMENT-END-DATE must be greater than ASSIGNMENT-BEGIN-DATE.
  • 30305-0025: For a Teacher Section Association being reported for the ECDS collection, the following must not be blank: ASSIGNMENT-BEGIN-DATE and ASSIGNMENT-END-DATE.
E1066ASSIGNMENT-END-DATEEndDateCAR.DECourse AttendanceStop Date

<TeacherSectionAssociation>

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

</TeacherSectionAssociation>


where YYYY-MM-DD = CAR.DE
Business Rules (FATAL):
  • 30305-0010: ASSIGNMENT-END-DATE must be between June 1, 2020 and August 31, 2021.
  • 30305-0011: ASSIGNMENT-END-DATE must be greater than ASSIGNMENT-BEGIN-DATE.
  • 30305-0025: For a Teacher Section Association being reported for the ECDS collection, the following must not be blank: ASSIGNMENT-BEGIN-DATE and ASSIGNMENT-END-DATE.
E0948 (C135)
COURSE-SEQUENCE-TYPETX-CourseSequenceCRS.CSQ * CoursesCrs Seq

<TeacherSectionAssociation>

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

</TeacherSectionAssociation>


where X = CRS.CSQ
C135 code is used rather than full Code Translation.
E0721 (C021)ROLE-IDTX-StaffRole
MST.SR1, MST.SR2, MST.SR3 Master Schedule
Role

<TeacherSectionAssociation>

<TX-StaffRole>XXX</TX-StaffRole>>

</TeacherSectionAssociation>


where XXX = MST.SR1 or MST.SR2 or MST.SR3 if any = 087, 047 and 033


InterchangeStudentProgramExtension

StudentSpecialEdProgramAssociationExtension

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

<StudentSpecialEdProgramAssociationExtension>

<StudentReference>

<StudentIdentity>

<StudentUniqueStateId>UUUUUUUUUU</StudentUniqueStateId>

</StudentIdentity>

</StudentReference>

</StudentSpecialEdProgramAssociationExtension>


where UUUUUUUUUU = STU.CID
E1337 (DC096)PROGRAM-TYPEProgramTypePGM.CD * Special ProgramsProgram Code

<StudentSpecialEdProgramAssociationExtension>

<ProgramReference>

<ProgramIdentity>

<ProgramType>Program</ProgramType>

</ProgramIdentity>

</ProgramReference>

</StudentSpecialEdProgramAssociationExtension>


where Program = PGM.CD
Full DC096 Code Translation is used rather than code.
For ECDS - PK Submission, PROGRAM-TYPE "Special Education" is used (per TWEDS DR1 for StudentSpecialEdProgramAssociationExtension).
E0212
DISTRICT-IDStateOrganizationIdLOC.CC + LOC.DC School OptionsCounty + District

<StudentSpecialEdProgramAssociationExtension>

<ProgramReference>

<ProgramIdentity>

<StateOrganizationId>CCCDDD</StateOrganizationId>

</ProgramIdentity>

</ProgramReference>

</StudentSpecialEdProgramAssociationExtension>


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

<StudentSpecialEdProgramAssociationExtension>

<EducationOrganizationReference>

<EducationalOrgIdentity>

<StateOrganizationId>CCCDDD</StateOrganizationId>

</EducationalOrgIdentity>

</EducationOrganizationReference>

</StudentSpecialEdProgramAssociationExtension>


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

* Must be mapped on Texas State Reporting > Code Translations