Difference between revisions of "Data Description Cases"

From SICDB Doc
Jump to navigation Jump to search
(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...")
 
 
(19 intermediate revisions by the same user not shown)
Line 1: Line 1:
== Data Description of cases.csv.gz ===
"The "cases" table is the base table of the SICdb dataset and the "CaseID" field serves as the identifier that relates all data. Each admission to the intensive care unit generates a unique "CaseID." To identify readmissions, a "PatientID" is provided. The "OffsetAfterFirstAdmission" field stores the time between the first admission and the current one.


=== Raw Fields ===
"TimeOfStay" is the time in seconds from the admission recorded by the MetaVision system to the discharge. This time may include any preceding surgery and ends when the case is closed.
 
There are three fields indicating survival: "DischargeState" indicates the patient's state upon discharge from the ICU and is taken from the MetaVision discharge form. "HospitalDischargeType" provides information on how the case was closed in the clinical information system. "OffsetOfDeath" is the time in seconds from admission to death and includes additional hospital stays and out of hospital mortality. As it refers to a 1-year mortality it is set to null if death occurred more than one year after admission.


{| class="wikitable"
{| class="wikitable"
|+ Caption text
|+ cases.csv.gz
|-
|-
! Name !! Description !! Comment
! Name !! Type !! Description !! Comment
|-  
|-  
| CaseID || A randomly assigned identifier || CaseID is unique to each admission.  
| CaseID || Integer ||  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
| PatientID || Integer ||A randomly assigned identifier || PatientID is unique to each Patient, useful to identify readmission
|-
|-
| AdmissionYear || Year of admission ||  
| AdmissionYear || Integer || 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.
| 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 || Simplified Acute Physiology Score III ||  
| ICUOffset || Integer || Time of actual ICU admission || SICdb includes preceding surgery if applicable, this field indicates the first transfer to an intensive or intermediate care ward
|-
|-
| HospitalDischargeType || Type of hospital discharge. || This field indicates survival.
| saps3 || Float || Simplified Acute Physiology Score III ||  
|-
|-
| DischargeUnit || Unit the patient was discharged to, as selected in Metavision discharge form ||
| HospitalDischargeType || Reference || Type of hospital discharge. || This field indicates survival.
|-
|-
| OffsetOfDeath || Seconds from primary admission to discharge with state 'deceased'. || Includes normal ward stay.
| HospitalDischargeDay || Integer || The day of hospital discharge after admission || Note that this data is only available in days
|-
|-
| Sex || ||  
| HospitalStayDays || Integer || Days stayed in hospital for this case, including pre icu. ||  
|-
|-
| WeightOnAdmission || Rounded to +-5kg ||  
| DischargeState || Reference || Type of icu discharge || This field indicates survival on icu
|-
|-
| HeightOnAdmission || Rounded to +-5cm ||  
| DischargeUnit || Reference || Unit the patient was discharged to, as selected in Metavision discharge form ||
|-
|-
| AgeOnAdmission || Rounded to +-5y, over 90 set to 90 ||  
| OffsetOfDeath || Integer || 1-year mortality in seconds from primary admission to death || 1 year mortality, including out-of-hospital as far as known. See {{:Mortality}} for further information.
|-
|-
| HospitalUnit || Last unit using this case ||  
| EstimatedSurvivalObservationTime || Reference || Estimation of oversation time, either 1-year or 6-month||  
|-
|-
| 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.
| Sex ||  Reference || ||  
|-
|-
| ICD10Main || ICD10 main code ||
| WeightOnAdmission || Float || Rounded to +-5kg ||  
|-
|-
| ICD10MainText || ICD10 main text ||
| HeightOnAdmission || Float || Rounded to +-5cm ||  
|-
|-
| DiagnosisT1 || Diagnosis field 1 ||  
| AgeOnAdmission || Integer || Rounded to +-5y, over 90 set to 90 ||  
|-
|-
| DiagnosisT2 || Diagnosis field 2 ||
| HospitalUnit || Reference || Last unit using this case ||  
|-
|-
| DiagnosisT3|| Diagnosis field 3 ||
| 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.
|-
|-
| SurgicalSite || ||
| ICD10Main || Text || ICD10 main code ||
|-
|-
| Premedication || List of premedication || Unfortunately in Austria we still use trade instead of substance names...
| ICD10MainText || Text || ICD10 main text ||
|-
|-
| InterventionsText || List of interventions ||
| SurgicalSite || Reference || ||
|-
|-
| HoursOfCRRT || Hours of continuous renal replacement threapy this admission || Note: This field will be moved into data table soon
| InterventionsText || Text || List of interventions ||
|-
|-
| AdmissionFormHasSepsis || A mandatory field in the admission form ||  
| HoursOfCRRT || Integer || Hours of continuous renal replacement threapy this admission **||  
|-
|-
| HeartSurgeryAdditionalData || For heart surgery patients there is additional data collected || Yes if applicable
| AdmissionFormHasSepsis || Reference ||  A mandatory field in the admission form **||  
|-
|-
| HeartSurgeryCPBTime || Bypass time ||
| HeartSurgeryAdditionalData || For heart surgery patients there is additional data collected **|| Yes if applicable
|-
|-
| HeartSurgeryBeginOffset || Offset in seconds from ICU admission to cut ||  
| HeartSurgeryCPBTime || Integer ||  Bypass time **||
|-
|-
| HeartSurgeryEndOffset || Offset in seconds from ICU admission to end of surgery ||  
| HeartSurgeryBeginOffset || Integer || Offset in seconds from ICU admission to cut **||  
|-
|-
| OffsetAfterFirstAdmission || If a patient has more than one admission, this is the offset in seconds from the first ||  
| 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 ||  


|}
|}
* These fields are not available on PhysioNet at the moment. Contact us for further information.
** These fields will be moved to data tables in version 1.1.0

Latest revision as of 05:42, 12 July 2024

"The "cases" table is the base table of the SICdb dataset and the "CaseID" field serves as the identifier that relates all data. Each admission to the intensive care unit generates a unique "CaseID." To identify readmissions, a "PatientID" is provided. The "OffsetAfterFirstAdmission" field stores the time between the first admission and the current one.

"TimeOfStay" is the time in seconds from the admission recorded by the MetaVision system to the discharge. This time may include any preceding surgery and ends when the case is closed.

There are three fields indicating survival: "DischargeState" indicates the patient's state upon discharge from the ICU and is taken from the MetaVision discharge form. "HospitalDischargeType" provides information on how the case was closed in the clinical information system. "OffsetOfDeath" is the time in seconds from admission to death and includes additional hospital stays and out of hospital mortality. As it refers to a 1-year mortality it is set to null if death occurred more than one year after admission.

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.
ICUOffset Integer Time of actual ICU admission SICdb includes preceding surgery if applicable, this field indicates the first transfer to an intensive or intermediate care ward
saps3 Float Simplified Acute Physiology Score III
HospitalDischargeType Reference Type of hospital discharge. This field indicates survival.
HospitalDischargeDay Integer The day of hospital discharge after admission Note that this data is only available in days
HospitalStayDays Integer Days stayed in hospital for this case, including pre icu.
DischargeState Reference Type of icu discharge This field indicates survival on icu
DischargeUnit Reference Unit the patient was discharged to, as selected in Metavision discharge form
OffsetOfDeath Integer 1-year mortality in seconds from primary admission to death 1 year mortality, including out-of-hospital as far as known. See The "OffsetOfDeath" field denotes the elapsed time, in seconds, from admission to death, taking into account any subsequent hospital stays and out-of-hospital mortality data. The data was gathered from various sources, including government data. It is set to null if the death occurs more than one year after admission, since it is defined to 1-year mortality. For technical reasons observation time is only 6 month for some patients, field "EstimatedSurvivalObservationTime" holds information about that. However, it is worth noting that in some cases, if a patient dies in foreign countries, the information may be scarce. Postal address validity checks were performed, but no statistically significant differences were found, indicating that this may not be an issue of concern. for further information.
EstimatedSurvivalObservationTime Reference Estimation of oversation time, either 1-year or 6-month
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
SurgicalSite Reference
InterventionsText Text List of interventions
HoursOfCRRT Integer Hours of continuous renal replacement threapy this admission **
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 
* These fields are not available on PhysioNet at the moment. Contact us for further information.
** These fields will be moved to data tables in version 1.1.0
Retrieved from "https://www.sicdb.com/wiki/index.php?title=Data_Description_Cases&oldid=385"