User Tools

Site Tools


extracts:midyear

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
extracts:midyear [2017/10/25 13:18] jstanfordextracts:midyear [2024/06/25 13:53] (current) – removed apape
Line 1: Line 1:
-{{indexmenu_n>20}} 
-======Mid Year Extract====== 
- 
-//**State Reporting > Extracts > Mid Year**// 
- 
-<WRAP round intro>Data extracted: //InterchangeFinanceExtension// 
- 
-The Midyear Actual Extract 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., PEIMS 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]] 
- 
-<WRAP box>**IMPORTANT:** Back up your database before extracting data.</WRAP> 
-</WRAP> 
- 
- 
-====Extract data:==== 
-^Field^Description^ 
-^Method|{{page>general:interchangefinanceextension_method}}| 
-^Year 1\\  Year 2|{{page>general:interchangefinanceextension_year}}| 
-^First Year|{{page>general:midyear_first_year_of_fiscal_year_change}}| 
-^Crosswalk Options|{{page>general:interchangefinanceextension_midyear_crosswalk_options}}| 
- 
-  * Click **Run** to extract the selected records. A message is displayed indicating that the extract is complete. 
-  * Click **Save** to write the records to TSDS. 
- 
-<WRAP box>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.</WRAP> 
-  
-====Other functions and features:==== 
- 
-^Print|++View the report.| {{page>general:print&inline}} ++| 
-^Error|++If errors are encountered, view the error report.| {{page>general:print&inline}} ++| 
- 
- 
- 
  
extracts/midyear.1508937517.txt.gz · Last modified: 2017/10/25 08:18 (external edit)