SSF_COLLECT_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	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
5	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
6	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	COLLECTOR_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Collector Type O=Collector Assigned by User ID R=Collector Assigned By Role
9	EMPLID_SW1	Character(1)	VARCHAR2(1) NOT NULL	Emplid Switch E=By Emplid O=By Org ID
10	COLLECTION_ID	Number(12,0)	DECIMAL(12) NOT NULL	Collection ID
11	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
12	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID
13	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
14	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
15	COLLECTION_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Collection Status A=Active being Collected C=Closed H=Hold All Collection Efforts I=Initial Collection Status N=Not Active Collected
16	REASON_IN	Character(3)	VARCHAR2(3) NOT NULL	Collection Reason In
17	NEXT_REVIEW_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Next Review User ID
18	NEXT_REVIEW_ROLE	Character(30)	VARCHAR2(30) NOT NULL	Next Review Role User
19	WL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Worklist Flag