BANK_ACCT_SBRVW

(SQL View)
 Index Back

View to populate bank account

View to populate bank account sub-record

SELECT A.SETID ,A.BANK_CD ,A.BANK_CD_CPTY ,A.BANK_ACCT_KEY ,B.BANK_ID_QUAL ,B.BNK_ID_NBR ,C.BRANCH_ID ,A.BANK_ACCT_TYPE ,A.BANK_ACCOUNT_NUM ,A.CHECK_DIGIT ,A.DFI_ID_QUAL ,A.DFI_ID_NUM ,B.DESCR AS BANK_NAME ,B.DESCR_AC AS BANK_NAME_AC ,B.COUNTRY ,B.ADDRESS1 ,B.ADDRESS2 ,B.ADDRESS3 ,B.ADDRESS4 ,B.CITY ,B.NUM1 ,B.NUM2 ,B.HOUSE_TYPE ,B.ADDR_FIELD1 ,B.ADDR_FIELD2 ,B.ADDR_FIELD3 ,B.COUNTY ,B.STATE ,B.POSTAL ,B.GEO_CODE ,B.IN_CITY_LIMIT ,B.COUNTRY_CODE ,B.PHONE ,B.EXTENSION ,B.FAX ,A.IBAN_CHECK_DIGIT ,A.IBAN_ID ,A.CURRENCY_CD ,A.PREFERRED_LANGUAGE ,C.DESCR AS BRANCH_DESCR ,C.DESCR_AC AS BRANCH_NAME_AC FROM PS_BANK_ACCT_DEFN A , PS_BANK_CD_TBL B , PS_BANK_BRANCH_TBL C WHERE A.SETID = B.SETID AND A.BANK_CD = B.BANK_CD AND A.SETID = C.SETID AND A.BANK_CD = C.BANK_CD AND A.BRANCH_NAME = C.BRANCH_NAME

# 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 BANK_CD_CPTY Character(5) VARCHAR2(5) NOT NULL An internal key field convention that facilitates the system distinction between banks and counterparties.
4 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
5 BANK_ID_QUAL Character(3) VARCHAR2(3) NOT NULL "A bank/counterparty attribute that determines
6 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
7 BRANCH_ID Character(10) VARCHAR2(10) NOT NULL The local branch office identifier associated with a given bank/counterparty.
8 BANK_ACCT_TYPE Character(2) VARCHAR2(2) NOT NULL An account attribute that describes the ostensible purposes of a given bank/counterparty account.
01=Time Deposit
03=Checking Account
05=Stock
06=Bond
07=Life Insurance Value
08=Retirement Account
10=Business Account
11=Trust Fund Account
12=Stock & Bond Account
13=Life Insurance Acct
CA=Current Account
CH=Charges Account
DA=Demand Deposit
LN=Loan
RD=Return Items on DDA
RS=Return Items-Savings
SA=Settlement Account
SV=Savings Account
Z=Mutually Defined
9 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
10 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit
11 DFI_ID_QUAL Character(2) VARCHAR2(2) NOT NULL A banking industry convention identifier utilized to drive data validation for a given bank/counterparty.
01=Transit Number
02=Swift ID/BIC
03=CHIPS Participant ID
04=Canadian Bank Branch/Institute
05=CHIPS Universal ID
ZZ=Mutually Defined
12 DFI_ID_NUM Character(12) VARCHAR2(12) NOT NULL A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun
13 BANK_NAME Character(30) VARCHAR2(30) NOT NULL Bank Name
14 BANK_NAME_AC Character(30) VARCHAR2(30) NOT NULL Alternate Character Set field for BENEFICIARY_BANK
15 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

16 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
17 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
18 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
19 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
20 CITY Character(30) VARCHAR2(30) NOT NULL City
21 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
22 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
23 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
24 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
25 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
26 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
27 COUNTY Character(30) VARCHAR2(30) NOT NULL County
28 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: %EDIT_STATE

29 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
30 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
31 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

32 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
33 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
34 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
35 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
36 IBAN_CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL IBAN Check Digit
37 IBAN_ID Character(34) VARCHAR2(34) NOT NULL IBAN - Internation Bank Account Number is used in European countries to uniquely identify Bank accounts across borders
38 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
39 PREFERRED_LANGUAGE Character(3) VARCHAR2(3) NOT NULL Preferred Language
ARA=Arabic
CFR=Canadian French
CZE=Czech
DAN=Danish
DUT=Dutch
E=English
ENG=English
ESP=Spanish
F=French
FIN=Finnish
FRA=French
GER=German
HUN=Hungarian
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
NOR=Norwegian
POL=Polish
POR=Portuguese
RUS=Russian
SVE=Swedish
THA=Thai
UKE=UK English
ZHS=Simplified Chinese
ZHT=Traditional Chinese
40 BRANCH_DESCR Character(30) VARCHAR2(30) NOT NULL Branch Description
41 BRANCH_NAME_AC Character(30) VARCHAR2(30) NOT NULL Branch Alternate Char