How to screen out the first ICU stay for a certain patient?

Open zheng523 opened this issue 3 months ago • 0 comments

In the document of the "patient" table, it says "There is no systematic method for chronologically ordering patientHealthSystemStayID for the same patient within the same year." But when I asked AI how to screen out the first ICU stay for a certain patient, it said that the database assigns a new, larger patienthealthsystemstayid for each new hospital stay for the same patient in the same year. Is this true?

Sep 04 '25 15:09 zheng523