Company Relationships

Snowflake table name : CYBERSYN.COMPANY_RELATIONSHIPS

View data source documentation here.

Name	Description	Type	Example
COMPANY_ID	Unique identifier assigned by Cybersyn to each company. Joinable to the COMPANY_INDEX table.	VARCHAR	bbd25bfb27a1860b449fa0a1bee480b5
COMPANY_NAME	The name of the company.	VARCHAR	AMERICAN AIRLINES GROUP 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	27a220de51d4643217d311c5203b155e
RELATED_COMPANY_NAME	The name of the related company.	VARCHAR	AMERICAN AIRLINES GROUP 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	Parent
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