HSP_TX_NDC_CODES

Description: |
Table for National Drug Code (NDC) codes and related information.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TX_ID | NUMERIC | No |
This column stores the unique identifier for the hospital billing transaction.
2 | LINE | INTEGER | No |
The Line Count
3 | NDC_CODE_RG_ID | VARCHAR | No |
Holds medication national drug codes associated with the charge.
4 | NDC_CODE_RG_ID_NDC_CODE | VARCHAR | No |
The external code for the National Drug Code (NDC). An NDC represents packages of medications.
5 | NDC_CODE_ADMIN_AMT | NUMERIC | No |
Administered amount for associated national drug code.
6 | NDC_CODE_UNIT_C_NAME | VARCHAR | No |
This column stores the unit associated with National Drug Code administered amount for the hospital billing transaction.
May contain organization-specific values: No
Category Entries:
Milliliters
Milligrams
Grams
International Units
Units