RIT_INT_SUBILVW

(SQL View)
 Index Back

Sub Interaction View

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

SELECT A.BO_ID_CUST ,A.ROLE_TYPE_ID_CUST ,A.BO_ID_CONTACT ,A.ROLE_TYPE_ID_CNTCT ,A.BO_ID_SITE ,A.INTERACTION_ID ,B.LANGUAGE_CD ,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 LEFT OUTER JOIN PS_RI_SUB_INTERACT S ON A.INTERACTION_ID = S.INTERACTION_ID LEFT OUTER JOIN PSXLATITEMLANG D ON D.FIELDVALUE = A.INTERACTION_MTHD AND D.FIELDNAME = 'INTERACTION_MTHD' , PS_RI_STATUS_LANG B WHERE B.RB_MCF_STATUS = A.INTERACT_STATUS AND B.RB_MCF_DETAIL_TYPE = A.RB_MCF_DETAIL_TYPE

  • Related Language Record for RIT_INT_SUBI_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 INTERACT_BEGIN DateTime(26) TIMESTAMP begin interaction
    9 INTERACT_BEGIN_CH Character(20) VARCHAR2(20) NOT NULL Interaction Start date & time
    10 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

    11 DESCR_SHORT Character(30) VARCHAR2(30) NOT NULL Description Short
    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 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    14 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
    15 SETID_CUSTOMER Character(5) VARCHAR2(5) NOT NULL Customer SetID
    16 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_FS_NONVW

    17 INTERACT_END DateTime(26) TIMESTAMP end interaction
    18 INTERACT_FLOW Character(4) VARCHAR2(4) NOT NULL interaction flow
    IN=Inbound
    OUT=Outbound
    19 CALLBACK_DATE DateTime(26) TIMESTAMP Call Back Date
    20 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
    21 NOTES Long Character CLOB Comments
    22 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    23 SUBINT_OBJ_TYPE Character(4) VARCHAR2(4) NOT NULL sub-interaction object type
    24 BO_ID_PARTNER Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID of Partner Company.
    25 ROLE_TYPE_ID_PART Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the partner
    26 BO_ID_PART_CONT Signed Number(32,0) DECIMAL(31) NOT NULL This is the business object identifier for the partner contact.
    27 ROLE_TYPE_ID_PARTC Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the partner contact
    28 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    29 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    30 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    31 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    32 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.
    33 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time