RC_SA_CASEID_VW (SQL View)	Index Back
Solution Advisor Case by ID A view showing Case keyed by Case_ID in order to facilitate Related Display functionality.

RC_SA_CASEID_VW

(SQL View)

Solution Advisor Case by ID

A view showing Case keyed by Case_ID in order to facilitate Related Display functionality.

SELECT CASE_ID , BUSINESS_UNIT , BO_ID_CUST , RC_SUMMARY , BO_ID_CONTACT , RC_STATUS FROM PS_RC_CASE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
4	RC_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Typically a summary of a long field.
5	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
6	RC_STATUS	Character(5)	VARCHAR2(5) NOT NULL	Case Status