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
amendments_history.amendment_note Defined in XML R
amendments_history.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
care_team.status Defined in XML R
care_team_member.role Defined in XML R
care_team_member.status Defined in XML R
contact_address.type Defined in XML R
contact_address.use Defined in XML R
contact_relation.relationship Defined in XML R
contact_relation.role Defined in XML R
contact_telecom.system Defined in XML R
contact_telecom.use Defined in XML R
drug_sales.pharmacy_supply_type Defined in XML R
employer_data.industry Defined in XML R
employer_data.occupation Defined in XML R
form_care_plan.care_plan_type Defined in XML R
form_care_plan.plan_status Defined in XML R
form_clinical_notes.clinical_notes_category Defined in XML R
form_clinical_notes.clinical_notes_type Defined in XML R
form_history_sdoh.childcare_needs Defined in XML R
form_history_sdoh.digital_access Defined in XML R
form_history_sdoh.disability_status Defined in XML R
form_history_sdoh.financial_strain Defined in XML R
form_history_sdoh.food_insecurity Defined in XML R
form_history_sdoh.housing_instability Defined in XML R
form_history_sdoh.hunger_q1 Defined in XML R
form_history_sdoh.hunger_q2 Defined in XML R
form_history_sdoh.interpersonal_safety Defined in XML R
form_history_sdoh.postpartum_status Defined in XML R
form_history_sdoh.pregnancy_intent Defined in XML R
form_history_sdoh.pregnancy_status Defined in XML R
form_history_sdoh.screening_tool Defined in XML R
form_history_sdoh.social_isolation Defined in XML R
form_history_sdoh.transportation_insecurity Defined in XML R
form_history_sdoh.utilities_insecurity Defined in XML R
form_observation.category Defined in XML R
form_observation.ob_status Defined in XML R
form_questionnaire_assessments.category Defined in XML R
form_vital_details.interpretation_option_id 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
lists_medication.medication_adherence Defined in XML R
lists_medication.medication_adherence_information_source Defined in XML R
lists_medication.request_intent Defined in XML R
lists_medication.usage_category Defined in XML R
openemr_postcalendar_events.pc_apptstatus Defined in XML R
openemr_postcalendar_events.pc_room Defined in XML R
patient_care_experience_preferences.observation_code Defined in XML R
patient_data.interpreter_needed Defined in XML R
patient_data.sex_identified Defined in XML R
patient_data.tribal_affiliations 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
patient_treatment_intervention_preferences.observation_code Defined in XML R
pnotes.message_status Defined in XML R
prescriptions.request_intent Defined in XML R
prescriptions.route Defined in XML R
prescriptions.usage_category Defined in XML R
procedure_order.billing_type Defined in XML R
procedure_order.order_intent Defined in XML R
procedure_order.order_priority Defined in XML R
procedure_order.order_status Defined in XML R
procedure_order.performer_type 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_specimen.collection_method_code Defined in XML R
procedure_specimen.condition_code Defined in XML R
procedure_specimen.specimen_location_code Defined in XML R
procedure_specimen.specimen_type_code Defined in XML R
procedure_type.procedure_type Defined in XML R
questionnaire_repository.category 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 BOOLEAN 3 0
option_value FLOAT 12 0
mapping VARCHAR 31 ''
notes TEXT 65535 √ NULL
codes VARCHAR 255 ''
toggle_setting_1 BOOLEAN 3 0
toggle_setting_2 BOOLEAN 3 0
activity TINYINT 3 1
subtype VARCHAR 31 ''
edit_options BOOLEAN 3 1
timestamp TIMESTAMP 19 current_timestamp()
last_updated DATETIME 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