Share this page
RPT_DIM_FM_BENEFIT_LINE_MV
This table stores the individual lines of information per benefit type category over time. The benefit lines have a many-to-one relationship with benefits.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
BENEFIT_LINE_ID |
NOT NULL |
NUMBER |
System-generated identifier |
|
BENEFIT_TYPE_CODE |
NOT NULL |
VARCHAR2(30) |
Benefit type code |
|
CATEGORY_CODE |
NULLABLE |
VARCHAR2(30) |
Category associated with the type |
|
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_LINE_MV_PK |
UNIQUE |
1 |
BENEFIT_LINE_ID |
|
RPT_DIM_FM_BENEFIT_LINE_MV_X2 |
NONUNIQUE |
1 |
BENEFIT_TYPE_CODE |
|
RPT_DIM_FM_BENEFIT_LINE_MV_X3 |
NONUNIQUE |
1 |
CATEGORY_CODE |
Sequences
This table uses no sequences.
