Matching Provider order entry to the procedure_icd

[AndrejIring]

Hi, I would like to ask if it is possible to match the exact orders (from poe table) to the corresponding procedures from procedures_icd.

I would like to calculate the exact time from admission to the catheterization.

For example, for hadm_id 27993048, I can see catheterization was done (from procedures_icd and drgcodes), but I cannot locate the exact order for it in the poe. Therefore, I cannot calculate the exact time between admission and catheterization (since procedure_icd only contains date and not time).

Is there another way I could get this information?