Share this page

# FM_FINANCIAL_SUMMARY

This table stores Portfolio Management financial summaries, financial data components, and their snapshots.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
FM_FINANCIAL_SUMMARY | FINANCIAL_SUMMARY_ID | ACTIVE_FS_ID
FM_BENEFITS | BENEFIT_ID | BENEFIT_ID
KNTA_USERS | USER_ID | CREATED_BY
FM_FORECAST_ACTUALS | FORECAST_ACTUAL_ID | FORECAST_ACTUAL_ID
ITG_SECURABLE_ENTITIES | SECURABLE_ENTITY_ID | FS_ACL_ID
KNTA_USERS | USER_ID | LAST_UPDATED_BY

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
FINANCIAL_SUMMARY_ID | NOT NULL | NUMBER | System-generated identifier
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
CREATION_DATE | NOT NULL | DATE | Date record was created
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
VERSION | NOT NULL | NUMBER | System-generated version, used for hibernate version control
PARENT_ID | NOT NULL | NUMBER | Identifier for the parent of the financial summary. Based on PARENT_ENTITY_ID, the PARENT_ID could be LIFECYCLE_ID in PFM_LIFECYCLE_PARENT_ENTITY, ORG_UNIT_ID in KRSC_ORG_UNITS_NLS, PROGRAM_ID in PGM_PROGRAMS or REQUEST_ID in KCRT_REQUESTS
PARENT_ENTITY_ID | NOT NULL | NUMBER | Identifier for the parent entity of the financial summary. For example, 526 is for lifecycle entity; 313 is for org unit; 67 is for program; 20 is for request.
NAME | NOT NULL | VARCHAR2(1300) | Name of the financial summary
DESCRIPTION | NULLABLE | VARCHAR2(1300) | Description of the financial summary
CURRENCY_CODE | NOT NULL | VARCHAR2(40) | Currency code that indicates the local currency used for the financial summary.
FORECAST_ACTUAL_ID | NOT NULL | NUMBER | Identifier for associated forecast actual
BENEFIT_ID | NOT NULL | NUMBER | Identifier for associated benefit
PLAN_OF_RECORD_FLAG | NULLABLE | VARCHAR2(1) | Flag that indicates if the financial summary snapshot is a plan of record
ACTIVE_FS_ID | NULLABLE | NUMBER | Used for snapshots only. Stores the identifier of the financial summary from which the snapshot is taken.
SNAPSHOT_SEQ | NULLABLE | NUMBER | Used for snapshots only. Determines the order of the snapshots.
ENTITY_TYPE | NULLABLE | VARCHAR2(255) | Indicates whether the entry is FS or SNAPSHOT
FS_ACL_ID | NULLABLE | NUMBER | Identifier for financial summary AC

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
FM_FINANCIAL_SUMMARY_PK | UNIQUE | 1 | FINANCIAL_SUMMARY_ID
FM_FINANCIAL_SUM_PARENT_IDX | NONUNIQUE | 1 | PARENT_ENTITY_ID
FM_FINANCIAL_SUM_PARENT_IDX | NONUNIQUE | 2 | PARENT_ID
FM_FINANCIAL_SUMMARY_N1 | NONUNIQUE | 1 | ACTIVE_FS_ID
FM_FINANCIAL_SUMMARY_N2 | NONUNIQUE | 1 | FORECAST_ACTUAL_ID
FM_FINANCIAL_SUMMARY_IDX_1 | NONUNIQUE | 1 | PLAN_OF_RECORD_FLAG
FM_FINANCIAL_SUMMARY_N2 | NONUNIQUE | 1 | BENEFIT_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
FM_FINANCIAL_SUMMARY_S | FINANCIAL_SUMMARY_ID

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: