Diagnosis

Individual finding/impression during a visit. May be multiple entries per visit. Does not indicate that this is the first time a patient is diagnosed with the condition. Each time a procedure is performed, a diagnosis must first be selected.

• diagnosis_id
• visit_id
• patient_id
• is_new
• is_ruleout
• diagnosis_name
• uncertain_diagnosis_name
• diagnosis_type
• diagnosis_status
• icd9
• icd10
• medical_domain
• firm_global_id

Associated diagnosis. One row per diagnosis/adx. Zero or more records per diagnosis.

• diagnosis_adx_id
• diagnosis_id
• patient_id
• diagnosis_name
• firm_global_id

One or more body locations associated with a diagnosis.

• diagnosis_body_location_id
• diagnosis_id
• patient_id
• body_part
• simple_description
• detail_description
• zone
• firm_global_id

One or more morphologies for the given diagnosis body location.

• diagnosis_body_location_morphology_id
• diagnosis_body_location_id
• patient_id
• morphology
• firm_global_id

Cause diagnosis. One row per diagnosis/cause dx. Zero or more records per diagnosis.

• diagnosis_cause_dx_id
• diagnosis_id
• patient_id
• diagnosis_name
• firm_global_id

Differential diagnosis. One row per diagnosis/ddx. Zero or more records per diagnosis.

• diagnosis_ddx_id
• diagnosis_id
• patient_id
• diagnosis_name
• firm_global_id

One or more measurements associated with a diagnosis. Measurements are defined and entered for each diagnosis.

• diagnosis_measurement_id
• diagnosis_id
• patient_id
• variable
• title
• question_text
• type
• value
• value_title
• firm_global_id

One or more morphologies for the given diagnosis.

• diagnosis_morphology_id
• diagnosis_id
• patient_id
• morphology
• firm_global_id

Referral as part of a diagnosis in the VE Room (Referral plan). This table records the provider and specialty that the patient is being referred to. One row per diagnosis/referral contact. NOTE: there will also be an entry in the procedure table with a procedure_name of Referral.

• diagnosis_referral_id
• diagnosis_id
• referral_contact_id
• patient_id
• specialty
• firm_global_id

Referral correspondence as part of a diagnosis in the VE Room (Referral Correspondence plan). This table records the provider and specialty the correspondence is sent to. One row per diagnosis/referral contact. NOTE: there will also be an entry in the procedure table with a procedure_name of Referral Correspondence.

• diagnosis_referral_correspondence_id
• diagnosis_id
• referral_contact_id
• patient_id
• specialty
• include_body_diagram
• include_ccd
• include_hipaa_cover_sheet
• include_notes
• include_summary
• firm_global_id