Lab
This section includes data related to electronic lab orders and results.
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
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
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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
Linking table for results to orders.
- result_log_order_id
- result_log_id
- order_log_id
- patient_id
- firm_global_id
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