RC_SLAMISS_VW

(SQL View)
 Index Back

Missed SLA

Number of Cases that missed the SLA for a customer.

SELECT A.BUSINESS_UNIT , A.BO_ID_CUST , B.BO_NAME , COUNT(DISTINCT A.CASE_ID) , 'Miss' FROM PS_RC_CASE A , PS_BO_NAME B WHERE A.RC_REST_IND = 'N' AND A.BO_ID_CUST <> 0 AND A.BO_ID_CUST = B.BO_ID GROUP BY A.BUSINESS_UNIT, A.BO_ID_CUST, 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_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
4 RC_CASE_COUNT Number(7,0) INTEGER NOT NULL Case Count
5 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