mortality and mortality day

Prerequisites

https://github.com/MIT-LCP/mimic-code/blob/master/concepts/cookbook/mortality.sql

Description

admittime is accurate to the minute but dod is not.
subject_id = '8547' and hadm_id = '131849' and icustay_id = '200119'
admissions table admittime: 2173-06-29 01:50:00 dischtime: 2173-06-30 07:58:00 deathtime: 2173-06-30 07:58:00
icustays table intime: 2173-06-29 01:50:00 outtime: 2173-06-30 07:58:00
patients table dod/dod_hosp/dod_ssn: 2173-06-30 00:00:00
round(((date_part('epoch'::text, (ie.outtime - ie.intime)) / (((60 * 60) * 24))::double precision))::numeric, 4) AS los_icu,
round(((date_part('epoch'::text, (adm.dischtime - adm.admittime)) / (((60 * 60) * 24))::double precision))::numeric, 4) AS los_hospital,

when we use los_icu>2 exclude deceased patient，but patients table‘ dod/dod_hosp/dod_ssn may not accurate. How to exclude those people.

• what you have tried
• references to similar issues
• queries demonstrating your question (if applicable)

Start with concepts/cookbook/mortality.sql and inspect how the admissions, icustays, and patients tables are used for mortality and length-of-stay calculations. Reproduce the subject_id 8547, hadm_id 131849, and icustay_id 200119 timestamps, then establish a documented, reproducible rule for handling deceased patients whose date-of-death values lack time precision.