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.