Difference between revisions of "Data Description References"

From SICDB Doc
Jump to navigation Jump to search
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)
|}
|}

Revision as of 19:15, 31 October 2022

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.


Caption d_references
Name Description Comment
ReferenceGlobalID Integer The unique ID for the reference Use this identifier as dictionary for alle encoded fields
ReferenceValue Text Reference value i.e. "Creatinine"
ReferenceName Text The name of the reference i.e. "Laboratory"
ReferenceUnit Text The unit of this item if applicable i.e. "mg/dl"