RC_ER_MEMASN_VW

(SQL View)
Index Back

ER Provider Group Case View

This view is used to show ER cases assigned to a Provider Group.

SELECT A.BUSINESS_UNIT ,A.CASE_ID ,A.RC_STATUS ,A.RC_PRIORITY ,A.RC_SEVERITY ,C.RC_ER_ASSIGNED_TO ,C.RC_PROVIDER_GRP_ID ,B.SETID FROM PS_RC_CASE A ,PS_RC_STATUS_TBL B ,PS_RC_CASE_ASSIGN C WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.CASE_ID = C.CASE_ID AND C.RC_ASSIGNMENT_TYPE='G' AND C.START_DATE <=%CurrentDateIn AND (C.END_DATE IS NULL OR C.END_DATE >=%CurrentDateIn) AND B.RC_STATUS = A.RC_STATUS AND B.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE = A.BUSINESS_UNIT AND D.RECNAME = 'RC_STATUS_TBL')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
3 RC_STATUS Character(5) VARCHAR2(5) NOT NULL Case Status
4 RC_PRIORITY Character(5) VARCHAR2(5) NOT NULL Case Priority
5 RC_SEVERITY Character(5) VARCHAR2(5) NOT NULL Case severity
6 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
7 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.
8 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.