RC_CASE_ASSO_VW

(SQL View)
 Index Back

Case Association

People associated with a case, including owers and customers

SELECT C.BUSINESS_UNIT , C.CASE_ID , 'M' , C.BO_ID_CUST , O.OPRID , 'CASESEC:' %Concat C.BUSINESS_UNIT %Concat C.CASE_VISIBILITY %Concat O.OPRID , N.BO_NAME_DISPLAY FROM PS_RC_CASE C , PS_RC_OPR_BO_ID_VW O , PS_BO_NAME N WHERE C.BO_ID_CUST <> 0 AND C.BO_ID_CUST = O.BO_ID AND (C.BO_ID_CUST = N.BO_ID AND N.PRIMARY_IND = 'Y') UNION SELECT C.BUSINESS_UNIT , C.CASE_ID , 'R' , C.BO_ID_REPORTED_BY , O.OPRID , 'CASESEC:' %Concat C.BUSINESS_UNIT %Concat C.CASE_VISIBILITY %Concat O.OPRID , N.BO_NAME_DISPLAY FROM PS_RC_CASE C , PS_RC_OPR_BO_ID_VW O , PS_BO_NAME N WHERE C.BO_ID_REPORTED_BY <> 0 AND C.BO_ID_REPORTED_BY <> C. BO_ID_CUST AND C.BO_ID_REPORTED_BY = O.BO_ID AND (C.BO_ID_REPORTED_BY = N.BO_ID AND N.PRIMARY_IND = 'Y') UNION SELECT I.BUSINESS_UNIT , I.CASE_ID , 'I' , O.BO_ID , O.OPRID , 'CASESEC:' %Concat I.BUSINESS_UNIT %Concat C.CASE_VISIBILITY %Concat O.OPRID , N.BO_NAME_DISPLAY FROM PS_RC_CASE C , PS_RC_INTEREST_PRT I , PS_RC_OPR_BO_ID_VW O , PS_BO_NAME N WHERE C.CASE_ID = I.CASE_ID AND C.BUSINESS_UNIT = I.BUSINESS_UNIT AND I.PERSON_ID = O.PERSON_ID AND O.BO_ID <> 0 AND (O.BO_ID = N.BO_ID AND N.PRIMARY_IND = 'Y') UNION SELECT C.BUSINESS_UNIT , C.CASE_ID , 'C' , C.BO_ID_CONTACT , O.OPRID , 'CASESEC:' %Concat C.BUSINESS_UNIT %Concat C.CASE_VISIBILITY %Concat O.OPRID , N.BO_NAME_DISPLAY FROM PS_RC_CASE C , PS_RC_OPR_BO_ID_VW O , PS_BO_NAME N WHERE C.BO_ID_CONTACT <> 0 AND C.BO_ID_CONTACT = O.BO_ID AND (C.BO_ID_CONTACT = N.BO_ID AND N.PRIMARY_IND = 'Y') UNION SELECT C.BUSINESS_UNIT , C.CASE_ID , 'K' , 0 , ' ' , 'CASESEC:' %Concat C.BUSINESS_UNIT %Concat 'KNOWNISSUE' , ' ' FROM PS_RC_CASE C WHERE C.GLOBAL_FLAG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
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 RC_SRCH_FCT_ASSOC Character(1) VARCHAR2(1) NOT NULL Search Facet Association
C=Contacted For
I=Interested In
K=Known Issue
M=My Cases
R=Reported by Me
4 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
5 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
6 CASE_SRCH_SECID Character(30) VARCHAR2(30) NOT NULL Search security - security based on Case Association
7 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object