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.