RC_CASECUST_VW (SQL View)	Index Back
Cases for a customer A view of all cases for by customer regardless of status. Must have a BO_ID_CUST.

RC_CASECUST_VW

(SQL View)

Cases for a customer

A view of all cases for by customer regardless of status. Must have a BO_ID_CUST.

SELECT DISTINCT A.BUSINESS_UNIT ,A.BO_ID_CUST , A.BO_ID_CUST , A.BO_ID_CUST , A.CASE_ID , B.BO_NAME FROM PS_RC_CASE A , PS_BO_NAME B WHERE BO_ID_CUST <> 0 AND B.BO_ID=A.BO_ID_CUST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
Prompt Table: BO_NAME_VW1

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

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

6 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
3	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer. Prompt Table: BO_NAME_VW1
4	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
5	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.
6	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object