EXTERNAL_ELIG_INFO
Description:
The EXTERNAL_ELIG_INFO table contains the external eligibility information returned by Rx Hub.

Primary Key
Column Name Ordinal Position
PAT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 EXT_ELIG_ID VARCHAR No
The unique ID of the external eligibility that is returned by RxHub.
4 EXT_ELIG_TYPE_C_NAME VARCHAR No
The external eligibility type category number for the external eligibility information returned by RX Hub.
May contain organization-specific values: Yes
Category Entries:
RxHub
5 EXTERNAL_ELIG_V_YN VARCHAR No
Indicates whether external eligibility is active.
May contain organization-specific values: No
Category Entries:
Yes
No
6 EXTERNAL_ELIG_S_ID VARCHAR No
This is the unique ID of the external eligibility source returned by RxHub.
7 EXT_ELIG_MATCH_YN VARCHAR No
Indicates whether external eligibility has been user verified.
The category values for this column were already listed for column: EXTERNAL_ELIG_V_YN
8 EXT_ELIG_NCPDP_ID VARCHAR No
Stores NCPDP value from Rx Eligibility responses into EPT 42021: EXTERNAL_ELIGIBILITY NCPDP VALUE.
9 EXT_ELIG_CH_ID VARCHAR No
Cardholder ID for mail order
10 EXT_ELIG_CH_NAME VARCHAR No
Cardholder Name for mail order
11 EXT_ELIG_GRP_ID VARCHAR No
Group ID for mail order
12 EXT_ELIG_PCN_NUM VARCHAR No
Plan network ID returned from SureScripts
13 EXT_ELIG_BIN_NUM VARCHAR No
Bin number returned from SureScripts
14 EXT_ELIG_DEP_YN VARCHAR No
Whether member is a dependent of the coverage
The category values for this column were already listed for column: EXTERNAL_ELIG_V_YN
15 EXT_ELIG_PAYOR_NAME VARCHAR No
Holds the PBM (Payor) name received on the e-prescribing eligibility response.
16 EXT_ELIG_CH_LNAME VARCHAR No
Holds the cardholder last name as received from the e-prescribing interface.
17 EXT_ELIG_CH_FNAME VARCHAR No
Holds the cardholder first name as received from the e-prescribing interface.
18 EXT_ELIG_CH_MNAME VARCHAR No
Holds the cardholder middle name as received from the e-prescribing interface.
19 EXT_ELIG_CH_SUFFIX VARCHAR No
Holds the cardholder suffix as received from the e-prescribing interface.
20 EXT_ELIG_GRP_NAME VARCHAR No
Holds the Group Name as received from the e-prescribing interface.
21 EXT_ELIG_ENT_IDENT_C_NAME VARCHAR No
Contains the entity identifier code as received from the e-prescribing interface.
May contain organization-specific values: No
Category Entries:
Dependent
Contracted Service Provider
Consultant’s Office
Health Maintenance Organization (HMO)
Oncology Center
Kidney Dialysis Unit
Preferred Provider Organization (PPO)
Acute Care Hospital
Provider
Military Facility
University, College or School
Outpatient Surgicenter
Physician, Clinic or Group Practice
Long Term Care Facility
Extended Care Facility
Psychiatric Health Facility
Laboratory
Retail Pharmacy
Home Health Care
Subcontractor
Federal, State, County or City Facility
Third-Party Administrator
Miscellaneous Health Care Facility
Non-Health Care Miscellaneous Facility
Church Operated Facility
Partnership
Public Health Service Facility
Veterans Administration Facility
Public Health Service Indian Service Facility
Hospital Unit of an Institution (prison hospital, college infirmary, etc.)
Service Supplier
Employer
Hospital Unit Within an Institution for the Mentally Retarded
Tuberculosis and Other Respiratory Diseases Facility
Obstetrics and Gynecology Facility
Eye, Ear, Nose and Throat Facility
Rehabilitation Facility
Orthopedic Facility
Chronic Disease Facility
Other Specialty Facility
Children’s General Facility
Children’s Hospital Unit of an Institution
Children’s Psychiatric Facility
Children’s Tuberculosis and Other Respiratory Diseases Facility
Children’s Eye, Ear, Nose and Throat Facility
Children’s Rehabilitation Facility
Children’s Orthopedic Facility
Children’s Chronic Disease Facility
Children’s Other Specialty Facility
Institution for Mental Retardation
Alcoholism and Other Chemical Dependency Facility
General Inpatient Care for AIDS/ARC Facility
AIDS/ARC Unit
Specialized Outpatient Program for AIDS/ARC
Alcohol/Drug Abuse or Dependency Inpatient Unit
Alcohol/Drug Abuse or Dependency Outpatient Services
Arthritis Treatment Center
Receiver
Claimant Authorized Representative
Data Processing Service Bureau
Birthing Room/LDRP Room
Burn Care Unit
Cardiac Catherization Laboratory
Open-Heart Surgery Facility
Cardiac Intensive Care Unit
Angioplasty Facility
Chronic Obstructive Pulmonary Disease Service Facility
Emergency Department
Trauma Center (Certified)
Extracorporeal Shock-Wave Lithotripter (ESWL) Unit
Genetic Counseling/Screening Services
Adult Day Care Program Facility
Alzheimer’s Diagnostic/Assessment Services
Comprehensive Geriatric Assessment Facility
Emergency Response (Geriatric) Unit
Geriatric Acute Care Unit
Geriatric Clinics
Respite Care Facility
Patient Education Unit
Community Health Promotion Facility
Worksite Health Promotion Facility
Hemodialysis Facility
Home Health Services
Hospice
Medical Surgical or Other Intensive Care Unit
Hisopathology Laboratory
Blood Bank
Neonatal Intensive Care Unit
Obstetrics Unit
Occupational Health Services
Organized Outpatient Services
Pediatric Acute Inpatient Unit
Psychiatric Child/Adolescent Services
Psychiatric Consultation-Liaison Services
Psychiatric Education Services
Psychiatric Emergency Services
Psychiatric Geriatric Services
Psychiatric Inpatient Unit
Psychiatric Outpatient Services
Psychiatric Partial Hospitalization Program
Megavoltage Radiation Therapy Unit
Radioactive Implants Unit
Therapeutic Radioisotope Facility
X-Ray Radiation Therapy Unit
CT Scanner Unit
Diagnostic Radioisotope Facility
Magnetic Resonance Imaging (MRI) Facility
Ultrasound Unit
Rehabilitation Inpatient Unit
Rehabilitation Outpatient Services
Performed At
Reproductive Health Services
Skilled Nursing or Other Long-Term Care Unit
Single Photon Emission Computerized Tomography (SPECT) Unit
Organized Social Work Service Facility
Outpatient Social Work Services
Emergency Department Social Work Services
Sports Medicine Clinic/Services
Hospital Auxiliary Unit
Patient Representative Services
Volunteer Services Department
Outpatient Surgery Services
Organ/Tissue Transplant Unit
Orthopedic Surgery Facility
Occupational Therapy Services
Physical Therapy Services
Recreational Therapy Services
Respiratory Therapy Services
Speech Therapy Services
Women’s Health Center/Services
Cardiac Rehabilitation Program Facility
Non-Invasive Cardiac Assessment Services
Emergency Medical Technician
Disciplinary Contact
Case Manager
Attending Physician
Operating Physician
Other Physician
Corrected Insured
Service Location
Place of Occurrence
Hospital
Rendering Provider
Subscriber’s Employer
Billing Provider
Pay-to Provider
Research Institute
Pharmacist
Admitting Surgeon
Commercial Insurer
Assistant Surgeon
Consulting Physician
Ordering Physician
Referring Provider
Dependent Name
Supervising Physician
Person or Other Entity Legally Responsible for a Child
Person or Other Entity With Whom a Child Resides
Previous Employer
Participating Laboratory
Facility
Physical Address
Mail Address
Dependent Insured
Clinic
Other Insured
Guardian
Paramedic
Paramedical Company
Previous Insured
Spouse Insured
Treatment Facility
Healthcare Professional Shortage Area (HPSA) Facility
Home Health Agency
Independent Physicians Association (IPA)
Injection Point
Insured or Subscriber
Insurer
Independent Lab
Legal Representative
Medical Insurance Carrier
Mammography Screening Center
Ordered By
Doctor of Optometry
Oxygen Therapy Facility
Patient Facility
Primary Insured or Subscriber
Primary Care Provider
Prior Insurance Carrier
Third Party Reviewing Preferred Provider Organization (PPO)
Third Party Repricing Preferred Provider Organization (PPO)
Primary Payer
Party to Receive Test Report
Party performing certification
Pickup Address
Pharmacy
Purchase Service Provider
Patient
Responsible Party
Policyholder
Physician
Managed Care
Chiropractor
Dentist
Doctor of Osteopathy
Podiatrist
Group Practice
Medical Doctor
Receiving Location
Rural Health Clinic
Skilled Nursing Facility
Secondary Payer
Service Provider
Supplier/Manufacturer
Transfer Point
Testing Laboratory
Third Party Reviewing Organization (TPO)
Transfer To
Tertiary Payer
Third Party Repricing Organization (TPO)
Nursing Home
Utilization Management Organization
Spouse
Durable Medical Equipment Supplier
Mutually Defined
Subscriber
Admitting Services