RC_ER_MEMASN_VW(SQL View) |
Index Back |
---|---|
ER Provider Group Case ViewThis 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. |