Separation of date and time fields

From CCMDB Wiki

Revision as of 23:02, 23 October 2025 by Ttenbergen (talk | contribs) (→Reasons)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

This page explains why we encode date and time in separate fields for some values.

Reasons

our legacy PDA data collection tool implemented date and time as two separate fields
there are more convenient user interface elements in MS Access to enter the two separately (DatePicker tool / calendar)
they can easily be combined during analysis

values affected

L_Log.Start Date field / Start Date field / Start Date and Time
L TmpV2.obsdate and obstime
L TmpV2.date_var and time_var
original Admit date and time
original Transfer Ready date and time
original Discharge date and time

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Separation_of_date_and_time_fields&oldid=167838"

Data structure