CHG_REVIEW_NDC_AMT

Description:

This table contains Medical National Drug Code (NDC) administered amount 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 administered amount 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 of the charge in the charge session. Multiple charges can be associated with this charge session.
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_ADMIN_AMT	NUMERIC	No
	The line number of the charge in the charge session. Multiple charges can be associated with this charge session