| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
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 |
|
|
Unique identifier for the billing facility that will be used for this encounter. |
|||||
| group_id | BIGINT | 19 | √ | NULL |
|
|
FK to the therapy group that is attending for the encounter service |
||||
| encounter | BIGINT | 19 | √ | NULL |
|
|
|||||
| 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 |
|
|
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 |
|
|
Default and main provider for this visit |
||||
| supervisor_id | INT | 10 | √ | 0 |
|
|
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 |
|
|
The calendar appointment id that this encounter is associated with or that this encounter was created from |