Dilemma of presenting surgery non-standard data to OMOP model

@guy_livne @AntoineLamer

Surgery and anesthesia time information are stored in Observation table. Each time point is one record. Some of the concept_ids are:

40483133 Start time of procedure
40482217 Completion time of procedure
4171540 Anesthesia preparation time
4161949 Anesthesia start time
4160029 Anesthesia finish time
40480482 Time of induction of anesthesia
40483093 Time of establishment of adequate anesthesia
40483530 Time of discharge from post anesthesia care unit
40481318 Time of patient arrival to location for anesthesia
40482694 Time of patient arrival in post anesthesia care location
40483565 Time ready for discharge from post anesthesia care unit
40483182 Time of arrival of anesthesia care provider to anesthetizing location

After putting these information in Observation table, they will be linked up with the actual surgery in Procedure table via Fact_Relationship table. I have provided an example in here.

3 Likes