RBF_CUST_ISS_VW (SQL View)	Index Back
View for Customer Issues This view is used to populate the grid in the customer view. This helps identify all the issues relation to a customer

RBF_CUST_ISS_VW

(SQL View)

View for Customer Issues

This view is used to populate the grid in the customer view. This helps identify all the issues relation to a customer

SELECT DISTINCT C.BO_ID ,A.CASE_ID , C.PERSON_ID ,D.BO_NAME CONTACT_NAME ,A.RC_SUMMARY , A.RC_STATUS , A.BUSINESS_UNIT ,A.CASE_TYPE , A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT ,A.CREATION_DATE , A.ROW_ADDED_DTTM FROM PS_RC_CASE A , PS_RD_PERSON C , PS_BO_NAME D WHERE ( A.BO_ID_CONTACT = C.BO_ID OR A.BO_ID_CUST = C.BO_ID) AND C.BO_ID = D.BO_ID AND D.PRIMARY_IND = 'Y' AND A.CASE_VISIBILITY = 'EXTL'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

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 CASE_CONTACT Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

4 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.

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

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

7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

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

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

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

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

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

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	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
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	CASE_CONTACT	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
4	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	The individual contact name associated with a given bank/counterparty.
5	RC_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Typically a summary of a long field.
6	RC_STATUS	Character(5)	VARCHAR2(5) NOT NULL	Case Status
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	CASE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Case Type
9	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
10	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
11	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
12	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact
13	CREATION_DATE	Date(10)	DATE	Creation date of the case.
14	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.