This is an old revision of the document!
State Reporting > Extracts > Mid Year
Data extracted: InterchangeFinanceExtension
This page extracts data for the ActualExtension interchange. The extract may need to be run multiple times, once to extract revenues and expenditures, and again to extract fund balances. If there are accounts with multiple fiscal years in the file ID, multiple extracts may be needed.
Each time you extract data, you overwrite the data in the frozen files (i.e., maintenance pages), including any data that was manually entered.
For a complete list of extract rules and edits for 2016-2017, see http://castro.tea.state.tx.us/tsds/teds/2017A/ds8/teds-peims-ds8.5.pdf
For a complete list of extract rules and validations for 2017-2018, see http://castro.tea.state.tx.us/tsds/teds/2018A/teds-ds5.pdf
IMPORTANT: Back up your database before extracting data.
Field | Description | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Method |
|
||||||||||||||||||||
Year 1 Year 2 |
Leave the Year 2 fields blank unless you have 5xxx-8xxx records for multiple fiscal years in the same File ID.
Year 2 automatically increments the fiscal year by 1 from the Fiscal Year field in the Year 1 field above.
|
||||||||||||||||||||
First Year |
Select if you are changing the fiscal year start date. You must enter a file ID and beginning and ending accounting periods for both fiscal years. Like funds will be combined into fiscal year 1. |
||||||||||||||||||||
Crosswalk Options |
Select any crosswalk tables you are using. The crosswalk tables must be built prior to running the extract.
|
Data can be re-extracted, but you will overwrite any existing data in the PEIMS frozen files when you save, unless you select Add New under Method when re-extracting data.
View the report.
|
|
Error | If errors are encountered, view the error report.
|
The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.