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.