RD_CALLRPT_TX_V

(SQL View)
 Index Back

Call Report Trans ID view

View of Transaction (Component Navigation) IDs that can be linked to a Call Report 12/04/2012: Removed PARTNER TransactionId as it is deprecated

SELECT T.RB_TRANSACTION_ID , TM.TRANSACTION_TITLE FROM PS_RB_TXN_DEFN T , PS_RB_TXN_MKT TM WHERE T.RB_TRANSACTION_ID = TM.RB_TRANSACTION_ID AND T.RB_TRANSACTION_ID IN ('LEAD', 'REFERRAL', 'OPPRT', 'COMPANY') AND TM.MARKET = 'GBL'

  • Related Language Record: RD_CR_TX_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RB_TRANSACTION_ID Character(25) VARCHAR2(25) NOT NULL Transaction ID
    2 TRANSACTION_TITLE Character(30) VARCHAR2(30) NOT NULL Transaction Title