Difference between revisions of "Data Description References"
Jump to navigation
Jump to search
(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...") |
|||
| (7 intermediate revisions by the same user not shown) | |||
| 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. | |||
{| class="wikitable" | {| class="wikitable" | ||
|+ | |+ d_references.csv.gz | ||
|- | |- | ||
! Name !! Description !! Comment | ! Name !! Type !! 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. " | | ReferenceValue || Text || Reference value || i.e. "Creatinine" | ||
|- | |- | ||
| ReferenceName || The name of the reference | | ReferenceName || Text || The name of the reference || i.e. "Laboratory" | ||
|- | |- | ||
| ReferenceUnit || The | | 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 || | |||
|} | |} | ||
Latest revision as of 05:41, 12 July 2024
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.
| Name | Type | 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" |
| LOINC_code | Text | LOINC Code | |
| LOINC_short | Text | LOINC SHORTNAME | |
| LOINC_long | Text | LOINC LONG_COMMON_NAME |