Data Description Cases
Revision as of 19:02, 31 October 2022 by Salkin (talk | contribs) (→Data Description of cases.csv.gz)
Data Description of cases.csv.gz
Name | Type | Description | Comment |
---|---|---|---|
CaseID | Integer | A randomly assigned identifier | CaseID is unique to each admission. |
PatientID | Integer | A randomly assigned identifier | PatientID is unique to each Patient, useful to identify readmission |
AdmissionYear | Integer | Year of admission | |
TimeOfStay | Integer | Time of stay (seconds) | 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 | Float | Simplified Acute Physiology Score III | |
HospitalDischargeType | Reference | Type of hospital discharge. | This field indicates survival. |
DischargeUnit | Reference | Unit the patient was discharged to, as selected in Metavision discharge form | |
OffsetOfDeath | Integer | Seconds from primary admission to discharge with state 'deceased'. | Includes normal ward stay. |
Sex | Reference | ||
WeightOnAdmission | Float | Rounded to +-5kg | |
HeightOnAdmission | Float | Rounded to +-5cm | |
AgeOnAdmission | Integer | Rounded to +-5y, over 90 set to 90 | |
HospitalUnit | Reference | Last unit using this case | |
ReferringUnit | Reference | 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 | Text | ICD10 main code | |
ICD10MainText | Text | ICD10 main text | |
DiagnosisT1 | Text | Diagnosis field 1 | |
DiagnosisT2 | Text | Diagnosis field 2 | |
DiagnosisT3 | Text | Diagnosis field 3 | |
SurgicalSite | Reference | ||
Premedication | Text | List of premedication | Unfortunately in Austria we still use trade instead of substance names... |
InterventionsText | Text | List of interventions | |
HoursOfCRRT | Integer | Hours of continuous renal replacement threapy this admission | Note: This field will be moved into data table soon |
AdmissionFormHasSepsis | Reference | A mandatory field in the admission form | |
HeartSurgeryAdditionalData | For heart surgery patients there is additional data collected | Yes if applicable | |
HeartSurgeryCPBTime | Integer | Bypass time | |
HeartSurgeryBeginOffset | Integer | Offset in seconds from ICU admission to cut | |
HeartSurgeryEndOffset | Integer | Offset in seconds from ICU admission to end of surgery | |
OffsetAfterFirstAdmission | Integer | If a patient has more than one admission, this is the offset in seconds from the first |