RXA_ATTEMPT

Description: |
Contains information about adjudication records, including the user and workstation that initiated the adjudication, the National Council for Prescription Drug Programs (NCPDP) transaction type, and the date the record was created. Adjudication records are used during prescription copay adjudication.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
RECORD_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | RECORD_ID | NUMERIC | No |
The unique identifier for the adjudication record.
2 | RECORD_STATUS_C_NAME | VARCHAR | No |
The record status category ID of the adjudication message (hidden, soft-deleted, etc...)
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
3 | ADJ_WORKSTATION_ID_WORKSTATION_NAME | VARCHAR | No |
This is the internal workstation name.
4 | USER_ID | VARCHAR | No |
The user who initiated the adjudication.
5 | USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
6 | RECORD_CREATION_DT | DATETIME | No |
Stores the date the record was created
7 | UPDATE_DATETIME | DATETIME (Local) | No |
Stores the instant the record was last locked/unlocked
8 | ADJ_INTENT_C_NAME | VARCHAR | No |
The overall intent category ID of the adjudication message (for example, reversal or billing).
May contain organization-specific values: No
Category Entries:
Billing
Reversal
9 | MESSAGE_SOURCE_C_NAME | VARCHAR | No |
The source category ID of the adjudication message.
May contain organization-specific values: No
Category Entries:
Pharmacy
Clinician Order Entry
Additional Coverage Information
Eligibility Query
HAAD Transaction
10 | ADJ_DEPARTMENT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
11 | TEST_CLAIM_YN | VARCHAR | No |
Indicates if the adjudication attempt is a test claim. 'N' or NULL indicate that the attempt is not a test claim. 'Y' indicates that the attempt is a test claim.
May contain organization-specific values: No
Category Entries:
No
Yes
12 | PAT_ID | VARCHAR | No |
The patient record to which this RXA record is associated. For Eligibility checking, this identifies the patient for whom the check is being performed.