Thirty days mortality
30-day mortality is defined in regard to a set of patients. Some of the reports use operations' properties for filtering operations. However, to calculate the mortality for those operation a set of patients must be determined. Read more about filtering patients by operation properties.
30-day mortality for given set of patients
Thirty Days Mortality is the fraction of patients that died within 30 days from the date of the first surgery.
For a each patient, thirty days mortality can be true or false. Condition for true is:
The difference between the earliest date of surgery and the date of death is less or equal to 30 days.
Example of patient history with false:
2000-01-01 birth 2000-01-15 operation 1 2000-02-12 operation 2 2000-03-01 death
Example of patient history with true:
2000-01-01 birth 2000-02-10 operation 1 2000-02-12 operation 2 2000-03-01 death
SQL code snippet for the thirty days mortality:
SELECT patient_id, CASE WHEN ( SELECT min(o1.date_of_surgery) FROM operation AS o1 WHERE o1.patient_id = p.patient_id ) - p.date_of_birth BETWEEN 0 AND 30 THEN 1 WHEN ( SELECT count(*) FROM operation AS o1 WHERE o1.patient_id = p.patient_id ) = 0 THEN NULL ELSE 0 END AS "m30f" FROM patient AS p ;
30-day mortality per procedure
For every raport that shows per-procedure mortality or Basic Score related mortality needs a different way of calculating mortality. The primary procedure must be elected for each patient. See the primary procedure election for details.