Difference between revisions of "Case Data"

From SICDB Doc
Jump to navigation Jump to search
Line 13: Line 13:
|-  
|-  
| CaseID || A randomly assigned identifier || CaseID is unique to each admission.  
| CaseID || A randomly assigned identifier || CaseID is unique to each admission.  
|-
| CaseIDKis || Secondary randomly assigned identifier, internal use || Internal data, do not use
|-
|-
| PatientID || A randomly assigned identifier || PatientID is unique to each Patient, useful to identify readmission
| PatientID || A randomly assigned identifier || PatientID is unique to each Patient, useful to identify readmission

Revision as of 18:33, 31 October 2022

Data Description

The cases table contains unique intensive care admissions and case related data. The case starts with startin a new Metavision case, which may be created for the anaesthesia preceding the intensive care stay.


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

Predefined Fields (RooDataServer)

Caption text
Name Description Comment Type
PreconditionDiabetes Indicates patient had diabetes prior to admission. This includes all types that have at least one medication G
PreconditionLungDisease Indicates patient had a lung decease prior to admission. Includes all types of diagnosed COPD. Includes severe (i.e. regularly taken medication) asthma G
PreconditionArtHypertension Indicates patient is in treatment for arterial hypertension (at least one medication) G
PreconditionRenalDysfuncion Indicates a renal dysfunction is known before admission This only includes cases, where a renal disease is documented in admission form! G

As this is the base table, defined fields are mostly similar to raw fields and are not documented twice.

Known Limitations

The cases data is generally considered as being widely valid. Nevertheless there are some limitations to be stated.

Time of stay

In most cases at a readmission in same hospital stay a new case is created. In rare cases the preceding case is reopened causing that TimeOfStay includes the time patient was on normal ward. If this issue is important you may use the tranfer log or the lacking monitor signals to remove/repair these cases. This issue is on ToDo list for future releases