BPW_WL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSPROCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Process Name (see PSBUSPROCDEFN).
2	ACTIVITYNAME	Character(30)	VARCHAR2(30) NOT NULL	Name of a Business Process Activity (see PSACTIVITYDEFN).
3	EVENTNAME	Character(30)	VARCHAR2(30) NOT NULL	Defines a routing event for PS Workflow
4	WORKLISTNAME	Character(30)	VARCHAR2(30) NOT NULL	Worklist Name
5	INSTANCEID	Number(10,0)	DECIMAL(10) NOT NULL	For a given worklist the unique number of rows in PSWORKLIST
6	TRANSACTIONID	Number(10,0)	DECIMAL(10) NOT NULL	Transaction Identifier
7	BPW_PROC_ID	Character(30)	VARCHAR2(30) NOT NULL	Process Weaver ID
8	BPW_PROC_RUN_CNTL	Character(30)	VARCHAR2(30) NOT NULL	Process Run Control ID
9	BPW_PROC_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Process Status for Business Process Weaver. - Any change should be reflected in BUSINESS_PROCESS_WEAVER:ENUM:ProcessStatus - "Summarized" status is by xlate value so make so to choose the proper value for new status. 10=Skipped 15=Cancelled 20=Complete 22=Compl/Warning 25=Complete/Error 30=Paused After 40=Not Started 50=Paused Before 60=Started 70=On Hold 90=Error
10	BPW_PROC_PROC_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance Number
11	BPW_WL_STATUS	Character(100)	VARCHAR2(100) NOT NULL	Worklist Status
12	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
13	BPW_PROC_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Business Process Type RTBL=Real Time Bottom Line SYS=System USER=User Defined
14	BPW_THRD_PROC_INST	Number(10,0)	DECIMAL(10) NOT NULL	Thread Instance Number
15	BPW_STEP_ID	Character(30)	VARCHAR2(30) NOT NULL	Step ID
16	BPW_STEP_PROC_INST	Number(10,0)	DECIMAL(10) NOT NULL	Step Instance Number
17	WL_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Worklist Priority 1=1-High 2=2-Medium 3=3-Low