ID

35277

Descripción

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

Palabras clave

Versiones (2)
  1. 4/1/17 4/1/17 -
  2. 26/2/19 26/2/19 -
Titular de derechos de autor

Observational Medical Outcomes Partnership (OMOP)

Subido en

26 de febrero de 2019

DOI

Para solicitar uno, por favor iniciar sesión.

Licencia

Creative Commons BY-NC 3.0
Comentarios del modelo :

Puede comentar sobre el modelo de datos aquí. A través de las burbujas de diálogo en los grupos de elementos y elementos, puede agregar comentarios específicos.

Volver a los comentarios del modelo
Comentarios de grupo de elementos para :

Comentarios del elemento para :

Para descargar modelos de datos, debe haber iniciado sesión. Por favor iniciar sesión o Registrate gratis.

OMOP Common Data Model (CDM) Drug Strength

Inglés

OMOP Common Data Model (CDM) Drug Strength

1 formularios  
Drug strength
Descripción

Drug strength

Alias
UMLS CUI-1
C0013227
UMLS CUI-2
C1705922
Drug concept ID
Descripción

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

Tipo de datos

integer

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Ingredient concept ID
Descripción

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

Tipo de datos

integer

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

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

Tipo de datos

float

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

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

Tipo de datos

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
Descripción

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

Tipo de datos

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
Descripción

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

Tipo de datos

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
Descripción

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.

Tipo de datos

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
Descripción

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.

Tipo de datos

integer

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

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

Tipo de datos

integer

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C0449961
valid start date
Descripción

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

Tipo de datos

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
Descripción

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.

Tipo de datos

date

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

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

Tipo de datos

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
Volver a la parte superior de la página

Similar models

OMOP Common Data Model (CDM) Drug Strength

1 formularios
Name
Tipo
Description | Question | Decode (Coded Value)
Tipo de datos
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)
Volver a la parte superior de la página 

Contacto

Utilice este formulario para comentarios, preguntas y sugerencias.

Los campos marcados con * son obligatorios.

Ayuda

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