Case Data - Revision history

Salkin at 16:38, 3 November 2022

2022-11-03T16:38:24Z

← Older revision		Revision as of 16:38, 3 November 2022
Line 7:		Line 7:
	{{:Processed_Referenced_Fields}}		{{:Processed_Referenced_Fields}}

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

	== Known Limitations ==		== Known Limitations ==

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

	=== Time of stay ===		=== 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]]		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]]

Salkin at 16:37, 3 November 2022

2022-11-03T16:37:46Z

← Older revision		Revision as of 16:37, 3 November 2022
Line 1:		Line 1:
	{{:Data Description Cases}}		{{:Data Description Cases}}

	== ~~Predefined Fields (RooDataServer)~~ ==		== Linked Data ==

	~~{\| class="wikitable"~~		Additional data to the case can be found in data_ref, which may have one entry per case and item type.
	~~\|+ Caption text~~
	\|-
	~~! Name !! Description !! Comment !! Type~~
	\|-
	~~\| PreconditionDiabetes \|\| Indicates patient had diabetes prior~~ to ~~admission. This includes all types that~~ have ~~at least~~ one ~~medication \|\| \|\| [[Generated Field\|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 \|\| [[Generated Field\|G]]~~
	\|-
	~~\| PreconditionArtHypertension \|\| Indicates patient is in treatment for arterial hypertension (at least one medication) \|\| \|\| [[Generated Field\|G]]~~
	\|-
	~~\| PreconditionRenalDysfuncion \|\| Indicates a renal dysfunction is known before admission \|\| This only includes cases, where a renal disease is documented in admission form! \|\| [[Generated Field\|G]]~~

	\|}		{{:Processed_Referenced_Fields}}

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

Salkin at 18:48, 31 October 2022

2022-10-31T18:48:48Z

← Older revision		Revision as of 18:48, 31 October 2022
Line 1:		Line 1:
	== Data Description ==		{{:Data Description Cases}}

	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 ==~~

	~~{\| 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 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) ==		== Predefined Fields (RooDataServer) ==

Salkin: /* Raw Fields */

2022-10-31T18:33:16Z

Raw Fields

← Older revision		Revision as of 18:33, 31 October 2022
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

Salkin: /* Raw Fields */

2022-10-31T18:32:05Z

Raw Fields

← Older revision		Revision as of 18:32, 31 October 2022
Line 26:		Line 26:
	\| HospitalDischargeType \|\| Type of hospital discharge. \|\| This field indicates survival.		\| HospitalDischargeType \|\| Type of hospital discharge. \|\| This field indicates survival.
	\|-		\|-
	\| DischargeUnit \|\| Unit the patient was ~~discharget~~ to, as selected in Metavision discharge form \|\|		\| 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.		\| OffsetOfDeath \|\| Seconds from primary admission to discharge with state 'deceased'. \|\| Includes normal ward stay.
Line 38:		Line 38:
	\| AgeOnAdmission \|\| Rounded to +-5y, over 90 set to 90 \|\|		\| AgeOnAdmission \|\| Rounded to +-5y, over 90 set to 90 \|\|
	\|-		\|-
	\| HospitalUnit \|\| Last unit using this case \|\| ~~Due to the way Metavision saves this data this field is not reliable! You may use it for quick~~		\| 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.		\| 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.

Salkin at 15:22, 28 October 2022

2022-10-28T15:22:56Z

← Older revision		Revision as of 15:22, 28 October 2022
Line 3:		Line 3:
	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.		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.

	~~== Predefined Fields (RooDataServer) ==~~

	~~{\| class="wikitable"~~
	~~\|+ Caption text~~
	\|-
	~~! Name !! Description !! Comment !! Type~~
	\|-
	~~\| PreconditionDiabetes \|\| Indicates patient had diabetes prior to admission. This includes all types that have at least one medication \|\| \|\| [[Generated Field\|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 \|\| [[Generated Field\|G]]
	\|-
	~~\| PreconditionArtHypertension \|\| Indicates patient is in treatment for arterial hypertension (at least one medication) \|\| \|\| [[Generated Field\|G]]~~
	\|-
	~~\| PreconditionRenalDysfuncion \|\| Indicates a renal dysfunction is known before admission \|\| This only includes cases, where a renal disease is documented in admission form! \|\| [[Generated Field\|G]]~~

	\|}

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

	== Raw Fields ==		== Raw Fields ==
Line 63:		Line 46:
	\| ICD10MainText \|\| ICD10 main text \|\|		\| ICD10MainText \|\| ICD10 main text \|\|
	\|-		\|-
	\| DiagnosisT1 \|\| Diagnosis field 1 \|\|		\| DiagnosisT1 \|\| Diagnosis field 1 \|\|
	\|-		\|-
	\| DiagnosisT2 \|\| Diagnosis field 2 \|\|		\| DiagnosisT2 \|\| Diagnosis field 2 \|\|
Line 71:		Line 54:
	\| SurgicalSite \|\| \|\|		\| SurgicalSite \|\| \|\|
	\|-		\|-
	\| Premedication \|\| ~~Simple list~~ of premedication \|\| Unfortunately in Austria we still use trade instead of substance names...		\| 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 \|\|
	\|-		\|-
	\| ~~InterventionsText~~ \|\| ~~Simple list of interventions~~ \|\|		\| OffsetAfterFirstAdmission \|\| If a patient has more than one admission, this is the offset in seconds from the first \|\|

	\|}		\|}

	~~ImportData~~		== Predefined Fields (RooDataServer) ==
	~~HoursOfCRRT~~
	~~AdmissionFormHasSepsis~~		{\| class="wikitable"
	~~OrbisDataAvailable~~		\|+ Caption text
	~~HeartSurgeryAdditionalData~~		\|-
	~~HeartSurgeryCPBTime~~		! Name !! Description !! Comment !! Type
	~~HeartSurgeryCrossClampTime~~		\|-
	~~HeartSurgeryBeginOffset~~		\| PreconditionDiabetes \|\| Indicates patient had diabetes prior to admission. This includes all types that have at least one medication \|\| \|\| [[Generated Field\|G]]
	~~HeartSurgeryEndOffset~~		\|-
	~~OffsetAfterFirstAdmission~~		\| PreconditionLungDisease \|\| Indicates patient had a lung decease prior to admission. \|\| Includes all types of diagnosed COPD. Includes severe (i.e. regularly taken medication) asthma \|\| [[Generated Field\|G]]
			\|-
			\| PreconditionArtHypertension \|\| Indicates patient is in treatment for arterial hypertension (at least one medication) \|\| \|\| [[Generated Field\|G]]
			\|-
			\| PreconditionRenalDysfuncion \|\| Indicates a renal dysfunction is known before admission \|\| This only includes cases, where a renal disease is documented in admission form! \|\| [[Generated Field\|G]]

			\|}

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

	== Known Limitations ==		== Known Limitations ==

Salkin: /* Predefined Fields (RooDataServer) */

2022-09-10T13:08:45Z

Predefined Fields (RooDataServer)

← Older revision		Revision as of 13:08, 10 September 2022
Line 12:		Line 12:
	\| PreconditionDiabetes \|\| Indicates patient had diabetes prior to admission. This includes all types that have at least one medication \|\| \|\| [[Generated Field\|G]]		\| PreconditionDiabetes \|\| Indicates patient had diabetes prior to admission. This includes all types that have at least one medication \|\| \|\| [[Generated Field\|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		\| PreconditionLungDisease \|\| Indicates patient had a lung decease prior to admission. \|\| Includes all types of diagnosed COPD. Includes severe (i.e. regularly taken medication) asthma \|\| [[Generated Field\|G]]
	\|-		\|-
	\| PreconditionArtHypertension \|\| Indicates patient is in treatment for arterial hypertension (at least one medication) \|\|		\| PreconditionArtHypertension \|\| Indicates patient is in treatment for arterial hypertension (at least one medication) \|\| \|\| [[Generated Field\|G]]
	\|-		\|-
	\| PreconditionRenalDysfuncion \|\| Indicates a renal dysfunction is known before admission \|\| This only includes cases, where a renal disease is documented in admission form!		\| PreconditionRenalDysfuncion \|\| Indicates a renal dysfunction is known before admission \|\| This only includes cases, where a renal disease is documented in admission form! \|\| [[Generated Field\|G]]

	\|}		\|}

Salkin: /* Predefined Fields (RooDataServer) */

2022-09-10T13:05:30Z

Predefined Fields (RooDataServer)

← Older revision		Revision as of 13:05, 10 September 2022
Line 10:		Line 10:
	! Name !! Description !! Comment !! Type		! Name !! Description !! Comment !! Type
	\|-		\|-
	\| PreconditionDiabetes \|\| Indicates patient had diabetes prior to admission. This includes all types that have at least one medication \|\| \|\| [[~~Calculated~~ Field\|C]]		\| PreconditionDiabetes \|\| Indicates patient had diabetes prior to admission. This includes all types that have at least one medication \|\| \|\| [[Generated Field\|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		\| PreconditionLungDisease \|\| Indicates patient had a lung decease prior to admission. \|\| Includes all types of diagnosed COPD. Includes severe (i.e. regularly taken medication) asthma

Salkin: /* Predefined Fields (RooDataServer) */

2022-09-10T12:54:57Z

Predefined Fields (RooDataServer)

← Older revision		Revision as of 12:54, 10 September 2022
Line 10:		Line 10:
	! Name !! Description !! Comment !! Type		! Name !! Description !! Comment !! Type
	\|-		\|-
	\| PreconditionDiabetes \|\| Indicates patient had diabetes prior to admission. This includes all types that have at least one medication \|\| \|\| [Calculated Field\|C]		\| PreconditionDiabetes \|\| Indicates patient had diabetes prior to admission. This includes all types that have at least one medication \|\| \|\| [[Calculated Field\|C]]
	\|-		\|-
	\| PreconditionLungDisease \|\| Indicates patient had a lung decease prior to admission. \|\| Includes all types of diagnosed COPD. Includes severe (i.e. regularly taken medication) asthma		\| PreconditionLungDisease \|\| Indicates patient had a lung decease prior to admission. \|\| Includes all types of diagnosed COPD. Includes severe (i.e. regularly taken medication) asthma

Salkin at 12:54, 10 September 2022

2022-09-10T12:54:47Z

← Older revision		Revision as of 12:54, 10 September 2022
Line 8:		Line 8:
	\|+ Caption text		\|+ Caption text
	\|-		\|-
	! Name !! Description !! Comment		! Name !! Description !! Comment !! Type
	\|-		\|-
	\| PreconditionDiabetes \|\| Indicates patient had diabetes prior to admission. This includes all types that have at least one medication \|\|		\| PreconditionDiabetes \|\| Indicates patient had diabetes prior to admission. This includes all types that have at least one medication \|\| \|\| [Calculated Field\|C]
	\|-		\|-
	\| PreconditionLungDisease \|\| Indicates patient had a lung decease prior to admission. \|\| Includes all types of diagnosed COPD. Includes severe (i.e. regularly taken medication) asthma		\| PreconditionLungDisease \|\| Indicates patient had a lung decease prior to admission. \|\| Includes all types of diagnosed COPD. Includes severe (i.e. regularly taken medication) asthma