list_options


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

Contains lists of unique value sets that a record’s property can be. Individual values/options in the list may be linked to a specific codesystem

Columns

Column Type Size Nulls Auto Default Children Parents Comments
list_id VARCHAR 100
form_vital_details.interpretation_list_id Defined in XML R
option_id VARCHAR 100
amendments.amendment_by Defined in XML R
amendments.amendment_status Defined in XML R
ar_session.adjustment_code Defined in XML R
ar_session.payment_method Defined in XML R
ar_session.payment_type Defined in XML R
billing.chargecat Defined in XML R
form_clinical_notes.clinical_notes_category Defined in XML R
form_clinical_notes.clinical_notes_type Defined in XML R
immunizations.administration_site Defined in XML R
immunizations.amount_administered_unit Defined in XML R
immunizations.completion_status Defined in XML R
immunizations.immunization_id Defined in XML R
immunizations.information_source Defined in XML R
immunizations.manufacturer Defined in XML R
immunizations.refusal_reason Defined in XML R
immunizations.route Defined in XML R
lists.list_option_id Defined in XML R
lists.occurrence Defined in XML R
lists.outcome Defined in XML R
lists.reaction Defined in XML R
lists.severity_al Defined in XML R
lists.subtype Defined in XML R
lists.verification Defined in XML R
amendments_history.amendment_note Defined in XML R
amendments_history.amendment_status Defined in XML R
form_vital_details.interpretation_option_id Defined in XML R
openemr_postcalendar_events.pc_apptstatus Defined in XML R
openemr_postcalendar_events.pc_room Defined in XML R
patient_reminders.due_status Defined in XML R
patient_reminders.reason_inactivated Defined in XML R
patient_tracker_element.room Defined in XML R
patient_tracker_element.status Defined in XML R
pnotes.message_status Defined in XML R
procedure_order.billing_type Defined in XML R
procedure_order.order_priority Defined in XML R
procedure_order.order_status Defined in XML R
procedure_order.procedure_order_type Defined in XML R
procedure_order.procedure_type Defined in XML R
procedure_order.specimen_location Defined in XML R
procedure_order.specimen_type Defined in XML R
procedure_report.report_status Defined in XML R
procedure_type.procedure_type Defined in XML R
rule_action_item.category Defined in XML R
rule_action_item.item Defined in XML R
therapy_groups_participant_attendance.meeting_patient_status Defined in XML R
title VARCHAR 255
seq INT 10 0
is_default BIT 1 0
option_value FLOAT 12 0
mapping VARCHAR 31
notes TEXT 65535 √ null
codes VARCHAR 255
toggle_setting_1 BIT 1 0
toggle_setting_2 BIT 1 0
activity TINYINT 3 1
subtype VARCHAR 31
edit_options BIT 1 1
timestamp TIMESTAMP 19 current_timestamp()

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc list_id + option_id

Relationships

Close relationships within degrees of separation