State Reporting

User Tools

Site Tools

Trace: • Mid Year Extract

Sidebar

Table of Contents

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

 Manage book(0 page(s))
 Help

Mid Year Extract

State Reporting > Extracts > Mid Year

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.

Each time you extract data, you overwrite the data in the frozen files (i.e., maintenance pages), including any data that was manually entered.

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.

Select this option, if you are extracting classes 5xxx-8xxx for the first time.
Add NewSelect to add new data to State Reporting tables without affecting previously extracted data.

If you need to extract 5xxx-8xxx for a fiscal year not included in a previous extract, select this option after you do the first extract using the above option.
Add Class 3 onlySelect to add records for all object class 3xxx accounts only. This option will overwrite any existing data for class 3xxx only.
Add Class 3 Only - Omit Budget Fund CodesSelect to extract class 3xxx records only. This option will exclude any accounts with a 3xxx object code identified as a Budget Fund Balance Obj from the Finance > Tables > Account Codes > Fund tab (e.g., 3700).
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

First Year

Select if you are changing the fiscal year start date. You must enter a file ID and beginning and ending accounting periods for both fiscal years. Like funds will be combined into fiscal year 1.

Crosswalk Options

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

Crosswalk 067

Select to omit a fund from the PEIMS submission.

Crosswalk 059

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

Crosswalk 060

Select to convert a fund code to another fund code.

Crosswalk 062

Select to convert an object code to another object code.

Crosswalk 064

Select to convert a function code to another function code.

Crosswalk 066

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

Crosswalk 063

Select to convert a fund code to a program code.

Crosswalk 070

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

Crosswalk 061

Select to convert an organization code to another organization code.

Replace 00 in 6XXX with 99

Select to replace program intent codes 00 in 6XXX with 99, when the function code is not 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 State Reporting tables.

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.

Other functions and features:

PrintView the report.
ErrorIf errors are encountered, view the error report.
extracts/midyear.txt · Last modified: 2022/08/17 15:55 by apape

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.