PAT_ENC_MSP_EGHP
Description:
This table contains the Primary Employer Group Health Plan Info part of the Medicare Secondary Payor Information from the Patient (EPT) master file. Some questionnaires use this as the patient's EGHP info rather than the 'primary' EGHP info.

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 SELF_EGHP_YN VARCHAR No
YES if the patient has employer group health plan (EGHP) coverage based on own or a family member's current or former employment.
May contain organization-specific values: Yes
Category Entries:
Yes
No
4 OTHER_EGHP_YN VARCHAR No
YES if the patient is covered by another employer group health plan (EGHP) in addition to the one listed under Primary EGHP.
May contain organization-specific values: Yes
Category Entries:
Yes
No
5 EGHP_INSURED_NAME VARCHAR No
Name of the person whose employer group health plan (EGHP) covers the patient.
6 EGHP_REL_SUBSCRB_C_NAME VARCHAR No
Relationship of the subscriber to the patient.
May contain organization-specific values: Yes
Category Entries:
Self
Spouse
Child
Employee
Unknown
7 EGHP_PCP VARCHAR No
Name of the patient's Primary Care Provider.
8 EGHP_EMPLOYER_NAME VARCHAR No
The employer that sponsors the employer group health plan (EGHP).
9 EGHP_EMPL_ADR_1 VARCHAR No
Employer group health plan (EGHP) subscriber's employer address line 1.
10 EGHP_EMPL_ADR_2 VARCHAR No
Employer group health plan (EGHP) subscriber's employer address line 2.
11 EGHP_EMPL_PHONE VARCHAR No
Employer group health plan (EGHP) subscriber's employer phone number.
12 EGHP_EMPL_CITY VARCHAR No
Employer group health plan (EGHP) subscriber's employer city.
13 EGHP_EMPL_ZIP VARCHAR No
Employer group health plan (EGHP) subscriber's employer zip
14 EGHP_INSUR_COMPANY VARCHAR No
Name of the employer group health plan (EGHP).
15 CVG_HMO_YN VARCHAR No
YES if coverage is an HMO.
May contain organization-specific values: Yes
Category Entries:
Yes
No
16 EGHP_POLICY_NUMBER VARCHAR No
Patient's member number for the employer group health plan (EGHP).
17 EGHP_GROUP_NUMBER VARCHAR No
Group number of the employer group health plan (EGHP).
18 EGHP_INSUR_ADR_1 VARCHAR No
Employer group health plan (EGHP) address line 1.
19 EGHP_INSUR_ADR_2 VARCHAR No
Employer group health plan (EGHP) address line 2.
20 EGHP_INSUR_CITY VARCHAR No
Employer group health plan (EGHP) city.
21 EGHP_INSUR_ZIP VARCHAR No
Employer group health plan (EGHP) Zip.
22 EGHP_PAT_SUP_INF_C VARCHAR No
Used to store whether or not the patient refused to provide information pertaining to the MSPQ EGHP question.
May contain organization-specific values: No
Category Entries:
Yes
No
23 EGHP_BEN_PKG VARCHAR No
The benefit package number or policy ID number for the employer group health plan.
24 EGHP_CUR_EMPL_YN VARCHAR No
Yes if the employer group health plan is through the subscriber's current employment. Some questionnaires use this instead of Covered by Employer Group Health Plan (I EPT 4672).
The category values for this column were already listed for column: EGHP_PAT_SUP_INF_C
25 MSP_SELF_NUMBER_EMPLOYEES_C_NAME VARCHAR No
MSP Item: tracks the number of employees of the patient's GHP provider
May contain organization-specific values: No
Category Entries:
1-19
20-99
100+