CHG_REVIEW_NDC_UNT

Description: |
This table contains Medical National Drug Code (NDC) administered unit for a temporary accounts receivable (TAR) record that is or has been in a Charge Review workqueue. Because one procedure in a TAR record can be associated with multiple NDC administered units, each row in this table represents one NDC administered unit and is identified by the transaction ID (TAR_ID), procedure line number (GROUP_LINE), and line number (VALUE_LINE). The data for this table is extracted using a KB_SQL query. Note: TAR records in Chronicles are purged periodically depending on your system setting. Be aware that old data in this table might be lost if you truncate the table.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
TAR_ID | 1 |
GROUP_LINE | 2 |
VALUE_LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TAR_ID | NUMERIC | No |
The unique identifier for the subject record.
2 | GROUP_LINE | INTEGER | No |
The line number for the information associated with this record.
3 | VALUE_LINE | INTEGER | No |
The line number of one of the multiple values associated with a specific group of data within this record.
4 | NDC_CODES_UNIT_C_NAME | VARCHAR | No |
Medical National Drug Code (NDC) Unit.
May contain organization-specific values: No
Category Entries:
Milliliters
Milligrams
Grams
International Units
Units