PC_WM_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUPRJACT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	BU/Proj/Act Option A=Business Unit/Project/Activity B=Business Unit E=All P=Business Unit/Project
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: Y
4	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Default Value: Y
5	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Default Value: Y
6	RESOURCE_ID	Character(40)	VARCHAR2(40) NOT NULL	Transaction ID
7	RESOURCE_ID_FROM	Character(40)	VARCHAR2(40) NOT NULL	Original Transaction ID
8	FROM_DATE	Date(10)	DATE	From Date
9	THRU_DATE	Date(10)	DATE	Through Date
10	DATE_RANGE_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Date Option A=Accounting Date E=All T=Transaction Date
11	DST_TYPE_OPTN	Character(1)	VARCHAR2(1) NOT NULL	DST Acct Type Option A=All Lines D=DST Lines F=FRG Lines S=STX Lines V=Specific Lines
12	AN_TYPE_WM_TU	Character(3)	VARCHAR2(3) NOT NULL	Maintenance Mgmt Tools Usage
13	WHERE_CLAUSE_LONG	Long Character(4000)	CLOB	Where Clause
14	LAST_RESOURCE_ID	Number(20,0)	DECIMAL(20) NOT NULL	Last Transaction ID
15	BUSINESS_UNIT_WO	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Work Order
16	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	Work Order Identification
17	WO_TASK_ID	Number(5,0)	INTEGER NOT NULL	Task Number
18	RES_LN_NBR	Number(5,0)	INTEGER NOT NULL	Resource Line No.
19	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line Default Value: 1
20	WORK_CNT	Number(10,0)	DECIMAL(10) NOT NULL	Count of Anything
21	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number
22	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).