forecasts

source

The forecast scenarios.

Definition

Forecast headers per (fiscal_year, scenario, version) — UNIQUE on the source. `scenario` is base / upside / downside; `status` walks draft → published → archived.

12 of 12

Column

Description

Tests · PII

forecast_id

Primary key — BIGSERIAL on the source.

2 tests

forecast_name

Display name of the forecast.

legal_entity_id

FK to `legal_entities.legal_entity_id`. Nullable.

fiscal_year

Fiscal year the forecast covers.

scenario

Scenario — `base` / `upside` / `downside`.

1 test

version

Forecast version (1-based).

as_of_period_id

FK to `fiscal_periods.period_id` the forecast is anchored on. NOT NULL.

1 test

status

Lifecycle — `draft` / `published` / `archived`.

1 test

currency

Forecast currency.

created_by_employee_id

FK to the creating employee — actor reference. Nullable.

created_at

Row insert timestamp in the source DB.

updated_at

Row update timestamp in the source DB.