TSDS Web-Enabled Data Standards

Search. Drill. Find.

Search For: Search By:
Year:
Collection:
Submission:
Submission Instance:
Published Version:
2024.2.1

PDF
Rule Applies To
Rule
Type
Rule # Rule Text /
Business Meaning
Error
Level
TSDS PEIMS
Sub
ESC LEA Campus Charter
Business Context 48011-0002
There must be school leaver data with a matching TX-UNIQUE-STUDENT-ID where LEAVER-REASON-CODE is "01".

A student reported in submission 1 with graduation program data must be reported as a graduate leaver.
F 1 Y Y Y
Business Context 48011-0003
There must be student school association data with a matching TX-UNIQUE-STUDENT-ID where GRADE-LEVEL-CODE is "09"-"12".

A student reported in submission 3 with graduation program intention data must be reported in grade level "09"-"12" at the end of the school year.
F 3 Y Y Y
Business Context 48011-0004
CAMPUS-ID must match an entry that is registered with the TEA as an active instructional campus in the reporting LEA, in the prior school year ending in "001"-"698".

For a student graduation program, the StateOrganizationId (TX-SchoolReference) must have been an active instructional campus in the reporting LEA in the previous school year and must end in "001"-"698".
F 1 Y Y Y
Business Context 48011-0005
CAMPUS-ID must match an entry that is registered with the TEA as an active instructional campus in the reporting LEA, in the current school year ending in "001"-"698".

For a student graduation program intent, the StateOrganizationId (TX-SchoolReference) must have been an active instructional campus in the reporting LEA in the current school year and must end in "001"-"698".
F 3 Y Y Y
Business Context 48011-0006
If FHSP-PARTICIPANT-CODE is "0", then the following fields must be blank: FHSP-DISTING-LEVEL-ACHIEVE-INDICATOR-CODE, STEM-ENDORSEMENT-INDICATOR-CODE, BUSINESS-AND-INDUSTRY-ENDORSEMENT-INDICATOR-CODE, PUBLIC-SERVICES-ENDORSEMENT-INDICATOR-CODE, ARTS-AND-HUMANITIES-ENDORSEMENT-INDICATOR-CODE, and MULTI-DISCIPLINARY-STUDIES-ENDORSEMENT-INDICATOR-CODE.

If a student is not currently enrolled in the Foundation High School Program, then TX-FHSPDistingLevelAchieveIndicator and the FHSP Endorsement Indicators must not be reported.
F 3 Y Y Y
Business Context 48011-0007
If FHSP-PARTICIPANT-CODE is not "0", then the following fields must not be blank: FHSP-DISTING-LEVEL-ACHIEVE-INDICATOR-CODE, STEM-ENDORSEMENT-INDICATOR-CODE, BUSINESS-AND-INDUSTRY-ENDORSEMENT-INDICATOR-CODE, PUBLIC-SERVICES-ENDORSEMENT-INDICATOR-CODE, ARTS-AND-HUMANITIES-ENDORSEMENT-INDICATOR-CODE, and MULTI-DISCIPLINARY-STUDIES-ENDORSEMENT-INDICATOR-CODE.

If a student is currently enrolled in the Foundation High School Program, then TX-FHSPDistingLevelAchieveIndicator and the FHSP Endorsement Indicators must be reported.
F 3 Y Y Y
Business Context 48011-0008
If FHSP-DISTING-LEVEL-ACHIEVE-INDICATOR-CODE is "1" or "2", then at least one of the following fields must be "1" or "2": STEM-ENDORSEMENT-INDICATOR-CODE, BUSINESS-AND-INDUSTRY-ENDORSEMENT-INDICATOR-CODE, PUBLIC-SERVICES-ENDORSEMENT-INDICATOR-CODE, ARTS-AND-HUMANITIES-ENDORSEMENT-INDICATOR-CODE, or MULTI-DISCIPLINARY-STUDIES-ENDORSEMENT-INDICATOR-CODE.

If TX-FHSPDistingLevelAchieveIndicator indicates a student is currently pursuing the Distinguished Level of Achievement, then at least one of these fields must indicate the student is currently pursuing or has successfully completed a program to earn an endorsement: TX-STEMEndorsementIndicator, TX-BusinessAndIndustryEndorsementIndicator, TX-PublicServicesEndorsementIndicator, TX-ArtsAndHumanitiesEndorsementIndicator, and TX-MultiDisciplinaryStudiesEndorsementIndicator.
F 3 Y Y Y
Business Context 48011-0009
If GRADE-LEVEL-CODE is "09"-"11", then FHSP-DISTING-LEVEL-ACHIEVE-INDICATOR-CODE should not be "2".

A student in grades "09"-"11" generally will not have completed the FHSP Distinguished Level of Achievement before their senior year of high school.
S 1, 3 Y Y Y
Field Validation 48011-000A
The combination of the following fields must be unique for each Student Graduation Program: DISTRICT-ID and TX-UNIQUE-STUDENT-ID.

The combination of the following fields must be unique for each Student Graduation Program: StateOrganizationId (TX-LEAReference) and StudentUniqueStateId.
F 1, 3 Y Y Y
Field Validation 48011-000B
For a Student Graduation Program, the following must be provided: DISTRICT-ID, TX-UNIQUE-STUDENT-ID, CAMPUS-ID, and FINANCIAL-AID-APPLICATION-CODE.

For a Student Graduation Program, the following must be provided: StateOrganizationId (TX-LEAReference), StudentUniqueStateId, StateOrganizationId (TX-SchoolReference), and TX-FinancialAidApplication.
F 1 Y Y Y
Field Validation 48011-000C
For a Student Graduation Program, the following must be provided: DISTRICT-ID, TX-UNIQUE-STUDENT-ID, CAMPUS-ID, and FHSP-PARTICIPANT-CODE

For a Student Graduation Program, the following must be provided: StateOrganizationId (TX-LEAReference), StudentUniqueStateId, StateOrganizationId (TX-SchoolReference), and TX-FHSPParticipant.
F 3 Y Y Y
Business Context 48011-0010
If GRADE-LEVEL-CODE is "09", then none of the following fields should be "2": STEM-ENDORSEMENT-INDICATOR-CODE, BUSINESS-AND-INDUSTRY-ENDORSEMENT-INDICATOR-CODE, PUBLIC-SERVICES-ENDORSEMENT-INDICATOR-CODE, ARTS-AND-HUMANITIES-ENDORSEMENT-INDICATOR-CODE, or MULTI-DISCIPLINARY-STUDIES-ENDORSEMENT-INDICATOR-CODE.

A student in grade "09" generally will not have completed any of the FHSP Endorsements.
S 1, 3 Y Y Y
Business Context 48011-0011
If FHSP-PARTICIPANT-CODE is "2", then the following fields must be "0" or "2": FHSP-DISTING-LEVEL-ACHIEVE-INDICATOR-CODE, STEM-ENDORSEMENT-INDICATOR-CODE, BUSINESS-AND-INDUSTRY-ENDORSEMENT-INDICATOR-CODE, PUBLIC-SERVICES-ENDORSEMENT-INDICATOR-CODE, ARTS-AND-HUMANITIES-ENDORSEMENT-INDICATOR-CODE, and MULTI-DISCIPLINARY-STUDIES-ENDORSEMENT-INDICATOR-CODE.

If a student has completed the Foundation High School Program, then the FHSP Distinguished Level of Achievement Indicator Code and the FHSP Endorsement Indicators must be reported as either the student is not pursuing or participating (0), or the student has completed (2). The student would no longer be pursuing a component if they have completed the program.
F 3 Y Y Y
Business Context 48011-0012
If GRADUATION-TYPE-CODE is "34", "35", "54", "55", "56", or "57" (FHSP) on this student's school leaver data, then the following fields must be either "0" or "2": FHSP-DISTING-LEVEL-ACHIEVE-INDICATOR-CODE, STEM-ENDORSEMENT-INDICATOR-CODE, BUSINESS-AND-INDUSTRY-ENDORSEMENT-INDICATOR-CODE, PUBLIC-SERVICES-ENDORSEMENT-INDICATOR-CODE, ARTS-AND-HUMANITIES-ENDORSEMENT-INDICATOR-CODE, and MULTI-DISCIPLINARY-STUDIES-ENDORSEMENT-INDICATOR-CODE.

If a leaver has graduated under the Foundation High School Program, then the TX-FHSPDistingLevelAchieveIndicator and the FHSP Endorsement Indicators must be reported as either the student is not pursuing or participating (0), or the student has completed the component (2).
F 1 Y Y Y
Business Context 48011-0014
If GRADE-LEVEL-CODE is "09" or "10", and FHSP-PARTICIPANT-CODE is "1", then at least one of the following fields should be "1": STEM-ENDORSEMENT-INDICATOR-CODE, BUSINESS-AND-INDUSTRY-ENDORSEMENT-INDICATOR-CODE, PUBLIC-SERVICES-ENDORSEMENT-INDICATOR-CODE, ARTS-AND-HUMANITIES-ENDORSEMENT-INDICATOR-CODE, or MULTI-DISCIPLINARY-STUDIES-ENDORSEMENT-INDICATOR-CODE.

A student in grade "09" or "10" who is pursuing the Foundation High School Program should specify at least one of the FHSP Endorsements.
S 3 Y Y Y
Business Context 48011-0015
If GRADE-LEVEL-CODE is "11" or "12", then INDIVIDUAL-GRADUATION-COMMITTEE-REVIEW-CODE must not be blank, and must be "00" or "01".

For graduation program intention data reported for a student in grade 11 or 12, the TX-IndividualGraduationCommitteeReviewIndicator must indicate "Not applicable" (00) or "IGC Reviewed" (01).
F 3 Y Y Y
Business Context 48011-0016
If GRADE-LEVEL-CODE is not "11" or "12", then INDIVIDUAL-GRADUATION-COMMITTEE-REVIEW-CODE must be blank.

TX-IndividualGraduationCommitteeReviewIndicator is only reported for students in grades 11 and 12. A student cannot have an IGC established before the 11th grade.
F 3 Y Y Y
Business Context 48011-0017
If GRADE-LEVEL-CODE is "11" or "12", and FHSP-PARTICIPANT-CODE is "1", then at least one of the following fields should be "1": STEM-ENDORSEMENT-INDICATOR-CODE, BUSINESS-AND-INDUSTRY-ENDORSEMENT-INDICATOR-CODE, PUBLIC-SERVICES-ENDORSEMENT-INDICATOR-CODE, ARTS-AND-HUMANITIES-ENDORSEMENT-INDICATOR-CODE, or MULTI-DISCIPLINARY-STUDIES-ENDORSEMENT-INDICATOR-CODE.

A student in grade "11" or "12" who is pursuing the Foundation High School Program should specify at least one of the FHSP Endorsements.
W 3 Y Y Y
Business Context 48011-0018
For a particular CAMPUS-ID, at least one student should be reported with FHSP-DISTING-LEVEL-ACHIEVE-INDICATOR-CODE of "2".

For a particular campus, at least one leaver who has graduated under the Foundation High School Program should be reported as having completed the distinguished level of achievement.
S 1 Y Y Y
Business Context 48011-0019
For a particular CAMPUS-ID, at least one student should be reported with a "2" in at least one of the following fields: STEM-ENDORSEMENT-INDICATOR-CODE, BUSINESS-AND-INDUSTRY-ENDORSEMENT-INDICATOR-CODE, PUBLIC-SERVICES-ENDORSEMENT-INDICATOR-CODE, ARTS-AND-HUMANITIES-ENDORSEMENT-INDICATOR-CODE, or MULTI-DISCIPLINARY-STUDIES-ENDORSEMENT-INDICATOR-CODE.

For a particular campus, at least one leaver who has graduated under the Foundation High School Program should be reported as having completed a program to earn an endorsement.
S 1 Y Y Y
Business Context 48011-0020
If FHSP-DISTING-LEVEL-ACHIEVE-INDICATOR-CODE is "2", and TEXAS-FIRST-EARLY-HS-COMPLETION-PROGRAM is blank/not reported, then at least one of the following fields must be "2": STEM-ENDORSEMENT-INDICATOR-CODE, BUSINESS-AND-INDUSTRY-ENDORSEMENT-INDICATOR-CODE, PUBLIC-SERVICES-ENDORSEMENT-INDICATOR-CODE, ARTS-AND-HUMANITIES-ENDORSEMENT-INDICATOR-CODE, or MULTI-DISCIPLINARY-STUDIES-ENDORSEMENT-INDICATOR-CODE.

If TX-FHSPDistingLevelAchieveIndicator indicates the graduate has completed the Distinguished Level of Achievement, and the student is not a graduate of the Texas First Early High School Completion Program, then at least one of these fields must indicate the graduate has successfully completed a program to earn an endorsement: TX-STEMEndorsementIndicator, TX-BusinessAndIndustryEndorsementIndicator, TX-PublicServicesEndorsementIndicator, TX-ArtsAndHumanitiesEndorsementIndicator, and TX-MultiDisciplinaryStudiesEndorsementIndicator.
F 1 Y Y Y
Business Context 48011-0021
The number of students with GRADE-LEVEL-CODE "12" and INDIVIDUAL-GRADUATION-COMMITTEE-REVIEW-CODE of "01" should not be equal to the number of students with GRADE-LEVEL-CODE "12".

An LEA or campus should not report all of their 12th grade students as being reviewed by an Individual Graduation Committee.
W 3 Y Y Y
Business Context 48011-0022
The number of students with GRADE-LEVEL-CODE "11" and INDIVIDUAL-GRADUATION-COMMITTEE-REVIEW-CODE of "01" should not be equal to the number of students with GRADE-LEVEL-CODE "11".

An LEA or campus should not report all of their 11th grade students as being reviewed by an Individual Graduation Committee.
W 3 Y Y Y
Business Context 48011-0023
If GRADE-LEVEL-CODE is "09"-"11", then FHSP-PARTICIPANT-CODE should be "1" on the student's graduation program intention data.

Students in grades "09"-"11" generally should be reported as currently pursuing the Foundation High School Program.
S 3 Y Y Y
Business Context 48011-0027
CAMPUS-ID should match a CAMPUS-ID-OF-ENROLLMENT on the student's highest REPORTING-PERIOD-INDICATOR-CODE on Attendance or Flexible Attendance data.

For a student's graduation program intention data, the StateOrganizationId (TX-SchoolReference) should be the last campus the student attended in the school year. If the student attended more than one campus in the highest reporting period attended, then StateOrganizationId (TX-SchoolReference) should be one of those campuses.
W 3 Y Y Y
Business Context 48011-0028
If GRADUATION-TYPE-CODE is not "34", "35", "54", "55", "56", or "57" (FHSP) or "40" (Texas First Early High School Completion Program) on this student's school leaver data, then the following fields must be blank/not reported: FHSP-DISTING-LEVEL-ACHIEVE-INDICATOR-CODE, STEM-ENDORSEMENT-INDICATOR-CODE, BUSINESS-AND-INDUSTRY-ENDORSEMENT-INDICATOR-CODE, PUBLIC-SERVICES-ENDORSEMENT-INDICATOR-CODE, ARTS-AND-HUMANITIES-ENDORSEMENT-INDICATOR-CODE, and MULTI-DISCIPLINARY-STUDIES-ENDORSEMENT-INDICATOR-CODE.

If a leaver has not graduated under the Foundation High School Program or the Texas First Early High School Completion Program, then the TX-FHSPDistingLevelAchieveIndicator and the FHSP Endorsement Indicators must not be reported.
F 1 Y Y Y
Business Context 48011-0029
If GRADE-LEVEL-CODE is "12", then FHSP-PARTICIPANT-CODE should be "2" on the student's graduation program intention data.

Students in grades "12" generally should be reported as having completed the Foundation High School Program.
S 3 Y Y Y
Business Context 48011-0031
If TEXAS-FIRST-EARLY-HS-COMPLETION-PROGRAM is not blank, then FHSP-DISTING-LEVEL-ACHIEVE-INDICATOR-CODE must be "2".

If a leaver has graduated under the Texas First Early High School Completion Program, then TX-FHSPDistingLevelAchieveIndicator must indicate that the student has achieved this distinction.
F 1 Y Y Y
Business Context 48011-0032
If TEXAS-FIRST-EARLY-HS-COMPLETION-PROGRAM is not blank, then GRADUATION-TYPE-CODE must be "40".

If a leaver has graduated under the Texas First Early High School Completion Program, then this student's TX-GraduationTypeCode must indicate that the student graduated early under the Texas First Early High School Completion Program.
F 1 Y Y Y
Business Context 48011-0033
If TEXAS-FIRST-EARLY-HS-COMPLETION-PROGRAM is not blank, then the following fields must be blank/not reported: STEM-ENDORSEMENT-INDICATOR-CODE, BUSINESS-AND-INDUSTRY-ENDORSEMENT-INDICATOR-CODE, PUBLIC-SERVICES-ENDORSEMENT-INDICATOR-CODE, ARTS-AND-HUMANITIES-ENDORSEMENT-INDICATOR-CODE, and MULTI-DISCIPLINARY-STUDIES-ENDORSEMENT-INDICATOR-CODE.

If a leaver has graduated under the Texas First Early High School Completion Program, then FHSP Endorsement Indicators must not be reported.
F 1 Y Y Y
Business Context 48011-0034
If GRADUATION-TYPE-CODE is "40", then this student's TEXAS-FIRST-EARLY-HS-COMPLETION-PROGRAM must not be blank.

If a leaver has graduated with TX-GraduationTypeCode indicating that they graduated early under the Texas First Early High School Completion Program, then their TX-TexasFirstEarlyHSCompletionProgram must be reported.
F 1 Y Y Y