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.
19 | SPLIT_RELATED_HAR_TYPE_C_NAME | VARCHAR | No |
Identifies the system calculated related HAR type (I HAR 146) of the HAR that this charge will be split to.
May contain organization-specific values: Yes
Category Entries:
Elective Services
ED/Inpatient Split Billing
Leave of Absence / Bed Hold
Interrupted Stay
Separate Service Area Billing
Home Infusion Medical Benefits
Received Self-Pay
Shadow Billing
Home Infusion Bypass
PAS LPR Hospital at Home Visit
Other
20 | DELEGATE_BILL_SOURCE_TX_ID | NUMERIC | No |
The source Tapestry ETR that the charge is linked to.
21 | SPLIT_RELATED_HAR_RULE_ID | VARCHAR | No |
Indicates the rule in the PB Profile that qualified the charge for the related visit account type stored in item 16801.
22 | SPLIT_RELATED_HAR_RULE_ID_RULE_NAME | VARCHAR | No |
The name of the rule.
23 | OVRD_SPLIT_RELATED_HAR_TYPE_C_NAME | VARCHAR | No |
Identifies the manually overridden related HAR type (I HAR 146) of the HAR that this charge will be split to.
The category values for this column were already listed for column: SPLIT_RELATED_HAR_TYPE_C_NAME
24 | DELEGATE_BILL_SOURCE_CLAIM_ID | NUMERIC | No |
The source Tapestry CLM that the charge is linked to.