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 [2019/12/19 14:46] 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}}| 
- 
-VCV Click **Run** to extract the selected records.<div indent>A message is displayed indicating that the extract is complete.</div>\\  \\   
-VCV Click **Save** to write the records to State Reporting tables. 
-<div indent> 
-<WRAP box>**NOTE:** 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> 
-</div> 
- 
----- 
- 
-^Print|++View the report.| {{page>general:print&inline}} ++| 
-^:::|test| 
-^Error|++If errors are encountered, view the error report.| {{page>general:print&inline}} ++| 
- 
- 
- 
  
extracts/midyear.1576766774.txt.gz · Last modified: 2019/12/19 09:46 (external edit)