ID

20096

Description

Hospital routine documentation models at the University Hospital Essen. Tables were derived from the Medico Information System. Original table name: Planauftraege

Keywords

  1. 2/6/17 2/6/17 -
Uploaded on

February 6, 2017

DOI

To request one please log in.

License

Creative Commons BY-NC 3.0

Model comments :

You can comment on the data model here. Via the speech bubbles at the itemgroups and items you can add comments to those specificially.

Itemgroup comments for :

Item comments for :

In order to download data models you must be logged in. Please log in or register for free.

University Hospital Essen planned interventional procedures

University Hospital Essen planned interventional procedures

Planauftraege
Description

Planauftraege

Alias
UMLS CUI-1
C0184661
UMLS CUI-2
C0543467
UMLS CUI-3
C1301732
Mandant
Description

cli

Data type

text

Alias
UMLS CUI [1,1]
C0008942
UMLS CUI [1,2]
C0030705
ID d.gepl.Eingriffs
Description

plo

Data type

text

Alias
UMLS CUI [1,1]
C0184661
UMLS CUI [1,2]
C1300638
Plan-Typ       
Description

pltyp

Data type

integer

Alias
UMLS CUI [1,1]
C1301732
UMLS CUI [1,2]
C0332307
Plan-Datum
Description

pldate

Data type

date

Alias
UMLS CUI [1,1]
C0011008
UMLS CUI [1,2]
C1301732
Termin-Typ       
Description

tmetyp

Data type

integer

Alias
UMLS CUI [1]
C0586344
OP-Saal
Description

opr

Data type

text

Alias
UMLS CUI [1]
C0029064
Position
Description

plseq

Data type

integer

Alias
UMLS CUI [1]
C0733755
Festgelegt a.Saal
Description

rfix

Data type

integer

Alias
UMLS CUI [1]
C0029064
Fachabteilung
Description

dep

Data type

text

Alias
UMLS CUI [1]
C0587450
Blutgruppe
Description

bgr

Data type

text

Alias
UMLS CUI [1]
C0005810
Vorbereitungszeit
Description

minprep

Data type

integer

Alias
UMLS CUI [1,1]
C0543467
UMLS CUI [1,2]
C1521827
Dauer der Sitzung
Description

minproc

Data type

integer

Alias
UMLS CUI [1,1]
C0543467
UMLS CUI [1,2]
C0449238
Nachbereitungszeit
Description

minafter

Data type

integer

Alias
UMLS CUI [1,1]
C0543467
UMLS CUI [1,2]
C0032790
UMLS CUI [1,3]
C0449238
Zeit Schnitt
Description

cuttme

Data type

time

Alias
UMLS CUI [1,1]
C0439659
UMLS CUI [1,2]
C0543467
Mehrfacheingriff
Description

plmulti

Data type

integer

Alias
UMLS CUI [1,1]
C0439064
UMLS CUI [1,2]
C0543467
Beginn-Zeitpunkt
Description

begtme

Data type

time

Alias
UMLS CUI [1,1]
C0543467
UMLS CUI [1,2]
C0439659
UMLS CUI [1,3]
C0040223
Ende-Zeitpunkt
Description

endtme

Data type

time

Alias
UMLS CUI [1,1]
C0543467
UMLS CUI [1,2]
C1272693
UMLS CUI [1,3]
C0040223
AN-Einleitungsdauer
Description

minanpre

Data type

integer

Alias
UMLS CUI [1,1]
C0002903
UMLS CUI [1,2]
C0449238
AN-Ausleitungsdauer
Description

minanpost

Data type

integer

Alias
UMLS CUI [1,1]
C0002903
UMLS CUI [1,2]
C0449238
Info AN-Prozesse
Description

Binärkombination:

Data type

integer

Alias
UMLS CUI [1,1]
C0002903
UMLS CUI [1,2]
C1533716

Similar models

University Hospital Essen planned interventional procedures

Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Planauftraege
C0184661 (UMLS CUI-1)
C0543467 (UMLS CUI-2)
C1301732 (UMLS CUI-3)
cli
Item
Mandant
text
C0008942 (UMLS CUI [1,1])
C0030705 (UMLS CUI [1,2])
plo
Item
ID d.gepl.Eingriffs
text
C0184661 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Item
Plan-Typ       
integer
C1301732 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
Code List
Plan-Typ       
CL Item
Vortagesplan (0)
CL Item
endgueltiger Plan (1)
CL Item
Plan fuer BAS (2)
pldate
Item
Plan-Datum
date
C0011008 (UMLS CUI [1,1])
C1301732 (UMLS CUI [1,2])
Item
Termin-Typ       
integer
C0586344 (UMLS CUI [1])
Code List
Termin-Typ       
CL Item
auf Abruf (0)
CL Item
nicht vor (1)
CL Item
terminiert (2)
opr
Item
OP-Saal
text
C0029064 (UMLS CUI [1])
plseq
Item
Position
integer
C0733755 (UMLS CUI [1])
Item
Festgelegt a.Saal
integer
C0029064 (UMLS CUI [1])
Code List
Festgelegt a.Saal
CL Item
False (0)
CL Item
True (1)
dep
Item
Fachabteilung
text
C0587450 (UMLS CUI [1])
bgr
Item
Blutgruppe
text
C0005810 (UMLS CUI [1])
minprep
Item
Vorbereitungszeit
integer
C0543467 (UMLS CUI [1,1])
C1521827 (UMLS CUI [1,2])
minproc
Item
Dauer der Sitzung
integer
C0543467 (UMLS CUI [1,1])
C0449238 (UMLS CUI [1,2])
minafter
Item
Nachbereitungszeit
integer
C0543467 (UMLS CUI [1,1])
C0032790 (UMLS CUI [1,2])
C0449238 (UMLS CUI [1,3])
cuttme
Item
Zeit Schnitt
time
C0439659 (UMLS CUI [1,1])
C0543467 (UMLS CUI [1,2])
Item
Mehrfacheingriff
integer
C0439064 (UMLS CUI [1,1])
C0543467 (UMLS CUI [1,2])
Code List
Mehrfacheingriff
CL Item
False (0)
CL Item
True (1)
begtme
Item
Beginn-Zeitpunkt
time
C0543467 (UMLS CUI [1,1])
C0439659 (UMLS CUI [1,2])
C0040223 (UMLS CUI [1,3])
endtme
Item
Ende-Zeitpunkt
time
C0543467 (UMLS CUI [1,1])
C1272693 (UMLS CUI [1,2])
C0040223 (UMLS CUI [1,3])
minanpre
Item
AN-Einleitungsdauer
integer
C0002903 (UMLS CUI [1,1])
C0449238 (UMLS CUI [1,2])
minanpost
Item
AN-Ausleitungsdauer
integer
C0002903 (UMLS CUI [1,1])
C0449238 (UMLS CUI [1,2])
Item
Info AN-Prozesse
integer
C0002903 (UMLS CUI [1,1])
C1533716 (UMLS CUI [1,2])
Code List
Info AN-Prozesse
CL Item
AN-Vorbereitung parallel (1)
CL Item
AN-Nachbereitung parallel (2)
CL Item
Saaleinstellung zu AN vom Saal übernehmen (4)
CL Item
ohne Anästhesie (8)

Please use this form for feedback, questions and suggestions for improvements.

Fields marked with * are required.

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