State Reporting

User Tools

Site Tools

Trace:

Sidebar

Table of Contents

extracts:fall:finance

This is an old revision of the document!

Finance Budget

TSDS > 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:

FieldDescription
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.

Add Class 3 Only

Select to extract class 3 equity accounts.

Add Class 3 Only - Omit Budget Fund Codes

Select if you are extracting class 3xxx.

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.

The “Extract is complete” message is displayed once the extract is complete.

Click Print to view the report


Review the report using the following buttons:

Click to go to the first page of the report.
Click Previous Page Icon to go back one page.
Click Next Page Icon to go forward one page.
Click Last Page Icon to go to the last page of the report.

The report can be viewed and saved in various file formats.

Click PDF Icon to save and print the report in PDF format.
Click CSV Icon to save and print the report in CSV format. (This option is not available for all reports.) When a report is exported to the CSV format, the report headers may not be included.
Click Close Button to close the report window. Some reports may have a Close Report, Exit, or Cancel button instead.

Review the accuracy of the budget data. Finance budget codes are listed on the left, and the collapsed PEIMS records are listed on the right.

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

Click Save to write records to TSDS..

extracts/fall/finance.1485896823.txt.gz · Last modified: 2017/01/31 16:07 (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.