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 surgery.

For a each patient, thirty days mortality can be true or false. Condition for true is:

There is an operation for which the difference between date of surgery and date of death is less or equal to 30 days.

Example of patient history with true:

2000-01-01 birth
2000-01-15 operation 1
2000-02-12 operation 2
2000-03-01 death

Even though the first (main) operation was more than 30 days before patient's death, there exists a second (possibly trivial) operation after which the patient deceased.

SQL code snippet for the thirty days mortality:

SELECT ...
FROM patient AS p
WHERE EXISTS (
   SELECT TRUE
   FROM operation AS o
   WHERE p.patient_id = o.patient_id
   AND p.date_of_death - o.date_of_surgery BETWEEN 0 AND 30
)

See also

• Hospital mortality