ID

19726

Description

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

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 clinic cases

University Hospital Essen clinic cases

Kliniksfaelle
Description

Kliniksfaelle

Alias
UMLS CUI-1
C1698493
Kliniksfallnummer
Description

can

Data type

integer

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

pat         

Data type

text

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

not null, eventuell fuer Tuning

Data type

integer

Alias
UMLS CUI [1]
C1269815
Fachrichtung
Description

dep

Data type

text

Alias
UMLS CUI [1]
C0587450
Anzahl der Operationen
Description

noop

Data type

text

Alias
UMLS CUI [1,1]
C0543467
UMLS CUI [1,2]
C0449788
Diagnose Abschluss kz
Description

mkclose

Data type

integer

Alias
UMLS CUI [1,1]
C0011900
UMLS CUI [1,2]
C0030685
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
Datum-Von
Description

datf        

Data type

datetime

Alias
UMLS CUI [1]
C0011008
Datum-Bis
Description

datt

Data type

datetime

Alias
UMLS CUI [1]
C0011008

Similar models

University Hospital Essen clinic cases

Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Kliniksfaelle
C1698493 (UMLS CUI-1)
can
Item
Kliniksfallnummer
integer
C1698493 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
pat         
Item
Aufnahmenummer
text
C0030673 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
per
Item
Patientennummer
integer
C1269815 (UMLS CUI [1])
dep
Item
Fachrichtung
text
C0587450 (UMLS CUI [1])
noop
Item
Anzahl der Operationen
text
C0543467 (UMLS CUI [1,1])
C0449788 (UMLS CUI [1,2])
Item
Diagnose Abschluss kz
integer
C0011900 (UMLS CUI [1,1])
C0030685 (UMLS CUI [1,2])
Code List
Diagnose Abschluss kz
CL Item
nein (0)
CL Item
ja, d.h. falls Entlassdiagnose vorhanden ist, kann dieses Kz. gesetzt werden (manuell) (1)
CL Item
nein, Kennzeichen wurde wieder zurueckgesetzt und Aenderungen werden protokolliert (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])
datf        
Item
Datum-Von
datetime
C0011008 (UMLS CUI [1])
datt
Item
Datum-Bis
datetime
C0011008 (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