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

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

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

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

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

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

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

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

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

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

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

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