RC_SLACUSTQ_VW (SQL View)	Index Back
SLA Past Performance A view showing the SLA performance on closed cases for a given customer.

RC_SLACUSTQ_VW

(SQL View)

SLA Past Performance

A view showing the SLA performance on closed cases for a given customer.

SELECT BUSINESS_UNIT , BO_ID_CUST , SLA_RESTORE , BO_NAME , BO_NAME , RC_CASE_COUNT FROM PS_RC_SLAMETM_VW UNION SELECT BUSINESS_UNIT , BO_ID_CUST , SLA_RESTORE , BO_NAME , BO_NAME , RC_CASE_COUNT FROM PS_RC_SLAMISSM_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 RB_TD_DESC60 Character(60) VARCHAR2(60) NOT NULL Description field to hold 60 characters

6 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	RB_TD_DESC60	Character(60)	VARCHAR2(60) NOT NULL	Description field to hold 60 characters
6	RC_CASE_COUNT	Number(7,0)	INTEGER NOT NULL	Case Count