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 | RB_MCF_DETAIL_TYPE | 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 | RB_MCF_STATUS | Character(4) | VARCHAR2(4) NOT NULL | Interaction status code in multi function |
3 | DESCR_SHORT | Character(30) | VARCHAR2(30) NOT NULL | Description Short |