form_groups_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_groups_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 group of patient’s visit to a healthcare provider. This is different than an appointment as this table tracks the actual service of care for a therapy group

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
forms.form_id Defined in XML R

The primary key which is the same as the forms.form_id column
date DATETIME 19 √ NULL

Date and time of the encounter
reason LONGTEXT 2147483647 √ NULL

The reason for the encounter
facility LONGTEXT 2147483647 √ NULL

The facility or location of the encounter
facility_id INT 10 0
facility.id Defined in XML R

Unique identifier for the billing facility that will be used for this encounter.
group_id BIGINT 19 √ NULL
therapy_groups.group_id Defined in XML R

FK to the therapy group that is attending for the encounter service
encounter BIGINT 19 √ NULL
form_group_attendance.encounter_id Defined in XML R
onset_date DATETIME 19 √ NULL

The date when the condition or issue for the group started
sensitivity VARCHAR 30 √ NULL

Sensitivity information related to the encounter as to who should be able to access / view this encounter
billing_note TEXT 65535 √ NULL

Notes related to billing for the encounter
pc_catid INT 10 5
openemr_postcalendar_categories.pc_catid Defined in XML R

The encounter service category taken from ‘openemr_postcalendar_categories’
last_level_billed INT 10 0

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

The party for whom payment was last received. 0=None, 1=Ins1, 2=Ins2, 3=Ins3
last_stmt_date DATE 10 √ NULL

The date of the last statement
stmt_count INT 10 0

The statement count
provider_id INT 10 √ 0
users.id Defined in XML R

Default and main provider for this visit
supervisor_id INT 10 √ 0
users.id Defined in XML R

Supervising provider, if any, for this visit
invoice_refno VARCHAR 31 ''

Reference number for the invoice
referral_source VARCHAR 31 ''

Source of the referral
billing_facility INT 10 0

ID of the billing facility
external_id VARCHAR 20 √ NULL

External ID associated with the encounter
pos_code TINYINT 3 √ NULL

Place of service code
counselors VARCHAR 255 √ NULL

Information about counselors related to the encounter
appt_id INT 10 √ NULL
openemr_postcalendar_events.pc_eid Defined in XML R

The calendar appointment id that this encounter is associated with or that this encounter was created from

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
encounter_date Performance Asc date
pid_encounter Performance Asc/Asc group_id + encounter

Relationships

Close relationships within degrees of separation