Engels

OMOP Common Data Model (CDM) Procedure occurrence

1 Formulieren  
Procedure occurrence
Beschrijving

Procedure occurrence

Alias
UMLS CUI-1
C0184661
UMLS CUI-2
C0087111
UMLS CUI-3
C2745955
Procedure occurrence ID
Beschrijving

A system-generated unique identifier for each procedure occurrence.

Datatype

integer

Alias
UMLS CUI [1,1]
C0184661
UMLS CUI [1,2]
C2745955
UMLS CUI [1,3]
C1300638
Person ID
Beschrijving

A foreign key identifier to the person for whom the visit is recorded. The demographic details of that person are stored in the person table.

Datatype

integer

Alias
UMLS CUI [1]
C2348585
Procedure concept ID
Beschrijving

A foreign key that refers to a standard procedure concept identifier in the Standardized Vocabularies.

Datatype

integer

Alias
UMLS CUI [1,1]
C0184661
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Procedure date
Beschrijving

The date on which the procedure was performed.

Datatype

date

Alias
UMLS CUI [1,1]
C0184661
UMLS CUI [1,2]
C0011008
Procedure type concept ID
Beschrijving

A foreign key to the predefined concept identifier in the Standardized Vocabularies reflecting the type of source data from which the procedure record is derived.

Datatype

integer

Alias
UMLS CUI [1,1]
C0184661
UMLS CUI [1,2]
C0332307
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Modifier concept ID
Beschrijving

A foreign key to a standard concept identifier for a modifier to the procedure (e.g. bilateral)

Datatype

integer

Alias
UMLS CUI [1,1]
C3542952
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Procedure quantity
Beschrijving

The quantity of procedures ordered or administered.

Datatype

integer

Alias
UMLS CUI [1,1]
C0184661
UMLS CUI [1,2]
C1265611
Provider ID
Beschrijving

A foreign key to the provider in the provider table who was associated with the visit.

Datatype

integer

Alias
UMLS CUI [1,1]
C1138603
UMLS CUI [1,2]
C1300638
Visit occurence ID
Beschrijving

A foreign key to the visit in the visit table during which the procedure was carried out.

Datatype

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C2745955
UMLS CUI [1,3]
C1300638
Procedure source value
Beschrijving

The source code for the procedure as it appears in the source data. This code is mapped to a standard procedure concept in the Standardized Vocabularies and the original code is, stored here for reference. Procedure source codes are typically ICD-9-Proc, CPT-4, HCPCS or OPCS-4 codes.

Datatype

text

Alias
UMLS CUI [1,1]
C0184661
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C1522609
Procedure source concept ID
Beschrijving

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

Datatype

integer

Alias
UMLS CUI [1,1]
C0184661
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Qualifier source value
Beschrijving

The source code for the qualifier as it appears in the source data.

Datatype

text

Alias
UMLS CUI [1,1]
C1514623
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C1522609
Terug naar het begin van de pagina

Similar models

OMOP Common Data Model (CDM) Procedure occurrence

1 Formulieren
Name
Type
Description | Question | Decode (Coded Value)
Datatype
Alias
Item Group
Procedure occurrence
C0184661 (UMLS CUI-1)
C0087111 (UMLS CUI-2)
C2745955 (UMLS CUI-3)
Procedure occurrence ID
Item
Procedure occurrence ID
integer
C0184661 (UMLS CUI [1,1])
C2745955 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Person ID
Item
Person ID
integer
C2348585 (UMLS CUI [1])
Procedure concept ID
Item
Procedure concept ID
integer
C0184661 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Procedure date
Item
Procedure date
date
C0184661 (UMLS CUI [1,1])
C0011008 (UMLS CUI [1,2])
Procedure type concept ID
Item
Procedure type concept ID
integer
C0184661 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Modifier concept ID
Item
Modifier concept ID
integer
C3542952 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Procedure quantity
Item
Procedure quantity
integer
C0184661 (UMLS CUI [1,1])
C1265611 (UMLS CUI [1,2])
Provider ID
Item
Provider ID
integer
C1138603 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Visit occurence ID
Item
Visit occurence ID
integer
C1512346 (UMLS CUI [1,1])
C2745955 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Procedure source value
Item
Procedure source value
text
C0184661 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C1522609 (UMLS CUI [1,3])
Procedure source concept ID
Item
Procedure source concept ID
integer
C0184661 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Qualifier source value
Item
Qualifier source value
text
C1514623 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C1522609 (UMLS CUI [1,3])
Terug naar het begin van de pagina