ID

20092

Description

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

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 personnel information

German ( localization.languageCode.DE )

University Hospital Essen personnel information

1 forms  
Personenstamm
Description

Personenstamm

Alias
UMLS CUI-1
C1955348
Patientennummer
Description

per

Data type

integer

Alias
UMLS CUI [1]
C1269815
Personenkennziffer
Description

kann z.B die Bundeswehrnummer sein

Data type

text

Alias
UMLS CUI [1,1]
C0027361
UMLS CUI [1,2]
C1300638
Sozialversicherungsnummer
Description

wird von der Rentenanstalt vergeben

Data type

text

Alias
UMLS CUI [1]
C1301821
Geburtsdatum
Description

birthd

Data type

date

Alias
UMLS CUI [1]
C0421451
Geburtsname
Description

Pflichtfeld in Patientenaufnahme

Data type

text

Alias
UMLS CUI [1,1]
C1299487
UMLS CUI [1,2]
C0806887
Nation,Geburtsort
Description

mnat

Data type

text

Alias
UMLS CUI [1]
C0032040
Geburtsort
Description

mcity

Data type

text

Alias
UMLS CUI [1]
C0032040
Sterbedatum
Description

deathd

Data type

date

Alias
UMLS CUI [1,1]
C0011008
UMLS CUI [1,2]
C0011065
Familienname,Vorname
Description

namechr     

Data type

text

Alias
UMLS CUI [1]
C1299487
Familienname
Description

name

Data type

text

Alias
UMLS CUI [1]
C0421448
Vorname
Description

chr

Data type

text

Alias
UMLS CUI [1]
C1299487
Familienname,Vorname,norm.
Description

namechrnorm

Data type

text

Alias
UMLS CUI [1]
C1299487
Namenszusatz
Description

Das Feld pname wird allgemein fuer den Namenszusatz verwendet. Im UI taucht der Begriff Kuenstlername also nicht auf. Das Feld nameadd wird nur von der eGK befuellt.

Data type

text

Alias
UMLS CUI [1]
C1299487
Name Vorsatzwort
Description

prename     

Data type

text

Alias
UMLS CUI [1]
C1299487
Kuenstlername
Description

Das Feld pname wird allgemein fuer den Namenszusatz verwendet. Im UI taucht der Begriff Kuenstlername also nicht auf. Das Feld nameadd wird nur von der eGK befuellt.

Data type

text

Alias
UMLS CUI [1]
C1299487
Familienname,Vorname,soundex
Description

soundex wird nur bis zum ersten nicht-alphabetischen Zeichen berechnet

Data type

text

Alias
UMLS CUI [1]
C1299487
Kuenstlername,soundex
Description

soundex wird nur bis zum ersten nicht-alphabetischen Zeichen berechnet

Data type

text

Alias
UMLS CUI [1]
C1299487
Nation,Staatsangehoerigkeit
Description

nation

Data type

text

Alias
UMLS CUI [1]
C0027473
Anrede
Description

sal

Data type

text

Alias
UMLS CUI [1]
C0421450
Titel
Description

title

Data type

text

Alias
UMLS CUI [1]
C0421450
Strasse
Description

street

Data type

text

Alias
UMLS CUI [1,1]
C1301826
UMLS CUI [1,2]
C0421449
Hausnummer
Description

hausnr

Data type

text

Alias
UMLS CUI [1,1]
C2825563
UMLS CUI [1,2]
C0421449
Strasse2,Anschriftenzusatz
Description

street2

Data type

text

Alias
UMLS CUI [1,1]
C1301826
UMLS CUI [1,2]
C0421449
Nation,Postanschrift
Description

nat

Data type

text

Alias
UMLS CUI [1]
C0421449
PLZ,Postanschrift
Description

zip

Data type

text

Alias
UMLS CUI [1]
C0421449
Ort,Postanschrift
Description

city

Data type

text

Alias
UMLS CUI [1]
C0421449
Postfach
Description

postfach

Data type

text

Alias
UMLS CUI [1]
C0421449
Telefonnummer
Description

phone

Data type

text

Alias
UMLS CUI [1]
C1515258
E-Mail-Adresse
Description

email

Data type

text

Alias
UMLS CUI [1]
C0013849
Back to the top of the page

Similar models

University Hospital Essen personnel information

1 forms
Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Personenstamm
C1955348 (UMLS CUI-1)
per
Item
Patientennummer
integer
C1269815 (UMLS CUI [1])
perscode    
Item
Personenkennziffer
text
C0027361 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
socinscode  
Item
Sozialversicherungsnummer
text
C1301821 (UMLS CUI [1])
birthd
Item
Geburtsdatum
date
C0421451 (UMLS CUI [1])
mname
Item
Geburtsname
text
C1299487 (UMLS CUI [1,1])
C0806887 (UMLS CUI [1,2])
mnat
Item
Nation,Geburtsort
text
C0032040 (UMLS CUI [1])
mcity
Item
Geburtsort
text
C0032040 (UMLS CUI [1])
deathd
Item
Sterbedatum
date
C0011008 (UMLS CUI [1,1])
C0011065 (UMLS CUI [1,2])
namechr     
Item
Familienname,Vorname
text
C1299487 (UMLS CUI [1])
name
Item
Familienname
text
C0421448 (UMLS CUI [1])
chr
Item
Vorname
text
C1299487 (UMLS CUI [1])
namechrnorm
Item
Familienname,Vorname,norm.
text
C1299487 (UMLS CUI [1])
nameadd     
Item
Namenszusatz
text
C1299487 (UMLS CUI [1])
prename     
Item
Name Vorsatzwort
text
C1299487 (UMLS CUI [1])
pname
Item
Kuenstlername
text
C1299487 (UMLS CUI [1])
namechrsound
Item
Familienname,Vorname,soundex
text
C1299487 (UMLS CUI [1])
pnamesound  
Item
Kuenstlername,soundex
text
C1299487 (UMLS CUI [1])
nation
Item
Nation,Staatsangehoerigkeit
text
C0027473 (UMLS CUI [1])
sal
Item
Anrede
text
C0421450 (UMLS CUI [1])
title
Item
Titel
text
C0421450 (UMLS CUI [1])
street
Item
Strasse
text
C1301826 (UMLS CUI [1,1])
C0421449 (UMLS CUI [1,2])
hausnr
Item
Hausnummer
text
C2825563 (UMLS CUI [1,1])
C0421449 (UMLS CUI [1,2])
street2
Item
Strasse2,Anschriftenzusatz
text
C1301826 (UMLS CUI [1,1])
C0421449 (UMLS CUI [1,2])
nat
Item
Nation,Postanschrift
text
C0421449 (UMLS CUI [1])
zip
Item
PLZ,Postanschrift
text
C0421449 (UMLS CUI [1])
city
Item
Ort,Postanschrift
text
C0421449 (UMLS CUI [1])
postfach
Item
Postfach
text
C0421449 (UMLS CUI [1])
phone
Item
Telefonnummer
text
C1515258 (UMLS CUI [1])
email
Item
E-Mail-Adresse
text
C0013849 (UMLS CUI [1])
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