Data range

From SICDB Doc
Jump to navigation Jump to search

This table contains, amongst others, data about treatment or invasivities like central lines. Data in this table has a DataID, which refers to d_references.ReferenceGlobalID, a begin offset and an end offset.

Name Type Description Comment
id Integer Primary Key
CaseID Integer Case identifier
DataID Reference
Offset Integer Time in seconds from admission
OffsetEnd Integer Time in seconds from admission
Data Text May contain a json object containing additional data (i.e. endotracheal tube size, ...)

Note: The data field is currently null. It has nevertheless been included for further compatibility, as it is planned to fill this field in next incremental update, which is sheduled March 2023.