Company Relationships

Snowflake table name : CYBERSYN.COMPANY_RELATIONSHIPS

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
COMPANY_ID	Unique identifier assigned by Cybersyn to each company. Joinable to the COMPANY_INDEX table.	VARCHAR	cddd6a81c10ce101ba2e710d6c664f01
COMPANY_NAME	The name of the company.	VARCHAR	SEE'S CANDIES INC
ENTITY_LEVEL	Describes the type or level of the entity for additional convenience. Currently, all entities are corporate entities and are denoted as 'Corporate'.	VARCHAR	Corporate
RELATED_COMPANY_ID	Unique identifier assigned by Cybersyn to the related company. Joinable to the COMPANY_INDEX table.	VARCHAR	3f646b4f0762107cf50ee19505f0d566
RELATED_COMPANY_NAME	The name of the related company.	VARCHAR	BERKSHIRE HATHAWAY INC
RELATED_ENTITY_LEVEL	Describes the type or level of the related entity for additional convenience. Currently, all entities are corporate entities and are denoted as 'Corporate'.	VARCHAR	Corporate
RELATIONSHIP_TYPE	Specifies the kind of relationship between the company and the related company. The value is 'Parent' when the company is the parent of the related company and 'Subsidiary' when the company is a subsidiary of the related company.	VARCHAR	Subsidiary
RELATIONSHIP_START_DATE	The beginning of a company being associated with the related company. In cases where the start date is unknown, NULL is assigned.	DATE	N/A
RELATIONSHIP_END_DATE	The ending of the relationship being valid for the company and the related company. In cases where a relationship is currently valid, an end date of NULL is assigned.	DATE	N/A