Financial Branch Entities

Snowflake table name : CYBERSYN.FINANCIAL_BRANCH_ENTITIES

View data source documentation here.

Name	Description	Type	Example
ID_RSSD	A unique identifier assigned by the Federal Reserve for the financial institution	NUMBER	4730042
ID_RSSD_PARENT	Unique identifier for the head office of the entity if the entity is a branch	NUMBER	233031
NAME_PARENT	Name of the parent bank	VARCHAR	FIRST AMERICAN TRUST, FSB
BRANCH_NAME	Name of the banking branch	VARCHAR	EAST WATAUGA BRANCH
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	True
START_DATE	First date for which the branch was open	DATE	2014-06-02
END_DATE	Last date for which the branch was open. NULL if still active	DATE	2024-05-24
ADDRESS	First line of the physical address at the street level	VARCHAR	3055 CARDINAL DRIVE
ADDRESS_LINE2	Second line of the physical address at the street level	VARCHAR	SUITE A-105
CITY	City the entity is physically located in	VARCHAR	LINCOLN
STATE_ABBREVIATION	Abbreviation of the state the entity is physically located in	VARCHAR	FL
ZIP_CODE	Zip code the entity is physically located in	VARCHAR	96799
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/47
ID_COUNTY	Unique identifier of the county where the entity is located	VARCHAR	geoId/12061
ID_ZIP	Unique identifier of the zip code where the entity is located	VARCHAR	zip/32963