Time inconsistencies in ed.edstays, ed.pyxis and hosp.prescriptions

I found some inconsistencies between the ED intime and pyxis charttime and prescription starttime. For some patients that went through ED, the charttime and starttime (from ed.pyxis and hosp.prescriptions respectively) are anterior to their registered intime in the Emergency Department (ed.edstays.intime).

I would like to get precise timings but I don't know which ones are more likely to be accurate or which ones are manually registered vs automatically registered.

Can you tell me how are registered these times ? Are there other (not too complicated) ways to determine which are trustworthy ?

Start with the definitions and data dictionaries for ed.edstays, ed.pyxis, and hosp.prescriptions, then review the MIMIC documentation for how intime, charttime, and starttime are recorded. Compare the documented timestamp provenance and known limitations. Done means the timing sources and practical trust guidance are clearly documented.