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-0011
For a particular DISTRICT-ID, if more than one Shared Services Arrangement is reported with the same SHARED-SVCS-ARRANGEMT-TYPE-CODE, then a special warning message will display for verification.

Verify that this district participates in more than one Shared Services Arrangement of the same TX-SharedServiceArrangement type.
S 1, 2 Y Y Y
Business Context 10020-0007
For each campus registered with TEA as an active instructional campus, there should be Budget data where ORGANIZATION-CODE matches the last three characters of CAMPUS-ID.

Budget data where TX-OrganizationCode matches the lasts three characters of StateOrganizationId should be reported for each active instructional campus.
S 1 Y Y
Business Context 10020-0009
Except for Texas School For the Blind and Visually Impaired (227905), Texas School for the Deaf (227906), and the Texas Juvenile Justice Department (227622), for each district’s data submission, and for each campus registered with TEA as an active instructional campus (except JJAEPs), there should be data for each staff person.

For each LEA's data submission (except for Texas School for the Blind and Visually Impaired, Texas School for the Deaf, and Texas Juvenile Justice Department), staff data should be reported for each staff person for each active instructional campus (except JJAEPs).
S 1 Y Y
Business Context 10020-0013
For each campus registered with TEA as an active instructional campus, except JJAEPs, there should be data for each staff responsibility.

Staff assignment data should be reported for each professional and paraprofessional staff person for each active instructional campus (except JJAEPs).
S 1 Y Y
Business Context 10020-0014
For each campus registered with TEA as an active instructional campus, there should be student data for each student served by the Local Education Agency.

Student data should be reported for each student for each active instructional campus.
S Y 1, 3 Y Y
Business Context 10020-0015
For each campus registered with TEA as an active instructional campus, excluding DAEPs and budgeted campuses, there should be at least one student enrollment with a matching CAMPUS-ID-OF-ENROLLMENT.

A campus registered with the TEA as an active instructional campus (except for DAEPs and budgeted campuses) should report student enrollment.
S 1 Y Y
Business Context 10020-0016
For each campus registered with TEA as an active instructional campus in the prior school year with any grade 7-12, there should be at least one leaver with a matching CAMPUS-ID-OF-ENROLLMENT.

A campus registered with the TEA as an active instructional campus in the prior school year with any grade 7-12 should report student leavers.
S 1 Y Y
Business Context 10020-0048
For each campus registered with TEA as an approved Texas Science, Technology, Engineering, and Mathematics (T-STEM) Academy campus, there should be at least one student with T-STEM-INDICATOR-CODE of "1", or else a warning will display for verification

Each campus approved as a Texas Science, Technology, Engineering, and Mathematics (T-STEM) Academy campus should report at least one student as enrolled in the program. A list of approved T-STEM Academies is available as a link with the latest release of the Texas Education Data Standards.
S 1, 3, 4 Y Y
Business Context 10020-0049
For each campus registered with TEA as an approved Early College High School (ECHS) campus, there should be at least one student with ECHS-INDICATOR-CODE of "1", or else a warning will display for verification

Each campus approved as an Early College High School (ECHS) campus should report at least one student as enrolled in the program. A list of approved Early College High Schools is available as a link with the latest release of the Texas Education Data Standards.
S 1, 3, 4 Y Y
Business Context 10020-0050
For each campus registered with TEA as an approved campus to run a Pathways in Technology (P-TECH) program, there should be at least one student with P-TECH-INDICATOR-CODE of "1", or else a warning will display for verification

Each campus approved to run a Pathways in Technology (P-TECH) program should report at least one student as participating in the program. A list of approved P-TECH programs is available as a link with the latest release of the Texas Education Data Standards.
S 1, 3, 4 Y Y
Business Context 10020-0057
For each campus that has entered into an agreement with the New Tech Network to operate as a New Tech Network campus, there should be at least one student with NEW-TECH-INDICATOR-CODE of "1", or else a warning will display for verification

Each campus approved to be a New Tech Network campus should report at least one student as participating in the program. A list of approved New Tech Network campuses is available as a link with the latest release of the Texas Education Data Standards.
S 1, 3, 4 Y Y
Business Context 20030-0033
There should be Budget data where FUND-CODE is "101", "240", or "701".

The budget data reported for a local education agency should include amounts for the following fund codes: "Food Service" (101), "National School Breakfast and Lunch Program" (240), or "Enterprise Fund - National School Breakfast and Lunch Program" (701).
S 1 Y
Business Context 20030-0034
There should be Budget data where FUND-CODE is "199" and FUNCTION-CODE is "13".

The budget data reported should include at least one budget amount where the TX-FundCode is "general fund" (199) and the TX-FunctionCode is "curriculum development and instructional staff development" (13).
S 1 Y Y
Business Context 20030-0035
If there is any Budget data for FUND-CODE "240", then there should be Budget data for FUND-CODE "240" for both OBJECT-CODE "5751" and "592X".

If a local education agency reports budget data for the "National School Breakfast and Lunch Program" fund code (240), then there should be budget data for that fund reported for the "food service activity" object code (5751) and at least one of the following object codes: "school breakfast program" (5921), "National School Lunch Program" (5922), "USDA donated commodities" (5923), or "federal revenues distributed by TEA" (5929).
S 1 Y Y Y
Business Context 20030-0038
There should be at least two Budget data items where OBJECT-CODE is "5XXX".

The budget data reported should include revenues (5XXX) for at least two different TX-ObjectCodes.
S 1 Y Y Y
Business Context 20030-0039
For each campus registered with TEA as an active instructional campus, excluding JJAEPs, there should be Budget data where OBJECT-CODE is "6100" or "6200", FUNCTION-CODE is "11", PROGRAM-INTENT-CODE is not "99", and ORGANIZATION-CODE matches the last three characters of CAMPUS-ID.

The budget data reported for each active instructional campus (excluding JJAEPs), should include amounts where the TX-ObjectCode is "payroll costs" (6100) or "professional and contracted services" (6200), the TX-FunctionCode is "instruction" (11), the TX-ProgramIntentCode is not "undistributed" (99), and the TX-OrganizationCode that matches the last three characters of Campus ID.
S 1 Y Y
Business Context 20030-0040
There should be Budget data where OBJECT-CODE is "6100" and ORGANIZATION-CODE is "701".

The budget data reported for a local education agency should include payroll expenditures for the Superintendent's Office.
S 1 Y Y
Business Context 20030-0041
There should be Budget data where OBJECT-CODE is "6100" and ORGANIZATION-CODE is not "999", and Budget data where OBJECT-CODE is "6100" and ORGANIZATION-CODE is "750".

The budget reported for a local education agency should include payroll expenditures in a TX-OrganizationCode other than the "undistributed" (999) organization code, and should also includes payroll expenditures in the "Indirect Costs General Administration" (750) organization code.
S 1 Y Y
Business Context 20030-0042
If DISTRICT-ID is not "015906", "015913", "015914", or "180901", then there should be Budget data where FUNCTION-CODE is "41" or "99" and ORGANIZATION-CODE is "703".

For all independent school districts, excluding Lackland (Air Force Base) ISD, Randolph Field (Air Force Base) ISD, Fort Sam Houston (Army Base) ISD, and Boys Ranch (Foster Child Group Home) ISD, the budget data reported should include amounts where the TX-FunctionCode is "general administration" (41) or "other intergovernmental charges" (99) and the TX-OrganizationCode is "tax costs" (703).
S 1 Y
Business Context 20030-0043
BUDGET-AMOUNT should not be greater than 3 billion dollars.

A budget item reported for a local education agency should not be reported in an TX-Amount greater than 3 billion dollars ($3,000,000,000).
S 1 Y Y Y
Business Context 20030-0044
OBJECT-CODE should not be "7959" or "7999".

The budget data reported should only include the TX-ObjectCode "other gains" (7959) or "net assets released from temporary restrictions" (7999) when the LEA is an open enrollment charter school.
S 1 Y Y
Business Context 20030-0045
If OBJECT-CODE is "5XXX", then BUDGET-AMOUNT should be greater than zero.

For budget revenues, the TX-Amount should be greater than zero.
S 1 Y Y Y
Business Context 20030-0050
If FUNCTION-CODE is "9X", then ORGANIZATION-CODE should be "999".

If the budget data reported for a local education agency includes amounts for "intergovernmental charges" (9X) TX-FunctionCodes, then the TX-OrganizationCode should be "undistributed" (999).
S 1 Y Y Y
Business Context 20030-0054
If the sum of BUDGET-AMOUNTs where OBJECT-CODE "5921" is greater than 0, and the sum of BUDGET-AMOUNTs for OBJECT-CODE "5922" is greater than 0, then the sum of BUDGET-AMOUNTs where OBJECT-CODE "5829" should be greater than 0.

If the budget data reported includes positive revenue amounts for the "school breakfast program" (5921) and the "National School Lunch Program" (5922), then the budget data should also include positive revenue amounts for the "state program revenues distributed by the TEA" (5829).
S 1 Y Y Y
Business Context 20030-0055
The sum of BUDGET-AMOUNTs where FUNCTION-CODE is "31"-"33" should be greater than or equal to the sum of all BUDGET-AMOUNTs where OBJECT-CODE is "5932".

The total budget amounts for TX-FunctionCodes "guidance, counseling, and evaluation services" (31), "social work services" (32), and "health services" (33) should be greater than or equal to the total budget amounts for the TX-ObjectCode "Medicaid Administrative Claiming Program-MAC" (5932).
S 1 Y Y Y
Business Context 20030-0056
The sum of BUDGET-AMOUNTs where OBJECT-CODE is "6100"-"6600" should not be greater than 50,000,000.

The total budget expenditures should not be greater than $50,000,000.
S 1 Y Y Y
Business Context 20030-0057
The sum of BUDGET-AMOUNTs where OBJECT-CODE is "6XXX" should not be more than twice the sum of all BUDGET-AMOUNTs where OBJECT-CODE is "5XXX".

The total budget expenditures reported should not be more than twice the total budget revenues reported.
S 1 Y Y Y
Business Context 20030-0058
If ADA is less than 500, then the sum of BUDGET-AMOUNTs where OBJECT-CODE is "6XXX" should not be greater than 10,000,000.

If ADA is less than 500, then total budget expenditures should not be greater than $10,000,000.
S 1 Y Y
Business Context 20030-0059
If ADA is between 500 and 1,000, then the sum of BUDGET-AMOUNTs where OBJECT-CODE is "6XXX" should not be greater than 20,000,000.

If ADA is between 500 and 1,000, then total budget expenditures should not be greater than $20,000,000.
S 1 Y Y
Business Context 20030-0060
If ADA is between 1,001 and 5,000, then the sum of BUDGET-AMOUNTs where OBJECT-CODE is "6XXX" should not be greater than 70,000,000.

If ADA is between 1,001 and 5,000, then total budget expenditures should not be greater than $70,000,000.
S 1 Y Y
Business Context 20030-0061
If ADA is between 5,001 and 10,000, then the sum of BUDGET-AMOUNTs where OBJECT-CODE is "6XXX" should not be greater than 175,000,000.

If ADA is between 5,001 and 10,000, then total budget expenditures should not be greater than $175,000,000.
S 1 Y Y
Business Context 20030-0062
If ADA is between 10,001 and 20,000, then the sum of BUDGET-AMOUNTs where OBJECT-CODE is "6XXX" should not be greater than 200,000,000.

If ADA is between 10,001 and 20,000, then total budget expenditures should not be greater than $200,000,000.
S 1 Y Y
Business Context 20030-0063
If ADA is between 20,001 and 30,000, then the sum of BUDGET-AMOUNTs where OBJECT-CODE is "6XXX" should not be greater than 300,000,000.

If ADA is between 20,001 and 30,000, then total budget expenditures should not be greater than $300,000,000.
S 1 Y Y
Business Context 20030-0064
If ADA is between 30,001 and 50,000, then the sum of BUDGET-AMOUNTs where OBJECT-CODE is "6XXX" should not be greater than 450,000,000.

If ADA is between 30,001 and 50,000, then total budget expenditures should not be greater than $450,000,000.
S 1 Y Y
Business Context 20030-0065
If ADA is between 50,001 and 60,000, then the sum of BUDGET-AMOUNTs where OBJECT-CODE is "6XXX" should not be greater than 600,000,000.

If ADA is between 50,001 and 60,000, then total budget expenditures should not be greater than 600,000,000.
S 1 Y Y
Business Context 20030-0066
If ADA is between 60,001 and 80,000, then the sum of BUDGET-AMOUNTs where OBJECT-CODE is "6XXX" should not be greater than 800,000,000.

If ADA is between 60,001 and 80,000, then total budget expenditures should not be greater than $800,000,000.
S 1 Y Y
Business Context 20030-0067
The sum of all BUDGET-AMOUNTs where OBJECT-CODE is "5XXX" divided by ADA should not exceed 19,000.

The total budget revenues for a local education agency should not be greater than $19,000 per ADA.
S 1 Y Y
Business Context 20030-0068
The sum of BUDGET-AMOUNTs where FUND-CODE is "199", FUNCTION-CODE is "11", OBJECT-CODE is "6100", and PROGRAM-INTENT-CODE is "11" divided by ADA should be between 2,000 and 10,000.

The total Budget per ADA should be between $2,000 and $10,000 for all budget amounts where the TX-FundCode is "general fund" (199), the TX-FunctionCode is "instruction" (11), the TX-ObjectCode is "payroll" (6100), and the TX-ProgramIntentCode is "basic educational services" (11).
S 1 Y Y
Business Context 20030-0069
The sum of BUDGET-AMOUNTs where FUNCTION-CODE is not "81" and OBJECT-CODE is not "5XXX" or "6500"-"899X" divided by ADA should be between 5,000 and 20,000.

The total amount budgeted per Average Daily Attendance (ADA) unit should be between $5,000 and $20,000 where the TX-ObjectCodes reported are "payroll costs" (6100), "professional and contracted services" (6200), "supplies and materials" (6300), or "other operating costs" (6400), and excluding amounts where the TX-FunctionCode is "facilities acquisition and construction" (81).
S 1 Y Y
Business Context 20030-0070
The sum of BUDGET-AMOUNTs where OBJECT-CODE is "5711" or "5719" should not vary by more than 15% from the LEA's total tax levy as reported to the State Comptroller's Office for the prior year.

The total budget amounts for TX-ObjectCodes "taxes, current year levy" (5711) and "penalties, interest and other tax revenues" (5719) reported should not vary by more than 15% from the LEA's total tax levy as reported to the State Comptroller's Office for the prior year.
S 1 Y
Business Context 20030-0071
The sum of BUDGET-AMOUNTs where OBJECT-CODE is "6100"-"6400" and PROGRAM-INTENT-CODE is "21" should not be greater than 7% of the sum of all BUDGET-AMOUNTs where OBJECT-CODE is "6100"-"6400".

The budget data reported for the "gifted and talented" program (PIC 21) should not be more that 7 percent of the total expenditures for the "payroll costs" (6100), "professional and contracted services" (6200), "supplies and materials" (6300), and "other operating costs" (6400) object codes.
S 1 Y Y Y
Business Context 20030-0072
The sum of BUDGET-AMOUNTs where OBJECT-CODE is "6100"-"6400" and PROGRAM-INTENT-CODE is "23" should not be greater than 25% of the sum of all BUDGET-AMOUNTs where OBJECT-CODE is "6100"-"6400".

The budget data reported for the "special education" program (PIC 23) should not be more that 25 percent of the total expenditures for the "payroll costs" (6100), "professional and contracted services" (6200), "supplies and materials" (6300), and "other operating costs" (6400) object codes.
S 1 Y Y
Business Context 20030-0073
The sum of BUDGET-AMOUNTs where FUND-CODE is not "599" and OBJECT-CODE is "6500" should not be greater than 20% of the sum of all BUDGET-AMOUNTs where FUND-CODE is not "599" and OBJECT-CODE is "6100"-"6600".

For all fund codes except for "debt service funds" (599), the total budget amounts for the "debt service" object code (6500) should not be greater than 20% of the total budget amounts for all expenditure object codes (6100-6600).
S 1 Y Y Y
Business Context 20030-0074
The sum of BUDGET-AMOUNTs where FUNCTION-CODE is "11", OBJECT-CODE is "6100", and ORGANIZATION-CODE is "999" should not be greater than 10% of the sum of all BUDGET-AMOUNTs where FUNCTION-CODE is "11", OBJECT-CODE is "6100", and DISTRICT-ID combined with ORGANIZATION-CODE or "999" is a CAMPUS-ID registered with TEA as an active or under construction campus for this LEA.

The total budget amounts for TX-FunctionCode "instruction" (11), TX-ObjectCode "payroll costs" (6100), and TX-OrganizationCode "undistributed" (999) should not be greater than 10% of the total budget amounts for TX-FunctionCode "instruction" (11), TX-ObjectCode "payroll costs" (6100), and TX-OrganizationCode "undistributed" (999) as well as organizations registered with the TEA as a campus in the reporting LEA.
S 1 Y Y
Business Context 20030-0075
The sum of all BUDGET-AMOUNTs where OBJECT-CODE is "5929" should not exceed 5% of the sum of all BUDGET-AMOUNTs where OBJECT-CODE is "5XXX".

For an open enrollment charter school, the total budget amounts for TX-ObjectCode "federal revenues distributed by TEA" (5929) should not be greater than 5% of the total budgeted revenues reported.
S 1 Y
Business Context 20030-0076
Total revenues (OBJECT-CODE "5XXX") for the current year budget for FUND-CODE "199" should not increase by more than 25% over the prior year budget for FUND-CODE "199".

The total revenues for the current year budget for the "General Fund" should not increase by more than 25% over the prior year budget for the "General Fund".
S 1 Y Y
Business Context 20030-0077
Total expenditures (OBJECT-CODE "6XXX") for the current year budget for FUND-CODE "199" should not increase by more than 25% over the prior year budget for FUND-CODE "199".

The total expenditures for the current year budget for the "General Fund" should not increase by more than 25% over the prior year budget for the "General Fund".
S 1 Y Y
Business Context 20030-0078
Total revenues (OBJECT-CODE "5XXX") for the current year budget for FUND-CODE "420" should not increase by more than 25% over the prior year budget for FUND-CODE "420".

For an open enrollment charter school, the total revenues for the current year budget for the "foundation school program and other state aid" TX-FundCode should not increase by more than 25% over the prior year budget for that fund code.
S 1 Y
Business Context 20030-0079
Total expenses (OBJECT-CODE "6XXX") for the current year budget for FUND-CODE "420" should not increase by more than 25% over the prior year budget for FUND-CODE "420".

For an open enrollment charter school, the total expenses for the current year budget for the "foundation school program and other state aid" TX-FundCode should not increase by more than 25% over the prior year budget for that fund code.
S 1 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 30050-0001
PERCENT-DAY-EMPLOYED should be greater than 19.

For a staff person, the TX-PercentDayEmployed should be greater than 19%.
S 1 Y Y Y
Business Context 30055-0001
If the Local Education Agency's data submission has Staff with STAFF-TYPE-CODE of "3", then the submission should also contain data for Contracted Instructional Staff.

If staff are reported with staff type code "contracted professional staff" (3), then contracted instructional staff data should also be reported.
S 1 Y Y
Business Context 30055-0007
TOTAL-CONTRACTED-INSTR-STAFF-FTES should not be greater than 30.00.

The total number of contracted instructional staff FTEs reported for a particular district, campus, and program intent code should not be greater than 30 FTEs.
S 1 Y Y
Business Context 30060-0004
Except for Texas School for the Deaf (227906), Texas School for the Blind and Visually Impaired (227905), and Texas Juvenile Justice Department (227622), each district's data submission should contain at least one staff payroll where ORGANIZATION-CODE is not "701".

For each LEA's data submission (except for Texas School for the Deaf, Texas School for the Blind and Visually Impaired, and Texas Juvenile Justice Department), at least some staff payroll should be paid from a TX-OrganizationCode other than the Superintendent's Office.
S 1 Y Y
Business Context 30060-0019
For a particular TX-UNIQUE-STAFF-ID, if SERVICE-ID on a staff responsibility is "01010000", then at least one payroll with matching TX-UNIQUE-STAFF-ID should have a PROGRAM-INTENT-CODE of "32", "33", "34", or "35".

For a staff person, if a responsibility has a TX-ServiceId for pre-kindergarten, then at least one staff payroll for that staff person should have TX-ProgramIntentCode indicating pre-kindergarten.
S 1 Y Y Y
Business Context 30060-0021
If PAYROLL-ACTIVITY-CODE is "78", then there should not be staff payroll where PAYROLL-ACTIVITY-CODE is "80".

If a staff person has payroll with TX-PayrollActivityCode indicating "non-salary", they should not also have payroll with TX-PayrollActivityCode indicating "base salary".
S 1 Y Y Y
Business Context 30060-0022
If FUNCTION-CODE is "11", then there should be staff responsibility data with a matching TX-UNIQUE-STAFF-ID.

If a staff person has payroll with TX-FunctionCode indicating "instruction", then there should be staff responsibility data reported.
S 1 Y Y Y
Business Context 30060-0023
If ROLE-ID is always "033", then there should be staff payroll for that person where FUNCTION-CODE is "11", "12", or "31".

If a staff person is always and only an Educational Aide, then they should have staff payroll with TX-FunctionCode indicating "instruction", "instructional resources and media services", or "guidance, counseling, and evaluation services".
S 1 Y Y Y
Business Context 30060-0024
PAYROLL-ACTIVITY-CODE should be "79" or "80".

For staff payroll, the TX-PayrollActivityCode should be "base salary" or "other supplemental duties".
S 1 Y
Business Context 30060-0025
FUND-CODE should not be "400", "403", or "405"-"408".

For staff payroll, the TX-FundCode should not be "school health" (400), "certification" (403), "gifted and talented" (405), "teacher recruitment" (406), "bilingual education" (407), or "technology" (408), which are reserved for use by Education Service Centers.
S 1 Y Y
Business Context 30060-0026
FUNCTION-CODE should not be "9X".

For staff payroll, the TX-FunctionCode should not be "intergovernmental charges".
S 1 Y
Business Context 30060-0027
ORGANIZATION-CODE should not be "703" or "751".

For staff payroll, the TX-OrganizationCode should not be "tax costs" or "fiscal agent shared services arrangement".
S 1 Y
Business Context 30060-0028
If FUND-CODE is "101", "102", "199", "240", "266", "277", "420", or "701", then FISCAL-YEAR should be "1".

For staff payroll reporting, the fiscal year should indicate the current school year if the TX-FundCode is "Food Service" (101), "ESC State Support" (102), "General Fund" (199), "National School Breakfast And Lunch Program" (240), "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), "Foundation School Program And Other State Aid" (420), or "Enterprise Fund-National School Breakfast and Lunch Program" (701).
S 1 Y Y Y
Business Context 30060-0029
If FUND-CODE is "2XX"-"429", then FISCAL-YEAR should be "8", "9", "0", or "1".

For staff payroll reporting in selected special revenue fund codes (2XX-429) the TX-FiscalYear should indicate the current or the three prior school years.
S 1 Y Y Y
Business Context 30060-0030
If ORGANIZATION-CODE is less than "699", then DISTRICT-ID combined with ORGANIZATION-CODE should be a Campus ID registered with TEA as an active instructional or under construction campus.

For staff payroll, if the TX-OrganizationCode is an instructional campus organization type, then the StateOrganizationId combined with the TX-OrganizationCode should be a campus registered with TEA as an active instructional or under construction campus.
S 1 Y Y Y
Business Context 30060-0031
If PROGRAM-INTENT-CODE is "11", then FUND-CODE should be "102", "199", "212", "236", "238", "239", "255", "258", "259", "266", "270", "271", "272", "273", "277", "289", "300", "301", "347", "357", "379", "383", "384", "388", "391", "393", "399", "402", "404", "406", "408", "410", "414", "415", "420", "422", "429", "433", "439", "440", "459", "461", "479", or "499".

If the staff payroll data reported includes amounts for the TX-ProgramIntentCode "basic educational services" (11), then the TX-FundCode should be "ESC state support" (102), "general fund" (199), selected "special revenue (federal programs)" funds, selected "special revenue (federally funded SSAs)" funds, selected "special revenue (state funded)" funds, selected "special revenue (state/locally funded SSAs)" funds, or selected "special revenue (local programs)" funds.
S 1 Y Y Y
Business Context 30060-0032
If PROGRAM-INTENT-CODE is "21", then FUND-CODE should be "102", "199", "212", "218", "255", "258", "259", "266", "270", "271", "272", "273", "277", "289", "301", "307", "347", "357", "379", "383", "384", "388", "391", "393", "397", "402", "405", "410", "414", "420", "422", "429", "433", "439", "440", "459", "461", "479", or "499".

If the staff payroll data reported includes amounts for the TX-ProgramIntentCode "gifted and talented" (21), then the TX-FundCode should be "ESC state support" (102), "general fund" (199), selected "special revenue (federal programs)" funds, selected "special revenue (federally funded SSAs)" funds, selected "special revenue (state funded)" funds, selected "special revenue (state/locally funded SSAs)" funds, or selected "special revenue (local programs)" funds.
S 1 Y Y Y
Business Context 30060-0033
If PROGRAM-INTENT-CODE is "22", then FUND-CODE should be "102", "199", "212", "244", "245", "246", "247", "248", "250", "251", "255", "258", "259", "266", "270", "271", "272", "273", "277", "289", "301", "331", "332", "333", "334", "335", "337", "338", "347", "357", "379", "383", "384", "387", "388", "391", "393", "396", "410", "414", "420", "422", "429", "433", "439", "440", "459", "461", "479", or "499".

If the staff payroll data reported includes amounts for the TX-ProgramIntentCode "career and technical" (22), then the TX-FundCode should be "ESC state support" (102), "general fund" (199), selected "special revenue (federal programs)" funds, selected "special revenue (federally funded SSAs)" funds, selected "special revenue (state funded)" funds, selected "special revenue (state/locally funded SSAs)" funds, or selected "special revenue (local programs)" funds.
S 1 Y Y Y
Business Context 30060-0034
If PROGRAM-INTENT-CODE is "23", then FUND-CODE should be "102", "199", "205", "224"-"230", "236", "238", "239", "253", "255", "258", "259", "266", "270", "271", "272", "273", "277", "289", "313"-"317", "319", "325", "327", "328", "340", "347", "357", "364", "365", "379", "383"-"386", "392", "393", "399", "402", "410", "414", "415", "416", "419", "420", "422", "429", "434", "435", "437", "439"-"441", "459", "461", "479", or "499".

If the staff payroll data reported includes amounts for the TX-ProgramIntentCode "services to students with disabilities (special education)" (23), then the TX-FundCode should be "ESC state support" (102), "general fund" (199), selected "special revenue (federal programs)" funds, selected "special revenue (federally funded SSAs)" funds, selected "special revenue (state funded)" funds, selected "special revenue (state/locally funded SSAs)" funds, or selected "special revenue (local programs)" funds.
S 1 Y Y Y
Business Context 30060-0035
If PROGRAM-INTENT-CODE is "24", "26", "28", or "29", then FUND-CODE should be "102", "199", "205", "206", "211", "212", "220", "222", "223", "236", "238", "239", "255", "258", "259", "264", "265", "266", "267", "268", "270"-"276", "277", "286", "289", "292", "294", "300", "301", "309", "311", "312", "325", "327"-"329", "342", "347", "352", "354", "355", "357", "359", "360", "367", "379", "381"-"384", "388", "390"-"393", "395"-"399", "402", "404", "409", "410", "412", "414"-"416", "419", "420", "422", "429", "431"-"433", "439"-"441", "459", "461", "479", or "499".

If the staff payroll data reported includes amounts for the TX-ProgramIntentCodes "accelerated education" (24), "non-disciplinary alternative education programs - AEP services" (26), "disciplinary alternative education programs - DAEP basic services" (28), or "disciplinary alternative education programs - DAEP state compensatory education supplemental costs" (29), then the TX-FundCode should be "ESC state support" (102), "general fund" (199), selected "special revenue (federal programs)" funds, selected "special revenue (federally funded SSAs)" funds, selected "special revenue (state funded)" funds, selected "special revenue (state/locally funded SSAs)" funds, or selected "special revenue (local programs)" funds.
S 1 Y Y Y
Business Context 30060-0036
If PROGRAM-INTENT-CODE is "25", then FUND-CODE should be "102", "199", "212", "255", "258", "259", "263", "266", "270"-"273", "277", "289", "301", "347", "350", "357", "379", "383", "388", "390", "391", "393", "399", "402", "407", "410", "412", "414", "415", "420", "422", "429", "433", "439", "440", "442", "459", "461", "479", or "499".

If the staff payroll data reported includes amounts for the TX-ProgramIntentCode "bilingual education and special language programs" (25), then the TX-FundCode should be "ESC state support" (102), "general fund" (199), selected "special revenue (federal programs)" funds, selected "special revenue (federally funded SSAs)" funds, selected "special revenue (state funded)" funds, selected "special revenue (state/locally funded SSAs)" funds, or selected "special revenue (local programs)" funds.
S 1 Y Y Y
Business Context 30060-0037
If PROGRAM-INTENT-CODE is "30", then FUND-CODE should be "102", "199", "211", "266", "271", "272", "276", "277", "286", "289", "300", "359", "360", or "420".

If the staff payroll data reported includes amounts for the TX-ProgramIntentCode "Title I, Part A schoolwide activities related to state compensatory education costs on campuses with 40% or more educationally disadvantaged students" (30), then the TX-FundCode should be "ESC state support" (102), "general fund" (199), selected "special revenue (federal programs)" funds, selected "special revenue (federally funded SSAs)" funds, or selected "special revenue (state funded)" funds.
S 1 Y Y Y
Business Context 30060-0039
If PROGRAM-INTENT-CODE is "91", then FUND-CODE should be "199", "266", "272", "277", "420", "461", "479", "499", or "699".

If the staff payroll data reported includes amounts for the TX-ProgramIntentCode "athletics and related activities" (91), then the TX-FundCode should be "general fund" (199), selected "special revenue (federal programs)" funds, selected "special revenue (state funded)" funds, selected "special revenue (local programs)" funds, or "capital projects funds" (699).
S 1 Y Y Y
Business Context 30060-0040
If PROGRAM-INTENT-CODE is "91", then FUNCTION-CODE should be "36", "51", or "52".

For staff payroll, if TX-ProgramIntentCode is "athletics and related activities", then the TX-FunctionCode should be "extracurricular activities" (36), "facilities maintenance and operations" (51), or "security and monitoring services" (52).
S 1 Y Y Y
Business Context 30060-0041
If PROGRAM-INTENT-CODE is "99", then FUND-CODE should be "101", "102", "199", "203", "205", "206", "209", "211", "212", "218", "220", "222", "223", "236", "238"-"242", "253", "255", "258", "259", "263"-"265", "266", "267", "268", "270"-"274", "277", "289", "292", "294", "298", "300", "301", "307", "309", "311", "312", "325", "327"-"329", "340", "342", "347", "357", "359", "367", "379", "381"-"384", "387", "388", "390"-"393", "395"-"400", "402"-"404", "406", "408"-"410", "412", "414"-"416", "419", "420", "422", "429", "431"-"433", "436", "438"-"441", "459", "461", "479", "499", "599", "699", "701", "749", "751"-"755", or "799".

If the staff payroll data reported includes amounts for the TX-ProgramIntentCode "undistributed" (99), then the TX-FundCode should be "food service" (101), "ESC state support" (102), "general fund" (199), selected "special revenue (federal programs)" funds, selected "special revenue (federally funded SSAs)" funds, selected "special revenue (state funded)" funds, selected "special revenue (state/locally funded SSAs)" funds, selected "special revenue (local programs)" funds, "debt service funds" (599), "capital projects funds" (699), "enterprise fund-National School Breakfast and Lunch Program" (701), "enterprise funds" (749), "transportation" (751), "print shop" (752), "insurance" (753), "computer operations" (754), "public entity risk pool" (755), or "internal service funds" (799).
S 1 Y Y Y
Business Context 30060-0043
If there is at least one payroll where the FUND-CODE is a Shared Services Arrangement fund in code table C145, then ESC-SSA-STAFF-INDICATOR-CODE should be "2" for this staff person.

If a staff person has payroll where the TX-FundCode is a shared services arrangement fund in code table C145, then this person's TX-SharedServiceArrangementStaffIndicator should indicate they are part of the ESC Shared Services Arrangement, for which the ESC is the fiscal agent.
S 1 Y
Business Context 30060-0045
For a particular TX-UNIQUE-STAFF-ID, the sum of all PAYROLL-AMOUNTs where PAYROLL-ACTIVITY-CODE is not "80" should not be greater than 25,000.

For staff payroll, total non-base salary for a staff person should not be greater than $25,000.
S 1 Y Y Y
Business Context 30060-0046
For a particular TX-UNIQUE-STAFF-ID, the sum of all PAYROLL-AMOUNTs where PAYROLL-ACTIVITY-CODE is "80" should be greater than the sum of all PAYROLL-AMOUNTs where PAYROLL-ACTIVITY-CODE is not "80".

For staff payroll, total base salary for a staff person should be greater than their total non-base salary.
S 1 Y Y Y
Business Context 30060-0047
For a particular TX-UNIQUE-STAFF-ID, for each unique PAYROLL-ACTIVITY-CODE except "02", "05", or "80", the sum of all PAYROLL-AMOUNTs should not be greater than 10,000.

For staff payroll for each TX-PayrollActivityCode (except UIL Athletics, Band or Orchestra, and Base Salary), the total of all TX-Amounts should not be greater than $10,000.
S 1 Y Y Y
Business Context 30060-0048
For a particular TX-UNIQUE-STAFF-ID, if ROLE-ID is always "033", then the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" should not be greater than 30,000.

If a staff person is always an educational aide, then their total base salary should not be greater than $30,000.
S 1 Y Y Y
Business Context 30060-0049
For a particular TX-UNIQUE-STAFF-ID, if ROLE-ID is always "033" or "036", 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 be between 10,000 and 29,000.

If a full-time staff person is always an Educational Aide or Certified Interpreter, then their total base salary should be between $10,000 and $29,000.
S 1 Y Y Y
Business Context 30060-0051
For a particular TX-UNIQUE-STAFF-ID, if ROLE-ID is "002", "005", "006", "007", "008", "011", "013", "015", "016", "017", "018", "021", "022", "023", "026", "028", "032", "041", "042", "056", "106", or "114", then the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" should not be greater than 70,000.

If a staff person has a TX-StaffRole of "002", "005", "006", "007", "008", "011", "013", "015", "016", "017", "018", "021", "022", "023", "026", "028", "032", "041", "042", "056", "106", or "114", then their total base salary should not be greater than $70,000.
S 1 Y Y Y
Business Context 30060-0052
For a particular TX-UNIQUE-STAFF-ID, if ROLE-ID is "003", "004", "012", "020", "040", "043"-"045", "061"-"065", or "079", then the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" should not be greater than 87,000.

If a staff person has a TX-StaffRole of "003", "004", "012", "020", "040", "043"-"045", "061"-"065", or "079", then their total base salary should not be greater than $87,000.
S 1 Y Y Y
Business Context 30060-0053
For a particular TX-UNIQUE-STAFF-ID, if ROLE-ID is "003", "004", "012", "020", "027", "043"-"045", or "060"-"063", then the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" should not be greater than 120,000.

If a staff person has a TX-StaffRole of "003", "004", "012", "020", "027", "043"-"045", or "060"-"063", then their total base salary should not be greater than $120,000.
S 1 Y Y Y
Business Context 30060-0057
For a particular TX-UNIQUE-STAFF-ID, if ROLE-ID is "003", "004", "012", "020", "027", "040", or "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 35,000.

If a full-time staff person has a TX-StaffRole of "003", "004", "012", "020", "027", "040", or "043"-"045", then their total base salary should not be less than $35,000.
S 1 Y Y Y
Business Context 30060-0058
For a particular TX-UNIQUE-STAFF-ID, if ROLE-ID is only "002", "005", "006", "007", "008", "011", "013", "015", "016", "017", "018", "021", "022", "023", "024", "026", "028", "030", "032", "040", "041", "042", "054", "064", "065", "079", "106", and/or "114", and PERCENT-DAY-EMPLOYED is 100, and NUMBER-DAYS-EMPLOYED is greater than or equal to 187, then for that staff member the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" should not be less than 32,000.

If a full-time staff person is only the following TX-StaffRoles "002", "005", "006", "007", "008", "011", "013", "015", "016", "017", "018", "021", "022", "023", "024", "026", "028", "030", "032", "040", "041", "042", "054", "064", "065", "079", "106", and/or "114", then their total base salary should not be less than $32,000.
S 1 Y Y Y
Business Context 30060-0059
For a particular TX-UNIQUE-STAFF-ID, if ROLE-ID is always "013" or "087", then the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" should not be greater than 65,000.

If a staff person is always a Librarian or Teacher, then their total base salary should not be greater than $65,000.
S 1 Y Y Y
Business Context 30060-0060
If no staff responsibility data exists for a staff person, then the sum of all PAYROLL-AMOUNTs should not be greater than 100,000.

If a staff person does not have any responsibility data, then the sum of their payroll amounts should not be greater than $100,000.
S 1 Y Y Y
Business Context 30060-0061
FTE Salary should not be greater than 350,000.

For staff payroll, the FTE Salary should not be greater than $350,000.
S 1 Y Y Y
Business Context 30060-0062
If staff responsibility data exists for a staff person, then FTE Salary should be between 5,000 and 90,000.

For staff payroll for a staff person having responsibility data, the FTE Salary should be between $5,000 and $90,000.
S 1 Y Y Y
Business Context 30060-0063
The average salary (PAYROLL-ACTIVITY-CODE "80" PAYROLL-AMOUNTs only) for all staff where ROLE-ID is "013" or "087", TOTAL-YEARS-PROF-EXPERIENCE is 0-5, PERCENT-DAY-EMPLOYED is 100, and NUMBER-DAYS-EMPLOYED is greater than or equal to 187 should be between 27,320 and 50,000.

The average base salary for all full-time Librarians and Teachers with TX-TotalYearsProfessionalExperience of 0-5 should be between $27,320 and $50,000.
S 1 Y Y Y
Business Context 30060-0064
The average salary (PAYROLL-ACTIVITY-CODE "80" PAYROLL-AMOUNTs only) for all staff where ROLE-ID is "013" or "087", TOTAL-YEARS-PROF-EXPERIENCE is 6-10, PERCENT-DAY-EMPLOYED is 100, and NUMBER-DAYS-EMPLOYED is greater than or equal to 187 should be between 32,800 and 56,000.

The average base salary for all full-time Librarians and Teachers with TX-TotalYearsProfessionalExperience of 6-10 should be between $32,800 and $56,000.
S 1 Y Y Y
Business Context 30060-0065
The average salary (PAYROLL-ACTIVITY-CODE "80" PAYROLL-AMOUNTs only) for all staff where ROLE-ID is "013" or "087", TOTAL-YEARS-PROF-EXPERIENCE is 11-20, PERCENT-DAY-EMPLOYED is 100, and NUMBER-DAYS-EMPLOYED is greater than or equal to 187 should be between 37,960 and 59,000.

The average base salary for all full-time Librarians and Teachers with TX-TotalYearsProfessionalExperience of 11-20 should be between $37,960 and $59,000.
S 1 Y Y Y
Business Context 30060-0066
The average salary (PAYROLL-ACTIVITY-CODE "80" PAYROLL-AMOUNTs only) for all staff where ROLE-ID is "013" or "087", TOTAL-YEARS-PROF-EXPERIENCE is greater than 20, PERCENT-DAY-EMPLOYED is 100, and NUMBER-DAYS-EMPLOYED is greater than or equal to 187 should be between 44,270 and 68,000.

The average base salary for all full-time Librarians and Teachers with TX-TotalYearsProfessionalExperience greater than 20 should be between $44,270 and $68,000.
S 1 Y Y Y
Business Context 30060-0067
If PROGRAM-INTENT-CODE is "32", "33", "34", or "35", then FUND-CODE should be "199", "205", "206", "211", "212", "263", "266", "270", "272", "274"-"276", "277", "286", "289", "294", "300", "301", "347", "350", "360", "367", "379", "388", "390", "391", "393", "395", "396", "402", "404", "410", "414"-"416", "419", "420", "422", "429", "439"-"442", "459", "461", "479", or "499".

If the staff payroll data reported includes amounts for the TX-ProgramIntentCode "pre-kindergarten-regular education" (32), "pre-kindergarten-special education" (33), "pre-kindergarten-compensatory education" (34), or "pre-kindergarten-bilingual education" (35), then the TX-FundCode should be "general fund" (199), selected "special revenue (federal programs)" funds, selected "special revenue (federally funded SSAs)" funds, selected "special revenue (state funded)" funds, selected "special revenue (state/locally funded SSAs)" funds, or selected "special revenue (local programs)" funds.
S 1 Y Y Y
Business Context 30090-0054
There should be one and only one staff person with ROLE-ID "027".

A school district or open enrollment charter school should have one and only one Superintendent/Chief Admin Officer/CEO/President.
S 1 Y Y
Business Context 30090-0055
If the first six characters of CAMPUS-ID do not match DISTRICT-ID, then a Shared Services Arrangement should be reported.

For a staff responsibility, if the StateOrganizationId is not in this district, then a shared services arrangement should be reported.
S 1 Y Y Y Y
Business Context 30090-0056
If SERVICE-ID is "01010000", then there should be staff payroll with a matching TX-UNIQUE-STAFF-ID where PROGRAM-INTENT-CODE is "32", "33", "34", or "35".

For a staff responsibility, if the TX-ServiceId is "pre-kindergarten", then this staff person should be reported with payroll with a pre-kindergarten TX-ProgramIntentCode.
S 1 Y Y Y
Business Context 30090-0057
If the first six characters of CAMPUS-ID match DISTRICT-ID and the last three characters of CAMPUS-ID are less than "699", then for each campus that has a staff person with ROLE-ID "087", there should be at least one student enrollment with a matching CAMPUS-ID-OF-ENROLLMENT.

For each campus in the district that is a high school, junior high/middle school, or elementary school, if there are staff with TX-StaffRole of "teacher", there should be enrolled students at the same campus.
S 1 Y Y Y
Business Context 30090-0058
There should not be 100-199 staff responsibilities for a particular TX-UNIQUE-STAFF-ID.

A staff person should not have 100-199 responsibilities.
S 1 Y Y Y Y
Business Context 30090-0059
If MONTHLY-MINUTES is not blank, then MONTHLY-MINUTES should not be less than 60 or greater than 9600.

For an instructional staff responsibility, the TX-MonthlyMintues should not be less than 60 or greater than 9600.
S 1 Y Y Y Y
Business Context 30090-0060
If SERVICE-ID is "127XXXXX", "130XXXXX", "N127XXXX", or "N130XXXX", then POPULATION-SERVED-CODE should be "05" or "06".

If a staff responsibility is reported with a TX-ServiceId beginning with "127", "130", "N127", or "N130" , then the TX-PopulationServed should be "career and technical students" (05) or "special education students" (06).
S 1 Y Y Y Y
Business Context 30090-0063
For a staff responsibility where ROLE-ID is NOT: 002 Art Therapist 007 Corrective Therapist 015 Music Therapist 016 Occupational Therapist 017 Certified Orientation and /Mobility Specialist (COMS) 018 Physical Therapist 021 Recreational Therapist 026 Speech Therapist/Speech /Language Pathologist 032 Work-Based Learning Site /Coordinator 033 Educational Aide 036 Certified Interpreter 047 Substitute Teacher, or 087 Teacher, then the first character of SERVICE-ID should not be "0"-"8", "A", "C", "F", "I", "L", "M", "N", or "P".

For a staff responsibility, if the TX-StaffRole is NOT instructional, then the TX-ServiceId should not be an instructional Service ID.
S 1 Y Y Y Y
Business Context 30090-0065
If ROLE-ID is "004" or "043"-"045", then the last three characters of CAMPUS-ID should be "701"-"703", "720", "750", "751", "998", or "999".

For a staff responsibility, if the TX-StaffRole is "superintendent/chief admin officer/CEO/president", "business manager", "tax assessor/collector", "director of personnel/human resources", 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, fiscal agent shared services arrangement, unallocated, or undistributed.
S 1 Y Y Y Y
Business Context 30090-0076
If ROLE-ID is "065", then SERVICE-ID should be "SS022000".

For ESC staff responsibility reporting, if the TX-StaffRole is "field service agent", then the TX-ServiceId should be "liaison services".
S 1 Y
Business Context 30090-0078
If ROLE-ID is "087" or "047", then CAMPUS-ID should not end with "998" or "999".

For a staff responsibility, if the TX-StaffRole is "teacher" or "substitute teacher", then the StateOrganizationId should not be "unallocated" or "undistributed".
S 1 Y Y Y
Business Context 30090-0079
For a particular TX-UNIQUE-STAFF-ID, if any MONTHLY-MINUTES are not blank, then the sum of the MONTHLY-MINUTES on all responsibilities should be at least 60.

All of the responsibilities for a staff person should have total TX-MonthlyMinutes of at least 60 minutes.
S 1 Y Y Y
Business Context 30090-0115
If NUMBER-DAYS-TAUGHT-WEEK-1, NUMBER-DAYS-TAUGHT-WEEK-2, NUMBER-DAYS-TAUGHT-WEEK-3, or NUMBER-DAYS-TAUGHT-WEEK-4 is not blank, then NUMBER-DAYS-TAUGHT-WEEK-1, NUMBER-DAYS-TAUGHT-WEEK-2, NUMBER-DAYS-TAUGHT-WEEK-3, and NUMBER-DAYS-TAUGHT-WEEK-4 should be 1-5.

When required to be reported, TX-NumberDaysTaughtWeek1, TX-NumberDaysTaughtWeek2, TX-NumberDaysTaughtWeek3, and TX-NumberDaysTaughtWeek4 should be at least 1 and not more than 5.
S 1 Y Y Y
Business Context 30090-0116
If NUMBER-MINUTES-TAUGHT-WEEK-1, NUMBER-MINUTES-TAUGHT-WEEK-2, NUMBER-MINUTES-TAUGHT-WEEK-3, or NUMBER-MINUTES-TAUGHT-WEEK-4 is not blank, then NUMBER-MINUTES-TAUGHT-WEEK-1 plus NUMBER-MINUTES-TAUGHT-WEEK-2 plus NUMBER-MINUTES-TAUGHT-WEEK-3 plus and NUMBER-MINUTES-TAUGHT-WEEK-4 should be less than or equal to 1800.

When required to be reported, the total minutes for a Physical Education class should be less than or equal to 1800 minutes for the 4 weeks of October.
S 1 Y Y Y
Business Context 30090-0118
If ROLE-ID is "033" or "036", then there should be at least one staff payroll with a matching TX-UNIQUE-STAFF-ID where OBJECT-CODE is "6129" or "6122".

For a staff person reported with a para-professional TX-StaffRole (Educational Aide (033) or Certified Interpreter (036)), there should be payroll data reported with a TX-ObjectCode indicating "Salaries or Wages for Support Personnel" (6129) or "Salaries or Wages for Substitute Support Personnel" (6122).
S 1 Y Y
Business Context 40100-0058
If age is less than 3 on September 1, then GRADE-LEVEL-CODE should be "EE".

A student that is less than 3 years old on September 1 should be reported with TX-GradeLevel "EE".
S 1, 3, 4 Y Y Y
Business Context 40100-0070
There should be student data where ECONOMIC-DISADVANTAGE-CODE of "01", "02", or "99".

There should be at least one student with one of the following economic disadvantage: Eligible For Free Meals Under The National School Lunch And Child Nutrition Program, Eligible For Reduced-price Meals Under The National School Lunch And Child Nutrition Program, or Other Economic Disadvantage.
S 1, 3 Y Y Y
Business Context 40100-0078
A student’s September 1 age should not be greater than 25.

A student should not be older than 25 years old on September 1 of the current year.
S 1, 3, 4 Y Y Y
Business Context 40100-0080
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).

The FirstName, MiddleName and/or LastSurname of a student 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, 3, 4 Y Y Y
Business Context 40100-0085
If GRADE-LEVEL-CODE is "EE", then September 1 age should be less than 6.

A student in grade EE should be less than 6 years old on September 1.
S 1, 3, 4 Y Y Y
Business Context 40100-0086
If GRADE-LEVEL-CODE is "PK", then September 1 age should be 3 or 4.

A student in grade "PK" should be 3 or 4 years old on September 1.
S 1, 3, 4 Y Y Y
Business Context 40100-0087
If GRADE-LEVEL-CODE is "KG", then September 1 age should be 5 or 6.

A student in grade KG should be 5 or 6 years old on September 1.
S 1, 3, 4 Y Y Y
Business Context 40100-0088
If GRADE-LEVEL-CODE is "12", then September 1 age should be 16-25.

A 12th grade student should be in the age range of 16-25 years old on September 1.
S 1, 3, 4 Y Y Y
Business Context 40100-0089
FIRST-NAME, MIDDLE-NAME, LAST-NAME, SEX-CODE, AMERICAN-INDIAN-ALASKA-NATIVE-CODE, ASIAN-CODE, BLACK-AFRICAN-AMERICAN-CODE, NATIVE-HAWAIIAN-PACIFIC-ISLANDER-CODE, WHITE-CODE, HISPANIC-LATINO-CODE, and DATE-OF-BIRTH should not be identical on students reported with two or more different STUDENT-IDs.

Students with different IdentificationCode values should not have identical demographic information.
S 1, 3, 4 Y Y Y
Business Context 40100-0115
At least one student enrollment should have an AT-RISK-INDICATOR-CODE of "1".

There should be at least one student identified as At-Risk.
S 1 Y Y Y
Business Context 40100-0116
At least one student should have a LEP-INDICATOR-CODE of "1".

There should be at least one student identified as limited English proficient (LEP)/English learner (EL).
S 1, 3 Y Y Y
Business Context 40100-0117
At least one student enrollment should have an ADA-ELIGIBILITY-CODE of "1".

There should be at least one student identified as eligible for full day attendance.
S 1 Y Y Y
Business Context 40100-0208
If POST-SECONDARY-CERTIFICATION-LICENSURE-CODE is not blank, then EFFECTIVE-DATE must be between June 1, 2020 and August 31, 2020.

A TX-PostSecondaryCertificationLicensure reported in the PEIMS Fall Submission (1) must have been earned between June 1, 2020 and August 31, 2020.
S 1 Y Y Y
Business Context 40110-0041
At least one student program should have a SPECIAL-ED-INDICATOR-CODE of "1".

There should be at least one student identified as Special Education.
S 1 Y Y Y
Business Context 40110-0042
At least one student program should have a GIFTED-TALENTED-INDICATOR-CODE of "1".

There should be at least one student identified as Gifted & Talented.
S 1, 3, 4 Y Y Y
Business Context 40110-0046
At least one student program should have a BILINGUAL-PROGRAM-TYPE-CODE that is not "0".

There should be at least one student identified as participating in a Bilingual program.
S 1 Y Y Y
Business Context 40110-0047
At least one student program should have an ESL-PROGRAM-TYPE-CODE of "2" or "3".

There should be at least one student identified as participating in an English as a Second Language (ESL) program.
S 1 Y Y Y
Business Context 40110-0049
If a campus is registered with TEA as an active instructional campus, excluding DAEPs, then there should be at least one student enrollment with a matching CAMPUS-ID-OF-ENROLLMENT and GRADE-LEVEL-CODE for each grade registered as a grade of instruction for the campus.

Each grade level for each active instructional campus in a district should have student enrollment reported.
S 1 Y Y
Business Context 40110-0050
If there is at least one student enrollment where GRADE-LEVEL-CODE is "12" on a campus, then there should be at least one leaver with a matching CAMPUS-ID where LEAVER-REASON-CODE is "01".

If student enrollment is reported for grade "12" on a campus, then at least one student leaver generally should be reported as a graduated from that campus.
S 1 Y Y Y
Business Context 40110-0051
If there is at least one student enrollment where GRADE-LEVEL-CODE is "07"-"12" on a campus, then there should be at least one leaver with a matching CAMPUS-ID where LEAVER-REASON-CODE is not "01".

If student enrollment is reported for grades "07"-"12" on a campus, then at least one student leaver should be reported with a TX-LeaverReasonCode other than graduated.
S 1 Y Y Y
Business Context 40110-0052
If there is at least one student enrollment on a particular CAMPUS-ID-OF-ENROLLMENT, then there should be at least one staff responsibility with a matching CAMPUS-ID and a ROLE-ID of "047" or "087", unless the campus is registered with TEA as a JJAEP.

Unless the campus is a JJAEP, if student enrollment is reported on a campus, then a teacher or substitute teacher should be reported for that campus.
S 1 Y Y Y
Business Context 40110-0053
If a student's age on September 1 of the current school year is less than 5, then GRADE-LEVEL-CODE should be "EE" or "PK".

A student that is age 4 or less on September 1 should be in TX-GradeLevel "EE" or "PK".
S 1 Y Y Y
Business Context 40110-0054
If ADA-ELIGIBILITY-CODE is "0" and September 1 age is less than 3, then GRADE-LEVEL-CODE should be "EE".

A student that is reported as "not in membership" and is less than 3 years old on September 1 should be reported in TX-GradeLevel "EE".
S 1 Y Y Y
Business Context 40110-0055
If GRADE-LEVEL-CODE is "EE" and September 1 age is less than 3, then the EARLY-CHILDHOOD-INTERV-IND-CODE should be "1", or the PRIMARY-DISABILITY-CODE or SECONDARY-DISABILITY-CODE or TERTIARY-DISABILITY-CODE should be "03", "04" or "05".

If a student is less than 3 years of age on September 1 and TX-GradeLevel is "EE", then the student generally should be participating in the Early Childhood Intervention program, or have one of the following disabilities: auditory impairment, visual impairment, or deaf-blind.
S 1 Y Y Y
Business Context 40110-0056
If GRADE-LEVEL-CODE is "EE" and age is 3 - 5 on the PEIMS Fall snapshot date, then PRESCHL-PROG-CHLDRN-WITH-DISAB-IND-CD should be "1".

A student that is 3 - 5 years old on the PEIMS Fall snapshot date and enrolled in "EE" generally should be a special education participant in the Preschool Program for Children with Disabilities.
S 1 Y Y Y
Business Context 40110-0058
If a student's September 1 age is less than 5, and GRADE-LEVEL-CODE is "KG"-"06", then ADA-ELIGIBILITY-CODE should be "0", "4", or "5".

If a student is less than 5 years old on September 1, and is reported in grades "KG"-"06", then TX-ADAEligibility should indicate the student is "not in membership", ineligible-full day, or ineligible-half day.
S 1 Y Y Y
Business Context 40110-0059
GRADE-LEVEL-CODE should be in the grade range of the CAMPUS-ID-OF-ENROLLMENT from the student school association, unless CAMPUS-ID-OF-ENROLLMENT is blank or SPECIAL-ED-INDICATOR-CODE is "1".

A student should generally be enrolled in a grade applicable to their TX-CampusIdOfEnrollment, unless they are in special education or their TX-CampusIdOfEnrollment is blank.
S 1 Y Y Y
Business Context 40110-0060
If AS-OF-STATUS-CODE is not "A", and STUDENT-ATTRIBUTION-CODE is "06", "30", or "31", then ADA-ELIGIBILITY-CODE should be "3" or "6".

If an enrolled student's TX-Attribution indicates a Transfer Between Public School Districts (06), Child of Charter School Employee (30), or Open Enrollment Charter School: Outside Attendance/Geographic Boundaries (31), then their TX-ADAEligibility should indicate eligible transfer student-full day or eligible transfer student-half day.
S 1 Y Y Y
Business Context 40110-0061
If GRADE-LEVEL-CODE is "05" and SSI-PROMOTION-RETENTION-CODE is not blank, then SSI-PROMOTION-RETENTION-CODE should be "04", "06", or "08".

A student in TX-GradeLevel "05" generally should have an TX-SSIPromotionRetention of blank, "04", "06", or "08".
S 1 Y Y Y
Business Context 40110-0062
If GRADE-LEVEL-CODE is "06" and SSI-PROMOTION-RETENTION-CODE is not blank, then SSI-PROMOTION-RETENTION-CODE should be "03", "05", or "07".

A student in TX-GradeLevel "06" generally should have an TX-SSIPromotionRetention of blank, "03", "05", or "07".
S 1 Y Y Y
Business Context 40110-0063
If SSI-PROMOTION-RETENTION-CODE is "03", "05", or "07", then GRADE-LEVEL-CODE should be "06".

TX-SSIPromotionRetention codes "03", "05", and "07" only apply to students in grade "06".
S 1 Y Y Y
Business Context 40110-0064
If GRADE-LEVEL-CODE is not "05"-"09", then SSI-PROMOTION-RETENTION-CODE should be blank.

The TX-SSIPromotionRetention only applies to student in TX-GradeLevel "05"-"09".
S 1 Y Y Y
Business Context 40110-0073
If SSI-PROMOTION-RETENTION-CODE is "09", "11", or "13", then GRADE-LEVEL-CODE should be "09".

TX-SSIPromotionRetention codes "09", "11", and "13" only apply to students grade "09".
S 1 Y Y Y
Business Context 40110-0074
If GRADE-LEVEL-CODE is "08" and SSI-PROMOTION-RETENTION-CODE is not blank, then SSI-PROMOTION-RETENTION-CODE should be "10", "12", or "14".

A student in grade "08" generally should have an TX-SSIPromotionRetention of blank, "10", "12", or "14".
S 1 Y Y Y
Business Context 40110-0075
If GRADE-LEVEL-CODE is "09" and SSI-PROMOTION-RETENTION-CODE is not blank, then SSI-PROMOTION-RETENTION-CODE should be "09", "11", or "13".

A student in grade "09" generally should have an TX-SSIPromotionRetention of blank, "09", "11", or "13".
S 1 Y Y Y
Business Context 40110-0100
CAMPUS-ID-OF-RESIDENCE should not be a campus registered with TEA as an alternative education program (AEP) campus or a disciplinary alternative education program (DAEP) campus.

A student's TX-CampusIdOfResidence should not be a campus registered with the TEA as an alternative education program (AEP) campus or a disciplinary alternative education program (DAEP) campus.
S 1, 3, 4 Y Y Y
Business Context 40110-0108
STUDENT-ATTRIBUTION-CODE should be "01", "30", or "31".

An open enrollment charter school student should be reported with TX-Attribution indicating Open Enrollment Charter School: Within Attendance/Geographic Boundaries (01), Child of Charter School Employee (30), or Open Enrollment Charter School: Outside Attendance/Geographic Boundaries (31).
S 1, 3, 4 Y
Business Context 40110-0114
If STUDENT-ATTRIBUTION-CODE is "21", "23", "25", or "27", then CAMPUS-ID-OF-RESIDENCE should not be blank and the first six characters should not match DISTRICT-ID.

If a student does not normally reside in the regular boundaries of the district, then TX-CampusIdOfResidence should be reported and it should not be in the reporting LEA.
S 1, 3, 4 Y Y
Business Context 40110-0185
At least one student program should have an INTERVENTION-STRATEGY-INDICATOR-CODE of "1".

There should be at least one student that has participated in an intervention strategy.
S 1, 3 Y Y Y
Business Context 40110-0186
At least one student program should have a SECTION-504-INDICATOR-CODE of "1".

There should be at least one student that has received assistance through either an aid, accommodation, or service under Section 504 Rehabilitation Act of 1973.
S 1, 3 Y Y Y
Business Context 40110-0188
INTERVENTION-STRATEGY-INDICATOR-CODE and SECTION-504-INDICATOR-CODE should not both be "1".

A student should not be identified as both having participated in an intervention strategy and having received assistance through either an aid, accommodation, or service under Section 504 Rehabilitation Act of 1973.
S 1, 3 Y Y Y
Business Context 40203-0006
If GRADUATION-TYPE-CODE is "07" or "57", then the student leaver should be at least 22 years of age as of September 1 of the current school year.

For a leaver, if the TX-GraduationTypeCode indicates the student has reached age 22, then the student's September 1 age should be at least 22.
S 1 Y Y Y
Business Context 40203-0007
If CAMPUS-ID is a campus registered with the TEA as a JJAEP in the prior school year, then STUDENT-ATTRIBUTION-CODE should be "02".

For a leaver, if the StateOrganizationId (TX-SchoolReference) reported was registered with the TEA as a JJAEP in the prior school year, then the TX-Attribution should indicate "JJAEP".
S 1 Y Y Y
Business Context 40203-0008
For a particular CAMPUS-ID, if the only LEAVER-REASON-CODEs used are "01" and "98", then identify this campus and its total number of leavers.

For a particular campus, if the only leavers reported are designated as "graduated" and "other", there may be miscoded leavers or missing leavers from the data reported.
S 1 Y Y Y
Business Context 40203-0009
A student leaver's prior year September 1 age should not be greater than 25 or less than 10.

A student leaver's prior year September 1 age should not be greater than 25 or less than 10.
S 1 Y Y Y
Business Context 40203-0016
If GRADE-LEVEL-CODE is "09" or "10", then LEAVER-REASON-CODE should not be "01" (graduated).

Students reported as graduates generally should not be in grade "09" or "10".
S 1 Y Y Y
Business Context 40203-0022
The number of school leavers with INDIVIDUAL-GRADUATION-COMMITTEE-GRADUATE-CODE of "02" should not be equal to the number of school leavers with GRADE-LEVEL-CODE "12".

An LEA or campus should not report all of their 12th grade graduates as having graduated based upon an IGC decision.
S 1 Y Y Y
Business Context 41163-0009
If PRIMARY-DISABILITY-CODE is "14", then age must be 3, 4 or 5 on the PEIMS Fall snapshot date.

For a special education student, if TX-PrimaryDisability is noncategorical early childhood, then the student must be 3, 4 or 5 years old on the PEIMS Fall snapshot date.
S 1 Y Y Y
Business Context 41163-0014
If PRESCHL-PROG-CHLDRN-WITH-DISAB-IND-CD is "1", then age on the PEIMS Fall snapshot date must be 3, 4 or 5, and EARLY-CHILDHOOD-INTERV-IND-CODE must be "0".

A special education student participating in the Preschool Program for Children with Disabilities must be 3 - 5 years old on the PEIMS Fall snapshot date, and is not eligible to participate in the Early Childhood Intervention program.
S 1 Y Y Y
Business Context 41163-0019
If INSTRUCTIONAL-SETTING-CODE is "45", "89", or "98", then age must be 3, 4 or 5 on the PEIMS Fall snapshot date.

If TX-InstructionalSetting indicates a full-time early childhood special education setting, then the special education student must be 3, 4 or 5 years old on the PEIMS Fall snapshot date.
S 1 Y Y Y
Business Context 41163-0025
Each Local Education Agency's data submission should report at least one student Special Education program association.

Student Special Education program association data should be reported for each Local Education Agency.
S 1 Y Y Y
Business Context 41163-0029
If GRADE-LEVEL-CODE is "PK" and SPECIAL-ED-INDICATOR-CODE is "1", then PRESCHL-PROG-CHLDRN-WITH-DISAB-IND-CD should be "1".

A special education student in TX-GradeLevel "PK" generally should participate in the Preschool Program for Children with Disabilities.
S 1 Y Y Y
Business Context 41163-0037
If PRESCHL-PROG-CHLDRN-WITH-DISAB-IND-CD is "1" and INSTRUCTIONAL-SETTING-CODE is "40", "81" or "91", then PPCD-SERVICE-LOCATION-CODE should be "1" or "4".

A PPCD student reported with a mainstream instructional setting generally should be reported with a TX-PPCDServiceLocationIndicator of "1" or "4".
S 1 Y Y Y
Business Context 41163-0038
If PRESCHL-PROG-CHLDRN-WITH-DISAB-IND-CD is "1" and INSTRUCTIONAL-SETTING-CODE is "41", "42", "82", "83", "92" or "93", then PPCD-SERVICE-LOCATION-CODE should be "1", "4", "5", or "6".

A PPCD student reported with a resource room instructional setting generally should be reported with a TX-PPCDServiceLocationIndicator of "1", "4", "5", or "6".
S 1 Y Y Y
Business Context 41163-0039
If PRESCHL-PROG-CHLDRN-WITH-DISAB-IND-CD is "1" and INSTRUCTIONAL-SETTING-CODE is "43", "44", "84", "85", "94" or "95", then PPCD-SERVICE-LOCATION-CODE should be "5" or "6".

A PPCD student reported with a self-contained mild/moderate/severe regular campus instructional setting generally should be reported with a TX-PPCDServiceLocationIndicator of "5" or "6".
S 1 Y Y Y
Business Context 41163-0040
If PRESCHL-PROG-CHLDRN-WITH-DISAB-IND-CD is "1" and INSTRUCTIONAL-SETTING-CODE is "02", "45", "86", "87", "89", "96", "97" or "98", then PPCD-SERVICE-LOCATION-CODE should be "3".

A PPCD student reported with a separate campus/class instructional setting should be reported with a TX-PPCDServiceLocationIndicator of "3".
S 1 Y Y Y
Business Context 41163-0046
If ADA-ELIGIBILITY-CODE is "0" and age is 3 - 5 on the PEIMS Fall snapshot date, then PRESCHL-PROG-CHLDRN-WITH-DISAB-IND-CD should be "1".

A student that is 3 - 5 years old on the PEIMS Fall snapshot date and "not in membership" generally should be a special education participant in the Preschool Program for Children with Disabilities.
S 1 Y Y Y
Business Context 41163-0068
If MULTIPLY-DISABLED-INDICATOR-CODE is "1", then please verify that the student has been designated as multiply disabled by the admission, review, and dismissal committee.

A student who is reported as multiply disabled has a combination of disabilities and meets all the conditions listed in 19 TAC §89.1040(c)(6). Not all students who have more than one disability are determined to be multiply disabled.
S 1, 3 Y Y Y
Business Context 41461-0012
For a particular CAMPUS-ID-OF-ENROLLMENT reporting Title I, Part A data, at least one student should have a TITLE-I-PART-A-INDICATOR-CODE of "6"-"9".

For each campus reporting Title I, Part A participation, at least one student should be identified as participating in the Title I program.
S 1, 3 Y Y Y
Business Context 48011-0009
If GRADE-LEVEL-CODE is "09"-"11", then FHSP-DISTING-LEVEL-ACHIEVE-INDICATOR-CODE should not be "2".

A student in grades "09"-"11" generally will not have completed the FHSP Distinguished Level of Achievement before their senior year of high school.
S 1, 3 Y Y Y
Business Context 48011-0010
If GRADE-LEVEL-CODE is "09", then none of the following fields should be "2": 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 "09" generally will not have completed any of the FHSP Endorsements.
S 1, 3 Y Y Y
Business Context 48011-0018
For a particular CAMPUS-ID, at least one student should be reported with FHSP-DISTING-LEVEL-ACHIEVE-INDICATOR-CODE of "2".

For a particular campus, at least one leaver who has graduated under the Foundation High School Program should be reported as having completed the distinguished level of achievement.
S 1 Y Y Y
Business Context 48011-0019
For a particular CAMPUS-ID, at least one student should be reported with a "2" in at least one of the following fields: 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.

For a particular campus, at least one leaver who has graduated under the Foundation High School Program should be reported as having completed a program to earn an endorsement.
S 1 Y Y Y