Sidebar
general:fallpeimsbusiness_financedomain_crosswalks
This is an old revision of the document!
Add crosswalks
Finance > Tables > TSDS Crosswalks
Map financial data from the LEA's set of accounts to TEA's Chart of Accounts for both the current and previous file IDs.
- Verify the TSDS crosswalks are correct.
- Verify that there are not crosswalks for the automatic crosswalks processed by ASCENDER.
- Review the Automatic Crosswalks section on the Finance TSDS Crosswalk Tables page.
- If a crosswalk is created on this page, it will be used and applied throughout the TSDS reporting process.
- Automatic crosswalks are applied AFTER crosswalks created on this page are applied.
As an example, a one-campus LEA that budgets and books expenditure records to campuses 101 and 001 should establish a crosswalk to move expenditures from Organization code 101 to Organization code 001.
TIP: When performing a crosswalk, note that it transfers all items from the old to the new. For example, if using 060 Actual – Fund to Fund and you move Fund 255 to 211, all line items from Fund 255 will be moved to Fund 211, not just a specific line item.
District Administration > Tables > District Information > Fall Finance TSDS Data
This tab is used to retrieve and edit Fall TSDS financial data, allowing for corrections to Budget and Payroll data in the TSDS staging tables. The staging area temporarily holds data before it is submitted to the Texas Education Agency (TEA) (i.e., promoted to the Operational Data Store (ODS)).
The data on this tab is obtained from the latest Fall extracts after period 10 is closed, incorporating all TSDS crosswalks, automatic crosswalks, and data summaries. Accounts are summarized by fund, function, object class (6100), organization, and program intent code. For instance, 199-11-6119.00-001-511000 will display as 199 11 6100 001 11. Users should cross-reference balances with the Finance application and may need to combine amounts to ensure accurate budget reporting.
Notes:
- This tab becomes available for editing the day after accounting period 10 is closed in Finance.
- Data cannot be duplicated. Duplicated data will receive an error upon submission.
- Enter data carefully on this tab. Incorrect or improperly formatted data may cause errors upon submission.
1 - Budget
general/fallpeimsbusiness_financedomain_crosswalks.1759866522.txt.gz · Last modified: 2025/10/07 19:48 by emoreno