Financial Institution Hierarchy

Snowflake table name : CYBERSYN.FINANCIAL_INSTITUTION_HIERARCHY

View data source documentation here.

Name	Description	Type	Example
ID_RSSD_PARENT	Unique identifier for parent entity. Joinable to entities table	NUMBER	112837
NAME_PARENT	Name of parent entity	VARCHAR	Heritage Bank
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	Bank
ID_RSSD_OFFSPRING	Unique identifier for offspring entity. Joinable to entities table	NUMBER	5134124
NAME_OFFSPRING	Name of offspring entity	VARCHAR	COCRF INVESTOR 85, LLC
ACTIVE_OFFSPRING	Flag to indicate if offspring is active	BOOLEAN	True
CATEGORY_OFFSPRING	High-level category of successor entity legal structure (e.g., Branch, Bank)	VARCHAR	Other Financial Institution
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 entities	VARCHAR	Direct relationship