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 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
Field Validation 20033-000A
The combination of the following fields must be unique for each Shared Services Arrangement Actual Financial data: DISTRICT-ID, SHARED-SVCS-ARR-MEMBER-DIST-ID, SHARED-SVCS-ARRANGEMT-TYPE-CODE, FUND-CODE, and FISCAL-YEAR.

The combination of the following fields must be unique for each Shared Services Arrangement Actual Financial data: StateOrganizationId (TX-FiscalAgentEducationOrganizationReference), StateOrganizationId (TX-SharedSvcsArrMemberLEAReference), TX-SharedServiceArrangement, TX-FundCode, and TX-FiscalYear.
F 2 Y Y Y
Field Validation 20033-000B
For Shared Services Arrangement Actual Financial data, the following must be provided: DISTRICT-ID, SHARED-SVCS-ARR-MEMBER-DIST-ID, SHARED-SVCS-ARRANGEMT-TYPE-CODE, FUND-CODE, FISCAL-YEAR, and ACTUAL-AMOUNT.

For Shared Services Arrangement Actual Financial data, the following must be provided: StateOrganizationId (TX-FiscalAgentEducationOrganizationReference), StateOrganizationId (TX-SharedSvcsArrMemberLEAReference), TX-SharedServiceArrangement, TX-FundCode, TX-FiscalYear, and TX-Amount.
F 2 Y Y Y