Company Relationships
Snowflake table name : CYBERSYN.COMPANY_RELATIONSHIPS
Last updated
Snowflake table name : CYBERSYN.COMPANY_RELATIONSHIPS
Last updated
Copyright © 2024 Cybersyn
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