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 30040-0002
For each staff person, Teacher Class Assignment (Teacher Section Association) data must be reported with a matching TX-UNIQUE-STAFF-ID.

Each teacher (role ids 047 and 087) must be reported with teacher class assignment (teacher section association) data.
F Y Y Y
Business Context 30040-0003
Each character of STAFF-ID must not be the same number.

For a staff person, each character of ID must not be the same number.
F 1, 4 Y Y Y
Business Context 30040-0004
The first three characters of STAFF-ID must be between "001" and "899" (excluding "666"), the fourth and fifth characters must be between "01" and "99", and the last four characters must be between "0001" and "9999".

For a staff person, the first three characters of ID must be between "001" and "899" (excluding "666"), the fourth and fifth characters must be between "01" and "99", and the last four characters must be between "0001" and "9999".
F 1, 4 Y Y Y
Field Validation 30040-0005
STAFF-ID must be 9 numeric characters.

For a staff person, the ID must be nine numeric characters.
F 1, 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 Y
Business Context 30040-0008
A staff person’s age on the PEIMS Fall snapshot date of the current school year must be between 14 and 98 years old.

A staff person’s age on the PEIMS Fall snapshot date of the current school year must be between 14 and 98 years old.
F 1, 4 Y Y Y
Business Context 30040-0009
AMERICAN-INDIAN-ALASKA-NATIVE-CODE, ASIAN-CODE, BLACK-AFRICAN-AMERICAN-CODE, NATIVE-HAWAIIAN-PACIFIC-ISLANDER-CODE, and WHITE-CODE must not all be 0.

A staff person must be reported with at least one race code.
F 1, 4 Y Y Y
Field Validation 30040-000A
The combination of the following fields must be unique for each staff person: DISTRICT-ID and TX-UNIQUE-STAFF-ID.

The combination of the following fields must be unique for each staff person: StateOrganizationId and StaffUniqueStateID.
F 1, 4 Y Y Y
Field Validation 30040-000B
For a staff person, the following must be provided: TX-UNIQUE-STAFF-ID, STAFF-IDENTIFICATION-SYSTEM, STAFF-ID, FIRST-NAME, LAST-NAME, DATE-OF-BIRTH, DISTRICT-ID, SEX-CODE, HISPANIC-LATINO-CODE, AMERICAN-INDIAN-ALASKA-NATIVE-CODE, ASIAN-CODE, BLACK-AFRICAN-AMERICAN-CODE, NATIVE-HAWAIIAN-PACIFIC-ISLANDER-CODE, WHITE-CODE, STAFF-TYPE-CODE, HIGHEST-DEGREE-LEVEL-CODE, YEARS-EXPERIENCE-IN-DISTRICT, and TOTAL-YEARS-PROF-EXPERIENCE.

For a staff person, the following must be provided: StaffUniqueStateId, IdentificationSystem, ID, FirstName, LastSurname, BirthDate, StateOrganizationId, TX-Sex, TX-HispanicLatinoEthnicity, TX-AmericanIndianAlaskaNative, TX-Asian, TX-BlackAfricanAmerican, TX-NativeHawaiianPacificIslander, TX-White, TX-StaffTypeCode, TX-HighestDegreeLevel, TX-YearsExperienceInDistrict, and TX-TotalYearsOfProfessionalExperience.
F 1, 4 Y 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
Business Context 30040-0014
TOTAL-YEARS-PROF-EXPERIENCE must be greater than or equal to YEARS-EXPERIENCE-IN-DISTRICT.

For a staff person, the TX-TotalYearsOfProfessionalExperience must be greater than or equal to the TX-YearsExperienceInDistrict.
F 1, 4 Y Y Y
Business Context 30040-0015
If a STAFF-ID matches a STUDENT-ID, then FIRST-NAME, LAST-NAME, and DATE-OF-BIRTH must also match.

If a staff person’s ID matches a student’s IdentificationCode, their FirstName, LastSurname and BirthDate must also match.
F 1, 4 Y Y
Business Context 30040-0016
If a staff person is 18 years old or younger on the PEIMS Fall snapshot date, then TOTAL-YEARS-PROF-EXPERIENCE must be 0.

If a staff person is 18 years old or younger on the PEIMS Fall snapshot date, then their TX-TotalYearsOfProfessionalExperience must be 0.
F 1, 4 Y Y Y
Business Context 30040-0018
TOTAL-YEARS-PROF-EXPERIENCE should be less than 41.

For a staff person, the TX-TotalYearsOfProfessionalExperience should be less than 41 years.
W 1, 4 Y Y Y
Business Context 30040-0019
YEARS-EXPERIENCE-IN-DISTRICT should be less than 41.

For a staff person, the TX-YearsExperienceInDistrict should be less than 41 years.
W 1, 4 Y Y Y
Business Context 30040-0022
FIRST-NAME, MIDDLE-NAME, and/or LAST-NAME should not end with " JR", " SR", " I", " II", " III", " IV", " V", " VI", " VII", " VIII", " IX", or " X" (not case sensitive).

For a staff person, FirstName, MiddleName and/or LastSurname should not end with any of the following characters that suggest a generation indicator: " JR", " SR", " I", " II", " III", " IV", " V", " VI", " VII", " VIII", " IX", or " X" (not case sensitive).
S Y 1, 4 Y Y Y
Business Context 30040-0023
A staff person’s age on the PEIMS Fall snapshot date of the current school year should be between 16 and 75 years old.

A staff person’s age on the PEIMS Fall snapshot date of the current school year should be between 16 and 75 years old.
S 1, 4 Y Y Y
Business Context 30040-0024
FIRST-NAME, LAST-NAME, SEX-CODE, and DATE-OF-BIRTH should not be identical on staff reported with two or more different STAFF-IDs.

FirstName, LastSurame, TX-Sex, and BirthDate should not match for two or more staff people with different ID values.
S 1, 4 Y Y Y
Business Context 30040-0027
For reporting a staff's Social Security number data with STAFF-ID (such as to PEIMS), STAFF-IDENTIFICATION-SYSTEM must be "State".

For reporting a staff's Social Security number data (such as to PEIMS), the IdentificationSystem must be "State".
F Y 1 Y Y Y
Business Context 30040-0028
If STAFF-IDENTIFICATION-SYSTEM is "State", then each character of STAFF-ID must not be the same number.

For a staff person, if the IdentificationSystem indicates "State", then each character of ID must not be the same number.
F Y Y Y
Business Context 30040-0029
If STAFF-IDENTIFICATION-SYSTEM is "State", then the first three characters of STAFF-ID must be between "001" and "899" (excluding "666"), the fourth and fifth characters must be between "01" and "99", and the last four characters must be between "0001" and "9999".

For a staff person, if the IdentificationSystem indicates "State", then the first three characters of ID must be between "001" and "899" (excluding "666"), the fourth and fifth characters must be between "01" and "99", and the last four characters must be between "0001" and "9999".
F Y Y Y
Business Context 30040-0030
If STAFF-IDENTIFICATION-SYSTEM is "State", then STAFF-ID must be 9 numeric characters

For a staff person, if the IdentificationSystem indicates "State", then ID must be nine numeric characters.
F Y Y Y
Field Validation 30040-0032
If TX-UNIQUE-STAFF-ID matches a TX-UNIQUE-STUDENT-ID, then STAFF-ID must also match STUDENT-ID.

If a staff person's StaffUniqueStateId matches a student's StudentUniqueStateId, then their Social Security numbers must also match.
F 1 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 Y Y
Field Validation 30040-0039
If TX-UNIQUE-STAFF-ID matches a Unique Id in the TSDS Unique Id system, but two or three of the three major demographics (FIRST-NAME, LAST-NAME, and STAFF-ID) do NOT match the major demographics for that entry in the TSDS Unique ID system, then a fatal error will be issued.

Two or three of this staff person's three major demographics (FirstName, LastName, ID) do not match the major demographics for this StaffUniqueStateId in the TSDS Unique Id system.
F 1, 4 Y Y Y
Field Validation 30040-0040
In the TSDS Unique ID system for this TX-UNIQUE-STAFF-ID, HISPANIC-LATINO-CODE must have a value of "0" or "1", and at least one valid race code value must be provided.

Before PEIMS data can be processed for this staff person through TSDS, the TSDS Unique ID system must be updated with valid race and ethnicity data, including at least one race value.
F 1, 4 Y Y Y
Field Validation 30040-0041
For this TX-UNIQUE-STAFF-ID, SEX-CODE must be "M" or "F" in the TSDS Unique ID system.

Before PEIMS data can be processed for this staff person, the TSDS Unique ID system must be updated with a valid value for sex/gender.
F 1, 4 Y Y Y
Business Context 30040-0042
The Texas School For the Blind and Visually Impaired (227905), the Texas School for the Deaf (227906), and the Texas Juvenile Justice Department (227622) must not submit staff data.

The Texas School for the Blind and Visually Impaired, the Texas School for the Deaf, and the Texas Juvenile Justice Department must not report staff data in submission 1.
F 1 Y
Business Context 30040-0043
For each staff person, staff employment payroll summary data (StaffEducationOrgEmploymentAssociationExtension complex type) must be reported with a matching TX-UNIQUE-STAFF-ID.

Staff employment payroll summary data (30050 StaffEducationOrgEmploymentAssociationExtension complex type) must be reported for each staff person reported.
F 1 Y Y Y
Business Context 30040-0044
If STAFF-TYPE-CODE for a staff person is "1", then there must be staff payroll for that person where PAYROLL-ACTIVITY-CODE is "80" (base salary) or "78" (non-salary).

If a staff person is reported as a school district or charter school employee, then they must be reported with payroll data with TX-PayrollActivityCode "base salary" (80) or "non-salary" (78).
F 1 Y Y Y
Business Context 30040-0045
If STAFF-TYPE-CODE for a staff person is "3" or "4", then they must not have any staff payroll data.

If a staff person is reported as contracted professional staff (not an employee), or a teacher employed at the in-district charter campus by an organization that has been granted a campus charter under TEC, Chapter 12, Subchapter C and is eligible for benefits under TEC §11.174 and 11.147(b), then they must not have any staff payroll reported.  
F 1 Y Y
Business Context 30040-0046
For this staff person, if STAFF-TYPE-CODE is "3" or "4", then there must be at least one staff responsibility reported.

If a staff person is a contracted professional staff, or a teacher employed at the in-district charter campus by an organization that has been granted a campus charter under TEC, Chapter 12, Subchapter C and is eligible for benefits under TEC §11.174 and 11.147(b), then they must be reported with a staff responsibility.
F 1 Y 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 Y
Business Context 30040-0048
STAFF-ID must not match STAFF-ID for any other staff person reported for this LEA.

A particular staff id may only be used for one staff person at an LEA.
F 1, 4 Y Y Y
Business Context 30040-0049
If this staff person has a Teacher Section Association with a CLASSROOM-POSITION of "Teacher of Record" and for a Course Section where HIGH-QUALITY-PK-PROGRAM-INDICATOR is "1", then PK-TEACHER-REQUIREMENT should not be blank.

TX-PKTeacherRequirement should be reported for each Teacher of Record associated with a High Quality PK program course.
S Y Y Y
Business Context 30040-0050
FIRST-NAME and/or LAST-NAME should not end with " JR", " SR", " I", " II", " III", " IV", " V", " VI", " VII", " VIII", " IX", or " X" (not case sensitive).

For a staff person, FirstName and/or LastSurname should not end with any of the following characters that suggest a generation indicator: " JR", " SR", " I", " II", " III", " IV", " V", " VI", " VII", " VIII", " IX", or " X" (not case sensitive).
S Y Y Y Y
Business Context 30040-0051
For each staff person, at least one of the following must be reported: a professional or paraprofessional ROLE-ID with staff responsibility data or an AUXILIARY-ROLE-ID with staff employment payroll summary data (StaffEducationOrgEmploymentAssociationExtension complex type).

Each staff person must be reported with a TX-StaffRole on responsibility data and/or a TX-AuxiliaryRoleID on staff employment payroll summary data (30050 StaffEducationOrgEmploymentAssociationExtension complex type).
F 1 Y Y
Business Context 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.

For a staff person reported for the Class Roster collection, the following must be reported: ID, Sex, BirthDate, HispanicLatinoEthnicity, HighestLevelOfEducationCompleted, YearsOfPriorProfessionalExperience, and at least one RacialCategory.
F Y Y Y
Business Context 30040-0053
For this staff person, there must be at least one staff responsibility reported.

For each staff person reported in the PEIMS Extended Year submission, they must be reported with a staff responsibility.
F 4 Y Y
Business Context 30040-0054
If TEACHER-INCENTIVE-ALLOTMENT-DESIGNATION-CODE is not reported, then Teacher Class Assignment (Teacher Section Association) data must be reported with a matching TX-UNIQUE-STAFF-ID.

Teachers that are not designated with a TX-TeacherIncentiveAllotmentDesignationCode must be reported with teacher class assignment (teacher section association) data for the Class Roster Winter Submission.
F Y Y Y
Business Context 30040-0055
If TEACHER-INCENTIVE-ALLOTMENT-DESIGNATION-CODE is reported, then there must be a Teacher School Association or a Teacher Section Association with a matching TX-UNIQUE-STAFF-ID.

Teachers identified as Active National Board Certified, designated, or pending new or change of designation must be reported with Teacher School Association or Teacher Section Association data to generate allotment funding.
F Y Y Y
Business Context 30040-0056
If TEACHER-INCENTIVE-ALLOTMENT-DESIGNATION-CODE is not reported, then there must not be a Teacher School Association reported for this TX-UNIQUE-STAFF-ID.

The Teacher School Association data must only be reported for teachers who are Active National Board Certified, designated, or pending new or change of designation to generate allotment funding.
F Y Y Y
Business Context 30040-0057
If PK-TEACHER-REQUIREMENT is not blank, then this staff person should have a Teacher Section Association with a CLASSROOM-POSITION of "Teacher of Record" for a Course Section where HIGH-QUALITY-PK-PROGRAM-INDICATOR is "1".

A staff person with a TX-PKTeacherRequirement should be reported as Teacher of Record for a High Quality PK program course.
S Y Y Y
Business Context 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.

TX-CreditableYearOfServiceIndicator must be reported for all teachers with a TX-TeacherIncentiveAllotmentDesignationCode.
F Y Y Y
Business Context 30040-0059
For this staff person, if STAFF-TYPE-CODE is "4", then there must be at least one staff responsibility reported with ROLE-ID of "087".

If a staff person is a teacher employed at the in-district charter campus by an organization that has been granted a campus charter under TEC, Chapter 12, Subchapter C and is eligible for benefits under TEC §11.174 and 11.147(b), then they must be reported with a Teacher staff responsibility.
F 1 Y Y