Company Relationships

Snowflake table name : CYBERSYN.COMPANY_RELATIONSHIPS

View data sources, attributes, and sample queries here.

NameDescriptionTypeExample

COMPANY_ID

Unique identifier assigned by Cybersyn to each company. Joinable to the COMPANY_INDEX table.

VARCHAR

27a220de51d4643217d311c5203b155e

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

bbd25bfb27a1860b449fa0a1bee480b5

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

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

Last updated

Copyright © 2024 Cybersyn