visual_acuity

A test to quantify an individual's visual acuity as a measure of the ability to detect, resolve or recognize visual details.

A test to quantify an individual's visual acuity as a measure of the ability to detect, resolve or recognize visual details.

Purpose. To record the results of visual acuity assessments, which are typically performed by quantifying the individual's ability to detect, resolve or identify visual differences or symbols.

Source

Columns

Constraints

check ((eye_examined_code is null and eye_examined_system is null and eye_examined_valueset_id is null and eye_examined is null) or (eye_examined is not null and eye_examined_code is not null and eye_examined_system is not null and eye_examined_valueset_id is not null))
check ((result_log_mar_result_magnitude is null and result_log_mar_result_units is null) or (result_log_mar_result_magnitude is not null and result_log_mar_result_units is not null))
check (result_log_mar_result_magnitude is null or (result_log_mar_result_units = '1{logMAR}' and result_log_mar_result_magnitude between -10 and 10))
check ((result_metre_ratio_result_numerator is null and result_metre_ratio_result_denominator is null) or (result_metre_ratio_result_numerator is not null and result_metre_ratio_result_denominator is not null))
check (result_metre_ratio_result_denominator is null or result_metre_ratio_result_denominator <> 0)
check (result_metre_ratio_result_numerator is null or result_metre_ratio_result_numerator between 0 and 100)
check ((result_feet_ratio_result_numerator is null and result_feet_ratio_result_denominator is null) or (result_feet_ratio_result_numerator is not null and result_feet_ratio_result_denominator is not null))
check (result_feet_ratio_result_denominator is null or result_feet_ratio_result_denominator <> 0)
check (result_feet_ratio_result_numerator is null or result_feet_ratio_result_numerator between 0 and 1000)
check ((result_decimal_notation_result_magnitude is null and result_decimal_notation_result_units is null) or (result_decimal_notation_result_magnitude is not null and result_decimal_notation_result_units is not null))
check (result_decimal_notation_result_magnitude is null or (result_decimal_notation_result_units = '1{decimal VA}' and result_decimal_notation_result_magnitude between 0 and 10))
check (result_etdrs_letter_score is null or result_etdrs_letter_score between 0 and 1000)
check ((result__5_score_notation_result_magnitude is null and result__5_score_notation_result_units is null) or (result__5_score_notation_result_magnitude is not null and result__5_score_notation_result_units is not null))
check (result__5_score_notation_result_magnitude is null or (result__5_score_notation_result_units = '1{5PointVA}' and result__5_score_notation_result_magnitude between 0 and 10))
check ((result_n_point_font_size_notation_result_code is null and result_n_point_font_size_notation_result_system is null and result_n_point_font_size_notation_result_numeric is null and result_n_point_font_size_notation_result is null) or (result_n_point_font_size_notation_result_valueset_id is not null and result_n_point_font_size_notation_result_code is not null and result_n_point_font_size_notation_result_system is not null and result_n_point_font_size_notation_result_numeric is not null and result_n_point_font_size_notation_result is not null))
check ((result_jaeger_font_size_notation_result_code is null and result_jaeger_font_size_notation_result_system is null and result_jaeger_font_size_notation_result_numeric is null and result_jaeger_font_size_notation_result is null) or (result_jaeger_font_size_notation_result_valueset_id is not null and result_jaeger_font_size_notation_result_code is not null and result_jaeger_font_size_notation_result_system is not null and result_jaeger_font_size_notation_result_numeric is not null and result_jaeger_font_size_notation_result is not null))
check ((result_cycles_per_centimetre_result_magnitude is null and result_cycles_per_centimetre_result_units is null) or (result_cycles_per_centimetre_result_magnitude is not null and result_cycles_per_centimetre_result_units is not null))
check (result_cycles_per_centimetre_result_magnitude is null or (result_cycles_per_centimetre_result_units = '1/cm' and result_cycles_per_centimetre_result_magnitude between 0 and 1000))
check ((result_cycles_per_degree_result_magnitude is null and result_cycles_per_degree_result_units is null) or (result_cycles_per_degree_result_magnitude is not null and result_cycles_per_degree_result_units is not null))
check (result_cycles_per_degree_result_magnitude is null or (result_cycles_per_degree_result_units = '1/deg' and result_cycles_per_degree_result_magnitude between 0 and 10000))
check ((result_best_qualitative_result_code is null and result_best_qualitative_result_system is null and result_best_qualitative_result_numeric is null and result_best_qualitative_result is null) or (result_best_qualitative_result_valueset_id is not null and result_best_qualitative_result_code is not null and result_best_qualitative_result_system is not null and result_best_qualitative_result_numeric is not null and result_best_qualitative_result is not null))
check (result_missed_or_additional_optotypes_count is null or result_missed_or_additional_optotypes_count between -9 and 9)
check ((result_missed_or_additional_optotypes_coded_text_code is null and result_missed_or_additional_optotypes_coded_text_system is null and result_missed_or_additional_optotypes_coded_text_valueset_id is null and result_missed_or_additional_optotypes_coded_text is null) or (result_missed_or_additional_optotypes_coded_text is not null and result_missed_or_additional_optotypes_coded_text_code is not null and result_missed_or_additional_optotypes_coded_text_system is not null and result_missed_or_additional_optotypes_coded_text_valueset_id is not null))
check (num_nonnulls(result_missed_or_additional_optotypes_count, result_missed_or_additional_optotypes_coded_text) <= 1)
check ((result_derived_result_derived_log_mar_result_magnitude is null and result_derived_result_derived_log_mar_result_units is null) or (result_derived_result_derived_log_mar_result_magnitude is not null and result_derived_result_derived_log_mar_result_units is not null))
check (result_derived_result_derived_log_mar_result_magnitude is null or (result_derived_result_derived_log_mar_result_units = '1{logMAR}' and result_derived_result_derived_log_mar_result_magnitude between -10 and 10))
check ((result_derived_result_derived_meter_ratio_result_numerator is null and result_derived_result_derived_meter_ratio_result_denominator is null) or (result_derived_result_derived_meter_ratio_result_numerator is not null and result_derived_result_derived_meter_ratio_result_denominator is not null))
check (result_derived_result_derived_meter_ratio_result_denominator is null or result_derived_result_derived_meter_ratio_result_denominator <> 0)
check (result_derived_result_derived_meter_ratio_result_numerator is null or result_derived_result_derived_meter_ratio_result_numerator between 0 and 100)
check ((result_derived_result_derived_feet_ratio_result_numerator is null and result_derived_result_derived_feet_ratio_result_denominator is null) or (result_derived_result_derived_feet_ratio_result_numerator is not null and result_derived_result_derived_feet_ratio_result_denominator is not null))
check (result_derived_result_derived_feet_ratio_result_denominator is null or result_derived_result_derived_feet_ratio_result_denominator <> 0)
check (result_derived_result_derived_feet_ratio_result_numerator is null or result_derived_result_derived_feet_ratio_result_numerator between 0 and 1000)
check ((result_derived_result_derived_decimal_notation_result_magnitude is null and result_derived_result_derived_decimal_notation_result_units is null) or (result_derived_result_derived_decimal_notation_result_magnitude is not null and result_derived_result_derived_decimal_notation_result_units is not null))
check (result_derived_result_derived_decimal_notation_result_magnitude is null or (result_derived_result_derived_decimal_notation_result_units = '1{decimal VA}' and result_derived_result_derived_decimal_notation_result_magnitude between 0 and 10))
check (result_derived_result_derived_etdrs_letter_score_result is null or result_derived_result_derived_etdrs_letter_score_result between 0 and 1000)
check ((result_derived_result_derived_cycles_per_degree_magnitude is null and result_derived_result_derived_cycles_per_degree_units is null) or (result_derived_result_derived_cycles_per_degree_magnitude is not null and result_derived_result_derived_cycles_per_degree_units is not null))
check (result_derived_result_derived_cycles_per_degree_magnitude is null or (result_derived_result_derived_cycles_per_degree_units = '1/deg' and result_derived_result_derived_cycles_per_degree_magnitude between 0 and 10000))
check ((testing_distance_category_code is null and testing_distance_category_system is null and testing_distance_category_valueset_id is null and testing_distance_category is null) or (testing_distance_category is not null and testing_distance_category_code is not null and testing_distance_category_system is not null and testing_distance_category_valueset_id is not null))
check ((testing_distance_magnitude is null and testing_distance_units is null) or (testing_distance_magnitude is not null and testing_distance_units is not null))
check (testing_distance_magnitude is null or (testing_distance_units = 'm' and testing_distance_magnitude between 0 and 1000) or (testing_distance_units = 'cm' and testing_distance_magnitude between 0 and 10000) or (testing_distance_units = '[in_i]' and testing_distance_magnitude between 0 and 10000) or (testing_distance_units = '[ft_i]' and testing_distance_magnitude between 0 and 10000))
check ((perceptual_task_code is null and perceptual_task_system is null and perceptual_task_valueset_id is null and perceptual_task is null) or (perceptual_task is not null and perceptual_task_code is not null and perceptual_task_system is not null and perceptual_task_valueset_id is not null))
check ((stimulus_method_code is null and stimulus_method_system is null and stimulus_method_valueset_id is null and stimulus_method is null) or (stimulus_method is not null and stimulus_method_code is not null and stimulus_method_system is not null and stimulus_method_valueset_id is not null))
check ((chart_or_stimulus_type_code is null and chart_or_stimulus_type_system is null and chart_or_stimulus_type_valueset_id is null) or (chart_or_stimulus_type is not null and chart_or_stimulus_type_code is not null and chart_or_stimulus_type_system is not null and chart_or_stimulus_type_valueset_id is not null))
check ((optotype_code is null and optotype_system is null and optotype_valueset_id is null) or (optotype is not null and optotype_code is not null and optotype_system is not null and optotype_valueset_id is not null))
check ((crowdedness_code is null and crowdedness_system is null and crowdedness_valueset_id is null and crowdedness is null) or (crowdedness is not null and crowdedness_code is not null and crowdedness_system is not null and crowdedness_valueset_id is not null))
check ((contrast_category_code is null and contrast_category_system is null and contrast_category_valueset_id is null and contrast_category is null) or (contrast_category is not null and contrast_category_code is not null and contrast_category_system is not null and contrast_category_valueset_id is not null))
check ((weber_contrast_numerator is null and weber_contrast_denominator is null) or (weber_contrast_numerator is not null and weber_contrast_denominator is not null))
check (weber_contrast_denominator is null or weber_contrast_denominator <> 0)
check (weber_contrast_denominator is null or weber_contrast_denominator = 1)
check ((michelson_contrast_numerator is null and michelson_contrast_denominator is null) or (michelson_contrast_numerator is not null and michelson_contrast_denominator is not null))
check (michelson_contrast_denominator is null or michelson_contrast_denominator <> 0)
check (michelson_contrast_denominator is null or michelson_contrast_denominator = 1)
check ((no_improvement_note_code is null and no_improvement_note_system is null and no_improvement_note_valueset_id is null) or (no_improvement_note is not null and no_improvement_note_code is not null and no_improvement_note_system is not null and no_improvement_note_valueset_id is not null))
check ((comparative_label_code is null and comparative_label_system is null and comparative_label_valueset_id is null) or (comparative_label is not null and comparative_label_code is not null and comparative_label_system is not null and comparative_label_valueset_id is not null))
check ((pupil_state_code is null and pupil_state_system is null and pupil_state_valueset_id is null) or (pupil_state is not null and pupil_state_code is not null and pupil_state_system is not null and pupil_state_valueset_id is not null))
check ((type_of_ancillary_lighting_used_code is null and type_of_ancillary_lighting_used_system is null and type_of_ancillary_lighting_used_valueset_id is null and type_of_ancillary_lighting_used is null) or (type_of_ancillary_lighting_used is not null and type_of_ancillary_lighting_used_code is not null and type_of_ancillary_lighting_used_system is not null and type_of_ancillary_lighting_used_valueset_id is not null))
check ((light_adaptation_state_code is null and light_adaptation_state_system is null and light_adaptation_state_valueset_id is null and light_adaptation_state is null) or (light_adaptation_state is not null and light_adaptation_state_code is not null and light_adaptation_state_system is not null and light_adaptation_state_valueset_id is not null))
check ((ambient_illuminance_magnitude is null and ambient_illuminance_units is null) or (ambient_illuminance_magnitude is not null and ambient_illuminance_units is not null))
check ((background_luminance_magnitude is null and background_luminance_units is null) or (background_luminance_magnitude is not null and background_luminance_units is not null))

Unique

• form_block_id

References

Referenced by

• visual_acuity_chart_or_stimulus_device_details via visual_acuity_id
• visual_acuity_test_not_done via visual_acuity_id
• visual_acuity_visual_aid_per_eye via visual_acuity_id

Indexes

• visual_acuity_form_id_idx on form_id

Child tables

3 tables hang off visual_acuity, one row per repetition.

visual_acuity_chart_or_stimulus_device_details

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

Unique

• visual_acuity_id, position
• visual_acuity_id, device_id

References

Indexes

• visual_acuity_chart_or_stimulus_device_details_device_id_idx on device_id

visual_acuity_test_not_done

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

Unique

• visual_acuity_id, position
• visual_acuity_id, exclusion_exam_id

References

Indexes

• visual_acuity_test_not_done_exclusion_exam_id_idx on exclusion_exam_id

visual_acuity_visual_aid_per_eye

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

Constraints

check ((aided_eye_code is null and aided_eye_system is null and aided_eye_valueset_id is null and aided_eye is null) or (aided_eye is not null and aided_eye_code is not null and aided_eye_system is not null and aided_eye_valueset_id is not null))
check ((visual_aid_type_code is null and visual_aid_type_system is null and visual_aid_type_valueset_id is null) or (visual_aid_type is not null and visual_aid_type_code is not null and visual_aid_type_system is not null and visual_aid_type_valueset_id is not null))
check ((cycloplegia_during_refraction_code is null and cycloplegia_during_refraction_system is null and cycloplegia_during_refraction_valueset_id is null and cycloplegia_during_refraction is null) or (cycloplegia_during_refraction is not null and cycloplegia_during_refraction_code is not null and cycloplegia_during_refraction_system is not null and cycloplegia_during_refraction_valueset_id is not null))
check ((power_of_sphere_magnitude is null and power_of_sphere_units is null) or (power_of_sphere_magnitude is not null and power_of_sphere_units is not null))
check ((power_of_cylinder_magnitude is null and power_of_cylinder_units is null) or (power_of_cylinder_magnitude is not null and power_of_cylinder_units is not null))
check ((axis_of_cylinder_magnitude is null and axis_of_cylinder_units is null) or (axis_of_cylinder_magnitude is not null and axis_of_cylinder_units is not null))
check ((near_addition_magnitude is null and near_addition_units is null) or (near_addition_magnitude is not null and near_addition_units is not null))

Unique

• visual_acuity_id, position

References

Indexes

• visual_acuity_visual_aid_per_eye_visual_aid_details_idx on visual_aid_details

Value sets