All Sanford flowsheet data in the measurement table must be deleted. These records can be identified by the following SELECT statement:
SELECT * FROM measurement WHERE measurement_source_concept_id = 0 and measurement_concept_id != 0
many records (>80% of the table) are expected to be deleted.
All Sanford flowsheet data in the measurement table must be deleted. These records can be identified by the following SELECT statement:
many records (>80% of the table) are expected to be deleted.