BUS_UNIT_RC_DEF

(SQL Table)
 Index Back

Case Defaults

Case Defaults by Business Unit, Vertical, Self Service

# 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 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code

Prompt Table: RDT_TMPL_FAM3VW

3 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

Prompt Table: RC_BU_COMP_VW

4 MARKET Character(3) VARCHAR2(3) NOT NULL Market

Default Value: GBL

Prompt Table: RDT_TMPL_MKT_VW

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

Prompt Table: RC_STATUS_TBL
Set Control Field: BUSINESS_UNIT

6 RC_STATUS_ROPEN Character(5) VARCHAR2(5) NOT NULL Case Status

Prompt Table: RC_STATUS_TBL
Set Control Field: BUSINESS_UNIT

7 RC_STATUS_RESOLVED Character(5) VARCHAR2(5) NOT NULL Case Status

Prompt Table: RC_STATUS_TBL
Set Control Field: BUSINESS_UNIT

8 RC_STATUS_DUP Character(5) VARCHAR2(5) NOT NULL Business Default Status for Cancel Duplicate Case

Prompt Table: RC_STATUS_TBL
Set Control Field: BUSINESS_UNIT

9 CASE_TYPE Character(5) VARCHAR2(5) NOT NULL Case Type

Prompt Table: RC_CASETYPE_TBL
Set Control Field: BUSINESS_UNIT

10 CASE_SUBTYPE Character(5) VARCHAR2(5) NOT NULL Field to capture the case subtype.

Prompt Table: RC_CASE_SUBTYPE
Set Control Field: BUSINESS_UNIT

11 DEF_CASE_TYPE Character(5) VARCHAR2(5) NOT NULL Case Type to be used when the case is associated to a Quality Defect.

Prompt Table: RC_CASETYPE_TBL
Set Control Field: BUSINESS_UNIT

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

Prompt Table: RC_PRIORITY_TBL
Set Control Field: BUSINESS_UNIT

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

Prompt Table: RC_URGENCY_TBL
Set Control Field: BUSINESS_UNIT

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

Prompt Table: RC_SEVERITY_TBL
Set Control Field: BUSINESS_UNIT

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

Prompt Table: RC_SOURCE_TBL
Set Control Field: BUSINESS_UNIT

16 RC_SOURCE_EIP Character(5) VARCHAR2(5) NOT NULL Default source value when creating a case from Case Web Service.

Prompt Table: RC_SOURCE_TBL
Set Control Field: BUSINESS_UNIT

17 RC_SOURCE_ERMS Character(5) VARCHAR2(5) NOT NULL Default source value when creating a case from Case EIP (3rd party).

Prompt Table: RC_SOURCE_TBL

18 CASE_TYPE_SS Character(5) VARCHAR2(5) NOT NULL Case Type, used to default the value for self-service.

Prompt Table: RC_BUCASETYP_SS
Set Control Field: BUSINESS_UNIT

19 CASE_SUBTYPE_SS Character(5) VARCHAR2(5) NOT NULL Field to capture the case subtype.

Prompt Table: RC_CASE_STY2_SS
Set Control Field: BUSINESS_UNIT

20 RC_PRIORITY_SS Character(5) VARCHAR2(5) NOT NULL Case Priority, used to default the value for Self-Service

Prompt Table: RC_PRIORITY_SS
Set Control Field: BUSINESS_UNIT

21 URGENCY_SS Character(5) VARCHAR2(5) NOT NULL Case Urgency, used as a default for Self-Service

Prompt Table: RC_URGENCY_SS
Set Control Field: BUSINESS_UNIT

22 RC_SEVERITY_SS Character(5) VARCHAR2(5) NOT NULL Case severity, used as a default for Self-Service

Prompt Table: RC_SEVERITY_SS
Set Control Field: BUSINESS_UNIT

23 RC_STATUS_SS Character(5) VARCHAR2(5) NOT NULL Case Status

Prompt Table: RC_STATUS_SS
Set Control Field: BUSINESS_UNIT

24 RC_STATUS_RSLVD_SS Character(5) VARCHAR2(5) NOT NULL Case Status

Prompt Table: RC_STATUS_SS
Set Control Field: BUSINESS_UNIT

25 RC_STATUS_CLOSE_SS Character(5) VARCHAR2(5) NOT NULL Case Status

Prompt Table: RC_STATUS_SS
Set Control Field: BUSINESS_UNIT

26 RC_STATUS_ROPEN_SS Character(5) VARCHAR2(5) NOT NULL Case Status

Prompt Table: RC_STATUS_SS
Set Control Field: BUSINESS_UNIT

27 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

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

Prompt Table: RC_CTD_TYP_F_VW
Set Control Field: BUSINESS_UNIT

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

Prompt Table: RC_CTD_DET_F_VW
Set Control Field: BUSINESS_UNIT

30 RC_CATEGORY_SS Character(5) VARCHAR2(5) NOT NULL CallCenter Category. Used in HD.

Prompt Table: RC_CTD_CAT_SSVW
Set Control Field: BUSINESS_UNIT

31 RC_TYPE_SS Character(5) VARCHAR2(5) NOT NULL Specialty type. Used on HD case.

Prompt Table: RC_CTD_TYP_SSV2
Set Control Field: BUSINESS_UNIT

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

Prompt Table: RC_CTD_DET_SSV2
Set Control Field: BUSINESS_UNIT

33 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.

Prompt Table: RF_PROVGRP_VW2
Set Control Field: BUSINESS_UNIT

34 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

35 RC_NOTE_TYPE Character(5) VARCHAR2(5) NOT NULL Case Note Types

Prompt Table: RC_NOTETYPE_TBL
Set Control Field: BUSINESS_UNIT

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

Prompt Table: RC_IMPACT_TBL
Set Control Field: BUSINESS_UNIT

37 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group

Prompt Table: RC_PRDGRP_VW1
Set Control Field: BUSINESS_UNIT

38 RC_SOURCE_HCM Character(5) VARCHAR2(5) NOT NULL Default source value when creating a case from HCM EIP (3rd party).

Prompt Table: RC_SOURCE_TBL
Set Control Field: BUSINESS_UNIT

39 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
40 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
41 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
42 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
43 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.
44 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time