medication_order

An order for a medication, vaccine, nutritional product or other therapeutic item for an identified individual.

An order for a medication, vaccine, nutritional product or other therapeutic item for an identified individual.

Purpose. To record all aspects of an order of a medication, vaccine, nutritional product or other therapeutic item for an identified individual.

Source

Columns

Constraints

check ((medication_item_code is null and medication_item_system is null and medication_item_valueset_id is null) or (medication_item is not null and medication_item_code is not null and medication_item_system is not null and medication_item_valueset_id is not null))
check ((route_code is null and route_system is null and route_valueset_id is null) or (route is not null and route_code is not null and route_system is not null and route_valueset_id is not null))
check ((body_site_code is null and body_site_system is null and body_site_valueset_id is null) or (body_site is not null and body_site_code is not null and body_site_system is not null and body_site_valueset_id is not null))
check (num_nonnulls(structured_body_site_anatomical_location, structured_body_site_anatomical_location_circle, structured_body_site_anatomical_location_relative) <= 1)
check ((administration_method_code is null and administration_method_system is null and administration_method_valueset_id is null) or (administration_method is not null and administration_method_code is not null and administration_method_system is not null and administration_method_valueset_id is not null))
check ((parsable_directions_value is null and parsable_directions_formalism is null) or (parsable_directions_value is not null and parsable_directions_formalism is not null))
check ((medication_safety_total_daily_effective_dose_t_9a749e_magnitude is null and medication_safety_total_daily_effective_dose_t_9a749e_units is null) or (medication_safety_total_daily_effective_dose_t_9a749e_magnitude is not null and medication_safety_total_daily_effective_dose_t_9a749e_units is not null))
check ((additional_instruction_code is null and additional_instruction_system is null and additional_instruction_valueset_id is null) or (additional_instruction is not null and additional_instruction_code is not null and additional_instruction_system is not null and additional_instruction_valueset_id is not null))
check ((patient_information_code is null and patient_information_system is null and patient_information_valueset_id is null) or (patient_information is not null and patient_information_code is not null and patient_information_system is not null and patient_information_valueset_id is not null))
check ((clinical_indication_code is null and clinical_indication_system is null and clinical_indication_valueset_id is null) or (clinical_indication is not null and clinical_indication_code is not null and clinical_indication_system is not null and clinical_indication_valueset_id is not null))
check (order_details_administrations_completed is null or order_details_administrations_completed >= 0)
check ((dispense_directions_substitution_direction_code is null and dispense_directions_substitution_direction_system is null and dispense_directions_substitution_direction_valueset_id is null and dispense_directions_substitution_direction is null) or (dispense_directions_substitution_direction is not null and dispense_directions_substitution_direction_code is not null and dispense_directions_substitution_direction_system is not null and dispense_directions_substitution_direction_valueset_id is not null))
check ((dispense_directions_priority_code is null and dispense_directions_priority_system is null and dispense_directions_priority_valueset_id is null) or (dispense_directions_priority is not null and dispense_directions_priority_code is not null and dispense_directions_priority_system is not null and dispense_directions_priority_valueset_id is not null))
check (order_identifier_system is null or order_identifier_value is not null)

Unique

• form_block_id

References

Referenced by

• medication_order_medication_details via medication_order_id
• medication_order_administration_device via medication_order_id
• medication_order_structured_dose_and_timing_directions via medication_order_id
• medication_order_medication_safety_safety_override via medication_order_id
• medication_order_medication_safety_maximum_dose via medication_order_id

Indexes

• medication_order_form_id_idx on form_id
• medication_order_structured_body_site_anatomical_location_idx on structured_body_site_anatomical_location
• medication_order_structured_body_site_anatomical_locatio_9a7a76 on structured_body_site_anatomical_location_circle
• medication_order_structured_body_site_anatomical_locatio_f2eb61 on structured_body_site_anatomical_location_relative

Child tables

5 tables hang off medication_order, one row per repetition.

medication_order_medication_details

Child table — one row per repetition, deleted with its parent.

Unique

• medication_order_id, position
• medication_order_id, medication_detail_id

References

Indexes

• medication_order_medication_details_medication_detail_id_idx on medication_detail_id

medication_order_administration_device

Child table — one row per repetition, deleted with its parent.

Unique

• medication_order_id, position
• medication_order_id, device_id

References

Indexes

• medication_order_administration_device_device_id_idx on device_id

medication_order_structured_dose_and_timing_directions

Child table — one row per repetition, deleted with its parent.

Unique

• medication_order_id, position
• medication_order_id, therapeutic_direction_id

References

Indexes

• medication_order_structured_dose_and_timing_directions_t_81b978 on therapeutic_direction_id

medication_order_medication_safety_safety_override

Child table — one row per repetition, deleted with its parent.

Unique

• medication_order_id, position

References

medication_order_medication_safety_maximum_dose

Child table — one row per repetition, deleted with its parent.

Constraints

check ((maximum_amount_magnitude is null and maximum_amount_units is null) or (maximum_amount_magnitude is not null and maximum_amount_units is not null))

Unique

• medication_order_id, position

References

Value sets