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 Recurring Plan Billing Exchange 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 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.