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