RI_LIST_VW

(SQL View)
 Index Back

Interaction List

Common Object used by viewing interaction list

SELECT I.INTERACTION_ID ,S.SEQNUM ,S.BO_ID_CUST ,S.ROLE_TYPE_ID_CUST ,C.BO_NAME ,C.BO_NAME_DISPLAY ,C.BO_NAME_AC ,I.BO_ID_CONTACT ,S.ROLE_TYPE_ID_CNTCT ,A.BO_NAME ,A.BO_NAME_DISPLAY ,A.BO_NAME_AC ,S.BO_ID_SITE ,S.SETID_RI ,S.BUSINESS_UNIT_RI ,I.INTERACTION_MTHD ,I.INTERACT_BEGIN ,I.INTERACT_END ,I.RB_MCF_DETAIL_TYPE ,I.INTERACT_STATUS ,I.INTERACT_FLOW ,I.CALLBACK_DATE ,S.SUBINT_OBJ_TYPE ,S.SETID_RI ,S.BUSINESS_UNIT_RI ,S.LEAD_ID ,S.OPPORTUNITY_ID ,S.FULFILLMENT_ID ,S.CASE_ID ,S.EMAILID ,S.SO_ID ,S.RBTACCTID ,S.RBTBILLID ,S.CAPTURE_ID ,S.INST_PROD_ID ,S.NOTES ,S.R_DEFECT_ID ,S.CHANGE_REQUEST_ID ,D.CONVERSION_CODE ,S.RA_CAMPAIGN_ID FROM PS_BO_NAME A ,PS_RI_INTERACTION I , PS_BO_NAME C ,PS_RI_SUB_INTERACT S ,PS_RB_UAD_RI_CATGR D WHERE A.BO_ID = I.BO_ID_CONTACT AND I.INTERACTION_ID = S.INTERACTION_ID(+) AND I.INTERACTION_ID = D.INTERACTION_ID (+) AND S.BO_ID_CUST = C.BO_ID(+)

  • Related Language Record: RI_LIST_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INTERACTION_ID Character(15) VARCHAR2(15) NOT NULL interaction id

    Default Value: NEXT

    2 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    3 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
    4 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
    5 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.
    6 BO_NAME_DISPLAY_1 Character(80) VARCHAR2(80) NOT NULL This field represents the Display Name for a business object
    7 NAME1_AC Character(40) VARCHAR2(40) NOT NULL Name 1 Alternate Char Set
    8 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
    9 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
    10 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
    11 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
    12 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
    13 BO_ID_SITE Number(31,0) DECIMAL(31) NOT NULL Business Object ID
    14 SETID_CUSTOMER Character(5) VARCHAR2(5) NOT NULL Customer SetID
    15 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_FS_NONVW

    16 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
    17 INTERACT_BEGIN DateTime(26) TIMESTAMP begin interaction
    18 INTERACT_END DateTime(26) TIMESTAMP end interaction
    19 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
    20 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

    Prompt Table: RI_STATUS_TBL

    21 INTERACT_FLOW Character(4) VARCHAR2(4) NOT NULL interaction flow
    IN=Inbound
    OUT=Outbound
    22 CALLBACK_DATE DateTime(26) TIMESTAMP Call Back Date
    23 SUBINT_OBJ_TYPE Character(4) VARCHAR2(4) NOT NULL sub-interaction object type
    24 SETID_RI Character(5) VARCHAR2(5) NOT NULL Interactions Setid
    25 BUSINESS_UNIT_RI Character(5) VARCHAR2(5) NOT NULL Business Unit Interactions
    26 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
    27 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID
    28 FULFILLMENT_ID Character(15) VARCHAR2(15) NOT NULL Fulfillment ID
    29 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.
    30 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    31 SO_ID Character(10) VARCHAR2(10) NOT NULL Service Order ID
    32 RBTACCTID Character(15) VARCHAR2(15) NOT NULL Unique service account indentifier
    33 RBTBILLID Character(15) VARCHAR2(15) NOT NULL Bill Id
    34 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.
    35 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
    36 NOTES Long Character CLOB Comments
    37 R_DEFECT_ID Character(15) VARCHAR2(15) NOT NULL Quality Defect Identification key unique by business unit
    38 CHANGE_REQUEST_ID Character(15) VARCHAR2(15) NOT NULL change request identification is key to change request
    39 CONVERSION_CODE Character(4) VARCHAR2(4) NOT NULL Conversion Code

    Prompt Table: RB_UAD_CATG_VW

    40 RA_CAMPAIGN_ID Character(15) VARCHAR2(15) NOT NULL Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id.