Data Description References - Revision history

Salkin at 05:41, 12 July 2024

2024-07-12T05:41:00Z

← Older revision		Revision as of 05:41, 12 July 2024
Line 1:		Line 1:

	The d_references table contains information on all encoded data fields of the SICdb dataset. Each field, that has "Reference" as field type, is associated with the ReferenceGlobalID in the d_references table. Additionally ReferenceUnit describes the unit of measurement used for this field. Refer to chapter [[SQL Examples]] to learn how to easily use this table in relational databases.		The d_references table contains information on all encoded data fields of the SICdb dataset. Each field, that has "Reference" as field type, is associated with the ReferenceGlobalID in the d_references table. Additionally ReferenceUnit describes the unit of measurement used for this field. Refer to chapter [[SQL Examples]] to learn how to easily use this table in relational databases.


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

Salkin at 05:39, 12 July 2024

2024-07-12T05:39:48Z

← Older revision		Revision as of 05:39, 12 July 2024
Line 15:		Line 15:
	\|-		\|-
	\| ReferenceUnit \|\| Text \|\| The unit of this item if applicable \|\| i.e. "mg/dl"		\| ReferenceUnit \|\| Text \|\| The unit of this item if applicable \|\| i.e. "mg/dl"
			\|-
			\| LOINC_code \|\| Text \|\| LOINC Code \|\|
			\|-
			\| LOINC_short \|\| Text \|\| LOINC SHORTNAME \|\|
			\|-
			\| LOINC_long \|\| Text \|\| LOINC LONG_COMMON_NAME \|\|

	\|}		\|}

Salkin at 15:49, 7 November 2022

2022-11-07T15:49:03Z

← Older revision		Revision as of 15:49, 7 November 2022
Line 1:		Line 1:

	The d_references table contains information on all encoded data fields of the SICdb dataset. Each field, that has "Reference" as field type, is associated with the ReferenceGlobalID in the d_references table. Additionally ReferenceUnit describes the unit of measurement used for this field.		The d_references table contains information on all encoded data fields of the SICdb dataset. Each field, that has "Reference" as field type, is associated with the ReferenceGlobalID in the d_references table. Additionally ReferenceUnit describes the unit of measurement used for this field. Refer to chapter [[SQL Examples]] to learn how to easily use this table in relational databases.

Salkin at 17:28, 3 November 2022

2022-11-03T17:28:29Z

← Older revision		Revision as of 17:28, 3 November 2022
Line 6:		Line 6:
	\|+ d_references.csv.gz		\|+ d_references.csv.gz
	\|-		\|-
	! Name !! Description !! Comment		! Name !! Type !! Description !! Comment
	\|-		\|-
	\| ReferenceGlobalID \|\| Integer \|\| The unique ID for the reference \|\| Use this identifier as dictionary for alle encoded fields		\| ReferenceGlobalID \|\| Integer \|\| The unique ID for the reference \|\| Use this identifier as dictionary for alle encoded fields

Salkin at 08:55, 1 November 2022

2022-11-01T08:55:04Z

← Older revision		Revision as of 08:55, 1 November 2022
Line 1:		Line 1:
	~~== Data Description of references.csv.gz ==~~
	The d_references table contains information on all encoded data fields of the SICdb dataset. Each field, that has "Reference" as field type, is associated with the ReferenceGlobalID in the d_references table. Additionally ReferenceUnit describes the unit of measurement used for this field.		The d_references table contains information on all encoded data fields of the SICdb dataset. Each field, that has "Reference" as field type, is associated with the ReferenceGlobalID in the d_references table. Additionally ReferenceUnit describes the unit of measurement used for this field.

Salkin at 19:15, 31 October 2022

2022-10-31T19:15:43Z

← Older revision		Revision as of 19:15, 31 October 2022
Line 4:		Line 4:

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

Salkin at 19:15, 31 October 2022

2022-10-31T19:15:25Z

← Older revision		Revision as of 19:15, 31 October 2022
Line 1:		Line 1:
	== Data Description of references.csv.gz ==		== Data Description of references.csv.gz ==
	The d_references table contains information on all encoded data fields of the ~~SICDB~~ dataset. ~~To simplify JOIN and other types~~ of ~~subqueries each reference value has an unique global identifier~~.		The d_references table contains information on all encoded data fields of the SICdb dataset. Each field, that has "Reference" as field type, is associated with the ReferenceGlobalID in the d_references table. Additionally ReferenceUnit describes the unit of measurement used for this field.


Line 10:		Line 10:
	\| ReferenceGlobalID \|\| Integer \|\| The unique ID for the reference \|\| Use this identifier as dictionary for alle encoded fields		\| ReferenceGlobalID \|\| Integer \|\| The unique ID for the reference \|\| Use this identifier as dictionary for alle encoded fields
	\|-		\|-
	\| ReferenceValue \|\| Text \|\| Reference value \|\| i.e. "~~Laboratory~~"		\| ReferenceValue \|\| Text \|\| Reference value \|\| i.e. "Creatinine"
	\|-		\|-
	\| ReferenceName \|\| Text \|\| The name of the reference \|\| i.e. "~~creatinine~~"		\| ReferenceName \|\| Text \|\| The name of the reference \|\| i.e. "Laboratory"
	\|-		\|-
	\| ReferenceUnit \|\| Text \|\| The ~~name~~ of ~~the reference~~ \|\| i.e. "mg/dl"		\| ReferenceUnit \|\| Text \|\| The unit of this item if applicable \|\| i.e. "mg/dl"
	\|-
	~~\| ReferenceOrder \|\| Integer \|\| Default order of reference \|\| i.e. KDIGO_0=0, KDIGO_1=1 (used in further releases)~~
	\|}		\|}

Salkin: /* Data Description of references.csv.gz */

2022-10-31T19:05:06Z

Data Description of references.csv.gz

← Older revision		Revision as of 19:05, 31 October 2022
Line 8:		Line 8:
	! Name !! Description !! Comment		! Name !! Description !! Comment
	\|-		\|-
	\| ReferenceGlobalID \|\| The unique ID for the reference \|\| Use this identifier as dictionary for alle encoded fields		\| ReferenceGlobalID \|\| Integer \|\| The unique ID for the reference \|\| Use this identifier as dictionary for alle encoded fields
	\|-		\|-
	\| ReferenceValue \|\| Reference value \|\| i.e. "Laboratory"		\| ReferenceValue \|\| Text \|\| Reference value \|\| i.e. "Laboratory"
	\|-		\|-
	\| ReferenceName \|\| The name of the reference \|\| i.e. "creatinine"		\| ReferenceName \|\| Text \|\| The name of the reference \|\| i.e. "creatinine"
	\|-		\|-
	\| ReferenceUnit \|\| The name of the reference \|\| i.e. "mg/dl"		\| ReferenceUnit \|\| Text \|\| The name of the reference \|\| i.e. "mg/dl"
	\|-		\|-
	\| ReferenceOrder \|\| Default order of reference \|\| i.e. KDIGO_0=0, KDIGO_1=1 (used in further releases)		\| ReferenceOrder \|\| Integer \|\| Default order of reference \|\| i.e. KDIGO_0=0, KDIGO_1=1 (used in further releases)
	\|}		\|}

Salkin: Created page with "== Data Description of references.csv.gz == The d_references table contains information on all encoded data fields of the SICDB dataset. To simplify JOIN and other types of subqueries each reference value has an unique global identifier. {| class="wikitable" |+ Caption d_references |- ! Name !! Description !! Comment |- | ReferenceGlobalID || The unique ID for the reference || Use this identifier as dictionary for alle encoded fields |- | ReferenceValue || Reference..."

2022-10-31T18:56:36Z

Created page with "== Data Description of references.csv.gz == The d_references table contains information on all encoded data fields of the SICDB dataset. To simplify JOIN and other types of subqueries each reference value has an unique global identifier. {| class="wikitable" |+ Caption d_references |- ! Name !! Description !! Comment |- | ReferenceGlobalID || The unique ID for the reference || Use this identifier as dictionary for alle encoded fields |- | ReferenceValue || Reference..."

New page

== Data Description of references.csv.gz ==
The d_references table contains information on all encoded data fields of the SICDB dataset. To simplify JOIN and other types of subqueries each reference value has an unique global identifier.

{| class="wikitable"
|+ Caption d_references
|-
! Name !! Description !! Comment
|-
| ReferenceGlobalID || The unique ID for the reference || Use this identifier as dictionary for alle encoded fields
|-
| ReferenceValue || Reference value || i.e. "Laboratory"
|-
| ReferenceName || The name of the reference || i.e. "creatinine"
|-
| ReferenceUnit || The name of the reference || i.e. "mg/dl"
|-
| ReferenceOrder || Default order of reference || i.e. KDIGO_0=0, KDIGO_1=1 (used in further releases)
|}