F2_MAF_TBL

(SQL Table)
Index Back

FACTS II MAF

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 F2_MAF_TSYMBOL Character(18) VARCHAR2(18) NOT NULL MAF Treasury Symbol
2 MAF_SEQ_NUM Number(3,0) SMALLINT NOT NULL MAF Sequence Number
3 RECORD_TYPE_7 Character(15) VARCHAR2(15) NOT NULL Record Type 7 TAS
4 DEPT_REGULAR Character(2) VARCHAR2(2) NOT NULL Dept Regular - TAS
5 DEPT_TRANSFER Character(2) VARCHAR2(2) NOT NULL Department Transfer - TAS
6 FISCAL_YR_TAS Character(4) VARCHAR2(4) NOT NULL Fiscal Year TAS
7 MAIN_ACCOUNT Character(4) VARCHAR2(4) NOT NULL Main Account TAS
8 SUB_ACCOUNT Character(3) VARCHAR2(3) NOT NULL Sub Account TAS
9 ACCT_SPLIT_SEQ_NUM Number(3,0) SMALLINT NOT NULL Account Split Seq Number
10 MASTER_PREPARE_IND Character(1) VARCHAR2(1) NOT NULL Master Preparer Ind
11 ACCT_SPLIT_ALL_IND Character(1) VARCHAR2(1) NOT NULL Acct Split Alloc Ind
12 PREPARER_ID Character(8) VARCHAR2(8) NOT NULL Preparer Identification

Prompt Table: F2_CONTACT_INFO

13 PRE_CLOSE_BALANCE Signed Number(28,3) DECIMAL(26,3) NOT NULL Pre-closing Balance
14 F2_NET_OUTLAYS Signed Number(28,3) DECIMAL(26,3) NOT NULL 03/15/2002 - WDR_FACTSII - For JFMIP Testing - Added to contain Net Outlays, to date, as reported by the Treasury.
15 CHAPTER Character(2) VARCHAR2(2) NOT NULL Chapter
16 GOALS_FLAG Character(1) VARCHAR2(1) NOT NULL GOALS Flag
17 APPROP_FLAG Character(1) VARCHAR2(1) NOT NULL Appropriation Flag
18 CERTIFY_FLAG Character(1) VARCHAR2(1) NOT NULL Certify Flag
19 BORROW_FLAG Character(1) VARCHAR2(1) NOT NULL Borrow Flag
20 BULK_NONBULK_IND Character(1) VARCHAR2(1) NOT NULL Bulk/Non-Bulk Flag
21 FMS_SOURCE_IND Character(1) VARCHAR2(1) NOT NULL FMS Source Indicator
22 OMB_SOURCE_IND Character(1) VARCHAR2(1) NOT NULL OMB Source Indicator
23 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: USD