Share this page

# RPT_DIM_FM_FIN_SUMMARY_MV

This is a materialized view on top of PPM's FM_FINANCIAL_SUMMARY table.

## 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 the financial summary derived from FM_FINANCIAL_SUMMARY table
NAME | NULLABLE | VARCHAR2(1300) | Name of the financial summary
DESCRIPTION | NULLABLE | VARCHAR2(1300) | Description of a Financial Summary
ENTITY_TYPE | NULLABLE | VARCHAR2(255) | Identifies the financial summary as the current financial summary (FS) or a snapshot (SNAPSHOT) of a financial summary.
CREATED_BY | NULLABLE | VARCHAR2(200) | Identifier for the user who created the record
IS_PLAN_OF_RECORD | NULLABLE | VARCHAR2(1) | Flag that indicates whether the financial summary is the plan of record (set to 'Y') or is not the plan of record (set to 'N').
LOCAL_CURRENCY_CODE | NULLABLE | VARCHAR2(40) | Each financial summary has an associated local currency and a code. The local currency and code are based on the region associated with the financial summary's parent. Programs have no associated region, so the local currency defaults to the base currency.
BASE_CURRENCY_CODE | NULLABLE | VARCHAR2(10) | Each financial summary has a base currency and a code associated with it. Example: USD for United States Dollar. The base currency defaults to the PPM Center base currency.
SNAPSHOT_SEQ | NULLABLE | NUMBER | Sequence in which snapshots were created, ranging from 0 to n.
CREATION_DATE | NULLABLE | DATE | Date record was created
IS_FINANCIAL_DATA_TABLE | NULLABLE | VARCHAR2(1) | Flag that indicates whether the entity ID for the financial summary's parent is set to 19 (Y) or not (N).
LOCAL_CURRENCY_SYMBOL | NULLABLE | VARCHAR2(50) | Symbol for the local currency
BASE_CURRENCY_SYMBOL | NULLABLE | VARCHAR2(50) | Symbol for the base currency
FS_ENABLED | NULLABLE | VARCHAR2(1) | Identifies if the financial summary is enabled 'Y' or not 'N'.

## Indexes

This table uses no indexes.

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