GM_PCL_WF_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	PCL_ID	Character(15)	VARCHAR2(15) NOT NULL	PCL_ID
6	PCL_VRSN_ID	Character(7)	VARCHAR2(7) NOT NULL	PCL_VRSN_ID
7	PCL_STATUS	Character(4)	VARCHAR2(4) NOT NULL	PCL_STATUS APPR=Approved DEND=Denied DRFT=Draft EXPD=Expired INAC=Inactive PEND=Pending RETD=Returned
8	DURATION	Number(5,0)	INTEGER NOT NULL	Recurrence Duration
9	PCL_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Protocol Type
10	PCL_SUB_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Protocol Subtype - Human , Animal A=Animal B=Both H=Human
11	GM_ELEMENT_VALUE	Character(18)	VARCHAR2(18) NOT NULL	GM_ELEMENT_VALUE
12	GM_DATE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	GM_DATE_TYPE CRD=Committee meeting Reminder CRN=Continuing Review EXP=Expiration REN=Renewal
13	COM_ID	Character(5)	VARCHAR2(5) NOT NULL	Committee Id. Used in Grants Protocol Setup
14	MEET_ID	Character(5)	VARCHAR2(5) NOT NULL	Meeting Id. Used in Grants Protocol Setup
15	DATE_SEL_DT	Date(10)	DATE	03/23/2004 SFC Added PROD_COST_EFF_DT label
16	RETURN_CD	Character(1)	VARCHAR2(1) NOT NULL	Return Code 0=Return OK 1=Return error
17	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
18	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
19	WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
20	NOTES	Long Character	CLOB	Budget Notes