form_encounter


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of form_encounter.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Represents the information related to a patient’s visit to a healthcare provider. This is different than an appointment as this table tracks the actual service of care

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
uuid BINARY 16 √ null
date DATETIME 19 √ null
reason LONGTEXT 2147483647 √ null
facility LONGTEXT 2147483647 √ null
facility_id INT 10 0
pid BIGINT 19 √ null
patient_data.pid Defined in XML R

The internal patient identifier
encounter BIGINT 19 √ null
ar_activity.encounter Defined in XML R
billing.encounter Defined in XML R
claims.encounter_id Defined in XML R
documents.encounter_id Defined in XML R
drug_sales.encounter Defined in XML R
external_procedures.ep_encounter Defined in XML R
onsite_documents.encounter Defined in XML R
onsite_signatures.encounter Defined in XML R
issue_encounter.encounter Defined in XML R
patient_tracker.encounter Defined in XML R
procedure_order.encounter_id Defined in XML R
questionnaire_response.encounter Defined in XML R
shared_attributes.encounter Defined in XML R
voids.encounter_id Defined in XML R
onset_date DATETIME 19 √ null
sensitivity VARCHAR 30 √ null
billing_note TEXT 65535 √ null
pc_catid INT 10 5

event category from openemr_postcalendar_categories
last_level_billed INT 10 0

The party for whom payment was last billed. -1=Nobody, 0=Patient, 1=Ins1, 2=Ins2, 3=Ins3
last_level_closed INT 10 0

The party for whom payment was last received. -1=Nobody, 0=Patient, 1=Ins1, 2=Ins2, 3=Ins3
last_stmt_date DATE 10 √ null
stmt_count INT 10 0
provider_id INT 10 √ 0

default and main provider for this visit
supervisor_id INT 10 √ 0

supervising provider, if any, for this visit
invoice_refno VARCHAR 31
referral_source VARCHAR 31
billing_facility INT 10 0
external_id VARCHAR 20 √ null
pos_code TINYINT 3 √ null
parent_encounter_id BIGINT 19 √ null
class_code VARCHAR 10 AMB
shift VARCHAR 31
voucher_number VARCHAR 255

also called referral number
discharge_disposition VARCHAR 100 √ null
encounter_type_code VARCHAR 31 √ null

not all types are categories
encounter_type_description TEXT 65535 √ null
referring_provider_id INT 10 √ 0

referring provider, if any, for this visit
date_end DATETIME 19 √ null
in_collection BIT 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
encounter_date Performance Asc date
pid_encounter Performance Asc/Asc pid + encounter
uuid Must be unique Asc uuid

Relationships

Close relationships within degrees of separation