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 040 Budget - From Org to Org and you move Org 101 to Org 001, all line items from Organization code 101 will be moved to Organization code 001, 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.
❏ Click 
to select 1 - Budget.
❏ In the Unique Staff ID field, type the 10-digit unique staff ID assigned to the staff member by the Texas Education Agency and click Retrieve.
❏ Make any necessary budget corrections (such as code or amount changes) to the Budget data in the TSDS staging tables.
❏ Click Save.
Notes:
Budget Data with an ODS ID
- To delete a previously submitted record, set its amount to zero and insert a new record with the correct data. This will mark the record for deletion and resubmission.
- Account codes (rows) are validated to prevent duplicate records.
| Change | Original Record | New Record |
|---|---|---|
| Account Code or Begin Date | Status = R - Resubmit, Action = D - Delete | Status = N – New, Action = I - Insert |
| Amount or End Date | Status = R - Resubmit, Action = U – Update | |
| Amount = 0 (zero) | Status = R – Resubmit, Action = D - Delete |
Records without an ODS ID
- Changes will not affect the Status or Action (Status = N - New, Action = I - Insert).
general/fallpeimsbusiness_financedomain_crosswalks.1761850204.txt.gz · Last modified: 2025/10/30 18:50 by emoreno