User Tools

Site Tools


implementation_international_drug_vocabulary

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
implementation_international_drug_vocabulary [2020/06/26 19:48]
aostropolets
implementation_international_drug_vocabulary [2020/06/26 19:54] (current)
aostropolets
Line 73: Line 73:
  
 ^Field^Required^Type^Description^ ^Field^Required^Type^Description^
-|concept_code_1|Yes|VARCHAR(255)|The source code|+|concept_code_1|Yes|VARCHAR(50)|The source code|
 |concept_id_2|Yes|INTEGER|The existing target Concept| |concept_id_2|Yes|INTEGER|The existing target Concept|
-|precedence|No| ​INTEGER|For multiple concept_code_1/​concept_id_2 combination the order of precedence in which they should be considered for equivalence testing. The mapping with the highest prevalence among the drugs will be used for writing a record to the CONCEPT_RELATIONSHIP table. A missing precedence will be interpreted as precedence 1. Every precedence value should be unique per concept_code_1|+|precedence|No|SMALLINT|For multiple concept_code_1/​concept_id_2 combination the order of precedence in which they should be considered for equivalence testing. The mapping with the highest prevalence among the drugs will be used for writing a record to the CONCEPT_RELATIONSHIP table. A missing precedence will be interpreted as precedence 1. Every precedence value should be unique per concept_code_1|
 |conversion_factor|No|NUMERIC|The factor used to convert the source code to the target Concept. This is usually defined for units| |conversion_factor|No|NUMERIC|The factor used to convert the source code to the target Concept. This is usually defined for units|
  
Line 94: Line 94:
  
 ^Field^Required^Type^Description^ ^Field^Required^Type^Description^
-|concept_code_1|Yes|VARCHAR(255)|One source code of the pair| +|concept_code_1|Yes|VARCHAR(50)|One source code of the pair| 
-|concept_code_2|Yes|VARCHAR(255)|The other source code of the pair|+|concept_code_2|Yes|VARCHAR(50)|The other source code of the pair|
  
 This table should contain relationships for each Drug Concept: To the Ingredients (always), the Dose Form (if appropriate),​the Supplier (if appropriate) and the Brand Name (if appropriate). All other relationships will be derived and ignored if they exist in the table. The relationships don't need to be symmetrical,​ only the one initiating from the Drug Concept is required. This table should contain relationships for each Drug Concept: To the Ingredients (always), the Dose Form (if appropriate),​the Supplier (if appropriate) and the Brand Name (if appropriate). All other relationships will be derived and ignored if they exist in the table. The relationships don't need to be symmetrical,​ only the one initiating from the Drug Concept is required.
Line 104: Line 104:
  
 ^Field^Required^Type^Description^ ^Field^Required^Type^Description^
-|drug_concept_code|Yes| VARCHAR(255)|The source code of the Drug or Drug Component, either Branded or Clinical| +|drug_concept_code|Yes| VARCHAR(50)|The source code of the Drug or Drug Component, either Branded or Clinical| 
-|ingredient_concept_code|Yes| VARCHAR(255)|The source code for one of the Ingredients|+|ingredient_concept_code|Yes| VARCHAR(50)|The source code for one of the Ingredients|
 |amount_value|No|NUMERIC|The numeric value for absolute content (usually solid formulations)| |amount_value|No|NUMERIC|The numeric value for absolute content (usually solid formulations)|
 |amount_unit|No| VARCHAR(255)|The verbatim unit of the absolute content (solids)| |amount_unit|No| VARCHAR(255)|The verbatim unit of the absolute content (solids)|
implementation_international_drug_vocabulary.txt · Last modified: 2020/06/26 19:54 by aostropolets