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.