GM_EXTRACT_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
4	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
5	RESOURCE_ID	Character(40)	VARCHAR2(40) NOT NULL	Transaction ID
6	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
7	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
8	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
9	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
10	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField
11	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField
12	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
13	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field
14	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField
15	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference
16	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate
17	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
18	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
19	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1
20	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
21	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
22	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
23	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
24	TRANS_DT	Date(10)	DATE	Transaction Date
25	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
26	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
27	FOREIGN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
28	RESOURCE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
29	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
30	DST_ID	Character(10)	VARCHAR2(10) NOT NULL	Distribution Code
31	TREE_SETID	Character(5)	VARCHAR2(5) NOT NULL	Tree SetID
32	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
33	WAIVED_FA_CLC_MTHD	Character(1)	VARCHAR2(1) NOT NULL	This field allows a user to defined whether waived facilities and administrative costs are determined by subtracting the budgeted/funded amount from the institution amount or from the sponsor amount. I=Institution Minus Funded S=Sponsor Minus Funded
34	FA_CALC_SPONSOR	Character(1)	VARCHAR2(1) NOT NULL	Sponsor F&&A
35	FA_CALC_WAIVED	Character(1)	VARCHAR2(1) NOT NULL	Waived F&&A
36	FA_CALC_COSTSHARED	Character(1)	VARCHAR2(1) NOT NULL	Cost Shared F&&A