Financial Institution Hierarchy

Snowflake table name : CYBERSYN.FINANCIAL_INSTITUTION_HIERARCHY

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
ID_RSSD_PARENT	Unique identifier for parent entity. Joinable to entities table	NUMBER	183743
NAME_PARENT	Name of parent entity	VARCHAR	CEDAR RAPIDS DOWNTOWN BRANCH
ACTIVE_PARENT	Flag to indicate if parent is active	BOOLEAN	True
CATEGORY_PARENT	High-level category of successor entity legal structure (e.g., Bank Holding Company)	VARCHAR	Branch
ID_RSSD_OFFSPRING	Unique identifier for offspring entity. Joinable to entities table	NUMBER	1086841
NAME_OFFSPRING	Name of offsprint entity	VARCHAR	WELLS FARGO BRASIL LTDA.
ACTIVE_OFFSPRING	Flag to indicate if offpsring is active	BOOLEAN	False
CATEGORY_OFFSPRING	High-level category of successor entity legal structure (e.g., Branch, Bank)	VARCHAR	Branch
RELATIONSHIP_TERMINATED	Indication if the relationship is still current	BOOLEAN	True
PARENT_CONTROLS_OFFSPRING	Indication if the parent has direct control over the offspring	BOOLEAN	True
PERCENT_CONTROL_OF_OFFSPRING	Parent percentage of controlling interest in the offspring	NUMBER	80
RELATIONSHIP_LEVEL	Description of the type of relationship between the two entiites	VARCHAR	Direct relationship