RC_WF_CASEHD_VW

(SQL View)
 Index Back

CRM Workflow Action Request VW

CRM Workflow Action Request View for Help Desk

SELECT A.OPRID , A.BUSPROCNAME , A.ACTIVITYNAME , A.EVENTNAME , A.WORKLISTNAME , A.INSTANCEID , A.INSTSTATUS , A.INSTAVAILABLEDTTM , A.INSTTIMEOUTDTTM , A.ORIGINATORID , C.BUSINESS_UNIT , B.CASE_ID , C.RC_SUMMARY , C.RC_RESP_DATE , C.RC_RESP_TIME , C.RC_REST_DATE , C.RC_REST_TIME , C.RC_RESP_IND , C.RC_REST_IND , C.RC_CATEGORY , C.RC_TYPE , C.RC_DETAIL , C.RC_IMPACT , C.BO_ID_CUST , C.ASSIGNED_TO , CASE WHEN C.BO_ID_CONTACT = 0 THEN '' ELSE C.CASE_CONTACT END , C.BO_ID_CONTACT , C.PROVIDER_GRP_ID , C.CREATION_DATE , C.CASE_TYPE , C.RC_STATUS , C.RC_PRIORITY , C.PRODUCT_ID , C.SECURE_CASE_FLG , B.WORKLIST_DESCR , C.DISP_TMPL_FAM_CD , A.WL_PRIORITY , A.COMMENTSHORT , CASE WHEN A.INSTSTATUS = 2 THEN 'Y' ELSE 'N' END , B.WF_PURPOSE , A.SYNCID FROM PSWORKLIST A , PS_RC_CASE_WL_HD B , PS_RC_CASE 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.CASE_ID = C.CASE_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
12 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
13 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.
14 RC_RESP_DATE Date(10) DATE Response date
15 RC_RESP_TIME Time(15) TIMESTAMP Response Time
16 RC_REST_DATE Date(10) DATE Restore Date
17 RC_REST_TIME Time(15) TIMESTAMP Restore Time
18 RC_RESP_IND Character(4) VARCHAR2(4) NOT NULL Response Indicator, to indicate different stage of response for SLA.
A=Pending
N=Late
NA=Not Applicable
Y=On-Time
19 RC_REST_IND Character(4) VARCHAR2(4) NOT NULL Restore Indicator, indicate different stage of restore for SLA
A=Pending
N=Late
NA=Not Applicable
Y=On-Time
20 RC_CATEGORY Character(5) VARCHAR2(5) NOT NULL CallCenter Category. Used in HD.

Prompt Table: RC_CTD_CAT_F_VW
Set Control Field: BUSINESS_UNIT

21 RC_TYPE Character(5) VARCHAR2(5) NOT NULL Specialty type. Used on HD case.

Prompt Table: RC_CTD_TYP_F_VW
Set Control Field: RC_CATEGORY

22 RC_DETAIL Character(5) VARCHAR2(5) NOT NULL Detail field on HD Case. Used in Quick Code.

Prompt Table: RC_CTD_DET_F_VW

23 RC_IMPACT Character(5) VARCHAR2(5) NOT NULL Case severity

Prompt Table: RC_IMPACT_TBL
Set Control Field: BUSINESS_UNIT

24 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
25 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.
26 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
27 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
28 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.

Prompt Table: RF_PROVIDER_GRP
Set Control Field: BUSINESS_UNIT

29 CREATION_DATE Date(10) DATE Creation date of the case.
30 CASE_TYPE Character(5) VARCHAR2(5) NOT NULL Case Type

Prompt Table: RC_CASETYPE_TBL
Set Control Field: BUSINESS_UNIT

31 RC_STATUS Character(5) VARCHAR2(5) NOT NULL Case Status

Prompt Table: RC_STATUS_TBL
Set Control Field: BUSINESS_UNIT

32 RC_PRIORITY Character(5) VARCHAR2(5) NOT NULL Case Priority

Prompt Table: RC_PRIORITY_TBL
Set Control Field: BUSINESS_UNIT

33 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: PROD_ITEM_VW2
Set Control Field: BUSINESS_UNIT

34 SECURE_CASE_FLG Character(1) VARCHAR2(1) NOT NULL Used in HRHD to Secure the case so that only people in the provider group assigned to the case can access the case.
N=No
Y=Yes
35 WORKLIST_DESCR Character(50) VARCHAR2(50) NOT NULL Description
36 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code
37 WL_PRIORITY Character(1) VARCHAR2(1) NOT NULL Priority
1=1-High
2=2-Medium
3=3-Low
38 COMMENTSHORT Character(30) VARCHAR2(30) NOT NULL Short Comment
39 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

40 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
41 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.