RI_RC_SUPPRT_VW (SQL View)	Index Back
support view Call center support view used by Interaction

RI_RC_SUPPRT_VW

(SQL View)

support view

Call center support view used by Interaction

SELECT BUSINESS_UNIT , CASE_ID , ' ' , RC_VERTICAL , RC_STATUS , RC_SUMMARY , CASE_CONTACT , CREATION_DATE , PRODUCT_ID , BO_ID_CONTACT , BO_ID_CUST , ROLE_TYPE_ID_CUST , BO_ID_SITE ,ROW_ADDED_DTTM FROM PS_RC_CASE WHERE RC_VERTICAL = 'SW'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_FS_NONVW

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 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

4 RC_VERTICAL Character(4) VARCHAR2(4) NOT NULL Specifies the CallCenter type. See translates for valid values.
HD=HelpDesk
SW=Support

5 RC_STATUS Character(5) VARCHAR2(5) NOT NULL Case Status
Prompt Table: RC_STATUS_TBL

6 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.

7 CASE_CONTACT Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
Prompt Table: RC_CNTCT_VW

8 ROW_ADDED_DT Date(10) DATE Date Added label added for Wealth Management.

9 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
Prompt Table: PROD_ITEM

10 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

11 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

12 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer

13 BO_ID_SITE Number(31,0) DECIMAL(31) NOT NULL Business Object ID

14 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_FS_NONVW
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	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
4	RC_VERTICAL	Character(4)	VARCHAR2(4) NOT NULL	Specifies the CallCenter type. See translates for valid values. HD=HelpDesk SW=Support
5	RC_STATUS	Character(5)	VARCHAR2(5) NOT NULL	Case Status Prompt Table: RC_STATUS_TBL
6	RC_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Typically a summary of a long field.
7	CASE_CONTACT	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts Prompt Table: RC_CNTCT_VW
8	ROW_ADDED_DT	Date(10)	DATE	Date Added label added for Wealth Management.
9	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: PROD_ITEM
10	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
11	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
12	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
13	BO_ID_SITE	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
14	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.