ID

35277

Beschrijving

OMOP Common Data Model (CDM) Drug Strength The DRUG_STRENGTH table contains structured content about the amount or concentration and associated units of a specific ingredient contained within a particular drug product. This table is supplemental information to support standardized analysis of drug utilization. The DRUG_STRENGTH table contains information for each active (non-deprecated) standard drug concept. A drug which contains multiple active Ingredients will result in multiple DRUG_STRENGTH records, one for each active ingredient. Ingredient strength information is provided either as absolute amount (usually for solid formulations) or as concentration (usually for liquid formulations. Sometimes, one Ingredient is listed with different units within the same drug. This is very rare, and usually this happens if there are more than one Precise Ingredient. For example, 'Penicillin G, Benzathine 150000 UNT/ML / Penicillin G, Procaine 150000 MEQ/ML Injectable Suspension' contains Penicillin G in two different forms. All Drug vocabularies containing Standard Concepts have entries in the DRUG_STRENGTH table. There is now a Concept Class for supplier information whose relationships can be found in CONCEPT_RELATIONSHIP with a RELATIONSHIP_ID of 'Has supplier' and 'Supplier of' OMOP Common Data Model Version 6.0 Specifications 11October2018 The Observational Medical Outcomes Partnership (OMOP) was a public-private partnership established to inform the appropriate use of observational healthcare databases for studying the effects of medical products. © 2014 Observational Health Data Sciences and Informatics This work is based on work by the Observational Medical Outcomes Partnership (OMOP) and used under license from the FNIH at http://omop.fnih.org/publiclicense. Version updated on 26.02.2019, from https://github.com/OHDSI/CommonDataModel/wiki/DRUG_STRENGTH

Link

http://omop.fnih.org/publiclicense

Trefwoorden

Versies (2)
  1. 04-01-17 04-01-17 -
  2. 26-02-19 26-02-19 -
Houder van rechten

Observational Medical Outcomes Partnership (OMOP)

Geüploaded op

26 februari 2019

DOI

Voor een aanvraag inloggen.

Licentie

Creative Commons BY-NC 3.0
Model Commentaren :

Hier kunt u commentaar leveren op het model. U kunt de tekstballonnen bij de itemgroepen en items gebruiken om er specifiek commentaar op te geven.

Terug naar het model Commentaren
Itemgroep Commentaren voor :

Item Commentaren voor :

U moet ingelogd zijn om formulieren te downloaden. AUB inloggen of schrijf u gratis in.

OMOP Common Data Model (CDM) Drug Strength

Engels

OMOP Common Data Model (CDM) Drug Strength

1 Formulieren  
Drug strength
Beschrijving

Drug strength

Alias
UMLS CUI-1
C0013227
UMLS CUI-2
C1705922
Drug concept ID
Beschrijving

A foreign key to the Concept in the CONCEPT table representing the identifier for Branded Drug or Clinical Drug Concept.

Datatype

integer

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Ingredient concept ID
Beschrijving

A foreign key to the Concept in the CONCEPT table, representing the identifier for drug Ingredient Concept contained within the drug product.

Datatype

integer

Alias
UMLS CUI [1,1]
C1550600
UMLS CUI [1,2]
C0013227
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Amount value
Beschrijving

The numeric value associated with the amount of active ingredient contained within the product.

Datatype

float

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C1372955
UMLS CUI [1,3]
C1265611
Amount unit concept ID
Beschrijving

A foreign key to the Concept in the CONCEPT table representing the identifier for the Unit for the absolute amount of active ingredient.

Datatype

integer

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C1372955
UMLS CUI [1,3]
C1519795
UMLS CUI [1,4]
C0178566
UMLS CUI [1,5]
C1300638
Numerator value
Beschrijving

The numeric value associated with the concentration of the active ingredient contained in the product

Datatype

float

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C1372955
UMLS CUI [1,3]
C0678756
UMLS CUI [1,4]
C1522609
Numerator unit concept ID
Beschrijving

A foreign key to the Concept in the CONCEPT table representing the identifier for the numerator Unit for the concentration of active ingredient.

Datatype

integer

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C1372955
UMLS CUI [1,3]
C0678756
UMLS CUI [1,4]
C1519795
UMLS CUI [1,5]
C0178566
UMLS CUI [1,6]
C1300638
Denominator value
Beschrijving

The amount of total liquid (or other divisible product, such as ointment, gel, spray, etc.). In case of Quantified Clinical or Branded Drugs the DENOMINATOR_VALUE contains the total amount of the solution (not the amount of the ingredient). In all other drug concept classes the denominator amount is NULL because the concentration is always normalized to the unit of the denominator. So, a product containing 960 mg in 20 mL is provided as 48 mg/mL in the Clinical Drug and Clinical Drug Component, while as a Quantified Clinical Drug it is written as 960 mg/20 mL.

Datatype

float

Alias
UMLS CUI [1,1]
C2825218
UMLS CUI [1,2]
C0013227
UMLS CUI [1,3]
C0037633
UMLS CUI [1,4]
C1265611
UMLS CUI [1,5]
C1522609
Denominator unit concept ID
Beschrijving

A foreign key to the Concept in the CONCEPT table representing the identifier for the denominator Unit for the concentration of active ingredient. Sometimes, different ingredients in liquid drugs are listed with different units in the DENOMINATOR_UNIT_CONCEPT_ID. This is usually the case if the ingredients are liquids themselves (concentration provided as mL/mL) or solid substances (mg/mg). In these cases, the general assumptions is made that the density of the drug is that of water, and one can assume 1 g = 1 mL.

Datatype

integer

Alias
UMLS CUI [1,1]
C2825218
UMLS CUI [1,2]
C1519795
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Box size
Beschrijving

The number of units of Clinical of Branded Drug, or Quantified Clinical or Branded Drug contained in a box as dispensed to the patient

Datatype

integer

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C0449961
valid start date
Beschrijving

The date when the Concept was first recorded. The default value is 1-Jan-1970.

Datatype

date

Alias
UMLS CUI [1,1]
C0808070
UMLS CUI [1,2]
C0013227
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
valid end date
Beschrijving

The date when the concept became invalid because it was deleted or superseded (updated) by a new Concept. The default value is 31-Dec-2099.

Datatype

date

Alias
UMLS CUI [1,1]
C0806020
UMLS CUI [1,2]
C0013227
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
invalid reason
Beschrijving

Reason the concept was invalidated. Possible values are 'D' (deleted), 'U' (replaced with an update) or NULL when valid_end_date has the default value. (Type varchar(1))

Datatype

text

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
UMLS CUI [1,4]
C3245471
UMLS CUI [1,5]
C0566251
Terug naar het begin van de pagina

Similar models

OMOP Common Data Model (CDM) Drug Strength

1 Formulieren
Name
Type
Description | Question | Decode (Coded Value)
Datatype
Alias
Item Group
Drug strength
C0013227 (UMLS CUI-1)
C1705922 (UMLS CUI-2)
Drug concept ID
Item
Drug concept ID
integer
C0013227 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Ingredient concept ID
Item
Ingredient concept ID
integer
C1550600 (UMLS CUI [1,1])
C0013227 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Amount value
Item
Amount value
float
C0013227 (UMLS CUI [1,1])
C1372955 (UMLS CUI [1,2])
C1265611 (UMLS CUI [1,3])
Amount unit concept ID
Item
Amount unit concept ID
integer
C0013227 (UMLS CUI [1,1])
C1372955 (UMLS CUI [1,2])
C1519795 (UMLS CUI [1,3])
C0178566 (UMLS CUI [1,4])
C1300638 (UMLS CUI [1,5])
Numerator value
Item
Numerator value
float
C0013227 (UMLS CUI [1,1])
C1372955 (UMLS CUI [1,2])
C0678756 (UMLS CUI [1,3])
C1522609 (UMLS CUI [1,4])
Numerator unit concept ID
Item
Numerator unit concept ID
integer
C0013227 (UMLS CUI [1,1])
C1372955 (UMLS CUI [1,2])
C0678756 (UMLS CUI [1,3])
C1519795 (UMLS CUI [1,4])
C0178566 (UMLS CUI [1,5])
C1300638 (UMLS CUI [1,6])
Denominator value
Item
Denominator value
float
C2825218 (UMLS CUI [1,1])
C0013227 (UMLS CUI [1,2])
C0037633 (UMLS CUI [1,3])
C1265611 (UMLS CUI [1,4])
C1522609 (UMLS CUI [1,5])
Denominator unit concept ID
Item
Denominator unit concept ID
integer
C2825218 (UMLS CUI [1,1])
C1519795 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Box size
Item
Box size
integer
C0013227 (UMLS CUI [1,1])
C0449961 (UMLS CUI [1,2])
valid start date
Item
valid start date
date
C0808070 (UMLS CUI [1,1])
C0013227 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
valid end date
Item
valid end date
date
C0806020 (UMLS CUI [1,1])
C0013227 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Item
invalid reason
text
C0013227 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
C3245471 (UMLS CUI [1,4])
C0566251 (UMLS CUI [1,5])
invalid reason
Code List
invalid reason
CL Item
Deleted (D)
CL Item
Replaced with an update (U)
CL Item
valid end date has the default value (NULL)
Terug naar het begin van de pagina 

Contact

Gebruik dit formulier voor feedback, vragen en verbeteringsvoorstellen.

Velden gemarkeerd met een * zijn verplicht.

Help

Do you need help on how to use the search function? Please watch the corresponding tutorial video for more details and learn how to use the search function most efficiently.

Watch Tutorial