Share this page
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.
