Related Topics

F-195/F-200 Budget File Extract & Extension

Contents

1 Overview

2 Account Codes Structure

3 Title Page with Parameters

4 Extract Summary Report

5 Extract File Listing

6 How-to

7 Extract Fields

8 User Tips

9 Selection Criteria

10 Tables Diagram

 

9 Selection Criteria

The following criteria are used by the program to select data for the F-195 report.

Important: Three validations must be complete before the report can be run successfully. Each must have a value of "yes".

  1. Select the Fiscal Year. (FFAMFA-FIS-YTD.FFAMDB-FIS-YEAR)

  2. Select the fund(s). Display all fund codes that have a crosswalk description. (Display FFAMAD-ACCT-DESC.FFAMAD-CODE when FFASDC-IND = "fund" AND FFAMAD-ACCT-DESC.FFAMAD-XWALK is not equal to blank.)

  3. Determine the dimension number that stores account type. (SYS-FFASAD-ACCT-MST.FFAMSAM-POS-TYPE when SYS-FFASAM-ACCT-MST.FFAACT-SYS-CODE = "WA01")

  4. Determine the dimension number that stores fund. (SYS-FFASAD-ACCT-MST.FFASAM-POS-FUND when SYS-FFASAM-ACCT-MST.FFAACT-SYS-CODE = "WA01")

  5. Generate a list of accounts from the year to date account table that matches the fiscal year selected. (FFAFMAFA-FIS-YTD.FFAMFA-FIS-YEAR = "selected")

  6. Budget Dollars to report. (FFAMFA-FIS-YTD): For each account, add dollars from the original, revision, and transfers fields to get the account’s budget value after revisions and transfers. (FFAMFA-FIS-YTD.FFAMFA-ORG-BUDGET+ FFAM-FIS-YTD.FFAMFA-REVISIONS+ FFAMFA-FIS-YTD.FFAMFA-TRANSFERS)

  1. Expenditure data for Fund 2 will not be included. Fund 2 expenditures have to do with projects. OSPI does not assign project numbers, and expects districts to manually enter projects into the 1SPI system. The projects are assigned a sequential number in that system and the dollar values are written out as an "item number" account type.

    1. Identify Fund 2 accounts in the detail budget table, identified with account IDs: If FFXWAN-XWALK-ACCT-NBR.FFXWAN-XWALK-ACCT-DIM [Type] = "2" and FFXWAN-XWALK-ACCT-NBR.FFXWAN-XWALK-ACCT-DIM [Fund]  begins "2", do not include the account in the F-195 Budget File Extract.

    2. Determine the dimension number of the account code that stores the account type.

    3. Filter out Fund 2 accounts that are expense types.

  3. Objects 2 and 3 are not included in the F-195 BUD SPI extract file.

  1. Determine the dimension number of the account code that stores the object. (SYS-FFASAM-ACCT-MST.FFAMSAM-POS-OBJ when SYS-FFASAM-ACCT-MST.FFAACT-SYS-CODE = "FFAACT-CONTROL-FILE.FFAACT-SYS-CODE")

  2. Filter out accounts that include objects 2 and 3 from the accounts in the detail budget table listing account IDs.

  1. Equity type accounts must report beginning and ending balances in the extract file. A unique item number exists for the account’s estimated beginning and ending balances.

    1. The beginning balance is stored in the database. (FFAMFA-FIS-YTD.FFAMFA-ORG-BUDGET + FFAMFA-FIS-YTD.FFAMFA-REVISIONS + FFAMFA-FIS-YTD.FFAMFA-TRANSFERS)

    2. Theending balance must be calculated. For all accounts that summarize the qualifying equity account, add all revenue budget balances and subtract all expense budget balances from the beginning balance. A qualifying equity account is an account that is an equity type, is part of a valid reporting fund, and has an item number for beginning and ending balances. (The calculation of the estimated ending balance includes accounts where FFAMAM-ACCT-MST.FFAMSA-CODE = qualifying equity account.)

  3. Negative amounts:

    1. Summary by F-195 reporting number: Budget dollar amounts are entered by the user by account code. Positive or negative dollar amounts may be entered for each individual budget account code in legacy and Skyward. The account codes are then summarized based upon F-195 reporting number. The reporting number represents a record in the F-195 extract file. The reporting number can be an item number, revenue code, or program-activity-object combination. A positive dollar amount should result.

    2. F-195 1SPI Application: The 1SPI application uses the F-195 extract file as input into its system. This system does not accept any records with a negative value. If a negative value is encountered, an error is generated and the record is rejected.

    3. Object 1 Credit Transfer summation records: F-195 records that represent object 1 Credit Transfers are inherently negative values. The F-195 1SPI application expects these values to be positive, and changes them to positive values by multiplying by negative 1.  

    4. Summation records that are not Credit Transfers (not object 1): F-195 extract file records that are not object 1 Credit Transfers may be summarized and need to be reported as a negative value. In the legacy application, these records are currently multiplied by a negative 1 and forced to be reported as positive. To the best of our knowledge, this is only done to accommodate the 1SPI application. By multiplying these values by negative 1 they may be being reported inaccurately.  

  5. Account Code to report: Update the list of accounts with the SPI account code value based upon the account’s fund and account type with information in the Washington State table. Positions of the account code are repeated based upon records in the State Account Dimensions (WA001SysStRptDim) table.

    1. Expense type accounts include the PPAAO – Program, Activity, Object (x5) values of the account code. The actual dimensions reported are different based upon fund type and not all accounts will have each dimension (program, activity, and object).

    2. Revenue type accounts include the RRRR – Revenue (x4) values of the account code.  The actual dimensions reported are different based upon fund type. For example, ASB fund has a dimension called "club" that is reported.

    3. All other or Misc. Items accounts include the OSPI Item number (x3). The OSPI Item number resides in the State Item Values (WA001SysSpiItem) table.

  7. SPI Item numbers:  For each fund, identify the accounts that qualify for reporting by SPI Item number. The information in the State Item Values (WA001SysSpiItem) table describes which accounts require an Item number.

    1. WA0001SysSpiItm.SpiItmFisYear = selected fiscal year.

    2. WA0001SysSpiItm.SpiItmFundType = first position of account code dimension FFXWAN-XWALK-ACCT-NBR.XWALK-ACCT-DIM[Fund].

    3. WA0001SysSpiItm.SpiItmBud = Budget value description. Included values are "B", "E", or "N". If the value is an "E", an estimated ending balance value needs to be calculated for that fund.

    4. WA0001SysSpiItm.SpiItmItemSrc = Item Source. Values represent General Ledger accounts, Clubs, Programs, and others.

    5. WA0001SysSpiItm.SpiItmF195Itm= Item Number. This extract file value represents budget dollars for the fund type and account code matching the other fields in the Item table.

    6. Report budget dollars, summarized by account code, included in the extract file.

Page Updated 4/04

Top