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.