Difference between revisions of "Unitlog"

From SICDB Doc
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
==Table Description==
==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.
{{:Data Description Unitlog}}
 
== Raw Fields ==
 
{| class="wikitable"
|+ 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  || i.e. C)
|}

Latest revision as of 10:11, 1 November 2022

Table Description

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


Caption unitlog
Name Type Description
id Integer Primary Key
CaseID Integer
PatientID Integer
LogState Integer Internal Metavision value. Note that in this version of the dataset this is a raw unencoded value.
Offset Integer Time in seconds after admission
HospitalUnit Reference