maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
Forecast headers per (fiscal_year, scenario, version). scenario is base / upside / downside.
13 of 13
Column
Description
Tests · PII
forecast_id
Primary key — UInt64.
3 tests
forecast_name
Display name of the forecast.
legal_entity_id
FK to `stg_postgres__legal_entities.legal_entity_id`. Nullable.
fiscal_year
Fiscal year the forecast covers. Int16.
scenario
Scenario — base / upside / downside.
1 test
version
Forecast version (1-based). Int16.
as_of_period_id
FK to fiscal_periods.period_id the forecast is anchored on (not staged). NOT NULL.
1 test
status
Lifecycle — draft / published / archived.
1 test
currency
Forecast currency, uppercased.
created_by_employee_id
FK to the creating employee — actor reference. Nullable.
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.