(OBSOLETE) Mid Year Extract

This extract was removed 6/25/24 with release 8.1100, AMP-9071 as TSDS sunsets.

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.