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 50300-0002
For each Course Section, there should be a corresponding student section association where CAMPUS-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE are the same.

Each course section that is scheduled should also have at least one student reported as participating in the course section with student section association data.
S Y 3, 4 Y Y Y
Business Context 50300-0003
CAMPUS-ID must match an entry registered with the TEA as an active instructional campus in the reporting LEA ending in "001"-"698".

A campus (SchoolReference) reporting course section data must be an active instructional campus registered with the TEA in the reporting LEA and must end in "001"-"698".
F 3, 4 Y Y Y
Business Context 50300-0004
SERVICE-ID must not begin with "SA", "SE", "SR", "SS", or "8".

Course section records must not be reported with CourseCodes that indicate: educational aides (starts with "SA"), special education and related services (starts with "SE"), teachers with additional responsibilities (starts with "SR"), faculty with non-teaching responsibilities (starts with "SS"), or local-credit courses (start with "8").
F Y 3, 4 Y Y Y
Business Context 50300-0006
If SERVICE-ID is a high school course, then COURSE-SEQUENCE-CODE must not be "A".

The TX-CourseSequence "A" is only reported for non-high school courses.
F Y 3, 4 Y Y Y
Business Context 50300-0007
If NON-CAMPUS-BASED-INSTRUCTION-CODE is "10", then SERVICE-ID must be "PES00008" - "PES00011".

If the TX-NonCampusBasedInstruction indicates a "non-district PE substitution program", then the CourseCode must be a "PE substitution non-district program" course.
F 3 Y Y Y
Business Context 50300-0008
If NON-CAMPUS-BASED-INSTRUCTION-CODE is "09", then CAMPUS-ID must be registered with TEA as a DAEP campus type.

If the TX-NonCampusBasedInstruction indicates an "out of district DAEP program", then the SchoolReference must be registered with the TEA as a DAEP campus.
F 3 Y Y Y
Business Context 50300-0009
If SERVICE-ID is a Career and Technical Education course (CTE Course = "H" or "M" in code table C022), then NON-CAMPUS-BASED-INSTRUCTION-CODE should be "00".

If the CourseCode is a career and technical education course, then the course generally will be taught by campus staff.
S 3 Y Y Y
Field Validation 50300-000A
The combination of the following fields must be unique for each Course Section: CLASS-ID-NUMBER, CAMPUS-ID, and COURSE-SEQUENCE-CODE.

The combination of the following fields must be unique for each Course Section: UniqueSectionCode, StateOrganizationId (SchoolReference), and TX-CourseSequence.
F Y 3, 4 Y Y Y
Field Validation 50300-000B
For a Course Section, the following must be provided: CLASS-ID-NUMBER, CourseOfferingReference, CAMPUS-ID (SchoolReference), CLASS-PERIOD, CAMPUS-ID (ClassPeriodReference), SCHOOL-YEAR, POPULATION-SERVED-CODE, COURSE-SEQUENCE-CODE, and NON-CAMPUS-BASED-INSTRUCTION-CODE.

For a Course Section, the following must be provided: UniqueSectionCode, CourseOfferingReference, StateOrganizationId (SchoolReference), ClassPeriodName, StateOrganizationId (ClassPeriodReference), TX-SchoolYear, TX-PopulationServed, TX-CourseSequence, and TX-NonCampusBasedInstruction.
F 3 Y Y Y
Field Validation 50300-000C
For a Course Section, the following must be provided: CLASS-ID-NUMBER, CourseOfferingReference, CAMPUS-ID (SchoolReference), SCHOOL-YEAR and COURSE-SEQUENCE-CODE.

For a Course Section, the following must be provided: UniqueSectionCode, CourseOfferingReference, StateOrganizationId (SchoolReference), TX-SchoolYear and TX-CourseSequence.
F 4 Y Y Y
Field Validation 50300-000E
The combination of the following fields must be unique for each Student Section Association: TX-UNIQUE-STUDENT-ID, CAMPUS-ID, CLASS-ID-NUMBER, COURSE-SEQUENCE-CODE, and STUDENT-BEGIN-DATE.

The combination of the following fields must be unique for each Student Section Association: StudentUniqueStateId, StateOrganizationId (SectionReference), UniqueSectionCode, TX-CourseSequence, and BeginDate.
F Y 3, 4 Y Y Y
Field Validation 50300-000F
For a Student Section Association, the following must be provided: TX-UNIQUE-STUDENT-ID, CAMPUS-ID, CLASS-ID-NUMBER, STUDENT-BEGIN-DATE, STUDENT-END-DATE, COURSE-SEQUENCE-CODE, and COURSE-COMPLETION-INDICATOR.

For a Student Section Association, the following must be provided: StudentUniqueStateId, StateOrganizationId (SchoolReference), UniqueSectionCode, BeginDate, EndDate, TX-CourseSequence, and TX-CourseCompletionIndicator.
F 3, 4 Y Y Y
Field Validation 50300-000H
The combination of the following fields must be unique for each Teacher Section Association: TX-UNIQUE-STAFF-ID, CAMPUS-ID, CLASS-ID-NUMBER, COURSE-SEQUENCE-CODE, and ASSIGNMENT-BEGIN-DATE.

The combination of the following fields must be unique for each Teacher Section Association: StaffUniqueStateId, StateOrganizationId, UniqueSectionCode, TX-CourseSequence, and BeginDate.
F Y Y Y
Business Context 50300-0010
If CAMPUS-ID is "019907006", "072801145", "101912100", "102904010", "220906007", "221801022", "236902008", "236902048", or "236902108", or TxVSN waiver campus "015835011", "031912203", "031916009", "046802011", "057905554", "101846008", "101911040", "129902005", "170902220", "177901104", "186902040", "186902698", "220920108", "246906006", or "246913100", then NON-CAMPUS-BASED-INSTRUCTION-CODE must be "04".

If a course section record indicates a Texas Virtual School Network (TxVSN) Online Schools campus for the SchoolReference, then the TX-NonCampusBasedInstruction must be reported as "Texas Virtual School Network (TxVSN) Online Schools Program".
F 3 Y Y Y
Business Context 50300-0011
For a student section association, STUDENT-END-DATE must be greater than or equal to STUDENT-BEGIN-DATE.

For a student section association, the date that a student was assigned to, or reassigned to, a course must occur before the last date a student was assigned to a course.
F Y 3, 4 Y Y Y
Business Context 50300-0012
For this Course Section, if the Course is for SERVICE-ID "127XXXXX", "130XXXXX", "N127XXXX", or "N130XXXX", then POPULATION-SERVED-CODE should be "05" or "06".

If a Course Section is reported with an ID (Service ID) beginning with "127", "130", "N127", or "N130" , then the TX-PopulationServed should be "career and technical students" (05) or "special education students" (06).
S 3 Y
Business Context 50300-0014
If NON-CAMPUS-BASED-INSTRUCTION-CODE is "04", then CAMPUS-ID must be "019907006", "072801145", "101912100", "102904010", "220906007", "221801022", "236902008", "236902048", or "236902108", or TxVSN waiver campus "015835011", "031912203", "031916009", "046802011", "057905554", "101846008", "101911040", "129902005", "170902220", "177901104", "186902040", "186902698", "220920108", "246906006", or "246913100".

If a course section record indicates the TX-NonCampusBasedInstruction is "Texas Virtual School Network (TxVSN) Online Schools Program", then a Texas Virtual School Network (TxVSN) Online Schools campus must be used for the SchoolReference.
F 3 Y Y Y