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