RC_CASE_INFO_VW

(SQL View)
 Index Back

Call Center View for Reports

Call Center View used in Reports

SELECT A.BUSINESS_UNIT , A.CASE_ID , D.DESCR , C.BO_NAME , E.RC_LAST_NAME , E.RC_FIRST_NAME , E.NAME , A.CASE_TYPE , A.PROVIDER_GRP_ID , A.RC_PRIORITY , A.CREATION_DATE , A.BO_ID_CUST , A.RC_VERTICAL , A.ROLE_TYPE_ID_CUST , A.RC_STATUS FROM PS_RC_CASE A , PS_RF_PROD_ITEM_VW D , PS_RC_ASSIGN_VW E , PS_BO_NAME C WHERE A.PRODUCT_ID = D.PRODUCT_ID AND A.ASSIGNED_TO = E.ASSIGNED_TO AND A.BO_ID_CONTACT = C.BO_ID AND C.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 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.
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 NAME Character(50) VARCHAR2(50) NOT NULL Name
5 RC_LAST_NAME Character(30) VARCHAR2(30) NOT NULL RC_LAST_NAME
6 RC_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
7 NAME_ASSIGNED_TO Character(80) VARCHAR2(80) NOT NULL The name of the assigned agent.
8 CASE_TYPE Character(5) VARCHAR2(5) NOT NULL Case Type
9 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.
10 RC_PRIORITY Character(5) VARCHAR2(5) NOT NULL Case Priority
11 CREATION_DATE Date(10) DATE Creation date of the case.
12 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
13 RC_VERTICAL Character(4) VARCHAR2(4) NOT NULL Specifies the CallCenter type. See translates for valid values.
HD=HelpDesk
SW=Support
14 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
15 RC_STATUS Character(5) VARCHAR2(5) NOT NULL Case Status