PRE_AR_CHG_2

Description: |
This table is a continuation of the PRE_AR_CHG table. 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 will delete rows from this table. This table contains additional information about the procedure.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
TAR_ID | 1 |
CHARGE_LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TAR_ID | NUMERIC | No |
The unique identifier for the transaction record.
2 | CHARGE_LINE | INTEGER | No |
The line number for the information associated with this transaction record. This represents a single charge procedure in the transaction.
3 | PENDING_STATUS_C_NAME | VARCHAR | No |
The pending status of this transaction: 1 means Pending and 2 means Waiting to Pend. If blank, the transaction is not pending.
May contain organization-specific values: No
Category Entries:
Pending
Waiting to Pend
4 | TX_TYPE_C_NAME | VARCHAR | No |
What this transaction record is used for (e.g. charge, payment, adjustment, etc...).
May contain organization-specific values: No
Category Entries:
Charge
Payment/Adjustment
Single Adjustment
Visit
Express Payment
5 | PENDING_REASON_C_NAME | VARCHAR | No |
The pending reason category ID for the temporary transaction.
May contain organization-specific values: Yes
Category Entries:
Other
Error in Charge Entry Validation Check
Warning in Charge Entry Validation Check
Import: Transaction Imported to holding Tank
Inpatient: Charge needs to be reviewed
6 | PENDING_COMMENT | VARCHAR | No |
A free-text comment to further explain why this transaction is pending.
7 | LAST_EDITED_DATE | VARCHAR | No |
The last date the check payment was edited.
8 | HOSP_ACCOUNT_ID | VARCHAR | No |
This item stores the hospital account record ID for the transaction.
9 | EXT_BILLING_NUM | VARCHAR | No |
A billing number from an external billing system.
10 | EXT_REFERENCE_NUM | VARCHAR | No |
A reference number from an external billing system.
11 | ENC_TYPE_C_NAME | VARCHAR | No |
The kind of encounter which is associated with this transaction (e.g. Walk-In, Appointment, Anesthesia, etc...).
May contain organization-specific values: Yes
Category Entries:
Registration
Walk-In
Hospital Encounter
Canceled
Unmerge
Contact Moved
Intake
EMPTY
Research Encounter
Radiation Treatment
Recurring Plan
Billing Exchange
Health Plan
Update
PCP/Clinic Change
Wait List
Enrollment
Social Care Application
Service Decision Registration
Leader Rounds
Clerical Orders
Patient-Selected Community Resource
Mother Baby Link
Lactation Encounter
Appointment
Surgery
Anesthesia
Anesthesia Event
Guardian Screening
Ancillary Procedure
Anticoagulation Discharge Documentation
Health Maintenance Letter
Patient Message
E-Visit
Mobile Order Only
Questionnaire Series Submission
Travel
Patient Self-Triage
Organ Offer
Community Care Management
Patient Outreach
Telephone
Nurse Triage
E-Consult
E-Consult Community Order
Results Follow-Up
Clinical Documentation Only
Telemedicine
Plan of Care Documentation
External Communication
Reconciled Outside Data
External Contact
Ophth Exam
Dialysis Calendar Documentation
Pre-Admission Testing
Episode Documentation Update
Hospice Admission
Home Infusion
Home Infusion Billing
Episode Update
Home Health Resumption of Care Planning
Home Health Admission
Home Care Visit
Home Care Update
Kanta Service Event
Remote Monitoring Data Collection
Patient Web Update
Community Orders
Committee Review
Post Mortem Documentation
Billing Encounter
Lab Requisition
Office Visit
Consent Form
Procedure Pass
External Hospital Admission
Letter (Out)
Hospital
Refill
Immunization
History
Referral
Orders Only
Rx Refill Authorize
Meds Only (Web)
Meds Void (Web)
Resolute Professional Billing Hospital Prof Fee
Episode Changes
Ancillary Orders
Pharmacy Visit
OurPractice Advisory
Abstract
12 | PROV_SPECIALTY_C_NAME | VARCHAR | No |
The provider's area of expert knowledge which applies for this transaction.
May contain organization-specific values: Yes
13 | DEFAULT_SVC_DATE | DATETIME | No |
The service date when this transaction took place.
14 | DO_NOT_BILL_INS_YN | VARCHAR | No |
Do Not Bill Insurance for the charge session (taken from visit if encounter form # is used). Possible values will be "Y" and "N".
May contain organization-specific values: No
Category Entries:
No
Yes
15 | CHARGE_DESC_OVRIDE | VARCHAR | No |
Holds the charge description if it has been changed from the default.
16 | PROC_MED_NEC_YN | VARCHAR | No |
Indicates whether this particular charge line is a medical necessity or not. Possible values will be "Y" and "N".
May contain organization-specific values: No
Category Entries:
Yes
No
17 | COPAY_INDICATOR_C_NAME | VARCHAR | No |
The payment type for this copay.
May contain organization-specific values: No
Category Entries:
Co-ins
Copay
Not Covered
No Patient Payment
18 | TAX | NUMERIC | No |
The tax related to this charge.
19 | TAX_PROC_YN | VARCHAR | No |
Indicates whether the procedure line is a tax procedure
20 | DX_ID | VARCHAR | No |
The diagnoses which apply to this charge line. This will be in the form of comma-separated integers, where each integer corresponds with a line in the CHG_REVIEW_DX table for this transaction.
21 | MANUAL_PRICE_OVRIDE | INTEGER | No |
Indicates if this price override is a manual override or was due to a pricing contract.
22 | ADJ_AMT | NUMERIC | No |
Adjustment amount for one charge line.
23 | PRICE_OVRIDE_FLAG | NUMERIC | No |
Holds the price override for this line, if one has been set.
24 | PANEL_PROC_ID | VARCHAR | No |
The procedure number for this charge line. Corresponds to the Procedure Master # (EAP-100).
25 | HEMATOCRIT_READING | NUMERIC | No |
The hematocrit reading for this procedure, if one has been taken.
26 | HEMOGLOBIN_READING | NUMERIC | No |
The hemoglobin reading for this procedure, if one has been taken.
27 | CHG_NOT_BILL_INS_YN | VARCHAR | No |
Do Not Bill Insurance for charge line. Possible values will be "Y" and "N".
The category values for this column were already listed for column: DO_NOT_BILL_INS_YN
28 | CHARGE_LENGTH | INTEGER | No |
The length of time in minutes that this procedure took.
29 | START_TIME | DATETIME (Local) | No |
The time when this procedure was started.
30 | STOP_TIME | DATETIME | No |
The time when this procedure was finished.
31 | START_DATE | DATETIME | No |
The date when this procedure was started.
32 | STOP_DATE | DATETIME | No |
The date when this procedure was finished.
33 | SERVICE_TIME | DATETIME (Local) | No |
The time of service for a charge line.
34 | SELF_PAY_AMOUNT | NUMERIC | No |
The self-pay amount associated with this charge line as determined by the Benefits Engine.
35 | CLAIM_ID | NUMERIC | No |
The unique ID of the claim information record associated with this charge line.
36 | CHG_CVG_STAT_C_NAME | VARCHAR | No |
The coverage status category ID for the temporary transaction. This is determined by the Benefits Engine.
May contain organization-specific values: No
Category Entries:
Covered, write-off
Not covered
Covered, no write-off
Not covered but assigned to payer
37 | OLD_ETR_ID | VARCHAR | No |
The unique Accounts Receivable (AR) transaction ID which is associated with this charge record. This column is frequently used to link to the ARPB_TRANSACTIONS table.
38 | ANESTHESIA_TYPE_C_NAME | VARCHAR | No |
Anesthesia procedure type.
May contain organization-specific values: Yes
Category Entries:
General
IV
Local
Monitored Anesthesia Care
Regional
39 | EMERG_STATUS_YN | VARCHAR | No |
Indicates where this charge is associated with an admitted patient with an emergency status.
May contain organization-specific values: No
Category Entries:
Yes
No
40 | PHYSICAL_STATUS_C_NAME | VARCHAR | No |
Physical status of the patient who had the anesthesia procedure.
May contain organization-specific values: Yes
Category Entries:
Normal Healthy
Mild Systemic Disease
Severe Systemic Disease
Severe/Threat
Moribund
Brain Dead
41 | ANES_BASE_UNITS | NUMERIC | No |
Anesthesia base units for the charge procedure.
42 | EMERG_UNITS | NUMERIC | No |
Emergency units for the charge procedure.
43 | PHYSICAL_STAT_UNITS | NUMERIC | No |
Physical status units for the charge procedure.
44 | AGE_UNITS | NUMERIC | No |
Age units for the anesthesia procedure.
45 | ANES_AGE_PROC_ID_PROC_NAME | VARCHAR | No |
The name of each procedure.
46 | ANES_EMERG_PROC_ID_PROC_NAME | VARCHAR | No |
The name of each procedure.
47 | CHARGE_BILL_STS_C_NAME | VARCHAR | No |
The anesthesia billing status category ID for the temporary transaction.
May contain organization-specific values: No
Category Entries:
Yes
No
Supplemental
Supplemental Unit
48 | ANES_SUPP_UNITS | VARCHAR | No |
Anesthesia supplemental units.
49 | ANES_AGE_PROC_UNIT | NUMERIC | No |
Anesthesia age unit procedure unit.
50 | ANES_EMERG_PROC_UNT | NUMERIC | No |
Anesthesia emergency unit procedure unit.
51 | ORIG_ANES_TX_SS | VARCHAR | No |
Original anesthesia transaction for special supplemental.
52 | RAD_THER_END | INTEGER | No |
Indicates end of radiation treatment.
53 | RAD_THER_LINK | VARCHAR | No |
Radiation therapy link for transfer/retro.
54 | CHANGED_DX_PX_YN | VARCHAR | No |
Indicates if charge review changed the diagnosis or procedure.
The category values for this column were already listed for column: DO_NOT_BILL_INS_YN
55 | ORIG_PAT_AMT | NUMERIC | No |
Original self-pay amount before discount.
56 | SST_DISCNT_OVRD_YN | VARCHAR | No |
Flag to indicate that the self-pay discount amount was manually overridden by the user.
The category values for this column were already listed for column: DO_NOT_BILL_INS_YN
57 | SST_SP_AMT_OVRD_YN | VARCHAR | No |
Flag to indicate that the self-pay amount was overridden in the self-pay discount workflow.
The category values for this column were already listed for column: DO_NOT_BILL_INS_YN
58 | SST_DISCNT_AMT | NUMERIC | No |
The self-pay discount amount.
59 | POS_TYPE_OVRRID_C_NAME | VARCHAR | No |
Place of service type override for a single charge line
May contain organization-specific values: Yes
Category Entries:
Telehealth - Provided in Patient's Home
Office
Home
Assisted Living Facility
Group Home
Mobile Unit
Temporary Lodging
Walk-in Retail Health Clinic
Place of Employment - Worksite
Off Campus - Outpatient Hospital
Urgent Care Facility
Inpatient Hospital
On Campus - Outpatient Hospital
Emergency Room - Hospital
Ambulatory Surgical Center
Birthing Center
Military Treatment Facility
Outreach Site/Street
Skilled Nursing Facility
Nursing Facility
Custodial Care Facility
Hospice
Adult Living Care Facility
Ambulance - Land
Ambulance - Air or Water
Independent Clinic
Federally Qualified Health Center
Inpatient Psychiatric Facility
Psychiatric Facility - Partial Hospitalization
Community Mental Health Center
Intermediate Care Facility/ Individuals with Intellectual Disabilities
Residential Substance Abuse Treatment Facility
Psychiatric Residential Treatment Center
Non-residential Substance Abuse Treatment Facility
Non-residential Opioid Treatment Facility
Mass Immunization Center
Comprehensive Inpatient Rehabilitation Facility
Comprehensive Outpatient Rehabilitation Facility
End-Stage Renal Disease Treatment Facility
Programs of All-Inclusive Care for the Elderly (PACE) Center
Public Health Clinic
Rural Health Clinic
Independent Laboratory
Other Place of Service
Pharmacy
Telehealth - Provided Other than in Patient's Home
School
Homeless Shelter
Indian Health Service Free-standing Facility
Indian Health Service Provider-based Facility
Tribal 638 Free-standing Facility
Tribal 638 Provider-based Facility
Prison/Correctional Facility
60 | BFD_COVERAGE_ID | NUMERIC | No |
This item stores the coverage used to compute reimbursement and pricing contract for charge lines that qualify for bill for denial workflows.
61 | MEDICATION_ID_MEDICATION_NAME | VARCHAR | No |
The name of this medication record.
62 | WRITE_OFF_EXCEPTION_C_NAME | VARCHAR | No |
The write-off exception for this charge.
May contain organization-specific values: No
Category Entries:
Yes
Yes, No NCC either
63 | INSURANCE_ONLY_FLAG_C_NAME | VARCHAR | No |
A flag to indicate if insurance only billing applies to this charge.
May contain organization-specific values: No
Category Entries:
Yes
yes and new SST
64 | AUTO_PAT_WRITEOFF_C_NAME | VARCHAR | No |
This item is set when the user flags the charge line for an automatic patient writeoff, and it is unset if the user unflags the charge line. This allows the system to distinguish when the user was the source of the insurance only flag value, rather than the system having set it automatically.
The category values for this column were already listed for column: INSURANCE_ONLY_FLAG_C_NAME
65 | DENTAL_PREAUTH_AMT | NUMERIC | No |
Stores the amount that will be sent to insurance for preauthorization for the associated charge line.