RPT_FCT_FM_FCST_ACTUAL_CELL

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

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

FACT_ID

NOT NULL

NUMBER

ID derived from the FM_FINANCIAL_LINE_CELLS table

FORECAST_ACTUAL_LINE_ID

NOT NULL

NUMBER

ID of each forecast actual line in a financial summary derived from FM_FORECAST_ACTUAL_LINES table

FORECAST_ACTUAL_ID

NOT NULL

NUMBER

Forecast Actual ID for a specific financial summary derived from FM_FORECAST_ACTUAL_LINES table

FINANCIAL_SUMMARY_ID

NOT NULL

NUMBER

ID for a financial summary the cost are associated with derived from FM_FINANCIAL_SUMMARY

DIRECT_PARENT_ID

NOT NULL

NUMBER

ID for the proposal, project, asset, program, org unit with which this financial summary is associated with. This ID is derived from PFM_LIFECYCLE_PARENT_ENTITY table for current active entity.

DIRECT_PARENT_TYPE

NOT NULL

VARCHAR2(20)

Type of parent entity (project, proposal, asset, program, org unit)

DIRECT_PARENT_NAME

NOT NULL

VARCHAR2(500)

Name of a proposal, project, asset, program, or org unit associated with the financial summary

REGION_ID

NULLABLE

NUMBER

ID of the region with which the cost is associated

PERIOD_ID

NOT NULL

NUMBER

ID of the region with which the cost is associated derived from FM_FINANCIAL_LINE_CELLS table

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 base currency

PLANNED_BASE

NULLABLE

NUMBER

Forecast cost aggregated for a given year, displayed in base currency

PLANNED_LOCAL

NULLABLE

NUMBER

Forecast cost aggregated for a given year, displayed in local currency

Indexes

Index Name

Index Type

Sequence

Column Name

RPT_FCT_FM_FCST_ACTL_CLL_N1

NONUNIQUE

1

PERIOD_ID

RPT_FCT_FM_FCST_ACTL_CLL_N2

NONUNIQUE

1

DIRECT_PARENT_ID

RPT_FCT_FM_FCST_ACTL_CLL_N3

NONUNIQUE

1

FORECAST_ACTUAL_LINE_ID

RPT_FCT_FM_FCST_ACTL_CLL_N4

NONUNIQUE

1

FINANCIAL_SUMMARY_ID

RPT_FCT_FM_FCST_ACTL_CLL_N5

NONUNIQUE

1

REGION_ID

RPT_FCT_FM_FCST_ACTL_CLL_N6

NONUNIQUE

1

DIRECT_PARENT_TYPE

Sequences

This table uses no sequences.