Float Data Hourly
| 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 |
| 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. |
Aggregation Description
Most signal data is averaged. The field data_float_h.cnt describes the amount of values aggregated. It is to be expected that the first signal values have less than 60 data points, as it is quite unlikely (1:60) that signal starts on minute 0.
Raw values are saved in field data_float_h.rawdata, being a list of bytes. (IEEE 754 Single(4 bytes), LittleEndian) <noinclude> The recommended way to access this data is using our provided software ([[Get Started]]). An example on how to deserialize the raw_data field can be found [[Deserialize Raw Data|here]]. </noinclude> 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.