ID

19636

Description

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

Keywords

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

January 17, 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 consultation

University Hospital Essen consultation

Default Itemgroup
Description

Default Itemgroup

Konsultationsnummer
Description

awo         

Data type

text

Alias
UMLS CUI [1,1]
C0009818
UMLS CUI [1,2]
C0237753
Aufnahmenummer
Description

pat         

Data type

text

Alias
UMLS CUI [1,1]
C0030673
UMLS CUI [1,2]
C0237753
Datum von
Description

datf        

Data type

date

Alias
UMLS CUI [1]
C0011008
Datum bis
Description

datt        

Data type

date

Alias
UMLS CUI [1]
C0806020
Konsil
Description

consil  

Data type

integer

Alias
UMLS CUI [1]
C0009818
Überweisungsgrund
Description

adr         

Data type

text

Alias
UMLS CUI [1,1]
C0205543
UMLS CUI [1,2]
C0392360
Arztschluessel,Konsultation
Description

dic         

Data type

text

Alias
UMLS CUI [1]
C0009818
Zentrum
Description

cen         

Data type

text

Alias
UMLS CUI [1]
C0565990
Fachrichtung
Description

dep         

Data type

text

Alias
UMLS CUI [1]
C0037778
Station
Description

wds         

Data type

text

Alias
UMLS CUI [1]
C1305702
Zimmer
Description

rom         

Data type

text

Alias
UMLS CUI [1]
C0030707
Bettnummer
Description

bed

Data type

text

Alias
UMLS CUI [1]
C0004916
Bemerkung
Description

text        

Data type

text

Alias
UMLS CUI [1]
C0947611
Geplant
Description

planned     

Data type

integer

Alias
UMLS CUI [1,1]
C1301732
UMLS CUI [1,2]
C0009818
Wiedereinbest.datum
Description

pland       

Data type

date

Alias
UMLS CUI [1]
C3650862

Similar models

University Hospital Essen consultation

Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
awo         
Item
Konsultationsnummer
text
C0009818 (UMLS CUI [1,1])
C0237753 (UMLS CUI [1,2])
pat         
Item
Aufnahmenummer
text
C0030673 (UMLS CUI [1,1])
C0237753 (UMLS CUI [1,2])
datf        
Item
Datum von
date
C0011008 (UMLS CUI [1])
datt        
Item
Datum bis
date
C0806020 (UMLS CUI [1])
Item
Konsil
integer
C0009818 (UMLS CUI [1])
Code List
Konsil
CL Item
nein=Konsultation  (0)
CL Item
ja=Konsil (1)
adr         
Item
Überweisungsgrund
text
C0205543 (UMLS CUI [1,1])
C0392360 (UMLS CUI [1,2])
dic         
Item
Arztschluessel,Konsultation
text
C0009818 (UMLS CUI [1])
cen         
Item
Zentrum
text
C0565990 (UMLS CUI [1])
dep         
Item
Fachrichtung
text
C0037778 (UMLS CUI [1])
wds         
Item
Station
text
C1305702 (UMLS CUI [1])
rom         
Item
Zimmer
text
C0030707 (UMLS CUI [1])
bed
Item
Bettnummer
text
C0004916 (UMLS CUI [1])
text        
Item
Bemerkung
text
C0947611 (UMLS CUI [1])
Item
Geplant
integer
C1301732 (UMLS CUI [1,1])
C0009818 (UMLS CUI [1,2])
Code List
Geplant
CL Item
Konsultation noch nicht wahrgenommen (1)
CL Item
Konsultation wahrgenommen (0)
pland       
Item
Wiedereinbest.datum
date
C3650862 (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