implementation_international_drug_vocabulary
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Next revision Both sides next revision | ||
|
implementation_international_drug_vocabulary [2020/06/26 19:47] aostropolets box_s |
implementation_international_drug_vocabulary [2020/06/26 19:48] aostropolets |
||
|---|---|---|---|
| Line 94: | Line 94: | ||
| ^Field^Required^Type^Description^ | ^Field^Required^Type^Description^ | ||
| - | |concept_code_1|Yes|string(255)|One source code of the pair| | + | |concept_code_1|Yes|VARCHAR(255)|One source code of the pair| |
| - | |concept_code_2|Yes|string(255)|The other source code of the pair| | + | |concept_code_2|Yes|VARCHAR(255)|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 112: | Line 112: | ||
| |denominator_value|No|NUMERIC|The denominator value for a concentration (usually liquid formulations). It should contain a number for Quantified products, and null for everything else.| | |denominator_value|No|NUMERIC|The denominator value for a concentration (usually liquid formulations). It should contain a number for Quantified products, and null for everything else.| | ||
| |denominator_unit|No|VARCHAR(255)|The verbatim denominator unit of a concentration (usually liquid formulations)| | |denominator_unit|No|VARCHAR(255)|The verbatim denominator unit of a concentration (usually liquid formulations)| | ||
| - | |box_size|No| NUMERIC |The number of units per box| | + | |box_size|No|SMALLINT|The number of units per box| |
| This table contains the dose of each ingredient in each drug, as well as the box_size. For drugs which have no strength information or have only for some of the containing ingredients, the ds_stage record must be omitted. '0' values in ds_stage are only allowed for inert drugs. | This table contains the dose of each ingredient in each drug, as well as the box_size. For drugs which have no strength information or have only for some of the containing ingredients, the ds_stage record must be omitted. '0' values in ds_stage are only allowed for inert drugs. | ||
implementation_international_drug_vocabulary.txt · Last modified: 2024/09/02 12:33 by jcruz
Page Tools
