|
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 |
|
|
|
|
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. |
|
|