RC_CASESTAT_VW(SQL View) |
Index Back |
|---|---|
View for cases status valuesCase Status view keyed by Business Unit and Status code. |
| SELECT A.BUSINESS_UNIT ,A.RC_STATUS ,B.RC_SHORT_DESCR FROM PS_RC_CASE A , PS_RC_STATUS_TBL B WHERE A.RC_STATUS=B.RC_STATUS AND B.SETID=( SELECT C.SETID FROM PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.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 | RC_STATUS | Character(5) | VARCHAR2(5) NOT NULL | Case Status |
| 3 | RC_SHORT_DESCR | Character(20) | VARCHAR2(20) NOT NULL | Short Description. Used on may CallCenter set-up tables |