Difference between revisions of "Data Description References"
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 | 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. " | | ReferenceValue || Text || Reference value || i.e. "Creatinine" | ||
|- | |- | ||
| ReferenceName || Text || The name of the reference | | ReferenceName || Text || The name of the reference || i.e. "Laboratory" | ||
|- | |- | ||
| ReferenceUnit || Text || The | | ReferenceUnit || Text || The unit of this item if applicable || i.e. "mg/dl" | ||
|} | |} |
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.
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" |