Data Description Data Float h - Revision history

Salkin at 17:27, 3 November 2022

2022-11-03T17:27:21Z

← Older revision		Revision as of 17:27, 3 November 2022
Line 12:		Line 12:
	\| Offset \|\| Integer\|\| Time in seconds after admission \|\|		\| Offset \|\| Integer\|\| Time in seconds after admission \|\|
	\|-		\|-
	\| Val \|\| Float \|\| Value \|\| The unit (if applicable) is found in d_references		\| 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 \|\|		\| cnt \|\| Integer \|\| Amount of values aggregated \|\|

Salkin at 17:26, 3 November 2022

2022-11-03T17:26:29Z

← Older revision		Revision as of 17:26, 3 November 2022
Line 2:		Line 2:

	{\| class="wikitable"		{\| class="wikitable"
	\|+ ~~Caption text~~		\|+ data_float_h.csv.gz
	\|-		\|-
	! Name !! Type !! Description !! Comment		! Name !! Type !! Description !! Comment

Salkin at 17:26, 3 November 2022

2022-11-03T17:26:15Z

@@ Line 1: / Line 1: @@
-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.
+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.
 {| class="wikitable"
@@ Line 18: / Line 18: @@
 | rawdata || Blob || List of 60 floats containing raw data  || Due to excessive storage needs minute values have been aggregated.
 |}

Salkin at 17:22, 3 November 2022

2022-11-03T17:22:08Z

← Older revision		Revision as of 17:22, 3 November 2022
Line 1:		Line 1:
			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.

	{\| class="wikitable"		{\| class="wikitable"

Salkin at 08:48, 3 November 2022

2022-11-03T08:48:30Z

← Older revision		Revision as of 08:48, 3 November 2022
Line 18:		Line 18:
	\|}		\|}

	<noinclude>== Aggregation Description ==<noinclude>		<noinclude>== Aggregation Description ==</noinclude>
	<includeonly>=== Aggregation Description ===</includeonly>		<includeonly>=== Aggregation Description ===</includeonly>
	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.		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.

Salkin at 08:47, 3 November 2022

2022-11-03T08:47:38Z

← Older revision		Revision as of 08:47, 3 November 2022
Line 18:		Line 18:
	\|}		\|}

	== Aggregation Description ==		<noinclude>== Aggregation Description ==<noinclude>
			<includeonly>=== Aggregation Description ===</includeonly>
	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.		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.

Salkin: Created page with " {| class="wikitable" |+ Caption text |- ! 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 ha..."

2022-10-31T19:52:24Z

Created page with " {| class="wikitable" |+ Caption text |- ! 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 ha..."

New page

{| class="wikitable"
|+ Caption text
|-
! 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.