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