Pathology
This section includes a log of biopsies and results.
cancer_log
Detailed information for cancerous and precancerous pathology results.
- cancer_log_id
- patient_id
- physician_id
- pathology_log_id
- refer_to_provider_id
- referred_from_provider_id
- entry_created_date
- entry_updated_date
- diagnosis
- diagnosis_snomed
- diagnosis_narrative
- diagnostic_confirmation
- location
- location_snomed
- laterality
- behavior
- biopsy_date
- diagnosis_date
- treatment_date
- treatment_method
- treated_by
- treatment_status
- progress_note
- clinical_stage
- clinical_tumor
- clinical_node
- clinical_metastasis
- tnm_date
- clinical_stage_descriptor
- tnm_edition
- clinical_staged_by
- pathology_stage
- pathology_tumor
- pathology_node
- pathology_metastasis
- pathology_stage_descriptor
- pathology_staged_by
- seer_summary_stage
- tumor_grade
- breslow_depth
- mitotic_index
- ulceration
- tils
- slnbx
- slnbx_comments
- radiation_oncology_note
- status
- firm_global_id
cancer_log_medication
Links medications from the medication list to a cancer log entry.
- cancer_log_medication_id
- cancer_log_id
- medication_id
- patient_id
- firm_global_id
cancer_log_pathology_treatmen t
Pathology log entries for excisions associated as a treatment for a cancer. One row per cancer log entry/pathology log entry.
- cancer_log_pathology_treatment_id
- cancer_log_id
- pathology_log_id
- patient_id
- firm_global_id
cancer_log_problem
Links problems from the problem list to a cancer log entry.
- cancer_log_problem_id
- cancer_log_id
- problem_list_id
- patient_id
- firm_global_id
cancer_log_procedure
Links procedures from the procedure log to a cancer log entry.
- cancer_log_procedure_id
- cancer_log_id
- procedure_log_id
- patient_id
- firm_global_id
cancer_log_visit
Cancer interval history.
- cancer_log_visit_id
- cancer_log_id
- visit_id
- patient_id
- history_selected
- history_status
- history_comments
- plan_selected
- exam
- plan
- plan_comments
- firm_global_id
pathology_log
Pathology specimen result log. Captures entries in all statuses - pending results, results received, and action plan completed.
- pathology_log_id
- patient_id
- physician_id
- visit_id
- result_entered_by_id
- procedure_body_location_id
- facility_id
- completed_by_id
- unresolved_by_id
- location
- procedure_name
- entry_created_date
- result_date
- unresolved_date
- cancer_type
- result
- comments
- action
- plan
- manual_result
- notes
- workflow
- pathology_group_identifier
- status
- visible
- firm_global_id
pathology_log_action
Action for a biopsy log entry. Zero or more actions per biopsy log entry.
- pathology_log_action_id
- pathology_log_id
- patient_id
- action
- firm_global_id
pathology_log_notification
Patient notification for a pathology log entry. Zero or more notifications per entry.
- pathology_log_notification_id
- pathology_log_id
- patient_id
- log_date_created
- template
- firm_global_id
pathology_log_plan
Plan for a biopsy log entry action. One or more plans per action.
- pathology_log_plan_id
- pathology_log_action_id
- patient_id
- plan
- firm_global_id