Pretesting
This section includes data related to optometric pretesting tests and measurements.
amsler_grid
Amsler grid test. One entry per test, zero or one entry per visit.
- amsler_grid_id
- visit_id
- patient_id
- result
- top_left_od
- top_left_os
- top_right_od
- top_right_os
- middle_center_od
- middle_center_os
- bottom_left_od
- bottom_left_os
- bottom_right_od
- bottom_right_os
- firm_global_id
binocular
Binocular tests (Near Point Conv., Near Point Accom., Phorias-D, Phorias-N, Vergence, Cross-Cylinder, Relative Accom., AC/A Ratio, Fusion/Stereopsis, Worth, Titmus, Dominance, Accommodative Facility, MEM Retinoscopy).
- binocular_id
- visit_id
- patient_id
- near_point_conv_test
- near_point_conv_reliability
- near_point_conv_blur
- near_point_conv_blur_selection
- near_point_conv_break
- near_point_conv_break_selection
- near_point_conv_recover
- near_point_conv_recover_selection
- near_point_accom_od
- near_point_accom_od_selection
- near_point_accom_os
- near_point_accom_os_selection
- near_point_accom_ou
- near_point_accom_ou_selection
- phorias_distance_test
- phorias_distance_measured_with
- phorias_distance_horiz
- phorias_distance_horiz_selection
- phorias_distance_deviation
- phorias_distance_od
- phorias_distance_od_selection
- phorias_distance_od_base
- phorias_distance_os
- phorias_distance_os_selection
- phorias_distance_os_base
- phorias_near_test
- phorias_near_measured_with
- phorias_near_horiz
- phorias_near_horiz_selection
- phorias_near_deviation
- phorias_near_od
- phorias_near_od_selection
- phorias_near_od_base
- phorias_near_os
- phorias_near_os_selection
- phorias_near_os_base
- vergence_measured_with
- divergence_distance_blur
- divergence_distance_blur_selection
- divergence_distance_break
- divergence_distance_break_selection
- divergence_distance_recover
- divergence_distance_recover_selection
- divergence_near_blur
- divergence_near_blur_selection
- divergence_near_break
- divergence_near_break_selection
- divergence_near_recover
- divergence_near_recover_selection
- convergence_distance_blur
- convergence_distance_blur_selection
- convergence_distance_break
- convergence_distance_break_selection
- convergence_distance_recover
- convergence_distance_recover_selection
- convergence_near_blur
- convergence_near_blur_selection
- convergence_near_break
- convergence_near_break_selection
- convergence_near_recover
- convergence_near_recover_selection
- cross_cylinder_bxc
- cross_cylinder_bxc_selection
- relative_accom_nra_blur
- relative_accom_nra_blur_selection
- relative_accom_nra_recover
- relative_accom_nra_recover_selection
- relative_accom_pra_blur
- relative_accom_pra_blur_selection
- relative_accom_pra_recover
- relative_accom_pra_recover_selection
- relative_accom_add
- relative_accom_acuity
- aca_numerator
- aca_numerator_selection
- aca_denominator
- aca_denominator_selection
- fusion_stereo_test
- fusion_stereo_reliability
- fusion_stereo_distance
- fusion_stereo_near
- worth_6_m
- worth_33_cm
- titmus_stereo_fly
- titmus_animal_a
- titmus_animal_b
- titmus_animal_c
- titmus_dots_1
- titmus_dots_2
- titmus_dots_3
- titmus_dots_4
- titmus_dots_5
- titmus_dots_6
- titmus_dots_7
- titmus_dots_8
- titmus_dots_9
- dominance
- accom_facility_method
- accom_facility_results
- accom_facility_rock_power
- accom_facility_reliability
- mem_ret_accom_lag
- mem_ret_accom_excess
- firm_global_id
central_retinal_thickness
Central Retinal Thickness. One entry per test, zero or one entry per visit.
- central_retinal_thickness_id
- visit_id
- patient_id
- central_retinal_thickness_od
- central_retinal_thickness_os
- firm_global_id
color_vision
Color vision tests (Pseudoisochromatic Plates and Farnsworth). Zero or one entry per visit.
- color_vision_id
- visit_id
- patient_id
- result
- test_type
- additional_notes
- farnsworth_od
- farnsworth_os
- correct_od
- correct_os
- plates_od
- plates_os
- od_1
- od_2
- od_3
- od_4
- od_5
- od_6
- od_7
- od_8
- od_9
- od_10
- od_11
- od_12
- od_13
- od_14
- od_15
- od_16
- od_17
- od_18
- od_19
- od_20
- od_21
- od_22
- od_23
- od_24
- od_25
- od_26
- od_27
- od_28
- od_29
- od_30
- od_31
- od_32
- od_33
- od_34
- od_35
- od_36
- od_37
- od_38
- os_1
- os_2
- os_3
- os_4
- os_5
- os_6
- os_7
- os_8
- os_9
- os_10
- os_11
- os_12
- os_13
- os_14
- os_15
- os_16
- os_17
- os_18
- os_19
- os_20
- os_21
- os_22
- os_23
- os_24
- os_25
- os_26
- os_27
- os_28
- os_29
- os_30
- os_31
- os_32
- os_33
- os_34
- os_35
- os_36
- os_37
- os_38
- firm_global_id
contacts_trial
Contact lens trial(s) given during the eye exam. Includes visual acuity with the contacts. One entry for each trial.
- contacts_trial_id
- visit_id
- patient_id
- date_recorded
- contacts_usage
- status
- wearing_schedule
- replenishment
- disinfecting
- notes
- print_notes
- expiration_date_od
- expiration_date_os
- lens_manufacturer_od
- lens_manufacturer_os
- lens_brand_od
- lens_brand_os
- lens_color_od
- lens_color_os
- start_date_od
- start_date_os
- base_curve_od
- base_curve_os
- diameter_od
- diameter_os
- underlying_condition_od
- underlying_condition_os
- sphere_od
- sphere_os
- cylinder_od
- cylinder_os
- axis_od
- axis_os
- add_od
- add_os
- refraction_other_od
- refraction_other_os
- visual_acuity_dcc_od
- visual_acuity_dcc_os
- visual_acuity_dcc_ou
- pinhole_dcc_od
- pinhole_dcc_os
- pinhole_dcc_ou
- glare_dcc_od
- glare_dcc_os
- glare_dcc_ou
- bat_dcc_od
- bat_dcc_os
- bat_dcc_ou
- pam_dcc_od
- pam_dcc_os
- pam_dcc_ou
- ram_dcc_od
- ram_dcc_os
- ram_dcc_ou
- visual_acuity_other_dcc_od
- visual_acuity_other_dcc_os
- visual_acuity_other_dcc_ou
- visual_acuity_ncc_od
- visual_acuity_ncc_os
- visual_acuity_ncc_ou
- pinhole_ncc_od
- pinhole_ncc_os
- pinhole_ncc_ou
- glare_ncc_od
- glare_ncc_os
- glare_ncc_ou
- bat_ncc_od
- bat_ncc_os
- bat_ncc_ou
- pam_ncc_od
- pam_ncc_os
- pam_ncc_ou
- ram_ncc_od
- ram_ncc_os
- ram_ncc_ou
- visual_acuity_other_ncc_od
- visual_acuity_other_ncc_os
- visual_acuity_other_ncc_ou
- movement_od
- movement_os
- centration_od
- centration_os
- vision_od
- vision_os
- comfort_od
- comfort_os
- torics_right_od
- torics_right_os
- torics_rotated_right_od
- torics_rotated_right_os
- torics_rotated_left_od
- torics_rotated_left_os
- or_sphere_od
- or_sphere_os
- or_cylinder_od
- or_cylinder_os
- or_axis_od
- or_axis_os
- or_visual_acuity_dcc_od
- or_visual_acuity_dcc_os
- or_visual_acuity_dcc_ou
- or_visual_acuity_ncc_od
- or_visual_acuity_ncc_os
- or_visual_acuity_ncc_ou
- firm_global_id
cover_test
Cover-Uncover and Alternate Cover motility tests. One entry per test, zero or more entries per visit.
- cover_test_id
- motility_id
- patient_id
- near_horizontal_defect
- near_horizontal_defect_eye
- near_horizontal_defect_amount
- near_vertical_defect
- near_vertical_defect_eye
- near_vertical_defect_amount
- distance_horizontal_defect
- distance_horizontal_defect_eye
- distance_horizontal_defect_amount
- distance_vertical_defect
- distance_vertical_defect_eye
- distance_vertical_defect_amount
- top_right_horizontal_defect
- top_right_horizontal_defect_eye
- top_right_horizontal_defect_amount
- top_right_vertical_defect
- top_right_vertical_defect_eye
- top_right_vertical_defect_amount
- top_center_horizontal_defect
- top_center_horizontal_defect_eye
- top_center_horizontal_defect_amount
- top_center_vertical_defect
- top_center_vertical_defect_eye
- top_center_vertical_defect_amount
- top_left_horizontal_defect
- top_left_horizontal_defect_eye
- top_left_horizontal_defect_amount
- top_left_vertical_defect
- top_left_vertical_defect_eye
- top_left_vertical_defect_amount
- tilt_right_horizontal_defect
- tilt_right_horizontal_defect_eye
- tilt_right_horizontal_defect_amount
- tilt_right_vertical_defect
- tilt_right_vertical_defect_eye
- tilt_right_vertical_defect_amount
- middle_right_horizontal_defect
- middle_right_horizontal_defect_eye
- middle_right_horizontal_defect_amount
- middle_right_vertical_defect
- middle_right_vertical_defect_eye
- middle_right_vertical_defect_amount
- middle_center_horizontal_defect
- middle_center_horizontal_defect_eye
- middle_center_horizontal_defect_amount
- middle_center_vertical_defect
- middle_center_vertical_defect_eye
- middle_center_vertical_defect_amount
- middle_left_horizontal_defect
- middle_left_horizontal_defect_eye
- middle_left_horizontal_defect_amount
- middle_left_vertical_defect
- middle_left_vertical_defect_eye
- middle_left_vertical_defect_amount
- tilt_left_horizontal_defect
- tilt_left_horizontal_defect_eye
- tilt_left_horizontal_defect_amount
- tilt_left_vertical_defect
- tilt_left_vertical_defect_eye
- tilt_left_vertical_defect_amount
- bottom_right_horizontal_defect
- bottom_right_horizontal_defect_eye
- bottom_right_horizontal_defect_amount
- bottom_right_vertical_defect
- bottom_right_vertical_defect_eye
- bottom_right_vertical_defect_amount
- bottom_center_horizontal_defect
- bottom_center_horizontal_defect_eye
- bottom_center_horizontal_defect_amount
- bottom_center_vertical_defect
- bottom_center_vertical_defect_eye
- bottom_center_vertical_defect_amount
- bottom_left_horizontal_defect
- bottom_left_horizontal_defect_eye
- bottom_left_horizontal_defect_amount
- bottom_left_vertical_defect
- bottom_left_vertical_defect_eye
- bottom_left_vertical_defect_amount
- firm_global_id
diagnostic_drops
Dilation performed during the eye exam. One entry per eye/dilation, zero or more entries per visit.
- diagnostic_drops_id
- visit_id
- patient_id
- date_recorded
- counsel_od
- counsel_os
- tropicamide_1_phenylephrine_2_5_od
- tropicamide_1_phenylephrine_2_5_os
- atropine_1_od
- atropine_1_os
- cyclopentolate_0_5_od
- cyclopentolate_0_5_os
- cyclopentolate_1_od
- cyclopentolate_1_os
- cyclopentolate_2_od
- cyclopentolate_2_os
- homatropine_5_od
- homatropine_5_os
- apraclonidine_1_od
- apraclonidine_1_os
- isopto_hyoscine_0_25_od
- isopto_hyoscine_0_25_os
- phenylephrine_10_od
- phenylephrine_10_os
- phenylephrine_2_5_od
- phenylephrine_2_5_os
- scopolamine_0_25_od
- scopolamine_0_25_os
- tropicamide_0_5_od
- tropicamide_0_5_os
- tropicamide_1_od
- tropicamide_1_os
- cyclomydril_od
- cyclomydril_os
- tropicamide_0_5_phenylephrine_2_5_od
- tropicamide_0_5_phenylephrine_2_5_os
- tropicamide_1_phenylephrine_10_od
- tropicamide_1_phenylephrine_10_os
- mydriacyl_neosynephrine_od
- mydriacyl_neosynephrine_os
- mydriacyl_od
- mydriacyl_os
- paremyd_od
- paremyd_os
- fluress_od
- fluress_os
- pilocarpine_1_od
- pilocarpine_1_os
- pilocarpine_2_od
- pilocarpine_2_os
- pilocarpine_4_od
- pilocarpine_4_os
- proparacaine_0_5_od
- proparacaine_0_5_os
- sodium_fluorescein_od
- sodium_fluorescein_os
- tetracaine_0_5_od
- tetracaine_0_5_os
- other_od
- other_os
- firm_global_id
duction
Ductions and versions of motility tests. One entry per duction test, zero or more entries per visit.
- duction_id
- motility_id
- patient_id
- top_left_od
- top_left_os
- top_right_od
- top_right_os
- middle_left_od
- middle_left_os
- middle_right_od
- middle_right_os
- bottom_left_od
- bottom_left_os
- bottom_right_od
- bottom_right_os
- firm_global_id
endothelial_counts
Endothelial cell counts. One entry per test, zero or one entry per visit.
- endothelial_counts_id
- visit_id
- patient_id
- count_od
- count_os
- firm_global_id
infant_vision
Infant vision recorded using the CSM method. One entry for each visit.
- infant_vision_id
- visit_id
- patient_id
- corneal_light_reflex_od
- corneal_light_reflex_os
- steadiness_od
- steadiness_os
- maintains_alignment_od
- maintains_alignment_os
- other_od
- other_os
- firm_global_id
iop
Intraocular pressure (IOP) reading. One entry per eye/reading, zero or more entries per visit.
- iop_id
- visit_id
- patient_id
- date_recorded
- eye
- method
- measurement
- measurement_selection
- reliability
- firm_global_id
keratometry
Indicate keratometry reading(s) were taken during the eye exam. Zero or one entry per visit.
- keratometry_id
- visit_id
- patient_id
- notes
- firm_global_id
keratometry_reading
Keratometry reading for a specific eye. One row per reading, zero or more entries per visit.
- keratometry_reading_id
- keratometry_id
- patient_id
- position
- date_recorded_od
- date_recorded_os
- flat_od
- flat_os
- flat_axis_od
- flat_axis_os
- steep_od
- steep_os
- steep_axis_od
- steep_axis_os
- mires_quality_od
- mires_quality_os
- method_od
- method_os
- firm_global_id
light_reflex
Light Reflex motility tests. One entry per test, zero or more entries per visit.
- light_reflex_id
- motility_id
- patient_id
- date_recorded
- correction
- working_distance
- fixation
- prism
- reflex_prism
- with_lens
- post_occlusion
- hirschberg_amount
- hirschberg_defect
- hirschberg_eye
- krimsky_amount
- krimsky_defect
- krimsky_eye
- firm_global_id
motility
Motility result. Zero or one entry per visit.
- motility_id
- visit_id
- patient_id
- result
- other
- firm_global_id
pachymetry
Corneal pachymetry thickness. One entry per test, zero or one entry per visit.
- pachymetry_id
- visit_id
- patient_id
- central_cornea_od
- central_cornea_os
- superior_cornea_od
- superior_cornea_os
- nasal_cornea_od
- nasal_cornea_os
- inferior_cornea_od
- inferior_cornea_os
- temporal_cornea_od
- temporal_cornea_os
- firm_global_id
pupil
Pupil exam. Zero or one entry per visit.
- pupil_id
- visit_id
- patient_id
- result
- light_od
- light_os
- dark_od
- dark_os
- near_od
- near_os
- size_od
- size_os
- round_od
- round_os
- regular_od
- regular_os
- reacts_od
- reacts_os
- apd_od
- apd_os
- rapd_od
- rapd_os
- other_od
- other_os
- firm_global_id
refraction
Refraction taken during the eye exam (ARx, MRx, CRx). Includes visual acuity with the refraction. One or more entries for each refraction.
- refraction_id
- visit_id
- patient_id
- date_recorded
- refraction_type
- eyeglass_usage
- pd_distance_ou
- pd_near_ou
- reading_distance
- notes
- print_notes
- underlying_condition_od
- underlying_condition_os
- sphere_od
- sphere_os
- cylinder_od
- cylinder_os
- axis_od
- axis_os
- add_od
- add_os
- horizontal_prism_od
- horizontal_prism_os
- horizontal_base_od
- horizontal_base_os
- vertical_prism_od
- vertical_prism_os
- vertical_base_od
- vertical_base_os
- slab_off_od
- slab_off_os
- vertex_distance_od
- vertex_distance_os
- pd_distance_od
- pd_distance_os
- pd_near_od
- pd_near_os
- refraction_other_od
- refraction_other_os
- visual_acuity_dcc_od
- visual_acuity_dcc_os
- visual_acuity_dcc_ou
- pinhole_dcc_od
- pinhole_dcc_os
- pinhole_dcc_ou
- glare_dcc_od
- glare_dcc_os
- glare_dcc_ou
- bat_dcc_od
- bat_dcc_os
- bat_dcc_ou
- pam_dcc_od
- pam_dcc_os
- pam_dcc_ou
- ram_dcc_od
- ram_dcc_os
- ram_dcc_ou
- visual_acuity_other_dcc_od
- visual_acuity_other_dcc_os
- visual_acuity_other_dcc_ou
- visual_acuity_ncc_od
- visual_acuity_ncc_os
- visual_acuity_ncc_ou
- pinhole_ncc_od
- pinhole_ncc_os
- pinhole_ncc_ou
- glare_ncc_od
- glare_ncc_os
- glare_ncc_ou
- bat_ncc_od
- bat_ncc_os
- bat_ncc_ou
- pam_ncc_od
- pam_ncc_os
- pam_ncc_ou
- ram_ncc_od
- ram_ncc_os
- ram_ncc_ou
- visual_acuity_other_ncc_od
- visual_acuity_other_ncc_os
- visual_acuity_other_ncc_ou
- firm_global_id
rgp_contacts_trial
RGP/Hybrid contact lens trials given during the eye exam. Includes visual acuity with the contacts. One entry for each trial.
- rgp_contacts_trial_id
- visit_id
- patient_id
- date_recorded
- wearing_schedule
- disinfecting
- dot
- contacts_usage
- status
- notes
- print_notes
- lens_manufacturer_od
- lens_manufacturer_os
- lens_product_od
- lens_product_os
- manual_lens_manufacturer_od
- manual_lens_manufacturer_os
- manual_lens_product_od
- manual_lens_product_os
- underlying_condition_od
- underlying_condition_os
- rgp_type_od
- rgp_type_os
- manual_rgp_type_od
- manual_rgp_type_os
- base_curve_1_od
- base_curve_1_os
- base_curve_2_od
- base_curve_2_os
- diameter_od
- diameter_os
- sphere_1_od
- sphere_1_os
- sphere_2_od
- sphere_2_os
- cylinder_1_od
- cylinder_1_os
- cylinder_2_od
- cylinder_2_os
- axis_1_od
- axis_1_os
- axis_2_od
- axis_2_os
- pcr_1_od
- pcr_1_os
- pcw_1_od
- pcw_1_os
- pcr_2_od
- pcr_2_os
- pcw_2_od
- pcw_2_os
- pcr_3_od
- pcr_3_os
- pcw_3_od
- pcw_3_os
- add_od
- add_os
- prism_od
- prism_os
- center_thickness_od
- center_thickness_os
- edge_thickness_od
- edge_thickness_os
- optical_zone_od
- optical_zone_os
- segment_height_od
- segment_height_os
- blend_od
- blend_os
- material_od
- material_os
- tint_od
- tint_os
- visual_acuity_dcc_od
- visual_acuity_dcc_os
- visual_acuity_dcc_ou
- visual_acuity_ncc_od
- visual_acuity_ncc_os
- visual_acuity_ncc_ou
- movement_od
- movement_os
- centration_od
- centration_os
- vision_od
- vision_os
- comfort_od
- comfort_os
- torics_right_od
- torics_right_os
- torics_rotated_right_od
- torics_rotated_right_os
- torics_rotated_left_od
- torics_rotated_left_os
- or_sphere_od
- or_sphere_os
- or_cylinder_od
- or_cylinder_os
- or_axis_od
- or_axis_os
- or_visual_acuity_dcc_od
- or_visual_acuity_dcc_os
- or_visual_acuity_ncc_od
- or_visual_acuity_ncc_os
- firm_global_id
rnfl_thickness
Retinal nerve fiber layer thickness. One entry per test, zero or one entry per visit.
- rnfl_thickness_id
- visit_id
- patient_id
- rnfl_thickness_od
- rnfl_thickness_os
- firm_global_id
visual_acuity
Visual acuity sets. Distance corrected (Dcc), near corrected (Ncc), distance uncorrected (Dsc), and near uncorrected (Nsc) can be recorded in each set. One or more entries per visual acuity set.
Visual acuities measured from wearing (WRx) tables get copied into this table, but are not linked. If visual acuity is edited the change does not occur to the source wearing table.
- visual_acuity_id
- visit_id
- patient_id
- date_recorded
- distance_test_type
- near_test_type
- distance_correction_type
- near_correction_type
- visual_acuity_dcc_od
- visual_acuity_dcc_os
- visual_acuity_dcc_ou
- pinhole_dcc_od
- pinhole_dcc_os
- pinhole_dcc_ou
- glare_dcc_od
- glare_dcc_os
- glare_dcc_ou
- bat_dcc_od
- bat_dcc_os
- bat_dcc_ou
- pam_dcc_od
- pam_dcc_os
- pam_dcc_ou
- ram_dcc_od
- ram_dcc_os
- ram_dcc_ou
- visual_acuity_other_dcc_od
- visual_acuity_other_dcc_os
- visual_acuity_other_dcc_ou
- visual_acuity_ncc_od
- visual_acuity_ncc_os
- visual_acuity_ncc_ou
- pinhole_ncc_od
- pinhole_ncc_os
- pinhole_ncc_ou
- glare_ncc_od
- glare_ncc_os
- glare_ncc_ou
- bat_ncc_od
- bat_ncc_os
- bat_ncc_ou
- pam_ncc_od
- pam_ncc_os
- pam_ncc_ou
- ram_ncc_od
- ram_ncc_os
- ram_ncc_ou
- visual_acuity_other_ncc_od
- visual_acuity_other_ncc_os
- visual_acuity_other_ncc_ou
- visual_acuity_dsc_od
- visual_acuity_dsc_os
- visual_acuity_dsc_ou
- pinhole_dsc_od
- pinhole_dsc_os
- pinhole_dsc_ou
- glare_dsc_od
- glare_dsc_os
- glare_dsc_ou
- bat_dsc_od
- bat_dsc_os
- bat_dsc_ou
- pam_dsc_od
- pam_dsc_os
- pam_dsc_ou
- ram_dsc_od
- ram_dsc_os
- ram_dsc_ou
- visual_acuity_other_dsc_od
- visual_acuity_other_dsc_os
- visual_acuity_other_dsc_ou
- visual_acuity_nsc_od
- visual_acuity_nsc_os
- visual_acuity_nsc_ou
- pinhole_nsc_od
- pinhole_nsc_os
- pinhole_nsc_ou
- glare_nsc_od
- glare_nsc_os
- glare_nsc_ou
- bat_nsc_od
- bat_nsc_os
- bat_nsc_ou
- pam_nsc_od
- pam_nsc_os
- pam_nsc_ou
- ram_nsc_od
- ram_nsc_os
- ram_nsc_ou
- visual_acuity_other_nsc_od
- visual_acuity_other_nsc_os
- visual_acuity_other_nsc_ou
- firm_global_id
visual_field
Visual Fields test. One entry per test, zero or one entry per visit.
- visual_field_id
- visit_id
- patient_id
- test_type
- test_other
- result
- additional_notes
- top_left_outer_od
- top_left_outer_os
- top_left_inner_od
- top_left_inner_os
- top_right_outer_od
- top_right_outer_os
- top_right_inner_od
- top_right_inner_os
- bottom_left_outer_od
- bottom_left_outer_os
- bottom_left_inner_od
- bottom_left_inner_os
- bottom_right_outer_od
- bottom_right_outer_os
- bottom_right_inner_od
- bottom_right_inner_os
- firm_global_id
wearing_contacts
Contact lenses the patient is wearing when presenting for the visit (WRx). Includes visual acuity with the contacts. One or more entries for each prescription.
- wearing_contacts_id
- visit_id
- patient_id
- date_recorded
- bifocal
- monovision
- toric
- contacts_option_other
- contacts_option_other_value
- contacts_usage
- status
- wearing_schedule
- replenishment
- disinfecting
- notes
- expiration_date_od
- expiration_date_os
- lens_manufacturer_od
- lens_manufacturer_os
- lens_brand_od
- lens_brand_os
- lens_color_od
- lens_color_os
- start_date_od
- start_date_os
- base_curve_od
- base_curve_os
- diameter_od
- diameter_os
- underlying_condition_od
- underlying_condition_os
- sphere_od
- sphere_os
- cylinder_od
- cylinder_os
- axis_od
- axis_os
- add_od
- add_os
- refraction_other_od
- refraction_other_os
- visual_acuity_dcc_od
- visual_acuity_dcc_os
- visual_acuity_dcc_ou
- pinhole_dcc_od
- pinhole_dcc_os
- pinhole_dcc_ou
- glare_dcc_od
- glare_dcc_os
- glare_dcc_ou
- bat_dcc_od
- bat_dcc_os
- bat_dcc_ou
- pam_dcc_od
- pam_dcc_os
- pam_dcc_ou
- ram_dcc_od
- ram_dcc_os
- ram_dcc_ou
- visual_acuity_other_dcc_od
- visual_acuity_other_dcc_os
- visual_acuity_other_dcc_ou
- visual_acuity_ncc_od
- visual_acuity_ncc_os
- visual_acuity_ncc_ou
- pinhole_ncc_od
- pinhole_ncc_os
- pinhole_ncc_ou
- glare_ncc_od
- glare_ncc_os
- glare_ncc_ou
- bat_ncc_od
- bat_ncc_os
- bat_ncc_ou
- pam_ncc_od
- pam_ncc_os
- pam_ncc_ou
- ram_ncc_od
- ram_ncc_os
- ram_ncc_ou
- visual_acuity_other_ncc_od
- visual_acuity_other_ncc_os
- visual_acuity_other_ncc_ou
- movement_od
- movement_os
- centration_od
- centration_os
- vision_od
- vision_os
- comfort_od
- comfort_os
- torics_right_od
- torics_right_os
- torics_rotated_right_od
- torics_rotated_right_os
- torics_rotated_left_od
- torics_rotated_left_os
- or_sphere_od
- or_sphere_os
- or_cylinder_od
- or_cylinder_os
- or_axis_od
- or_axis_os
- or_visual_acuity_dcc_od
- or_visual_acuity_dcc_os
- or_visual_acuity_dcc_ou
- or_visual_acuity_ncc_od
- or_visual_acuity_ncc_os
- or_visual_acuity_ncc_ou
- firm_global_id
wearing_glasses
Glasses the patient is wearing when presenting for the visit (WRx). Includes visual acuity with the glasses. One or more entries for each prescription.
- wearing_glasses_id
- visit_id
- patient_id
- date_recorded
- eyeglass_type
- eyeglass_usage
- anti_reflective_coating
- hi_index_lenses
- polarized
- polycarbonate
- scratch_coating
- slab_off
- sunglasses
- transition_lenses
- uv_coating
- eyeglass_option_other
- pd_distance_ou
- pd_near_ou
- notes
- underlying_condition_od
- underlying_condition_os
- sphere_od
- sphere_os
- cylinder_od
- cylinder_os
- axis_od
- axis_os
- add_od
- add_os
- horizontal_prism_od
- horizontal_prism_os
- horizontal_base_od
- horizontal_base_os
- vertical_prism_od
- vertical_prism_os
- vertical_base_od
- vertical_base_os
- slab_off_od
- slab_off_os
- vertex_distance_od
- vertex_distance_os
- pd_distance_od
- pd_distance_os
- pd_near_od
- pd_near_os
- refraction_other_od
- refraction_other_os
- visual_acuity_dcc_od
- visual_acuity_dcc_os
- visual_acuity_dcc_ou
- pinhole_dcc_od
- pinhole_dcc_os
- pinhole_dcc_ou
- glare_dcc_od
- glare_dcc_os
- glare_dcc_ou
- bat_dcc_od
- bat_dcc_os
- bat_dcc_ou
- pam_dcc_od
- pam_dcc_os
- pam_dcc_ou
- ram_dcc_od
- ram_dcc_os
- ram_dcc_ou
- visual_acuity_other_dcc_od
- visual_acuity_other_dcc_os
- visual_acuity_other_dcc_ou
- visual_acuity_ncc_od
- visual_acuity_ncc_os
- visual_acuity_ncc_ou
- pinhole_ncc_od
- pinhole_ncc_os
- pinhole_ncc_ou
- glare_ncc_od
- glare_ncc_os
- glare_ncc_ou
- bat_ncc_od
- bat_ncc_os
- bat_ncc_ou
- pam_ncc_od
- pam_ncc_os
- pam_ncc_ou
- ram_ncc_od
- ram_ncc_os
- ram_ncc_ou
- visual_acuity_other_ncc_od
- visual_acuity_other_ncc_os
- visual_acuity_other_ncc_ou
- firm_global_id
wearing_rgp_contacts
RGP/Hybrid contact lenses the patient is wearing when presenting for the visit (WRx). Includes visual acuity with the contacts. One or more entries for each prescription.
- wearing_rgp_contacts_id
- visit_id
- patient_id
- date_recorded
- wearing_schedule
- disinfecting
- dot
- contacts_usage
- status
- notes
- lens_manufacturer_od
- lens_manufacturer_os
- lens_product_od
- lens_product_os
- manual_lens_manufacturer_od
- manual_lens_manufacturer_os
- manual_lens_product_od
- manual_lens_product_os
- underlying_condition_od
- underlying_condition_os
- rgp_type_od
- rgp_type_os
- manual_rgp_type_od
- manual_rgp_type_os
- base_curve_1_od
- base_curve_1_os
- base_curve_2_od
- base_curve_2_os
- diameter_od
- diameter_os
- sphere_1_od
- sphere_1_os
- sphere_2_od
- sphere_2_os
- cylinder_1_od
- cylinder_1_os
- cylinder_2_od
- cylinder_2_os
- axis_1_od
- axis_1_os
- axis_2_od
- axis_2_os
- pcr_1_od
- pcr_1_os
- pcw_1_od
- pcw_1_os
- pcr_2_od
- pcr_2_os
- pcw_2_od
- pcw_2_os
- pcr_3_od
- pcr_3_os
- pcw_3_od
- pcw_3_os
- add_od
- add_os
- prism_od
- prism_os
- center_thickness_od
- center_thickness_os
- edge_thickness_od
- edge_thickness_os
- optical_zone_od
- optical_zone_os
- segment_height_od
- segment_height_os
- blend_od
- blend_os
- material_od
- material_os
- tint_od
- tint_os
- visual_acuity_dcc_od
- visual_acuity_dcc_os
- visual_acuity_dcc_ou
- visual_acuity_ncc_od
- visual_acuity_ncc_os
- visual_acuity_ncc_ou
- movement_od
- movement_os
- centration_od
- centration_os
- vision_od
- vision_os
- comfort_od
- comfort_os
- torics_right_od
- torics_right_os
- torics_rotated_right_od
- torics_rotated_right_os
- torics_rotated_left_od
- torics_rotated_left_os
- or_sphere_od
- or_sphere_os
- or_cylinder_od
- or_cylinder_os
- or_axis_od
- or_axis_os
- or_visual_acuity_dcc_od
- or_visual_acuity_dcc_os
- or_visual_acuity_ncc_od
- or_visual_acuity_ncc_os
- firm_global_id