RPT_FCT_FM_FA_APPROVED_MV

This is a fact table in reporting Star schema that contains the approved budget, forecast and actual information of financial summary of lifecycle entities, programs, portfolios, and org units. This information is stored at year granularity.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name	Null?	Data Type	Description
FINANCIAL_SUMMARY_ID	NULLABLE	NUMBER	ID of a financial summary derived from RPT_FCT_FM_APPROVED_BUDGETS table.
FORECAST_ACTUAL_ID	NULLABLE	NUMBER	Forecast Actual ID for a financial summary.
DIRECT_PARENT_ID	NULLABLE	NUMBER	ID of the financial entity that this financial summary belongs to (Project / Proposal / Asset / Program).
DIRECT_PARENT_TYPE	NULLABLE	VARCHAR2(20)	Proposal, Project, Asset, Program
DIRECT_PARENT_NAME	NULLABLE	VARCHAR2(500)	Name of the financial entity (project, proposal, asset, or program) to which this financial summary belongs.
REGION_ID	NULLABLE	NUMBER	ID of the region with which the cost is associated
PERIOD_ID	NULLABLE	NUMBER	ID of the Proposal/Project/Asset/Program/org units to which this Financial Summary belongs
APPROVED_BASE	NULLABLE	NUMBER	Approved cost aggregated for a given year, displayed in base currency
APPROVED_LOCAL	NULLABLE	NUMBER	Approved cost aggregated for a given year, displayed in local currency
FORECAST_BASE	NULLABLE	NUMBER	Forecast cost aggregated for a given year, displayed in base currency
FORECAST_LOCAL	NULLABLE	NUMBER	Forecast cost aggregated for a given year, displayed in local currency
ACTUAL_BASE	NULLABLE	NUMBER	Actual cost aggregated for a given year, displayed in base currency
ACTUAL_LOCAL	NULLABLE	NUMBER	Actual cost aggregated for a given year, displayed in local currency
CAPEX_APPROVED_BASE	NULLABLE	NUMBER	Approved capital cost aggregated for a given year, displayed in base currency
CAPEX_APPROVED_LOCAL	NULLABLE	NUMBER	Approved capital cost aggregated for a given year, displayed in local currency
OPEX_APPROVED_BASE	NULLABLE	NUMBER	Approved operating cost aggregated for a given year, displayed in local currency
OPEX_APPROVED_LOCAL	NULLABLE	NUMBER	Approved operating cost aggregated for a given year, displayed in base currency

Indexes

This table uses no indexes.

Sequences

This table uses no sequences.