Lab

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