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.