6.24 Configuring Exempt Filer Bank

The information in this table is used to populate information for the Exempt Filer Bank on the CTR. It is expected to have a single row to represent the filing bank.

Column Name	Description
FILER_BANK_NM	Name of the filing bank.
FILER_BANK_EIN_NB	EINID of the filing bank.
FILER_BANK_RSSD_NB	RSSDID of the filing bank.
FILER_BANK_ADDR	Street address of the filing bank.
FILER_BANK_ADDR_CITY	City of the filing bank.
FILER_BANK_ADDR_STATE_CD	State code of the filing 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.
FILER_BANK_ADDR_POSTL_CD	The zip code or postal code for the filing 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: FRB(Federal Reserve Board) 2 FDIC(Federal Deposit Insurance Corporation) 7 IRS (Internal Revenue Service) NCUA(National Credit Union Administration) 4 OCC(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_FILER ('INSTITUTION','111122220',null,'ABCLANE', 'CITY','STATE','53002', null,
null, 'FILING INSTITUTION, null)