ID

19717

Description

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

Keywords

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

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 Material (B)

German ( localization.languageCode.DE )

University Hospital Essen Material (B)

1 forms  
Material (B)
Description

Material (B)

Alias
UMLS CUI-1
C1875802
UMLS CUI-2
C0520510
Schluessel
Description

opm

Data type

text

Massnahme
Description

ser

Data type

text

Alias
UMLS CUI [1]
C0441472
Kliniksfallnummer
Description

can

Data type

text

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

Interne Artikelnummer

Data type

integer

Alias
UMLS CUI [1,1]
C1875802
UMLS CUI [1,2]
C0237753
Artikelgruppe
Description

zu beachten: artgrp entspricht nicht artgrp in den Artikeltabellen, artgrp wird hier nur für die Verteilung auf die unterschiedlichen Folder benoetigt; Standardbelegung (kann beim Kunden anders sein) PFL: 0: Material, 2: Implantate, 3: Spuelung 98: Siebe, 99: Sets AOP: 100: Material, 102: Gase

Data type

integer

Alias
UMLS CUI [1]
C1875802
Anzahl
Description

no

Data type

integer

Alias
UMLS CUI [1]
C0449788
Menge
Description

amnt

Data type

integer

Alias
UMLS CUI [1]
C1265611
Masseinheit
Description

uni

Data type

text

Alias
UMLS CUI [1]
C1519795
Chargennummer
Description

auch Sterilisationsnummer bei Siebbestandteilen

Data type

text

Alias
UMLS CUI [1]
C2986223
Anordnungsdatum
Description

verorddat

Data type

datetime

Alias
UMLS CUI [1,1]
C0011008
UMLS CUI [1,2]
C1272683
Anordnungspersonal
Description

verordpsr

Data type

text

Alias
UMLS CUI [1,1]
C1272683
UMLS CUI [1,2]
C0027361
Anfangszeit
Description

datf

Data type

datetime

Alias
UMLS CUI [1,1]
C0439659
UMLS CUI [1,2]
C0040223
Endezeit
Description

datt

Data type

datetime

Alias
UMLS CUI [1,1]
C1272693
UMLS CUI [1,2]
C0040223
Siebtyp
Description

sit

Data type

text

Alias
UMLS CUI [1,1]
C0184061
UMLS CUI [1,2]
C1547771
Settyp
Description

stt

Data type

text

Alias
UMLS CUI [1,1]
C1875802
UMLS CUI [1,2]
C0332307
Uebertragungsdat. MAWI
Description

datmawi

Data type

datetime

Alias
UMLS CUI [1]
C0011008
GTIN
Description

Global Trade Item Number: internationale Artikelnummer

Data type

text

Alias
UMLS CUI [1,1]
C0184061
UMLS CUI [1,2]
C1300638
Anlage Datum
Description

crd

Data type

datetime

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

cruser

Data type

text

Alias
UMLS CUI [1,1]
C1707531
UMLS CUI [1,2]
C0684224
Back to the top of the page

Similar models

University Hospital Essen Material (B)

1 forms
Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Material (B)
C1875802 (UMLS CUI-1)
C0520510 (UMLS CUI-2)
opm
Item
Schluessel
text
ser
Item
Massnahme
text
C0441472 (UMLS CUI [1])
can
Item
Kliniksfallnummer
text
C1698493 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
art
Item
Artikelnr
integer
C1875802 (UMLS CUI [1,1])
C0237753 (UMLS CUI [1,2])
artgrp
Item
Artikelgruppe
integer
C1875802 (UMLS CUI [1])
no
Item
Anzahl
integer
C0449788 (UMLS CUI [1])
amnt
Item
Menge
integer
C1265611 (UMLS CUI [1])
uni
Item
Masseinheit
text
C1519795 (UMLS CUI [1])
charge
Item
Chargennummer
text
C2986223 (UMLS CUI [1])
verorddat
Item
Anordnungsdatum
datetime
C0011008 (UMLS CUI [1,1])
C1272683 (UMLS CUI [1,2])
verordpsr
Item
Anordnungspersonal
text
C1272683 (UMLS CUI [1,1])
C0027361 (UMLS CUI [1,2])
datf
Item
Anfangszeit
datetime
C0439659 (UMLS CUI [1,1])
C0040223 (UMLS CUI [1,2])
datt
Item
Endezeit
datetime
C1272693 (UMLS CUI [1,1])
C0040223 (UMLS CUI [1,2])
sit
Item
Siebtyp
text
C0184061 (UMLS CUI [1,1])
C1547771 (UMLS CUI [1,2])
stt
Item
Settyp
text
C1875802 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
datmawi
Item
Uebertragungsdat. MAWI
datetime
C0011008 (UMLS CUI [1])
gtin
Item
GTIN
text
C0184061 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
crd
Item
Anlage Datum
datetime
C0684224 (UMLS CUI [1,1])
C1706214 (UMLS CUI [1,2])
C0011008 (UMLS CUI [1,3])
cruser
Item
Anlage User
text
C1707531 (UMLS CUI [1,1])
C0684224 (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