Reference Table

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.

d_references.csv.gz

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

Usage Information

d_references is the dictionary for all encoded data.

Raw Data

For raw data replace the value (i.e. Laboratory.LaboratoryID) with the value of d_references.ReferenceValue where Laboratory.LaboratoryID = d_references.ReferenceGlobalID

SQL

Use a join query to get the reference value.

Example:

 SELECT Sex,SexRef.ReferenceValue as SexCaption FROM `cases` INNER JOIN d_references as SexRef ON SexRef.ReferenceGlobalID = cases.Sex;

RooDataServer

ReferenceSelection

All fields using references provide simple filters to select references. On export RooDataServer will per default export the text value of an encoding.

Note

To reduce the amount of tables there is no table describing references as there is no significant gain of information expected. This may change in later versions of dataset. To enumerate a reference use table d_references.ReferenceName, which is an immutable, case sensitive key to a reference.