Clinical records¶

The clinical table and lab table of the release: anaesthesia record, lab results, admission.

Stub

Imported from the time-source table; the full page is still to be written.


Type	other
Clocks	Hospital records clock

Variables¶

Variable	Type	Stamped by	Spaced by
Case end	event	Hospital records clock	—
Admission and discharge	event	Hospital records clock	—
Anaesthesia record events	event	Hospital records clock	—
Blood gas result time	event	Hospital records clock	—
Central lab result time	event	Hospital records clock	—

Observations¶

Observation	Status	Summary
Anaesthesia record times on 5-minute marks are rounded up	established	An anaesthesia start or end entered on a 5-minute mark was rounded up to it: the event happened in the 5 minutes before, and on average a little earlier still. Clear for anaesthesia end; for anaesthesia start the margin is small, and the value model (How the anesthesia start time was charted) prefers rounding to the nearest mark.
Op end was filled in from the recording end in 537 cases	established	In 537 cases (8.4%) the op end is exactly 10 minutes before the end of the recording, so it was filled in rather than charted. These cases are concentrated in thoracic surgery and under sedation or spinal anaesthesia.
The EMR clock's offset cannot be separated from documentation lag	established	Both routes between the EMR clock and the recorder run through the case start, so any EMR clock offset cancels. Without a time from outside the release it is confounded with how late entries are made.
The EVENT track repeats the clinical table	established	In 411 random cases the recorder EVENT track's four entries equal the clinical table's case start, operation start, operation end and case end exactly: the release generated them from the table.
The lab time is neither the draw nor the result	established	VitalDB's lab timestamp marks the specimen (logged at the lab, or entered from a theatre analyser): minutes after the draw and before the result, whose time is not recorded.
Some ICU stays are longer than the postoperative stay	likely	In 37 cases the ICU day count reaches or exceeds the days from surgery to discharge, though the release describes it as the postoperative ICU stay. Most are emergencies with long stays before surgery, so the count probably includes ICU days before the operation.
Three lab analytes stop at a reporting limit	likely	Lactate is capped at 15.0 mmol/L, aPTT at 400.0 s, and ESR does not go below 2 mm/h: the values at the limit stand for "this or beyond", not for the number itself.

Studies¶

Study	Date	Status	Summary
What the lab timestamp marks	2026-10-13	current	VitalDB's lab time is a per-specimen timestamp: not the draw, and not the result. Blood gases are stamped 3–12 minutes after the draw, central-lab panels about 8–24 minutes after it, and the result follows a turnaround the release does not record.
Closing loops in the timing graph	2026-10-13	current	Where two independent routes reach the same clock, the offsets around the loop must sum to zero. Three measured loops close within their noise; the BIS loop closes up to a constant latency; the proposed EMR loop is not a loop at all.
Recovering the time of day	2026-10-12	current	The release shifts every case to start at 2100-01-01 00:00 UTC, removing the date and the time of day. The time of day (Korean local time) can be recovered to the minute from the admission date and the seconds of the EMR times.
Anaesthesia record times are rounded up	2026-10-12	current	Anaesthesia start and end entered on a 5-minute mark sit 90–290 s later, against device markers, than entries typed to the minute. Rounding up to the next 5 minutes fits every one of 11 markers better than rounding to the nearest or down.
Arterial line accesses in the pressure waveform	2026-10-11	current	Flushes, zeroing and blood draws leave clear signatures in the arterial pressure. A detector finds them in the waveform alone (about one access per hour) and matches 77% of lab draws to an access within 15 minutes, against 26% for random times.

Tags: stub