Engelsk

OMOP Common Data Model (CDM) Device Exposure

1 Formulär  
Device Exposure
Beskrivning

Device Exposure

Alias
UMLS CUI-1
C0699733
UMLS CUI-2
C0332157
Device exposure ID
Beskrivning

A system-generated unique identifier for each device exposure.

Datatyp

integer

Alias
UMLS CUI [1,1]
C0699733
UMLS CUI [1,2]
C0332157
UMLS CUI [1,3]
C1300638
Person ID
Beskrivning

A foreign key identifier to the person who is subjected to the procedure. The demographic details of that person are stored in the person table.

Datatyp

integer

Alias
UMLS CUI [1]
C2348585
Device concept ID
Beskrivning

Only the DI portion of the UDI would be captured as a Concept in the Standardized Vocabularies.

Datatyp

integer

Alias
UMLS CUI [1,1]
C0699733
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Device exposure start date
Beskrivning

The date the device or supply was applied or used.

Datatyp

date

Alias
UMLS CUI [1,1]
C0699733
UMLS CUI [1,2]
C0332157
UMLS CUI [1,3]
C0011008
Device exposure end date
Beskrivning

The date the device or supply was removed from use.

Datatyp

date

Alias
UMLS CUI [1,1]
C0699733
UMLS CUI [1,2]
C0332157
UMLS CUI [1,3]
C0011008
Device type concept ID
Beskrivning

Provenance for the data, e.g. procedure device, from registry, etc.

Datatyp

integer

Alias
UMLS CUI [1,1]
C0699733
UMLS CUI [1,2]
C0332307
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Unique device ID
Beskrivning

The entire UDI or equivalent.

Datatyp

text

Alias
UMLS CUI [1,1]
C3830167
UMLS CUI [1,2]
C0699733
Quantity
Beskrivning

The number of individual devices used for the exposure

Datatyp

integer

Alias
UMLS CUI [1,1]
C1265611
UMLS CUI [1,2]
C0699733
Provider ID
Beskrivning

A foreign key to the provider in the provider table who was responsible for using the device.

Datatyp

integer

Alias
UMLS CUI [1,1]
C1138603
UMLS CUI [1,2]
C1300638
Visit occurrence ID
Beskrivning

A foreign key to the visit in the visit table during which the device was used.

Datatyp

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C2745955
UMLS CUI [1,3]
C1300638
Device source value
Beskrivning

The source code for the device as it appears in the source data. This code is mapped to a standard device concept in the Standardized Vocabularies and the original code is stored here for reference.

Datatyp

text

Alias
UMLS CUI [1,1]
C0699733
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C1522609
Device source concept ID
Beskrivning

A foreign key to a device concept that refers to the code used in the source.

Datatyp

integer

Alias
UMLS CUI [1,1]
C0699733
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Tillbaka till toppen

Similar models

OMOP Common Data Model (CDM) Device Exposure

1 Formulär
Name
Typ
Description | Question | Decode (Coded Value)
Datatyp
Alias
Item Group
Device Exposure
C0699733 (UMLS CUI-1)
C0332157 (UMLS CUI-2)
Device exposure ID
Item
Device exposure ID
integer
C0699733 (UMLS CUI [1,1])
C0332157 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Person ID
Item
Person ID
integer
C2348585 (UMLS CUI [1])
Device concept ID
Item
Device concept ID
integer
C0699733 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Device exposure start date
Item
Device exposure start date
date
C0699733 (UMLS CUI [1,1])
C0332157 (UMLS CUI [1,2])
C0011008 (UMLS CUI [1,3])
Device exposure end date
Item
Device exposure end date
date
C0699733 (UMLS CUI [1,1])
C0332157 (UMLS CUI [1,2])
C0011008 (UMLS CUI [1,3])
Device type concept ID
Item
Device type concept ID
integer
C0699733 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Unique device ID
Item
Unique device ID
text
C3830167 (UMLS CUI [1,1])
C0699733 (UMLS CUI [1,2])
Quantity
Item
Quantity
integer
C1265611 (UMLS CUI [1,1])
C0699733 (UMLS CUI [1,2])
Provider ID
Item
Provider ID
integer
C1138603 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Visit occurrence ID
Item
Visit occurrence ID
integer
C1512346 (UMLS CUI [1,1])
C2745955 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Device source value
Item
Device source value
text
C0699733 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C1522609 (UMLS CUI [1,3])
Device source concept ID
Item
Device source concept ID
integer
C0699733 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Tillbaka till toppen