CHG_REVIEW_NDC_CD

Description: |
This table contains Medical National Drug Code (NDC) ID 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 codes, each row in this table represents one NDC ID 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 NDC associated with a specific group of data within this record.
4 | NDC_CODES_ID | VARCHAR | No |
Internal ID of Medical National Drug Code (NDC)
5 | NDC_CODES_ID_NDC_CODE | VARCHAR | No |
The external code for the National Drug Code (NDC). An NDC represents packages of medications.