RB_RI_CASE_VW

(SQL View)
 Index Back

SELECT CASE_ID , BUSINESS_UNIT_RI , INTERACTION_ID , PARENT_INTER_ID , ROOT_INTER_ID , BO_ID_CONTACT , BO_ID_CUST , BO_ID_SITE , ROLE_TYPE_ID_CNTCT , ROLE_TYPE_ID_CUST , BO_NAME_CONTACT , RB_MCF_DETAIL_TYPE , INTERACTION_MTHD , INTERACT_BEGIN , INTERACT_END , INTERACT_STATUS , INTERACT_FLOW , CALLBACK_DATE , SEQNUM , SUBINT_OBJ_TYPE ,%subrec(RB_AUDIT_SBR, PS_RB_RI_OBJ_VW) , NOTES FROM PS_RB_RI_OBJ_VW WHERE SUBINT_OBJ_TYPE = 'CASE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
2 BUSINESS_UNIT_RI Character(5) VARCHAR2(5) NOT NULL Business Unit Interactions
3 INTERACTION_ID Character(15) VARCHAR2(15) NOT NULL interaction id
4 PARENT_INTER_ID Character(15) VARCHAR2(15) NOT NULL Parent Interaction ID....................................
5 ROOT_INTER_ID Character(15) VARCHAR2(15) NOT NULL Root Interaction ID.......................................
6 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
7 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
8 BO_ID_SITE Number(31,0) DECIMAL(31) NOT NULL Business Object ID
9 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
10 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
11 BO_NAME_CONTACT Character(50) VARCHAR2(50) NOT NULL BO_NAME_CONTACT
12 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
13 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
14 INTERACT_BEGIN DateTime(26) TIMESTAMP begin interaction
15 INTERACT_END DateTime(26) TIMESTAMP end interaction
16 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
17 INTERACT_FLOW Character(4) VARCHAR2(4) NOT NULL interaction flow
IN=Inbound
OUT=Outbound
18 CALLBACK_DATE DateTime(26) TIMESTAMP Call Back Date
19 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
20 SUBINT_OBJ_TYPE Character(4) VARCHAR2(4) NOT NULL sub-interaction object type
21 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
22 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
23 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
24 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
25 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.
26 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
27 NOTES Long Character CLOB Comments