RG_WF_CHGREQ_VW

(SQL View)
 Index Back

Worklist Change Request View

Change Request Worklist view...............

SELECT A.OPRID , A.BUSPROCNAME , A.ACTIVITYNAME , A.EVENTNAME , A.WORKLISTNAME , A.INSTANCEID , A.INSTSTATUS , A.INSTAVAILABLEDTTM , A.INSTTIMEOUTDTTM , A.ORIGINATORID , A.WL_PRIORITY , A.COMMENTSHORT , B.CHANGE_REQUEST_ID , B.BUSINESS_UNIT , C.RG_SUMMARY , C.BO_ID_REQUESTOR , C.BO_ID_OWNER , B.WORKLIST_DESCR , B.DISP_TMPL_ID , C.CHANGE_STATUS , C.RG_CATEGORY , C.RG_PRIORITY , C.RG_REQUEST_TYPE , C.RG_REQ_SUB_TYPE , CASE WHEN A.INSTSTATUS = 2 THEN 'Y' ELSE 'N' END , B.WF_PURPOSE , A.SYNCID FROM PSWORKLIST A , PS_RG_CHG_REQST_WL B , PS_RG_CHANGE_REQST 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.CHANGE_REQUEST_ID = C.CHANGE_REQUEST_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT

# 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 WL_PRIORITY Character(1) VARCHAR2(1) NOT NULL Priority
1=1-High
2=2-Medium
3=3-Low
12 COMMENTSHORT Character(30) VARCHAR2(30) NOT NULL Short Comment
13 CHANGE_REQUEST_ID Character(15) VARCHAR2(15) NOT NULL change request identification is key to change request
14 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
15 RG_SUMMARY Character(80) VARCHAR2(80) NOT NULL Summary description of a Change Request
16 BO_ID_REQUESTOR Number(31,0) DECIMAL(31) NOT NULL Change Requester Identification number
17 BO_ID_OWNER Number(31,0) DECIMAL(31) NOT NULL Financial Account Business Object ID
18 WORKLIST_DESCR Character(50) VARCHAR2(50) NOT NULL Description
19 DISP_TMPL_ID Character(30) VARCHAR2(30) NOT NULL Template identifier to define the display template.
20 CHANGE_STATUS Character(4) VARCHAR2(4) NOT NULL status of a Change Request in Change Management application
21 RG_CATEGORY Character(4) VARCHAR2(4) NOT NULL change management change Request Category
22 RG_PRIORITY Character(4) VARCHAR2(4) NOT NULL change management
23 RG_REQUEST_TYPE Character(4) VARCHAR2(4) NOT NULL Change Management Type of Change Request.
24 RG_REQ_SUB_TYPE Character(4) VARCHAR2(4) NOT NULL Change Management change Request Sub Type
25 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

26 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
27 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.