LCI_HISTORICAL_DATA

Description: |
Data describing the beneficiary's coverage over time.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
EXTERNAL_CVG_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | EXTERNAL_CVG_ID | NUMERIC | No |
The unique identifier (.1 item) for the external 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 | HIST_FILE_TIMESTAMP_UTC_DTTM | DATETIME (UTC) | No |
Contains the file timestamp for every file loaded.
4 | HIST_EXTERNAL_COVERAGE_TYPE_C_NAME | NUMERIC | No |
The coverage type. This data is tracked over time per file.
May contain organization-specific values: No
Category Entries:
Medicare Part A
Medicare Part B
5 | HIST_COVERAGE_BEGIN_DATE | DATETIME | No |
The effective start date for the coverage. This data is tracked over time per file.
6 | HIST_MEDICARE_STATUS_C_NAME | NUMERIC | No |
The reason for the beneficiary's Medicare entitlement. This data is tracked over time per file.
May contain organization-specific values: No
Category Entries:
Not Applicable
Aged without ESRD
Aged with ESRD
Disabled without ESRD
Disabled with ESRD
ESRD only
7 | HIST_MCARE_MCAID_DUAL_STAT_C_NAME | NUMERIC | No |
This field indicates whether the patient has Medicare, Medicaid, both, neither, or some partial combination. This data is tracked over time per file.
May contain organization-specific values: No
Category Entries:
No Medicaid status
Eligible - QMB only (partial dual)
Eligible - QMB and Medicaid (full dual)
Eligible - SLMB only (partial dual)
Eligible - SLMB and Medicaid (full dual)
Eligible - QDWI (partial dual)
Eligible - Qualifying individuals (partial dual)
Eligible - Other dual eligibles with Medicaid (full dual)
Eligible - Other dual eligibles without Medicaid (non-dual)
Other full dual
Unknown
8 | HIST_ORIGINAL_MCARE_ELIG_RSN_C_NAME | NUMERIC | No |
The original reason for the beneficiary's Medicare entitlement. This data is tracked over time per file.
May contain organization-specific values: Yes
Category Entries:
Age
Disabled without ESRD
ESRD only
Disabled with ESRD
None of the above
9 | HIST_ENTITLEMENT_BUYIN_IND_C_NAME | NUMERIC | No |
Medicare coverage type (Part A, B, or both) and whether the state paid premiums through a buy-in program. This data is tracked over time per file.
May contain organization-specific values: No
Category Entries:
Not Entitled
Part A Only
Part B Only
Part A and Part B
Part A, State Buy-in
Part B, State Buy-in
Part A and B, State Buy-in
10 | HIST_HOSPICE_BEGIN_DATE | DATETIME | No |
The date that Hospice care enrollment begins. This data is tracked over time per file.
11 | HIST_HOSPICE_END_DATE | DATETIME | No |
The date that Hospice care enrollment ends. This data is tracked over time per file.