TR_PE_CONTCT_VW

(SQL View)
Index Back

Bank Contacts Pagelet

Bank Contacts Pagelet

SELECT B.SETID ,B.CONTACT_ID ,B.NAME ,B.CONTACT_TITLE ,B.LOCATION ,B.BANK_CD ,C.BRANCH_NAME ,%subrec(BUS_PHONE_SBR,B) FROM PS_TR_CONTACT_TBL B ,PS_BANK_BRANCH_CNT C WHERE B.SETID = C.SETID AND B.CONTACT_ID = C.CONTACT_ID AND B.BANK_CD=C.BANK_CD

# 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

Default Value: NEXT

3 NAME Character(50) VARCHAR2(50) NOT NULL Name
4 CONTACT_TITLE Character(35) VARCHAR2(35) NOT NULL The professional title for a given bank/counterparty contact person.
5 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

6 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
7 BRANCH_NAME Character(10) VARCHAR2(10) NOT NULL Branch Name
8 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
9 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
10 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
11 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number