Document Management
This section is a log of file attachments, including those not assigned to the patient. Physical attachments are excluded.
fax_inbound
Inbound faxes. One row per inbound fax.
- fax_inbound_id
- fax_line_id
- file_attachment_id
- patient_id
- date_received
- pages
- csid
- transaction_id
- caller_id
- status
- phone_number
- firm_global_id
fax_management
One row per outbound fax. This table contains additional metadata associated with outbound faxes.
- fax_management_id
- patient_id
- visit_id
- fax_template_id
- created_by_staff_id
- released_by_staff_id
- file_name
- intro
- body
- ending
- include_antepartum_record
- include_body_diagram
- include_ccd
- include_ccr
- include_face_sheet
- include_hipaa_cover_sheet
- include_notes
- include_summary
- save_to_chart
- archived
- queued_date
- released_date
- archived_date
- firm_global_id
fax_outbound
Queued and sent outbound faxes. One row per outbound fax.
- fax_outbound_id
- fax_link_id
- fax_management_id
- fax_template_id
- queued_by_staff_id
- released_by_staff_id
- referral_contact_id
- referral_institution_id
- patient_id
- visit_id
- transaction_id
- date_queued
- date_released
- date_submitted
- date_sent
- recipient_type
- include_body_diagram
- include_ccd
- include_hipaa_cover_sheet
- include_notes
- include_summary
- include_ccr
- pages
- pages_sent
- status
- date_created
- firm_global_id
file_attachment
Log of file attachments, including those not assigned to a patient. One row per file. NOTE: file contents are not included in this table.
- file_attachment_id
- firm_id
- uploaded_by_staff_id
- uploaded_by_patient_id
- patient_id
- visit_id
- document_category_id
- document_firm_id
- diagnosis_id
- elab_order_id
- lab_request_id
- procedure_id
- procedure_body_location_id
- document_category
- title
- file_name
- file_type
- file_size
- document_status
- photo_permission
- file_exists_checked
- imported
- in_visit_note
- is_editable
- is_primary_photo
- visible
- added_on_date
- firm_global_id