PRE_AR_CHG
Description:
This table contains one row for each line of each temporary accounts receivable (TAR) record (think of a TAR record as one charge entry screen and each line as an individual procedure). Deleting charge lines from Chronicles will delete rows from this table. This table contains basic information about the procedure and its charge review history. This table also contains the current status of the TAR record. This is found in the CHARGE_STATUS_C column.

Primary Key
Column Name Ordinal Position
TAR_ID 1
CHARGE_LINE 2

Column Information
Name Type Discontinued?
1 TAR_ID NUMERIC No
The unique ID of the temporary transaction record.
2 CHARGE_LINE INTEGER No
The line number for the charge on this temporary transaction record.
3 SERVICE_DATE DATETIME No
The service date on which the charge procedure is performed.
4 SERV_AREA_ID_LOC_NAME VARCHAR No
The name of the revenue location.
5 LOC_ID_LOC_NAME VARCHAR No
The name of the revenue location.
6 PROC_DEPT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
7 PROC_POS_ID_LOC_NAME VARCHAR No
The name of the revenue location.
8 COVERAGE_ID NUMERIC No
The unique ID of the coverage on the charge. This column is frequently used to link to the V_COVERAGE_PAYOR_PLAN table.
9 ACCOUNT_ID NUMERIC No
The unique ID of the guarantor account on the charge. This column is frequently used to link to the ACCOUNT table.
10 PERF_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
11 BILL_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
12 PROC_ID_PROC_NAME VARCHAR No
The name of each procedure.
13 QTY NUMERIC No
The quantity on the charge.
14 AMOUNT NUMERIC No
The dollar amount on the charge.
15 ENTER_USER_ID VARCHAR No
The unique ID of the user who entered the charge. This column is frequently used to link to the CLARITY_EMP table.
16 ENTER_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
17 FILE_DATE DATETIME No
The date the temporary charge was posted into a transaction. If this field is blank the charge has not been posted into a transaction. It is either still in the workqueue (both the file date and delete date are blank) or has been deleted (the delete date field is populated). This date will match the post date in CLARITY_TDL.
18 FILE_USER_ID VARCHAR No
The unique ID of the user who corrected the error of the charges. This column is frequently used to link to the CLARITY_EMP table.
19 FILE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
20 TX_ID NUMERIC No
The unique ID of the transaction the charge is stored within a temporary transaction.
21 DELETE_DATE DATETIME No
The date the charge was deleted. If this field is blank the charge has not been deleted. It is either still in the WQ (both the file date and delete date are blank) or has been filed into ETR (the file date field is populated).
22 DELETE_USER_ID VARCHAR No
The unique ID of the user who deleted the charge. This column is frequently used to link to the CLARITY_EMP table.
23 DELETE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
24 REFERRING_PROV_ID VARCHAR No
The unique ID of the referral provider related to the charge. This column is frequently used to link to the CLARITY_SER table.
25 REFERRING_PROV_ID_REFERRING_PROV_NAM VARCHAR No
The name of the referral source.
26 RECEIVE_DATE DATETIME No
The receive date for a charge. This date is entered by users in charge entry.
27 CODER_USER_ID VARCHAR No
The unique ID of the coder on the charge. This column is frequently used to link to the CLARITY_EMP table. This data is entered by users in charge entry.
28 CODER_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
29 CODED_DATE DATETIME No
The date on which the charge was coded. This date is entered by users in charge entry.
30 BILL_AREA_ID NUMERIC No
The unique ID of the bill area is associated with the charge. This column is frequently used to link to the BILL_AREA table.
31 BILL_AREA_ID_BILL_AREA_NAME VARCHAR No
The record name of this bill area, financial subdivision, or financial division.
32 SESS_BILL_AREA_ID NUMERIC No
The unique ID of the bill area is associated with the charge session (TAR). This column is frequently used to link to the BILL_AREA table.
33 SESS_BILL_AREA_ID_BILL_AREA_NAME VARCHAR No
The record name of this bill area, financial subdivision, or financial division.
34 LOG_ID VARCHAR No
The unique ID associated with the surgical log record for this row. This column is frequently used to link to the OR_LOG table. This item is populated if charge is entered from OpTime (Epic's operating room management application).
35 SUPPLY_ID VARCHAR No
The unique ID associated with the supply record for this row. This column is frequently used to link to the OR_SPLY table.
36 SUPPLY_ID_SUPPLY_NAME VARCHAR No
The name of the inventory item.
37 IMPLANT_ID VARCHAR No
The unique ID associated with the implant record for this row. This column is frequently used to link to the OR_IMP table.
38 SESS_DEPT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
39 SESS_POS_ID_LOC_NAME VARCHAR No
The name of the revenue location.
40 CHARGE_SOURCE_C_NAME VARCHAR No
The source category number of the charge. This column will only be populated if the charge is not posted through the normal professional billing charge entry workflow. Charge source could be 1-Transaction Import, 2-Interface, 3-EpicCare, 4-Inpatient Charge Utility, 5-Hospital Professional Fee, 6-Inpatient Professional Charge.
May contain organization-specific values: No
Category Entries:
Transaction Import
Interface
EpicCare
Inpatient Charge Utility
Hospital Professional Fee
Inpatient Professional Charge
Payment Plan Auto-Pay
41 CHARGE_STATUS_C_NAME VARCHAR No
The status category number of the charge. 1-Filed without Review, 2-Filed after Review, 3-In Review, 4-Deleted, 5-Created, 6-Deleted in Charge Review.
May contain organization-specific values: No
Category Entries:
Filed without Review
Filed after Review
In Review
Deleted
Created
Deleted in Charge Review
42 SESS_PERF_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
43 SESS_BILL_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
44 DENTAL_ENTRY_FLG VARCHAR No
Indicates if the procedure is a dental procedure.
45 DENTAL_TOOTH_NUM_C_NAME VARCHAR No
The tooth number for the dental procedure.
May contain organization-specific values: No
Category Entries:
Tooth 1
Tooth 2
Tooth 3
Tooth 4
Tooth 5
Tooth 6
Tooth 7
Tooth 8
Tooth 9
Tooth 10
Tooth 11
Tooth 12
Tooth 13
Tooth 14
Tooth 15
Tooth 16
Tooth 17
Tooth 18
Tooth 19
Tooth 20
Tooth 21
Tooth 22
Tooth 23
Tooth 24
Tooth 25
Tooth 26
Tooth 27
Tooth 28
Tooth 29
Tooth 30
Tooth 31
Tooth 32
Tooth A
Tooth B
Tooth C
Tooth D
Tooth E
Tooth F
Tooth G
Tooth H
Tooth I
Tooth J
Tooth K
Tooth L
Tooth M
Tooth N
Tooth O
Tooth P
Tooth Q
Tooth R
Tooth S
Tooth T
Tooth 18 (FDI)
Tooth 17 (FDI)
Tooth 16 (FDI)
Tooth 15 (FDI)
Tooth 14 (FDI)
Tooth 13 (FDI)
Tooth 12 (FDI)
Tooth 11 (FDI)
Tooth 21 (FDI)
Tooth 22 (FDI)
Tooth 23 (FDI)
Tooth 24 (FDI)
Tooth 25 (FDI)
Tooth 26 (FDI)
Tooth 27 (FDI)
Tooth 28 (FDI)
Tooth 38 (FDI)
Tooth 37 (FDI)
Tooth 36 (FDI)
Tooth 35 (FDI)
Tooth 34 (FDI)
Tooth 33 (FDI)
Tooth 32 (FDI)
Tooth 31 (FDI)
Tooth 41 (FDI)
Tooth 42 (FDI)
Tooth 43 (FDI)
Tooth 44 (FDI)
Tooth 45 (FDI)
Tooth 46 (FDI)
Tooth 47 (FDI)
Tooth 48 (FDI)
Tooth 55 (FDI)
Tooth 54 (FDI)
Tooth 53 (FDI)
Tooth 52 (FDI)
Tooth 51 (FDI)
Tooth 61 (FDI)
Tooth 62 (FDI)
Tooth 63 (FDI)
Tooth 64 (FDI)
Tooth 65 (FDI)
Tooth 75 (FDI)
Tooth 74 (FDI)
Tooth 73 (FDI)
Tooth 72 (FDI)
Tooth 71 (FDI)
Tooth 81 (FDI)
Tooth 82 (FDI)
Tooth 83 (FDI)
Tooth 84 (FDI)
Tooth 85 (FDI)
Tooth UR8 (Palmer)
Tooth UR7 (Palmer)
Tooth UR6 (Palmer)
Tooth UR5 (Palmer)
Tooth UR4 (Palmer)
Tooth UR3 (Palmer)
Tooth UR2 (Palmer)
Tooth UR1 (Palmer)
Tooth UL1 (Palmer)
Tooth UL2 (Palmer)
Tooth UL3 (Palmer)
Tooth UL4 (Palmer)
Tooth UL5 (Palmer)
Tooth UL6 (Palmer)
Tooth UL7 (Palmer)
Tooth UL8 (Palmer)
Tooth LL8 (Palmer)
Tooth LL7 (Palmer)
Tooth LL6 (Palmer)
Tooth LL5 (Palmer)
Tooth LL4 (Palmer)
Tooth LL3 (Palmer)
Tooth LL2 (Palmer)
Tooth LL1 (Palmer)
Tooth LR1 (Palmer)
Tooth LR2 (Palmer)
Tooth LR3 (Palmer)
Tooth LR4 (Palmer)
Tooth LR5 (Palmer)
Tooth LR6 (Palmer)
Tooth LR7 (Palmer)
Tooth LR8 (Palmer)
Tooth URE (Palmer)
Tooth URD (Palmer)
Tooth URC (Palmer)
Tooth URB (Palmer)
Tooth URA (Palmer)
Tooth ULA (Palmer)
Tooth ULB (Palmer)
Tooth ULC (Palmer)
Tooth ULD (Palmer)
Tooth ULE (Palmer)
Tooth LLE (Palmer)
Tooth LLD (Palmer)
Tooth LLC (Palmer)
Tooth LLB (Palmer)
Tooth LLA (Palmer)
Tooth LRA (Palmer)
Tooth LRB (Palmer)
Tooth LRC (Palmer)
Tooth LRD (Palmer)
Tooth LRE (Palmer)
46 DENTAL_SURFACE VARCHAR No
The tooth surface for the dental procedure. The value could be a semicolon-delimited string if there are multiple surfaces. For example, 2;3.
47 DENTAL_ARCH_C_NAME VARCHAR No
The arch info for the dental procedure.
May contain organization-specific values: No
Category Entries:
Lower
Upper
48 DENTAL_QUADRANT_C_NAME VARCHAR No
The quadrant info for the dental procedure.
May contain organization-specific values: No
Category Entries:
Lower Left
Lower Right
Upper Left
Upper Right
Whole Oral Cavity
Maxillary Area
Mandibular Area
Upper Right Sextant
Upper Anterior Sextant
Upper Left Sextant
Lower Left Sextant
Lower Anterior Sextant
Lower Right Sextant
49 DENTAL_AREA VARCHAR No
The area info for dental procedure. The value is a dash-delimited string of two tooth numbers. It indicates the area between the two teeth. For example, 2-3.
50 DENTAL_SUPNUMARY_YN VARCHAR No
Indicates whether this dental procedure is for a supernumerary.
May contain organization-specific values: No
Category Entries:
Yes
No
51 DENTAL_MO_TO_RECALL INTEGER No
The number of months after which follow-up is needed for the dental procedure.
52 DENTAL_HYGIENIST_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
53 ANES_SUPPLEMENTAL VARCHAR No
Indicate if the procedure is anesthesia or supplemental procedure. 1 means the procedure is an anesthesia procedure. 2 means the procedure is a supplemental procedure.
54 TIMED VARCHAR No
Indicate if the procedure uses timed algorithm.
55 ADJUD_SELF_PAY_AMT NUMERIC No
The adjudicated self-pay amount.
56 ADJUD_COPAY_AMT NUMERIC No
The adjudicated copay portion of the self-pay amount.
57 ADJUD_COINS_AMT NUMERIC No
The adjudicated coinsurance portion of the self-pay amount.
58 ADJUD_DEDUCT_AMT NUMERIC No
The adjudicated deductible portion of the self-pay amount.
59 ADJUD_OVRIDE_FLAG_C_NAME VARCHAR No
A flag to indicate if and how the adjudicated self-pay amount was overridden.
May contain organization-specific values: No
Category Entries:
Benefit Package Adjudication Formula
Coverage Level Override
Plan Level Override
Copay Suppressed
Payor Level Override Programming Point
Service Area Level Override Programming Point
Waived - Secondary Coverage Available
Copay Computation Function Programming Point
60 OLD_RETRO_ETR_ID NUMERIC No
Unique ID of old retroadjudication transactions.
61 PRICE_PER_UNIT NUMERIC No
The price for each unit for a procedure.
62 NIA_NIDUS_OUTCOME_C_NAME VARCHAR No
The National Imaging Association
May contain organization-specific values: Yes
Category Entries:
Positive
Negative
Equivocal
Significant Incidental
63 SPEC_SUP_PROC_TYP_C_NAME VARCHAR No
The special supplemental procedure type category ID for the temporary transaction.
May contain organization-specific values: No
Category Entries:
Age Unit
Emergency Unit
64 ANES_PROCEDURE_LINK INTEGER No
The line in the charge session that created this charge line. This happens for anesthesia supplemental procedures, charge shadowing, and charge quantity splitting.
65 ANES_ASA_CODE_ID_PROC_NAME VARCHAR No
The name of each procedure.
66 ORDER_ID NUMERIC No
The order that is linked to this charge.
67 RESEARCH_STUDY_ID_RESEARCH_STUDY_NAME VARCHAR No
The name of the research study record.
68 PROTOCOL_CSN NUMERIC No
Contact serial number of the charge's linked protocol version within linked research study or linked treatment plan.
69 RSH_CHG_ROUTE_C_NAME VARCHAR No
Category value to indicate how a charge related to a research study was routed, either to the research study guarantor account or to the patient's account.
May contain organization-specific values: No
Category Entries:
File to Study
File to Patient
70 FIN_DIV_ID NUMERIC No
The financial division associated with the charge.
71 FIN_DIV_ID_BILL_AREA_NAME VARCHAR No
The record name of this bill area, financial subdivision, or financial division.
72 FIN_SUBDIV_ID NUMERIC No
The financial subdivision associated with the charge.
73 FIN_SUBDIV_ID_BILL_AREA_NAME VARCHAR No
The record name of this bill area, financial subdivision, or financial division.
74 CREATE_DATE DATETIME No
The date the charge was created.
75 TREATMENT_PLAN_CSN NUMERIC No
The contact serial number of the treatment plan that generated this charge and order.
76 RESEARCH_ENROLL_ID NUMERIC No
The unique ID of the research study association linked to this charge.
77 DENTAL_PREAUTH_QTY INTEGER No
Stores the quantity that will be sent to insurance for preauthorization for the associated charge line
78 PROC_INSTRUCTIONS VARCHAR No
Free text regarding the specific procedure.
79 FAST_PAY_SP_BALANCE NUMERIC No
Self-pay balance for use with fast payment.
80 REF_OVERRIDE_USER_ID VARCHAR No
This item stores the user who overrode the referral associated with this charge line.
81 REF_OVERRIDE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
82 REFERRAL_ID NUMERIC No
This items stores the referral ID for a charge line.
83 CHARGE_COMMENT VARCHAR No
This item stores a charge comment.