dim_company_code


Description

Company codes (tags) that can be assigned to companies for categorization and filtering purposes. Similar to customer codes but for partner companies.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
company_code_id int8 19 null
bridge_company_to_company_code.company_code_id Implied Constraint R

The primary key of this table. System column calculated by the source System.

name varchar 256 null

The name of the company code.

description varchar 256 null

Description of the company code. Defaults to ‘UNKNOWN’ if not provided.

color_hex varchar 256 null

Hexadecimal color code for visual representation of the company code.

last_updated timestamptz 35 null

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

Relationships