Financial Branch Entities

Snowflake table name : CYBERSYN.FINANCIAL_BRANCH_ENTITIES

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
ID_RSSD	A unique identifier assigned by the Federal Reserve for the financial institution	NUMBER	1849523
ID_RSSD_PARENT	Unique identifier for the head office of the entity if the entity is a branch	NUMBER	451965
NAME_PARENT	Name of the parent bank	VARCHAR	CALVIN B. TAYLOR BANKING COMPANY OF BERLIN, MARYLAND
BRANCH_NAME	Name of the banking branch	VARCHAR	Peoples Bank of Bluewell
CATEGORY	Category of the entity for a given RSSD. Branch or bank	VARCHAR	Branch
IS_ACTIVE	Status of the branch to determine active or closed	BOOLEAN	False
START_DATE	First date for which the branch was open	DATE	1981-02-18
END_DATE	Last date for which the branch was open. NULL if still active	DATE	2024-03-06
ADDRESS	First line of the physical address at the street level	VARCHAR	2090 NORTHWEST 107TH AVENUE
ADDRESS_LINE2	Second line of the physical address at the street level	VARCHAR	SUITE 160
CITY	City the entity is physically located in	VARCHAR	PINEVILLE
STATE_ABBREVIATION	Abbreviation of the state the entity is physically located in	VARCHAR	VA
ZIP_CODE	Zip code the entity is physically located in	VARCHAR	96753
ID_COUNTRY	Unique identifier of the country where the entity is located	VARCHAR	country/USA
ID_STATE	Unique identifier of the state where the entity is located	VARCHAR	geoId/51
ID_COUNTY	Unique identifier of the county where the entity is located	VARCHAR	geoId/24047
ID_ZIP	Unique identifier of the zip code where the entity is located	VARCHAR	zip/22902