V_EHI_CVG_COVERAGE_HIST_MEM

Description: |
Filter view for loading coverage history by member as EHI.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
COVERAGE_ID | 1 |
LINE | 2 |
INFO_LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | COVERAGE_ID | NUMERIC | No |
The unique ID assigned to the coverage record. This ID may be encrypted if you have elected to use enterprise reporting’s encryption utility.
2 | LINE | INTEGER | No |
The line number used to identify each row of history information for a coverage record.
3 | CHANGE_DATE | DATETIME | No |
The date on which each change was added to the coverage record.
4 | ACTION_C_NAME | VARCHAR | No |
The category value associated with the change made to the coverage record (i.e. Create, Add Member, Change Covered Status, etc.)
May contain organization-specific values: No
Category Entries:
Create Coverage
Add Member
Change Coverage Eff Date
Change Member Eff Date
Remove Member
Add Account
Change Payor
Change Benefit Plan on Employer Group
Change Corporation
Change Employer Group
Change Coverage Term Date
Change COBRA Status
Change Member Relationship
Add Benefit Bucket
Change Benefit Bucket Amount
Change Member Term Date
Member Coverage Marked In Question
Change Covered Status
Change File Order Override
Change Riders on Employer Group
Remove Benefit Plan from Employer Group
Change Activation Date on Employer Group
Change Termination Date on Employer Group
Change Member Number
Change Eff Dt Due to Group Term Date
Change Term Dt Due to Group Eff Date
Change Attribute Effective Date
Change Attribute Termination Date
Remove Coverage Attribute
Change Member Term Reason
Coverage Transferred
Change Coverage Application Date
Change Member Application Date
Change Pending Expiration Date
Change Subscriber ID
Change Coverage Level Riders Tracking on Employer Group
Change Riders Manually on Coverage
Change Riders Automatically on Coverage
Change Use HRA on Employer Group
Change Premium Billing Effective Date on Coverage
Change Premium Billing Term Date on Coverage
Change Premium Billing Premium Rate on Coverage
Change Premium Billing APTC Amount on Coverage
Change Premium Billing CSR Amount on Coverage
Change Premium Billing Tribal Amount on Coverage
Change Premium Billing Employer Amount on Coverage
Change Premium Billing Responsibility Amount on Coverage
Change Premium Billing Member Premium on Coverage
834 Confirmation - Queue
834 Confirmation - Ad Hoc
834 Cancellation - Queue
834 Cancellation - Ad Hoc
834 Termination - Queue
834 Termination - Ad Hoc
834 Full Audit - Queue
834 Full Audit - Ad Hoc
Delete Premium Rate Line on Coverage
Delete Member Premium on Coverage
834 Supplementary Audit - Queue
834 Supplementary Audit - Ad Hoc
Change Continuing Coverage
Change Premium Billing State Amount on Coverage
Add Member Effective Period
Remove Member Effective Period
Remove Release of Information
Add Member Effective Period Due to Group Activation Date Changes
Delete Member Effective Period Due to Group Activation Date Changes
Add Member Effective Period Due to Group Termination Date Changes
Delete Member Effective Period Due to Group Termination Date Changes
Coverage Enrollment Reason Changed
Coverage Termination Reason Changed
Member Enrollment Reason Changed
Generate IRS 1095-B
Change Premium Billing Non-Hyde Credit Amount on Coverage
Change Issuer Policy ID
Add Issuer Policy ID
Remove Issuer Policy ID
Change Medicare Advantage Workflow Status
Change Medicare Number
Change Premium Billing Medicare Part C Premium Override
Change Premium Billing Medicare Part D Premium Override
Change Premium Billing Medicare LIS for Part D
Change Premium Billing Medicare Late Enrollment Penalty
Change Premium Billing Medicare LIS for LEP
Change Premium Billing Medicare LEP Waived
Generate MARx Transaction
Medicare Advantage Daily Transaction Reply Report Message Received
Change Medicare Premium Payment Option
Change HIX Enrollment Additional Maintenance Reason Code
Coverage Transferred Using Employer Group Transfer Coverage Utility
Access Subscriber or Dependent Demographic Information
M834 CSR Variant Change
M834 Coverage Gap
Medicare Advantage BEQ Response message received
Change External Subscriber ID
Change External Member ID
Change Premium Billing Medicare LIS Effective Date
Change Premium Billing Medicare LIS Term Date
Change Premium Billing Medicare LIS Percentage
Change Premium Billing Medicare Premium Override Effective Date
Change Premium Billing Medicare Premium Override Term Date
M834 Single/Family Employer Group Change
Change Subscriber Demographic Information
Edit Transaction in Staging Area
Change Agent Information
Change Legacy HICN
Change Claim Code
Remove Claim Code
Add Claim Code
Add Premium Rate Line on Coverage
Change Broker Information
Add Coverage Attribute
Edit Coverage Attribute Comment
834 Reinstatement - Queue
834 Reinstatement - Ad Hoc
Change Medicare Coverage Type
Change Medicare Status Reason
Change Medicaid Identifier
Change Coverage Review Status
Change Member Risk Adjustment Factor
Add Third Party Payer Effective Period
Remove Third Party Payer Effective Period
Change Third Party Payer Effective Date
Change Third Party Payer Termination Date
Change Third Party Payer Name
Change Medicare LIS Copay Category
Add Medicare LIS Period
Delete Medicare LIS Period
Add Medicare LEP Period
Delete Medicare LEP Period
Change Premium Billing Medicare LEP Termination Date
Changed Coverage Effective Date Change Reason
Changed Member Effective Date Change Reason
Add Medicare Premium Override Period
Delete Medicare Premium Override Period
Add Rider Override Period
Delete Rider Override Period
Change Rider Override Termination Date
Change Rider Override Premium
Add Rider Effective Period
Delete Rider Effective Period
Change Rider Effective Period Termination Date
Add Member to Rider Effective Period
Remove Member from Rider Effective Period
Add Medicare Premium Payment Option
Delete Medicare Premium Payment Option
Change Grace Period Information
Change Premium Billing Medicare LIS Source Code
Change Requested Termination Date
Change Termination Notice Date
Add Covered Through
Remove Covered Through
Add Subscriber Employment Status
Remove Subscriber Employment Status
Change Subscriber Employment Status
Add MC Employment Date
Remove MC Employment Date
Change MC Employment Date
Add Subscriber Address
Remove Subscriber Address
Change Subscriber Address
Add Member Court Decree on Parent Responsibility
Remove Member Court Decree on Parent Responsibility
Change Member Court Decree on Parent Responsibility
Add Member Custodial Parent
Remove Member Custodial Parent
Change Member Custodial Parent
Add Sponsor Related History Effective From
Remove Sponsor Related History Effective From
Change Sponsor Related History From
Add Sponsoring Employer's Size
Remove Sponsoring Employer's Size
Change Sponsoring Employer's Size
Add Member Mailing Address
Remove Member Mailing Address
Change Member Mailing Address
Add Member Custodial Parent Address
Remove Member Custodial Parent Address
Change Member Custodial Parent Address
Add Member Responsible Person Address
Remove Member Responsible Person Address
Change Member Responsible Person Address
Add Sponsor Related History Effective To
Remove Sponsor Related History Effective To
Change Sponsor Related History Effective To
Change Geographic Area Investigation Start Date
Change Geographic Area Temporary Address Start Date
Add Attribute Effective Date
Add Attribute Termination Date
Add Coverage Attribute Comment
Remove Attribute Effective Date
Remove Attribute Termination Date
Remove Coverage Attribute Comment
Merge Member Records
Add Member Responsible Person
Remove Member Responsible Person
Change Member Network
Add Member Effective Period Enrollment Reason
Change Member Effective Period Enrollment Reason
Remove Member Effective Period Enrollment Reason
Add Member Effective Period Termination Reason
Change Member Effective Period Termination Reason
Remove Member Effective Period Termination Reason
Medicare Advantage Monthly Membership Report Transaction Received
Medicare Advantage Monthly Membership Report Omission Transaction Created
Member Effective Periods Changed
Generate COBA E01 Add Submission
Generate COBA E01 Change Submission
Generate COBA E01 Delete Submission
Terminate Member's Coverage
Add M3P Effective Period
Terminate M3P Effective Period
Change M3P Effective Periods
Add M3P Election Request
Change M3P Election Request Status
Change M3P Election Requests
Add M3P Likely to Benefit
Change M3P Likely to Benefit
Change Eligibility Verification Grace Period
Change Member Card ID
Change Primary Coverage
BEQ Web Service Initiated
Change Broker Effective Period
Add Broker
Remove Broker
Add Brokerage Override
Remove Brokerage Override
Change Brokerage Override Type
Change Brokerage Override Effective Period
Change Paid Through Date
Add MARx Transaction
Remove MARx Transaction
Edit MARx Transaction
Medicare Advantage Agent Broker Compensation Report Transaction Received
Change Enrollment County
Add Agent/Broker Compensation Information
Remove Agent/Broker Compensation Information
Edit Agent/Broker Compensation Information
5 | EDIT_INFO | VARCHAR | No |
The original information associated with the change.
6 | EDIT_PAT_ID | VARCHAR | No |
The member ID for whom the change is done.
7 | EFF_DT_CHNG_RSN_C_NAME | VARCHAR | No |
The effective date change reason in the Coverage History.
May contain organization-specific values: Yes
No Entries Defined
8 | MC_EDIT_HX_TIME | DATETIME (Local) | No |
Coverage history time of change.
9 | INFO_RCVD_DT | DATETIME | No |
The information received date associated with the change.
10 | INFO_LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
11 | ITEM | INTEGER | No |
The item associated with the old and new values of this line.
12 | IS_KEY_ITEM_YN | VARCHAR | No |
Indicates whether the item on this line is a key item for the action associated with this line. The set values (old and new separately) of key items in the same group for the same action cannot be duplicated across other groups of that action. 'Y' indicates that the item is a key item. 'N' or NULL indicates that the item is not a key item.
May contain organization-specific values: No
Category Entries:
No
Yes
13 | OLD_VALUE | VARCHAR | No |
The old value of the item on this line.
14 | NEW_VALUE | VARCHAR | No |
The new value of the item on this line.
15 | OLD_CID | VARCHAR | No |
If the item on this line is a category item or a networked item, the CID associated with the old value of the item on this line.
16 | NEW_CID | VARCHAR | No |
If the item on this line is a category item or a networked item, the CID associated with the new value of the item on this line.
17 | GROUP_NUM | INTEGER | No |
A number that groups a set of items together in an action. If the group number is 0, it means the item and its values apply to every group in the action.
18 | CHANGE_UTC_DTTM | DATETIME (UTC) | No |
The UTC instant that the change happened.