PRE_AR_SESSION

Description:

This table stores single response items for charges. Note: temporary accounts receivable (TAR) records in Chronicles are purged periodically depending on your system setting. Be aware that old data in this table might be lost if you truncate the table.

Primary Key

Column Name	Ordinal Position
TAR_ID	1

Column Information

	Name	Type	Discontinued?
1	TAR_ID	NUMERIC	No
	The unique identifier for the temporary transaction.
2	TX_SOURCE_C_NAME	VARCHAR	No
	The source of the charge session. 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
3	LK_IN_PCONC_VAL	VARCHAR	No
	Concurrency Value locked in anesthesia charge summary.
4	LK_IN_PCONC_USR_ID	VARCHAR	No
	The ID of the user who locked-in preconcurrency in anesthesia charge summary.
5	LK_IN_PCONC_USR_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
6	LK_IN_PCONC_IN_DTTM	DATETIME (Local)	No
	The timestamp when preconcurrency was locked in anesthesia charge summary.
7	TREATMENT_PLAN_ID	VARCHAR	No
	The treatment plan on the charge session.
8	ANES_TYPE_C_NAME	VARCHAR	No
	The type category for the temporary anesthesia transaction. May contain organization-specific values: Yes Category Entries: General IV Local Monitored Anesthesia Care Regional
9	EMERG_STAT_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
10	PHYSICAL_STAT_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
11	SUP_MOD_OVRIDE_YN	VARCHAR	No
	Override the normal modifier with the modifier corresponding to a medically supervised case. The category values for this column were already listed for column: EMERG_STAT_YN
12	ORIGINAL_CRNA_TX	NUMERIC	No
	Original CRNA transaction ID.
13	POS_TYPE_C_NAME	VARCHAR	No
	The place of service type category ID for the temporary transaction. 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
14	ACCOUNT_ID	NUMERIC	No
	The unique ID of the guarantor account on the charge session.
15	PAT_ID	VARCHAR	No
	The unique ID of the patient on the charge session.
16	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.
17	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.
18	REFERRING_PROV_ID	VARCHAR	No
	The unique ID of the referral provider on the charge session.
19	REFERRING_PROV_ID_REFERRING_PROV_NAM	VARCHAR	No
	The name of the referral source.
20	DEPT_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
21	POS_ID_LOC_NAME	VARCHAR	No
	The name of the revenue location.
22	SERV_AREA_ID_LOC_NAME	VARCHAR	No
	The name of the revenue location.
23	LOC_ID	VARCHAR	No
	The unique ID of the location on the charge session.
24	TX_TYPE_C_NAME	VARCHAR	No
	Tells 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
25	PAT_ENC_CSN_ID	NUMERIC	No
	This column contains the patient encounter serial number for the charge session.
26	RQG_ID	NUMERIC	No
	This column contains the reference lab requisition grouper ID.
27	ANES_SUP_UNIT_PROC_TOT_UNIT	NUMERIC	No
	The total number of units of supplemental unit procedures for this charge session.
28	CHARGE_SLIP_NUMBER	VARCHAR	No
	This is the number used to associate PB charge sessions with encounters.
29	DENTAL_CHARGE_TYPE_C_NAME	VARCHAR	No
	Indicates what type of dental charge it is. May contain organization-specific values: No Category Entries: Visit Charge Periodic Charge Initial Charge Predetermination Charge Banding Charge
30	OVERRIDE_PAYER_ID_PAYOR_NAME	VARCHAR	No
	The name of the payor.
31	OVERRIDE_PLAN_ID_BENEFIT_PLAN_NAME	VARCHAR	No
	The name of the benefit plan record.
32	ORIGINAL_HTR_ID	NUMERIC	No
	The original hospital billing transaction ID.
33	CODED_DATE	DATETIME	No
	Coded date for charge session.
34	SPECIMEN_ID	VARCHAR	No
	The lab specimen ID associated with the temporary charge session.
35	TEST_ID_TEST_NAME	VARCHAR	No
	The name of the test record.
36	REFERRAL_ID	NUMERIC	No
	The referral number for the referral associated to this charge.
37	REQUISITION_ID	NUMERIC	No
	Reference Lab Requisition ID associated with the temporary charge session.