BANK_CNTCT_VW

(SQL View)
Index Back

Bank Contact Prompt View


select A.SETID, A.BANK_CD, A.CONTACT_ID, A.NAME, A.CONTACT_TITLE, B.DESCR from PS_TR_CONTACT_TBL A, PS_BANK_CD_TBL B where A.SETID = B.SETID and A.BANK_CD = B.BANK_CD

  • Related Language Record: BANK_CNTCT_LG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    3 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
    4 NAME Character(50) VARCHAR2(50) NOT NULL Name
    5 CONTACT_TITLE Character(35) VARCHAR2(35) NOT NULL The professional title for a given bank/counterparty contact person.
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description