Data Description Laboratory - Revision history

Salkin at 16:51, 3 November 2022

2022-11-03T16:51:29Z

← Older revision		Revision as of 16:51, 3 November 2022
Line 2:		Line 2:

	Like all "Reference" fields additional data like name and unit of measurement is found in d_references. See [[SQL Examples]] to learn how to connect them using a relational database system.		Like all "Reference" fields additional data like name and unit of measurement is found in d_references. See [[SQL Examples]] to learn how to connect them using a relational database system.

			To simplify lookup for labs of previous stays PatientID was added to this table.

Salkin at 16:49, 3 November 2022

2022-11-03T16:49:12Z

← Older revision		Revision as of 16:49, 3 November 2022
Line 1:		Line 1:
	The laboratory table contains all available lab data, in many cases including the pre-admission labs.		The laboratory table contains all available lab data, in many cases including the pre-admission labs.

			Like all "Reference" fields additional data like name and unit of measurement is found in d_references. See [[SQL Examples]] to learn how to connect them using a relational database system.


Line 19:		Line 21:
	\| LaboratoryValue \|\| Float \|\| Value \|\| Unity of measurement can be found in d_references		\| LaboratoryValue \|\| Float \|\| Value \|\| Unity of measurement can be found in d_references
	\|-		\|-
	\| LaboratoryType \|\| Reference \|\| Used for special laboratory types, i.e. arterial blood gas. ~~Relates to d_references.ReferenceGlobalID~~ \|\|		\| LaboratoryType \|\| Reference \|\| Used for special laboratory types, i.e. arterial blood gas. \|\|
	\|}		\|}

Salkin at 09:11, 1 November 2022

2022-11-01T09:11:26Z

← Older revision		Revision as of 09:11, 1 November 2022
Line 11:		Line 11:
	\| CaseID \|\| Integer \|\| Case identifier \|\|		\| CaseID \|\| Integer \|\| Case identifier \|\|
	\|-		\|-
	\| ~~LaboratoryID~~ \|\| Reference \|\| \|\|		\| PatientID \|\| Integer \|\| Patient identifier \|\|
			\|-
			\| DrugID \|\| Reference \|\| \|\|
	\|-		\|-
	\| Offset \|\| Integer \|\| Time in seconds after admission \|\|		\| Offset \|\| Integer \|\| Time in seconds after admission \|\|

Salkin at 08:58, 1 November 2022

2022-11-01T08:58:32Z

← Older revision		Revision as of 08:58, 1 November 2022
Line 1:		Line 1:
			The laboratory table contains all available lab data, in many cases including the pre-admission labs.


	{\| class="wikitable"		{\| class="wikitable"
	\|+ ~~Caption text~~		\|+ laboratory.csv.gz
	\|-		\|-
	! Name !! Type !! Description !! Comment		! Name !! Type !! Description !! Comment

Salkin: Created page with " {| class="wikitable" |+ Caption text |- ! Name !! Type !! Description !! Comment |- | id || Integer || Primary Key || |- | CaseID || Integer || Case identifier || |- | LaboratoryID || Reference || || |- | Offset || Integer || Time in seconds after admission || |- | LaboratoryValue || Float || Value || Unity of measurement can be found in d_references |- | LaboratoryType || Reference || Used for special laboratory types, i.e. arterial blood gas. Relates to d_..."

2022-11-01T08:57:42Z

Created page with " {| class="wikitable" |+ Caption text |- ! Name !! Type !! Description !! Comment |- | id || Integer || Primary Key || |- | CaseID || Integer || Case identifier || |- | LaboratoryID || Reference || || |- | Offset || Integer || Time in seconds after admission || |- | LaboratoryValue || Float || Value || Unity of measurement can be found in d_references |- | LaboratoryType || Reference || Used for special laboratory types, i.e. arterial blood gas. Relates to d_..."

New page

{| class="wikitable"
|+ Caption text
|-
! Name !! Type !! Description !! Comment
|-
| id || Integer || Primary Key ||
|-
| CaseID || Integer || Case identifier ||
|-
| LaboratoryID || Reference || ||
|-
| Offset || Integer || Time in seconds after admission ||
|-
| LaboratoryValue || Float || Value || Unity of measurement can be found in d_references
|-
| LaboratoryType || Reference || Used for special laboratory types, i.e. arterial blood gas. Relates to d_references.ReferenceGlobalID ||
|}