ID

20088

Description

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

Keywords

Versions (1)
  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.

Back to model comments
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 medication information

German ( localization.languageCode.DE )

University Hospital Essen medication information

1 forms  
Medikamentendaten
Description

Medikamentendaten

Alias
UMLS CUI-1
C0013227
UMLS CUI-2
C1955348
lfd. Nummer pro pat
Description

no

Data type

integer

Alias
UMLS CUI [1,1]
C0260201
UMLS CUI [1,2]
C0920316
UMLS CUI [1,3]
C0237753
UMLS CUI [2]
C1955348
lfd. Nummer pro Rezept
Description

medno

Data type

integer

Alias
UMLS CUI [1,1]
C0260201
UMLS CUI [1,2]
C0920316
UMLS CUI [1,3]
C0237753
UMLS CUI [2]
C1521941
Dokumentennummer
Description

dre

Data type

integer

Alias
UMLS CUI [1,1]
C0920316
UMLS CUI [1,2]
C0237753
Rezepttyp
Description

psctype

Data type

integer

Alias
UMLS CUI [1,1]
C1521941
UMLS CUI [1,2]
C0332307
Fachrichtung
Description

dep

Data type

text

Alias
UMLS CUI [1]
C0587450
Station
Description

wds

Data type

text

Alias
UMLS CUI [1]
C1305702
ausstellender Arzt
Description

dic

Data type

text

Alias
UMLS CUI [1,1]
C3469597
UMLS CUI [1,2]
C1521941
UMLS CUI [1,3]
C1710470
Herkunft
Description

__IFAP = Uebernahme aus ifap __DATE = Uebernahme aus altem Rezept vom Typ __IFAP __DIACOS = Uebernahme aus Diacos __DATEDCS = Uebernahme aus altem Rezept vom Typ __DIACOS __HAND = manuell erfasst oder nach Uebernahme geaendert

Data type

text

Alias
UMLS CUI [1,1]
C1521941
UMLS CUI [1,2]
C0449689
PZN
Description

wenn origin = __HAND, ist die PZN leer

Data type

text

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C0920316
UMLS CUI [1,3]
C0237753
Bezeichnung
Description

des

Data type

text

Alias
UMLS CUI [1]
C2360065
Darreichungsform
Description

form

Data type

text

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C0013058
Packungsgroesse
Description

packsize

Data type

text

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C0013194
Mengeneinheit
Description

unit

Data type

text

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C1519795
Preis
Description

price

Data type

float

Alias
UMLS CUI [1]
C0680994
Hersteller
Description

producer

Data type

text

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C0947322
Festbetrag
Description

fixedsum

Data type

float

Alias
UMLS CUI [1]
C0680994
Betaeubungsmittel
Description

helpmk02    

Data type

text

Alias
UMLS CUI [1]
C0237425
Menge
Description

quantity

Data type

float

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C1265611
NP
Description

np

Data type

text

aut idem Kennung
Description

autidem

Data type

integer

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C0920316
UMLS CUI [1,3]
C0237753
Datum Originalrezept
Description

gefuellt bei origin = __DATE und DATEDCS

Data type

date

Alias
UMLS CUI [1,1]
C1521941
UMLS CUI [1,2]
C0011008
Back to the top of the page

Similar models

University Hospital Essen medication information

1 forms
Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Medikamentendaten
C0013227 (UMLS CUI-1)
C1955348 (UMLS CUI-2)
no
Item
lfd. Nummer pro pat
integer
C0260201 (UMLS CUI [1,1])
C0920316 (UMLS CUI [1,2])
C0237753 (UMLS CUI [1,3])
C1955348 (UMLS CUI [2])
medno
Item
lfd. Nummer pro Rezept
integer
C0260201 (UMLS CUI [1,1])
C0920316 (UMLS CUI [1,2])
C0237753 (UMLS CUI [1,3])
C1521941 (UMLS CUI [2])
dre
Item
Dokumentennummer
integer
C0920316 (UMLS CUI [1,1])
C0237753 (UMLS CUI [1,2])
psctype
Item
Rezepttyp
integer
C1521941 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
dep
Item
Fachrichtung
text
C0587450 (UMLS CUI [1])
wds
Item
Station
text
C1305702 (UMLS CUI [1])
dic
Item
ausstellender Arzt
text
C3469597 (UMLS CUI [1,1])
C1521941 (UMLS CUI [1,2])
C1710470 (UMLS CUI [1,3])
origin
Item
Herkunft
text
C1521941 (UMLS CUI [1,1])
C0449689 (UMLS CUI [1,2])
pzn
Item
PZN
text
C0013227 (UMLS CUI [1,1])
C0920316 (UMLS CUI [1,2])
C0237753 (UMLS CUI [1,3])
des
Item
Bezeichnung
text
C2360065 (UMLS CUI [1])
form
Item
Darreichungsform
text
C0013227 (UMLS CUI [1,1])
C0013058 (UMLS CUI [1,2])
packsize
Item
Packungsgroesse
text
C0013227 (UMLS CUI [1,1])
C0013194 (UMLS CUI [1,2])
unit
Item
Mengeneinheit
text
C0013227 (UMLS CUI [1,1])
C1519795 (UMLS CUI [1,2])
price
Item
Preis
float
C0680994 (UMLS CUI [1])
producer
Item
Hersteller
text
C0013227 (UMLS CUI [1,1])
C0947322 (UMLS CUI [1,2])
fixedsum
Item
Festbetrag
float
C0680994 (UMLS CUI [1])
helpmk02    
Item
Betaeubungsmittel
text
C0237425 (UMLS CUI [1])
quantity
Item
Menge
float
C0013227 (UMLS CUI [1,1])
C1265611 (UMLS CUI [1,2])
np
Item
NP
text
autidem
Item
aut idem Kennung
integer
C0013227 (UMLS CUI [1,1])
C0920316 (UMLS CUI [1,2])
C0237753 (UMLS CUI [1,3])
pscdatf
Item
Datum Originalrezept
date
C1521941 (UMLS CUI [1,1])
C0011008 (UMLS CUI [1,2])
Back to the top of the page 

Contact

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

Fields marked with * are required.

Help

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