Differences

This shows you the differences between two versions of the page.

--- documentation:next_cdm:eraroute [2017/01/12 18:12] – vojtechhuser
+++ documentation:next_cdm:eraroute [2017/01/12 18:13] (current) – vojtechhuser
@@ Line 1: / Line 1: @@
-Proposal by: Vojtech Huser
+**Proposal by:** Vojtech Huser
-Use Case: ingredients like neomycin can be taken oraly and localy (otic, ophtalmic). Such drug eras are medically distinct.
+**Use Case:** ingredients like neomycin can be taken oraly and localy (otic, ophtalmic). Such drug eras are medically distinct.
-Changes proposed:
+**Changes proposed:**
-Modify DRUG_ERA table (http://www.ohdsi.org/web/wiki/doku.php?id=documentation:cdm:drug_era) and add route_concept_id column (as a required column; if drug route is not known, enter 0)
+Modify DRUG_ERA table (http://www.ohdsi.org/web/wiki/doku.php?id=documentation:cdm:drug_era) and add route_concept_id column (as an optional column)
@@ Line 11: / Line 12: @@
 http://www.ohdsi.org/web/wiki/doku.php?id=documentation:cdm:drug_exposure
+Paste of the column details:
 route_concept_id	(integer)	A foreign key to a predefined concept in the Standardized Vocabularies reflecting the route of administration
-Forum e-voting on the proposal is possible here (first post likes count):
+**Forum e-voting on the proposal is possible here (first post likes count):**
 http://forums.ohdsi.org/t/cdm-change-proposal-drug-era-add-route-concept-id-column/2101
-Discuss: (same thread as above)
+**Discuss:** (same thread as above)