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.