RPT_FCT_FM_BENEFIT_CELLS

This table holds benefit information derived from PPM tables. All the fields are derived from PPM benefit tables.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

FACT_ID

NOT NULL

NUMBER

The financial line cell ID that is derived from KNTA_USERS table

BENEFIT_ID

NOT NULL

NUMBER

The benefit ID that is derived from FM_BENEFIT_LINES table

BENEFIT_LINE_ID

NOT NULL

NUMBER

The benefit line ID that is derived from FM_BENEFIT_LINES table

FINANCIAL_SUMMARY_ID

NOT NULL

NUMBER

Financial summary ID that is derived from FM_FINANCIAL_SUMMARY table

DIRECT_PARENT_ID

NOT NULL

NUMBER

ID of the item where current financial information comes from

DIRECT_PARENT_TYPE

NOT NULL

VARCHAR2(20)

Type of the item where current financial information comes from (for example, PROJECT/ ASSET/ PROPOSAL/ PROGRAM/ PORTFOLIO)

DIRECT_PARENT_NAME

NOT NULL

VARCHAR2(500)

Name of the item where current financial information comes from

REGION_ID

NULLABLE

NUMBER

ID of the Region

PERIOD_ID

NOT NULL

NUMBER

Period ID that is derived from FM_FINANCIAL_LINE_CELLS table

ACTUAL_BASE

NULLABLE

NUMBER

Actual value in base currency that is derived from FM_FINANCIAL_LINE_CELLS table

ACTUAL_LOCAL

NULLABLE

NUMBER

Actual value in local currency that is derived from FM_FINANCIAL_LINE_CELLS table

PLANNED_BASE

NULLABLE

NUMBER

Planned value in base currency that is derived from FM_FINANCIAL_LINE_CELLS table

PLANNED_LOCAL

NULLABLE

NUMBER

Planned value in local currency that is derived from FM_FINANCIAL_LINE_CELLS table

Indexes

Index Name

Index Type

Sequence

Column Name

RPT_FCT_FM_BENEFIT_CLL_N1

 NONUNIQUE

1

PERIOD_ID

RPT_FCT_FM_BENEFIT_CLL_N2

 NONUNIQUE

1

DIRECT_PARENT_ID

RPT_FCT_FM_BENEFIT_CLL_N3

 NONUNIQUE

1

BENEFIT_LINE_ID

RPT_FCT_FM_BENEFIT_CLL_N4

 NONUNIQUE

1

FINANCIAL_SUMMARY_ID

RPT_FCT_FM_BENEFIT_CLL_N5

 NONUNIQUE

1

REGION_ID

RPT_FCT_FM_BENEFIT_CLL_N6

 NONUNIQUE

1

DIRECT_PARENT_TYPE

Sequences

This table uses no sequences.