RC_SLAEXCEED_VW (SQL View)	Index Back
Missed SLA A view of business units that have cases with a missed SLA.

RC_SLAEXCEED_VW

(SQL View)

Missed SLA

A view of business units that have cases with a missed SLA.

SELECT DISTINCT BUSINESS_UNIT , DISP_TMPL_FAM_CD FROM PS_RC_CASE WHERE %CurrentDateTimeIn > RC_RED_DTTM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_FS_NONVW

2 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 Prompt Table: SP_BU_FS_NONVW
2	DISP_TMPL_FAM_CD	Character(30)	VARCHAR2(30) NOT NULL	Display Template Family Code