SETIDRC_STATUSC=Closed
D=Canceled
H=Case is on hold
O=Case is Open
SDB_STATUS_VW(SQL View) |
Index Back |
|---|---|
Case Status ViewUsed to load case status information to contact center dashboard. |
| SELECT A.SETID , A.RC_STATUS , A.RC_SHORT_DESCR , A.RC_DESCR_SS , A.LONG_DESC , A.STATUS_CATEGORY , B.XLATSHORTNAME , B.XLATLONGNAME FROM PS_RC_STATUS_TBL A , PSXLATITEM B WHERE B.FIELDNAME = 'STATUS_CATEGORY' AND B.FIELDVALUE = A.STATUS_CATEGORY AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PSXLATITEM C WHERE C.FIELDNAME = B.FIELDNAME AND C.FIELDVALUE = B.FIELDVALUE AND C.EFFDT <= %CurrentDateIn AND C.EFF_STATUS = 'A') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 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 |
| 4 | RC_DESCR_SS | Character(30) | VARCHAR2(30) NOT NULL | Description to be shown on Self-Service Pages |
| 5 | LONG_DESC | Character(50) | VARCHAR2(50) NOT NULL | Long Description field. |
| 6 | STATUS_CATEGORY | Character(1) | VARCHAR2(1) NOT NULL |
Categories for Case Status.
These drive processing.
C=Closed D=Canceled H=Case is on hold O=Case is Open |
| 7 | STATUS_CAT_SDESCR | Character(10) | VARCHAR2(10) NOT NULL | Used for contact center dashboard to display status category short description. |
| 8 | STATUS_CAT_LDESCR | Character(30) | VARCHAR2(30) NOT NULL | Used for contact center dashboard to display status category long description. |