ID

35277

Descrição

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

Palavras-chave

Versões (2)
  1. 04/01/2017 04/01/2017 -
  2. 26/02/2019 26/02/2019 -
Titular dos direitos

Observational Medical Outcomes Partnership (OMOP)

Transferido a

26 de fevereiro de 2019

DOI

Para um pedido faça login.

Licença

Creative Commons BY-NC 3.0
Comentários do modelo :

Aqui pode comentar o modelo. Pode comentá-lo especificamente através dos balões de texto nos grupos de itens e itens.

Voltar para os comentários do modelo
Comentários do grupo de itens para :

Comentários do item para :

Para descarregar formulários, precisa de ter uma sessão iniciada. Por favor faça login ou registe-se gratuitamente.

OMOP Common Data Model (CDM) Drug Strength

Inglês

OMOP Common Data Model (CDM) Drug Strength

1 Formulários  
Drug strength
Descrição

Drug strength

Alias
UMLS CUI-1
C0013227
UMLS CUI-2
C1705922
Drug concept ID
Descrição

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

Tipo de dados

integer

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Ingredient concept ID
Descrição

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

Tipo de dados

integer

Alias
UMLS CUI [1,1]
C1550600
UMLS CUI [1,2]
C0013227
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Amount value
Descrição

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

Tipo de dados

float

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C1372955
UMLS CUI [1,3]
C1265611
Amount unit concept ID
Descrição

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 dados

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
Descrição

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

Tipo de dados

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
Descrição

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 dados

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
Descrição

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 dados

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
Descrição

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 dados

integer

Alias
UMLS CUI [1,1]
C2825218
UMLS CUI [1,2]
C1519795
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Box size
Descrição

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 dados

integer

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C0449961
valid start date
Descrição

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

Tipo de dados

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
Descrição

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 dados

date

Alias
UMLS CUI [1,1]
C0806020
UMLS CUI [1,2]
C0013227
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
invalid reason
Descrição

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 dados

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
Voltar ao início da página

Similar models

OMOP Common Data Model (CDM) Drug Strength

1 Formulários
Name
Tipo
Description | Question | Decode (Coded Value)
Tipo de dados
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)
Voltar ao início da página 

Contacto

Use este formulário para feedback, perguntas e sugestões de aperfeiçoamento.

Campos marcados com * são obrigatórios.

Ajuda

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