|
|
|
|
|
|
|
Contents
|
The F-195 process accesses the following tables and fields in creating the extract report:
|
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-FFASAM-ACCT-MST.FFASAM-POS-FUND when SYS-FFASAM-ACCT-MST.FFAACT-SYS-CODE = "FFAACT-CONTROL-FILE.FFAACT-SYS-CODE"] |
|
|
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 |
11 |
5 |
RRRR (Revenue) select the dimension numbers based upon information in the WA001SysStRptDim table: FFXWAN-XWALK-ACCT-NBR.FFXWAN-XWALK-ACCT-DIM[ ] |
|
|
Misc. Items |
11 |
3 |
Item Number assigned by OSPI |
|
|
Dollar Value |
16 |
11 |
F-195 values must be shifted 2 places to the left. A hexadecimal symbol will appear in the last position of the dollar amount: FFAMFA-FIS-YTD.FFAMFA-ORG-BUDGET + FFAMFA-FIS-YTD.REVISIONS + FFAMFA-FIS-YTD.TRANSFERS |
|
Page Updated 4/04