PRE_AR_CHG_3

Description:

This table is a continuation of the PRE_AR_CHG table. This table contains one row for each line of each TAR record (think of a TAR record as one charge entry screen and each line as an individual procedure). Deleting charge lines will delete rows from this table. This table contains additional information about the procedure. *Note: TAR records in Chronicles are purged periodically depending on your system setting. Be aware that old data in this table may be lost if you truncate the table.

Primary Key

Column Name	Ordinal Position
TAR_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	TAR_ID	NUMERIC	No
	The unique identifier (.1 item) for the charge session record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	ADV_PRICING_DESCRIPTION	VARCHAR	No
	Description of the advanced pricing line in ECP used for this charge.
4	ADV_PRICING_INDEX_ID	VARCHAR	No
	Component or component group used in advanced pricing.
5	ADV_PRICING_INDEX_ID_COMPONENT_INDEX_NAME	VARCHAR	No
	The name of the component index record
6	ADV_PRICING_RULE_ID	VARCHAR	No
	Rule used for advanced pricing.
7	ADV_PRICING_RULE_ID_RULE_NAME	VARCHAR	No
	The name of the rule.
8	ADV_PRICING_MECHANISM_C_NAME	VARCHAR	No
	Advanced pricing mechanism used. May contain organization-specific values: No Category Entries: Percent of Fee Schedule Minimum of Options Maximum of Options Extension Percent of Base Price
9	ADV_PRICING_FSC1_ID	NUMERIC	No
	Fee schedule 1 used in advanced pricing.
10	ADV_PRICING_FSC1_ID_FEE_SCHEDULE_NAME	VARCHAR	No
	The name of each fee schedule.
11	ADV_PRICING_FSC2_ID	NUMERIC	No
	Fee schedule 2 used in advanced pricing.
12	ADV_PRICING_FSC2_ID_FEE_SCHEDULE_NAME	VARCHAR	No
	The name of each fee schedule.
13	ADV_PRICING_FSC_PERC_1	NUMERIC	No
	Percent of specified fee schedule 1 used in advanced pricing.
14	ADV_PRICING_FSC_PERC_2	NUMERIC	No
	Percent of specified fee schedule 2 used in advanced pricing.
15	ADV_PRICING_PERC_BASE	INTEGER	No
	Percent of base price used in advanced pricing.
16	ADV_PRICING_LPP_ID	NUMERIC	No
	Pricing extension used in advanced pricing.
17	ADV_PRICING_LPP_ID_LPP_NAME	VARCHAR	No
	The name of the extension.
18	FIN_ASST_TRACKER_ID	NUMERIC	No
	The unique identifier of the financial assistance tracker that discounted this transaction.