UseCase09 - Doctor Records Procedure Outcome

Initiating Actor - Doctor

Description

After performing a procedure, a doctor records the outcome. The system stores the procedure result and updates the performed procedure notes. The result becomes visible on the patient's medical record through the procedure's existing link to that record.

Scenario

1. Doctor navigates to pending procedures for a patient.

SELECT
  pp.performed_id,
  pr.procedure_type,
  pr.description,
  pp.procedure_date,
  pp.notes
FROM performed_procedures pp
JOIN procedures pr ON pp.procedure_id = pr.procedure_id
WHERE pp.patient_id = (
SELECT patient_id 
FROM users 
WHERE username = 'maja.veljanova')
  AND pp.doctor_id = (
SELECT doctor_id 
FROM users 
WHERE username = 'elena.kirova');

2. Doctor selects a performed procedure to record the outcome for.

SELECT
  pp.performed_id,
  pr.procedure_type,
  pr.description,
  u_p.first_name AS patient_first_name,
  u_p.last_name AS patient_last_name,
  pp.procedure_date,
  pp.notes
FROM performed_procedures pp
JOIN procedures pr ON pp.procedure_id = pr.procedure_id
JOIN patients p ON pp.patient_id = p.patient_id
JOIN users u_p ON p.patient_id = u_p.patient_id
WHERE pp.performed_id = (
SELECT MAX(performed_id) 
FROM performed_procedures 
WHERE doctor_id = (
SELECT doctor_id 
FROM users 
WHERE username = 'elena.kirova'));

3. Doctor enters the outcome notes and submits.

UPDATE performed_procedures
SET notes = 'ECG completed successfully. Heart rhythm normal, no arrhythmias detected.'
WHERE performed_id = (SELECT MAX(performed_id) FROM performed_procedures
  WHERE doctor_id = (SELECT doctor_id FROM users WHERE username = 'elena.kirova'));

4. System stores the detailed procedure result.

INSERT INTO procedure_results (procedure_id, result_description, result_date)
VALUES (
  (SELECT procedure_id FROM procedures WHERE procedure_type = 'ECG'),
  'Normal sinus rhythm. Heart rate 72 bpm. No ST elevation.',
  '2026-06-10'
)
RETURNING result_id;

5. System confirms and displays all procedure results on the patient's medical record, using the existing link between the medical record and the procedure catalog entry.

SELECT
  p.procedure_type,
  pres.result_description,
  pres.result_date
FROM medical_record_procedures mrp
JOIN procedures p ON mrp.procedure_id = p.procedure_id
JOIN procedure_results pres ON pres.procedure_id = p.procedure_id
WHERE mrp.record_id = (
  SELECT record_id 
  FROM medical_records 
  WHERE patient_id = (
    SELECT patient_id 
    FROM users 
    WHERE username = 'maja.veljanova'
  )
);