HIX_MEM_RATES

Description:

The HIX_MEM_RATES table contains information about the individual member premium for an exchange coverage. The table includes the effective date, premium rate, and the member ID.

Primary Key

Column Name	Ordinal Position
CVG_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	CVG_ID	NUMERIC	No
	The unique identifier for the coverage record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	HIX_MEM_EFF_DATE	DATETIME	No
	The effective date of the member's premium rate
4	HIX_MEM_PREMIUM	NUMERIC	No
	The individually rated premium rate amount for each member on an exchange coverage
5	HIX_MEM_ID	VARCHAR	No
	Stores the member's internal ID in an exchange coverage.