RI_LIST_LVW

(SQL View)
 Index Back

Interaction List

Common Object used by viewing interaction list

SELECT I.INTERACTION_ID ,SL.SEQNUM ,SL.LANGUAGE_CD ,SL.NOTES FROM PS_RI_SUB_INT_LNG SL ,PS_RI_INTERACTION I WHERE SL.INTERACTION_ID = I.INTERACTION_ID

  • Related Language Record for RI_LIST_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 NOTES Long Character CLOB Comments