Data Description Cases - Revision history

Salkin at 05:42, 12 July 2024

2024-07-12T05:42:21Z

← Older revision		Revision as of 05:42, 12 July 2024
Line 51:		Line 51:
	\|-		\|-
	\| ICD10MainText \|\| Text \|\| ICD10 main text \|\|		\| ICD10MainText \|\| Text \|\| ICD10 main text \|\|
	\|-
	~~\| DiagnosisT1 \|\| Text \|\| Diagnosis field 1* \|\|~~
	\|-
	~~\| DiagnosisT2 \|\| Text \|\| Diagnosis field 2* \|\|~~
	\|-
	~~\| DiagnosisT3\|\| Text \|\| Diagnosis field 3* \|\|~~
	\|-		\|-
	\| SurgicalSite \|\| Reference \|\| \|\|		\| SurgicalSite \|\| Reference \|\| \|\|

Salkin at 08:33, 5 April 2024

2024-04-05T08:33:30Z

← Older revision		Revision as of 08:33, 5 April 2024
Line 23:		Line 23:
	\|-		\|-
	\| HospitalDischargeType \|\| Reference \|\| Type of hospital discharge. \|\| This field indicates survival.		\| 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		\| DischargeState \|\| Reference \|\| Type of icu discharge \|\| This field indicates survival on icu

Salkin at 15:39, 21 May 2023

2023-05-21T15:39:50Z

← Older revision		Revision as of 15:39, 21 May 2023
Line 17:		Line 17:
	\|-		\|-
	\| 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.		\| 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 \|\|		\| saps3 \|\| Float \|\| Simplified Acute Physiology Score III \|\|

Salkin at 10:17, 5 February 2023

2023-02-05T10:17:46Z

← Older revision		Revision as of 10:17, 5 February 2023
Line 27:		Line 27:
	\|-		\|-
	\| 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.		\| 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.
			\|-
			\| EstimatedSurvivalObservationTime \|\| Reference \|\| Estimation of oversation time, either 1-year or 6-month\|\|
	\|-		\|-
	\| Sex \|\| Reference \|\| \|\|		\| Sex \|\| Reference \|\| \|\|

Salkin at 09:25, 5 February 2023

2023-02-05T09:25:47Z

← Older revision		Revision as of 09:25, 5 February 2023
Line 3:		Line 3:
	"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.		"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. ~~However,~~ it ~~should be noted that "OffsetOfDeath" cannot be used as long~~-~~term survival information as~~ it is ~~only~~ set if ~~the patient dies within a hospital stay~~.		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"

Salkin at 09:24, 5 February 2023

2023-02-05T09:24:31Z

← Older revision		Revision as of 09:24, 5 February 2023
Line 46:		Line 46:
	\| DiagnosisT1 \|\| Text \|\| Diagnosis field 1* \|\|		\| DiagnosisT1 \|\| Text \|\| Diagnosis field 1* \|\|
	\|-		\|-
	\| DiagnosisT2 \|\| Text \|\| Diagnosis field 2 \|\|		\| DiagnosisT2 \|\| Text \|\| Diagnosis field 2* \|\|
	\|-		\|-
	\| DiagnosisT3\|\| Text \|\| Diagnosis field 3* \|\|		\| DiagnosisT3\|\| Text \|\| Diagnosis field 3* \|\|

Salkin at 09:24, 5 February 2023

2023-02-05T09:24:04Z

← Older revision		Revision as of 09:24, 5 February 2023
Line 26:		Line 26:
	\| DischargeUnit \|\| Reference \|\| Unit the patient was discharged to, as selected in Metavision discharge form \|\|		\| 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 {{Mortality}} for further information.		\| 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.
	\|-		\|-
	\| Sex \|\| Reference \|\| \|\|		\| Sex \|\| Reference \|\| \|\|

Salkin at 09:23, 5 February 2023

2023-02-05T09:23:50Z

← Older revision		Revision as of 09:23, 5 February 2023
Line 26:		Line 26:
	\| DischargeUnit \|\| Reference \|\| Unit the patient was discharged to, as selected in Metavision discharge form \|\|		\| DischargeUnit \|\| Reference \|\| Unit the patient was discharged to, as selected in Metavision discharge form \|\|
	\|-		\|-
	\| OffsetOfDeath \|\| Integer \|\| ~~Seconds~~ from primary admission to death \|\| ~~Not linked to current stay~~, ~~may include normal ward and later stays~~		\| 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.
	\|-		\|-
	\| Sex \|\| Reference \|\| \|\|		\| Sex \|\| Reference \|\| \|\|

Salkin at 09:58, 6 January 2023

2023-01-06T09:58:02Z

← Older revision		Revision as of 09:58, 6 January 2023
Line 54:		Line 54:
	\| InterventionsText \|\| Text \|\| List of interventions \|\|		\| 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~~		\| HoursOfCRRT \|\| Integer \|\| Hours of continuous renal replacement threapy this admission **\|\|
	\|-		\|-
	\| AdmissionFormHasSepsis \|\| Reference \|\| A mandatory field in the admission form \|\|		\| AdmissionFormHasSepsis \|\| Reference \|\| A mandatory field in the admission form **\|\|
	\|-		\|-
	\| HeartSurgeryAdditionalData \|\| For heart surgery patients there is additional data collected \|\| Yes if applicable		\| HeartSurgeryAdditionalData \|\| For heart surgery patients there is additional data collected **\|\| Yes if applicable
	\|-		\|-
	\| HeartSurgeryCPBTime \|\| Integer \|\| Bypass time \|\|		\| HeartSurgeryCPBTime \|\| Integer \|\| Bypass time **\|\|
	\|-		\|-
	\| HeartSurgeryBeginOffset \|\| Integer \|\| Offset in seconds from ICU admission to cut \|\|		\| HeartSurgeryBeginOffset \|\| Integer \|\| Offset in seconds from ICU admission to cut **\|\|
	\|-		\|-
	\| HeartSurgeryEndOffset \|\| Integer \|\| Offset in seconds from ICU admission to end of surgery \|\|		\| 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 \|\|		\| OffsetAfterFirstAdmission \|\| Integer \|\| If a patient has more than one admission, this is the offset in seconds from the first \|\|
Line 71:		Line 71:

	* These fields are not available on PhysioNet at the moment. Contact us for further information.		* 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

Salkin at 09:56, 6 January 2023

2023-01-06T09:56:26Z

← Older revision		Revision as of 09:56, 6 January 2023
Line 1:		Line 1:
	The cases table is the base table of the SICdb dataset~~, '''~~CaseID~~''' is~~ the identifier that ~~relationally connects~~ all data. ~~For each~~ admission to ~~our~~ intensive care unit ~~one~~ CaseID ~~is generated~~. To identify readmissions, a PatientID is provided. The time between the first admission and the current ~~is stored in field OffsetAfterFirstAdmission~~.		"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 ~~Metavision~~ admission to ~~Metavision~~ discharge. This time may ~~begin with the~~ preceding surgery, and ends when the case is closed.		"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 3 fields indicating survival. DischargeState indicates the state of the ~~patient on~~ ICU ~~discharge, this data~~ is taken from the ~~Metavision~~ discharge form. HospitalDischargeType ~~gives~~ information ~~about~~ how ~~this~~ case was closed in the clinical information system. OffsetOfDeath is the time in seconds from admission to death. ~~This field also takes further stays into consideration and is~~, ~~opposite to DischargeState and HospitalDischargeType, not linked to the stay identifier. Take into consideration~~ that OffsetOfDeath cannot be used as long-term survival information~~, because~~ it ~~will~~ only be set if the patient ~~died~~ within a stay ~~in hospital~~.		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. However, it should be noted that "OffsetOfDeath" cannot be used as long-term survival information as it is only set if the patient dies within a hospital stay.

	{\| class="wikitable"		{\| class="wikitable"