Financial Branch Entities

Snowflake table name : CYBERSYN.FINANCIAL_BRANCH_ENTITIES

View data sources, attributes, and sample queries here.

NameDescriptionTypeExample

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

Last updated

Copyright © 2024 Cybersyn