BUS_UNIT_DEF_VW

(SQL View)
 Index Back

Case Default View. Not SS

Case Default view. Not Self Service.

SELECT BUSINESS_UNIT ,MARKET ,PNLGRPNAME ,RC_STATUS ,CASE_TYPE ,RC_PRIORITY ,URGENCY ,RC_SEVERITY ,RC_SOURCE ,RC_CATEGORY ,RC_TYPE ,RC_DETAIL ,RC_STATUS_RESOLVED ,CONTACT_ME_PG FROM PS_BUS_UNIT_RC_DEF

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: BUS_UNIT_TBL_RC.BUSINESS_UNIT

2 MARKET Character(3) VARCHAR2(3) NOT NULL Market
3 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
4 RC_STATUS Character(5) VARCHAR2(5) NOT NULL Case Status
5 CASE_TYPE Character(5) VARCHAR2(5) NOT NULL Case Type

Prompt Table: RC_CASETYPE_TBL
Set Control Field: BUSINESS_UNIT

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

Prompt Table: RC_PRIORITY_TBL
Set Control Field: BUSINESS_UNIT

7 URGENCY Character(5) VARCHAR2(5) NOT NULL Case Urgency

Prompt Table: RC_URGENCY_TBL
Set Control Field: BUSINESS_UNIT

8 RC_SEVERITY Character(5) VARCHAR2(5) NOT NULL Case severity

Prompt Table: RC_SEVERITY_TBL
Set Control Field: BUSINESS_UNIT

9 RC_SOURCE Character(5) VARCHAR2(5) NOT NULL Case Source How this case origianated

Prompt Table: RC_SOURCE_TBL
Set Control Field: BUSINESS_UNIT

10 RC_CATEGORY Character(5) VARCHAR2(5) NOT NULL CallCenter Category. Used in HD.

Prompt Table: RC_CATEGORY_VW
Set Control Field: BUSINESS_UNIT

11 RC_TYPE Character(5) VARCHAR2(5) NOT NULL Specialty type. Used on HD case.
12 RC_DETAIL Character(5) VARCHAR2(5) NOT NULL Detail field on HD Case. Used in Quick Code.
13 RC_STATUS_RESOLVED Character(5) VARCHAR2(5) NOT NULL Case Status
14 CONTACT_ME_PG Character(10) VARCHAR2(10) NOT NULL Provider group that will get notification when a customer clicks the contact me button on the manage case page in self-service. This provider group wil only be notified if there is no provider group or agent assigned to the case.

Prompt Table: RF_PROVGRP_VW2
Set Control Field: BUSINESS_UNIT