RO_RI_CAPTUREVW

(SQL View)
Index Back

Capture Viiew

Tis record is a view contains Capture Id

SELECT CAPTURE_ID , %subrec(RB_RI_OBJ_SBR,PS_RB_RI_OBJ_VW) FROM PS_RB_RI_OBJ_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.
2 INTERACTION_ID Character(15) VARCHAR2(15) NOT NULL interaction id
3 PARENT_INTER_ID Character(15) VARCHAR2(15) NOT NULL Parent Interaction ID....................................
4 ROOT_INTER_ID Character(15) VARCHAR2(15) NOT NULL Root Interaction ID.......................................
5 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
6 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
7 BO_ID_SITE Number(31,0) DECIMAL(31) NOT NULL Business Object ID
8 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
9 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
10 BO_NAME_CONTACT Character(50) VARCHAR2(50) NOT NULL BO_NAME_CONTACT
11 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
12 INTERACTION_MTHD Character(4) VARCHAR2(4) NOT NULL Interaction Method
BOEM=OLM Broadcast Email
ICHT=Inbound Chat
IEML=Inbound Email
IFAX=Inbound Fax
IPHN=Inbound Phone
IWEB=Inbound Web
OBWL=Outbound Worklist Notification
OEML=Outbound Email
OFAX=Outbound Fax
OPHN=Outbound Phone
OPRN=Outbound Print
SMSO=Outbound SMS
SOEM=OLM Single Email
SYNC=Synchronized Email
13 INTERACT_BEGIN DateTime(26) TIMESTAMP begin interaction
14 INTERACT_END DateTime(26) TIMESTAMP end interaction
15 INTERACT_STATUS Character(4) VARCHAR2(4) NOT NULL interaction status
BUSY=Busy
CALL=Callback
CHLD=Child Answered
CMPL=Completed
INPR=In Process
NOAN=No Answer
NOCL=Do Not Call Again
16 INTERACT_FLOW Character(4) VARCHAR2(4) NOT NULL interaction flow
IN=Inbound
OUT=Outbound
17 CALLBACK_DATE DateTime(26) TIMESTAMP Call Back Date
18 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
19 SUBINT_OBJ_TYPE Character(4) VARCHAR2(4) NOT NULL sub-interaction object type
20 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
21 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
22 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
23 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
24 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
25 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
26 NOTES Long Character CLOB Comments