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.