RF_CASESETID_VW (SQL View)	Index Back
Service Order Case View This is the service order case prompt view based on the service order customer.

RF_CASESETID_VW

(SQL View)

Service Order Case View

This is the service order case prompt view based on the service order customer.

SELECT DISTINCT A.BO_ID_CUST , A.CASE_ID , A.BUSINESS_UNIT , C.CUST_ID , D.BO_NAME_DISPLAY , D.BO_NAME_AC , E.STATUS_CATEGORY FROM PS_RC_CASE A , PS_SET_CNTRL_REC B , PS_BC C , PS_BO_NAME D , PS_RC_STATUS_TBL E WHERE B.RECNAME = 'BC' AND A.BO_ID_CUST = C.BO_ID(+) AND D.BO_ID = A.BO_ID_CUST AND E.RC_STATUS = A.RC_STATUS AND A.RC_VERTICAL= 'SW' AND D.PRIMARY_IND = 'Y' AND E.SETID = ( SELECT F.SETID FROM PS_SET_CNTRL_REC F WHERE F.SETCNTRLVALUE = A.BUSINESS_UNIT AND F.RECNAME = 'RC_STATUS_TBL')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

4 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID

5 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

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

7 STATUS_CATEGORY Character(1) VARCHAR2(1) NOT NULL Categories for Case Status. These drive processing.
C=Closed
D=Canceled
H=Case is on hold
O=Case is Open

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID
5	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
6	BO_NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
7	STATUS_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Categories for Case Status. These drive processing. C=Closed D=Canceled H=Case is on hold O=Case is Open