stg_postgres__cost_centers

staging view

Cost centers, cleaned.

Definition

The cost-center hierarchy typed for MergeTree marts. Parent FK builds the rollup tree; owner FK names the accountable manager.

10 of 10

Column

Description

Tests · PII

cost_center_id

Primary key — UInt64.

4 tests

cost_center_code

Short unique cost-center code (e.g. CC-1000).

2 tests

cost_center_name

Display name (renamed from `name`).

parent_cost_center_id

Self-FK to `cost_centers.cost_center_id`. Null for roots.

owner_employee_id

FK to `finance_employees.employee_id`. Nullable.

region

Region slug — US / EU / APAC. Nullable.

is_active

True for active cost centers.

source_created_at

Row insert timestamp from the source DB. DateTime64(6).

source_updated_at

Row update timestamp from the source DB. DateTime64(6).

airbyte_extracted_at

When the loader extracted this row from postgres-source.