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.