ID

19727

Description

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

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 Event

University Hospital Essen Event

Event
Description

Event

Alias
UMLS CUI-1
C0441471
UMLS CUI-2
C0184661
Vorgang
Description

eve

Data type

text

Alias
UMLS CUI [1,1]
C0441471
UMLS CUI [1,2]
C0184661
Hauptvorgang
Description

Hauptvorgang: zugehoeriger Vorgang. Sollte keiner existieren, ist sie gleich der eigenen Vorgangsnummer

Data type

text

Alias
UMLS CUI [1,1]
C0441471
UMLS CUI [1,2]
C0184661
Anforderer Fachr.
Description

clidep      

Data type

text

Alias
UMLS CUI [1,1]
C1272683
UMLS CUI [1,2]
C0587450
Anforderer Station
Description

cliwds

Data type

text

Alias
UMLS CUI [1,1]
C1272683
UMLS CUI [1,2]
C1305702
Erbringer Fachr.
Description

srvdep

Data type

text

Alias
UMLS CUI [1,1]
C0884358
UMLS CUI [1,2]
C0587450
Erbringer Station
Description

srvwds

Data type

text

Alias
UMLS CUI [1,1]
C0884358
UMLS CUI [1,2]
C1305702
Katalog
Description

cat

Data type

text

Alias
UMLS CUI [1]
C0376658
Untersuchung
Description

srv

Data type

text

Alias
UMLS CUI [1]
C0031809
Vorgangstyp
Description

Vorgangstyp: Definiert um welche Art von Vorgang es sich handelt

Data type

integer

Alias
UMLS CUI [1,1]
C0441471
UMLS CUI [1,2]
C0332307
Leistungstyp
Description

Leistungstyp: Definiert bei einer Leistung, um welche es sich handelt (Mapping)

Data type

integer

Alias
UMLS CUI [1,1]
C0557854
UMLS CUI [1,2]
C0332307
Beginn
Description

datf

Data type

datetime

Alias
UMLS CUI [1]
C0011008
Ende
Description

datt

Data type

datetime

Alias
UMLS CUI [1]
C0011008
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
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

Similar models

University Hospital Essen Event

Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Event
C0441471 (UMLS CUI-1)
C0184661 (UMLS CUI-2)
eve
Item
Vorgang
text
C0441471 (UMLS CUI [1,1])
C0184661 (UMLS CUI [1,2])
evemain
Item
Hauptvorgang
text
C0441471 (UMLS CUI [1,1])
C0184661 (UMLS CUI [1,2])
clidep      
Item
Anforderer Fachr.
text
C1272683 (UMLS CUI [1,1])
C0587450 (UMLS CUI [1,2])
cliwds
Item
Anforderer Station
text
C1272683 (UMLS CUI [1,1])
C1305702 (UMLS CUI [1,2])
srvdep
Item
Erbringer Fachr.
text
C0884358 (UMLS CUI [1,1])
C0587450 (UMLS CUI [1,2])
srvwds
Item
Erbringer Station
text
C0884358 (UMLS CUI [1,1])
C1305702 (UMLS CUI [1,2])
cat
Item
Katalog
text
C0376658 (UMLS CUI [1])
srv
Item
Untersuchung
text
C0031809 (UMLS CUI [1])
Item
Vorgangstyp
integer
C0441471 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
Code List
Vorgangstyp
CL Item
Ticket  (0 )
CL Item
Serie  (1 )
CL Item
Gruppentermin  (2 )
CL Item
Leistungspaket  (3 )
CL Item
Leistung  (4 )
CL Item
Sperre  (5 )
CL Item
Auftrag  (6 )
CL Item
Platzhalter  (7 )
CL Item
Hinweis (8 )
Item
Leistungstyp
integer
C0557854 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
Code List
Leistungstyp
CL Item
ohne Mapping  (0 )
CL Item
Leistung der alten Leistungsstelle  (1 )
CL Item
Bettenbelegung  (2 )
CL Item
Radiologie  (3 )
CL Item
OP  (4 )
CL Item
geplante Verlegungen  (5 )
CL Item
Bettensperre (bei Vorgangstyp = Sperre) (6 )
datf
Item
Beginn
datetime
C0011008 (UMLS CUI [1])
datt
Item
Ende
datetime
C0011008 (UMLS CUI [1])
per
Item
Patientennummer
integer
C1269815 (UMLS CUI [1])
pat
Item
Aufnahmenummer
text
C0030673 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
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])

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