CVG_PREMIUM_RATES

Description: |
Coverage level premium rates.

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 | PREMIUM_RATE_EFF_DT | DATETIME | No |
Stores the effective date of the coverage level premium rate.
4 | PREMIUM_RATE | NUMERIC | No |
Stores the coverage level override premium rate.
5 | PREMIUM_RT_TERM_DT | DATETIME | No |
Stores the term date of the coverage level premium rate
6 | HIX_APTC_AMT | NUMERIC | No |
Stores the Advance Premium Tax Credit amount.
7 | HIX_CSR_AMT | NUMERIC | No |
Stores the Cost Sharing Reduction amount of an exchange coverage.
8 | HIX_OTHER_AMT | NUMERIC | No |
The payment amount for an exchange coverage from a federally recognized tribe.
9 | HIX_EMPLOYER_AMT | NUMERIC | No |
Stores the employer responsibility amount for an exchange coverage.
10 | HIX_RESP_AMT | NUMERIC | No |
Stores the total responsibility amount for an exchange coverage.
11 | HIX_STATE_AMOUNT | NUMERIC | No |
The payment amount for an exchange coverage from the state
12 | MCARE_PART_C_PREM | NUMERIC | No |
This column stores the amount for the Part C premium, which is used for Medicare Advantage coverages.
13 | MCARE_PART_D_PREM | NUMERIC | No |
This column stores the amount for the Part D premium. This value is compared to the Part D premium amount on the employer group during premium computation. This value isn't directly used for billing. The adjusted Part D premium (CVG-18838), which is used for billing, is calculated using this amount.
14 | MCARE_LATE_ENRL_PEN | NUMERIC | No |
This column holds the amount for Part D Late Enrollment Penalty (LEP), which is used for some Medicare Advantage coverages.
15 | MCARE_LIS_PART_D | NUMERIC | No |
This column holds the Low Income Subsidy (LIS) amount for Part D on Medicare Advantage coverages.
16 | MCARE_LIS_FOR_LEP | NUMERIC | No |
This column holds the Low Income Subsidy (LIS) for Late Enrollment Penalty (LEP); this is only used for Medicare Advantage coverages.
17 | MCARE_LEP_WAIVED | NUMERIC | No |
This column holds the amount of waived Late Enrollment Penalty (LEP) for Medicare Advantage coverages.
18 | MCARE_ADJ_LEP | NUMERIC | No |
This column holds the adjusted Late Enrollment Penalty. The Low Income Subsidy for Late Enrollment Penalty (CVG-18835) and the Late Enrollment Penalty Waived (CVG-18836) are each subtracted from the Late Enrollment Penalty (CVG-18833) to arrive at this amount. This amount will then be billed to the member.
19 | MCARE_ADJ_PART_D | NUMERIC | No |
This column holds the adjusted Part D premium. The Low Income Subsidy for Part D (CVG-18834) is subtracted from the Part D premium (CVG-18832) to arrive at this amount.
20 | HIX_NON_HYDE_AMOUNT | NUMERIC | No |
The non-Hyde credit amount for an exchange coverage.