SDB_I_STATUS_VW(SQL View) |
Index Back |
|---|---|
Email Status ViewEmail Status View used in Contact Center Dashboard. |
| SELECT RB_MCF_DETAIL_TYPE , RB_MCF_STATUS , DESCR_SHORT FROM PS_RI_STATUS_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(4) | VARCHAR2(4) NOT NULL |
MCF Detail Type indicating the Detail component to be associated with an interaction
CHAT=Chat CM=Printer CMEM=Outbound Email IBEM=Inbound Email NONE=Phone OMEM=OLM Outbound Email SMSO=Outbound SMS SS=Self Service SYNC=Synchronized Email |
|
| 2 | Character(4) | VARCHAR2(4) NOT NULL | Interaction status code in multi function | |
| 3 | DESCR_SHORT | Character(30) | VARCHAR2(30) NOT NULL | Description Short |