F2_STAGING_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	TSYMBOL_ATTRIB	Character(16)	VARCHAR2(16) NOT NULL	Treasury Symbol Attribute
3	REPORT_ID	Character(8)	VARCHAR2(8) NOT NULL	Report Identifier
4	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
5	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPER_UNIT_TBL
6	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_TBL
7	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_TBL
8	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASS_CF_TBL
9	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_TBL
10	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_TBL
11	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
12	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
13	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
14	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CHARTFIELD1_TBL
15	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CHARTFIELD2_TBL
16	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CHARTFIELD3_TBL
17	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
18	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
19	F2_ACCOUNT	Character(6)	VARCHAR2(6) NOT NULL	FACTS II Account
20	RECORD_TYPE_7	Character(15)	VARCHAR2(15) NOT NULL	Record Type 7 TAS
21	F2_COHORT_YR	Character(4)	VARCHAR2(4) NOT NULL	Cohort Year
22	INDEF_DEF_FLAG	Character(15)	VARCHAR2(15) NOT NULL	Indefinite/Definite
23	F2_CAT_B	Character(3)	VARCHAR2(3) NOT NULL	Category B Code
24	APPOR_CAT_B_TEXT	Character(25)	VARCHAR2(25) NOT NULL	Apportionment Category B Text
25	PUBLIC_LAW	Character(15)	VARCHAR2(15) NOT NULL	Public Law Cited
26	APPOR_CAT_CODE	Character(15)	VARCHAR2(15) NOT NULL	Apportionment Category Code
27	F2_AUTHORITY_TYPE	Character(15)	VARCHAR2(15) NOT NULL	Authority Type
28	TRANS_PARTNER	Character(15)	VARCHAR2(15) NOT NULL	Transaction Partner
29	TRANS_AGENCY	Character(2)	VARCHAR2(2) NOT NULL	Transfer Agency
30	TRANS_ACCOUNT	Character(4)	VARCHAR2(4) NOT NULL	Transfer Account
31	TRANS_TO_FROM	Character(4)	VARCHAR2(4) NOT NULL	Transfer to/from
32	REIMBURSABLE_FLAG	Character(15)	VARCHAR2(15) NOT NULL	Reimbursable Flag
33	YEAR_BUDGET_AUTH	Character(4)	VARCHAR2(4) NOT NULL	Year of Budget Authority
34	BEA_CATEGORY	Character(15)	VARCHAR2(15) NOT NULL	BEA Category
35	BORROW_SOURCE	Character(15)	VARCHAR2(15) NOT NULL	Borrowing Source
36	ADVANCE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Advance Flag
37	CURR_PERM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Status of Budgetary Authority
38	DEF_LIQUID_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Adjusts made in Subsequent Yrs
39	DEFICIENCY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Deficiency Flag
40	AVAILABILITY_FLAG	Character(15)	VARCHAR2(15) NOT NULL	Budget Resource Availability
41	LEGISLATION_FLAG	Character(15)	VARCHAR2(15) NOT NULL	Type of Legislation
42	OMB_FUNCTION	Character(3)	VARCHAR2(3) NOT NULL	Function
43	F2_EXP_UNEXP	Character(15)	VARCHAR2(15) NOT NULL	Expired/ Unexpired Indicator
44	BEGIN_BALANCE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Beginning Balance
45	PTD_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Period to Date Amount
46	BEGIN_END	Character(15)	VARCHAR2(15) NOT NULL	Begin/End Balance Code
47	F2_DEBIT_CREDIT	Character(15)	VARCHAR2(15) NOT NULL	Debit/ Credit Indicator
48	POSTED_TOTAL_DR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Posted Total Debits
49	POSTED_TOTAL_CR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Posted Total Credits
50	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code