Prescription
This section includes data related toglasses, contact lens, and medication prescriptions.
contacts_rx
Contact lens prescriptions. One entry for each prescription, zero or more entries per patient. Linked to visit if the prescription was written as part of a visit.
- contacts_rx_id
- patient_id
- provider_id
- facility_id
- visit_id
- date_recorded
- active
- contacts_usage
- status
- notes
- print_notes
- fitting_type
- wearing_schedule
- replenishment
- disinfecting
- underlying_condition_od
- underlying_condition_os
- start_date_od
- start_date_os
- expiration_date_od
- expiration_date_os
- lens_manufacturer_od
- lens_manufacturer_os
- lens_brand_od
- lens_brand_os
- base_curve_od
- base_curve_os
- diameter_od
- diameter_os
- sphere_od
- sphere_os
- cylinder_od
- cylinder_os
- axis_od
- axis_os
- add_od
- add_os
- lens_color_od
- lens_color_os
- quantity_od
- quantity_os
- visual_acuity_dcc_od
- visual_acuity_dcc_os
- visual_acuity_dcc_ou
- pinhole_dcc_od
- pinhole_dcc_os
- pinhole_dcc_ou
- visual_acuity_ncc_od
- visual_acuity_ncc_os
- visual_acuity_ncc_ou
- details_other_od
- details_other_os
- 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
glasses_rx
Eyeglass prescriptions. One entry for each prescription, zero or more entries per patient. Linked to visit if the prescription was written as part of a visit.
- glasses_rx_id
- patient_id
- provider_id
- facility_id
- visit_id
- date_recorded
- active
- eyeglass_usage
- underlying_condition_od
- underlying_condition_os
- sphere_od
- sphere_os
- cylinder_od
- cylinder_os
- axis_od
- axis_os
- add_od
- add_os
- visual_acuity_dcc_od
- visual_acuity_dcc_os
- visual_acuity_ncc_od
- visual_acuity_ncc_os
- pinhole_dcc_od
- pinhole_dcc_os
- start_date_od
- start_date_os
- expiration_date_od
- expiration_date_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
- pd_distance_od
- pd_distance_os
- pd_near_od
- pd_near_os
- prism_other_od
- prism_other_os
- seg_hgt_od
- seg_hgt_os
- oc_hgt_od
- oc_hgt_os
- dec_dist_od
- dec_dist_os
- inset_od
- inset_os
- total_dec_od
- total_dec_os
- pd_distance_ou
- pd_near_ou
- qp_uv400
- qp_anti_reflective
- qp_single_vision
- qp_bifocal
- qp_progressives
- qp_transition
- qp_polarized
- qp_sunglasses
- qp_slab_off
- qp_high_index
- qp_safety_lenses
- qp_other
- lens_style
- lens_style_other
- lens_material
- lens_material_other
- lens_coating
- lens_coating_other
- lens_tint
- lens_tint_other
- color
- color_solid
- color_gradient
- eye_size
- distance_between_lenses
- top_to_bottom
- effective_diameter
- lens_mirror
- lens_uv
- lens_uncut
- lens_safety
- lens_polish_edges
- lens_knife_edge
- lens_tap
- lens_options_other
- frame_name
- frame_manufacturer_name
- frame_color
- temple_length
- frame_zyi
- frame_metal
- frame_grooved
- frame_drilled
- frame_to_come
- frame_supply
- frame_edge_only
- frame_pattern_enclosed_only
- frame_circumference
- notes
- print_notes
- firm_global_id
rgp_contacts_rx
RGP/Hybrid contact lens prescriptions. One entry for each prescription, zero or more entries per patient. Linked to visit if the prescription was written as part of a visit.
- rgp_contacts_rx
rx
Prescriptions written from the application. A prescription can be written as part of a visit, or separate from a visit.
- rx_id
- patient_id
- written_by_id
- facility_id
- diagnosis_id
- compound_medication_id
- written_on_date
- drug_name
- short_name
- generic_name
- is_generic
- nametypecode
- medid
- ndc
- dose_form
- route
- strength
- strength_units
- quantity
- quantity_units
- refills
- dose
- frequency
- indication
- package_size
- package_type
- package_size_units
- sig
- note
- allow_substitutions
- status
- void_reason
- pharmacy_ncpdpid
- pharmacy_name
- pharmacy_npi
- days_supply
- dea_class
- location
- plan_payer_name
- rxn_term_type
- side_effects
- from_mobile
- prior_authorization_required
- earliest_fill_date
- firm_global_id