RPT_DIM_FM_BENEFIT_MV

This is a materialized view on top of FM_BENEFITS and FM_USER_DATA tables.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

BENEFIT_ID

NOT NULL

NUMBER

ID of the benefit

SHOW_ACTUALS_FLAG

NOT NULL

VARCHAR2(1)

Flag to enable or disable showing of actuals

USER_DATA_<N>

NULLABLE

VARCHAR2(255)

Hidden value of user data associated with the benefit

<N> ranges from 1 to 20.

USER_DATA_<N>_VISIBLE

NULLABLE

VARCHAR2(255)

Visible value of user data associated with the benefit

<N> ranges from 1 to 20.

Indexes

Index Name

Index Type

Sequence

Column Name

RPT_DIM_FM_BENEFIT_MV_PK

UNIQUE

1

BENEFIT_ID

Sequences

This table uses no sequences.