RXA_ADJUD_MESSAGE_5

Description:

Contains information relating to a single contact of an adjudication record. Adjudication records are used by pharmacy during prescription claim adjudication.

Primary Key

Column Name	Ordinal Position
RECORD_ID	1
CONTACT_DATE_REAL	2

Column Information

	Name	Type	Discontinued?
1	RECORD_ID	NUMERIC	No
	The unique identifier (.1 item) for the adjudication record.
2	CONTACT_DATE_REAL	FLOAT	No
	A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
4	O_PRES_CNTY_CODE_ID	NUMERIC	No
	Code of the country.
5	O_PRES_CNTY_CODE_ID_EXT_CODE_LST_NAME	VARCHAR	No
	The name of the list value.
6	O_PRES_ALT_ID_QL_ID	NUMERIC	No
	A code qualifying the Prescriber Alternate ID (A26-ZP).
7	O_PRES_ALT_ID_QL_ID_EXT_CODE_LST_NAME	VARCHAR	No
	The name of the list value.
8	O_PRES_ALT_ID_S	VARCHAR	No
	An alternate ID assigned to the prescriber (A26-ZP).
9	O_PR_ALT_ID_ST_CODE_ID	NUMERIC	No
	State/Province Code associated with the Prescriber Alternate ID Qualifier (A25-ZM) and the Prescriber Alternate ID (A26-ZP).
10	O_PR_ALT_ID_ST_CODE_ID_EXT_CODE_LST_NAME	VARCHAR	No
	The name of the list value.
11	O_PR_ALT_ID_CT_CODE_ID	NUMERIC	No
	Code of the country (B40-3A).
12	O_PR_ALT_ID_CT_CODE_ID_EXT_CODE_LST_NAME	VARCHAR	No
	The name of the list value.
13	O_FACLTY_ID_QUAL_ID	NUMERIC	No
	Code qualifying the Facility ID (336-8C).
14	O_FACLTY_ID_QUAL_ID_EXT_CODE_LST_NAME	VARCHAR	No
	The name of the list value.
15	O_FAC_STRT_ADDR_ONE	VARCHAR	No
	Free form text for Facility address line 1 information (B20-7M).
16	O_FAC_STRT_ADDR_TWO	VARCHAR	No
	Free form text for Facility address line 2 information (B21-7N).
17	O_FAC_CNTRY_CODE_ID	NUMERIC	No
	Code of the country (B37-1X).
18	O_FAC_CNTRY_CODE_ID_EXT_CODE_LST_NAME	VARCHAR	No
	The name of the list value.
19	O_LAST_KNOWN_IIN	VARCHAR	No
	Last known Card Issuer ID or Issuer Identification Number used for network routing used on a previous claim (B56-3E).
20	O_LAST_KNOWN_PCN	VARCHAR	No
	Last known number assigned by the processor used on a previous claim (B57-3F).
21	O_LST_KNWN_GRP_ID_S	VARCHAR	No
	Last known ID assigned to the cardholder group or employer group used on a previous claim (B58-3G).
22	O_LST_KNWN_CH_ID_S	VARCHAR	No
	Last known insurance ID assigned to the cardholder or identification number used by the plan used on a previous claim (B59-3H).
23	O_LAST_P_CLAIM_YEAR	VARCHAR	No
	Identifies the year used on a previous claim (B60-3J).
24	O_LAST_P_CLAIM_MNTH	VARCHAR	No
	Identifies the month used on a previous claim (B61-3K).