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.

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