Thirty days mortality

Terminology

Reports Aristotle Score Central database Fundamental diagnosis Outcome assigned to Primary procedure Small procedures

Report parameters

Thirty days mortality Hospital mortality Length of stay Basic Score

Data

Validation Validation rules Entry ratio Flow Verification Source data verification Selective entry Backup

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.

See also

• Hospital mortality