CAN_BANK_VW

(SQL View)
 Index Back

CAN Bank Table view

Used to retrieve Bank Branch Table containing bank name and address

SELECT A.COUNTRY_CD , A.BANK_CD , A.EFF_STATUS , A.DESCRSHORT , A.COUNTRY , A.ADDRESS1 , A.CITY , A.STATE , A.POSTAL FROM PS_BANK_EC_TBL A WHERE A.EFF_STATUS = 'A' AND A.COUNTRY_CD = 'CAN'

  • Related Language Record: CAN_BANK_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Country Code

    Prompt Table: COUNTRY1_VW

    2 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID
    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR_BANKNAME Character(10) VARCHAR2(10) NOT NULL description for the bank name coming from prompt table
    5 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    6 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    7 CITY Character(30) VARCHAR2(30) NOT NULL City
    8 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province

    Prompt Table: STATE_TBL

    9 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal