RC_SLAPGSTAT_VW (SQL View)	Index Back
Missed SLA by Status Number of cases that have missed their SLA by provider group and status.

RC_SLAPGSTAT_VW

(SQL View)

Missed SLA by Status

Number of cases that have missed their SLA by provider group and status.

SELECT A.BUSINESS_UNIT , A.PROVIDER_GRP_ID , B.NAME1 , COUNT(DISTINCT A.CASE_ID) , A.RC_STATUS ,A.DISP_TMPL_FAM_CD FROM PS_RC_CASE A , PS_RF_PROVIDER_GRP B , PS_SET_CNTRL_REC C WHERE %CurrentDateTimeIn > A.RC_RED_DTTM AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'RF_PROVIDER_GRP' AND B.SETID = C.SETID AND A.PROVIDER_GRP_ID = B.PROVIDER_GRP_ID GROUP BY A.BUSINESS_UNIT, A.PROVIDER_GRP_ID, B.NAME1, A.RC_STATUS, A.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 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.

3 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.

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

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

6 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	PROVIDER_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Identification number for the provider group.
3	NAME1	Character(50)	VARCHAR2(50) NOT NULL	Generic 50 character name field for storing names.
4	RC_CASE_COUNT	Number(7,0)	INTEGER NOT NULL	Case Count
5	RC_STATUS	Character(5)	VARCHAR2(5) NOT NULL	Case Status
6	DISP_TMPL_FAM_CD	Character(30)	VARCHAR2(30) NOT NULL	Display Template Family Code