RPT_FCT_FM_APPROVED_BUDGETS

This is a fact table in reporting Star schema that contains the approved budget information of lifecycle entities, programs, org units, and portfolios. The approved budget information is stored at year 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 FM_APPROVED_BUDGETS table

FINANCIAL_SUMMARY_ID

NOT NULL

NUMBER

ID of the financial summary derived from FM_FINANCIAL_SUMMARY table

DIRECT_PARENT_ID

NOT NULL

NUMBER

ID of proposal, project, asset, program, org unit with which this financial summary is associated. This ID is derived from PFM_LIFECYCLE_PARENT_ENTITY table for currently 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 with derived from

PERIOD_ID

NOT NULL

NUMBER

ID of the period with which the cost is associated with derived from FM_APPROVED_BUDGETS table

AMOUNT_BASE

NULLABLE

NUMBER

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

AMOUNT_LOCAL

NULLABLE

NUMBER

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

EXPENSE_TYPE_CODE

NULLABLE

VARCHAR2(40)

Indicates the expense type (capital or operating)

Indexes

Index Name

Index Type

Sequence

Column Name

SYS_C003624083

UNIQUE

1

FACT_ID

Sequences

This table uses no sequences.