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...") |
|||
| 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) | ||
|} | |} | ||
Revision as of 19:05, 31 October 2022
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.
| 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. "Laboratory" |
| ReferenceName | Text | The name of the reference | i.e. "creatinine" |
| ReferenceUnit | Text | The name of the reference | i.e. "mg/dl" |
| ReferenceOrder | Integer | Default order of reference | i.e. KDIGO_0=0, KDIGO_1=1 (used in further releases) |