| 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 | |||