State Reporting

User Tools

Site Tools

Trace:
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/02/06 19:37] – jstanfordextracts:midyear [2022/08/17 15:55] (current) – apape
Line 1: Line 1:
 +{{indexmenu_n>20}}
 ======Mid Year Extract====== ======Mid Year Extract======
  
-//**TSDS > Extracts > Mid Year**//+//**State Reporting > Extracts > Mid Year**//
  
-<WRAP round intro>Data extracted: //InterchangeFinanceExtension// +<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.\\  \\   
-The Midyear Actual Extract page extracts data for the ActualExtension interchange. The extract +Each time you extract data, you overwrite the data in the frozen files (i.e., maintenance pages), including any data that was manually entered.\\  \\   
-may need to be run multiple times, once to extract revenues and expenditures, and again to +/* 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]]\\  \\   
-extract fund balances. If there are accounts with multiple fiscal years in the file ID, multiple +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]] */
-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]]+
  
 <WRAP box>**IMPORTANT:** Back up your database before extracting data.</WRAP> <WRAP box>**IMPORTANT:** Back up your database before extracting data.</WRAP>
Line 19: Line 15:
  
 ====Extract data:==== ====Extract data:====
-^Field^Description^ + 
-^Method|{{page>general:interchangefinanceextension_method}}|+^Method|{{page>general:interchangefinanceextension_method_midyear}}|
 ^Year 1\\  Year 2|{{page>general:interchangefinanceextension_year}}| ^Year 1\\  Year 2|{{page>general:interchangefinanceextension_year}}|
 ^First Year|{{page>general:midyear_first_year_of_fiscal_year_change}}| ^First Year|{{page>general:midyear_first_year_of_fiscal_year_change}}|
 ^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 TSDS.+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 PEIMS frozen files when you save, unless you select **Add New** under **Method** when re-extracting data.</WRAP> 
-  
 ====Other functions and features:==== ====Other functions and features:====
  
extracts/midyear.1486409845.txt.gz · Last modified: 2017/02/06 14:37 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

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.