Related Topics

Create Crosswalk Descriptions

Contents

1 Overview

2 Exception Report

3 How-to

4 Selection Criteria

5 Tables Diagram

 

4 Selection Criteria

  1. Select records from the district's account dimension table that are required for state reporting. Records that are required for state reporting must represent a state-reportable fund. Accounts reportable to OSPI include nine specific dimensions.

  2. If the account description requires a crosswalk, attempt to create a crosswalk description record. A record can be created if the reportable positions of the account description have state equivalent values. Three possible circumstances exist:

    1. If the record has an Account Indicator value (FFAMAD-ACCT-DESCS.FFASDC-IND) equal to "A03" for "General Ledger", the program finds and enters a state-equivalent crosswalk value.

    2. If the record has an Account Indicator value (FFAMAD-ACCT-DESCS.FFASDC-IND) equal to "A01" for "Fund", the program attempts to find and enter a state-equivalent crosswalk value.

    3. If the record has an Account Indicator value (FFAMAD-ACCT-DESCS.FFASDC-IND) of something other than "A03" or "A01", the program uses a Washington table to compare specific positions of the code, attempting to find a state-equivalent crosswalk value.

  1. At the end of the process, all account description records have been read and evaluated.

  2. A Missing Crosswalk Values report is created for the selected fiscal year.

    1. If there are no records to include on the report, all crosswalk descriptions have a valid state equivalent. The first validation is considered complete, and the last two are incomplete:

      1. Account Descriptions (FFXWVC-VALIDATION-CONTROL.FFXWVC-VALID-DESC-X) = "Yes" for Valid Descriptions.

      2. Account Codes (FFXWVC-VALIDATION-CONTROL.FFXWVC-VALID-ACCT-X) = "No" for Valid Account Codes.

      3. Account Grids (FFXWVC-VALIDATION-CONTROL.FFXWVC-VALID-GRID-X) = "No" for Valid Account Grids.

    2. Records included in the report do not have valid state equivalents. All three validations are set as incomplete:

      1. Account Descriptions (FFXWVC-VALIDATION-CONTROL.FFXWVC-VALID-DESC-X) = "No" for Valid Descriptions.

      2. Account Codes (FFXWVC-VALIDATION-CONTROL.FFXWVC-VALID-ACCT-X) = "No" for Valid Account Codes.

      3. Account Grids (FFXWVC-VALIDATION-CONTROL.FFXWVC-VALID-GRID-X) = "No" for Valid Account Grids.

Page Updated 7/03

Top