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.