problem_qualifier

Contextual or temporal qualifier for a specified problem or diagnosis.

Contextual or temporal qualifier for a specified problem or diagnosis.

Purpose. To record a clinical context-specific or time-specific qualifier for a specified problem or diagnosis.

Source

Columns

Constraints

check ((diagnostic_status_code is null and diagnostic_status_system is null and diagnostic_status_valueset_id is null) or (diagnostic_status is not null and diagnostic_status_code is not null and diagnostic_status_system is not null and diagnostic_status_valueset_id is not null))
check ((disorder_category_code is null and disorder_category_system is null and disorder_category_valueset_id is null) or (disorder_category is not null and disorder_category_code is not null and disorder_category_system is not null and disorder_category_valueset_id is not null))
check ((current_past_code is null and current_past_system is null and current_past_valueset_id is null and current_past is null) or (current_past is not null and current_past_code is not null and current_past_system is not null and current_past_valueset_id is not null))
check ((active_inactive_code is null and active_inactive_system is null and active_inactive_valueset_id is null and active_inactive is null) or (active_inactive is not null and active_inactive_code is not null and active_inactive_system is not null and active_inactive_valueset_id is not null))
check ((level_of_control_code is null and level_of_control_system is null and level_of_control_valueset_id is null) or (level_of_control is not null and level_of_control_code is not null and level_of_control_system is not null and level_of_control_valueset_id is not null))
check ((progression_code is null and progression_system is null and progression_valueset_id is null) or (progression is not null and progression_code is not null and progression_system is not null and progression_valueset_id is not null))
check ((resolution_phase_code is null and resolution_phase_system is null and resolution_phase_valueset_id is null) or (resolution_phase is not null and resolution_phase_code is not null and resolution_phase_system is not null and resolution_phase_valueset_id is not null))
check ((remission_status_code is null and remission_status_system is null and remission_status_valueset_id is null) or (remission_status is not null and remission_status_code is not null and remission_status_system is not null and remission_status_valueset_id is not null))
check ((episodicity_code is null and episodicity_system is null and episodicity_valueset_id is null) or (episodicity is not null and episodicity_code is not null and episodicity_system is not null and episodicity_valueset_id is not null))
check ((occurrence_code is null and occurrence_system is null and occurrence_valueset_id is null) or (occurrence is not null and occurrence_code is not null and occurrence_system is not null and occurrence_valueset_id is not null))
check ((course_label_code is null and course_label_system is null and course_label_valueset_id is null) or (course_label is not null and course_label_code is not null and course_label_system is not null and course_label_valueset_id is not null))
check ((diagnostic_category_code is null and diagnostic_category_system is null and diagnostic_category_valueset_id is null) or (diagnostic_category is not null and diagnostic_category_code is not null and diagnostic_category_system is not null and diagnostic_category_valueset_id is not null))
check ((admission_diagnosis_coded_text_code is null and admission_diagnosis_coded_text_system is null and admission_diagnosis_coded_text_valueset_id is null and admission_diagnosis_coded_text is null) or (admission_diagnosis_coded_text is not null and admission_diagnosis_coded_text_code is not null and admission_diagnosis_coded_text_system is not null and admission_diagnosis_coded_text_valueset_id is not null))
check (num_nonnulls(admission_diagnosis_boolean, admission_diagnosis_coded_text) <= 1)

References

Referenced by

• problem_diagnosis_status via problem_qualifier_id

Value sets