RC_MYSLAYELS_VW (SQL View)	Index Back
My SLA Status Number of yellow cases assigned to an agent grouped by status.

RC_MYSLAYELS_VW

(SQL View)

My SLA Status

Number of yellow cases assigned to an agent grouped by status.

SELECT BUSINESS_UNIT , ASSIGNED_TO , RC_STATUS ,RC_SHORT_DESCR , COUNT(DISTINCT CASE_ID) , 'Yellow' , DISP_TMPL_FAM_CD FROM PS_RC_MYCASE_VW WHERE RC_YELLOW_DTTM <= %CurrentDateTimeIn AND RC_RED_DTTM > %CurrentDateTimeIn GROUP BY BUSINESS_UNIT, ASSIGNED_TO, RC_STATUS,RC_SHORT_DESCR, DISP_TMPL_FAM_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.

3 RC_STATUS Character(5) VARCHAR2(5) NOT NULL Case Status

4 RC_SHORT_DESCR Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables

5 RC_CASE_COUNT Number(7,0) INTEGER NOT NULL Case Count

6 SLA_COLOR Character(6) VARCHAR2(6) NOT NULL SLA Color - can be red, green or yellow depending on how close the case is to missing the required restore time goal per the service level agreement.

7 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	ASSIGNED_TO	Character(15)	VARCHAR2(15) NOT NULL	This is a field to store assignment information.
3	RC_STATUS	Character(5)	VARCHAR2(5) NOT NULL	Case Status
4	RC_SHORT_DESCR	Character(20)	VARCHAR2(20) NOT NULL	Short Description. Used on may CallCenter set-up tables
5	RC_CASE_COUNT	Number(7,0)	INTEGER NOT NULL	Case Count
6	SLA_COLOR	Character(6)	VARCHAR2(6) NOT NULL	SLA Color - can be red, green or yellow depending on how close the case is to missing the required restore time goal per the service level agreement.
7	DISP_TMPL_FAM_CD	Character(30)	VARCHAR2(30) NOT NULL	Display Template Family Code