RQ_WF_DEFECT_VW

(SQL View)
Index Back

Work flow Action Request

Quality Application Work flow Action Request View

SELECT a.oprid , A.BUSPROCNAME , A.ACTIVITYNAME , A.EVENTNAME , A.WORKLISTNAME , A.INSTANCEID , A.INSTSTATUS , A.INSTAVAILABLEDTTM , A.INSTTIMEOUTDTTM , A.ORIGINATORID , B.BUSINESS_UNIT , B.R_DEFECT_ID , B.RB_WF_WL_PRIORITY , B.R_PROD_RLSE_ID , B.DESCR , B.R_PRIORITY_CODE , B.R_PRIORITY_CD_DESC , C.R_ST_STATUS_CD , C.R_ST_REASON_CD , B.R_SUBJECT , B.WORKLIST_DESCR , A.WL_PRIORITY , A.COMMENTSHORT , CASE WHEN A.INSTSTATUS = 2 THEN 'Y' ELSE 'N' END , B.WF_PURPOSE , A.SYNCID FROM PSWORKLIST A , PS_RQ_DEFECT_WL B , PS_RQ_DEFECT C WHERE A.BUSPROCNAME = B.BUSPROCNAME AND A.ACTIVITYNAME = B.ACTIVITYNAME AND A.EVENTNAME = B.EVENTNAME AND A.WORKLISTNAME = B.WORKLISTNAME AND A.INSTANCEID = B.INSTANCEID AND A.INSTSTATUS <= 2 AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.R_DEFECT_ID = C.R_DEFECT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
3 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
4 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
5 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
6 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
7 INSTSTATUS Number(5,0) INTEGER NOT NULL Determines worklist status, available, selected, worked, cancelled
0=Selected
1=Open
2=Worked
3=Cancelled
8 INSTAVAILABLEDTTM DateTime(26) TIMESTAMP Datetime worklist instance was made available
9 INSTTIMEOUTDTTM DateTime(26) TIMESTAMP Datetime that a worklist times out
10 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_RQ_NONVW

12 R_DEFECT_ID Character(15) VARCHAR2(15) NOT NULL Quality Defect Identification key unique by business unit
13 RB_WF_WL_PRIORITY Character(1) VARCHAR2(1) NOT NULL Notification Priority
1=High
2=Medium
3=Low
14 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.

Prompt Table: RQ_PROD_DESC_VW

15 DESCR Character(30) VARCHAR2(30) NOT NULL Description
16 R_PRIORITY_CODE Character(2) VARCHAR2(2) NOT NULL Priority
1=High
2=Medium
3=Low
17 R_PRIORITY_CD_DESC Character(30) VARCHAR2(30) NOT NULL Priority code
18 R_ST_STATUS_CD Character(4) VARCHAR2(4) NOT NULL STATUS CODE

Prompt Table: RQ_UD_ST_STATUS

19 R_ST_REASON_CD Character(4) VARCHAR2(4) NOT NULL Status Reason

Prompt Table: RQ_UD_ST_REASON

20 R_SUBJECT Character(254) VARCHAR2(254) NOT NULL subject
21 WORKLIST_DESCR Character(50) VARCHAR2(50) NOT NULL Description
22 WL_PRIORITY Character(1) VARCHAR2(1) NOT NULL Priority
1=1-High
2=2-Medium
3=3-Low
23 COMMENTSHORT Character(30) VARCHAR2(30) NOT NULL Short Comment
24 SHOW_COMPLETED Character(1) VARCHAR2(1) NOT NULL This field is used to determine whether the worklist should be filtered to show only completed worklist entries.

Y/N Table Edit

Default Value: N

25 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
26 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.