RC_CUST_SRCH_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_CUST_SRCH_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 BUSINESS_UNIT , BO_ID_CUST FROM PS_RC_CASE WHERE BO_ID_CUST <> 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	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