Practice

Patient assigned consent form table.

• consent_form_patient_id
• consent_form_id
• patient_id
• attachment_on_file
• declined
• expired
• processed_date
• expiration_date
• firm_global_id

Patient to Primary Care Provider mapping table.

• patient_primary_care_provider_id
• firm_id
• patient_id
• primary_care_provider_id
• primary_care_provider_name
• firm_global_id

Patient to Referring Provider mapping table.

• patient_referring_provider_id
• firm_id
• patient_id
• referring_provider_id
• referring_provider_name
• is_latest
• date_last_seen
• firm_global_id

Protocol usage log. One row per protocol usage.

• protocol_log_id
• visit_id
• patient_id
• protocol_id
• applied_by_id
• created_by_id
• date_applied
• firm_global_id

Patient referral sources link table. One row per referral transaction.

• referral_source_link_id
• patient_id
• referral_source_id
• firm_id
• referring_patient_id
• appointment_id
• visit_id
• bill_id
• referral_type_id
• created_by_staff_id
• primary_source
• referral_name
• referral_type
• referral_description
• built_in
• status
• firm_global_id

Each row logs changes to patients restricted status and when a staff member accesses a restricted patient chart or region.

• restricted_chart_event_log_id
• patient_id
• accessed_by_staff_id
• event_type
• reason
• event_start
• event_end
• firm_global_id

Visit to referring provider mapping table.

• visit_referral_id
• visit_id
• patient_id
• referring_provider_id
• is_latest
• firm_global_id