RC_MYSLAGRN_VW (SQL View)	Index Back
Agent Green SLA Number of Cases in green SLA status for an agent by priority.

RC_MYSLAGRN_VW

(SQL View)

Agent Green SLA

Number of Cases in green SLA status for an agent by priority.

SELECT BUSINESS_UNIT , ASSIGNED_TO , RC_PRIORITY , RC_SHORT_DESCR1 , COUNT(DISTINCT (CASE_ID)) , 'Green' ,DISP_TMPL_FAM_CD FROM PS_RC_MYCASE_VW WHERE RC_YELLOW_DTTM > %CurrentDateTimeIn AND RC_PRIORITY <> ' ' GROUP BY BUSINESS_UNIT, ASSIGNED_TO, RC_PRIORITY, RC_SHORT_DESCR1, 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_PRIORITY Character(5) VARCHAR2(5) NOT NULL Case Priority

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_PRIORITY	Character(5)	VARCHAR2(5) NOT NULL	Case Priority
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