RF_SO_CASE_VW (SQL View)	Index Back
Service Order Case View This is the view that returns the cases associated with a service order customer.

RF_SO_CASE_VW

(SQL View)

Service Order Case View

This is the view that returns the cases associated with a service order customer.

SELECT A.CASE_ID , B.BO_NAME FROM PS_RC_CASE A , PS_BO_NAME_PRIM_VW B WHERE A.BO_ID_CUST = B.BO_ID

# 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 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

#	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	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object