P6_WBS_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
3	PROJECT_OBJECTID	Number(10,0)	DECIMAL(10) NOT NULL	A unique ID that is the Project key to a corresponding table in an external system such as Primavera.
4	WBS_ID	Character(100)	VARCHAR2(100) NOT NULL	WBS ID
5	PARENT_OBJECTID	Number(10,0)	DECIMAL(10) NOT NULL	A unique ID that is the Activity key to a corresponding table in an external system such as Primavera.
6	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
7	ACTIVITY_OBJECTID	Number(10,0)	DECIMAL(10) NOT NULL	A unique ID that is the Activity key to a corresponding table in an external system such as Primavera.
8	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
9	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
10	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
11	INTFC_LINE_NUM	Number(8,0)	INTEGER NOT NULL	Interface Line Number
12	ACTIVITY_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Activity Description
13	ACT_COST_EXP_LVL	Character(1)	VARCHAR2(1) NOT NULL	Acttual Cost Export Level A=Total S=Source Type
14	P6_RECNAME_STG	Character(15)	VARCHAR2(15) NOT NULL	Stage Table Name
15	P6_FIELDNAME_GUID	Character(18)	VARCHAR2(18) NOT NULL	Guid Field Name
16	SQLID_WHERE	Character(30)	VARCHAR2(30) NOT NULL	Match Rule SQL Object
17	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
18	SELECT_COUNT	Number(10,0)	DECIMAL(10) NOT NULL	SQL Select Count
19	SELECT_X	Character(1)	VARCHAR2(1) NOT NULL	Select 'X'
20	P6_SQL_LONG	Long Character(4096)	CLOB	SQL String