The TSDS Class Roster Submissions collect information required to link a student’s assessment results to the teacher who provided the associated instruction. 


There are two submissions: Fall and Winter. They collect the same information, except:

  • Fall reports students in grades 1-12.
  • Winter reports students in grades EE-12.


InterchangeEducationOrganizationExtension

InterchangeMasterScheduleExtension

InterchangeStudentParentExtension

InterchangeStudentEnrollmentExtension

InterchangeStaffAssociationExtension


InterchangeEducationOrganizationExtension

LocalEducationAgencyExtension

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

<LocalEducationAgency id="LEA_CCCDDD">

<StateOrganizationId>CCCDDD</StateOrganizationId>

</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-000A: DISTRICT-ID must be unique for each LEA.


SchoolExtension

Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
School
idLOC.CDSchool OptionsCode

<School id="SCH_SSS">

<StateOrganizationId>CCCDDDSSS</StateOrganizationId>

</School>


where SSS = LOC.CD
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
Rules (FATAL):
  • 10020-0005/30305-0003: The last three characters of CAMPUS-ID must be 001-698.
  • 10020-0012/30305-0003: CAMPUS-ID must match an entry registered with TEA as an active instructional campus.
  • 10020-000A: CAMPUS-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
ClassPeriodReferencerefLOC.CDSchool OptionsCode
MST.PDMaster SchedulePeriod

<School id="SCH_SSS">

<ClassPeriodReference ref="CP_SSS_p"/>
</School>


where:
  • SSS = LOC.CD
  • p = MST.PD 

One ClassPeriodReference for each ClassPeriod complex type


ClassPeriod

Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
ClassPeriodidLOC.CDSchool OptionsCode
MST.PDMaster SchedulePeriod
<ClassPeriod id="CP_SSS_p">

<ClassPeriodName>PP</ClassPeriodName>

</ClassPeriod>


where:

  • SSS = LOC.CD
  • p = MST.PD
E1074CLASS-PERIODClassPeriodNameNon-flex:
MST.PD
Master Schedule; Period
Flex:
FTF.TT, or
Flex PeriodsTiny Title
FTF.STIShort Title
<ClassPeriod id="CP_SSS_p">

<ClassPeriodName>PP</ClassPeriodName>

</ClassPeriod>


where XX = 

  • Non-flex schools: MST.PD 
  • Flex schools: FTF.TT if populated; otherwise first two characters of FTF.STI (zero padded)


Course

Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
E1089 (DC036)COURSE-IDENTIFICATION-SYSTEMIdentificationSystem
"LEA Course Code"
<Course>

<CourseCode IdentificationSystem="LEA course code">

<ID>CCCC</ID>

</CourseCode>

</Course>

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

<CourseCode IdentificationSystem="LEA course code">

<ID>CCCC</ID>

</CourseCode>

</Course>


where CCCC = CRS.CN
  • DR1: LOCAL-COURSE-CODE must be provided for non-PEIMS reporting.
E1089 (DC036)
COURSE-IDENTIFICATION-SYSTEM
IdentificationSystem
"State course code"
<Course>

<CourseCode IdentificationSystem="State course code">

<ID>SSSSSSSS</ID>

</CourseCode>

</Course>

  • GR1: For TSDS reporting, when reporting a SERVICE-ID, the IdentificationSystem should be "State course code".
E0724 (C022)
SERVICE-IDIDCRS.SVC
Courses > Other
Service ID
<Course>

<CourseCode IdentificationSystem="State course code">

<ID>SSSSSSSS</ID>

</CourseCode>

</Course>


where SSSSSSSS = CRS.SVC
  • DR1: SERVICE-ID (E0724) is used for TSDS (Class Roster, ECDS) and PEIMS reporting.
Rule (FATAL):
  • 30305-0004/50300-0004: SERVICE-ID must not begin with SA, SE, SR, SS, or 8.
EducationOrganizationReferencerefLOC.SCSchool OptionsCampus
<Course>

<EducationOrganizationReference ref="SCH_SSS"/>

</Course>


where SSS = LOC.SC


Program

  • For the Class Roster, a corresponding Program complex type should be reported if a ProgramReference is reported in LocalEducationAgencyExtension complex type.
Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
ProgramidSPR.CD *School ProgramsProgram Type 
<Program id="PGRM_XX">

<ProgramType>Program</ProgramType>

</Program>


where XX = SPR.CD

E1337 (DC096)PROGRAM-TYPEProgramType
SPR.CD * School ProgramsProgram Type
<Program id="PGRM_XX">

<ProgramType>Program</ProgramType>

</Program>


where Program = SPR.CD 

Full DC096 Code Translation is used rather than code.


InterchangeMasterScheduleExtension  

CourseOffering

  • 10050-000B: The combination of the following must be unique for each CourseOffering: SchoolReference and CourseReference.
Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
CourseOfferingidLOC.CDSchool OptionsCode
MST.CNMaster Schedule
Course
MST.SE
Section

<CourseOffering id="CourseOffering_SSS_CCCC_XXXX">

<LocalCourseCode>CCCC</LocalCourseCode>

</CourseOffering>


where XX:

  • SSS = LOC.CD
  • CCCC = MST.CN
  • XXXX = MST.SE
E1194
LOCAL-COURSE-CODE
LocalCourseCode MST.CNMaster ScheduleCourse

<CourseOffering id="CourseOffering_SSS_CCCC_XXXX">

<LocalCourseCode>CCCC</LocalCourseCode>

</CourseOffering>


where CCCC = MST.CN

  • DR1: LOCAL-COURSE-CODE must be provided for non-PEIMS reporting.
E0266
CAMPUS-ID
StateOrganizationId
LOC.CC + LOC.DC + LOC.SC
School OptionsCounty + District + Campus

<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-SYSTEM


IdentificationSystem
"LEA course code"

<CourseOffering id="CourseOffering_SSS_CCCC_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".
E1194
LOCAL-COURSE-CODE


IDCRS.CNCoursesCrsID#

<CourseOffering id="CourseOffering_SSS_CCCC_XXXX">

<CourseReference>

<CourseIdentity>

<CourseCode IdentificationSystem="LEA course code">

<ID>CCCC</ID>

</CourseCode>

</CourseIdentity>

</CourseReference>

</CourseOffering>


where CCCC = CRS.CN

  • DR1: LOCAL-COURSE-CODE must be provided for non-PEIMS reporting.


SectionExtension

  • 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.
  • 30305-0001: For each TeacherSectionAssociation, there must be a Course SectionExtension with a matching CAMPUS-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE. See Referential Integrity for Class Roster.
  • 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. See Referential Integrity for Class Roster.
  • 10050-000C/50300-000A: The combination of the following fields must be unique for each Course SectionExtension: CLASS-ID-NUMBER, CAMPUS-ID, and COURSE-SEQUENCE-CODE.
Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
E1056
CLASS-ID-NUMBER
UniqueSectionCode
LOC.CDSchool OptionsCode
MST.SEMaster ScheduleSection

<Section>

<UniqueSectionCode>CCCCCCCCCC_SSSS</UniqueSectionCode>

</Section>


where:

  • CCCCCCCCCC = LOC.CD (zero padded)
  • SSSS = MST.SE
E1362 (DC091)
POPULATION-SERVED
PopulationServedMST.PSVMaster SchedulePopulation Served

<Section>

<PopulationServed>Population</PopulationServed >

</Section>


where Population = MST.PSV

Full DC091 Code Translation is used rather than code.

Rules (FATAL):
  • 10050-0003: For a Course SectionExtension being reported for the Class Roster collection, POPULATION-SERVED and NON-CAMPUS-BASED-INSTRUCTION-CODE must not be blank.
  • 40110-0223: For each StudentSectionAssociation where NON-CAMPUS-BASED-INSTRUCTION-CODE on the corresponding Course SectionExtension is 00, there must be at least one TeacherSectionAssociation with a matching CAMPUS-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE.
CourseOfferingReferencerefLOC.CDSchool OptionsCode
MST.CNMaster ScheduleCourse
MST.SESection

<Section>

<CourseOfferingReference ref="CourseOffering_SSS_CCCC_SSSS"/>

</CourseOffering>

</Section>


where:

  • SSS = LOC.CD
  • CCCC = MST.CN
  • SSSS = MST.SE
E0266
CAMPUS-ID
StateOrganizationId
LOC.CC + LOC.DC + LOC.SC
School OptionsCounty + District + Campus

<Section>

<SchoolReference>

<EducationalOrgIdentity>

<StateOrganizationId>CCCDDDSSS</StateOrganizationId>

</EducationalOrgIdentity>

</SchoolReference>

</Section>


where:

  • CCC = LOC.CC
  • DDD = LOC.DC
  • SSS = LOC.SC
Special Warning:
  • 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.
E1074


CLASS-PERIOD


ClassPeriodName
Non-flex:
MST.PD
Master SchedulePeriod
Flex:
FTF.TT, or
Flex PeriodsTiny Title
FTF.STI Short 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
E0266
CAMPUS-ID
StateOrganizationId
LOC.CC + LOC.DC + LOC.SC
School OptionsCounty + District + Campus

<Section>

<StateOrganizationId>CCCDDDSSS</StateOrganizationId>

</Section>


where:

  • CCC = LOC.CC
  • DDD = LOC.DC
  • SSS = LOC.SC
E0948 (C135)


COURSE-SEQUENCE-CODE


TX-CourseSequence
CRS.CSQCourses > OtherCrs Seq

<Section>

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

</Section>


where X = CRS.CSQ

Rules (FATAL):
  • 30305-0012/50300-0006: If SERVICE-ID is a high school course, then COURSE-SEQUENCE-CODE must not be A.
E1072 (C182)NON-CAMPUS-BASED-INSTRUCTION-CODETX-NonCampusBasedInstructionCRS.NCI *
Courses > OtherNon-Campus Inst
<Section>

<TX-NonCampusBasedInstruction>XX</TX-NonCampusBasedInstruction>

</Section>


where XX = CRS.NCI

Rule (FATAL):
  • 10050-0003: For a Course Section being reported for the Class Roster collection, POPULATION-SERVED and NON-CAMPUS-BASED-INSTRUCTION-CODE must not be blank.


InterchangeStudentParentExtension  

StudentExtension

  • GR2: Students enrolled in the LEA in grades 1-12 as of the last Friday in September should be reported as part of the Class Roster Fall Submission.
  • 40100-0186: For a student being reported for the Class Roster collection, the following must not be blank: STUDENT-ID, SEX, HISPANIC-LATINO-ETHNICITY, and at least one RACIAL-CATEGORY.
  • 40100-0187/40110-0211: For each student reported by the LEA, there must be StudentSectionAssociation data with a matching TX-UNIQUE-STUDENT-ID. See Referential Integrity for Class Roster.
  • 40100-0197/40110-0001: For each student reported by the LEA, there must be enrollment (StudentSchoolAssociation) data with a matching TX-UNIQUE-STUDENT-ID. See Referential Integrity for Class Roster.
  • 40100-000A: The combination of the following fields must be unique for each student: DISTRICT-ID and TX-UNIQUE-STUDENT-ID.
  • 10020-0014: For each campus registered with TEA as an active instructional campus, there should be student data for each student served by the LEA.
Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
StudentidLOC.CDSchool OptionsCode
STU.IDDemographicsStudent ID
<Student id="SCID_SSS_XXXXXX">

</Student>


where:

  • SSS = LOC.CD
  • XXXXXX = STU.ID
E1523
TX-UNIQUE-STUDENT-ID
StudentUniqueStateId
STU.CIDDemographics > Student Data 2Unique ID

<Student id="SCID_SSS_XXXXXX">

<StudentUniqueStateId>UUUUUUUUUU</StudentUniqueStateId>

</Student>


where UUUUUUUUUU = STU.CID

Rules (FATAL):
  • 40100-0099: TX-UNIQUE-STUDENT-ID must match an entry in the TSDS Unique ID system.
  • 40100-0145: TX-UNIQUE-STUDENT-ID must not match TX-UNIQUE-STUDENT-ID for any other student reported for this LEA.
E1090 (DC126)STUDENT-IDENTIFICATION-SYSTEMIdentificationSystem"State"

<Student id="SCID_SSS_XXXXXX">

<StudentIdentificationCode IdentificationSystem="State">

<IdentificationCode>SSSSSSSSS</IdentificationCode>

</StudentIdentificationCode>

</Student>

Rule (FATAL):
  • 40100-0101: For reporting student data, STUDENT-IDENTIFICATION-SYSTEM for STUDENT-ID must be "State".
E0001STUDENT-IDIdentificationCodeESD.EDDemographics > Student Data 2Soc-Sec-Num/S-Number

<Student id="SCID_SSS_XXXXXX">

<StudentIdentificationCode IdentificationSystem="State">

<IdentificationCode>SSSSSSSSS</IdentificationCode>

</StudentIdentificationCode>

</Student>


where SSSSSSSSS = ESD.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", 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-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-SYSTEMIdentificationSystem
"District"

<Student id="SCID_SSS_XXXXXX">

<StudentIdentificationCode IdentificationSystem="District">

<IdentificationCode>XXXXXX</IdentificationCode>

</StudentIdentificationCode>

</Student>

  • DR2: When submitting the STUDENT-IDENTIFICATION-SYSTEM data element for LOCAL-STUDENT-ID, this value will equal “District”.
Rule (FATAL):
  • 40100-0106: For reporting a student's local ID data (such as to PEIMS), if LOCAL-STUDENT-ID is not blank, then STUDENT-IDENTIFICATION-SYSTEM for LOCAL-STUDENT-ID must be "District".
E0923LOCAL-STUDENT-IDIdentificationCodeSTU.IDDemographics
Student ID

<Student id="SCID_SSS_XXXXXX">

<StudentIdentificationCode IdentificationSystem="District">

<IdentificationCode>XXXXXX</IdentificationCode>

</StudentIdentificationCode>

</Student>


where XXXXXX = STU.ID

Rule (FATAL):
  • 40100-0106: For reporting a student's local ID data (such as to PEIMS), if LOCAL-STUDENT-ID is not blank, then STUDENT-IDENTIFICATION-SYSTEM for LOCAL-STUDENT-ID must be "District".
E0703FIRST-NAMEFirstNameSTU.FNDemographics
First Name

<Student id="SCID_SSS_XXXXXX">

<Name>

<FirstName>First</FirstName>

</Name>

</Student>


where First = STU.FN

Special Warnings:
  • 40100-0079: FIRST-NAME should not contain 0-9.
  • 40100-0080: FIRST-NAME should not end with JR, SR, I, II, III, IV, V, VI, VII, VIII, IX, or X (not case sensitive).
E0704MIDDLE-NAMEMiddleNameSTU.MNDemographics
Middle Name

<Student id="SCID_SSS_XXXXXX">

<Name>

<MiddleName>Middle</MiddleName>

</Name>

</Student>


where Middle = STU.MN

Special Warnings:
  • 40100-0079: MIDDLE-NAME should not contain 0-9.
  • 40100-0080: MIDDLE-NAME should not end with JR, SR, I, II, III, IV, V, VI, VII, VIII, IX, or X (not case sensitive).
E0705LAST-NAME LastSurnameSTU.LNDemographics
Last Name

<Student id="SCID_SSS_XXXXXX">

<Name>

<LastSurname>Last</LastSurname>

</Name>

</Student>


where Last = STU.LN

Special Warnings:
  • 40100-0079: LAST-NAME should not contain 0-9.
  • 40100-0080: LAST-NAME should not end with JR, SR, I, II, III, IV, V, VI, VII, VIII, IX, or X (not case sensitive).
E1303 (DC148)GENERATION-CODE-SUFFIXGenerationCodeSuffixSTU.SF *Demographics
Suffix

<Student id="SCID_SSS_XXXXXX">

<Name>

<GenerationCodeSuffix>X</GenerationCodeSuffix>
</Name>

</Student>


where X = STU.SF if present; otherwise omitted

E1325 (DC119)SEXSexSTU.GNDemographics
Gender

<Student id="SCID_SSS_XXXXXX">

<Sex>Gender</Sex>

</Student>


where Gender = STU.GN

Full DC119 Code Translation is used rather than code.

E0006 DATE-OF-BIRTHBirthDateSTU.BDDemographics
Birthdate

<Student id="SCID_SSS_XXXXXX">

<BirthData>

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

</BirthData>

</Student>


where YYYY-MM-DD = STU.BD

Rule (FATAL):
  • 40100-0017: DATE-OF-BIRTH must be a valid date.
E1375HISPANIC-LATINO-ETHNICITYHispanicLatinoEthnicitySTU.ETHDemographics
Ethnicity

<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.RC5Demographics
Race

<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.

E0212DISTRICT-IDStateOrganizationIdLOC.CC + LOC.DC
School 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

  • 40100-0197/40110-0001: For each student reported by the LEA, there must be enrollment (StudentSchoolAssociation) data with a matching TX-UNIQUE-STUDENT-ID. See Referential Integrity for Class Roster.
  • 40110-0224: For each StudentSectionAssociation, there must be a student enrollment (StudentSchoolAssociation) with a matching TX-STUDENT-UNIQUE-ID and CAMPUS-ID. See Referential Integrity for Class Roster.
  • 40110-000D: The combination of the following fields must be unique for each student Enrollment (StudentSchoolAssociation): TX-UNIQUE-STUDENT-ID, and CAMPUS-ID.
Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
E1523TX-UNIQUE-STUDENT-IDStudentUniqueStateIdSTU.CIDDemographics > Student Data 2
Unique ID

<StudentSchoolAssociation>

<StudentReference>

<StudentIdentity>

<StudentUniqueStateId>UUUUUUUUUU</StudentUniqueStateId>

</StudentIdentity>

</StudentReference>

</StudentSchoolAssociation>


where UUUUUUUUUU = STU.CID
E0266CAMPUS-IDStateOrganizationIdLOC.CC + LOC.DC + LOC.SC
School 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.

Rule (FATAL):
  • 40110-0214: For an enrollment (StudentSchoolAssociation) being reported for the Class Roster collection Fall submission, ENTRY-GRADE-LEVEL-TYPE must not be blank, and must be a valid value in the DC063 code table except for Early Education, Preschool/Prekindergarten, and Kindergarten.


StudentSectionAssociation

  • 40100-0187/40110-0211: For each student reported by the LEA, there must be StudentSectionAssociation data with a matching TX-UNIQUE-STUDENT-ID. See Referential Integrity for Class Roster.
  • 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. See Referential Integrity for Class Roster.
  • 40110-0224: For each StudentSectionAssociation, there must be a student enrollment (StudentSchoolAssociation) with a matching TX-STUDENT-UNIQUE-ID and CAMPUS-ID. See Referential Integrity for Class Roster.
  • 40110-000E/50300-000E: The 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.
  • 30305-0026: For each TeacherSectionAssociation, there should be at least one StudentSectionAssociation with a matching CAMPUS-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE. See Referential Integrity for Class Roster.
Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
E1523TX-UNIQUE-STUDENT-IDStudentUniqueStateIdSTU.CID
Demographics > Student Data 2
Unique ID

<StudentSectionAssociation>

<StudentReference>

<StudentIdentity>

<StudentUniqueStateId>UUUUUUUUUU</StudentUniqueStateId>

</StudentIdentity>

</StudentReference>

</StudentSectionAssociation>


where UUUUUUUUUU = STU.CID

E0266
CAMPUS-ID
StateOrganizationId
LOC.CC + LOC.DC + LOC.SC
School Options
County + District + Campus

<StudentSectionAssociation>

<SectionReference>

<SectionIdentity>

<StateOrganizationId>CCCDDDSSS</StateOrganizationId>

</SectionIdentity>

</SectionReference>

</StudentSectionAssociation>


where:

  • CCC = LOC.CC
  • DDD = LOC.DC
  • SSS = LOC.SC
E1056
CLASS-ID-NUMBER
UniqueSectionCode
LOC.CDSchool Options
Code
MST.SE
Master ScheduleSection

<StudentSectionAssociation>

<SectionReference>

<SectionIdentity>

<UniqueSectionCode>CCCCCCCCCC_SSSS</UniqueSectionCode>

</SectionIdentity>

</SectionReference>

</StudentSectionAssociation>


where:

  • CCCCCCCCCC = LOC.CD (zero padded) 
  • SSSS = MST.SE
E1069
STUDENT-BEGIN-DATE
BeginDate
CAR.DSCourse AttendanceStart Date

<StudentSectionAssociation>

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

</StudentSectionAssociation>


where YYYY-MM-DD = CAR.DS

Rules (FATAL):
  • 40110-0081/50300-0011: For a StudentSectionAssociation, STUDENT-END-DATE must be greater than or equal to STUDENT-BEGIN-DATE.
  • 40110-0165: STUDENT-BEGIN-DATE must be between June 1, 2021 and August 31, 2022.
  • 40110-0163: STUDENT-BEGIN-DATE must be a valid date.
E1070
STUDENT-END-DATE
EndDate
CAR.DECourse AttendanceStop Date

<StudentSectionAssociation>

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

</StudentSectionAssociation>


where YYYY-MM-DD = CAR.DE

Rules (FATAL):
  • 40110-0081/50300-0011: For a StudentSectionAssociation, STUDENT-END-DATE must be greater than or equal to STUDENT-BEGIN-DATE.
  • 40110-0166: STUDENT-END-DATE must be between June 1, 2021 and August 31, 2022.
  • 40110-0164: STUDENT-END-DATE must be a valid date.
E0948 (C136)
COURSE-SEQUENCE-CODE
TX-CourseSequence
CRS.CSQ
Courses > OtherCrs Seq

<StudentSectionAssociation>

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

</StudentSectionAssociation>


where X = CRS.CSQ

Rules (FATAL):
  • 30305-0012/50300-0006: If SERVICE-ID is a high school course, then COURSE-SEQUENCE-CODE must not be A.


InterchangeStaffAssociationExtension  

StaffExtension

  • GR1: Fall Submission: Only LEA-employed or contracted staff serving an LEA as of the last Friday in September who have a ROLE-ID 087 (Teacher) or ROLE-ID 047 (Long-term Substitute Teacher) should be reported.
  • GR1: Winter Submission: Only LEA-employed or contracted staff serving an LEA as of the last Friday in February who have a ROLE-ID 087 (Teacher) or ROLE-ID 047 (Long-term Substitute Teacher) should be reported.
  • 30305-0002: TX-UNIQUE-STAFF-ID for a TeacherSectionAssociation must match TX-UNIQUE-STAFF-ID for a staff person. See Referential Integrity for Class Roster.
  • 30040-000C: The combination of the following fields must be unique for each staff person: TX-UNIQUE-STAFF-ID and DISTRICT-ID.
  • 10020-0028: For each campus registered with TEA as an active instructional campus (except JJAEPs), there should be data for each teacher.
  • 30040-0052: For a staff person being reported for the Class Roster collection, the following must not be blank: STAFF-ID, SEX, DATE-OF-BIRTH, HISPANIC-LATINO-ETHNICITY, HIGHEST-LEVEL-OF-EDUCATION-COMPLETED, YEARS-OF-PRIOR-TEACHING-EXPERIENCE, and at least one RACIAL-CATEGORY.
Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
Staff
idLOC.CDSchool OptionsCode
STF.IDStaffLocal Staff ID

<Staff id="STF_SSS_NNNNNN">

<StaffUniqueStateId>UUUUUUUUU</StaffUniqueStateId>

</Staff>


where:

  • SSS = LOC.CD
  • NNNNNN = STF.ID
E1524
TX-UNIQUE-STAFF-ID
StaffUniqueStateId
STF.SIDStaffUnique ID

<Staff id="STF_SSS_NNNNNN">

<StaffUniqueStateId>UUUUUUUUU</StaffUniqueStateId>

</Staff>


where UUUUUUUUU = STF.SID

Rules (FATAL):
  • 30040-0038: TX-UNIQUE-STAFF-ID must match an entry in the TSDS Unique ID system.
  • 30040-0047: TX-UNIQUE-STAFF-ID must not match TX-UNIQUE-STAFF-ID for any other staff person reported for this LEA.
E1088 (C191)
STAFF-IDENTIFICATION-SYSTEM
StaffIdentificationCode IdentificationSystem
"State"
<Staff id="STF_SSS_NNNNNN">

<StaffIdentificationCode IdentificationSystem="State">

<ID>XXXXXXXXX</ID>

</StaffIdentificationCode>

</Staff>

  • DR1: The STAFF-IDENTIFICATION-SYSTEM will always be reported with a value of “State” to identify the state STAFF-ID for the staff member.
Rule (FATAL):
  • 30040-0027: For reporting a staff's Social Security number data with STAFF-ID (such as to PEIMS), STAFF-IDENTIFICATION-SYSTEM must be "State".
E1505
STAFF-ID
IDSTF.SSStaff

Social Security #

<Staff id="STF_SSS_NNNNNN">

<StaffIdentificationCode IdentificationSystem="State">

<ID>XXXXXXXXX</ID>

</StaffIdentificationCode>

</Staff>


where XXXXXXXXX = STF.SS

Rules (FATAL):
  • 30040-0028: If STAFF-IDENTIFICATION-SYSTEM is "State", each character of STAFF-ID must not be the same number.
  • 30040-0029: If STAFF-IDENTIFICATION-SYSTEM is "State", the first three characters of STAFF-ID must be between 001-899 (excluding 666), the fourth and fifth characters must be between 01-99, and the last four characters must be between 0001-9999.
  • 30040-0030: If STAFF-IDENTIFICATION-SYSTEM is "State", then STAFF-ID must be 9 numeric characters.
E0703


FIRST-NAME


FirstName
STF.FN
StaffFirst Name

<Staff id="STF_SSS_NNNNNN">

<Name>

<FirstName>FirstName</FirstName>

</Name>

</Staff>


where FirstName = STF.FN

Special Warning:
  • 30040-0022: FIRST-NAME should not end with JR, SR, I, II, III, IV, V, VI, VII, VIII, IX, or X (not case sensitive).
E0704


MIDDLE-NAME


MiddleName
STF.MNStaffMiddle Name

<Staff id="STF_SSS_NNNNNN">

<Name>

<MiddleName>MiddleName</MiddleName>

</Name>

</Staff>


where MiddleName = STF.MN

Omitted if blank.

Special Warning:
  • 30040-0022: MIDDLE-NAME should not end with JR, SR, I, II, III, IV, V, VI, VII, VIII, IX, or X (not case sensitive).
E0705 


LAST-NAME


LastSurname
STF.LNStaffLast Name

<Staff id="STF_SSS_NNNNNN">

<Name>

<LastSurname>LastName</LastSurname>

</Name>

</Staff>


where

Special Warning:
  • 30040-0022: LAST-NAME should not end with JR, SR, I, II, III, IV, V, VI, VII, VIII, IX, or X (not case sensitive).
E1303 (DC148)


GENERATION-CODE-SUFFIX


GenerationCodeSuffix
STF.SFStaffSuffix

<Staff id="STF_SSS_NNNNNN">

<Name>

<GenerationCodeSuffix>Suffix</GenerationCodeSuffix>

</Name>

</Staff>


where Suffix = STF.SF

Full DC148 Code Translation is used rather than code.

E1325 (DC119)


SEX

SexSTF.SXStaffSex

<Staff id="STF_SSS_NNNNNN">

<Sex>Sex</Sex>

</Staff>


where Sex = STF.SX

Full DC119 Code Translation is used rather than code.

E0006


DATE-OF-BIRTH


BirthDate
STF.BDStaffBirthdate

<Staff id="STF_SSS_NNNNNN">

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

</Staff>


where YYYY-MM-DD = STF.BD

Rule (FATAL):
  • 30040-0007: DATE-OF-BIRTH must be a valid date.
E1375
HISPANIC-LATINO-ETHNICITY
HispanicLatinoEthnicity
STF.ECStaffEthnicity

<Staff id="STF_SSS_NNNNNN">

<HispanicLatinoEthnicity>true/false</HispanicLatinoEthnicity>

</Staff>


where true/false = 

  • 'true' if STF.EC = Y, or
  • 'false' if STF.EC = N
E1343 (DC097)


RACIAL-CATEGORY


RacialCategory
STF.RC1 - STF.RC5StaffRace-Race5

<Staff id="STF_SSS_NNNNNN">

<Race>

<RacialCategory>Race</RacialCategory>

</Race>

</Staff>


where Race = 

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

One entry for each race associated with the employee.

Full DC097 Code Translation is used rather than code.

E1460 (DC077)
HIGHEST-LEVEL-OF-EDUCATION-COMPLETED
HighestLevelOfEducationCompleted
STF.ELStaffEducation Lvl

<Staff id="STF_SSS_NNNNNN">

<HighestLevelOfEducationCompleted>Level</HighestLevelOfEducationCompleted>

</Staff>


where Level = STF.EL

Full DC077 Code Translation is used rather than code.
E1377
YEARS-OF-PRIOR-TEACHING-EXPERIENCE
YearsOfPriorTeachingExperience
STF.TYSStaff

Total Years of Edu Service

<Staff id="STF_SSS_NNNNNN">

<YearsOfPriorTeachingExperience>NN</YearsOfPriorTeachingExperience >

</Staff>


where NN = STF.TYS

E0212


DISTRICT-ID


StateOrganizationId
LOC.CC + LOC.DC
School OptionsCounty + District

<Staff id="STF_SSS_NNNNNN">

<TX-LEAReference>

<EducationalOrgIdentity>

<StateOrganizationId>CCCDDD</StateOrganizationId>

</EducationalOrgIdentity>

</TX-LEAReference>

</Staff>


where:
  • CCC = LOC.CC
  • DDD = LOC.DC 
E1073 (C181)
STAFF-TYPE-CODE
TX-StaffTypeCode
Not reported from Aeries

Not required for TSDS

E1721CREDITABLE-YEAR-OF-SERVICE-INDICATOR-CODETX-CreditableYearOfServiceIndicator



Rules (FATAL):
  • 30040-0058: If at least one TEACHER-INCENTIVE-ALLOTMENT-DESIGNATION-CODE is reported for a staff person, then CREDITABLE-YEAR-OF-SERVICE-INDICATOR-CODE must not be blank.
  • 30305-0027: If ROLE-ID is 047, then TEACHER-INCENTIVE-ALLOTMENT-DESIGNATION-CODE and CREDITABLE-YEAR-OF-SERVICE-INDICATOR-CODE must not be reported.
E1722TEACHER-INCENTIVE-ALLOTMENT-DESIGNATION-CODETX-TeacherIncentiveAllotmentDesignationCode



Rules (FATAL):
  • 30040-0054: If TEACHER-INCENTIVE-ALLOTMENT-DESIGNATION-CODE is not reported, then Teacher Class Assignment (TeacherSectionAssociation) data must be reported with a matching TX-UNIQUE-STAFF-ID.
  • 30040-0055: If TEACHER-INCENTIVE-ALLOTMENT-DESIGNATION-CODE is reported, then there must be a TeacherSchoolAssociation or a TeacherSectionAssociation with a matching TX-UNIQUE-STAFF-ID.
  • 30040-0056: If TEACHER-INCENTIVE-ALLOTMENT-DESIGNATION-CODE is not reported, then there must not be a TeacherSchoolAssociation reported for this TX-UNIQUE-STAFF-ID.
  • 30040-0058: If at least one TEACHER-INCENTIVE-ALLOTMENT-DESIGNATION-CODE is reported for a staff person, then CREDITABLE-YEAR-OF-SERVICE-INDICATOR-CODE must not be blank.
  • 30305-0027: If ROLE-ID is 047, then TEACHER-INCENTIVE-ALLOTMENT-DESIGNATION-CODE and CREDITABLE-YEAR-OF-SERVICE-INDICATOR-CODE must not be reported.
  • 30310-0001: For a TeacherSchoolAssociation, there must be a staff person with a matching TX-UNIQUE-STAFF-ID and at least one TEACHER-INCENTIVE-ALLOTMENT-DESIGNATION-CODE.


TeacherSectionAssociationExtension

  • GR1: LEA-employed or contracted teaching staff (ROLE-IDs 087 Teacher 047 Long-term Substitute Teacher) should be reported for the Class Roster Fall Submission and the Class Roster Winter Submission.
    • For the Class Roster Fall Submission, report TeacherSectionAssociationExtension for all teachers of courses offered in grades 1-12 as of the last Friday in September.
    • For the Class Roster Winter Submission, report TeacherSectionAssociationExtension for all teachers of courses offered in grades EE-12 as of the last Friday in February.
  • 30305-0001: For each TeacherSectionAssociation, there must be a Course SectionExtension with a matching CAMPUS-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE. See Referential Integrity for Class Roster.
  • 30305-0002: TX-UNIQUE-STAFF-ID for a TeacherSectionAssociation must match TX-UNIQUE-STAFF-ID for a staff person. See Referential Integrity for Class Roster.
  • 30305-0024: For a TeacherSectionAssociation being reported for the Class Roster collection, the following must not be blank: CLASSROOM-POSITION, ASSIGNMENT-BEGIN-DATE, and ROLE-ID.
  • 40110-0223: For each StudentSectionAssociation where NON-CAMPUS-BASED-INSTRUCTION-CODE on the corresponding Course SectionExtension is 00, there must be at least one TeacherSectionAssociation with a matching CAMPUS-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE.
  • 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.
  • 30305-0026: For each TeacherSectionAssociation, there should be at least one StudentSectionAssociation with a matching CAMPUS-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE. See Referential Integrity for Class Roster.
  • 30040-0054: If TEACHER-INCENTIVE-ALLOTMENT-DESIGNATION-CODE is not reported, then Teacher Class Assignment (TeacherSectionAssociation) data must be reported with a matching TX-UNIQUE-STAFF-ID.
  • 30040-0055: If TEACHER-INCENTIVE-ALLOTMENT-DESIGNATION-CODE is reported, then there must be a TeacherSchoolAssociation or a TeacherSectionAssociation with a matching TX-UNIQUE-STAFF-ID.
  • 30305-0028: If both TeacherSchoolAssociation and TeacherSectionAssociation data are reported with matching TX-UNIQUE-STAFF-ID but different CAMPUS-ID values, then a special warning message will be displayed asking for verification of this teacher’s assignments.


Element ID & Code TableData ElementXML NameAeries Table.FieldAeries PageLabel
E1524
TX-UNIQUE-STAFF-ID
StaffUniqueStateId
STF.SIDStaffUnique ID

<TeacherSectionAssociation>

<TeacherReference>

<StaffIdentity>

<StaffUniqueStateId>UUUUUUUUU</StaffUniqueStateId>

</StaffIdentity>

</TeacherReference>

</TeacherSectionAssociation>


where UUUUUUUUU = STF.SID

E0266
CAMPUS-ID
StateOrganizationId
LOC.CC + LOC.DC + LOC.SC
School OptionsCounty + District + Campus

<TeacherSectionAssociation>

<SectionReference>

<SectionIdentity>

<StateOrganizationId>CCCDDDSSS</StateOrganizationId>

</SectionIdentity>

</SectionReference>

</TeacherSectionAssociation>


where:

  • CCC = LOC.CC
  • DDD = LOC.DC
  • SSS = LOC.SC
Special Warning:
  • 10020-0023: For each campus registered with TEA as an active regular instructional campus, there should be at least one teacher class assignment (TeacherSectionAssociation) with a matching CAMPUS-ID.
E1056 


CLASS-ID-NUMBER


UniqueSectionCode
LOC.CDSchool OptionsCode
MST.CN + "_"Master ScheduleCourse
MST.SESection

<TeacherSectionAssociation>

<SectionReference>

<SectionIdentity>

<UniqueSectionCode>XXXXX_CCCC_SSSS</UniqueSectionCode>

</SectionIdentity>

</SectionReference>

</TeacherSectionAssociation>


where:

  • XXXXX = LOC.CD (zero padded)
  • CCCC = MST.CN
  • SSSS = MST.SE
E1454 (DC143)
CLASSROOM-POSITION

ClassroomPosition
MST.TP1
Master SchedulePosition

<TeacherSectionAssociation>

<ClassroomPosition>Position</ClassroomPosition>

</TeacherSectionAssociation>


where Position = MST.TP1

Full DC143 Code Translation is used rather than code.

E1065


ASSIGNMENT-BEGIN-DATE


BeginDate
Non-Flex:
CAR.DS
Course AttendanceStart Date
Flex:
SSM.SD
Master Schedule - Section StaffStart Date

<TeacherSectionAssociation>

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

</TeacherSectionAssociation>


where YYYY-MM-DD =

  • Non-flex: CAR.SD
  • Flex: SSM.SD
Rules (FATAL):
  • 30305-0008: ASSIGNMENT-BEGIN-DATE must be between June 1, 2021 and August 31, 2022.
  • 30305-0007: ASSIGNMENT-BEGIN-DATE must be a valid date.
E1066   


ASSIGNMENT-END-DATE


EndDate
Non-Flex:
CAR.DE
Course Attendance
Stop Date
Flex:
SSM.ED
Master Schedule - Section StaffEnd Date

<TeacherSectionAssociation>

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

</TeacherSectionAssociation>


where YYYY-MM-DD =

  • Non-flex: CAR.DE
  • Flex:  SSM.ED

Rules (FATAL):

  • 30305-0010: 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-0009: ASSIGNMENT-END-DATE must be a valid date.
E0948 (C135)


COURSE-SEQUENCE-CODE


TX-CourseSequence
CRS.CSQCourses > OtherCrs Seq

<TeacherSectionAssociation>

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

</TeacherSectionAssociation>


where X = CRS.CSQ

Rules (FATAL):
  • 30305-0012/50300-0006: If SERVICE-ID is a high school course, then COURSE-SEQUENCE-CODE must not be A.
E0721 (C021)
ROLE-ID
TX-StaffRole
STJ.JCStaff > Job AssignmentsRole Description
<TeacherSectionAssociation>

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

</TeacherSectionAssociation>


where XXX = STJ.JC

Rules (FATAL):
  • 30040-0002: For each staff person (role IDs 047 and 087), Teacher Class Assignment (TeacherSection Association) data must be reported with a matching TX-UNIQUE-STAFF-ID.
  • 30305-0006: ROLE-ID must be 047 or 087.


* Must be mapped on Texas State Reporting > Code Translations