BUSINESS_UNITCASE_IDRF_CASE_ASGN_VW(SQL View) |
Index Back |
|---|---|
Provider Group Case ViewThis view is used to show cases assigned to a Provider Group. |
| SELECT A.BUSINESS_UNIT ,A.CASE_ID ,A.RC_STATUS ,A.RC_PRIORITY ,A.RC_SEVERITY ,A.ASSIGNED_TO ,PROVIDER_GRP_ID ,B.SETID FROM PS_RC_CASE A ,PS_RC_STATUS_TBL B WHERE B.RC_STATUS = A.RC_STATUS AND B.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'RC_STATUS_TBL') AND B.STATUS_CATEGORY = 'O' |
| # | 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. |