Primary procedure - Revision history

MaciejBlizinski at 19:20, 28 September 2005

2005-09-28T19:20:00Z

MaciejBlizinski at 19:19, 28 September 2005

2005-09-28T19:19:41Z

MaciejBlizinski at 19:14, 28 September 2005

2005-09-28T19:14:00Z

MaciejBlizinski at 19:11, 28 September 2005

2005-09-28T19:11:42Z

MaciejBlizinski at 19:09, 28 September 2005

2005-09-28T19:09:42Z

MaciejBlizinski at 22:02, 23 September 2005

2005-09-23T22:02:03Z

New page

'''Primary procedure''' is the most important, the most significant procedure in specific '''operation'''. In most cases, it's the procedure with highest [[Basic Score]].

'''See also'''

*[[Mortality assigned to]]
*[[Fundamental diagnosis]]

[[category:terminology]]

←Older revision		Revision as of 19:20, 28 September 2005
Line 1:		Line 1:
		+	{{terminology-infobox}}
		+
	'''Primary procedure''' is the most important, the most significant procedure in specific '''operation'''. In most cases, it's the procedure with highest [[Basic Score]].		'''Primary procedure''' is the most important, the most significant procedure in specific '''operation'''. In most cases, it's the procedure with highest [[Basic Score]].

@@ Line 54: / Line 54: @@
 The reduction is performed in such a way, that each patient-procedure link has an assigned priority, like this:
 {|border="1"
@@ Line 118: / Line 117: @@
 |}
 '''See also'''

@@ Line 75: / Line 75: @@
 |Patient2
 |Procedure2
-|1
+|2
 |-
 |Patient3
@@ Line 93: / Line 93: @@
 |3
 |}
 '''See also'''
 *[[Mortality assigned to]]
 *[[Fundamental diagnosis]]
 [[category:terminology]]

@@ Line 51: / Line 51: @@
 |Patient4
 |Procedure1
 |}

←Older revision		Revision as of 19:09, 28 September 2005
Line 1:		Line 1:
	'''Primary procedure''' is the most important, the most significant procedure in specific '''operation'''. In most cases, it's the procedure with highest [[Basic Score]].		'''Primary procedure''' is the most important, the most significant procedure in specific '''operation'''. In most cases, it's the procedure with highest [[Basic Score]].
		+
		+	==Usage of primary procedure in database reports==
		+
		+	The full database structure employs a model where one patient is exposed to multiple procedures during multiple operation. An example table in a relational database would look like this:
		+
		+	{\|border="1"
		+	!Patient ID
		+	!Procedure name
		+	\|-
		+	\|Patient1
		+	\|Procedure1
		+	\|-
		+	\|Patient1
		+	\|Procedure2
		+	\|-
		+	\|Patient2
		+	\|Procedure3
		+	\|-
		+	\|Patient2
		+	\|Procedure2
		+	\|-
		+	\|Patient3
		+	\|Procedure1
		+	\|-
		+	\|Patient4
		+	\|Procedure1
		+	\|-
		+	\|Patient4
		+	\|Procedure2
		+	\|-
		+	\|Patient4
		+	\|Procedure3
		+	\|}
		+
		+	However, this model doesn't allow to perform a "mortality vs procedure" report, because mortality is a property of a patient, and one procedure has to be chosen as the "responsible" procedure. To perform a "mortality vs procedure" report, the above table has to be reduced down to this model, with no repeating "Patient ID" value:
		+
		+	{\|border="1"
		+	!Patient ID
		+	!Procedure name
		+	\|-
		+	\|Patient1
		+	\|Procedure1
		+	\|-
		+	\|Patient2
		+	\|Procedure3
		+	\|-
		+	\|Patient3
		+	\|Procedure1
		+	\|-
		+	\|Patient4
		+	\|Procedure1
		+	\|}

	'''See also'''		'''See also'''