RC_SLARED_VW

(SQL View)
 Index Back

Red SLA

Number of Cases in an SLA status of red for a customer contact for one day.

SELECT A.BUSINESS_UNIT , A.BO_ID_CUST ,A.BO_ID_CONTACT , B.BO_NAME , COUNT(DISTINCT A.CASE_ID) , 'Red' FROM PS_RC_CASE A , PS_BO_NAME B , PS_RC_STATUS_TBL C , PS_SET_CNTRL_TBL D WHERE A.RC_RED_DTTM < %CurrentDateTimeIn AND D.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RC_STATUS = A.RC_STATUS AND C.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE = A.BUSINESS_UNIT AND D.RECNAME = 'RC_STATUS_TBL') AND C.STATUS_CATEGORY = 'O' AND A.BO_ID_CUST <> 0 AND A.BO_ID_CUST = B.BO_ID GROUP BY A.BUSINESS_UNIT, A.BO_ID_CUST,A.BO_ID_CONTACT, B.BO_NAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
3 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
4 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
5 RC_CASE_COUNT Number(7,0) INTEGER NOT NULL Case Count
6 SLA_RESTORE Character(4) VARCHAR2(4) NOT NULL Field used for SLA charts. Shows whether SLA commitment was met or missed for a customer.
MET=Met
MISS=Missed