ID

27759

Description

Documentation form for quality assurance in German Health Care by the institute forapplied quality Improvement and Research in Health Care (Aqua), https://www.aqua-institut.de/en/home. Internal Aqua form version: NLS Specification 2015 V02

Link

https://www.aqua-institut.de/en/home

Keywords

  1. 11/28/17 11/28/17 - Julian Varghese
  2. 4/10/21 4/10/21 - Ahmed Rafee, MD
Copyright Holder

AQUA institute

Uploaded on

November 28, 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.

Quality assurance Living Donor Renal Transplant (AQUA)

Quality assurance Living Donor Renal Transplant (AQUA)

Basic documentation
Description

Basic documentation

Healthcare facility Identifier
Description

Institutionskennzeichen

Data type

integer

Alias
UMLS CUI-1
Code finden
Zip Code of Discharge
Description

Entlassender Standort

Data type

text

Alias
UMLS CUI-1
Code finden
Facility's Section Identifier
Description

Betriebsstätten-Nummer

Data type

text

Alias
UMLS CUI-1
Code finden
Admission date (dd.mm.yyyy)
Description

Aufnahmedatum Krankenhaus

Data type

date

Alias
UMLS CUI-1
Code finden
Medical specialty
Description

Fachabteilung

Data type

integer

Alias
UMLS CUI-1
Code finden
Donor ID (ET-Number)
Description

Spender ID

Data type

integer

Alias
UMLS CUI-1
m
Date of Birth (DD.MM.YYYY)
Description

Geburtsdatum

Data type

date

Alias
UMLS CUI-1
Code finden
Gender
Description

Geschlecht

Data type

integer

Alias
UMLS CUI-1
Code finden
Body Height (in cm)
Description

Körpergröße

Data type

integer

Measurement units
  • cm
Alias
UMLS CUI-1
Code finden
cm
Body weight at admission time (in kg)
Description

Körpergewicht bei Aufnahme

Data type

integer

Measurement units
  • kg
Alias
UMLS CUI-1
Code finden
kg
Case history
Description

Case history

Preoperative arterial hypertension
Description

arterielle Hypertonie präoperativ

Data type

boolean

Alias
UMLS CUI-1
Code finden
Serum creatinine level (in mg/dl)
Description

Kreatininwert i.S. in mg/dl

Data type

integer

Measurement units
  • mg/dl
Alias
UMLS CUI-1
Code finden
mg/dl
Serum creatinine level(in µmol/l)
Description

Kreatininwert i.S. in µmol/l

Data type

integer

Measurement units
  • µmol/l
µmol/l
Surgery
Description

Surgery

Surgical operation date
Description

OP-Datum

Data type

date

Alias
UMLS CUI-1
Code finden
Procedure codes
Description

Operation

Data type

integer

Alias
UMLS CUI-1
Code finden
Procedure Duration (in minutes)
Description

Dauer des Eingriffs

Data type

integer

Measurement units
  • minutes
Alias
UMLS CUI-1
Code finden
minutes
Progress
Description

Progress

intra/postoperative (severe) complications requiring action
Description

behandlungsbedürftige (schwere) intra- oder postoperative Komplikation(en)

Data type

boolean

Alias
UMLS CUI-1
Code finden
UMLS CUI-2
Code finden
Hemorrhage
Description

Blutung

Data type

integer

Alias
UMLS CUI-1
Code finden
Required surgical revision
Description

Reoperation erforderlich

Data type

integer

Alias
UMLS CUI-1
Code finden
Other complication
Description

sonstige Komplikationen

Data type

integer

Alias
UMLS CUI-1
Code finden
Discharge
Description

Discharge

Donor is dependent on renal dialysis at discharge
Description

Spender bei Entlassung dialysepflichtig?

Data type

boolean

Alias
UMLS CUI-1
m
Serum creatinine level (in mg/dl) at discharge
Description

Kreatininwert i.S. in mg/dl

Data type

integer

Measurement units
  • mg/dl
Alias
UMLS CUI-1
Code finden
mg/dl
Serum creatinine level(in µmol/l) at discharge
Description

Kreatininwert i.S. in µmol/l

Data type

integer

Measurement units
  • µmol/l
µmol/l
Urine albumin Level (in mg/l)
Description

Albumin i. U.

Data type

integer

Measurement units
  • mg/l
Alias
UMLS CUI-1
Code finden
mg/l
Urine albumin/creatinine ratio measurement (in mg/g)
Description

Albumin-Kreatinin-Verhältnis i. U.

Data type

integer

Measurement units
  • mg/g
Alias
UMLS CUI-1
Code finden
mg/g
Arterial hypertension at discharge
Description

arterielle Hypertonie

Data type

boolean

Alias
UMLS CUI-1
Code finden
Hostpital discharge date (DD.MM.YYYY)
Description

Entlassungsdatum Krankenhaus

Data type

date

Alias
UMLS CUI-1
Code finden
Discharge diagnosis/es
Description

Entlassungsdiagnose(n)

Data type

integer

Alias
UMLS CUI-1
Code finden
Reason for discharge
Description

Entlassungsgrund

Data type

integer

Cause of Death
Description

Todesursache

Data type

integer

Alias
UMLS CUI-1
Code finden

Similar models

Quality assurance Living Donor Renal Transplant (AQUA)

Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Basic documentation
Institutionskennzeichen
Item
Healthcare facility Identifier
integer
Code finden (UMLS CUI-1)
Entlassender Standort
Item
Zip Code of Discharge
text
Code finden (UMLS CUI-1)
Betriebsstätten-Nummer
Item
Facility's Section Identifier
text
Code finden (UMLS CUI-1)
Aufnahmedatum Krankenhaus
Item
Admission date (dd.mm.yyyy)
date
Code finden (UMLS CUI-1)
Item
Medical specialty
integer
Code finden (UMLS CUI-1)
Code List
Medical specialty
CL Item
internal medicine (0100)
CL Item
internal medicine: geriatrics (0102)
CL Item
internal medicine: cardiology (0103)
CL Item
internal medicine: nephrology (0104)
CL Item
internal medicine: hematology and internal oncology  (0105)
CL Item
internal medicine: endocrinology (0106)
CL Item
internal medicine: gastroenterology  (0107)
CL Item
internal medicine: pneumonology (0108)
CL Item
internal medicine: rheumatology (0109)
CL Item
internal medicine: pulmonology (0114)
CL Item
internal medicine: tumor research (0150)
CL Item
internal medicine: coloproctology (0151)
CL Item
internal medicine: infectiology (0152)
CL Item
internal medicine: diabetes (0153)
CL Item
internal medicine: naturopathy (0154)
CL Item
internal medicine: stroke unit (0156)
CL Item
internal medicine (0190)
CL Item
geriatry (0200)
CL Item
geriatry: gynecology  (0224)
CL Item
geriatry: day unit (for semi-residential care)  (0260)
CL Item
geriaty: night unit (for semi-residential care) (0261)
CL Item
geriatry (0290)
CL Item
cardiology (0300)
CL Item
nephrology (0400)
CL Item
nephrology: pediatrics (0410)
CL Item
nephrology: intensive care (0436)
CL Item
nephrology (0490)
CL Item
hematology and internal oncology  (0500)
CL Item
hematology and internal oncology: pediatrics (0510)
CL Item
hematology and internal oncology: gynacology (0524)
CL Item
hematology and internal oncology: radiation therapy (0533)
CL Item
hematology and internal oncology  (0590)
CL Item
endocrinology (0600)
CL Item
endicrinology: gastroenterology (0607)
CL Item
endocrinology: pediatrics (0610)
CL Item
endocrinology (0690)
CL Item
gastroenterology (0700)
CL Item
gastroenterology: endocrinology (0706)
CL Item
gastroenterology: pediatrics (0710)
CL Item
gastroenterology (0790)
CL Item
pneumology (0800)
CL Item
rheumatology (0900)
CL Item
rheumatology: pediatrics (0910)
CL Item
rheumatology (0990)
CL Item
pediatrics (1000)
CL Item
pediatrics: nephrology (1004)
CL Item
pediatrics: hematology and internal oncology  (1005)
CL Item
pediatrics: endocrinology (1006)
CL Item
pediatrics: gastroenterology (1007)
CL Item
pediatrics: rheumatology (1009)
CL Item
pediatrics: pediatric cardiology (1011)
CL Item
pediatrics: nephrology (1012)
CL Item
pediatrics: pulmonology (1014)
CL Item
pediatrics: pediatric neurology (1028)
CL Item
pediatrics: perinatal medicine (1050)
CL Item
continuing care for children (1051)
CL Item
pediatrics (1090)
CL Item
pediatric cardiology (1100)
CL Item
pediatric cardiology: intensive care (1136)
CL Item
pediatric cardiology (1190)
CL Item
neonatology (1200)
CL Item
pediatric surgery (1300)
CL Item
pulmonology (1400)
CL Item
pulmonology: pediatrics (1410)
CL Item
pulmonology (1490)
CL Item
general surgery (1500)
CL Item
general surgery: pediatric surgery (1513)
CL Item
general surgery: trauma surgery (1516)
CL Item
general surgery: vascular surgery (1518)
CL Item
general surgery: plastic surgery (1519)
CL Item
general surgery: thoracic surgery (1520)
CL Item
general surgery: orthopedics (1523)
CL Item
general surgery: intensive care (1536)
CL Item
general surgery: abdominal- and vascular surgery (1550)
CL Item
Allgemeine Chirurgie: hand surgery (1551)
CL Item
general surgery (1590)
CL Item
trauma surgery (1600)
CL Item
neurosurgery (1700)
CL Item
vascular surgery (1800)
CL Item
plastic surgery (1900)
CL Item
thoracic surgery (2000)
CL Item
thoracic surgery: cardiac surgery (2021)
CL Item
thoracic surgery: intensive care (2036)
CL Item
thoracic surgery: cardiac surgery intensive care (2050)
CL Item
thoracic surgery (2090)
CL Item
cardiac surgery (2100)
CL Item
cardiac surgery: vascular surgery (2118)
CL Item
cardiac surgery: thoracic surgery (2120)
CL Item
cardiac surgery: intensive care (2136)
CL Item
cardiac surgery: thoracic surgery and intensive care (2150)
CL Item
cardiac surgery (2190)
CL Item
urology (2200)
CL Item
orthopedics (2300)
CL Item
orthopedics: rheumatology (2309)
CL Item
orthopedics: surgery (2315)
CL Item
orthopedics and trauma surgery (2316)
CL Item
orthopedics (2390)
CL Item
gynecology and obstetrics (2400)
CL Item
gynecology: geriatry (2402)
CL Item
gynecology: hematology and internal oncology  (2405)
CL Item
gynecology: endocrinology (2406)
CL Item
gynecology (2425)
CL Item
gynecology and obstetrics (2490)
CL Item
obstetrics (2500)
CL Item
otolaryngology (2600)
CL Item
ophthalmology (2700)
CL Item
neurology: (2800)
CL Item
neurology: pediatrics (2810)
CL Item
neurology: stroke units (2856)
CL Item
neurology (2890)
CL Item
general psychiatry: (2900)
CL Item
general psychiatry: neurology (2928)
CL Item
general psychiatry: child and adolescent psychiatry (2930)
CL Item
general psychiatry: psychosomatics and psychotherapy (2931)
CL Item
general psychiatry: addiction treatment (2950)
CL Item
general psychiatry: geropsychiatry (2951)
CL Item
general psychiatry: forensic treatment (2952)
CL Item
general psychiatry: addiction treatment (day unit) (2953)
CL Item
general psychiatry: addiction treatment (night unit) (2954)
CL Item
general psychiatry: geropsychiatry (day unit) (2955)
CL Item
general psychiatry: geropsychiatry (night unit) (2956)
CL Item
general psychiatry: day unit (for semi-residential care) (2960)
CL Item
general psychiatry: night unit (for semi-residential care) (2961)
CL Item
general psychiatry (2990)
CL Item
child and adolescent psychiatry (3000)
CL Item
child and adolescent psychiatry: day unit (for semi-residential care) (3060)
CL Item
child and adolescent psychiatry: night unit (for semi-residential care) (3061)
CL Item
child and adolescent psychiatry (3090)
CL Item
psychosomatic/psychotherapy (3100)
CL Item
psychosomatic/psychotherapy: child and adolescent psychiatry (3110)
CL Item
psychosomatic/psychotherapy: day unit (for semi-residential care) (3160)
CL Item
psychosomatic/psychotherapy: night unit (for semi-residential care) (3161)
CL Item
psychosomatic/psychotherapy (3190)
CL Item
nuclear medicine (3200)
CL Item
nuclear medicine: radiation therapy (3233)
CL Item
nuclear medicine (3290)
CL Item
radiation therapy (3300)
CL Item
radiation therapy: hematology and internal oncology  (3305)
CL Item
radiation therapy: radiology (3350)
CL Item
radiation therapy (3390)
CL Item
dermatology (3400)
CL Item
dermatology: day unit (for semi-residential care) (3460)
CL Item
dermatology (3490)
CL Item
dentistry, orthodontics, maxillofacial surgery (3500)
CL Item
intensive-care medicine (3600)
CL Item
intensive-care medicine: internal medicine (3601)
CL Item
intensive-care medicine: cardiology (3603)
CL Item
intensive-care medicine: pediatrics (3610)
CL Item
intensive-care medicine: neurosurgery (3617)
CL Item
intensive-care medicine: surgery (3618)
CL Item
intensive-care medicine: cardiac surgery (3621)
CL Item
intensive-care medicine: urology (3622)
CL Item
intensive-care medicine: gynecology and obstetrics (3624)
CL Item
intensive-care medicine: otolaryngology  (3626)
CL Item
intensive-care medicine: neurology (3628)
CL Item
operative intensive-care medicine: surgery (3650)
CL Item
intensive-care medicine: thorax-heart surgery (3651)
CL Item
intensive-care medicine: heart-thorax surgery (3652)
CL Item
intensive-care medicine (3690)
CL Item
other medical specialty (3700)
CL Item
angiology (3750)
CL Item
radiology (3751)
CL Item
palliative care (3752)
CL Item
pain therapy (3753)
CL Item
section for alternative health practice (3754)
CL Item
spinal surgery (3755)
CL Item
addiction medicine (3756)
CL Item
visceral surgery (3757)
CL Item
other medical specialty (3790)
Spender ID
Item
Donor ID (ET-Number)
integer
m (UMLS CUI-1)
Geburtsdatum
Item
Date of Birth (DD.MM.YYYY)
date
Code finden (UMLS CUI-1)
Item
Gender
integer
Code finden (UMLS CUI-1)
Code List
Gender
CL Item
male (1)
CL Item
female (2)
Körpergröße
Item
Body Height (in cm)
integer
Code finden (UMLS CUI-1)
Körpergewicht bei Aufnahme
Item
Body weight at admission time (in kg)
integer
Code finden (UMLS CUI-1)
Item Group
Case history
arterielle Hypertonie präoperativ
Item
Preoperative arterial hypertension
boolean
Code finden (UMLS CUI-1)
Kreatininwert i.S. in mg/dl
Item
Serum creatinine level (in mg/dl)
integer
Code finden (UMLS CUI-1)
Kreatininwert i.S. in µmol/l
Item
Serum creatinine level(in µmol/l)
integer
Item Group
Surgery
OP-Datum
Item
Surgical operation date
date
Code finden (UMLS CUI-1)
Operation
Item
Procedure codes
integer
Code finden (UMLS CUI-1)
Dauer des Eingriffs
Item
Procedure Duration (in minutes)
integer
Code finden (UMLS CUI-1)
Item Group
Progress
behandlungsbedürftige (schwere) intra- oder postoperative Komplikation(en)
Item
intra/postoperative (severe) complications requiring action
boolean
Code finden (UMLS CUI-1)
Code finden (UMLS CUI-2)
Item
Hemorrhage
integer
Code finden (UMLS CUI-1)
Code List
Hemorrhage
CL Item
yes (1)
Item
Required surgical revision
integer
Code finden (UMLS CUI-1)
Code List
Required surgical revision
CL Item
yes (1)
Item
Other complication
integer
Code finden (UMLS CUI-1)
Code List
Other complication
CL Item
yes (1)
Item Group
Discharge
Spender bei Entlassung dialysepflichtig?
Item
Donor is dependent on renal dialysis at discharge
boolean
m (UMLS CUI-1)
Kreatininwert i.S. in mg/dl
Item
Serum creatinine level (in mg/dl) at discharge
integer
Code finden (UMLS CUI-1)
Kreatininwert i.S. in µmol/l
Item
Serum creatinine level(in µmol/l) at discharge
integer
Albumin i. U.
Item
Urine albumin Level (in mg/l)
integer
Code finden (UMLS CUI-1)
Albumin-Kreatinin-Verhältnis i. U.
Item
Urine albumin/creatinine ratio measurement (in mg/g)
integer
Code finden (UMLS CUI-1)
arterielle Hypertonie
Item
Arterial hypertension at discharge
boolean
Code finden (UMLS CUI-1)
Entlassungsdatum Krankenhaus
Item
Hostpital discharge date (DD.MM.YYYY)
date
Code finden (UMLS CUI-1)
Entlassungsdiagnose(n)
Item
Discharge diagnosis/es
integer
Code finden (UMLS CUI-1)
Item
Reason for discharge
integer
Code List
Reason for discharge
CL Item
treatment finished as planned (1)
CL Item
transferral to nursing facility (10)
CL Item
discharge to hospice (11)
CL Item
external transferral to psychiatric treatment (13)
CL Item
treatment finished because of other reasons, postdischarge treatment is planned (14)
CL Item
treatment aborted against medical advice, postdischarge treatment is planned (15)
CL Item
internal transferral with change of DRG payment Areas (17)
CL Item
treatment finished as planned, postdischarge treatment is planned (2)
CL Item
case termination (internal transferral) with change between full- and partial stationary care (22)
CL Item
discharge at the end of the year with admission in previous year  (25)
CL Item
treatment finished because of other reasons (3)
CL Item
treatment aborted against medical advice (4)
CL Item
change of jurisdiction of insurer or other payer (5)
CL Item
transferral to another hospital (6)
CL Item
death (7)
CL Item
transferral to another hospital within cooperative and governmental policies (8)
CL Item
transferral to rehabilitation facility (9)
Item
Cause of Death
integer
Code finden (UMLS CUI-1)
Code List
Cause of Death
CL Item
infection (1)
CL Item
cardiovascular (2)
CL Item
cerebrovascular (3)
CL Item
other (4)
CL Item
unknown (9)

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