SDB_I_STATUS_VW

(SQL View)
Index Back

Email Status View

Email 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