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 [2022/08/17 15:55] (current) apape
Line 7: Line 7:
 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.\\  \\   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.\\  \\   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 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]]\\  \\  +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 box>**IMPORTANT:** Back up your database before extracting data.</WRAP>
Line 21: Line 21:
 ^Crosswalk Options|{{page>general:interchangefinanceextension_midyear_crosswalk_options}}| ^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. +VCV Click **Run** to extract the selected records.<div indent>A message is displayed indicating that the extract is complete.</div>\\  \\   
-  Click **Save** to write the records to State Reporting tables.+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>
  
-<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>+----
  
- +====Other functions and features:====
-----+
  
 ^Print|++View the report.| {{page>general:print&inline}} ++| ^Print|++View the report.| {{page>general:print&inline}} ++|
extracts/midyear.1543353469.txt.gz · Last modified: 2018/11/27 16:17 (external edit)