PAT_ENC_MSP_EGHP2
Description:
This table contains the Secondary Employer Group Health Plan Info part of the Medicare Secondary Payor Information from the Patient (EPT) master file. Some questionnaires use this as the spouse's EGHP info rather than the 'secondary' 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 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
4 EGHP_EMPLOYEE_NAME VARCHAR No
Name of the person whose employer group health plan (EGHP) covers the patient.
5 OTHR_EGHP_REL_C_NAME VARCHAR No
The coverage subscriber's relationship to the patient.
May contain organization-specific values: Yes
Category Entries:
Self
Spouse
Child
Employee
Unknown
6 OTHR_EGHP_PCP VARCHAR No
Name of the patient's Primary Care Provider.
7 OTH_EGHP_EMPL_NAME VARCHAR No
The employer that sponsors the employer group health plan (EGHP).
8 OTH_EGHP_EMPL_PHON VARCHAR No
The employer's phone number.
9 OTH_EGHP_EMPL_AD_1 VARCHAR No
Secondary employer group health plan (EGHP) address line 1.
10 OTH_EGHP_EMPL_AD_2 VARCHAR No
Secondary employer group health plan (EGHP) address line 2.
11 OTH_EGHP_EMPL_CITY VARCHAR No
Secondary employer group health plan (EGHP) subscriber's employer city.
12 OTH_EGHP_EMPL_ZIP VARCHAR No
Secondary employer group health plan (EGHP) subscriber's employer zip
13 OTH_EGHP_INSR_COMP VARCHAR No
Name of the secondary employer group health plan (EGHP).
14 OTH_CVG_HMO_YN VARCHAR No
YES if coverage is an HMO.
May contain organization-specific values: Yes
Category Entries:
Yes
No
15 OTH_EGHP_POLCY_NUM VARCHAR No
Patient's member number for the secondary employer group health plan (EGHP).
16 OTH_EGHP_GROUP_NUM VARCHAR No
Group number of the secondary employer group health plan (EGHP).
17 OTH_EGHP_INSR_AD_1 VARCHAR No
Secondary employer group health plan (EGHP) address line 1.
18 OTH_EGHP_INSR_AD_2 VARCHAR No
Secondary employer group health plan (EGHP) address line 2.
19 OTH_EGHP_INSR_CITY VARCHAR No
Secondary employer group health plan (EGHP) city.
20 OTH_EGHP_INSR_ZIP VARCHAR No
Secondary employer group health plan (EGHP) Zip.
21 OTH_EGHP_20_EMP_YN VARCHAR No
Does the employer that sponsors this group health plan have 20 or more employees?
May contain organization-specific values: No
Category Entries:
Yes
No
22 OTH_EGHP_100_EMP_YN VARCHAR No
Does the employer that sponsors this group health plan have 100 or more employees?
The category values for this column were already listed for column: OTH_EGHP_20_EMP_YN
23 OTH_EGHP_BEN_PKG VARCHAR No
The benefit package number or policy ID number for the employer group health plan.
24 OTH_EGHP_CUR_EMP_YN VARCHAR No
Yes if the employer group health plan is through the subscriber's current employment.
The category values for this column were already listed for column: OTH_EGHP_20_EMP_YN