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.