V_EHI_COVERAGE_SUBS
Description:
This view contains information about a coverage's subscriber. Used for Electronic Health Information (EHI) export.

Primary Key
Column Name Ordinal Position
COVERAGE_ID 1

Column Information
Name Type Discontinued?
1 COVERAGE_ID NUMERIC No
The unique ID assigned to the coverage record. This ID may be encrypted if you have elected to use enterprise reporting’s encryption utility.
2 SUBSCRIBER_PAT_ID VARCHAR No
If the subscriber is the same person as a patient, this item contains the patient ID.
3 SUBSCRIBER_CONFDENTIAL_NAME VARCHAR No
This item contains the confidential name of the associated patient, if it exists. The name is used to determine the confidential nature of the subscriber.
4 SUBSCRIBER_NUMBER VARCHAR No
The identification number assigned to the subscriber for the coverage. When the subscriber is also a member on the coverage, this is the same as the subscriber’s member number. This column may be hidden if you have elected to use enterprise reporting’s security utility.
5 SUBSCRIBER_ID_FROM_SOURCE_FILE VARCHAR No
Subscriber ID received on the source file for the subscriber on the coverage.
6 SUBSCRIBER_MEDICARE_NUMBER VARCHAR No
Stores the subscriber's Medicare number, if applicable. This will be a Medicare Beneficiary Number (MBI) if available, or a Health Insurance Claim Number (HICN) if not.
7 SUBSCRIBER_MEDICARE_HIC_NUMBER VARCHAR No
Contains the subscriber Health Insurance Claim Number (HICN) once it has been replaced by the Medicare Beneficiary Number (MBI).
8 SUBSCRIBER_SEX_C_NAME VARCHAR No
The sex of the subscriber on the coverage.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Unknown
Nonbinary
X
Other
9 SUBSCRIBER_GENDER_IDENTITY_C_NAME VARCHAR No
Stores the category ID of the subscriber's gender identity as stored on the coverage. This value may not be the same as the gender identity stored on the subscriber's patient record.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Transgender Female
Transgender Male
Other
Choose not to disclose
Nonbinary
Genderqueer
10 SUBSCRIBER_RACE_C_NAME VARCHAR No
The race of the subscriber.
May contain organization-specific values: Yes
No Entries Defined
11 SUBSCRIBER_PREFERRED_NAME VARCHAR No
Stores the preferred name of the subscriber as present on the coverage record at the time of coverage creation. This value may not be the same as the preferred name stored on the subscriber's patient record.
12 SUBSCRIBER_NAME VARCHAR No
The name of the subscriber for the coverage. This column may be hidden if you have elected to use enterprise reporting’s security utility.
13 SUBSCRIBER_EMPLOYER_COUNTY_C_NAME VARCHAR No
The county of the subscriber's employer's address on a coverage
May contain organization-specific values: Yes
14 SUBSCRIBER_REL_TO_GUAR_C_NAME VARCHAR No
The category number for the subscriber's relationship to the guarantor.
May contain organization-specific values: Yes
Category Entries:
Aunt
Brother
Daughter
Father
Friend
Granddaughter
Grandfather
Grandmother
Grandson
Legal Guardian
Mother
Other
Step Father
Sister
Self
Step Mother
Son
Spouse
Uncle
Employer
Unverified Proxy
Transplant Recipient
Visit Contact
15 SUBSCRIBER_EMPLOYER_HOUSE_NUM VARCHAR No
The house number of the subscriber's employer's address on a coverage
16 SUBSCRIBER_EMPLOYER_DISTRICT_C_NAME VARCHAR No
The district of the subscriber's employer's address on a coverage
May contain organization-specific values: Yes
17 SUBSCRIBER_EMPLOYER_ID VARCHAR No
This is the unique ID of the employer of the patient subscribing to the coverage if EAF 6410 is set to 1. This is free text if EAF 6410 is set to 2.
18 SUBSCRIBER_EMPLOYER_ID_EMPLOYER_NAME VARCHAR No
The name of the employer.
19 SUBSCRIBER_EMPLOYER_COMMENT VARCHAR No
A free text comment that can be entered when the value that is considered to be "Other" is selected as the employer. This option is available only if your organization has chosen to link the subscriber employer to the Employer (EEP) master file in the Facility Profile.
20 SUBSCRIBER_EMPLOYER_CITY VARCHAR No
The City field of the subscriber's employer's address on the coverage.
21 SUBSCRIBER_EMPLOYER_STATE_C_NAME VARCHAR No
The state of the subscriber's employer's address on a coverage.
May contain organization-specific values: Yes
22 SUBSCRIBER_EMPLOYER_ZIP VARCHAR No
The zip code of the subscriber's employer's address on a coverage
23 SUBSCRIBER_EMPLOYMENT_STATUS_C_NAME VARCHAR No
The employment status of the subscriber's employer on a coverage (i.e. full, part, etc.).
May contain organization-specific values: Yes
Category Entries:
Full Time
Part Time
Not Employed
Self Employed
Retired
On Active Military Duty
Student - Full Time
Student - Part Time
Unknown
24 SUBSCRIBER_EMPLOYER_COUNTRY_C_NAME VARCHAR No
The category number for the country of the subscriber's employer.
May contain organization-specific values: Yes
25 SUBSCRIBER_EMPLOYER_PHONE VARCHAR No
The phone number of the subscriber's employer on a coverage
26 SUBSCRIBER_EMPLOYER_FAX VARCHAR No
The fax number of the coverage subscriber's employer.
27 SUBSCRIBER_EMPLOYEE_ID_NUMBER VARCHAR No
The coverage subscriber's employee ID number.
28 SUBSCRIBER_ADDR_IS_UNDELIV_YN VARCHAR No
Indicates if subscriber home address is undeliverable.
May contain organization-specific values: No
Category Entries:
No
Yes
29 SUBSCRIBER_HOUSE_NUMBER VARCHAR No
Subscriber House Number for non-US locales
30 SUBSCRIBER_CITY VARCHAR No
The city of the mailing address for the subscriber on the coverage.
31 SUBSCRIBER_STATE_C_NAME VARCHAR No
The state of the mailing address for the subscriber on the coverage.
The category values for this column were already listed for column: SUBSCRIBER_EMPLOYER_STATE_C_NAME
32 SUBSCRIBER_SUBDIVISION_CODE_C_NAME VARCHAR No
Capture the subscriber's country subdivision code.
May contain organization-specific values: Yes
No Entries Defined
33 SUBSCRIBER_ZIP VARCHAR No
The postal code of the mailing address for the subscriber on the coverage.
34 SUBSCRIBER_COUNTRY_C_NAME VARCHAR No
The country of the mailing address for the subscriber on the coverage.
The category values for this column were already listed for column: SUBSCRIBER_EMPLOYER_COUNTRY_C_NAME
35 SUBSCRIBER_COUNTY_C_NAME VARCHAR No
The county of the mailing address for the subscriber on the coverage.
The category values for this column were already listed for column: SUBSCRIBER_EMPLOYER_COUNTY_C_NAME
36 SUBSCRIBER_IS_US_CITIZEN_YN VARCHAR No
Indicates whether the subscriber is a U.S. citizen.
May contain organization-specific values: Yes
Category Entries:
Yes
No
37 SUBSCRIBER_DISTRICT_C_NAME VARCHAR No
The district of the mailing address for the subscriber on the coverage.
The category values for this column were already listed for column: SUBSCRIBER_EMPLOYER_DISTRICT_C_NAME
38 SUBSCRIBER_PHONE VARCHAR No
The home phone number for the subscriber on the coverage.
39 SUBSCRIBER_FAX VARCHAR No
The fax number for the subscriber on the coverage.
40 SUBSCRIBER_WORK_PHONE VARCHAR No
The work phone number for the subscriber on the coverage.
41 SUBSCRIBER_BIRTH_DATE DATETIME No
The date of birth for the subscriber on the coverage.
42 SUBSCRIBER_MARITAL_STATUS_C_NAME VARCHAR No
The marital status of the subscriber.
May contain organization-specific values: Yes
Category Entries:
Single
Married
Divorced
43 SUBSCRIBER_SSN VARCHAR No
The SSN number of the subscriber on a coverage
44 SUBSCRIBER_OCCUPATION VARCHAR No
The coverage subscriber's occupation.
45 SUBSCRIBER_RETIRE_DATE DATETIME No
The date when the coverage subscriber retired.
46 SUBSCRIBER_SPOUSE_RETIRE_DATE DATETIME No
The date when the coverage subscriber's spouse retired.
47 SUBSCRIBER_ADDRESS_IS_VALID_C_NAME VARCHAR No
The category ID which indicates whether the subscriber address has been validated.
May contain organization-specific values: No
Category Entries:
Not Validated
Valid
Invalid
Could not validate (System Error)
48 SUBSCRIBER_ADDR_VALID_MTHD_C_NAME VARCHAR No
The category ID which indicates the validation method by which the subscriber address was validated.
May contain organization-specific values: No
Category Entries:
Manually by end user
System-validated
49 SUBSCRIBER_ADDR_VALID_UTC_DTTM DATETIME (UTC) No
The UTC date and time when the subscriber address was last validated.
50 SUBSCRIBER_BNK_ID VARCHAR No
Banking details of the subscriber.
51 SUBSCRIBER_ALT_BILL_NAME VARCHAR No
The alternate billing name for the coverage subscriber.
52 SUBSCRIBER_ALT_BIRTH_DATE DATETIME No
The alternate subscriber date of birth override for use with interfaces.
53 SUBSCRIBER_ALT_SEX_C_NAME VARCHAR No
The subscriber's sex as known to the payor.
The category values for this column were already listed for column: SUBSCRIBER_SEX_C_NAME
54 SUBSCRIBER_CHAMPUS_STATUS VARCHAR No
The CHAMPUS/Tricare subscriber status.
55 SUBSCRIBER_EMPLOYMENT_DATE DATETIME No
The date on which the subscriber began working for the employer associated with the employer group.
56 SUBSCRIBER_APPLICATION_DATE DATETIME No
The date on which the subscriber applied for coverage.
57 MEDICARE_SUBSCRIBER_IDENT VARCHAR No
The unique ID of the subscriber that will be used for supplemental claims.
58 RQG_REL_TO_SUBSCRIBER_C_NAME VARCHAR No
The patient to subscriber relationship category number for this coverage.
May contain organization-specific values: Yes
Category Entries:
Self
Spouse
Child
Employee
Unknown
59 SUBSCRIBER_HAS_ICHRA_YN VARCHAR No
Indicator for whether the subscriber is enrolled in an individual coverage HRA.
The category values for this column were already listed for column: SUBSCRIBER_ADDR_IS_UNDELIV_YN
60 MCARE_GENDER_IDENTITY_C_NAME VARCHAR No
The gender identity denoted by the subscriber on their Medicare Advantage application.
May contain organization-specific values: No
Category Entries:
Woman
Man
Non-binary
I use a different term
I choose not to answer
Form left blank
61 MCARE_SEX_ORIENTATION_C_NAME VARCHAR No
The sexual orientation denoted by the subscriber on their Medicare Advantage application.
May contain organization-specific values: No
Category Entries:
Lesbian or gay
Straight, that is not gay or lesbian
Bisexual
I use a different term
I don't know
I choose not to answer
Form left blank
62 MCARE_SPEC_GENDER_IDENTITY VARCHAR No
The term the subscriber specified for their gender identity on their Medicare Advantage application because a value for their gender identity was not present on the application.
63 MCARE_SPEC_SEX_ORIENTATION VARCHAR No
The term the subscriber specified for their sexual orientation on their Medicare Advantage application because a value for their sexual orientation was not present on the application.
64 MCARE_INDIV_REP_NAME VARCHAR No
The name of the individual representative that helped the subscriber fill out their Medicare Advantage application.
65 MCARE_INDIV_REP_REL_C_NAME VARCHAR No
The relationship of the individual representative to the subscriber that they helped fill out the Medicare Advantage application for.
May contain organization-specific values: No
Category Entries:
Agent
Broker
SHIP counselor
Authorized representative
Other (third party)
Self
I choose not to answer
66 MCARE_INDIV_REP_NPN VARCHAR No
The National Producer Number of the individual representative that helped the subscriber fill out the Medicare Advantage application, if the individual representative is an agent or a broker.