ID

35277

Description

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

Lien

http://omop.fnih.org/publiclicense

Mots-clés

Versions (2)
  1. 04/01/2017 04/01/2017 -
  2. 26/02/2019 26/02/2019 -
Détendeur de droits

Observational Medical Outcomes Partnership (OMOP)

Téléchargé le

26 février 2019

DOI

Pour une demande vous connecter.

Licence

Creative Commons BY-NC 3.0
Modèle Commentaires :

Ici, vous pouvez faire des commentaires sur le modèle. À partir des bulles de texte, vous pouvez laisser des commentaires spécifiques sur les groupes Item et les Item.

Retour au modèle Commentaires
Groupe Item commentaires pour :

Item commentaires pour :

Vous devez être connecté pour pouvoir télécharger des formulaires. Veuillez vous connecter ou s’inscrire gratuitement.

OMOP Common Data Model (CDM) Drug Strength

Anglais

OMOP Common Data Model (CDM) Drug Strength

1 Formulaires  
Drug strength
Description

Drug strength

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

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

Type de données

integer

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

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

Type de données

integer

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

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

Type de données

float

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

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

Type de données

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
Description

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

Type de données

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
Description

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

Type de données

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
Description

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.

Type de données

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
Description

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.

Type de données

integer

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

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

Type de données

integer

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

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

Type de données

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
Description

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.

Type de données

date

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

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

Type de données

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
Retour au début de la page

Similar models

OMOP Common Data Model (CDM) Drug Strength

1 Formulaires
Name
Type
Description | Question | Decode (Coded Value)
Type de données
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)
Retour au début de la page 

Contact

Utilisez ce formulaire pour les retours, les questions et les améliorations suggérées.

Les champs marqués d’un * sont obligatoires.

Aide

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