ID

19714

Description

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

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 medical referral

University Hospital medical referral

Ueberweisungsschein/Belegartzschein
Description

Ueberweisungsschein/Belegartzschein

Alias
UMLS CUI-1
C0260201
UMLS CUI-2
C0920316
Scheinnummer
Description

ref

Data type

text

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

pat

Data type

text

Alias
UMLS CUI [1,1]
C0030673
UMLS CUI [1,2]
C1300638
Nummer, Ifd. , 1150
Description

stellt Bezug zur x1150cog her

Data type

text

Alias
UMLS CUI [1]
C0237753
Quartal
Description

Eintrag wie 1993/1

Data type

text

Alias
UMLS CUI [1]
C2825406
Scheintyp
Description

nur Ueberweisung oder Belegarztschein

Data type

text

Alias
UMLS CUI [1,1]
C0260201
UMLS CUI [1,2]
C0920316
Scheinuntergruppe
Description

cek

Data type

text

Alias
UMLS CUI [1,1]
C0260201
UMLS CUI [1,2]
C0920316
Nummer,lfd.
Description

Ifdno

Data type

text

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

dre

Data type

text

Alias
UMLS CUI [1]
C0920316
Ankreuzfeld Krankenvers. *3
Description

Art der KV auswählen

Data type

integer

Alias
UMLS CUI [1]
C0021672
kurativ
Description

cur

Data type

text

Alias
UMLS CUI [1]
C1276305
praeventiv
Description

prev

Data type

text

Alias
UMLS CUI [1,1]
C0199176
UMLS CUI [1,2]
C0679717
ESS
Description

bei Laborüberweisung ab Quartal 2012/1 0=ohne Angabe, 1=Empfängnisregelung,Sterilisation,Schwangerschaftsabbruch

Data type

integer

Ueberweisung an
Description

fad

Data type

text

Alias
UMLS CUI [1]
C0260201
Institut
Description

ins

Data type

text

Alias
UMLS CUI [1]
C1301943
Ueberweisung an
Description

aim

Data type

text

Alias
UMLS CUI [1]
C0260201
Antragsdatum Anerkennung
Description

Antragsdatum des Anerkennungsbescheids der Psychotherapie

Data type

datetime

Alias
UMLS CUI [1]
C0011008
Gueltigkeitsdauer
Description

vald

Data type

text

Alias
UMLS CUI [1,1]
C1519941
UMLS CUI [1,2]
C0449238
Diag. Verdacht Befund Medik.
Description

Ab Quartal 2/2011 Splittung des ursprünglichen Feldes Diagnose/Verdacht in zwei Inhalte Diagnose/Verdachtsdiagnose und Befund/Medikation Speicherung je max. 120 Zeichen XML-like wie folgt <7>Diagnose/Verdachtsdiagnose</7><8>Befund/Medikation</8> Übertragung von Diag./Ver.diag. in Feldkennung 4207 der Abrechnungsdatei Übertragung von Bef./Medik. in Feldkennung 4208 der Abrechnungsdatei

Data type

text

Alias
UMLS CUI [1]
C0011900
Auftrag
Description

text

Data type

text

Alias
UMLS CUI [1]
C1547859
Stationaere Behandlung
Description

patin

Data type

text

Alias
UMLS CUI [1]
C0019993
Bewilligte Leistung Nr.
Description

Bis Quartal 2005/1: Kennziffer O I./II. Ab Quartal 2005/2: Nr. der bewilligten Leistungen der Psychotherapie

Data type

text

Alias
UMLS CUI [1,1]
C0205540
UMLS CUI [1,2]
C0557854
Kennziffer O III.
Description

help02

Data type

text

Vertragsarzt-Nr. Erstveranlasser
Description

help03

Data type

text

Erstveranlasser
Description

help04

Data type

text

Bewilligte Leistung Anzahl
Description

Ab Quartal 2005/2: Anzahl der bewilligten Leistungen der Psychotherapie

Data type

text

Alias
UMLS CUI [1,1]
C0205540
UMLS CUI [1,2]
C0557854
Bel.Aerztl. Behandlung
Description

Ankreuzfeld: 0=ohne Angabe, 1=belegt

Data type

integer

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

Similar models

University Hospital medical referral

Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Ueberweisungsschein/Belegartzschein
C0260201 (UMLS CUI-1)
C0920316 (UMLS CUI-2)
ref
Item
Scheinnummer
text
C0260201 (UMLS CUI [1,1])
C0920316 (UMLS CUI [1,2])
C0237753 (UMLS CUI [1,3])
pat
Item
Aufnahmenummer
text
C0030673 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
no
Item
Nummer, Ifd. , 1150
text
C0237753 (UMLS CUI [1])
quart
Item
Quartal
text
C2825406 (UMLS CUI [1])
cet
Item
Scheintyp
text
C0260201 (UMLS CUI [1,1])
C0920316 (UMLS CUI [1,2])
cek
Item
Scheinuntergruppe
text
C0260201 (UMLS CUI [1,1])
C0920316 (UMLS CUI [1,2])
Ifdno
Item
Nummer,lfd.
text
C0260201 (UMLS CUI [1,1])
C0920316 (UMLS CUI [1,2])
C0237753 (UMLS CUI [1,3])
dre
Item
Dokumentennummer
text
C0920316 (UMLS CUI [1])
Item
Ankreuzfeld Krankenvers. *3
integer
C0021672 (UMLS CUI [1])
Code List
Ankreuzfeld Krankenvers. *3
CL Item
ohne Angabe  (0)
CL Item
AOK  (1)
CL Item
LKK  (2)
CL Item
BKK  (3)
CL Item
IKK  (4)
CL Item
VdAK  (5)
CL Item
AEV  (6)
CL Item
Knappschaft (7)
cur
Item
kurativ
text
C1276305 (UMLS CUI [1])
prev
Item
praeventiv
text
C0199176 (UMLS CUI [1,1])
C0679717 (UMLS CUI [1,2])
Item
ESS
integer
Code List
ESS
CL Item
ohne Angabe (0)
CL Item
Empfängnisregelung,Sterilisation,Schwangerschaftsabbruch (1)
fad
Item
Ueberweisung an
text
C0260201 (UMLS CUI [1])
ins
Item
Institut
text
C1301943 (UMLS CUI [1])
aim
Item
Ueberweisung an
text
C0260201 (UMLS CUI [1])
ufuntil
Item
Antragsdatum Anerkennung
datetime
C0011008 (UMLS CUI [1])
vald
Item
Gueltigkeitsdauer
text
C1519941 (UMLS CUI [1,1])
C0449238 (UMLS CUI [1,2])
diagnosis
Item
Diag. Verdacht Befund Medik.
text
C0011900 (UMLS CUI [1])
text
Item
Auftrag
text
C1547859 (UMLS CUI [1])
patin
Item
Stationaere Behandlung
text
C0019993 (UMLS CUI [1])
help01
Item
Bewilligte Leistung Nr.
text
C0205540 (UMLS CUI [1,1])
C0557854 (UMLS CUI [1,2])
help02
Item
Kennziffer O III.
text
help03
Item
Vertragsarzt-Nr. Erstveranlasser
text
help04
Item
Erstveranlasser
text
helpmk01
Item
Bewilligte Leistung Anzahl
text
C0205540 (UMLS CUI [1,1])
C0557854 (UMLS CUI [1,2])
Item
Bel.Aerztl. Behandlung
integer
Code List
Bel.Aerztl. Behandlung
CL Item
ohne Angabe (0)
CL Item
belegt (1)
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])

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