Difference between revisions of "Unitlog"

From SICDB Doc
Jump to navigation Jump to search
Line 19: Line 19:
| Offset || Time in seconds after admission ||  
| Offset || Time in seconds after admission ||  
|-
|-
| HospitalUnit || Encoded unit value, unitlog.HospitalUnit = d_references.ReferenceGlobalID  || i.e. C)
| HospitalUnit || Encoded unit value, unitlog.HospitalUnit = d_references.ReferenceGlobalID  ||  
|}
|}

Revision as of 12:04, 9 October 2022

Table Description

The d_unitlog table contains information of patient transportation. Note that in many cases Metavision creates multiple entries and this data is difficult to interpret.

Raw Fields

Caption unitlog
Name Description Comment
id Primary Key
CaseID
PatientID
LogState Internal raw Metavision value
Offset Time in seconds after admission
HospitalUnit Encoded unit value, unitlog.HospitalUnit = d_references.ReferenceGlobalID