AP_CLAIM_PX_NDC

Description:

The AP_CLAIM_PX_NDC table stores items related to National Drug Code (NDC) data for AP Claim service lines. Multiple NDCs can be associated to a single claim service line. To link this table’s service line information back to a claim header, join this table to AP_CLAIM_PROC_IDS on the TX_ID column. If you need to report on claim service lines specific to Cost Sharing Reduction (CSR), join this table instead to AP_CLAIM_PROC_IDS_CSR on the TX_ID column.

Primary Key

Column Name	Ordinal Position
TX_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	TX_ID	NUMERIC	No
	The unique ID of the AP Claim procedure transaction.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	NDC_CODE_ID	VARCHAR	No
	The unique identifier of the National Drug Code (NDC) for the service on an AP claim. It should be used to join to NDC tables, such as RX_NDC, to find details about the code or translate to a readable format.
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_QUANTITY	NUMERIC	No
	The quantity or amount of the National Drug Code (NDC) dispensed for the service on an AP claim.
6	NDC_UNIT_C_NAME	VARCHAR	No
	The unit category ID for the quantity of a National Drug Code (NDC) dispensed for a service on an AP claim. The stored values can be translated using ZC_NDC_UNITS. May contain organization-specific values: No Category Entries: Milliliters Milligrams Grams International Units Units
7	NDC_PRESCRIPTIONNUM	VARCHAR	No
	The prescription number associated with the National Drug Code (NDC) dispensed for a service on an AP claim.
8	NDC_LINK_SEQ_NUM	VARCHAR	No
	The link sequence number associated with the National Drug Code (NDC) dispensed for a service on an AP claim.