PNA_BANK_VW

(SQL View)
 Index Back

Bank Table

Main Bank Table containing bank name and address

SELECT COUNTRY_CD , BANK_CD , EFF_STATUS , BANK_NM , DESCRSHORT , COUNTRY , ADDRESS1 , ADDRESS2 , CITY , STATE , POSTAL FROM PS_BANK_EC_TBL WHERE EFF_STATUS = 'A'

# 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 BANK_NM Character(40) VARCHAR2(40) NOT NULL Bank Name
5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
6 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

7 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
8 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
9 CITY Character(30) VARCHAR2(30) NOT NULL City
10 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

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