Data Description Cases
Revision as of 18:47, 31 October 2022 by Salkin (talk | contribs) (Created page with "== Data Description of cases.csv.gz === === Raw Fields === {| class="wikitable" |+ 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 dischar...")
Data Description of cases.csv.gz =
Raw Fields
| 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 |