CLP_NDC_RELATED

Description:

This table holds the National Drug Code (NDC) information on the claim.

Primary Key

Column Name	Ordinal Position
CLAIM_PRINT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	CLAIM_PRINT_ID	NUMERIC	No
	This is the claim record ID.
2	LINE	INTEGER	No
	The line number of one of the multiple values associated with a specific group of data within this record.
3	NDC_CODE_ID	VARCHAR	No
	This is the National Drug Code ID.
4	NDC_CODE_ID_NDC_CODE	VARCHAR	No
	The external code for the National Drug Code (NDC). An NDC represents packages of medications.
5	NDC_NUMBER	VARCHAR	No
	This is the National Drug Code number.
6	NDC_QTY	NUMERIC	No
	This is the National Drug Code quantity.
7	NDC_UNITS_C_NAME	VARCHAR	No
	This holds the units of the drug. The units are billing appropriate. May contain organization-specific values: No Category Entries: Milliliters Milligrams Grams International Units Units
8	CLAIM_LINE_PTR	NUMERIC	No
	This field points to a claim line.
9	ERX_ID	NUMERIC	No
	This item holds the medication ID.
10	RX_NUM	VARCHAR	No
	This holds the prescription number.
11	COMPOUND_LINK_NUM	VARCHAR	No
	This holds the Link Sequence Number used to associate ingredients of a compound drug.