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.