Data Description Cases

From SICDB Doc
Revision as of 18:47, 31 October 2022 by Salkin (talk | contribs)
Jump to navigation Jump to search

Data Description of cases.csv.gz

Raw Fields

Caption text
Name Description Comment
CaseID A randomly assigned identifier CaseID is unique to each admission.
PatientID A randomly assigned identifier PatientID is unique to each Patient, useful to identify readmission
AdmissionYear Year of admission
TimeOfStay Time of stay Time from primary metavision admission, to last discharge. In cases, where the patient is admitted to ward after surgery, this will include surgery time.
saps3 Simplified Acute Physiology Score III
HospitalDischargeType Type of hospital discharge. This field indicates survival.
DischargeUnit Unit the patient was discharged to, as selected in Metavision discharge form
OffsetOfDeath Seconds from primary admission to discharge with state 'deceased'. Includes normal ward stay.
Sex
WeightOnAdmission Rounded to +-5kg
HeightOnAdmission Rounded to +-5cm
AgeOnAdmission Rounded to +-5y, over 90 set to 90
HospitalUnit Last unit using this case
ReferringUnit Referring unit as selected in admission form Note: Unfortunatly in some cases "Notaufnahme" is selected here, so the referring unit is not specified in these cases.
ICD10Main ICD10 main code
ICD10MainText ICD10 main text
DiagnosisT1 Diagnosis field 1
DiagnosisT2 Diagnosis field 2
DiagnosisT3 Diagnosis field 3
SurgicalSite
Premedication List of premedication Unfortunately in Austria we still use trade instead of substance names...
InterventionsText List of interventions
HoursOfCRRT Hours of continuous renal replacement threapy this admission Note: This field will be moved into data table soon
AdmissionFormHasSepsis A mandatory field in the admission form
HeartSurgeryAdditionalData For heart surgery patients there is additional data collected Yes if applicable
HeartSurgeryCPBTime Bypass time
HeartSurgeryBeginOffset Offset in seconds from ICU admission to cut
HeartSurgeryEndOffset Offset in seconds from ICU admission to end of surgery
OffsetAfterFirstAdmission If a patient has more than one admission, this is the offset in seconds from the first