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] 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) | ||
+ | |||
---- | ---- |