State Reporting

User Tools

Site Tools

Trace: • Finance Budget Fall Extract

Sidebar

Table of Contents

extracts:fall:finance
Book Creator
 Add this page to your book
Book Creator
 Remove this page from your book  

 Manage book(0 page(s))
 Help

Finance Budget Fall Extract

State Reporting > Extracts > Fall > Finance Budget

Data Extracted: InterchangeFinanceExtension

This page extracts 12 months of budget data.

IMPORTANT: Back up your database before extracting data.

Extract data:

Method
Delete ALL and Add

(Recommended) Select to delete all existing data for this fiscal year from the State Reporting tables before extracting and adding new data to the State Reporting tables.

Add New

Select if you are re-extracting data. This option adds data to the State Reporting tables.

CAUTION: If any Finance data exists in the State Reporting tables for this fiscal year; there is a risk of duplicating data if this option is selected.

Year 1
Year 2
File IDType the file ID for the prior year according to your district's naming convention for prior year file IDs. This is maintained on ASCENDER Finance > Tables > District Finance Options.

For the specified File ID, all audit entries must be posted, and revenue and expense balances must be reconciled to the audit report.
Acct Period
Thru

Select the ending accounting period. The number corresponds to the month in which the fiscal year ends (e.g., 8 for August).

Fiscal Year

Select the ending year of the fiscal year.

For example, for the 2021-2022 school year, select 2. See Year 2 below:

Leave the Year 2 fields blank unless you have 5xxx-8xxx records for multiple fiscal years in the same File ID.

Year 2 automatically increments the fiscal year by 1 from the Fiscal Year field in the Year 1 field above.

Extracting Multiple Fiscal Year Data Example

Crosswalk Options

Select Replace 00 in 6XXX with 99.

Select Crosswalk 046 if locally defined funds exist in your budget/finance.

Select any other crosswalk tables you are using. The crosswalk tables must be built prior to running the extract.

Crosswalk 049

Select to omit a specific fund from the fall submission.

Crosswalk 045

Select to convert a specific fund/subobject combination to a program code.

Crosswalk 046

Select to convert one fund code to another fund code.

Crosswalk 047

Select to convert one object code to another object code.

Crosswalk 048

Select to convert one function code to another function code.

Crosswalk 055

Select to convert a specific fund/function/subobject combination to a program code.

Crosswalk 056

Select to convert a specific fund code to a program code.

Crosswalk 069

Select to convert a specific fund/program combination to a program code.

Crosswalk 040

Select to convert one organization code to another organization code.

Replace 00 in 6XXX with 99

Select to replace program intent codes 00 in 6XXX with 99, provided the function code is not equal to 11.

❏ Click Run to extract the selected records.

A message is displayed indicating that the extract is complete.



❏ Click Save to write the records to ASCENDER State Reporting tables.

IMPORTANT! You must click Save to add the budget data to State Reporting. If you do not click Save, you will need to re-extract the data.




PrintView the report.

WARNING! If you navigate away from the extract page, the Print button will no longer be available.


NOTE: Data can be re-extracted, but you will overwrite any existing data in State Reporting when you click Save, unless you select Add New under Method when re-extracting data.

extracts/fall/finance.txt · Last modified: 2020/07/15 07:43 by 127.0.0.1

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.