TSDS Web-Enabled Data Standards

Search. Drill. Find.

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

PDF
Rule Applies To
Rule
Type
Rule # Rule Text /
Business Meaning
Error
Level
TSDS PEIMS
Sub
ESC LEA Campus Charter
Business Context 10011-0007
Each Local Education Agency's data submission should report a Shared Services Arrangement for each shared services arrangement type in which they are a member or fiscal agent.

Generally, each local education agency participates in at least one shared services arrangement and should report the applicable data for each shared services arrangement type in which they are a member or fiscal agent.
W 1, 2 Y Y Y
Business Context 20030-0052
If PROGRAM-INTENT-CODE is "31", "36", "37", "38", or "43" then FUND-CODE should be "199" or "420".

If the budget data reported includes budget amounts for the TX-ProgramIntentCode "High School Allotment" (31), "Early Education Allotment" (36), "Dyslexia or Related Disorder Services" (37), "College, Career, or Military Readiness" (38), or "Dyslexia – Special Education" (43), then the TX-FundCode should be "General Fund" (199) or "Foundation School Program and Other State Aid" (420).
W 1 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 30050-0002
NUMBER-DAYS-EMPLOYED should be between 100 and 261.

For a staff person, the TX-NumberDaysEmployed should be between 100 and 261.
W 1 Y Y Y
Business Context 30055-0006
If the Local Education Agency's data submission has Contracted Instructional Staff, then the submission should also contain data for individual Staff with STAFF-TYPE-CODE of "3".

If contracted instructional staff are reported, then at least one staff person with staff type code "contracted professional staff" (3) should also be reported.
W 1 Y Y
Business Context 30060-0020
There should be at least one staff payroll where ORGANIZATION-CODE is "701".

For a Local Education Agency, at least some staff payroll should be paid from a TX-OrganizationCode for Superintendent's Office.
W 1 Y Y
Business Context 30060-0038
If PROGRAM-INTENT-CODE is "31", then FUND-CODE should be "199", "266", "277", or "420".

If the staff payroll data reported includes amounts for the TX-ProgramIntentCode "High School Allotment" (31), then the TX-FundCode should be "General Fund" (199), "Elementary and Secondary School Emergency Relief Fund (ESSER) of the Coronavirus Aid, Relief, and Economic Security (CARES) Act" (266), "Coronavirus Relief Fund (CRF) of the CARES Act" (277), or "Foundation School Program And Other State Aid" (420).
W 1 Y Y Y
Business Context 30060-0042
If OBJECT-CODE is "6112" and FUNCTION-CODE is "11", then ROLE-ID should be "047".

For staff payroll, if TX-ObjectCode is "salaries or wages for substitute teachers and other professionals" and TX-FunctionCode is "instruction", then TX-StaffRole should be "substitute teacher", indicating this staff person is a substitute teacher serving in a classroom where the teacher has quit, died, or been terminated.
W 1 Y Y Y
Business Context 30060-0044
For a particular TX-UNIQUE-STAFF-ID, the sum of all PAYROLL-AMOUNTs where PAYROLL-ACTIVITY-CODE is not "80" should not be between 10,001 and 25,000.

For staff payroll, total non-base salary for a staff person should not be between 10,001 and 25,000.
W 1 Y Y Y
Business Context 30060-0050
For a particular TX-UNIQUE-STAFF-ID, if ROLE-ID is "002", "005"-"008", "011", "013", "015", "018", "021"-"023", "026", "028", "032", "040"-"042", "047", "064", "065", or "079", then the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" should not be greater than 68,000.

If a staff person has a TX-StaffRole of "002", "005"-"008", "011", "013", "015", "018", "021"-"023", "026", "028", "032", "040"-"042", "047", "064", "065", or "079", then their total base salary should not be greater than $68,000.
W 1 Y Y Y
Business Context 30060-0054
For a particular TX-UNIQUE-STAFF-ID, if ROLE-ID is "003", "004", "012", "020", "027", "040", or "043"-"045", then the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" should not be greater than 105,000.

If a staff person has a TX-StaffRole of "003", "004", "012", "020", "027", "040", or "043"-"045", then their total base salary should not be greater than $105,000.
W 1 Y Y Y
Business Context 30060-0055
For a particular TX-UNIQUE-STAFF-ID, if ROLE-ID is "003", "004", "012", "020", "061"-"065", or "079", and PERCENT-DAY-EMPLOYED is 100, and NUMBER-DAYS-EMPLOYED is greater than or equal to 187, then the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" should not be less than 44,000.

If a full-time staff person has a TX-StaffRole of "003", "004", "012", "020", "061"-"065", or "079", then their total base salary should not be less than $44,000.
W 1 Y Y Y
Business Context 30060-0056
For a particular TX-UNIQUE-STAFF-ID, if ROLE-ID is "043"-"045", and PERCENT-DAY-EMPLOYED is 100, and NUMBER-DAYS-EMPLOYED is greater than or equal to 187, then the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" should not be less than 25,000.

If a full-time staff person has a TX-StaffRole of Business Manager, Tax Assessor/Collector, or Human Resources Director, then their total base salary should not be less than $25,000.
W 1 Y Y Y
Business Context 30090-0061
If SERVICE-ID is "01010000", then POPULATION-SERVED-CODE should be "02", "03", "07", or "10".

For a staff responsibility, if the TX-ServiceId is "pre-kindergarten", then the TX-PopulationServed should be "bilingual students" (02), "compensatory/remedial education students" (03), "ESL students" (07), or "migrant students" (10).
W 1 Y Y Y Y
Business Context 30090-0062
If SERVICE-ID is not "02000000", "02530002", "02530003", "02530004", "02530005", "02530006", "02530007", "02530008", "02890000", "03150100" - "03152400", "03823000", "03830100", "03830200", "03830300", "03830400", "SE000002", "SR000001", "SR000003", "SR000005", or "SS011000", then NUMBER-STUDENTS-IN-CLASS should not be greater than 40.

For a staff responsibility where the TX-ServiceId is not "02000000", "02530002", "02530003", "02530004", "02530005", "02530006", "02530007", "02530008", "02890000", "03150100" - "03152400", "03823000", "03830100", "03830200", "03830300", "03830400", "SE000002", "SR000001", "SR000003", "SR000005", or "SS011000" (certain combined grade, PE, music, dance, and additional responsibilities), then the TX-NumberStudentsInClass should be 40 or less.
W 1 Y Y Y Y
Business Context 30090-0064
If ROLE-ID is "002" or "015", then SERVICE-ID should be "SE000001", "SE000005", or "SE000006".

For a staff responsibility, if the TX-StaffRole is "art therapist" or "music therapist", then the TX-ServiceId should be "special education, generic", "visually impaired", or "auditorially impaired".
W 1 Y Y Y Y
Business Context 30090-0066
If ROLE-ID is "005", "023", "115", "116", "117", or "118", then SERVICE-ID should be "SE000001", or "SS007000"-"SS009000".

For a staff responsibility, if the TX-StaffRole is Psychological Associate (005), LSSP/Psychologist (023), Psychiatric Nurse (115), Licensed Clinical Social Worker (116), Licensed Professional Counselor (117), or Licensed Marriage and Family Therapist (118) then the TX-ServiceId should be "Special Education, Generic" (SE000001), "Guidance and Counseling Services" (SS007000), "Social Work Services" (SS008000), or "Health Services" (SS009000).
W 1 Y Y Y Y
Business Context 30090-0067
If ROLE-ID is "006", then SERVICE-ID should be "SE000001"-"SE000003" or "SE000006".

For a staff responsibility, if the TX-StaffRole is "audiologist", then the TX-ServiceId should be "special education, generic", "speech therapy", "speech assessment", or "auditorially impaired".
W 1 Y Y Y Y
Business Context 30090-0068
If ROLE-ID is "007", "011", or "016", then SERVICE-ID should be "SE000001".

For a staff responsibility, if the TX-StaffRole is "corrective therapist", "educational diagnostician", or "occupational therapist", then the TX-ServiceId should be "special education, generic".
W 1 Y Y Y Y
Business Context 30090-0069
If ROLE-ID is "013", then the last three characters of CAMPUS-ID should not be "701"-"703", "720", or "750".

For a staff responsibility, if the TX-StaffRole is "librarian", then the StateOrganizationId should not be a financial campus for the following: superintendent's office, school board, tax costs, direct costs-general administration, or indirect costs-general administration.
W 1 Y Y Y Y
Business Context 30090-0070
If ROLE-ID is "017", "018", or "021", then SERVICE-ID should be "SE000001" or "SE000004"-"SE000006".

For a staff responsibility, if the TX-StaffRole is "Certified Orientation and Mobility Specialist (COMS)", "physical therapist", or "recreation therapist", then the TX-ServiceId should be one of the following: "special education, generic", "adaptive physical education", "visually impaired", or "auditorially impaired".
W 1 Y Y Y Y
Business Context 30090-0071
If ROLE-ID is "022", then the last three characters of CAMPUS-ID should not be "701"-"703", "720", "750", or "751".

For a staff responsibility, if the TX-StaffRole is "school nurse", then the StateOrganizationId should not be a financial campus for one of the following: superintendent's office, school board, tax costs, direct costs-general administration, indirect costs-general administration, or fiscal agent shared services arrangement.
W 1 Y Y Y Y
Business Context 30090-0072
If ROLE-ID is "032", then SERVICE-ID should not be "SAXXXXXX", "SSXXXXXX", or "SE000002"-"SE000006".

For a staff responsibility, if the TX-StaffRole is "work-based learning site coordinator", then the TX-ServiceId should not be "instructional educational aides and interpreters", non-teaching responsibilities, "speech therapy", "speech assessment", "adaptive physical education", "visually impaired", or "auditorially impaired".
W 1 Y Y Y Y
Business Context 30090-0073
If ROLE-ID is "041", then SERVICE-ID should be "SS001XXX", "SS002000", "SS004XXX", or "SS005XXX".

For a staff responsibility, if the TX-StaffRole is "teacher facilitator", then the TX-ServiceId should be "instructional administration", "instructional resources and media services", "instructional research and development", or "curriculum and personnel development"
W 1 Y Y Y Y
Business Context 30090-0074
If ROLE-ID is "042", then SERVICE-ID should be "SS001000"-"SS001003", or "SS005000".

For a staff responsibility, if the TX-StaffRole is "teacher appraiser", then the TX-ServiceId should be "instructional administration" (elementary, middle/junior high, or secondary), or "curriculum and personnel development".
W 1 Y Y Y Y
Business Context 30090-0075
If ROLE-ID is "114", then SERVICE-ID should be any that begin with "SS" except those that begin with "SS001", "SS013000", "SS014000", "SS016000", or "SS019000".

For a staff responsibility, if the TX-StaffRole is "Other Campus Exempt Professional Auxiliary" (114), then the TX-ServiceId should be any that begin with "SS" except "Instructional Administration" (starts with SS001), "General Administration" (SS013000), "Plant Maintenance and Operation" (SS014000), "Computer Processing" (SS016000), or "Community Services" (SS019000).
W 1 Y Y Y
Business Context 30090-0077
If ROLE-ID is "113", then SERVICE-ID should be "SS013000" or "SS023000".

For a staff responsibility, if the TX-StaffRole is "Other District Exempt Professional Auxiliary" (113), then the TX-ServiceId should be "General Administration" (SS013000) or "Certification Services" (SS023000).
W 1 Y Y Y
Business Context 30090-0080
The total number of staff where ROLE-ID is "002", "005", "006", "007", "008", "011", "013", "015", "016", "017", "018", "019", "021", "022", "023", "026", "028", "032", "041", "042", "100", "101", "102", "103", "104", "105", "106", "107", "108", "109", "110", "111", "112", "113", "114", "115", "116", "117", or "118" should not vary by more than 50% from the total number of staff reported with these ROLE-IDs for the prior year.

The total number of support staff should not vary by more than 50% from the total support staff reported last year.
W 1 Y Y Y
Business Context 30090-0081
The total number of staff where ROLE-ID is "003", "004", "012", "020", "027", "040", "043"-"045", "060"-"065", or "079" should not vary by more than 50% from the total number of staff reported with these ROLE-IDs for the prior year.

The total number of administrative staff should not vary by more than 50% from the total administrative staff reported last year.
W 1 Y Y Y
Business Context 30090-0082
The total number of staff where ROLE-ID is "033" should not vary by more than 50% from the total number of staff reported with this ROLE-ID for the prior year.

The total number of educational aides should not vary by more than 50% from the total educational aides reported last year.
W 1 Y Y Y
Business Context 30090-0083
The total number of staff where ROLE-ID is "033" and POPULATION-SERVED-CODE is "06" should not vary by more than 50% from the total number of staff reported with this ROLE-ID and POPULATION-SERVED-CODE for the prior year.

The total number of educational aides for special education students should not vary by more than 50% from the total educational aides for special education students reported last year.
W 1 Y Y Y
Business Context 30090-0084
If ROLE-ID is "003", "004", "005", "008", "011", "012", "013", "018", "019", "020", "023", "024", "026", "027", "028", "040", "041", "042", "054", "060", "061", "062", "063", "064", "065", "079", or "087", then HIGHEST-DEGREE-LEVEL-CODE should not be "0".

For a staff person, the TX-HighestDegreeLevel should be Bachelor’s degree or higher if they serve as one of the following TX-StaffRoles: "003", "004", "005", "008", "011", "012", "013", "018", "019", "020", "023", "024", "026", "027", "028", "040", "041", "042", "054", "060", "061", "062", "063", "064", "065", "079", or "087".
W 1 Y Y Y
Business Context 30090-0088
There should be at least one staff person with ROLE-ID "008".

There should be at least one staff person who is reported with a TX-StaffRole of "School Counselor" (008).
W 1 Y Y
Business Context 30090-0089
There should be at least one staff person with ROLE-ID "043".

There should be at least one staff person who is reported with a TX-StaffRole of "Business Manager" (043).
W 1 Y Y
Business Context 30090-0090
There should be at least one staff person with ROLE-ID "045".

There should be at least one staff person who is reported with a TX-StaffRole of "Director of Personnel/Human Resources" (045).
W 1 Y Y
Business Context 30090-0091
There should be at least one staff person with ROLE-ID "055".

There should be at least one staff person who is reported with a TX-StaffRole of "Registrar" (055).
W 1 Y Y
Business Context 30090-0092
There should be at least one staff person with ROLE-ID "114".

There should be at least one staff person who is reported with a TX-StaffRole of "Other Campus Exempt Professional Auxiliary" (114).
W 1 Y Y
Business Context 30090-0093
There should be at least one staff person with ROLE-ID "100"-"113" or "115"-"118" (various district non-instructional professional role IDs).

There should be at least one staff person who is reported with a TX-StaffRole of "100"-"113" or "115"-"118" (various district non-instructional professional role IDs).
W 1 Y Y
Business Context 30090-0094
If ROLE-ID is "100", "101", "104", or "112", then SERVICE-ID should be "SS013000".

For a staff responsibility, if the TX-StaffRole is "Textbook Manager" (100), "Legal Services" (101), "Internal Auditor" (104), or "Business Services Professional" (112), then the TX-ServiceId should be "General Administration" (SS013000).
W 1 Y Y Y
Business Context 30090-0095
If ROLE-ID is "102", then SERVICE-ID should be "SS006000" or "SS019000".

For a staff responsibility, if the TX-StaffRole is "Communication Professional" (102), then the TX-ServiceId should be "Communication and Dissemination" (SS006000), or "Community Services" (SS019000).
W 1 Y Y Y
Business Context 30090-0096
If ROLE-ID is "103", then SERVICE-ID should be "SS013000" or begin with "SS004".

For a staff responsibility, if the TX-StaffRole is "Research/Evaluation Professional" (103), then the TX-ServiceId should be "General Administration" (SS013000), or "Instructional Research and Development" (starts with SS004).
W 1 Y Y Y
Business Context 30090-0097
If ROLE-ID is "105", then SERVICE-ID should be "SS020000" or "SS021000".

For a staff responsibility, if the TX-StaffRole is "Security" (105), then the TX-ServiceId should be "Truant Officer/Visiting Teacher Services" (SS020000), or "Security Services" (SS021000).
W 1 Y Y Y
Business Context 30090-0098
If ROLE-ID is "106", then SERVICE-ID should be "SS015000", "SS016000", "SS017000", "SS018000" or "SS025000".

For a staff responsibility, if the TX-StaffRole is "Information Technology Professional" (106), then the TX-ServiceId should be "Data Processing Management" (SS015000), "Computer Processing" (SS016000), "Data Processing Development" (SS017000), "Data Processing Technical Assistance" (SS018000), or "Information Technology Activities" (SS025000).
W 1 Y Y Y
Business Context 30090-0099
If ROLE-ID is "107", then SERVICE-ID should be "SS012000".

For a staff responsibility, if the TX-StaffRole is "Food Service Professional" (107), then the TX-ServiceId should be "Food Services" (SS012000).
W 1 Y Y Y
Business Context 30090-0100
If ROLE-ID is "108", then SERVICE-ID should be "SS010000".

For a staff responsibility, if the TX-StaffRole is "Transportation" (108), then the TX-ServiceId should be "Pupil Transportation" (SS010000).
W 1 Y Y Y
Business Context 30090-0101
If ROLE-ID is "109", then SERVICE-ID should be "SS011000".

For a staff responsibility, if the TX-StaffRole is "Athletics" (109), then the TX-ServiceId should be "Extracurricular Activities" (SS011000).
W 1 Y Y Y
Business Context 30090-0102
If ROLE-ID is "110" or "111", then SERVICE-ID should be "SS014000".

For a staff responsibility, if the TX-StaffRole is "Custodial – Staff serving in a professional/management role" (110) or "Maintenance – Staff serving in a professional/management role" (111), then the TX-ServiceId should be "Plant Maintenance and Operation" (SS014000).
W 1 Y Y Y
Business Context 40100-0074
If AS-OF-STATUS-CODE is "D", or "E", then the student should be reported as a Leaver.

If a student is indicated as being enrolled last year but not enrolled this year in the school start window, or not on the PEIMS Fall snapshot (as-of) date, then they should be reported as a Leaver.
W 1 Y Y Y
Business Context 40100-0091
If there are any students where MIDDLE-NAME is blank, then a warning message showing the total number of students in this category will be issued asking for verification.

The number of students with no MiddleName should be verified.
W 1, 3, 4 Y Y Y
Business Context 40100-0152
If LEP-INDICATOR-CODE is "1", "F", "S", "3", "4", or "5", and HOME-LANGUAGE-CODE is not "98", then STUDENT-LANGUAGE-CODE should not be "98".

A LEP/English learner (EL) student generally should not be reported as speaking English, even if English is not the language spoken in their home.
W 1 Y Y Y
Business Context 40100-0155
If STUDENT-LANGUAGE-CODE and HOME-LANGUAGE-CODE are both not "98", then LEP-INDICATOR-CODE should be "1", "F", "S", "3", "4", or "5".

If the student does not speak English and English is not the language spoken in their home, then the student should be reported as LEP/English learner (EL).
W 1 Y Y Y
Business Context 40100-0200
If AS-OF-STATUS-CODE is not "A", and the student’s age on September 1 of the current school year is greater than or equal to 18 and less than 26, then ADULT-PREVIOUS-ATTENDANCE-INDICATOR-CODE should not be blank.

TX-AdultPreviousAttendanceIndicator should be reported for enrolled students who are age 18-25 on September 1 of the current school year who are currently enrolled in a high school equivalency program, dropout recovery school, or other adult education program (under TEC Section 29.259).
W 1, 3 Y Y Y
Business Context 40110-0066
If PARENTAL-PERMISSION-CODE is "D", then GRADE-LEVEL-CODE should not be "09"-"12".

If a parent or guardian has approved placement of a LEP/English learner (EL) student in the Bilingual Program, then the student typically will not be enrolled in TX-GradeLevel "09"-"12".
W 1 Y Y Y
Business Context 40110-0067
For a given CAMPUS-ID-OF-ENROLLMENT, the total number of student enrollments divided by the total number of staff with a unique TX-UNIQUE-STAFF-ID, ROLE-ID of "047" or "087", and matching CAMPUS-ID should not be greater than 30.

For a given campus, the ratio of students to teachers should not be greater than 30 to 1.
W 1 Y Y Y
Business Context 40110-0109
STUDENT-ATTRIBUTION-CODE should not be "06".

Generally, open enrollment charter schools do not enroll students from outside their charter school boundaries.
W 1, 3, 4 Y
Business Context 40110-0208
If SPECIAL-ED-INDICATOR-CODE is "0", GRADE-LEVEL-CODE is "EE", and CAMPUS-ID-OF-ENROLLMENT on a student's school association data is blank or not reported, then a warning message will be displayed asking for verification of this student’s data.

If a student in TX-GradeLevel "EE" is reported without a TX-CampusIdOfEnrollment on their student school association data, then their TX-SpecialEducation and TX-CampusIdOfEnrollment should be verified for accuracy.
W 1 Y Y Y
Business Context 40203-0014
For a particular CAMPUS-ID, there should be at least two different LEAVER-REASON-CODE values reported.

For a particular campus, all of the leavers should not be reported with the same leaver reason code.
W 1 Y Y Y
Business Context 40203-0021
At least one student leaver graduate should be reported with GRADUATION-TYPE-CODE "34", "54", "55", "56", or "57".

At least one graduate should be reported as having graduated under the Foundation High School Program (FHSP).
W 1 Y Y
Business Context 41163-0027
If EARLY-CHILDHOOD-INTERV-IND-CODE is "1", then INSTRUCTIONAL-SETTING-CODE should be "01", "31", "32", or "34".

If a special education student is participating in the Early Childhood Intervention program, then TX-InstructionalSetting should be homebound, home-based instruction, center-based instruction, or other environment.
W 1 Y Y Y
Business Context 41163-0028
If PRIMARY-DISABILITY-CODE is "09", and INSTRUCTIONAL-SETTING-CODE is not "40", then SPEECH-THERAPY-INDICATOR-CODE should not be "0".

If a student's TX-PrimaryDisability is speech impairment and TX-InstructionalSetting is mainstream, then the student should receive speech therapy.
W 1 Y Y Y