Difference between revisions of "Data Description References"
Jump to navigation
Jump to search
| (2 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. | 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. | ||
| 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 | ||
Latest revision as of 15:49, 7 November 2022
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" |