Difference between revisions of "Data Description Unitlog"

From SICDB Doc
Jump to navigation Jump to search
(Created page with "The 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 == {| class="wikitable" |+ Caption unitlog |- ! Name !! Type !! Description !! Comment |- | id || Integer || Primary Key || |- | CaseID || Integer || || |- | PatientID || Integer || || |- | LogState || Integer || Internal Metavision value. Note that in this version of the dataset th...")
 
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
The unitlog table contains information of patient transportation. Note that in many cases Metavision creates multiple entries and this data is difficult to interpret.
The 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 ==


{| class="wikitable"
{| class="wikitable"
|+ Caption unitlog
|+ Caption unitlog
|-
|-
! Name !! Type !! Description !! Comment
! Name !! Type !! Description  
|-  
|-  
| id || Integer || Primary Key ||
| id || Integer || Primary Key  
|-
|-
| CaseID ||  Integer ||  ||
| CaseID ||  Integer ||   
|-
|-
| PatientID || Integer ||  ||
| PatientID || Integer ||   
|-
|-
| LogState || Integer ||  Internal Metavision value. Note that in this version of the dataset this is a raw unencoded value.  ||
| 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 ||
| Offset || Integer || Time in seconds after admission
|-
|-
| HospitalUnit ||  Reference || Encoded unit value, unitlog.HospitalUnit = d_references.ReferenceGlobalID  ||
| HospitalUnit ||  Reference ||  
|}
|}

Latest revision as of 10:35, 9 November 2022

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