|
Name |
Type |
Discontinued? |
|
1 |
PAT_ID |
VARCHAR |
No |
|
|
|
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table. |
|
|
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 |
MCARE_HEALTH_STATUS_C_NAME |
VARCHAR |
No |
|
|
|
Stores the category number for a Health Status Flag. A health status flag is an indicator that comes from CMS for Medicare Advantage members. |
May contain organization-specific values: No |
Category Entries: |
Long Term Institutional |
ESRD |
Medicaid |
Hospice |
Disabled |
Dialysis |
Institutional |
Home and Community Based Services |
Nursing Home Certifiable |
Kidney Transplant |
|
|
4 |
START_DATE |
DATETIME |
No |
|
|
|
Stores the start date of the corresponding health status flag. |
|
|
5 |
END_DATE |
DATETIME |
No |
|
|
|
Stores the end date of the corresponding health status flag. |
|
|