Skip to main content
. 2021 Oct 29;23(10):e29259. doi: 10.2196/29259

Table 4.

List of queries in the context of the operating room visits and hospital stays.

Query ID Query Requirement Query steps and queried tables
1 Number of operations per year and per specialty department Identify the visit to the operating room and the corresponding department

  • Identification of visits to the operating room with the new concept “operating room visit” (VISIT_DETAIL)

  • Relationship between care_site_id of the operating room and care_site_id of the department (CONCEPT_RELATIONSHIP, CONCEPT)
2 Anesthesia procedure during an outpatient visit Cross-check data from two sources: operating room (AIMSa) and hospital stay (PMSIb)

  • Identification of visits to the operating room with the new concept “operating room visit” (VISIT_DETAIL, VISIT_OCCURRENCE)
3 Operations with fast-track surgery and no admission to the PACUc Identify a specific period of the operation

  • Identification of visits to the operating room with the new concept “operating room visit” (VISIT_DETAIL)

  • Joining with PACU periods (PERIOD)
4 Operations with an MAPd<65 mm Hg within 30 minutes of inducing anesthesia Cross-check data from two secondarily computed, operation-specific periods

  • Period P1 of hypotension with MAP<65 mm Hg (PERIOD)

  • Period P2 of anesthesia (PERIOD)

  • Joining of P1 and P2 with the start date of P1 in 30 minutes following the start date of P2
5 Administration of norepinephrine, epinephrine, ephedrine, phenylephrine, dobutamine, or atropine received within 15 minutes of the first drop in MAP to below 65 mm Hg Cross-check data from a secondarily computed period and specific drug administrations

  • First period P1 of MAP<65 mm Hg (PERIOD)

  • Administration A of norepinephrine, epinephrine, ephedrine, phenyleprine, dobutamine, or atropine (DRUG_EXPOSURE)

  • Linking P1 and A with the start date and time of A in the 15 minutes following the start date of P1

  • Aggregation by drug
6 Length of stay by ASAe status Cross-check data from two sources: the operating room (AIMS) and hospital stay (PMSI)

  • Extraction of ASA status conditions (CONDITION_OCCURRENCE)

  • Linking of the operating room visit details to the visit occurrence (VISIT_OCCURRENCE)

  • Aggregation of the duration of visit occurrence by ASA status
7 Operations followed by a stay in the intensive care unit Cross-check data from two sources: operating room (AIMS) and hospital stay (PMSI)

  • Identification of visits to the operating room with the new concept “operating room visit” VD1f (VISIT_DETAIL)

  • Identification of visits to the intensive care unit VD2 (VISIT_DETAIL)

  • Linking VD1 to VD2 according to the visit_occurrence identifier and with VD2 start datetime>VD1 end datatime
8 Characterization of the Mallampati grade Query the preanesthesia consultation

  • Extraction of Mallampati scores (NOTE)

  • Aggregation by score

aAIMS: anesthesia information management system.

bPMSI: Programme de Médicalisation des Systèmes d’Information.

cPACU: postanesthesia care unit.

dMAP: mean arterial pressure.

eASA: American Society of Anesthesiologists.

fVD: visit detail.