RQ_DEFECT_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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_RQ_NONVW
8	R_DEFECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Quality Defect Identification key unique by business unit
9	RB_WF_WL_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Notification Priority 1=High 2=Medium 3=Low
10	R_PRIORITY_CODE	Character(2)	VARCHAR2(2) NOT NULL	Priority 1=High 2=Medium 3=Low
11	R_PRIORITY_CD_DESC	Character(30)	VARCHAR2(30) NOT NULL	Priority code
12	R_PROD_RLSE_ID	Character(18)	VARCHAR2(18) NOT NULL	Product Release ID / Product ID. 05/19/2003 Increased field length from 15 to 18 in order to be compatible with field PRODUCT_ID.
13	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
14	R_SUBJECT	Character(254)	VARCHAR2(254) NOT NULL	subject
15	WORKLIST_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Description
16	R_ST_STATUS_CD	Character(4)	VARCHAR2(4) NOT NULL	STATUS CODE
17	R_ST_REASON_CD	Character(4)	VARCHAR2(4) NOT NULL	Status Reason
18	WF_PURPOSE	Character(4)	VARCHAR2(4) NOT NULL	Purpose of the Notification 0=FYI APPR=Approval Required ASSN=Assignment ESCA=Escalation FOLL=Follow-Up Requested HOLD=Hold Notification SLA=SLA Warning SLAX=SLA Exception STAT=Status Change TASG=Task Assignment UPD=Update Notification