| Rule Applies To | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Rule Type |
Rule # | Rule Text / Business Meaning |
Error Level |
TSDS | PEIMS Sub |
ESC | LEA | Campus | Charter |
| Field Validation | 10010-000A |
DISTRICT-ID must be unique for each Local Education Agency.
StateOrganizationId must be unique for each Local Education Agency.
|
F | Y | 1, 2, 3, 4 | Y | Y | ||
| Field Validation | 10020-000A |
CAMPUS-ID must be unique for each campus.
StateOrganizationId must be unique for each campus.
|
F | Y | 1, 2, 3, 4 | Y | Y | Y | |
| Field Validation | 10050-000B |
The combination of the following must be unique for each Course Offering: SchoolReference and CourseReference.
The combination of the following must be unique for each Course Offering: SchoolReference and CourseReference.
|
F | Y | Y | Y | Y | ||
| Field Validation | 10050-000C |
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 | 30040-0007 |
DATE-OF-BIRTH must be a valid date.
For a staff person, the BirthDate must be a valid date.
|
F | Y | 1, 4 | Y | Y | ||
| Field Validation | 30040-000C |
The combination of the following fields must be unique for each staff person: TX-UNIQUE-STAFF-ID and DISTRICT-ID.
The combination of the following fields must be unique for each staff person: StaffUniqueStateId and StateOrganizationId.
|
F | Y | Y | Y | Y | ||
| Field Validation | 30040-0038 |
TX-UNIQUE-STAFF-ID must match an entry in the TSDS Unique ID system.
For each staff person, the StaffUniqueStateId must match and entry in the TSDS Unique Id system.
|
F | Y | 1, 4 | Y | Y | ||
| Field Validation | 30040-0047 |
TX-UNIQUE-STAFF-ID must not match TX-UNIQUE-STAFF-ID for any other staff person reported for this LEA.
A particular StaffUniqueStateId may only be used for one staff person at an LEA.
|
F | Y | 1, 4 | Y | Y | ||
| Field Validation | 30305-0007 |
ASSIGNMENT-BEGIN-DATE must be a valid date.
For a teacher section association, the BeginDate must be a valid calendar date.
|
F | Y | Y | Y | Y | ||
| Field Validation | 30305-0009 |
ASSIGNMENT-END-DATE must be a valid date.
For a teacher section association, the EndDate must be a valid calendar date.
|
F | Y | Y | Y | Y | ||
| Field Validation | 30305-000A |
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 | Y | ||
| Field Validation | 40100-000A |
The combination of the following fields must be unique for each student: DISTRICT-ID and TX-UNIQUE-STUDENT-ID.
The combination of the following fields must be unique for each student: StateOrganizationId (TX-LEAReference) and StudentUniqueStateId.
|
F | Y | 1, 3, 4 | Y | Y | Y | |
| Field Validation | 40100-0017 |
DATE-OF-BIRTH must be a valid date.
A student's BirthDate must be a valid date.
|
F | Y | 1, 3, 4 | Y | Y | Y | |
| Field Validation | 40100-0079 |
FIRST-NAME, MIDDLE-NAME, or LAST-NAME should not contain "0"-"9".
The FirstName, MiddleName and/or LastSurname of a student should not contain "0"-"9".
|
S | Y | 1, 3, 4 | Y | Y | Y | |
| Field Validation | 40100-0099 |
TX-UNIQUE-STUDENT-ID must match an entry in the TSDS Unique ID system.
A student's StudentUniqueStateId must match an entry in the TSDS Unique Id system.
|
F | Y | 1, 3, 4 | Y | Y | Y | |
| Field Validation | 40100-0145 |
TX-UNIQUE-STUDENT-ID must not match TX-UNIQUE-STUDENT-ID for any other student reported for this LEA.
A particular StudentUniqueStateId may only be used for one student at an LEA.
|
F | Y | 1, 3, 4 | Y | |||
| Field Validation | 40110-000D |
The combination of the following fields must be unique for each student Enrollment (Student School Association): TX-UNIQUE-STUDENT-ID, and CAMPUS-ID.
The combination of the following fields must be unique for each student Enrollment (Student School Association): StudentUniqueStateId, and StateOrganizationId (SchoolReference).
|
F | Y | Y | Y | Y | ||
| Field Validation | 40110-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 | 40110-0163 |
STUDENT-BEGIN-DATE must be a valid date.
The date that a student was assigned to, or reassigned to, a course must be a valid date.
|
F | Y | 3, 4 | Y | Y | Y | |
| Field Validation | 40110-0164 |
STUDENT-END-DATE must be a valid date.
The last date a student was assigned to a course must be a valid date.
|
F | Y | 3, 4 | 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-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-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 | Y | ||