Share this page

# 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.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: