CONTACT_TD

(SQL View)
 Index Back

Customer Contact Detail


SELECT A.SETID , A.CONTACT_ID , A.CONTACT_FLAG , A.NAME1 , A.TITLE , A.LANGUAGE_PREF , A.SALUTATION , A.AUTHORIZATION_ID FROM PS_CONTACT A WHERE EFF_STATUS = 'A' AND EFFDT = ( SELECT MAX(EFFDT) FROM PS_CONTACT A_ED WHERE A.SETID = A_ED.SETID AND A.CONTACT_ID = A_ED.CONTACT_ID )

  • Related Language Record: CONTACT_TD_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
    3 CONTACT_FLAG Character(1) VARCHAR2(1) NOT NULL An attribute that describes the specific purpose of a given bank/counterparty contact person.
    E=External Contact
    I=Internal Contact
    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    5 TITLE Character(35) VARCHAR2(35) NOT NULL Title
    6 LANGUAGE_PREF Character(3) VARCHAR2(3) NOT NULL Language Code
    CFR=Canadian French
    DAN=Danish
    DUT=Dutch
    ENG=English
    ESP=Spanish
    FRA=French
    GER=German
    GRK=Greek
    ITA=Italian
    JPN=Japanese
    KOR=Korean
    MAY=Bahasa Malay
    POL=Polish
    POR=Portuguese
    SVE=Swedish
    THA=Thai
    ZHS=Simplified Chinese
    ZHT=Traditional Chinese
    7 SALUTATION Character(30) VARCHAR2(30) NOT NULL Salutation
    8 AUTHORIZATION_ID Character(10) VARCHAR2(10) NOT NULL Authorization ID