ID

35277

Beskrivning

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

Länk

http://omop.fnih.org/publiclicense

Nyckelord

Versioner (2)
  1. 2017-01-04 2017-01-04 -
  2. 2019-02-26 2019-02-26 -
Rättsinnehavare

Observational Medical Outcomes Partnership (OMOP)

Uppladdad den

26 februari 2019

DOI

För en begäran logga in.

Licens

Creative Commons BY-NC 3.0
Modellkommentarer :

Här kan du kommentera modellen. Med hjälp av pratbubblor i Item-grupperna och Item kan du lägga in specifika kommentarer.

Tillbaka till modellkommentarer
Itemgroup-kommentar för :

Item-kommentar för :

Du måste vara inloggad för att kunna ladda ner formulär. Var vänlig logga in eller registrera dig utan kostnad.

OMOP Common Data Model (CDM) Drug Strength

Engelsk

OMOP Common Data Model (CDM) Drug Strength

1 Formulär  
Drug strength
Beskrivning

Drug strength

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

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

Datatyp

integer

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

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

Datatyp

integer

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

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

Datatyp

float

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

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

Datatyp

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
Beskrivning

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

Datatyp

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
Beskrivning

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

Datatyp

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
Beskrivning

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.

Datatyp

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
Beskrivning

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.

Datatyp

integer

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

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

Datatyp

integer

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

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

Datatyp

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
Beskrivning

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.

Datatyp

date

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

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

Datatyp

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
Tillbaka till toppen

Similar models

OMOP Common Data Model (CDM) Drug Strength

1 Formulär
Name
Typ
Description | Question | Decode (Coded Value)
Datatyp
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)
Tillbaka till toppen 

Kontakt

Använd detta formulär för feedback, frågor och förslag på förbättringar.

Fält markerade med * är obligatoriska.

Hjälp

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