documentation:next_cdm:eraroute
Differences
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 [2016/11/29 18:04] 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):** | ||
| + | http://forums.ohdsi.org/t/cdm-change-proposal-drug-era-add-route-concept-id-column/2101 | ||
| + | |||
| + | **Discuss:** (same thread as above) | ||
| + | |||
| ---- | ---- | ||
documentation/next_cdm/eraroute.1480442672.txt.gz · Last modified: 2016/11/29 18:04 by vojtechhuser
Page Tools
