RC_SLACUSTD_VW (SQL View)	Index Back
Customer SLA by Day A view of SLA performance for a given customer for the last day.

RC_SLACUSTD_VW

(SQL View)

Customer SLA by Day

A view of SLA performance for a given customer for the last day.

SELECT BUSINESS_UNIT , BO_ID_CUST , SLA_RESTORE , BO_NAME , RC_CASE_COUNT FROM PS_RC_SLAMETD_VW UNION SELECT BUSINESS_UNIT , BO_ID_CUST , SLA_RESTORE , BO_NAME , RC_CASE_COUNT FROM PS_RC_SLAMISSD_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 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

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

#	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	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
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