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.