RXA_NCPDP_OVERRIDE

Description:

National Council for Prescription Drug Programs (NCPDP) override values during prescription claims adjudication.

Primary Key

Column Name	Ordinal Position
RECORD_ID	1
CONTACT_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	RECORD_ID	NUMERIC	No
	The unique identifier 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	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
5	OVR_NCPDP_FIELD	VARCHAR	No
	The override NCPDP field to be sent out during prescription adjudication.
6	OVR_NCPDP_VALUE	VARCHAR	No
	The override NCPDP value to be sent out during prescription adjudication.
7	OVR_NCPDP_PARENT	VARCHAR	No
	Override NCPDP parent fields to be sent out during prescription adjudication. When a user enters an override value for an NCPDP field and that NCPDP field is part of a counter, the system automatically populates this column with the field ID of the counter parent. If the field being overridden is part of a double-counter (such as in the COB segment), this column stores both counters, the parent of the field, and the parent of that parent. For example, if 431-DV is overridden with 10.00, RXA 1220 stores 341-HB, 337-4C.
8	OVR_NCPDP_PRN_COUNT	INTEGER	No
	The parent counter for the NCPDP override. For a field under a single counter, this does not apply. For a field that is under a double counter (e.g. 363-2H Compound Ingredient Modifier Code in the Compound segment), this is the index of main counter (e.g. for compounds, this indicates which ingredient it is).
9	OVERRIDE_SEGMENT	VARCHAR	No
	The NCPDP segment that the override field belongs to.
10	OVR_NCPDP_CTR_IDX	INTEGER	No
	The counter index for the NCPDP override. For a field under a single counter, this is the index for that field. For a field under a double counter (e.g. 363-2H Compound Ingredient Modifier Code in the Compound segment), this is also the index for that field. For example, if there are two values for field 363-2H for the third ingredient in the compound, then this item tracks the index for these two values. That is, item 1230 will have a value of 3 (for the third ingredient), item 1225 will have a value of 1 for the first 363-2H value, and a value of 2 for the second 363-2H value.