dim_company

-1 rows


Description

A ‘partner company’ that contracts can be related to for the Corporate Fitness program. Only includes companies that are currently whitelisted for the studios related to this DWH instance.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
company_id int8 19 null
fct_contract.company_id fct_contract_company_id_fkey R

The primary key of this table. System column calculated by the source System.
company_name varchar 256 null

The name of the partner company.
external_company_identifier varchar 256 √ null

A string to identify the company in external systems.
company_number varchar 256 √ null

More human-readable identifier key to identify the company. Formatted as C-<increasing number> (eg C-1, C-2, ..).
active bool 1 null

Whether the company currently is assignable to contracts.
archived bool 1 null

Permanently removed but kept for historic relations.
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags behind source system).

Relationships

Close relationships within degrees of separation