Difference between revisions of "Data Description Medication"
Jump to navigation
Jump to search
(Created page with "{| class="wikitable" |+ medication.csv.gz |- ! Name !! Type !! Description !! Comment |- | id || Integer || Primary Key || |- | CaseID || Integer || Case identifier || |- | LaboratoryID || Reference || || |- | Offset || Integer || Time in seconds after admission || |- | OffsetDrugEnd || Integer || If drug was given continuously refers to end of application. Field is set to 60 seconds on bolus application. || |- | Amount || Float || Full amount given regardles...") |
|||
| Line 1: | Line 1: | ||
Contains all medication given during stay. Additional data like name and unit of measurement is found in d_references, where medication.DrugID is associated to d_references.ReferenceGlobalID. Metavision does not differ between continuous or single doses in rangesignals, so a single dose is set to 60 second admission time. Each change of a continuous application will end the current entry and create a new one. | |||
{| class="wikitable" | {| class="wikitable" | ||
|+ medication.csv.gz | |+ medication.csv.gz | ||
| Line 8: | Line 10: | ||
| CaseID || Integer || Case identifier || | | CaseID || Integer || Case identifier || | ||
|- | |- | ||
| | | DrugID || Reference || || | ||
|- | |- | ||
| Offset || Integer || Time in seconds after admission || | | Offset || Integer || Time in seconds after admission || | ||
Revision as of 17:12, 3 November 2022
Contains all medication given during stay. Additional data like name and unit of measurement is found in d_references, where medication.DrugID is associated to d_references.ReferenceGlobalID. Metavision does not differ between continuous or single doses in rangesignals, so a single dose is set to 60 second admission time. Each change of a continuous application will end the current entry and create a new one.
| Name | Type | Description | Comment |
|---|---|---|---|
| id | Integer | Primary Key | |
| CaseID | Integer | Case identifier | |
| DrugID | Reference | ||
| Offset | Integer | Time in seconds after admission | |
| OffsetDrugEnd | Integer | If drug was given continuously refers to end of application. Field is set to 60 seconds on bolus application. | |
| Amount | Float | Full amount given regardless of time | Unity of measurement found in d_references |
| AmountPerMinute | Float | Dosage per minute | Unity of measurement found in d_references |