RBG_CASE_GEO_VW (SQL View)	Index Back
View on Case and Address View on Case and Address used by Map Dashboard.

RBG_CASE_GEO_VW

(SQL View)

View on Case and Address

View on Case and Address used by Map Dashboard.

SELECT A.BUSINESS_UNIT , A.CASE_ID , A.MARKET , A.RC_SUMMARY , A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , Z.BO_NAME , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , Y.BO_NAME , A.RC_STATUS , A.CASE_TYPE , A.RC_PRIORITY , A.RC_CATEGORY , A.RC_TYPE , A.RC_DETAIL , A.CREATION_DATE , %subrec(RB_AUDIT_SBR,A) FROM PS_RC_CASE A , PS_BO_NAME Z , PS_BO_NAME Y WHERE A.ROLE_TYPE_ID_CUST IN (2,9) AND A.BO_ID_CUST = Z.BO_ID (+) AND A.BO_ID_CONTACT = Y.BO_ID(+) AND ( (A.CASE_ID IN ( SELECT Z.CASE_ID FROM PS_RBG_INCI_ADD_VW Z WHERE Z.BUSINESS_UNIT = A.BUSINESS_UNIT)) OR (A.CASE_ID IN ( SELECT X.CASE_ID FROM PS_RBG_CUST_ADD_VW X WHERE X.BUSINESS_UNIT = A.BUSINESS_UNIT)) )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_RCOVR_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 MARKET Character(3) VARCHAR2(3) NOT NULL Market

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

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

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

7 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

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

9 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact

10 BO_NAME_CONTACT Character(50) VARCHAR2(50) NOT NULL BO_NAME_CONTACT

11 RC_STATUS Character(5) VARCHAR2(5) NOT NULL Case Status
Prompt Table: RC_STATUS_TBL
Set Control Field: BUSINESS_UNIT

12 CASE_TYPE Character(5) VARCHAR2(5) NOT NULL Case Type
Prompt Table: RC_CASETYPE_TBL
Set Control Field: BUSINESS_UNIT

13 RC_PRIORITY Character(5) VARCHAR2(5) NOT NULL Case Priority
Prompt Table: RC_PRIORITY_TBL
Set Control Field: BUSINESS_UNIT

14 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

15 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

16 RC_DETAIL Character(5) VARCHAR2(5) NOT NULL Detail field on HD Case. Used in Quick Code.
Prompt Table: RC_CTD_DET_F_VW

17 CREATION_DATE Date(10) DATE Creation date of the case.

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

19 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

20 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

21 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

22 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.

23 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_RCOVR_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	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market
4	RC_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Typically a summary of a long field.
5	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
6	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
7	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
8	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
9	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact
10	BO_NAME_CONTACT	Character(50)	VARCHAR2(50) NOT NULL	BO_NAME_CONTACT
11	RC_STATUS	Character(5)	VARCHAR2(5) NOT NULL	Case Status Prompt Table: RC_STATUS_TBL Set Control Field: BUSINESS_UNIT
12	CASE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Case Type Prompt Table: RC_CASETYPE_TBL Set Control Field: BUSINESS_UNIT
13	RC_PRIORITY	Character(5)	VARCHAR2(5) NOT NULL	Case Priority Prompt Table: RC_PRIORITY_TBL Set Control Field: BUSINESS_UNIT
14	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
15	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
16	RC_DETAIL	Character(5)	VARCHAR2(5) NOT NULL	Detail field on HD Case. Used in Quick Code. Prompt Table: RC_CTD_DET_F_VW
17	CREATION_DATE	Date(10)	DATE	Creation date of the case.
18	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
19	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
20	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
21	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
22	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.
23	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time