6.25 Configuring Affiliated Bank

The information in this table is used to populate data related to any Exempt Affiliated Banks that may be associated with the Exempt Filer Bank. The values in this table are used to allow a user to select the relevant affiliated bank from the Exemption record in the UI and have the associated information automatically populate on the Exemption record and DOEP.

Table 6-15 KDD_AFILIATED_BANK Table Attributes

Column Name	Description
AFILIATED_BANK_NM	Name of the affiliated bank.
FILER_EIN_NB	EINID of the filer.
AFILIATED_BANK_EIN_NB	EINID of the affiliated bank.
AFILIATED_BANK_RSSD_NB	RSSDID of the affiliated bank.
AFILIATED_BANK_ADDR	Street address of the affiliated bank.
AFILIATED_BANK_ADDR_CITY	City of the affiliated bank.
AFILIATED_BANK_ADDR_STATE_CD	State code of the affiliated bank. If a US state/territory, then it must adhere to the two-letter codes used by the United States Postal Service when the country is equal to US or a U.S. Territory.
AFILIATED_BANK_ADDR_POSTL_CD	The zip code or postal code for the affiliated bank. Do not include punctuation or formatting such as hyphens, periods, and spaces within the entry.
PRIMARY_FEDERAL_REGULATOR	Enter the appropriate code to record the filing institution’s primary federal regulator. The value provided must adhere to the following requirements: l 1FRB (Federal Reserve Board) l 2FDIC (Federal Deposit Insurance Corporation) l 7IRS (Internal Revenue Service) l 3NCUA (National Credit Union Administration) 4OCC (Office of the Comptroller of the Currency) Record the code (1,2,7,3,4) only.
AFFILIATED_BANKS_INDICATOR	Indicates that a parent bank or financial holding company (or one of its bank subsidiaries) is making the designation of exempt person on behalf of some or all bank subsidiaries of the holding company.
FILER	Filer requesting the exemption.
USER_FIELD	User who approved the exemption.

For example:

Insert into KDD_AFILIATED_BANK ('BANK', '111122220', '222', null,'ABC STREET',
'CITY', 'STATE','55555', null, null, null))