Contents
|
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.
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:
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.
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.
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.
At the end of the process, all account description records have been read and evaluated.
A Missing Crosswalk Values report is created for the selected fiscal year.
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:
Account Descriptions (FFXWVC-VALIDATION-CONTROL.FFXWVC-VALID-DESC-X) = "Yes" for Valid Descriptions.
Account Codes (FFXWVC-VALIDATION-CONTROL.FFXWVC-VALID-ACCT-X) = "No" for Valid Account Codes.
Account Grids (FFXWVC-VALIDATION-CONTROL.FFXWVC-VALID-GRID-X) = "No" for Valid Account Grids.
Records included in the report do not have valid state equivalents. All three validations are set as incomplete:
Account Descriptions (FFXWVC-VALIDATION-CONTROL.FFXWVC-VALID-DESC-X) = "No" for Valid Descriptions.
Account Codes (FFXWVC-VALIDATION-CONTROL.FFXWVC-VALID-ACCT-X) = "No" for Valid Account Codes.
Account Grids (FFXWVC-VALIDATION-CONTROL.FFXWVC-VALID-GRID-X) = "No" for Valid Account Grids.
Page Updated 7/03