ID

19719

Description

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

Keywords

  1. 1/23/17 1/23/17 -
Uploaded on

January 23, 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 Order

University Hospital Essen Order

Auftrag
Description

Auftrag

Alias
UMLS CUI-1
C1705178
UMLS CUI-2
C1272683
Auftragsnummer
Description

ord

Data type

integer

Alias
UMLS CUI [1,1]
C1705178
UMLS CUI [1,2]
C1300638
Erbringende Station
Description

wdssrv

Data type

text

Alias
UMLS CUI [1,1]
C1305702
UMLS CUI [1,2]
C0884358
Erbringende Fachrichtung
Description

depsrv

Data type

text

Alias
UMLS CUI [1,1]
C0587450
UMLS CUI [1,2]
C0884358
Hauptauftrag
Description

Bei Folgeaufträgen die Nummer des Auftrags auf den sich dieser Auftrag bezieht

Data type

integer

Alias
UMLS CUI [1]
C1705178
Auftragsnummer extern
Description

ordext

Data type

text

Alias
UMLS CUI [1,1]
C1705178
UMLS CUI [1,2]
C1300638
Formular
Description

frm

Data type

text

Alias
UMLS CUI [1]
C3242370
Anfordernde Station
Description

wdscli      

Data type

text

Alias
UMLS CUI [1,1]
C1272683
UMLS CUI [1,2]
C1305702
Anfordernde Fachrichtung
Description

depcli

Data type

text

Alias
UMLS CUI [1,1]
C1272683
UMLS CUI [1,2]
C0587450
Patientennummer
Description

per

Data type

integer

Alias
UMLS CUI [1]
C1269815
Aufnahmenummer
Description

pat

Data type

text

Alias
UMLS CUI [1,1]
C0030673
UMLS CUI [1,2]
C1300638
Kliniksfallnummer
Description

can

Data type

integer

Alias
UMLS CUI [1,1]
C1698493
UMLS CUI [1,2]
C1300638
Auftragstatus
Description

sta

Data type

text

Alias
UMLS CUI [1]
C1550341
Auftragdatum
Description

ordd

Data type

datetime

Alias
UMLS CUI [1]
C1549499
Wunschdatum
Description

wishd

Data type

datetime

Alias
UMLS CUI [1,1]
C0871633
UMLS CUI [1,2]
C0011008
Freigabedatum
Description

freed

Data type

datetime

Alias
UMLS CUI [1,1]
C0011008
UMLS CUI [1,2]
C0205540
Freigabeuser
Description

freeuser

Data type

text

Alias
UMLS CUI [1]
C0205540
Arzt d. freigeben soll
Description

freedic

Data type

text

Alias
UMLS CUI [1,1]
C0031831
UMLS CUI [1,2]
C0027365
UMLS CUI [1,3]
C0205540
Patient infekt
Description

infekt

Data type

text

Alias
UMLS CUI [1]
C0030705
OP-Planung
Description

opmk

Data type

text

Alias
UMLS CUI [1,1]
C0543467
UMLS CUI [1,2]
C1301732
Dringlichkeit
Description

urg

Data type

text

Alias
UMLS CUI [1]
C2188401
Datum Anlage
Description

crd

Data type

datetime

Alias
UMLS CUI [1,1]
C0684224
UMLS CUI [1,2]
C1706214
UMLS CUI [1,3]
C0011008
User Anlage
Description

cruser

Data type

text

Alias
UMLS CUI [1,1]
C1707531
UMLS CUI [1,2]
C0684224
bel. Station
Description

wdsctr

Data type

text

Alias
UMLS CUI [1]
C1305702
bel. Fachrichtung
Description

depctr

Data type

text

Alias
UMLS CUI [1]
C0587450

Similar models

University Hospital Essen Order

Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Auftrag
C1705178 (UMLS CUI-1)
C1272683 (UMLS CUI-2)
ord
Item
Auftragsnummer
integer
C1705178 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
wdssrv
Item
Erbringende Station
text
C1305702 (UMLS CUI [1,1])
C0884358 (UMLS CUI [1,2])
depsrv
Item
Erbringende Fachrichtung
text
C0587450 (UMLS CUI [1,1])
C0884358 (UMLS CUI [1,2])
ordmain
Item
Hauptauftrag
integer
C1705178 (UMLS CUI [1])
ordext
Item
Auftragsnummer extern
text
C1705178 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
frm
Item
Formular
text
C3242370 (UMLS CUI [1])
wdscli      
Item
Anfordernde Station
text
C1272683 (UMLS CUI [1,1])
C1305702 (UMLS CUI [1,2])
depcli
Item
Anfordernde Fachrichtung
text
C1272683 (UMLS CUI [1,1])
C0587450 (UMLS CUI [1,2])
per
Item
Patientennummer
integer
C1269815 (UMLS CUI [1])
pat
Item
Aufnahmenummer
text
C0030673 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
can
Item
Kliniksfallnummer
integer
C1698493 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
sta
Item
Auftragstatus
text
C1550341 (UMLS CUI [1])
ordd
Item
Auftragdatum
datetime
C1549499 (UMLS CUI [1])
wishd
Item
Wunschdatum
datetime
C0871633 (UMLS CUI [1,1])
C0011008 (UMLS CUI [1,2])
freed
Item
Freigabedatum
datetime
C0011008 (UMLS CUI [1,1])
C0205540 (UMLS CUI [1,2])
freeuser
Item
Freigabeuser
text
C0205540 (UMLS CUI [1])
freedic
Item
Arzt d. freigeben soll
text
C0031831 (UMLS CUI [1,1])
C0027365 (UMLS CUI [1,2])
C0205540 (UMLS CUI [1,3])
infekt
Item
Patient infekt
text
C0030705 (UMLS CUI [1])
opmk
Item
OP-Planung
text
C0543467 (UMLS CUI [1,1])
C1301732 (UMLS CUI [1,2])
urg
Item
Dringlichkeit
text
C2188401 (UMLS CUI [1])
crd
Item
Datum Anlage
datetime
C0684224 (UMLS CUI [1,1])
C1706214 (UMLS CUI [1,2])
C0011008 (UMLS CUI [1,3])
cruser
Item
User Anlage
text
C1707531 (UMLS CUI [1,1])
C0684224 (UMLS CUI [1,2])
wdsctr
Item
bel. Station
text
C1305702 (UMLS CUI [1])
depctr
Item
bel. Fachrichtung
text
C0587450 (UMLS CUI [1])

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