GM_PT_STAGE_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	GM_PT_SOURCE	Character(4)	VARCHAR2(4) NOT NULL	Transaction Source KK=Commitment Control PC=Project
3	TREE_SETID	Character(5)	VARCHAR2(5) NOT NULL	Tree SetID
4	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
5	TREE_LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Parent tree level if this is a part of the PSTREEBRANCH record
6	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
7	SPONSOR_BUD	Character(5)	VARCHAR2(5) NOT NULL	Sponsor Budgets
8	GM_CSR_GM_BUD	Character(5)	VARCHAR2(5) NOT NULL	Cost Sharing - Budgets
9	SPONSOR_EXPD	Character(5)	VARCHAR2(5) NOT NULL	Sponsor Expenditures
10	COST_SHARE_EXPD	Character(5)	VARCHAR2(5) NOT NULL	Cost Share Expenditures
11	SPONSOR_ENCB	Character(5)	VARCHAR2(5) NOT NULL	Sponsor Encumbrances
12	COST_SHARE_ENCB	Character(5)	VARCHAR2(5) NOT NULL	Cost Share Encumbrances
13	SPONSOR_PREENCB	Character(5)	VARCHAR2(5) NOT NULL	Sponsor Pre-encumbrances
14	COST_SHARE_PREENCB	Character(5)	VARCHAR2(5) NOT NULL	Cost Share Pre-encumbrances
15	THIRDPARTY_EXPD	Character(5)	VARCHAR2(5) NOT NULL	Third Party Expenditures
16	WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
17	WHERE_CLAUSE1	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
18	AWD_DAYS_ELAPSED	Number(4,0)	SMALLINT NOT NULL	Days Elapsed
19	PRJ_DAYS_ELAPSED	Number(4,0)	SMALLINT NOT NULL	Days Elapsed
20	DATE1	Date(10)	DATE	Date
21	DATE2	Date(10)	DATE	Date
22	COUNTER2	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Counter 2
23	COUNTER3	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Counter 3
24	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
25	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
26	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
27	FA_CS_FROM_VALUE	Character(10)	VARCHAR2(10) NOT NULL	Chartfield From Value
28	FA_CS_TO_VALUE	Character(10)	VARCHAR2(10) NOT NULL	Chartfield To Value
29	FINAL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Final Bill Option
30	TMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Field for holding temp data
31	BUD_OVERLAP_SW	Character(1)	VARCHAR2(1) NOT NULL	Overlap Award Budget Period F=First L=Last
32	WHERE_LONG	Long Character	CLOB	Where Clause