CTI_TRANS_VW

(SQL View)
 Index Back

View into CTI_TRANS

Used to find all transactions that are not mapped to content providers.

SELECT CTI_TRANSACTION ,DESCR , CTI_ACTION FROM PS_CTI_PS_ACTIONS WHERE FOREIGN_TRANS = 'N'

  • Related Language Record: CTI_PS_ACT_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CTI_TRANSACTION Character(5) VARCHAR2(5) NOT NULL The CTI transaction for this unit of work.
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 CTI_ACTION Character(1) VARCHAR2(1) NOT NULL Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration
    A=Add
    U=Update/Inquiry