TX_NDC_INFORMATION

Description: |
This table contains Medical National Drug Code (NDC) information. Since one transaction may be associated with multiple NDC codes, each row in this table represents one NDC code and is identified by the transaction ID and line number. The data for this table is extracted using a KB_SQL query.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
TX_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TX_ID | NUMERIC | No |
The unique accounts receivable transaction record ID.
2 | LINE | INTEGER | No |
Line number to identify each row of Medical National Drug Code (NDC) data associated with an individual transaction.
3 | NDC_CODES_ID | VARCHAR | No |
The ID of the Medical National Drug Code (NDC) associated with a transaction.
4 | NDC_CODES_ID_NDC_CODE | VARCHAR | No |
The external code for the National Drug Code (NDC). An NDC represents packages of medications.
5 | NDC_CODES_ADMIN_AMT | NUMERIC | No |
The NDC amount associated with this charge.
6 | NDC_CODES_UNIT_C_NAME | VARCHAR | No |
The Medical National Drug Code (NDC) unit associated with the charge.
May contain organization-specific values: No
Category Entries:
Milliliters
Milligrams
Grams
International Units
Units