Surgery Start Date/Time

Search:

Description

This phenotype returns the documented date/time of procedure start for each case. One value per case.

Limitation

Sites must map to specific MPOG concepts to be identified by this phenotype. See logic section for concepts included in this phenotype.

This phenotype only results "observed" dates and times. "Observed" dates and times are those that are explicitly entered or documented in the record and must be documented as part of the note. MPOG will not default to the "time entered" to determine case start. "Time entered" reflects the time that the documentation was written, and not necessarily the time that care was provided.

Data quality is limited to individual site documentation accuracy, completeness, and variable mapping, which is performed by each site, independently. MPOG, as the coordinating center, reviews data quality at each data upload and monthly via Data Diagnostics and Case Validation tools. This review, while thorough, may not contain all data elements relevant to this phenotype and thus should be carefully reviewed by the user.

Value Type

Datetime

Enumeration

Value	Value Code	Definition

Return Columns

Column Name	Data Type

Granularity

Logic

This phenotype assesses the case for documentation mapped to Procedure Start Date/Time (MPOG Concept ID: 50006) and Surgical Incision Time (MPOG Concept ID: 50235), and returns the earliest date/time as long as the documentation was not deleted. Concepts between Anesthesia Start (MPOG Concept ID: 50002) and Anesthesia End (MPOG Concept ID:50009) are considered. If no procedure start or incision time is found between anesthesia start and anesthesia end, the phenotype will look for a procedure start or incision time documented within 1 hour before anesthesia start and then select the time closest to the anesthesia start time. If the procedure start or incision is not found, it will return NULL. Only the observed date/time will be used; entered time is not considered for this phenotype.