TSDS Web-Enabled Data Standards

Search. Drill. Find.

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

PDF
Rule Applies To
Rule
Type
Rule # Rule Text /
Business Meaning
Error
Level
TSDS PEIMS
Sub
ESC LEA Campus Charter
Business Context 10010-0006
TOTAL-NUM-SCHOOL-BOARD-REQUESTS should be greater than 0.

Each LEA should be reported with at least one request submitted outside of a school board meeting by a member of the board of trustees for information, documents, and records.
W 3 Y
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", or "38", 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), or "college, career, or military readiness" (38), 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 20032-0072
If OBJECT-CODE is "3XXX", then ACTUAL-AMOUNT should not be a negative number.

The actual financial data should not be reported with a negative fund balance/net position.
W 2 Y Y Y
Business Context 20032-0103
If PROGRAM-INTENT-CODE is "31", then FUND-CODE should be "199" or "420".

If the actual financial data reported includes amounts for the TX-ProgramIntentCode "high school allotment" (31), then the TX-FundCode should be "general fund" (199) or "foundation school program and other state aid" (420).
W 2 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 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 Y Y Y
Business Context 30040-0035
YEARS-OF-PRIOR-PROFESSIONAL-EXPERIENCE should be less than 41.

For a staff person, the YearsOfPriorProfessionalExperience should be less than 41 years.
W Y
Business Context 30040-0036
YEARS-OF-PRIOR-TEACHING-EXPERIENCE should be less than 41.

For a staff person, the YearsOfPriorTeachingExperience should be less than 41 years.
W 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" 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), 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", "03150100"-"03152400", "03823000", "SR000001", "SR000003", "SR000005", "SE000002", "03830100"-"03830400", "02890000", 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", "03150100"-"03152400", "03823000", "SR000001", "SR000003", "SR000005", "SE000002", "03830100"-"03830400", "02890000", or "SS011000", 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" or "023", then SERVICE-ID should be "SE000001", or "SS007000"-"SS009000".

For a staff responsibility, if the TX-StaffRole is "psychological associate" or "LSSP/psychologist", then the TX-ServiceId should be "special education, generic", "guidance and counseling services", "social work services", or "health services".
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", or "114" 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"-"005", "008", "011"-"013", "018"-"020", "023", "026"-"028", "040"-"042", "054", "060"-"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"-"005", "008", "011"-"013", "018"-"020", "023", "026"-"028", "040"-"042", "054", "060"-"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 "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".

There should be at least one staff person who is reported with a TX-StaffRole of "100"-"113" (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" (110) or "Maintenance" (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", or "4", 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", or "4".

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 40110-0048
For GRADE-LEVEL-CODE "05" and "06", at least one student enrollment should have an SSI-PROMOTION-RETENTION-CODE of "03"-"08".

At least one student in grade levels "05" and "06" should have TX-SSIPromotionRetention of "03"-"08".
W 1 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-0076
For GRADE-LEVEL-CODE "08" and "09", at least one student enrollment should have an SSI-PROMOTION-RETENTION-CODE of "09"-"14".

At least one student in grade levels "08" or "09" should have TX-SSIPromotionRetention of "09"-"14".
W 1 Y Y Y
Business Context 40110-0092
If GRADE-LEVEL-CODE is "09"-"12" and CAREER-AND-TECHNICAL-ED-IND-CD is "2", then there should be a Course Transcript for that student where SERVICE-ID is a Career and Technical Education course (CTE Course = "H" in code table C022).

A career and technical education student in grades "09"-"12" that is a participant in a coherent sequence of courses should be reported with a course transcript for a career and technical education course.
W 3 Y Y Y
Business Context 40110-0093
If GRADE-LEVEL-CODE is "09"-"12" and CAREER-AND-TECHNICAL-ED-IND-CD is "2", then there should be Career and Technical Education Attendance and/or Career and Technical Education Flexible Attendance data reported.

A career and technical education student in grades "09"-"12" that is a participant in a coherent sequence of courses should be reported with career and technical education attendance and/or flexible attendance data.
W 3 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 40170-0005
Each Local Education Agency's data submission should report at least one student Career and Technical Education Course.

Student Career & Technical Education Course data should be reported for each Local Education Agency.
W 1 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
Business Context 41169-0004
Each Local Education Agency's data submission should report at least one student Career and Technical Education program association.

There generally should be at least one career and technical education program association reported for each LEA.
W 1 Y Y
Business Context 41169-0005
If DISPLACED-HOMEMAKER-CODE is "1", then AT-RISK-INDICATOR-CODE should be "1".

A career and technical education student that is reported as a displaced homemaker should be reported as an At-Risk student.
W 1 Y Y Y
Business Context 41461-0011
Each Local Education Agency's data submission should contain student Title I Part A program associations.

Student Title I Part A program association data should be reported for each Local Education Agency.
W 3 Y Y
Business Context 42400-0033
For a particular CAMPUS-ID-OF-ENROLLMENT, if there are any students whose sum of TOTAL-ELIGIBLE-DAYS-PRESENT and TOTAL-DAYS-ABSENT for all reporting periods is greater than 180.0, then a message showing the total number of students in this category will be issued asking for verification.

Students should generally not be reported with more than 180 days of enrollment.
W 3 Y Y Y
Business Context 42400-0046
For a particular TX-UNIQUE-STUDENT-ID and REPORTING-PERIOD-INDICATOR-CODE, the sum of ELIGIBLE-DAYS-PRESENT plus INELIGIBLE-DAYS-PRESENT plus DAYS-ABSENT should not be greater than 40.0.

For a student in a particular TX-ReportingPeriod, the sum of TX-TotalEligibleDaysPresent and TX-TotalIneligibleDaysPresent and TX-TotalDaysAbsent should not be more than 40 days.
W 3 Y Y Y
Business Context 42400-0048
For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, NUMBER-DAYS-TAUGHT should not be less than 24.

Each particular TX-CampusIdOfEnrollment, TX-InstructionalTrack, and TX-ReportingPeriod should have at least 24 days of instruction.
W 3 Y Y Y
Business Context 42400-0059
For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, NUMBER-DAYS-TAUGHT should not be greater than 40.

Each particular TX-CampusIdOfEnrollment, TX-InstructionalTrack, and TX-ReportingPeriod should have less than 40 days of instruction.
W 3 Y Y Y
Business Context 42401-0004
For each Attendance data item, if GRADE-LEVEL-CODE is "EE", then TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT must be 0.0 or blank.

Students in grade "EE" must not be reported with Bilingual/ESL program attendance.
W 3 Y Y Y
Business Context 42410-0017
Each Local Education Agency's data submission should report at least one Career and Technical Education Attendance, except for Texas School for the Deaf (227906), Texas School for the Blind and Visually Impaired (227905), and Texas Juvenile Justice Department (227622).

Each Local Education Agency's data submission should report Career and Technical Education Attendance for each student in membership who was enrolled in a secondary Career and Technical Education class, except for Texas School for the Deaf, Texas School for the Blind and Visually Impaired, and Texas Juvenile Justice Department.
W 3 Y Y
Business Context 42500-0029
For a particular TX-UNIQUE-STUDENT-ID and REPORTING-PERIOD-INDICATOR-CODE, there should not be matching Attendance.

A student should not be reported with both flexible attendance and regular attendance in the same TX-ReportingPeriod.
W 3 Y Y Y
Business Context 42500-0033
For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, NUMBER-DAYS-TAUGHT should not be less than 24.

Each particular TX-CampusIdOfEnrollment, TX-InstructionalTrack, and TX-ReportingPeriod should have at least 24 days of instruction.
W 3 Y Y Y
Business Context 42505-0017
If this Local Education Agency's data submission includes any students with Flexible Attendance, then the submission should include at least one Special Education Flexible Attendance, except for Texas School for the Deaf (227906), Texas School for the Blind and Visually Impaired (227905), and Texas Juvenile Justice Department (227622).

There generally should be at least some special education attendance reported for each Local Education Agency that reports flexible attendance, except for Texas School for the Deaf, Texas School for the Blind and Visually Impaired, and Texas Juvenile Justice Department.
W 3, 4 Y Y
Business Context 42510-0015
If this Local Education Agency's data submission includes any students with GRADE-LEVEL-CODE "07"-"12", CAREER-AND-TECHNICAL-ED-IND-CD is not "0", and Flexible Attendance, then the submission should include at least one Career and Technical Education Flexible Attendance, except for Texas School for the Deaf (227906), Texas School for the Blind and Visually Impaired (227905), and Texas Juvenile Justice Department (227622).

If this Local Education Agency reports any career and technical education students in grade "07"-"12" with flexible attendance, then it should report career and technical education flexible attendance, except for Texas School for the Deaf, Texas School for the Blind and Visually Impaired, and Texas Juvenile Justice Department.
W 3, 4 Y Y Y
Business Context 43415-0067
If ONRAMPS-DUAL-ENROLLMENT-INDICATOR-CODE is "1", then DUAL-CREDIT-INDICATOR-CODE should also be "1".

OnRamps dual enrollment courses should generally be reported with TX-DualCreditIndicator.
W 3, 4 Y Y Y
Business Context 44425-0035
DATE-OF-DISCIPLINARY-ACTION should be greater than or equal to August 1, 2019 and less than or equal to July 1, 2020.

The date of a reported disciplinary action should be within the current school year within the range of the months from August through July.
W 3 Y Y Y
Business Context 45435-0010
Each Local Education Agency's data submission should contain Restraint Events.

Restraint Event data should be reported for each Local Education Agency.
W 3 Y Y
Business Context 48011-0017
If GRADE-LEVEL-CODE is "11" or "12", and FHSP-PARTICIPANT-CODE is "1", then at least one of the following fields should be "1": STEM-ENDORSEMENT-INDICATOR-CODE, BUSINESS-AND-INDUSTRY-ENDORSEMENT-INDICATOR-CODE, PUBLIC-SERVICES-ENDORSEMENT-INDICATOR-CODE, ARTS-AND-HUMANITIES-ENDORSEMENT-INDICATOR-CODE, or MULTI-DISCIPLINARY-STUDIES-ENDORSEMENT-INDICATOR-CODE.

A student in grade "11" or "12" who is pursuing the Foundation High School Program should specify at least one of the FHSP Endorsements.
W 3 Y Y Y
Business Context 48011-0021
The number of students with GRADE-LEVEL-CODE "12" and INDIVIDUAL-GRADUATION-COMMITTEE-REVIEW-CODE of "01" should not be equal to the number of students with GRADE-LEVEL-CODE "12".

An LEA or campus should not report all of their 12th grade students as being reviewed by an Individual Graduation Committee.
W 3 Y Y Y
Business Context 48011-0022
The number of students with GRADE-LEVEL-CODE "11" and INDIVIDUAL-GRADUATION-COMMITTEE-REVIEW-CODE of "01" should not be equal to the number of students with GRADE-LEVEL-CODE "11".

An LEA or campus should not report all of their 11th grade students as being reviewed by an Individual Graduation Committee.
W 3 Y Y Y
Business Context 48011-0027
CAMPUS-ID should match a CAMPUS-ID-OF-ENROLLMENT on the student’s highest REPORTING-PERIOD-INDICATOR-CODE on Attendance or Flexible Attendance data.

For a student’s graduation program intention data, the StateOrganizationId (TX-SchoolReference) should be the last campus the student attended in the school year. If the student attended more than one campus in the highest reporting period attended, then StateOrganizationId (TX-SchoolReference) should be one of those campuses.
W 3 Y Y Y