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 [2018/11/27 21:17] 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//\\  \\   
-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]]\\  \\   
- 
-<WRAP box>**IMPORTANT:** Back up your database before extracting data.</WRAP> 
-</WRAP> 
- 
- 
-====Extract data:==== 
- 
-^Method|{{page>general:interchangefinanceextension_method_midyear}}| 
-^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 State Reporting tables. 
- 
-<WRAP box>Data can be re-extracted, but you will overwrite any existing data in the frozen files when you save, unless you select **Add New** under **Method** when re-extracting data.</WRAP> 
- 
- 
----- 
- 
-^Print|++View the report.| {{page>general:print&inline}} ++| 
-^Error|++If errors are encountered, view the error report.| {{page>general:print&inline}} ++| 
- 
- 
- 
  
extracts/midyear.1543353469.txt.gz · Last modified: 2018/11/27 16:17 (external edit)