Procedure
This section contains data related to procedures and plans in the Ocular Exam.
procedure
Procedure performed during a visit, associated with a diagnosis.
- procedure_id
- diagnosis_id
- patient_id
- procedure_alias
- procedure_name
- firm_global_id
procedure_body_location
One or more body locations associated with a procedure. Body locations are selected using a pre-defined anatomical atlas.
- procedure_body_location_id
- procedure_id
- patient_id
- body_part
- simple_description
- detail_description
- zone
- firm_global_id
procedure_metadata
Additional data recorded for each procedure. May be recorded for the procedure as a whole or for a specific body location. Records all questions, single-input, and single-select responses. Due to processing time requirements this table is refreshed weekly on Saturday.
- procedure_metadata_id
- procedure_body_location_id
- procedure_id
- patient_id
- variable
- question_text
- type
- value
- range_value
- firm_global_id
procedure_mips_quality
Responses for the MIPS Quality plan. One row per plan/question/response. Due to processing time requirements this table is refreshed weekly on Saturday.
- procedure_mips_quality_id
- procedure_id
- patient_id
- tab_label
- question_text
- value
- text_value
- firm_global_id