cost_centers

source

The org units we budget and post against.

Definition

Cost-center hierarchy used by GL lines, budgets, forecasts, and expense lines. `parent_cost_center_id` builds the rollup tree; `owner_employee_id` names the accountable manager.

9 of 9

Column

Description

Tests · PII

cost_center_id

Primary key — BIGSERIAL on the source.

2 tests

cost_center_code

Short unique code (e.g. `CC-1000`).

2 tests

name

Display name (renamed to `cost_center_name` in staging).

parent_cost_center_id

FK to `cost_centers.cost_center_id`. Null for root cost centers.

owner_employee_id

FK to `finance_employees.employee_id`. Nullable.

region

Region slug — `US` / `EU` / `APAC`. Nullable.

is_active

True for active cost centers.

created_at

Row insert timestamp in the source DB.

updated_at

Row update timestamp in the source DB.