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

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
;

See also

• Hospital mortality