Difference between revisions of "SICdb Documentation"

From SICDB Doc
Jump to navigation Jump to search
(Created page with "== List of files == {{:Case Data:Raw Fields}} {{:Float Data Hourly}}")
 
Line 1: Line 1:
== List of files ==
== List of files ==


{{:Case Data:Raw Fields}}
{{:Case Data/Raw Fields}}




{{:Float Data Hourly}}
{{:Float Data Hourly}}

Revision as of 18:41, 31 October 2022

List of files

Case Data/Raw Fields


Contains hourly float data associated with a case. If more (minute) data is available, data was aggregated and the corresponding values are stored in rawdata field. Refer to Deserialize Raw Data for more information. Metavision does, in database, not differentiate between qualitative (i.e. blood pressure) and quantitative (i.e. drainage volume) data, this was done programatically saving the sum instead of average. The field cnt indicates the amount of values aggregated.

data_float_h.csv.gz
Name Type Description Comment
CaseID Integer Case identifier
DataID Reference
Offset Integer Time in seconds after admission
Val Float Value The unit (if applicable) is found in d_references where data_float_h.DataID is associated to d_references.ReferenceGlobalID
cnt Integer Amount of values aggregated
rawdata Blob List of 60 floats containing raw data Due to excessive storage needs minute values have been aggregated.