texas education data standards (teds)castro.tea.state.tx.us/tsds/teds/2016a/v2.0/tsds_august... ·...

Texas Education Data Standards (TEDS) 2015-2016 Change Post Addendum Version 2016.A.2.0 August 31, 2015 Prepared by: State Education Data Systems (SEDS) Team

August 2015 Version 2016.A.2.0 i

Contents Document History ................................................................................................................................................................................................................................................... ii Section 1 – Data Submission Specifications & Responsibilities ............................................................................................................................................................................. 3 Section 2 – Data Submission Requirements .......................................................................................................................................................................................................... 3

Section 2.1 Education Organization Category ................................................................................................................................................................................................... 3 Section 2.2 Finance Organization Category ...................................................................................................................................................................................................... 3 Section 2.3 Staff Category ................................................................................................................................................................................................................................. 3 Section 2.4 Student Category ............................................................................................................................................................................................................................ 4

Section 3 – Description of Data Elements .............................................................................................................................................................................................................. 5 Section 3.1 Education Organization Category ................................................................................................................................................................................................... 5 Section 3.3 Staff Category ................................................................................................................................................................................................................................. 5 Section 3.4 Student Category ............................................................................................................................................................................................................................ 6

Section 4 – Description of Codes ........................................................................................................................................................................................................................... 7 Section 5 – Business Rules and Validations ........................................................................................................................................................................................................ 10 Section 6 – Ed-Fi Core & TX Core Extension Schemas ...................................................................................................................................................................................... 11 Section 7 – Interchange Schemas ........................................................................................................................................................................................................................ 12

Section 7.1 InterchangeEducationOrganizationExtension .............................................................................................................................................................................. 12 Section 7.4 InterchangeStudentExtension ...................................................................................................................................................................................................... 12 Section 7.5 InterchangeStudentParentExtension ............................................................................................................................................................................................ 12 Section 7.6 InterchangeStudentEnrollmentExtension ..................................................................................................................................................................................... 13 Section 7.9 InterchangeStudentDisciplineExtension ....................................................................................................................................................................................... 13 Section 7.11 InterchangeStudentProgramExtension ....................................................................................................................................................................................... 13

Section 8.1 – PEIMS Data Submission Specifications & Responsibilities ........................................................................................................................................................... 15 Section 8.2 – PEIMS Data Submission Requirements ......................................................................................................................................................................................... 15

Section 8.2.1 PEIMS Education Organization Category ................................................................................................................................................................................. 15 Section 8.2.3 PEIMS Staff Category................................................................................................................................................................................................................ 15 Section 8.2.4 PEIMS Student Category .......................................................................................................................................................................................................... 15 Section 8.2.5 PEIMS Campus Course Section Category ................................................................................................................................................................................ 16

Section 8.3 – PEIMS Description of Data Elements ............................................................................................................................................................................................. 16 Section 8.3.1 PEIMS Education Organization Category ................................................................................................................................................................................. 16 Section 8.3.3 PEIMS Staff Category................................................................................................................................................................................................................ 17 Section 8.3.4 PEIMS Student Category .......................................................................................................................................................................................................... 17 Section 8.3.5 PEIMS Campus Course Section Category Description of Data Elements ................................................................................................................................ 18

August 2015 Version 2016.A.2.0 ii

Section 8.4 – PEIMS Description of Codes .......................................................................................................................................................................................................... 19 Section 8.5 – PEIMS Business Rules and Validations ......................................................................................................................................................................................... 21 Section 8.6 – Ed-Fi Core & TX Core Extension Schemas ................................................................................................................................................................................... 22 Ed-Fi Core Schema .............................................................................................................................................................................................................................................. 22 TX-Core Extension Schema ................................................................................................................................................................................................................................. 22 Section 8.7 – PEIMS Interchange Schemas ........................................................................................................................................................................................................ 23

Section 8.7.1 PEIMS InterchangeEducationOrganizationExtension ............................................................................................................................................................... 23 Section 8.7.3 PEIMS InterchangeStudentExtension ....................................................................................................................................................................................... 23 Section 8.7.4 PEIMS InterchangeStudentEnrollment ...................................................................................................................................................................................... 23 Section 8.7.7 PEIMS InterchangeStudentDisciplineExtension ........................................................................................................................................................................ 24

Section 10 – Data Collections ............................................................................................................................................................................................................................... 25 Early Childhood Data System – Section 10 ..................................................................................................................................................................................................... 25 Early Childhood Data System - Collection Spreadsheet ................................................................................................................................................................................. 25

TEDS Appendices ................................................................................................................................................................................................................................................ 25 PEIMS Appendices ............................................................................................................................................................................................................................................... 25

Document History

Date Description

August 31, 2015 Change log created

August 2015 Version 2016.A.2.0 3

TSDS TEDS 2015-2016 Post Addendum Version Change The following is a list of changes made from the Addendum Version 2016.A.1.0 published July 1, 2015 to the Post Addendum Version 2016A.2.0 published August 31, 2015.

Section 1 – Data Submission Specifications & Responsibilities

Section 2 – Data Submission Requirements

Section 2.1 Education Organization Category

Element ID Data Element XML Name Description of Changes

SchoolExtension Complex Type

E1561 NUMBER-OF-STUDENTS-REVIEWED-BY-IGC TX-NumberOfStudentsReviewedByIGC Added new data element

E1555 PK-SCHOOL-TYPE TX-PKSchoolType Deleted data element

Section 2.2 Finance Organization Category

SharedServiceArrangementExtension Complex Type

Updated reporting requirements to be consistent with Legacy PEIMS.

Section 2.3 Staff Category


StaffExtension Complex Type

E0505 STAFF-ID ID Updated business rules


Section 2.4 Student Category


StudentGraduationProgramExtension Complex Type

E1563 INDIVIDUAL-GRADUATION-COMMITTEE-REVIEW-CODE

TX-IndividualGraduationCommitteeReviewIndicator

Added new data element

StudentExtension Complex Type

E0984 MIGRANT-INDICATOR-CODE TX-MigrantIndicator Updated business rules

E1082 HOMELESS-STATUS-CODE TX-HomelessStatus Updated business rules

E1528 FOSTER-CARE-INDICATOR-CODE TX-FosterCareIndicator Updated business rules

E0792 LEP-INDICATOR-CODE TX-LEPIndicator Updated business rules

SchoolLeaverExtension Complex Type

E1562 INDIVIDUAL-GRADUATION-COMMITTEE-GRADUATE-CODE

TX-IndividualGraduationCommitteeGraduateIndicator


DisciplineIncidentExtension Complex Type

E0782 CAMPUS-ID-OF-ENROLLMENT TX-CampusIdOfEnrollment Added to Complex Type

StudentDisciplineIncidentAssociationExtension Complex Type


E0782 CAMPUS-ID-OF-ENROLLMENT TX-CampusIdOfEnrollment Removed Sub. 3 PEIMS mandatory designation

StudentSpecialEdProgramAssociationExtension Complex Type

E0041 PRIMARY-DISABILITY-CODE TX-PrimaryDisability Updated business rules

StudentProgramExtension Complex Type

E0782 CAMPUS-ID-OF-ENROLLMENT TX-CampusIdOfEnrollment Set PEIMS mandatory designation for Sub. 3

StudentSchoolAssociationExtension Complex Type

E1555 PK-SCHOOL-TYPE TX-PKSchoolType Added data element

Section 3 – Description of Data Elements

Section 3.1 Education Organization Category





Section 3.3 Staff Category



Section 3.4 Student Category



E0782 CAMPUS-ID-OF-ENROLLMENT TX-CampusIdOfEnrollment Set PEIMS mandatory designation for Sub. 3






E0782 CAMPUS-ID-OF-ENROLLMENT TX-CampusIDOfEnrollment Added new data element




E0782 CAMPUS-ID-OF-ENROLLMENT TX-CampusIdOfEnrollment Designated as mandatory for PEIMS Sub. 3


E1555 PK-SCHOOL-TYPE TX-PKSchooltype Added data element


Section 4 – Description of Codes

Code Table ID

Code Table Name XML Name Description of Changes

C022 SERVICE-ID IdentificationCode Added Service Id’s: 03102530 Statistics 02890000 Music, General Music 6 13018000 Financial Math C022 SERVICE-ID IdentificationCode Deleted Service Id’s: C022 SERVICE-ID IdentificationCode Revised Service Id’s: Correct service id: ‘N114001’ to ‘N1140001’ Correct description, short description., and abbreviation – I3010201 Correct description – 03254000 ‘ IIV’ to ‘IV’ Correct description – 03834700 to ‘Dance III, Dance History I’ Correct description – 03834800 to ‘Dance IV, Dance History II’ Correct description – 03252400 ‘Tichnical’ to ‘Technical’ Correct abbreviation – N1300993 Video Game Design 1 – ‘VIDEOGD’ TO VIDEOGD1’ Correct description – N1290001 to ‘Advancement Via Individual Determination I’ Correct description – N1290002 to ‘Advancement Via Individual Determination II’ Correct description – N1290030 to ‘Advancement Via Individual Determination III’ Correct description – N1290037 to ‘Strength Bank: A Relationship Initiative” C062 GRADUATION-TYPE-CODE TX-GraduationTypeCodeType Revised Code 04 Translation

Revised Code 05 Translation



Revised code ‘18’ Translation

Add new code ‘35’






Code Table ID


C164 DISCIPLINARY-ACTION-CODE

TX-DisciplinaryActionCodeType Delete code ‘16’ Truancy (failure to attend school) charges filed in Juvenile Municipal or Justice of the Peace court and a fine was assessed

Delete code ‘17’ Truancy ((failure to attend school) charges filed in Juvenile Municipal or Justice of the Peace court and no fine was assessed

Add code ‘29’ Truancy Complaint Filed in Truancy Court (includes County Court, Justice of the Peace Court, or Municipal Court)

C165 DISCIPLINARY-ACTION-REASON-CODE

TX-DisciplinaryActionReasonType Revise code ‘11’ translation

Revise code ‘12’ translation



Delete code ‘43’

Revise code ‘44’ citation


C192 UNACCOMPANIED-YOUTH-STATUS-CODE

TX-UnaccompaniedYouthStatusType Revised Code 4: Homeless Student is not in the physical custody of a parent or legal guardian (i.e., homeless student is not unaccompanied) at any time during the school year.

C201 INDIVIDUAL-GRADUATION-COMMITTEE-CODE

TX-IndividualGraduationCommitteeType

New Code Table

00 Not Applicable

01 IGC Reviewed (Submission 3 Only)

02 IGC Graduate (Submission 1 Only)

DC152 PK-SCHOOL-TYPE TX-PKSchoolType Revised code ’01 – ‘Non-Public Pre-K Head Start’

Revised code ‘02’ – Public Pre-K

Revised code ‘05’ – Non-Public Pre-K Licensed Child Care

Revised code ‘07’ - Public Pre-K Head Start

Revised code ‘08’ - Public Pre-K Licensed Child Care


Section 5 – Business Rules and Validations

Rule # Edit # Description of Change 10020-0031 02017 New rule 30040-0039 04313 Revision: Removed DATE-OF-BIRTH; Changed "but ANY of the four...do NOT match" to "but two or three of the

three...do NOT match" 30060-0016 0601E Missing from some publications of TEDS. Please verify implementation. 40100-0100 10210 Revision: Changed "but ANY...do NOT match" to "but three or four...do NOT match" 40110-000H Revision: Removed Submission 3 40110-000K Revision: Added CAMPUS-ID-OF-ENROLLMENT 40110-000V New rule 40203-0004 20307 Revision: Added INDIVIDUAL-GRADUATION-COMMITTEE-GRADUATE-CODE 40203-0005 20308 Revision: Added INDIVIDUAL-GRADUATION-COMMITTEE-GRADUATE-CODE 40203-0006 20313 Revision: Added GRADUATION-TYPE-CODE 57; revised Business Meaning 40203-0010 Revision: Added GRADUATION-TYPE-CODEs 54 – 57 40203-0011 Revision: Added GRADUATION-TYPE-CODEs 54 – 57 40203-0018 20342 New rule 40203-0019 20343 New rule 40203-0020 20344 New rule 42400-0033 40010 Revision: Corrected error level from Fatal to Warning 42401-0006 40075 Revision: Removed "on any of this Basic Attendance", no change in logic. 42405-0030 40535 Revision: Corrected "a 410 record" to "Career and Technical Education Attendance" 44425-000D Revision: Added "The combination of the following fields" and "CAMPUS-ID-OF-ENROLLMENT". CAMPUS-ID-OF-

ENROLLMENT is added to the key for this complex type. 44425-000E Revision: Added CAMPUS-ID-OF-ENROLLMENT 44425-000H Revision: Removed CAMPUS-ID-OF-ENROLLMENT 44425-0016 42515 Revision: Removed DISCIPLINARY-ACTION-CODEs 16 and 17; Added DISCIPLINARY-ACTION-CODE 29 44425-0019 42557 Revision: Removed DISCIPLINARY-ACTION-CODEs 16 and 17; Added DISCIPLINARY-ACTION-CODE 29; Removed

DISCIPLINARY-ACTION-REASON-CODE 43; Revised Business Meaning 44425-0020 42565 Revision: Removed DISCIPLINARY-ACTION-REASON-CODE 43; Removed DISCIPLINARY-ACTION-CODEs 16 and

17; Added DISCIPLINARY-ACTION-CODE 29; Revised Business Meaning 44425-0021 42561 Revision: Removed DISCIPLINARY-ACTION-CODEs 16 and 17; Added DISCIPLINARY-ACTION-CODE 29; Revised

Business Meaning 44425-0037 42526 Revision: Removed DISCIPLINARY-ACTION-REASON-CODE 43 44425-0050 42576 Revision: Removed DISCIPLINARY-ACTION-REASON-CODE 43 44425-0055 42581 Revision: Removed DISCIPLINARY-ACTION-REASON-CODE 43 44425-0059 42585 Revision: Removed DISCIPLINARY-ACTION-REASON-CODE 50; Revised Business Meaning 44425-0061 42587 Revision: Removed DISCIPLINARY-ACTION-REASON-CODE 43; Changed “12-17 years old” to “12-18 years old”;

Revised Business Meaning 44425-0064 42590 Revision: Removed DISCIPLINARY-ACTION-REASON-CODE 43; Revised Business Meaning 48011-0002 Revision: Added GRADUATION-TYPE-CODEs 54 – 57 48011-0015 20345 New rule 48011-0016 20346 New rule


Section 6 – Ed-Fi Core & TX Core Extension Schemas

TX-Core Extension Schema







Added data element


E0782 CAMPUS-ID-OF-ENROLLMENT TX-CampusIdOfEnrollment Added new data element

StudentDisciplineisciplineIncidentExtension Complex Type













Section 7 – Interchange Schemas

Section 7.1 InterchangeEducationOrganizationExtension





Section 7.4 InterchangeStudentExtension



StudentCharacteristics Complex Type

Section 7.5 InterchangeStudentParentExtension




Section 7.6 InterchangeStudentEnrollmentExtension





Added to Complex Type



Section 7.9 InterchangeStudentDisciplineExtension






Section 7.11 InterchangeStudentProgramExtension




Section 8.1 – PEIMS Data Submission Specifications & Responsibilities

Section 8.2 – PEIMS Data Submission Requirements

Section 8.2.1 PEIMS Education Organization Category





Section 8.2.3 PEIMS Staff Category


StaffExtension Complex Type

E0505 STAFF-ID ID Updated business rules

Section 8.2.4 PEIMS Student Category













StudentSpecialEdProgramAssociationExtension Complex Type

E0041 PRIMARY-DISABILITY-CODE TX-PrimaryDisablity Updated business rules



Section 8.2.5 PEIMS Campus Course Section Category


Section 8.3 – PEIMS Description of Data Elements

Section 8.3.1 PEIMS Education Organization Category






Section 8.3.3 PEIMS Staff Category


Section 8.3.4 PEIMS Student Category











Added data element to Complex Type








Section 8.3.5 PEIMS Campus Course Section Category Description of Data Elements



Section 8.4 – PEIMS Description of Codes

Code Table ID


C022 SERVICE-ID IdentificationCode Added Service Id’s: 03102530 Statistics 02890000 Music, General Music 6 13018000 Financial Math C022 SERVICE-ID IdentificationCode Deleted Service Id’s: C022 SERVICE-ID IdentificationCode Revised Service Id’s: Correct service id: ‘N114001’ to ‘N1140001’

Correct description, short description., and abbreviation – I3010201 Correct description – 03254000 ‘ IIV’ to ‘IV’ Correct description – 03834700 to ‘Dance III, Dance History I’ Correct description – 03834800 to ‘Dance IV, Dance History II’ Correct description – 03252400 ‘Tichnical’ to ‘Technical’ Correct abbreviation – N1300993 Video Game Design 1 – ‘VIDEOGD’ TO VIDEOGD1’ Correct description – N1290001 to ‘Advancement Via Individual Determination I’ Correct description – N1290002 to ‘Advancement Via Individual Determination II’ Correct description – N1290030 to ‘Advancement Via Individual Determination III’ Correct description – N1290037 to ‘Strength Bank: A Relationship Initiative” C062 GRADUATION-TYPE-CODE TX-GraduationTypeCodeType Revised Code 04 Translation




Revised code ‘18’ Translation







Code Table ID


C164 DISCIPLINARY-ACTION-CODE

TX-DisciplinaryActionCodeType Delete code ‘16’ Truancy (failure to attend school) charges filed in Juvenile Municipal or Justice of the Peace court and a fine was assessed

Delete code ‘17’ Truancy ((failure to attend school) charges filed in Juvenile Municipal or Justice of the Peace court and no fine was assessed

Add code ‘29’ Truancy Complaint Filed in Truancy Court (includes County Court, Justice of the Peace Court, or Municipal Court)

C165 DISCIPLINARY-ACTION-REASON-CODE

TX-DisciplinaryActionReasonType Revise code ‘11’ translation





Revise code ‘44’ citation


C192 UNACCOMPANIED-YOUTH-STATUS-CODE

TX-UnaccompaniedYouthStatusType Revised Code 4: Homeless Student is not in the physical custody of a parent or legal guardian (i.e., homeless student is not unaccompanied) at any time during the school year.

C201 INDIVIDUAL-GRADUATION-COMMITTEE-CODE

TX-IndividualGraduationCommitteeType

New Code Table

00 Not Applicable

01 IGC Reviewed (Submission 3 Only)

02 IGC Graduate (Submission 1 Only)


Section 8.5 – PEIMS Business Rules and Validations

Rule # Edit # Description of Change 10020-0031 02017 New rule 30040-0039 04313 Revision: Removed DATE-OF-BIRTH; Changed "but ANY of the four...do NOT match" to "but two or three of the

three...do NOT match" 30060-0016 0601E Missing from some publications of TEDS. Please verify implementation. 40100-0100 10210 Revision: Changed "but ANY...do NOT match" to "but three or four...do NOT match" 40110-000H Revision: Removed Submission 3 40110-000K Revision: Added CAMPUS-ID-OF-ENROLLMENT 40110-000V New rule 40203-0004 20307 Revision: Added INDIVIDUAL-GRADUATION-COMMITTEE-GRADUATE-CODE 40203-0005 20308 Revision: Added INDIVIDUAL-GRADUATION-COMMITTEE-GRADUATE-CODE 40203-0006 20313 Revision: Added GRADUATION-TYPE-CODE 57; revised Business Meaning 40203-0010 Revision: Added GRADUATION-TYPE-CODEs 54 – 57 40203-0011 Revision: Added GRADUATION-TYPE-CODEs 54 – 57 40203-0018 20342 New rule 40203-0019 20343 New rule 40203-0020 20344 New rule 42400-0033 40010 Revision: Corrected error level from Fatal to Warning 42401-0006 40075 Revision: Removed "on any of this Basic Attendance", no change in logic. 42405-0030 40535 Revision: Corrected "a 410 record" to "Career and Technical Education Attendance" 44425-000D Revision: Added "The combination of the following fields" and "CAMPUS-ID-OF-ENROLLMENT". CAMPUS-ID-OF-

ENROLLMENT is added to the key for this complex type. 44425-000E Revision: Added CAMPUS-ID-OF-ENROLLMENT 44425-000H Revision: Removed CAMPUS-ID-OF-ENROLLMENT 44425-0016 42515 Revision: Removed DISCIPLINARY-ACTION-CODEs 16 and 17; Added DISCIPLINARY-ACTION-CODE 29 44425-0019 42557 Revision: Removed DISCIPLINARY-ACTION-CODEs 16 and 17; Added DISCIPLINARY-ACTION-CODE 29; Removed

DISCIPLINARY-ACTION-REASON-CODE 43; Revised Business Meaning 44425-0020 42565 Revision: Removed DISCIPLINARY-ACTION-REASON-CODE 43; Removed DISCIPLINARY-ACTION-CODEs 16 and

17; Added DISCIPLINARY-ACTION-CODE 29; Revised Business Meaning 44425-0021 42561 Revision: Removed DISCIPLINARY-ACTION-CODEs 16 and 17; Added DISCIPLINARY-ACTION-CODE 29; Revised

Business Meaning 44425-0037 42526 Revision: Removed DISCIPLINARY-ACTION-REASON-CODE 43 44425-0050 42576 Revision: Removed DISCIPLINARY-ACTION-REASON-CODE 43 44425-0055 42581 Revision: Removed DISCIPLINARY-ACTION-REASON-CODE 43 44425-0059 42585 Revision: Removed DISCIPLINARY-ACTION-REASON-CODE 50; Revised Business Meaning 44425-0061 42587 Revision: Removed DISCIPLINARY-ACTION-REASON-CODE 43; Changed “12-17 years old” to “12-18 years old”;

Revised Business Meaning 44425-0064 42590 Revision: Removed DISCIPLINARY-ACTION-REASON-CODE 43; Revised Business Meaning 48011-0002 Revision: Added GRADUATION-TYPE-CODEs 54 – 57 48011-0015 20345 New rule 48011-0016 20346 New rule


Section 8.6 – Ed-Fi Core & TX Core Extension Schemas

Ed-Fi Core Schema

There were no changes to this section

TX-Core Extension Schema





E1562 INDIVIDUAL-GRADUATION-COMMITTEE-GRADU TX-IndividualGraduationCommitteeGraduat Added data element



StudentDisciplineisciplineIncidentExtension Complex Type













Section 8.7 – PEIMS Interchange Schemas

Section 8.7.1 PEIMS InterchangeEducationOrganizationExtension




Section 8.7.3 PEIMS InterchangeStudentExtension



Section 8.7.4 PEIMS InterchangeStudentEnrollment






Added data element to Complex Type



Section 8.7.7 PEIMS InterchangeStudentDisciplineExtension






Section 10 – Data Collections

Early Childhood Data System – Section 10

No changes

Element ID Data Element Description of Changes

Early Childhood Data System - Collection Spreadsheet

Element ID Data Element Description of Changes (Version) No Changes

TEDS Appendices

Appendix P - Revised reporting guidelines for 1: discipline reason codes 2: graduation type codes 3: optional flexible school day funding formulas

Appendix B – Added new data elements.

Appendix C – Added new data elements.

PEIMS Appendices

Appendix P - Revised reporting guidelines for 1: discipline reason codes 2: graduation type codes 3: optional flexible school day funding formulas

Appendix B – Added new data elements.

Appendix C – Added new data elements.

texas education data standards (teds)castro.tea.state.tx.us/tsds/teds/2016a/v2.0/tsds_august... ·...

Documents