State Reporting

User Tools

Site Tools

Trace: • midyear_import • midyear_extracts
academy:midyear_extracts

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
academy:midyear_extracts [2019/11/15 16:27] – jstanfordacademy:midyear_extracts [2021/12/10 19:48] (current) – apape
Line 2: Line 2:
 [[extracts:midyear|State Reporting > Extracts > Midyear]]\\  \\   [[extracts:midyear|State Reporting > Extracts > Midyear]]\\  \\  
 <WRAP round intro>The Midyear 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.</WRAP> <WRAP round intro>The Midyear 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.</WRAP>
 +
 \\   \\  
-<WRAP box>**CAUTION:** Each time you extract data, you overwrite the data in the frozen files (i.e., State Reporting maintenance pages), including any data that was manually entered.</WRAP> +<WRAP box>**CAUTION:** Each time you extract data using the **Delete ALL** and **Add** options, you overwrite the data in the frozen files (i.e., the State Reporting maintenance pages), including any data that was manually entered. If you extract multiple times, make sure to select one of the options to Add New records. It is recommended that all extracts are completed before making changes to the frozen file.</WRAP> 
-\\  \\ +\\  
-{{:images:screenshots:extracts_midyear.png|Midyear extract with selected fields highlighted}} +{{:images:screenshots:midyear_data_extract.png|Mid-Year Data Extract}} 
-\\  \\  +\\ \\
 ^Method|{{page>general:interchangefinanceextension_method_midyear}}| ^Method|{{page>general:interchangefinanceextension_method_midyear}}|
 ^Year 1\\  Year 2|{{page>general:interchangefinanceextension_year}}| ^Year 1\\  Year 2|{{page>general:interchangefinanceextension_year}}|
Line 13: Line 14:
 VCV Click **Run**.\\  \\   VCV Click **Run**.\\  \\  
 <div indent> <div indent>
-{{:images:screenshots:extracts_midyear_complete.png|Extract is complete message}}\\  \\   
 </div> </div>
 ^Print|++View the report.| {{page>general:print&inline}} ++| ^Print|++View the report.| {{page>general:print&inline}} ++|
Line 21: Line 21:
 VCV On the extract page, click **Save**.\\  \\   VCV On the extract page, click **Save**.\\  \\  
 <div indent> <div indent>
-<WRAP box>**CAUTION:** You must click **Save** to add the budget data to the frozen files. If you do not click **Save**, you will need to re-extract the data.</WRAP>+<WRAP box>**CAUTION:** You must click **Save** to add the data to the frozen files. If you do not click **Save**, you will need to re-extract the data.</WRAP>
 \\   \\  
 The “Finance records were successfully written to TSDS” message is displayed.\\  \\   The “Finance records were successfully written to TSDS” message is displayed.\\  \\  
-{{:images:screenshots:extracts_midyear_saved.png|Finance records successfully written message}} + 
-\\  \\   +<WRAP box>**NOTE:** Data can be re-extracted, but you will overwrite any existing data in the frozen files when you click **Save**, unless you select **Add New under Method** when re-extracting data 
-<WRAP box>**NOTE:** Data can be re-extracted, but you will overwrite any existing data in the frozen files when you click **Save**, unless you select **Add New under Method** when re-extracting data.</WRAP>+</WRAP>
  
 </div> </div>
Line 33: Line 33:
  
 <div indent> <div indent>
-  * Repeat the extract for class 3xxx data only. +  * If needed, repeat the extract for class 3xxx data only.\\  
-  * Go to [[maintenance:midyear:finance|State Reporting > Maintenance > Finance Actual]] where you can manually enter ending fund balances (3xxx) into frozen as reflected on schedule C-1 of the audit. The totals should match the audit report.+ 
 +{{:images:screenshots:midyear_repeat_extract1.png|Setting parameters for Class 3 extract}}\\ 
 + 
 +{{:images:screenshots:midyear_repeat_extract1_report.png|Setting parameters for Class 3 extract report}} 
 +  * Or go to [[maintenance:midyear:finance|State Reporting > Maintenance > Finance Actual]] where you can manually enter ending fund balances (3xxx) into frozen as reflected on schedule C-1 of the audit. The totals should match the audit report.\\ 
 + 
 +{{:images:screenshots:midyear_repeat_extract2.png|Manually entering ending fund balances}} 
 +\\ 
 +<div indent><WRAP Box>**NOTE**: Fund Balances should be entered with the opposite sign as displayed in Finance. For example, if the balance is -2,9750,000 in Finance, enter as 2,9750,000 in State Reporting. The extract automatically makes the change. 
 +</WRAP> 
 +</div> 
 +</div> 
 +\\  \\   
 +VCV Run the extract a second time to add the remaining data. 
 +<div indent> 
 +</div> 
 +\\ 
 +VCV Click **Run**.  
 +\\  \\ 
 +VCV Click **Print** to review the data. 
 +\\  \\ 
 +VCV Click **Save** to add the records to the “frozen file” in State Reporting.  
 + 
 +<div indent>The report will only show the records defined in this extract. You can view complete data on the [[maintenance:midyear:finance|State Reporting > Maintenance > Mid Year > Finance Actual]]. 
 +</div> 
 +\\ 
 + 
 +<WRAP Box>**NOTE**: You may run the extract a third time if you want to bring over the fund balance accounts. 
 +</WRAP>  
 +<div indent>
 </div> </div>
academy/midyear_extracts.1573835269.txt.gz · Last modified: 2019/11/15 11:27 (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.