RC_ARRIVALWK_VW (SQL View)	Index Back
Case Arrivals A view for populating a chart with Case Arrivals by week.

RC_ARRIVALWK_VW

(SQL View)

Case Arrivals

A view for populating a chart with Case Arrivals by week.

SELECT A.BUSINESS_UNIT , A.PROVIDER_GRP_ID , B.RC_MANAGER , COUNT(DISTINCT A.CASE_ID) , 'Arrivals' , DISP_TMPL_FAM_CD FROM PS_RC_CASE A , PS_RF_PROVIDER_GRP B WHERE A.CREATION_DATE > %DateAdd(%currentdatein , -7) AND B.PROVIDER_GRP_ID = A.PROVIDER_GRP_ID AND B.SETID = ( SELECT C.SETID FROM PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'RF_PROVIDER_GRP') GROUP BY A.BUSINESS_UNIT, A.PROVIDER_GRP_ID, B.RC_MANAGER, 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 RC_MANAGER Character(15) VARCHAR2(15) NOT NULL Call Center Manager. Used in call center business unit setup.

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

5 CASE_ARRIVALS Character(10) VARCHAR2(10) NOT NULL Contains the string 'Arrivals' for use with charting.

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	RC_MANAGER	Character(15)	VARCHAR2(15) NOT NULL	Call Center Manager. Used in call center business unit setup.
4	RC_CASE_COUNT	Number(7,0)	INTEGER NOT NULL	Case Count
5	CASE_ARRIVALS	Character(10)	VARCHAR2(10) NOT NULL	Contains the string 'Arrivals' for use with charting.
6	DISP_TMPL_FAM_CD	Character(30)	VARCHAR2(30) NOT NULL	Display Template Family Code