TSDS Web-Enabled Data Standards

Search. Drill. Find.

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

PDF
Rule Applies To
Rule
Type
Rule # Rule Text /
Business Meaning
Error
Level
TSDS PEIMS
Sub
ESC LEA Campus Charter
Business Context 10010-0015
For each Local Education Agency’s data submission, there must be data reported for the LEA itself.

Each LEA must report the basic information about itself.
F Y 1, 2, 3, 4 Y Y
Business Context 10011-0001
For districts registered with the TEA as the Texas School for the Deaf (227906), the Texas School for the Blind and Visually Impaired (227905), or the Texas Juvenile Justice Department (227622), the data submission must not contain a Shared Services Arrangement.

The Texas School for the Deaf, the Texas School for the Blind and Visually Impaired, and the Texas Juvenile Justice Department must not report participation in a shared services arrangement.
F 1, 2 Y
Business Context 10011-0002
If DISTRICT-ID and FISCAL-AGENT-DISTRICT-ID are the same value, then Shared Services Arrangement Actual Financial data with a matching SHARED-SVCS-ARRANGEMT-TYPE-CODE must be reported.

If a district is the fiscal agent for a shared services arrangement, then that district must report SSA actual financial data for each member district of that SSA.
F 2 Y Y Y
Business Context 10011-0003
FISCAL-AGENT-DISTRICT-ID must match an entry (district or ESC) registered with the TEA.

For a shared services arrangement, TX-FiscalAgentEducationOrganizationReference must be registered with the TEA.
F 1, 2 Y Y Y
Business Context 10011-0004
FISCAL-AGENT-DISTRICT-ID must not be registered with the TEA as a charter district.

An open enrollment charter school may not be reported as the fiscal agent for a shared services arrangement.
F 1, 2 Y Y Y
Business Context 10011-0005
If DISTRICT-ID and FISCAL-AGENT-DISTRICT-ID are the same value, then at least one Actual Financial data item must show a FUND-CODE that is a Shared Services Arrangement fund.

For a shared services arrangement, if the reporting district is also the fiscal agent for a SSA type, then that district must also report actual financial data to include a shared services arrangement fund code that matches the SSA type.
F 2 Y Y Y
Business Context 10011-0006
If SHARED-SVCS-ARRANGEMT-TYPE-CODE is "10", then FISCAL-AGENT-DISTRICT-ID must not be "227906".

Texas School for the Deaf must not be reported as a shared services arrangement fiscal agent for a Regional Day School Program for the Deaf (RDSPD).
F 1, 2 Y Y 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 10011-0008
If DISTRICT-ID and FISCAL-AGENT-DISTRICT-ID are NOT the same value, then Shared Services Arrangement Actual Financial data should not be reported for that SHARED-SVCS-ARRANGEMENT-TYPE-CODE.

If a district is not the fiscal agent for a shared services arrangement, then that district should not report SSA actual financial data for that TX-SharedServiceArrangement. Verify that the SSA is for the fiscal agent. The fiscal agent does not report an SSA for each SSA member district.
S 2 Y Y Y
Business Context 10011-0009
The data submission must not contain a Shared Services Arrangement except for the following charters: "057814", "057840", "068803", "101807", "101811", "174801", "212804", "220810", "227806", "227819", or "236802".

Open enrollment charter schools cannot be reported as a member district of a shared services arrangement, unless they are a governmental charter school, therefore they must not report any shared services arrangement data.
F 1, 2 Y
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-0002
Campus data must be provided for each campus registered with the TEA in the prior year with campus status of active or under construction.

Campus data must be reported for each campus registered with the TEA in the prior year with campus status of active or under construction.
F 2 Y Y
Business Context 10020-0005
The last three characters of CAMPUS-ID must be "001"-"698".

For a Campus, the StateOrganizationId must end with "001"-"698".
F Y 1, 2, 3, 4 Y Y Y
Business Context 10020-0008
For each campus registered with TEA as an active instructional campus in the prior school year, there should be Actual Financial data where ORGANIZATION-CODE matches the last three characters of CAMPUS-ID.

Actual Financial data where TX-OrganizationCode matches the lasts three characters of StateOrganizationId should be reported for each active instructional campus in the prior school year.
S 2 Y Y
Business Context 10020-0011
CAMPUS-ID must match an entry registered with TEA as active instructional or under construction in the prior school year.

For a Campus, the StateOrganizationId must be a valid campus registered with the TEA as active instructional or under construction in the prior school year.
F 2 Y Y Y
Business Context 20032-0001
There must be Actual Financial data where OBJECT-CODE is "5XXX" and where OBJECT-CODE is "6XXX".

The actual financial data reported for a local education agency must include amounts for revenues and expenditures.
F 2 Y Y Y
Business Context 20032-0002
There must be Actual Financial data where FUNCTION-CODE is "41".

The actual financial data reported must include amounts for the "general administration" TX-FunctionCode.
F 2 Y Y Y
Business Context 20032-0003
There must be Actual Financial data where FUNCTION-CODE is "13".

The actual financial data reported must include at least one amount where the TX-FunctionCode is "curriculum development and instructional staff development" (13).
F 2 Y Y Y
Business Context 20032-0004
If DISTRICT-ID is not "015906", "015913", "015914", or "180901", then there must be Actual Financial data for each of the following OBJECT-CODEs: "6119", "6212", and "6259".

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 actual financial data reported must include amounts for each of the following TX-ObjectCodes: "salaries or wages-teachers and other professional personnel" (6119), "audit services" (6212), and "utilities" (6259).
F 2 Y
Business Context 20032-0005
If DISTRICT-ID is not "015906", "015913", "015914", or "180901", then there must be Actual Financial data where OBJECT-CODE is "5711".

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 actual financial data reported must include amounts for the "taxes, current year levy" TX-ObjectCode (5711).
F 2 Y
Business Context 20032-0006
If DISTRICT-ID is not "015906", "015913", "015914", or "180901", then there must be Actual Financial data where OBJECT-CODE is "6213".

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 actual financial data reported must include amounts for the "tax appraisal and collection" object code (6213).
F 2 Y
Business Context 20032-0007
There must be Actual Financial data where FUND-CODE is "199" and OBJECT-CODE is "3XXX".

The actual financial data reported for a local education agency must include fund balances/net assets in the "General Fund".
F 2 Y
Business Context 20032-0008
There must be Actual Financial data where FUND-CODE is "199" and OBJECT-CODE is "6144".

The actual financial data reported for a local education agency must include amounts in the "General Fund" for the "teacher retirement/TRS Care - on-behalf payments" TX-ObjectCode (6144).
F 2 Y Y
Business Context 20032-0009
There must be Actual Financial data where OBJECT-CODE is "6212".

The actual financial data reported must include amounts for the "audit services" TX-ObjectCode.
F 2 Y Y Y
Business Context 20032-0010
There must be Actual Financial data where OBJECT-CODE is "6399".

The actual financial data reported must include amounts for the "general supplies" object code.
F 2 Y Y Y
Business Context 20032-0011
There must be Actual Financial data where PROGRAM-INTENT-CODE is "11" and OBJECT-CODE is "61XX"-"64XX".

The actual financial data reported for a local education agency must include amounts for the "basic educational services" program intent code (11) and at least one of the following expenditure TX-ObjectCodes: "payroll costs" (61XX), "professional and contracted services" (62XX), "supplies and materials" (63XX), and "other operating costs" (64XX).
F 2 Y
Business Context 20032-0012
FUNCTION-CODE must not be "62".

Only education service centers can report actual financial data for the "school district administrative support services" TX-FunctionCode.
F 2 Y Y
Business Context 20032-0013
PROGRAM-INTENT-CODE must not be "71"-"79" or "81"-"89".

Only education service centers can report actual financial data for the TX-ProgramIntentCodes "reserved for use by education service centers" (71-79, or 81-89).
F 2 Y Y
Business Context 20032-0014
FUND-CODE must not be "749", "751"-"755", or "799".

Actual financial data must not be reported to PEIMS for the following TX-FundCodes: "enterprise funds" (749), "transportation" (751), "print shop" (752), "insurance" (753), "computer operations" (754), "public entity risk pool" (755), or "internal service funds" (799).
F 2 Y Y Y
Business Context 20032-0015
ORGANIZATION-CODE must not be "700", "704"-"719", "721"-"749", or "752"-"997".

The actual financial data reported for a local education agency must not include amounts for the following administrative organizations: "general administration" (700), "reserved for future state definition" (704-708, 721-725, or 752-799), "direct costs - locally defined" (709-719), "indirect costs - locally defined" (726-749), or "locally defined" (800-997).
F 2 Y Y Y
Business Context 20032-0016
FUND-CODE must not be "420".

Only open enrollment charter schools can report actual financial data for the "foundation school program and other state aid" (420) TX-FundCode.
F 2 Y Y
Business Context 20032-0017
ACTUAL-AMOUNT must not exceed 325,000,000.

An actual financial item reported for an open enrollment charter school must not be reported in an amount greater than 325 million dollars ($325,000,000).
F 2 Y
Business Context 20032-0018
If OBJECT-CODE is within the range "61XX"-"66XX", then FUNCTION-CODE must not be "00".

For actual financial expenditures, the TX-FunctionCode must not be reported as "no function".
F 2 Y Y Y
Business Context 20032-0019
If OBJECT-CODE is within the range "61XX"-"66XX", then PROGRAM-INTENT-CODE must not be "00".

For actual financial expenditures, the TX-ProgramIntentCode must not be reported as "no program".
F 2 Y Y Y
Business Context 20032-0020
If OBJECT-CODE is within the range "61XX"-"66XX", then ORGANIZATION-CODE must not be "000", "709"-"719", "726"-"749", or "800"-"997".

For actual financial expenditures, the TX-OrganizationCode must not indicate any of the following: no organization (000), Direct Costs-Locally Defined (709-719), Indirect Costs-Locally Defined (726-749), or Locally Defined (800-997).
F 2 Y Y Y
Business Context 20032-0021
If FUND-CODE is "599", then OBJECT-CODE should be "3480", "3490", "3525", "3545", "3565", "3590", "5XXX", "64XX", "65XX", "791X", "7949", "7989", "891X", "8949", or "8989".

For actual financial data, if the TX-FundCode is "debt service funds", then the TX-ObjectCode should be selected fund balances (3480, 3490, 3525, 3545, 3565, 3590), a revenue (5XXX), an other operating costs (64XX), a debt service (65XX), selected other resources/non-operating revenue (791X, 7949, or 7989), or selected other uses/non-operating expenses (891X, 8949, or 8989).
S 2 Y Y
Business Context 20032-0022
If ORGANIZATION-CODE is "751", then FUND-CODE must be a Shared Services Arrangement fund in code table C145.

If the actual financial data reported has a "fiscal agent shared services arrangement" (751) TX-OrganizationCode, then the TX-FundCode must be a shared services arrangement fund code.
F 2 Y Y Y
Business Context 20032-0023
If OBJECT-CODE is "6224", then FUNCTION-CODE must be "91".

If the actual financial data reported includes amounts where the TX-ObjectCode is "student attendance credits" (6224), then the TX-FunctionCode must be "contracted instructional services between public schools" (91).
F 2 Y Y Y
Business Context 20032-0024
If FUND-CODE is "101", "102", "199", "240", "420", or "701", then FISCAL-YEAR must be "3".

For actual financial reporting, the fiscal year must indicate the prior school year if the TX-FundCode is "Food Service" (101), "ESC State Support" (102), "General Fund" (199), "National School Breakfast And Lunch Program" (240), "Foundation School Program And Other State Aid" (420), or "Enterprise Fund-National School Breakfast and Lunch Program" (701).
F 2 Y Y Y
Business Context 20032-0025
If DISTRICT-ID is a charter, but not a governmental charter ("057814", "057840", "068803", "101807", "101811", "174801", "212804", "220810", "227806", "227819", or "236802"), then OBJECT-CODE must not be "3200"-"3480", "3510"-"3580", "3800", "3900", "5711", "5712", "5721"-"5723", "5739", "5745", "5746", "5754", "5831", "5841", "5842", "5849", "5941", "5951", "5952", "5959", "6144", "6213", "6224", "6439", "6492", "6493", "6511"-"6513", "6519", "66XX", "7912"-"7915", "7918", "7949", "7952"-"7957", "7989", or "8912".

The actual financial data reported for an open enrollment charter school (excluding governmental charter schools) must not include amounts for object codes dedicated to independent school districts and governmental charter schools.
F 2 Y
Business Context 20032-0026
If DISTRICT-ID is a charter, but not a governmental charter ("057814", "057840", "068803", "101807", "101811", "174801", "212804", "220810", "227806", "227819", or "236802"), then ORGANIZATION-CODE must not be "700", "703"-"719", "721"-"749", or "751"-"997".

The actual financial data reported for an open enrollment charter school (excluding governmental charter schools) must not include amounts for any of the following TX-OrganizationCodes: "general administration" (700), "tax costs" (703), "reserved for future state definition" (704-708, 721-725, or 752-799), "direct costs - locally defined" (709-719), "indirect costs - locally defined" (726-749), "fiscal agent SSAs" (751), or "locally defined" (800-997).
F 2 Y
Business Context 20032-0027
If DISTRICT-ID is a charter, but not a governmental charter ("057814", "057840", "068803", "101807", "101811", "174801", "212804", "220810", "227806", "227819", or "236802"), then FUNCTION-CODE must not be "62" or "9X".

The actual financial data reported for an open enrollment charter school (excluding governmental charter schools) must not include amounts for TX-FunctionCodes "school district administrative support services" (62), or "intergovernmental charges" (9X).
F 2 Y
Business Context 20032-0028
If DISTRICT-ID is a charter, but not a governmental charter ("057814", "057840", "068803", "101807", "101811", "174801", "212804", "220810", "227806", "227819", or "236802"), then FUND-CODE must not be "102", "292"-"379", "400", "403", "405"-"408", "431"-"459", "479", or "5XX"-"9XX".

The actual financial data reported for an open enrollment charter school (excluding governmental charter schools) must not include amounts for the following fund codes: "ESC only" (102, 400, 403, 405-408), shared services arrangements (292-379, 431-459), "permanent fund" (479), "debt service funds" (5XX), "capital projects funds" (6XX), "proprietary fund types" (7XX), "fiduciary fund types" (8XX), or "general capital assets and long-term debt" (9XX).
F 2 Y
Business Context 20032-0029
If FUNCTION-CODE is "91", then OBJECT-CODE must be "61XX"-"64XX".

If the actual financial data reported includes amounts for the TX-FunctionCode "contracted instructional services between public schools" (91), then the TX-ObjectCode must be one of the following expenditure TX-ObjectCodes: "payroll costs" (61XX), "professional and contracted services" (62XX), "supplies and materials" (63XX), and "other operating costs" (64XX).
F 2 Y Y Y
Business Context 20032-0030
If FUNCTION-CODE is "41", then ORGANIZATION-CODE must be "701"-"703", "720", "750", or "751".

If the actual financial data reported includes amounts where the TX-FunctionCode is "general administration" (41), then the TX-OrganizationCode must be an administrative organization (701-703, 720, 750) or "fiscal agent SSA" (751).
F 2 Y Y
Business Context 20032-0031
FUND-CODE must not be "102", "400", "403", or "405"-"408".

Only education service centers can report actual financial data for the following TX-FundCodes: "ESC state support" (102), "school health" (400), "certification" (403), "gifted and talented" (405), "teacher recruitment" (406), "bilingual education" (407), and "technology" (408).
F 2 Y Y
Business Context 20032-0032
If FUNCTION-CODE is "91" or "92", then ORGANIZATION-CODE must be "999".

If the actual financial data reported includes amounts for "contracted instructional services between public schools" (91) or "incremental costs associated with chapter 41, Texas Education Code, purchase or sale of WADA" (92) TX-FunctionCodes, then the TX-OrganizationCode must be "undistributed" (999).
F 2 Y Y Y
Business Context 20032-0034
The sum of all ACTUAL-AMOUNTs where OBJECT-CODE is "57XX"-"59XX" must be greater than 0.

The actual financial data reported must include total revenues greater than zero ($0).
F 2 Y Y Y
Business Context 20032-0035
The sum of all ACTUAL-AMOUNTs where OBJECT-CODE is "57XX" must be greater than 0.

The actual financial data reported must include total local and intermediate revenues (57XX) greater than zero ($0).
F 2 Y Y
Business Context 20032-0036
The sum of all ACTUAL-AMOUNTs where OBJECT-CODE is "5811" must be greater than 0.

The actual financial data reported for a local education agency must include total "per capita apportionment " revenue greater than zero ($0).
F 2 Y
Business Context 20032-0037
The sum of all ACTUAL-AMOUNTs where OBJECT-CODE is "61XX"-"64XX" must be greater than 0.

The actual financial data reported must include total expenditures greater than zero ($0) from the following TX-ObjectCodes: "payroll costs" (61XX), "professional and contracted services" (62XX), "supplies and materials" (63XX), and "other operating costs" (64XX).
F 2 Y Y Y
Business Context 20032-0038
The sum of all ACTUAL-AMOUNTs where OBJECT-CODE is "65XX"-"66XX" must be greater than 0.

The actual financial data reported must include total expenditures from "debt service" and "capital outlay" TX-ObjectCodes (65XX-66XX) greater than zero ($0).
F 2 Y Y
Business Context 20032-0039
The sum of all ACTUAL-AMOUNTs where OBJECT-CODE is "79XX" must be greater than 0.

The actual financial data reported must include total "other resources" greater than zero ($0).
F 2 Y Y
Business Context 20032-0040
The sum of all ACTUAL-AMOUNTs where OBJECT-CODE is "89XX" must be greater than 0.

The actual financial data reported must include total "other uses" greater than zero ($0).
F 2 Y Y
Business Context 20032-0041
The sum of all ACTUAL-AMOUNTs where FUND-CODE is "199" and OBJECT-CODE is "57XX"-"59XX" must be greater than 0.

The actual financial data reported for the "general fund" (199) must include total revenues originating from local, state and federal TX-ObjectCodes (57XX-59XX) greater than zero ($0).
F 2 Y Y
Business Context 20032-0042
The sum of all ACTUAL-AMOUNTs where FUND-CODE is "199" and OBJECT-CODE is "61XX"-"64XX" must be greater than 0.

The actual financial data reported for the "general fund" (199) must include total expenditures greater than zero ($0) from the following TX-ObjectCodes: "payroll costs" (61XX), "professional and contracted services" (62XX), "supplies and materials" (63XX), and "other operating costs" (64XX).
F 2 Y Y
Business Context 20032-0043
The sum of all ACTUAL-AMOUNTs where FUND-CODE is "199" and OBJECT-CODE is "65XX"-"66XX" must be greater than 0.

The actual financial data reported for the "general fund" (199) must include total expenditures from "debt service" and "capital outlay" TX-ObjectCodes (65XX-66XX) greater than zero ($0).
F 2 Y Y
Business Context 20032-0044
The sum of all ACTUAL-AMOUNTs where FUND-CODE is "199" and OBJECT-CODE is "79XX" must be greater than 0.

The actual financial data reported for the "general fund" (199) must include total other resources originating from "other resources/non-operating revenues" TX-ObjectCodes (79XX) greater than zero ($0).
F 2 Y Y
Business Context 20032-0045
The sum of all ACTUAL-AMOUNTs where FUND-CODE is "199" and OBJECT-CODE is "89XX" must be greater than 0.

The actual financial data reported for the "general fund" (199) must include total other uses originating from "other uses/non-operating expenses" TX-ObjectCodes (89XX) greater than zero ($0).
F 2 Y Y
Business Context 20032-0046
If DISTRICT-ID is not "015906", "015913", "015914", or "180901", then the sum of all ACTUAL-AMOUNTs where OBJECT-CODE is "571X" must be greater than 0.

The 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 do not levy or collect property taxes for school district funding purposes. All other local education agencies, excluding charter schools, must report actual financial data where the TX-Amounts for "taxes, penalties, interest and other tax revenues" are greater than zero ($0).
F 2 Y
Business Context 20032-0047
For each reported FUNCTION-CODE, the sum of all ACTUAL-AMOUNTs where OBJECT-CODE is "61XX"-"66XX" must be greater than 0.

The actual financial data reported must include total expenditures (61XX-66XX) greater than zero ($0) for each TX-FunctionCode reported.
F 2 Y
Business Context 20032-0048
For each reported PROGRAM-INTENT-CODE, the sum of all ACTUAL-AMOUNTs where OBJECT-CODE is "61XX"-"64XX" must be greater than 0.

The actual financial data reported for each TX-ProgramIntentCode must include total expenditures greater than zero ($0) for the following TX-ObjectCodes: "payroll costs" (61XX), "professional and contracted services" (62XX), "supplies and materials" (63XX), and "other operating costs" (64XX).
F 2 Y Y
Business Context 20032-0049
The ((sum of ACTUAL-AMOUNTs where OBJECT-CODE is "6XXX" and FUND-CODE is not equal to "599" or "699" and FUNCTION-CODE is not equal to "81" or "91") divided by the (sum of ACTUAL-AMOUNTs where OBJECT-CODE is "5XXX" and FUND-CODE is not equal to "599" or "699" and FUNCTION-CODE is not equal to "81" or "91")) multiplied by 100 must be less than 200.00.

For actual financial data amounts for all TX-FundCodes, except "debt service funds" (599) and "capital projects funds" (699), and all TX-FunctionCodes, except "facilities acquisition and construction" (81) and "contracted instructional services between public schools" (91), the total expenditures (6XXX) must be less than 200% of the total revenues (5XXX).
F 2 Y
Business Context 20032-0050
The ((sum of ACTUAL-AMOUNTs where OBJECT-CODE is "6XXX") divided by the (sum of ACTUAL-AMOUNTs where OBJECT-CODE is "5XXX")) multiplied by 100 must be less than 200.00.

For actual financial data reported for an open enrollment charter school, the total expenses (6XXX) must be less than 200% of the total revenues.
F 2 Y
Business Context 20032-0051
There should be at least two Actual Financial data items where OBJECT-CODE is "5XXX".

The actual financial data reported for an open enrollment charter school should include revenues (5XXX) for at least two different TX-ObjectCodes.
S 2 Y
Business Context 20032-0052
There should be Actual Financial data for each of the following OBJECT-CODEs: "5811", "5812", "6319", and "6429".

The actual financial data reported for a local education agency should include amounts for each of the following TX-ObjectCodes: "per capita apportionment" (5811), "foundation school program act entitlements" (5812), "supplies for maintenance and/or operations" (6319), and "insurance and bonding costs" (6429).
S 2 Y
Business Context 20032-0053
There should be Actual Financial data where FUND-CODE is "199" and OBJECT-CODE is "5XXX".

The actual financial data reported for a local education agency should include revenues in the "General Fund".
S 2 Y
Business Context 20032-0055
There should be Actual Financial data where FUND-CODE is "410" and OBJECT-CODE is "5829".

The actual financial data reported for a local education agency should include at least one amount where the TX-FundCode is "state textbook fund" (410) and the TX-ObjectCode is "state program revenues distributed by TEA" (5829).
S 2 Y Y
Business Context 20032-0056
If DISTRICT-ID is a charter, but not a governmental charter ("057814", "057840", "068803", "101807", "101811", "174801", "212804", "220810", "227806", "227819", or "236802"), then there must be Actual Financial data where FUND-CODE is "420" and OBJECT-CODE is "5XXX".

The actual financial data reported for an open enrollment charter school (excluding governmental charter schools) must include revenue amounts for the "foundation school program and other state aid" (420) fund code.
F 2 Y
Business Context 20032-0057
There should be at least two Actual Financial data items where OBJECT-CODE is "61XX" and ORGANIZATION-CODE is different on the two items.

The actual financial data reported should include "payroll costs" expenditures (61XX) for at least two different TX-OrganizationCodes.
S 2 Y Y
Business Context 20032-0058
There must be Actual Financial data where OBJECT-CODE is "6146".

The actual financial data reported must include amounts for the "teacher retirement/TRS care" TX-ObjectCode.
F 2 Y Y Y
Business Context 20032-0062
There should be Actual Financial data where FUND-CODE is "410" and OBJECT-CODE is "6XXX".

The actual financial data reported for a local education agency should include expenditures for the "state textbook fund" TX-FundCode (410).
S 2 Y Y
Business Context 20032-0063
If DISTRICT-ID is a charter, but not a governmental charter ("057814", "057840", "068803", "101807", "101811", "174801", "212804", "220810", "227806", "227819", or "236802"), then there must be Actual Financial data where FUND-CODE is "420" and OBJECT-CODE is "6XXX".

The actual financial data reported for an open enrollment charter school (excluding governmental charter schools) must include expense amounts for the "foundation school program and other state aid" (420) fund code.
F 2 Y
Business Context 20032-0064
For each campus registered with TEA as an active instructional campus in the prior school year, excluding JJAEPs, there should be Actual Financial data where FUNCTION-CODE is "11".

The actual financial data reported for each active instructional campus that existed in the prior school year (excluding JJAEPs) should include amounts where the TX-FunctionCode is "instruction" (11).
S 2 Y Y
Business Context 20032-0065
For each campus registered with TEA as an active instructional campus in the prior school year, excluding JJAEPs, there should be Actual Financial data where OBJECT-CODE is "61XX" and FUNCTION-CODE is "11".

The actual financial data reported for each active instructional campus that existed in the prior school year (excluding JJAEPs), should include amounts where the TX-ObjectCode is "payroll costs" (61XX) and the TX-FunctionCode is "instruction" (11).
S 2 Y Y
Business Context 20032-0066
If FUND-CODE is a Shared Services Arrangement fund in code table C145, then there should be at least one Shared Services Arrangement reported where FISCAL-AGENT-DISTRICT-ID equals DISTRICT-ID in the Shared Services Arrangement Actual Financial data.

If the actual financial data reported includes amounts for shared services arrangement fund codes, then at least one SSA should be reported with a StateOrganizationId (TX-FiscalAgentEducationOrganizationReference) that matches the StateOrganizationId (TX-LEAReference) on the SSA financial actual data.
S 2 Y Y
Business Context 20032-0067
If FUND-CODE is a Shared Services Arrangement fund in code table C145, then there must be Shared Services Arrangement Actual Financial data reported.

If the actual financial data reported includes amounts for shared services arrangement TX-FundCodes, then Shared Services Arrangement Actual Financial data must also be reported.
F 2 Y Y
Business Context 20032-0068
If OBJECT-CODE is "6259" and ACTUAL-AMOUNT is less than 100, there should be at least one Shared Services Arrangement reported where SHARED-SVCS-ARRANGEMT-TYPE-CODE is "26".

If the actual financial data reported includes expenditures on "utilities" (6259) less than $100, then a 011 Shared Services Arrangement with shared services arrangement type code of "utilities" (26) should also be reported.
S 2 Y Y
Business Context 20032-0069
If OBJECT-CODE is "5722", "5841", or "5951", then there must be Shared Services Arrangement Actual Financial data reported.

If the actual financial data reported includes the TX-ObjectCodes "SSA-local revenues from member districts" (5722), "SSA-state revenues from member districts" (5841), "SSA-federal revenues from member districts" (5951), then Shared Services Arrangement Actual Financial data must also be reported.
F 2 Y Y
Business Context 20032-0070
ACTUAL-AMOUNT should not be greater than 3 billion dollars.

An actual financial item reported for a local education agency should not be reported in an amount greater than 3 billion dollars ($3,000,000,000).
S 2 Y Y
Business Context 20032-0071
OBJECT-CODE should not be "7959" or "7999".

The actual financial data reported should only include the TX-ObjectCodes "other gains" (7959) or "net assets released from temporary restrictions" (7999) when the LEA is an open enrollment charter school.
S 2 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-0074
If FUND-CODE is "199", FUNCTION-CODE is not "34", and OBJECT-CODE is not "6494", then ACTUAL-AMOUNT should not be less than zero.

The actual financial data reported should not include negative expenditure amounts for the general fund, with the exception of the TX-FunctionCode for "student (pupil) transportation" (34) and the TX-ObjectCode for "reclassified transportation expenditures/expenses" (6494).
S 2 Y Y Y
Business Context 20032-0075
If FUND-CODE is "2XX"-"429", then FISCAL-YEAR should be "1", "2", "3", or "4".

For actual financial reporting in selected special revenue fund codes (2XX-429) the TX-FiscalYear should indicate the current or the three prior school years.
S 2 Y Y Y
Business Context 20032-0076
If FUND-CODE is a Shared Services Arrangement fund in code table C145, and OBJECT-CODE is "61XX-"66XX", then ORGANIZATION-CODE must be "751".

If the actual financial data reported has an expenditure amount in a shared services arrangement TX-FundCode, then the TX-OrganizationCode must be "fiscal agent shared services arrangement" (751).
F 2 Y Y
Business Context 20032-0077
If FUNCTION-CODE is "71", then OBJECT-CODE must be "65XX".

If the actual financial data reported includes amounts for the TX-FunctionCode "debt service" (71), then the TX-ObjectCode must be "debt service" (65XX).
F 2 Y Y Y
Business Context 20032-0078
If FUNCTION-CODE is "99" and OBJECT-CODE is "6213", then ORGANIZATION-CODE should be "703".

If the actual financial data reported for a local education agency includes amounts for "other intergovernmental charges" (99) TX-FunctionCode, and the "tax appraisal and collection" (6213) TX-ObjectCode, then the TX-OrganizationCode should be "tax costs" (703).
S 2 Y
Business Context 20032-0079
If OBJECT-CODE is "5921" or "5922", then the FUND-CODE must be "240".

If the actual financial data reported for an open enrollment charter school includes the TX-ObjectCodes "school breakfast program" (5921) or "National School Lunch Program" (5922), then the TX-FundCode must be "National School Breakfast and Lunch Program" (240).
F 2 Y
Business Context 20032-0080
If ORGANIZATION-CODE is "001"-"698", then DISTRICT-ID combined with ORGANIZATION-CODE must be a Campus ID registered with the TEA as an active instructional campus or an under construction campus in the prior school year.

For actual financial data, an organization within the range of 001-698 must be registered with the TEA as an active instructional or under construction campus in the prior school year.
F 2 Y Y Y
Business Context 20032-0081
If OBJECT-CODE is "6211", then FUNCTION-CODE must be "41", "81", or "92".

If the actual financial data reported includes amounts where the TX-ObjectCode is "legal services" (6211), then the TX-FunctionCode must be "general administration" (41), "facilities acquisition and construction" (81), or "incremental costs associated with chapter 41, Texas Education Code, purchase or sale of WADA" (92).
F 2 Y Y Y
Business Context 20032-0082
If OBJECT-CODE is "6212" or "6214", then FUNCTION-CODE should be "41".

If the actual financial data reported for an open enrollment charter school includes amounts where the TX-ObjectCode is "audit services" (6212) or "lobbying" (6214), then the TX-FunctionCode should be "general administration" (41).
S 2 Y
Business Context 20032-0083
If OBJECT-CODE is "6213", then FUNCTION-CODE should be "41" or "92" or "99".

If the actual financial data reported includes amounts where the TX-ObjectCode is "tax appraisal and collection" (6213), then the TX-FunctionCode should be "general administration" (41), "incremental costs associated with chapter 41, Texas Education Code, purchase or sale of WADA" (92), or "other intergovernmental charges" (99).
S 2 Y
Business Context 20032-0084
If OBJECT-CODE is "6222" or "6223", then FUNCTION-CODE should be "11", "95", or "99".

If the actual financial data reported includes amounts where the TX-ObjectCode is "student tuition-public schools" (6222) or "student tuition-other than to public schools" (6223), then the TX-FunctionCode should be "instruction" (11), "payments to JJAEP programs" (95). Or "other intergovernmental charges" (99).
S 2 Y Y Y
Business Context 20032-0085
If OBJECT-CODE is "6259", then FUNCTION-CODE should be "51" or "81".

If the actual financial data reported includes amounts where the TX-ObjectCode is "utilities" (6259), then the TX-FunctionCode should be "facilities maintenance and operations" (51), or "facilities acquisition and construction" (81).
S 2 Y Y Y
Business Context 20032-0086
If OBJECT-CODE is "6321", then FUNCTION-CODE should be "11" or "61".

If the actual financial data reported includes amounts where the TX-ObjectCode is "Instructional Materials" (6321), then the TX-FunctionCode should be "instruction" (11) or "community services" (61).
S 2 Y Y
Business Context 20032-0087
If OBJECT-CODE is "6339", then FUNCTION-CODE should be "11", "31", or "61".

If the actual financial data reported includes amounts where the TX-ObjectCode is "testing materials" (6339), then the TX-FunctionCode should be "instruction" (11), "guidance, counseling, and evaluation services" (31), or "community services" (61).
S 2 Y Y Y
Business Context 20032-0088
If OBJECT-CODE is "634X", then FUNCTION-CODE should be "35", "36", or "61".

If the actual financial data reported includes amounts where the TX-ObjectCode is "food service or other resale items" (634X), then the TX-FunctionCode should be "food services" (35), "extracurricular activities" (36), or "community services" (61).
S 2 Y Y
Business Context 20032-0089
If OBJECT-CODE is "6412", then FUNCTION-CODE should be "11", "36", or "61".

If the actual financial data reported includes amounts where the TX-ObjectCode is "travel and subsistence-students" (6412), then the TX-FunctionCode should be "instruction" (11), "extracurricular activities" (36), or "community services" (61).
S 2 Y Y Y
Business Context 20032-0090
If OBJECT-CODE is "6413", then FUNCTION-CODE should not be "71", "81", or "93".

If the actual financial data reported includes amounts where the TX-ObjectCode is "stipends-non-employees" (6413), then the TX-FunctionCode should not be "debt service" (71), "facilities acquisition and construction" (81), or "payments to fiscal agent/member district of shared services arrangements" (93).
S 2 Y Y Y
Business Context 20032-0091
If OBJECT-CODE is "6439", then FUNCTION-CODE should be "41" or "81".

If the actual financial data reported includes amounts where the TX-ObjectCode is "election costs" (6439), then the TX-FunctionCode should be "general administration" (41), or "facilities acquisition and construction" (81).
S 2 Y
Business Context 20032-0093
If OBJECT-CODE is "65XX", then FUNCTION-CODE must be "71".

If the actual financial data reported includes amounts where the TX-ObjectCode is "debt service" (65XX), then the TX-FunctionCode must be "debt service" (71).
F 2 Y Y Y
Business Context 20032-0094
If OBJECT-CODE is "6619" or "6629", then FUNCTION-CODE must be "51" or "81".

If the actual financial data reported includes amounts where the TX-ObjectCode is "land purchase and improvement" (6619) or "building purchase, construction, or improvements" (6629), then the TX-FunctionCode must be "facilities maintenance and operations" (51), or "facilities acquisition and construction" (81).
F 2 Y Y Y
Business Context 20032-0095
If ORGANIZATION-CODE is "701"-"703", "720", or "750", then FUNCTION-CODE must be "41", "53", or "99".

The actual financial data reported for a local education agency’s "administrative organizations" (701-703, 720, 750) must only include function codes: "general administration" (41), "data processing services" (53), and "other intergovernmental charges" (99).
F 2 Y Y
Business Context 20032-0096
If PROGRAM-INTENT-CODE is "11", then FUND-CODE should be "102", "199", "212", "236", "238", "239", "255", "258", "259", "266", "269", "270", "271", "272", "273", "277", "278", "279", "280", "281", "282", "283", "284", "285", "289", "300", "301", "345", "347", "357", "364", "365", "366", "367", "379", "383", "384", "388", "391", "393", "399", "402", "404", "406", "408", "410", "414", "415", "420", "422", "429", "433", "439", "459", "461", "479", "499", or "699".

If the actual financial 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, selected "special revenue (local programs)" funds, or "capital projects funds" (699).
S 2 Y Y Y
Business Context 20032-0097
If PROGRAM-INTENT-CODE is "21", then FUND-CODE should be "102", "199", "212", "218", "255", "258", "259", "266", "269", "270", "271", "272", "273", "277", "278", "279", "280", "281", "282", "283", "284", "289", "301", "307", "345", "347", "357", "364", "367", "379", "383", "384", "388", "391", "393", "397", "402", "405", "410", "414", "420", "422", "429", "433", "439", "459", "461", "479", "499", or "699".

If the actual financial 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, selected "special revenue (local programs)" funds, or "capital projects funds" (699).
S 2 Y Y Y
Business Context 20032-0098
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", "269", "270", "271", "272", "273", "277", "278", "279", "280", "281", "282", "283", "284", "289", "301", "331", "332", "333", "334", "335", "337", "338", "345", "347", "357", "364", "367", "379", "383", "384", "387", "388", "391", "393", "396", "410", "414", "420", "422", "429", "433", "439", "459", "461", "479", "499", or "699".

If the actual financial 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, selected "special revenue (local programs)" funds, or "capital projects funds" (699).
S 2 Y Y Y
Business Context 20032-0099
If PROGRAM-INTENT-CODE is "23", then FUND-CODE should be "102", "199", "205", "224", "225", "226", "227", "228", "229", "230", "236", "238", "239", "253", "255", "258", "259", "266", "269", "270", "271", "272", "273", "277", "278", "279", "280", "281", "282", "283", "284", "285", "289", "313", "314", "315", "316", "317", "319", "325", "327", "328", "340", "345", "347", "357", "364", "365", "366", "367", "379", "383", "384", "385", "386", "392", "393", "399", "402", "410", "414", "415", "416", "419", "420", "422", "429", "434", "435", "437", "439", "441", "459", "461", "479", "499", or "699".

If the actual financial 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, selected "special revenue (local programs)" funds, or "capital projects funds" (699).
S 2 Y Y Y
Business Context 20032-0100
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", "269", "270", "271", "272", "273", "274", "275", "276", "277", "278", "279", "280", "281", "282", "283", "284", "285", "289", "292", "294", "300", "301", "309", "311", "312", "325", "327", "328", "329", "342", "345", "347", "352", "354", "355", "357", "364", "365", "366", "367", "379", "381", "382", "383", "384", "388", "390", "391", "392", "393", "395", "396", "397", "398", "399", "402", "404", "409", "410", "412", "414", "415", "416", "419", "420", "422", "429", "431", "432", "433", "439", "441", "459", "461", "479", "499", or "699".

If the actual financial 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, selected "special revenue (local programs)" funds, or "capital projects funds" (699).
S 2 Y Y Y
Business Context 20032-0101
If PROGRAM-INTENT-CODE is "25", then FUND-CODE should be "102", "199", "212", "255", "258", "259", "263", "266", "269", "270", "271", "272", "273", "277", "278", "279", "280", "281", "282", "283", "284", "285", "289", "301", "345", "347", "350", "357", "364", "365", "366", "367", "379", "383", "388", "390", "391", "393", "399", "402", "407", "410", "412", "414", "415", "420", "422", "429", "433", "439", "442", "459", "461", "479", "499", or "699".

If the actual financial 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, selected "special revenue (local programs)" funds, or "capital projects funds" (699).
S 2 Y Y Y
Business Context 20032-0102
If PROGRAM-INTENT-CODE is "30", then FUND-CODE should be "102", "199", "211", "266", "271", "272", "276", "277", "278", "279", "280", "281", "282", "283", "284", "285", "289", "300", or "420".

If the actual financial 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 2 Y Y Y
Business Context 20032-0104
If PROGRAM-INTENT-CODE is "33", then FUND-CODE should be "199", "205", "206", "212", "263", "266", "269", "270", "272", "274", "275", "276", "277", "278", "279", "280", "281", "282", "283", "289", "294", "301", "345", "347", "350", "367", "379", "388", "390", "391", "393", "395", "396", "402", "404", "410", "414", "415", "416", "419", "420", "422", "429", "439", "442", "459", "461", "479", or "499".

If the actual financial data reported includes amounts for the TX-ProgramIntentCode "pre-kindergarten-special education" (33), 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 2 Y Y Y
Business Context 20032-0105
If PROGRAM-INTENT-CODE is "91", then FUNCTION-CODE must be "36", "51", or "52".

If the actual financial data reported includes amounts for the "athletics and related activities" (91) TX-ProgramIntentCode, then the TX-FunctionCode must be "extracurricular activities" (36), "facilities maintenance and operations" (51), or "security and monitoring services" (52).
F 2 Y Y Y
Business Context 20032-0106
The sum of ACTUAL-AMOUNTs where OBJECT-CODE is "3XXX" should not be a negative number.

The actual financial data reported should not include total fund balances/net assets less than zero ($0).
S 2 Y Y Y
Business Context 20032-0107
There should be Actual Financial data where FUND-CODE is "199" and PROGRAM-INTENT-CODE is "21", and the sum of all ACTUAL-AMOUNTs for this data should be greater than 0.

The actual financial data reported for the "general fund" (199) should include total amounts greater than zero ($0) for the "gifted and talented" (21) TX-ProgramIntentCode.
S 2 Y
Business Context 20032-0108
There should be Actual Financial data where FUND-CODE is "199" and PROGRAM-INTENT-CODE is "22", and the sum of all ACTUAL-AMOUNTs for this data should be greater than 0.

The actual financial data reported for the "general fund" (199) should include total amounts greater than zero ($0) for the "career and technical" (22) TX-ProgramIntentCode.
S 2 Y
Business Context 20032-0109
There should be Actual Financial data where FUND-CODE is "199" and PROGRAM-INTENT-CODE is "23", and the sum of all ACTUAL-AMOUNTs for this data should be greater than 0.

The actual financial data reported for the "general fund" (199) should include total amounts greater than zero ($0) for the "special education" (23) TX-ProgramIntentCode.
S 2 Y
Business Context 20032-0110
There should be Actual Financial data where FUND-CODE is "199" and PROGRAM-INTENT-CODE is "24", "26", "28", "29" or "30", and the sum of all ACTUAL-AMOUNTs for this data should be greater than 0.

The actual financial data reported for the "general fund" (199) should include total amounts greater than zero ($0) for the following TX-ProgramIntentCodes: "accelerated education" (24), "non-disciplinary alternative education programs - AEP services" (26), "disciplinary alternative education programs - DAEP basic services" (28), "disciplinary alternative education programs - DAEP state compensatory education supplemental costs" (29), and "Title I, Part A schoolwide activities related to state compensatory education costs on campuses with 40% or more educationally disadvantaged students" (30).
S 2 Y
Business Context 20032-0111
There should be Actual Financial data where FUND-CODE is "199" and PROGRAM-INTENT-CODE is "25", and the sum of all ACTUAL-AMOUNTs for this data should be greater than 0.

The actual financial data reported for the "general fund" (199) should include total amounts greater than zero ($0) for the "bilingual education and special language programs" (25) TX-ProgramIntentCode.
S 2 Y
Business Context 20032-0113
There should be Actual Financial data where FUND-CODE is "199" and PROGRAM-INTENT-CODE is "33", and the sum of all ACTUAL-AMOUNTs for this data should be greater than 0.

The actual financial data reported for the "general fund" (199) should include total amounts greater than zero ($0) for the "pre-kindergarten-special education" (33) TX-ProgramIntentCode.
S 2 Y
Business Context 20032-0114
There should be Actual Financial data where FUND-CODE is "420" and PROGRAM-INTENT-CODE is "21", and the sum of all ACTUAL-AMOUNTs for this data should be greater than 0.

The actual financial data reported for an open enrollment charter school for the "foundation school program and other state aid" (420) fund code should include total amounts greater than zero ($0) for the "gifted and talented" (21) TX-ProgramIntentCode.
S 2 Y
Business Context 20032-0115
There should be Actual Financial data where FUND-CODE is "420" and PROGRAM-INTENT-CODE is "22", and the sum of all ACTUAL-AMOUNTs for this data should be greater than 0.

The actual financial data reported for an open enrollment charter school for the "foundation school program and other state aid" (420) fund code should include total amounts greater than zero ($0) for the "career and technical" (22) TX-ProgramIntentCode.
S 2 Y
Business Context 20032-0116
There should be Actual Financial data where FUND-CODE is "420" and PROGRAM-INTENT-CODE is "23", and the sum of all ACTUAL-AMOUNTs for this data should be greater than 0.

The actual financial data reported for an open enrollment charter school for the "foundation school program and other state aid" (420) fund code should include total amounts greater than zero ($0) for the "special education" (23) TX-ProgramIntentCode.
S 2 Y
Business Context 20032-0117
There should be Actual Financial data where FUND-CODE is "420" and PROGRAM-INTENT-CODE is "24", "26", "28", "29" or "30", and the sum of all ACTUAL-AMOUNTs for this data should be greater than 0.

The actual financial data reported for an open enrollment charter school for the "foundation school program and other state aid" (420) fund code should include total amounts greater than zero ($0) for the following TX-ProgramIntentCodes: "accelerated education" (24), "non-disciplinary alternative education programs - AEP services" (26), "disciplinary alternative education programs - DAEP basic services" (28), "disciplinary alternative education programs - DAEP state compensatory education supplemental costs" (29), and "Title I, Part A schoolwide activities related to state compensatory education costs on campuses with 40% or more educationally disadvantaged students" (30).
S 2 Y
Business Context 20032-0118
There should be Actual Financial data where FUND-CODE is "420" and PROGRAM-INTENT-CODE is "25", and the sum of all ACTUAL-AMOUNTs for this data should be greater than 0.

The actual financial data reported for an open enrollment charter school for the "foundation school program and other state aid" (420) fund code should include total amounts greater than zero ($0) for the "bilingual education and special language programs" (25) TX-ProgramIntentCode.
S 2 Y
Business Context 20032-0120
There should be Actual Financial data where FUND-CODE is "420" and PROGRAM-INTENT-CODE is "33", and the sum of all ACTUAL-AMOUNTs for this data should be greater than 0.

The actual financial data reported for an open enrollment charter school for the "foundation school program and other state aid" (420) fund code should include total amounts greater than zero ($0) for the "pre-kindergarten-special education" (33) TX-ProgramIntentCode.
S 2 Y
Business Context 20032-0121
The sum of ACTUAL-AMOUNTs where FUNCTION-CODE is "31"-"33" and OBJECT-CODE is "61XX"-"66XX" should be greater than or equal to the sum of ACTUAL-AMOUNTs where OBJECT-CODE is "5932".

The total actual financial amounts for expenditures 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 actual financial amounts for the TX-ObjectCode "Medicaid Administrative Claiming Program-MAC" (5932).
S 2 Y Y
Business Context 20032-0122
If ADA is less than 500, then the sum of ACTUAL-AMOUNTs where OBJECT-CODE is "6XXX" and FUND-CODE is not a Shared Services Arrangement fund in code table C145 should not be greater than 10,000,000.

If ADA is less than 500, then total actual financial expenditures (excluding SSA fund codes) should not be greater than $10,000,000.
S 2 Y Y
Business Context 20032-0123
If ADA is between 500 and 1,000, then the sum of ACTUAL-AMOUNTs where OBJECT-CODE is "6XXX" and FUND-CODE is not a Shared Services Arrangement fund in code table C145 should not be greater than 20,000,000.

If ADA is between 500 and 1,000, then total actual financial expenditures (excluding SSA fund codes) should not be greater than $20,000,000.
S 2 Y Y
Business Context 20032-0124
If ADA is between 1,001 and 5,000, then the sum of ACTUAL-AMOUNTs where OBJECT-CODE is "6XXX" and FUND-CODE is not a Shared Services Arrangement fund in code table C145 should not be greater than 100,000,000.

If ADA is between 1,001 and 5,000, then total actual financial expenditures (excluding SSA fund codes) should not be greater than $100,000,000.
S 2 Y Y
Business Context 20032-0125
If ADA is between 5,001 and 10,000, then the sum of ACTUAL-AMOUNTs where OBJECT-CODE is "6XXX" and FUND-CODE is not a Shared Services Arrangement fund in code table C145 should not be greater than 225,000,000.

If ADA is between 5,001 and 10,000, then total actual financial expenditures (excluding SSA fund codes) should not be greater than $225,000,000.
S 2 Y Y
Business Context 20032-0126
If ADA is between 10,001 and 20,000, then the sum of ACTUAL-AMOUNTs where OBJECT-CODE is "6XXX" and FUND-CODE is not a Shared Services Arrangement fund in code table C145 should not be greater than 275,000,000.

If ADA is between 10,001 and 20,000, then total actual financial expenditures (excluding SSA fund codes) should not be greater than $275,000,000.
S 2 Y Y
Business Context 20032-0127
If ADA is between 20,001 and 30,000, then the sum of ACTUAL-AMOUNTs where OBJECT-CODE is "6XXX" and FUND-CODE is not a Shared Services Arrangement fund in code table C145 should not be greater than 400,000,000.

If ADA is between 20,001 and 30,000, then total actual financial expenditures (excluding SSA fund codes) should not be greater than $400,000,000.
S 2 Y Y
Business Context 20032-0128
If ADA is between 30,001 and 50,000, then the sum of ACTUAL-AMOUNTs where OBJECT-CODE is "6XXX" and FUND-CODE is not a Shared Services Arrangement fund in code table C145 should not be greater than 650,000,000.

If ADA is between 30,001 and 50,000, then total actual financial expenditures (excluding SSA fund codes) should not be greater than $650,000,000.
S 2 Y Y
Business Context 20032-0129
If ADA is between 50,001 and 60,000, then the sum of ACTUAL-AMOUNTs where OBJECT-CODE is "6XXX" and FUND-CODE is not a Shared Services Arrangement fund in code table C145 should not be greater than 750,000,000.

If ADA is between 50,001 and 60,000, then total actual financial expenditures (excluding SSA fund codes) should not be greater than $750,000,000.
S 2 Y Y
Business Context 20032-0130
If ADA is between 60,001 and 80,000, then the sum of ACTUAL-AMOUNTs where OBJECT-CODE is "6XXX" and FUND-CODE is not a Shared Services Arrangement fund in code table C145 should not be greater than 1,000,000,000.

If ADA is between 60,001 and 80,000, then total actual financial expenditures (excluding SSA fund codes) should not be greater than $1,000,000,000.
S 2 Y Y
Business Context 20032-0131
The sum of ACTUAL-AMOUNTs where FUND-CODE is not "599", "699", or a Shared Services Arrangement fund in code table C145, and OBJECT-CODE is "5XXX" divided by ADA should not be greater than 10,000.

The total actual financial revenues per Average Daily Attendance (ADA) unit should not be greater than $10,000 for all amounts, excluding those with SSA fund codes, "debt service funds" (599), or "capital projects funds" (699).
S 2 Y Y
Business Context 20032-0132
The sum of ACTUAL-AMOUNTs where FUND-CODE is "199", FUNCTION-CODE is "11", OBJECT-CODE is "6119", and PROGRAM-INTENT-CODE is "11" divided by ADA should be between 2,000 and 10,000.

The total actual amounts per ADA should be between $2,000 and $10,000 for all actual amounts where the TX-FundCode is "General Fund" (199), the TX-FunctionCode is "Instruction" (11), the TX-ObjectCode is "Salaries Or Wages-Teachers And Other Professional Personnel" (6119), and the TX-ProgramIntentCode is "Basic Educational Services" (11).
S 2 Y
Business Context 20032-0133
The sum of ACTUAL-AMOUNTs where FUND-CODE is not a Shared Services Arrangement fund in code table C145, FUNCTION-CODE is not "71" or "81", and OBJECT-CODE is not "3XXX", "5XXX", or "65XX"-"89XX", divided by ADA should not be greater than 10,000.

The total actual financial amounts per Average Daily Attendance (ADA) unit should not be greater than $10,000 where the TX-ObjectCodes reported are "payroll costs" (61XX), "professional and contracted services" (62XX), "supplies and materials" (63XX), or "other operating costs" (64XX), and excluding amounts with SSA TX-FundCodes and amounts where the TX-FunctionCode is "debt service" (71) and "facilities acquisition and construction" (81).
S 2 Y Y
Business Context 20032-0134
The sum of ACTUAL-AMOUNTs where OBJECT-CODE is "5811" and "5812" should not vary more than 20% from the prior year Foundation Master File amount that includes Available School Fund, Foundation School Fund and Reduction for WADA Sold.

The total actual financial amounts for "per capita apportionment" (5811) and "foundation school program act entitlements" (5812) reported should not vary by more than 20% from the LEA's prior year Foundation Master File amount that includes Available School Fund, Foundation School Fund, and Reduction for WADA Sold.
S 2 Y Y
Business Context 20032-0135
The sum of ACTUAL-AMOUNTs where OBJECT-CODE is "61XX"-"64XX" and PROGRAM-INTENT-CODE is "21" should not be greater than 7% of the sum of ACTUAL-AMOUNTs where OBJECT-CODE is "61XX"-"64XX".

The actual financial data reported for a local education agency for the "gifted and talented" program (PIC 21) should not be more that 7 percent of the total expenditures for the "payroll costs" (61XX), "professional and contracted services" (62XX), "supplies and materials" (63XX), and "other operating costs" (64XX) object codes.
S 2 Y Y
Business Context 20032-0136
The sum of ACTUAL-AMOUNTs where OBJECT-CODE is "61XX"-"64XX" and PROGRAM-INTENT-CODE is "22" should not be greater than 12% of the sum of ACTUAL-AMOUNTs where OBJECT-CODE is "61XX"-"64XX".

The actual financial data reported for the "career and technical" program (PIC 22) should not be more that 12 percent of the total expenditures for the "payroll costs" (61XX), "professional and contracted services" (62XX), "supplies and materials" (63XX), and "other operating costs" (64XX) TX-ObjectCodes.
S 2 Y Y
Business Context 20032-0137
The sum of ACTUAL-AMOUNTs where OBJECT-CODE is "61XX"-"64XX" and PROGRAM-INTENT-CODE is "23" should not be greater than 25% of the sum of ACTUAL-AMOUNTs where OBJECT-CODE is "61XX"-"64XX".

The actual financial data reported for a local education agency for the "special education" program (PIC 23) should not be more that 25 percent of the total expenditures for the "payroll costs" (61XX), "professional and contracted services" (62XX), "supplies and materials" (63XX), and "other operating costs" (64XX) object codes.
S 2 Y Y
Business Context 20032-0138
The sum of ACTUAL-AMOUNTs where OBJECT-CODE is "61XX"-"64XX" and PROGRAM-INTENT-CODE is "24" should not be greater than 20% of the sum of ACTUAL-AMOUNTs where OBJECT-CODE is "61XX"-"64XX".

The actual financial data reported for the "accelerated education" programs (PIC 24) should not be more that 20 percent of the total expenditures for the "payroll costs" (61XX), "professional and contracted services" (62XX), "supplies and materials" (63XX), and "other operating costs" (64XX) TX-ObjectCodes.
S 2 Y Y
Business Context 20032-0139
The sum of ACTUAL-AMOUNTs where OBJECT-CODE is "61XX"-"64XX" and PROGRAM-INTENT-CODE is "25" should not be greater than 10% of the sum of ACTUAL-AMOUNTs where OBJECT-CODE is "61XX"-"64XX".

The actual financial data reported for the "bilingual education and special language" programs (PIC 25) should not be more that 10 percent of the total expenditures for the "payroll costs" (61XX), "professional and contracted services" (62XX), "supplies and materials" (63XX), and "other operating costs" (64XX) TX-ObjectCodes.
S 2 Y Y
Business Context 20032-0140
The sum of ACTUAL-AMOUNTs where FUND-CODE is not "599" or "699", and OBJECT-CODE is "65XX"-"66XX" should not be greater than 30% of the sum of ACTUAL-AMOUNTs where FUND-CODE is not "599" or "699" and OBJECT-CODE is "61XX"-"66XX".

For all fund codes except for "debt service funds" (599) and "capital projects funds" (699), the total actual financial amounts for the "debt service" and "capital outlay" object codes (65XX-66XX) should not be greater than 30% of the total actual financial amounts for all expenditure object codes (61XX-66XX).
S 2 Y Y
Business Context 20032-0141
The sum of all ACTUAL-AMOUNTs where OBJECT-CODE is "5929" should not exceed 5% of the sum of all ACTUAL-AMOUNTs where OBJECT-CODE is "5XXX".

For an open enrollment charter school, the total actual financial amounts for object code "federal revenues distributed by TEA" (5929) should not be greater than 5% of the total actual financial revenues reported.
S 2 Y
Business Context 20032-0142
The total revenues (OBJECT-CODE "5XXX") for the current year actual financials for the "General Fund" should not increase by more than 25% over the prior year actual financials for the "General Fund".

Total revenues for current year Actual Financial for the General Fund should not increase by more than 25% over the prior year Actual Financial for the General Fund.
S 2 Y
Business Context 20032-0143
Total expenditures (OBJECT-CODE "6XXX") for current year Actual Financial for FUND-CODE "199" should not increase by more than 25% over the prior year Actual Financial for FUND-CODE "199".

The total expenditures for the current year actual financials for the "General Fund" should not increase by more than 25% over the prior year actual financials for the "General Fund".
S 2 Y
Business Context 20032-0144
Total revenues (OBJECT-CODE "5XXX") for current year Actual Financial for FUND-CODE "420" should not increase by more than 25% over the prior year Actual Financial for FUND-CODE "420".

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

For an open enrollment charter school, the total expenses for the current year for the "foundation school program and other state aid" TX-FundCode should not increase by more than 25% over the prior year amounts for that fund code.
S 2 Y
Business Context 20032-0146
The ((sum of ACTUAL-AMOUNTs where OBJECT-CODE is "6XXX" and FUND-CODE is not equal to "599" or "699" and FUNCTION-CODE is not equal to "81" or "91") divided by the (sum of ACTUAL-AMOUNTs where OBJECT-CODE is "5XXX" and FUND-CODE is not equal to "599" or "699" and FUNCTION-CODE is not equal to "81" or "91")) multiplied by 100 should be less than 150.00.

For actual financial data amounts for all TX-FundCodes, except "debt service funds" (599) and "capital projects funds" (699), and all TX-FunctionCodes, except "facilities acquisition and construction" (81) and "contracted instructional services between public schools" (91), the total expenditures (6XXX) should be less than 150% of the total revenues (5XXX).
S 2 Y
Business Context 20032-0147
The ((sum of ACTUAL-AMOUNTs where OBJECT-CODE is "6XXX") divided by the (sum of ACTUAL-AMOUNTs where OBJECT-CODE is "5XXX")) multiplied by 100 should be less than 125.00.

For actual financial data reported for an open enrollment charter school, the total expenses (6XXX) should be less than 125% of the total revenues (5XXX).
S 2 Y
Business Context 20032-0148
The sum of all ACTUAL-AMOUNTs where OBJECT-CODE is "6212" should be greater than 0.

The actual financial data reported should included total amounts for "Audit Services" that are greater than zero ($0).
S 2 Y
Business Context 20032-0149
There should be Actual Financial data where OBJECT-CODE is "6491".

The actual financial data reported for an LEA should include at least one amount for TX-ObjectCode “Statutorily Required Public Notices” (6491).
S 2 Y
Business Context 20032-0150
OBJECT-CODE must not be "6491".

Open enrollment charter schools must not report actual financial data for "Statutorily Required Public Notices" (TX-ObjectCode 6491).
F 2 Y
Business Context 20032-0151
If FUND-CODE is "269", "278", "279", "280", "284", "285", or "345", then FUNCTION-CODE must not be "71".

TX-FunctionCode must not be "Debt Service" (71) when TX-FundCode is certain federal funds or federally funded SSAs related to the ARP Act, and ESEA Title V, Part B, Subpart 1 (The Small, Rural School Achievement Program).
F 2 Y Y
Business Context 20032-0152
If FUND-CODE is "269", "277", "278", "279", "280", "284", "285", or "345", then FUNCTION-CODE must not be "81".

TX-FunctionCode must not be “Facilities Acquisition And Construction" (81) when TX-FundCode is certain federal funds or federally funded SSAs related to the CARES Act, the ARP Act, and ESEA Title V, Part B, Subpart 1 (The Small, Rural School Achievement Program).
F 2 Y Y
Business Context 20032-0153
If FUNCTION-CODE is "71", and FUND-CODE is "2XX", then OBJECT-CODE must be "6512", "6514", "6522", or "6526".

Federal funds (TX-FundCode that starts with "2") may only be used with TX-FunctionCode "Debt Service" (71) when TX-ObjectCode is "Right To Use Lease Liability - Principal" (6512), "Subscription-Based Information Technology Arrangements (SBITA) - Principal" (6514), "Interest On Right To Use Leases" (6522), or "Interest on Subscription-Based Information Technology Arrangements (SBITA)" (6526).
F 2 Y Y
Business Context 20033-0001
SHARED-SVCS-ARR-MEMBER-DIST-ID must match a DISTRICT-ID or EDUCATION-SERVICE-CENTER-ID registered with the TEA in the prior school year.

The TX-SharedSvcsArrMemberLEAReference must be an LEA or ESC registered with the TEA in the prior school year.
F 2 Y Y Y
Business Context 20033-0002
SHARED-SVCS-ARR-MEMBER-DIST-ID must not be a Local Education Agency registered with the TEA as a charter unless SHARED-SVCS-ARR-MEMBER-DIST-ID is "057814", "057840", "068803", "101807", "101811", "174801", "212804", "220810", "227806", "227819", or "236802".

For SSA financial actual data, an open enrollment charter school cannot be reported as a member district of a shared services arrangement unless they are a governmental charter school.
F 2 Y
Business Context 20033-0003
DISTRICT-ID must not be a Local Education Agency registered with the TEA as a charter in the prior school year.

An open enrollment charter school cannot be reported as the fiscal agent of a shared services arrangement, and therefore cannot report SSA financial actual data. Each open enrollment charter school reports its own share of SSA expenditures on its own actual financial data.
F 2 Y
Business Context 20033-0004
FISCAL-YEAR must be "1", "2", "3", or "4".

For shared services arrangement actual financial data reported, the TX-FiscalYear must indicate the current or the three prior school years.
F 2 Y Y Y
Business Context 20033-0006
DISTRICT-ID in the Shared Services Arrangement Actual Financial data must equal FISCAL-AGENT-DISTRICT-ID on the Shared Services Arrangement.

The fiscal agent district reporting SSA actual financial data must report SSA organization data.
F 2 Y Y
Business Context 20033-0007
SHARED-SVCS-ARRANGEMENT-TYPE-CODE in the Shared Services Arrangement Actual Financial data must match SHARED-SVCS-ARRANGEMENT-TYPE-CODE on a Shared Services Arrangement where DISTRICT-ID matches FISCAL-AGENT-DISTRICT-ID on the SSA.

The fiscal agent district reporting SSA financial actual data must report SSA organization data with matching TX-SharedServiceArrangement type codes.
F 2 Y Y
Business Context 20033-0008
For a particular FUND-CODE and FISCAL-YEAR, the sum of all ACTUAL-AMOUNTs on Shared Services Arrangement Financial data should equal the sum of all ACTUAL-AMOUNTs on Actual Financial data for the same FUND-CODE and FISCAL-YEAR combination where OBJECT-CODE is "6XXX", but not "6492" and "6493".

For each matching combination of TX-FundCode and TX-FiscalYear, the total of all amounts on SSA financial actual data reported by the fiscal agent district should equal the total of all expenditures (6XXX) reported on their actual financial data, excluding the object codes "payments to fiscal agents of SSAs" (6492) and "payments to member districts of SSAs" (6493).
S 2 Y Y Y