RI_SUB_INT_LVW

(SQL View)
Index Back

Sub Interaction View

Language view: Sub Interaction View used to populate subinteractions in related grid.

SELECT b.BO_ID_CUST ,CASE WHEN b.ROLE_TYPE_ID_CUST = 42 THEN 2 WHEN b.ROLE_TYPE_ID_CUST = 46 THEN 9 ELSE b.ROLE_TYPE_ID_CUST END , a.BO_ID_CONTACT ,b.ROLE_TYPE_ID_CNTCT ,b.BO_ID_SITE ,b.INTERACTION_ID ,b.SEQNUM ,L.LANGUAGE_CD ,b.SUBINT_OBJ_TYPE ,b.NOTES ,a.INTERACT_STATUS ,b.INTERACT_BEGIN ,L.DESCR_SHORT ,0 ,0 ,0 ,0 , %subrec(RB_AUDIT_SBR, b) FROM PS_RI_INTERACTION a , PS_RI_SUB_INTERACT b , PS_RI_STATUS_LANG L WHERE a.INTERACTION_ID = b.INTERACTION_ID AND L.RB_MCF_STATUS = a.INTERACT_STATUS AND L.RB_MCF_DETAIL_TYPE = a.RB_MCF_DETAIL_TYPE

  • Related Language Record for RI_SUB_INT_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 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    8 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 SUBINT_OBJ_TYPE Character(4) VARCHAR2(4) NOT NULL sub-interaction object type
    10 NOTES Long Character CLOB Budget Notes
    11 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
    12 INTERACT_BEGIN DateTime(26) TIMESTAMP begin interaction
    13 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    14 BO_ID_PARTNER Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID of Partner Company.
    15 ROLE_TYPE_ID_PART Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the partner
    16 BO_ID_PART_CONT Signed Number(32,0) DECIMAL(31) NOT NULL This is the business object identifier for the partner contact.
    17 ROLE_TYPE_ID_PARTC Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the partner contact
    18 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    19 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    20 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    21 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    22 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.
    23 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time