Difference between revisions of "Data Description"
Jump to navigation
Jump to search
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The SICdb dataset consists of multiple tables. The main tables are [[Table: Cases | cases]], [[Reference_Table | d_references]], [[Medication_Data | medication]] | The SICdb dataset consists of multiple tables. The main tables are [[Table: Cases | cases]], [[Reference_Table | d_references]], [[Medication_Data | medication]], [[data_float_h]] and [[data_ref]]. | ||
Nearly all fields in the SICdb dataset, that can be encoded, are referenced in d_references, where field ReferenceGlobalID is | Each admission creates one entry in table [[Table: Cases | cases]] and data is relationally connected via the field CaseID, which is available in each of the related tables. Time values are stored in field offset, which is time in seconds from admission. | ||
Nearly all fields in the SICdb dataset, that can be encoded, are referenced in d_references, where field ReferenceGlobalID is related to specified field. | |||
Refer to [[File List]] for a description of each file. | |||
Latest revision as of 09:03, 11 October 2022
The SICdb dataset consists of multiple tables. The main tables are cases, d_references, medication, data_float_h and data_ref.
Each admission creates one entry in table cases and data is relationally connected via the field CaseID, which is available in each of the related tables. Time values are stored in field offset, which is time in seconds from admission.
Nearly all fields in the SICdb dataset, that can be encoded, are referenced in d_references, where field ReferenceGlobalID is related to specified field.
Refer to File List for a description of each file.