Documentation/EHI_Export/docs/tables/openemr_postcalendar_events.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pc_eid | INT UNSIGNED | 10 | √ | null |
| form_groups_encounter.appt_id | Defined in XML | R | | patient_tracker.eid | Defined in XML | R |
|
|
Surrogate id of the record used as the primary incrementing key
| | pc_catid | INT | 10 | | | 0 |
|
| openemr_postcalendar_categories.pc_catid | Defined in XML | R |
|
The appointment category
| | pc_multiple | INT UNSIGNED | 10 | | | null |
|
|
Multiple occurrences of the event. Used if this is a recurring appointment.
| | pc_aid | VARCHAR | 30 | √ | | NULL |
|
| users.id | Defined in XML | R |
|
The provider this appointment is connected to
| | pc_pid | VARCHAR | 11 | √ | | NULL |
|
| patient_data.pid | Defined in XML | R |
|
The internal patient identifier
| | pc_gid | INT | 10 | √ | | 0 |
|
| therapy_groups.group_id | Defined in XML | R |
|
The therapy group id this appointment is for
| | pc_title | VARCHAR | 150 | √ | | NULL |
|
|
Title of the event
| | pc_time | DATETIME | 19 | √ | | NULL |
|
|
Time of the event
| | pc_hometext | TEXT | 65535 | √ | | NULL |
|
|
Description of the event
| | pc_comments | INT | 10 | √ | | 0 |
|
|
Comments associated with the event
| | pc_counter | MEDIUMINT UNSIGNED | 8 | √ | | 0 |
|
|
Event counter
| | pc_topic | INT | 10 | | | 1 |
|
|
Topic id of the event
| | pc_informant | VARCHAR | 20 | √ | | NULL |
|
| users.id | Defined in XML | R |
|
User creating the event
| | pc_eventDate | DATE | 10 | | | '0000-00-00' |
|
|
Date of the event
| | pc_endDate | DATE | 10 | | | '0000-00-00' |
|
|
End date of the event
| | pc_duration | BIGINT | 19 | | | 0 |
|
|
Duration of the event
| | pc_recurrtype | INT | 10 | | | 0 |
|
|
Recurrence type of the event
| | pc_recurrspec | TEXT | 65535 | √ | | NULL |
|
|
Recurrence specification of the event
| | pc_recurrfreq | INT | 10 | | | 0 |
|
|
Recurrence frequency of the event
| | pc_startTime | TIME | 10 | √ | | NULL |
|
|
Start time of the event
| | pc_endTime | TIME | 10 | √ | | NULL |
|
|
End time of the event
| | pc_alldayevent | INT | 10 | | | 0 |
|
|
Indicates if the event is an all-day event
| | pc_location | TEXT | 65535 | √ | | NULL |
|
|
Location of the event
| | pc_conttel | VARCHAR | 50 | √ | | NULL |
|
|
Contact telephone number
| | pc_contname | VARCHAR | 50 | √ | | NULL |
|
|
Contact name
| | pc_contemail | VARCHAR | 255 | √ | | NULL |
|
|
Contact email address
| | pc_website | VARCHAR | 255 | √ | | NULL |
|
|
Website associated with the event
| | pc_fee | VARCHAR | 50 | √ | | NULL |
|
|
Event fee
| | pc_eventstatus | INT | 10 | | | 0 |
|
|
Event status -1=hidden,0=queued,1=approved
| | pc_sharing | INT | 10 | | | 0 |
|
|
Sharing status of the event
| | pc_language | VARCHAR | 30 | √ | | NULL |
|
|
Language of the event
| | pc_apptstatus | VARCHAR | 15 | | | '-' |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘apptstat’ if it is a single patient appointment OR list_options.list_id=‘groupstat’ if this is a group appointment. It represents the current appointment status checked in, checked out, waiting, etc
| | pc_prefcatid | INT | 10 | | | 0 |
|
| openemr_postcalendar_categories.pc_catid | Defined in XML | R |
|
Preferred category id for a provider available slot
| | pc_facility | INT | 10 | | | 0 |
|
| facility.id | Defined in XML | R |
|
The facility for where the service for this appointment will be rendered
| | pc_sendalertsms | VARCHAR | 3 | | | 'NO' |
|
|
Send SMS alerts for the event
| | pc_sendalertemail | VARCHAR | 3 | | | 'NO' |
|
|
Send email alerts for the event
| | pc_billing_location | SMALLINT | 5 | | | 0 |
|
| facility.id | Defined in XML | R |
|
Billing facility location of the event
| | pc_room | VARCHAR | 20 | | | '' |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘patient_flow_board_rooms’ and represents the facility room that the patient has been assigned to for this appointment if one has been assigned
| | uuid | BINARY | 16 | √ | | NULL |
|
|
UUID of the record
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | pc_eid |
| basic_event | Performance | Asc/Asc/Asc/Asc/Asc/Asc/Asc | pc_catid + pc_aid + pc_eventDate + pc_endDate + pc_eventstatus + pc_sharing + pc_topic |
| pc_eventDate | Performance | Asc | pc_eventDate |
| uuid | Must be unique | Asc | uuid |