COUNTRY_CDBANK_ID_CODESSF_BIC_VW(SQL View) |
Index Back |
|---|
| SELECT A.COUNTRY_CD ,A.BANK_ID_CODE ,A.BANK_CD ,A.BANK_NM ,' ' ,' ' FROM PS_BANK_EC_TBL A WHERE A.BANK_ID_CODE <> ' ' UNION SELECT B.COUNTRY_CD ,B.BANK_ID_CODE ,B.BANK_CD ,C.BANK_NM ,B.BRANCH_EC_CD ,B.DESCR FROM PS_BANK_BRANCH_TBL B , PS_BANK_EC_TBL C WHERE B.BANK_CD = C.BANK_CD AND B.BANK_ID_CODE <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Country Code |
| 2 | BANK_ID_CODE |
Character(11) | VARCHAR2(11) NOT NULL | Bank Identifier Code |
| 3 | BANK_CD | Character(11) | VARCHAR2(11) NOT NULL | Bank ID |
| 4 | BANK_NM | Character(40) | VARCHAR2(40) NOT NULL | Bank Name |
| 5 | BRANCH_EC_CD | Character(17) | VARCHAR2(17) NOT NULL | Bank Branch ID |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |