RC_SLACUSTWC_VW (SQL View)	Index Back
SLA Performance by Week A view showing the SLA performance for cases closed in the last week for a company contact.

RC_SLACUSTWC_VW

(SQL View)

SLA Performance by Week

A view showing the SLA performance for cases closed in the last week for a company contact.

SELECT BUSINESS_UNIT , BO_ID_CUST ,BO_ID_CONTACT , SLA_RESTORE , BO_NAME , RC_CASE_COUNT FROM PS_RC_SLAMETWC_VW UNION SELECT BUSINESS_UNIT , BO_ID_CUST ,BO_ID_CONTACT , SLA_RESTORE , BO_NAME , RC_CASE_COUNT FROM PS_RC_SLAMISSWC_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_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

4 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

5 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

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	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
4	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
5	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
6	RC_CASE_COUNT	Number(7,0)	INTEGER NOT NULL	Case Count