F-196 Year-End Extract for OSPI

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 Selection Criteria

9 Tables Diagram

Field Name

Starting Position

Length

Path to data field

Field ID

ESD Number

1

3

System Admin / System / Dist Config / WA ESD

DISTRICT-CONFIG.SESD-CODE

County Number

4

2

Positions 1-2: System Admin / System / Dist Config /District Code

DISTRICT-CONFIG.DISTRICT-CODE

District Number

6

3

Positions 3-5: System Admin / System / Dist Config /District Code

DISTRICT-CONFIG.DISTRICT-CODE

Data Source

Type

9

1

Must be "F" for fund

Fund

10

1

First position must equal 1, 2, 3, 4, or 9: FFXWAN-XWALK-ACCT-NBR.FFXWAN-XWALK-ACCT-DIM[SYS-FFASAD-ACCT-DTL.FFASAD-DIM-NBR when SYS-FFASAD-ACCT-DTL.FFASAD-FUND-CODE = yes]

Item Number

11

5

3-5 characters

Expenditure

11

5

PPAAO (Program, Activity, Object) select the dimension numbers based upon information in the WA001SysStRptDim table: FFXWAN-XWALK-ACCT-NBR.FFXWAN-XWALK-ACCT-DIM[ ]

Revenue

12

5

RRRR (Revenue) select the dimension numbers based upon information in the WA001SysStRptDim table: FFXWAN-XWALK-ACCT-NBR.FFXWAN-XWALK-ACCT-DIM[ ]

Misc. Items

13

3

Item Number assigned by OSPI

Dollar Value

16

11

 F-196 values must be shifted 2 places to the left. A hexadecimal symbol will appear in the last position of the dollar amount. Add the following accounts for each account ID by account type as follows: Type A & E &endash; FFAMFA-FIS-YTD.FFAMFA-BEG-BALANCE plus FFAMFA-FIS-YTD.FFAMFA-AMT-DEBIT minus FFAMFA-FIS-YTD.FFAMFA-AMT-CREDIT.  TYPE L & Q & R &endash; FFAMFA-FIS-YTD.FFAMFA-BEG-BALANCE plus FFAMFA-FIS-YTD.FFAMFA-AMT- CREDIT minus FFAMFA-FIS-YTD.FFAMFA-AMT- DEBIT.