RIT_INT_SUBI_VW

(SQL View)
 Index Back

Interaction view

Outer Join between Interaction and sub interaction used in 360-degree view. Used as a Dynamic Grid View.

SELECT S.BO_ID_CUST ,S.ROLE_TYPE_ID_CUST ,A.BO_ID_CONTACT ,S.ROLE_TYPE_ID_CNTCT ,S.BO_ID_SITE ,A.INTERACTION_ID ,A.INTERACT_BEGIN ,to_char(A.INTERACT_BEGIN ,'YYYY-MM-DD-HH24.MI.SS') ,A.INTERACT_STATUS ,B.DESCR_SHORT ,A.INTERACTION_MTHD ,D.XLATLONGNAME ,A.RB_MCF_DETAIL_TYPE ,A.SETID_CUSTOMER ,A.BUSINESS_UNIT ,A.INTERACT_END ,A.INTERACT_FLOW ,A.CALLBACK_DATE ,' ' ,S.NOTES , S.SEQNUM ,S.SUBINT_OBJ_TYPE ,0 ,0 ,0 ,0 ,%subrec(RB_AUDIT_SBR, A) FROM PS_RI_INTERACTION A , PS_RI_SUB_INTERACT S , PSXLATITEM D , PS_RI_STATUS_TBL B WHERE B.RB_MCF_STATUS = A.INTERACT_STATUS AND B.RB_MCF_DETAIL_TYPE = A.RB_MCF_DETAIL_TYPE AND A.INTERACTION_ID (+) = S.INTERACTION_ID AND D.FIELDVALUE (+) = A.INTERACTION_MTHD AND D.FIELDNAME (+) = 'INTERACTION_MTHD' AND D.EFF_STATUS (+) = 'A' AND D.EFFDT (+) <= TO_DATE ( TO_CHAR ( SYSDATE , 'YYYY-MM-DD'), 'YYYY-MM-DD' )

  • Related Language Record: RIT_INT_SUBILVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
    2 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
    3 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
    4 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
    5 BO_ID_SITE Number(31,0) DECIMAL(31) NOT NULL Business Object ID
    6 INTERACTION_ID Character(15) VARCHAR2(15) NOT NULL interaction id
    7 INTERACT_BEGIN DateTime(26) TIMESTAMP begin interaction
    8 INTERACT_BEGIN_CH Character(20) VARCHAR2(20) NOT NULL Interaction Start date & time
    9 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
    10 DESCR_SHORT Character(30) VARCHAR2(30) NOT NULL Description Short
    11 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
    12 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    13 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
    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 INTERACT_END DateTime(26) TIMESTAMP end interaction
    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 DATE_CRITERIA Character(4) VARCHAR2(4) NOT NULL Date Criteria
    A=7 - View All
    D0=1 - Today
    D1=2 - Yesterday
    D15=4 - Last 2 Weeks
    D17=3 - Last Week
    D30=5 - Last Month
    Y1=6 - Last Year
    20 NOTES Long Character CLOB Comments
    21 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    22 SUBINT_OBJ_TYPE Character(4) VARCHAR2(4) NOT NULL sub-interaction object type
    23 BO_ID_PARTNER Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID of Partner Company.
    24 ROLE_TYPE_ID_PART Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the partner
    25 BO_ID_PART_CONT Signed Number(32,0) DECIMAL(31) NOT NULL This is the business object identifier for the partner contact.
    26 ROLE_TYPE_ID_PARTC Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the partner contact
    27 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    28 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    29 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    30 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    31 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.
    32 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time