budgets

source

The annual budget versions.

Definition

Budget headers per (fiscal_year, version) — UNIQUE on the source. `status` walks draft → approved → archived.

11 of 11

Column

Description

Tests · PII

budget_id

Primary key — BIGSERIAL on the source.

2 tests

budget_name

Display name of the budget.

legal_entity_id

FK to `legal_entities.legal_entity_id`. Nullable.

fiscal_year

Fiscal year the budget covers.

version

Budget version (1-based).

status

Lifecycle — `draft` / `approved` / `archived`.

1 test

currency

Budget currency.

approved_by_employee_id

FK to the approving employee — actor reference. Nullable.

approved_at

When the budget was approved. Nullable.

created_at

Row insert timestamp in the source DB.

updated_at

Row update timestamp in the source DB.