IBAN_FORMAT_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
2	COUNTRY_2CHAR	Character(2)	VARCHAR2(2) NOT NULL	2-Char Country Code
3	IBAN_ENTERABLE	Character(1)	VARCHAR2(1) NOT NULL	IBAN is generated automatically Y/N Table Edit Default Value: Y
4	IBAN_MANDATORY	Character(1)	VARCHAR2(1) NOT NULL	IBAN is mandatory. Y/N Table Edit Default Value: N
5	IBAN_BANKID_POS	Number(3,0)	SMALLINT NOT NULL	IBAN Bank ID Position
6	IBAN_BANKID_LEN	Number(3,0)	SMALLINT NOT NULL	IBAN Bank ID Length
7	IBAN_BANKID_PAD	Character(1)	VARCHAR2(1) NOT NULL	Pad with zeros Y/N Table Edit Default Value: N
8	IBAN_DFI_ID_POS	Number(3,0)	SMALLINT NOT NULL	IBAN DFI ID Position
9	IBAN_DFI_ID_LEN	Number(3,0)	SMALLINT NOT NULL	IBAN DFI ID Length
10	IBAN_DFI_ID_PAD	Character(1)	VARCHAR2(1) NOT NULL	Pad with zeros Y/N Table Edit Default Value: N
11	IBAN_BRANCHID_POS	Number(3,0)	SMALLINT NOT NULL	IBAN Branch ID Position
12	IBAN_BRANCHID_LEN	Number(3,0)	SMALLINT NOT NULL	Branch ID Length
13	IBAN_BRANCHID_PAD	Character(1)	VARCHAR2(1) NOT NULL	Pad with zeros Y/N Table Edit Default Value: N
14	IBAN_ACCOUNT_POS	Number(3,0)	SMALLINT NOT NULL	IBAN Account Position
15	IBAN_ACCOUNT_LEN	Number(3,0)	SMALLINT NOT NULL	IBAN Account Length
16	IBAN_ACCOUNT_PAD	Character(1)	VARCHAR2(1) NOT NULL	Pad with zeros Y/N Table Edit Default Value: N
17	IBAN_CHKDIGIT_POS	Number(3,0)	SMALLINT NOT NULL	Check Digit Start
18	IBAN_CHKDIGIT_LEN	Number(3,0)	SMALLINT NOT NULL	Check Digit Length
19	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