RC_SLACUSTOC_VW

(SQL View)
 Index Back

Open Case SLA Status

A view showing the SLA status for a given customer's open cases.

SELECT BUSINESS_UNIT , BO_ID_CUST , BO_NAME , RC_CASE_COUNT , SLA_RESTORE FROM PS_RC_SLAGREENC_VW UNION SELECT BUSINESS_UNIT , BO_ID_CUST , BO_NAME , RC_CASE_COUNT , SLA_RESTORE FROM PS_RC_SLAYELOWC_VW UNION SELECT BUSINESS_UNIT , BO_ID_CUST , BO_NAME , RC_CASE_COUNT , SLA_RESTORE FROM PS_RC_SLAREDC_VW

# 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