PAT_ENC_MSP_ESRD

Description: |
This table contains the ESRD (End Stage Renal Disease) part of the Medicare Secondary Payor Information from the Patient (EPT) master file.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ENC_CSN_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ENC_CSN_ID | NUMERIC | No |
A unique serial number for this encounter. This number is unique across all patients and encounters in the system.
2 | CONTACT_DATE | DATETIME | No |
The date (calendar format) on which the encounter took place.
3 | END_STAGE_RNL_YN | VARCHAR | No |
YES if the patient is entitled to Medicare because of End Stage Renal Disease
May contain organization-specific values: Yes
Category Entries:
Yes
No
4 | DIALYSIS_BGN_DATE | DATETIME | No |
Date when dialysis began.
5 | COORD_PERIOD_YN | VARCHAR | No |
YES if the patient is still in the coordination period.
May contain organization-specific values: Yes
Category Entries:
Yes
No
6 | RECVG_TRNG_YN | VARCHAR | No |
YES if the patient is receiving training for self-dialysis.
May contain organization-specific values: Yes
Category Entries:
Yes
No
7 | DIAL_TRN_BEGN_DATE | DATETIME | No |
Date when self-dialysis training began.
8 | MEDIC_INIT_ESRD_YN | VARCHAR | No |
YES if the patient's initial entitlement to Medicare was based on End Stage Renal Disease (ESRD).
May contain organization-specific values: No
Category Entries:
Yes
No
9 | PART_A_EFF_DATE | DATETIME | No |
Part A effective date.
10 | RNAL_TRANSPLT_YN | VARCHAR | No |
YES if the patient has had a kidney transplant because of End Stage Renal Disease (ESRD).
May contain organization-specific values: No
Category Entries:
Yes
No
11 | RNAL_TRANSPLT_DATE | DATETIME | No |
Date of the transplant.
12 | BLACK_LUNG_YN | VARCHAR | No |
YES if the patient is entitled to benefits under the Black LungProgram.
May contain organization-specific values: Yes
Category Entries:
Yes
No
13 | BLACK_LUNG_NUM | VARCHAR | No |
Black Lung program ID number.
14 | BLCK_LUNG_COVD_YN | VARCHAR | No |
YES if the services being received are on the list of covered procedures for treatment of Black Lung.
May contain organization-specific values: Yes
Category Entries:
Yes
No
15 | BLK_LUNG_BNFT_DATE | DATETIME | No |
Date the benefits for the Black Lung program began.
16 | PHS_YN | VARCHAR | No |
YES if the services are covered by a Public Health Service or Research Program.
May contain organization-specific values: No
Category Entries:
Yes
No
17 | PHS_START_DATE | DATETIME | No |
Start date of the Public Health Service (PHS) or research program.
18 | PHS_END_DATE | DATETIME | No |
End date of the Public Health Service (PHS) or research program.
19 | PHS_PROGRM_NAME | VARCHAR | No |
Name of the Public Health Service (PHS) or research program.
20 | PHS_PROGRM_ADR_1 | VARCHAR | No |
Line 1 of Public Health Service (PHS) program address.
21 | PHS_PROGRM_ADR_2 | VARCHAR | No |
Line 2 of the Public Health Service (PHS) program address.
22 | PHS_PROGRM_CITY | VARCHAR | No |
City of the Public Health Service (PHS) or research program.
23 | PHS_PROGRM_ZIP | VARCHAR | No |
ZIP Code of the Public Health Service (PHS) or research program.
24 | IS_MSP_DIALYSIS_YN | VARCHAR | No |
Indicates whether the patient has received maintenance dialysis treatments.
The category values for this column were already listed for column: MEDIC_INIT_ESRD_YN
25 | MSP_GHP_PRIOR_YN | VARCHAR | No |
MSP Item: tracks if the patient was receiving Group Health Plan (GHP) coverage prior to their coverage through Medicare. This has an influence on how the filing order is calculated after the MSPQ has been completed.
May contain organization-specific values: No
Category Entries:
Yes
No