openemr_postcalendar_events


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 openemr_postcalendar_events.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

Holds records for Patient Appointment/Calendar information

Columns

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_title VARCHAR 150 √ NULL

Title of the event
pc_time DATETIME 19 √ NULL

Time of the event
pc_hometext MEDIUMTEXT 16777215 √ 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 MEDIUMTEXT 16777215 √ 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 MEDIUMTEXT 16777215 √ 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
pc_gid INT 10 √ 0
therapy_groups.group_id Defined in XML R

The therapy group id this appointment is for
uuid BINARY 16 √ NULL

UUID of the record

Indexes

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

Relationships

Close relationships within degrees of separation