This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
documentation:next_cdm:eraroute [2017/01/12 18:09] 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 and add route_concept_id column | + | 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 | 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 | 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 | 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) |