Lab
This section includes data related to electronic lab orders and results.
elab_order
Outbound lab order. Includes all lab types (clinical, pathology, and radiology). There can be multiple tests in one order (see lab_order_test). One row per order.
- elab_order_id
- visit_id
- staff_id
- patient_id
- lab_id
- lab_facility_id
- order_number
- lab_order_number
- billing_type
- lab_type
- workflow_status
- firm_global_id
elab_order_test
Test for an outbound lab order. There can be multiple tests in one order. One row per order/test.
- elab_order_test_id
- elab_order_id
- patient_id
- diagnosis_id
- pathology_log_id
- universal_service_id
- filler_field_1
- loinc
- lab_compendium_code
- test_number
- relevant_clinical_information
- specimen_source
- reason_for_study
- status
- firm_global_id
elab_result
Inbound lab results. Includes ALL results, including unassigned and unsolicited results. There can be multiple results for one order or test (see order_number and test_number). One row per result.
- elab_result_id
- elab_order_id
- elab_order_test_id
- patient_id
- assigned_by_id
- pathology_log_id
- date_received
- universal_service_id
- filler_order_number
- loinc
- lab_compendium_code
- test_number
- relevant_clinical_information
- specimen_source
- reason_for_study
- status
- date_assigned
- auto_assigned
- active
- firm_global_id
lab_attachment
Lab attachments associated with lab requests or lab results.
- lab_attachment_id
- lab_request_id
- lab_result_id
- patient_id
- created_by_staff_id
- result_signed_by_staff_id
- result_signed_by_staff_secondary_id
- filename
- source
- result_signed_date
- result_signed_date_secondary
- firm_global_id
lab_note
Notes that are created and viewed across all lab specific fields. Can be created within a request for labs or viewed when reviewing lab requests, results, orders and attachments.
- lab_note_id
- elab_order_id
- lab_request_id
- lab_result_id
- lab_attachment_id
- patient_id
- lab_note
- sequence_number
- source
- type
- firm_global_id
lab_request
Contains lab/path requests.
- lab_request_id
- elab_order_id
- patient_id
- pathology_log_id
- result_status
- test_number
- filler_order_number
- universal_service_number
- relevant_clinical_information
- ordering_provider
- reason_for_study
- active
- observation_date
- date_received
- date_assigned
- firm_global_id
lab_result
Contains lab results.
- lab_result_id
- lab_request_id
- patient_id
- lab_note_id
- observation_identifier
- observation_sub_id
- observation_value
- observation_result_status
- observation_datetime
- date_performed
- analysis_datetime
- performing_organization_name
- performing_organization_address
- performing_organization_medical_director
- lab_result_note
- sequence_number
- source
- type
- firm_global_id
order_log
Contains metadata associated with the patient's orders.
- order_log_id
- firm_id
- visit_id
- facility_id
- provider_id
- patient_id
- patient_case_id
- elab_order_id
- procedure_id
- insurance_policy_id
- order_number
- order_name
- order_details
- priority
- provider_name
- facility_name
- perform_at_name
- order_type
- order_sub_type
- order_status
- order_date
- order_due_date
- order_scheduled_date
- firm_global_id
order_log_attachment
Metadata about file attachments associated with patient's orders.
- order_log_attachment_id
- order_log_id
- file_attachment_id
- facility_id
- patient_id
- firm_global_id
order_log_detail
Flexible metadata values associated with patient's orders.
- order_log_detail_id
- order_log_id
- parent_order_log_detail_id
- patient_id
- order_type
- key
- title
- value
- grouping
- firm_global_id
order_log_detail_cpt_code
CPT codes associated to order_log_detail.
- order_log_detail_cpt_code_id
- order_log_detail_id
- order_log_id
- patient_id
- cpt_code
- firm_global_id
order_log_note
Notes associated with a patient's order.
- order_log_note_id
- order_log_id
- facility_id
- patient_id
- created_by_staff_id
- modified_by_staff_id
- note
- archived
- firm_global_id
result_log
Log of test result received and their status.
- result_log_id
- firm_id
- facility_id
- provider_id
- patient_id
- visit_id
- referral_institution_id
- elab_order_id
- elab_order_result_id
- file_attachment_id
- pathology_log_id
- pathology_group_identifier
- received_date
- visit_date
- collected_date
- performed_date
- type
- name
- flag
- diagnosis
- provider_name
- vendor_name
- status
- workflow_status
- sent_to_portal
- firm_global_id
result_log_attachment
Linking table for file attachments associated with a result.
- result_log_attachment_id
- result_log_id
- file_attachment_id
- firm_id
- facility_id
- patient_id
- firm_global_id
result_log_detail
Flexible metadata associated with a result.
- result_log_detail_id
- result_log_id
- patient_id
- order_log_id
- body_location_id
- result_name
- result_type
- body_part
- flag
- firm_global_id
result_log_detail_diagnosis
Diagnosis associated with a result_log_detail record.
- result_log_detail_diagnosis_id
- result_log_detail_id
- patient_id
- diagnosis_id
- diagnosis_name
- diagnosis_type
- firm_global_id
result_log_note
Notes associated with result_log records.
- result_log_note_id
- result_log_id
- firm_id
- facility_id
- patient_id
- created_by_staff_id
- modified_by_staff_id
- note
- archived
- firm_global_id
result_log_order
Linking table for results to orders.
- result_log_order_id
- result_log_id
- order_log_id
- patient_id
- firm_global_id
result_log_sub_detail
Additional details for results received.
- result_log_sub_detail_id
- result_log_detail_id
- patient_id
- body_location_id
- result_name
- result_type
- body_part
- flag
- firm_global_id