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.