Pre-send Checker - Revision history

Ttenbergen: Text replacement - "[[Category: " to "[[Category:"

2025-07-30T16:55:03Z

Text replacement - "[[Category: " to "[[Category:"

← Older revision		Revision as of 11:55, 30 July 2025
Line 16:		Line 16:

	=== checks against current tmp projects ===		=== checks against current tmp projects ===
	{{#ask: [[DICApp::CCMDB.accdb]] [[Category: Tmp check]] [[DICStatus::implemented]]		{{#ask: [[DICApp::CCMDB.accdb]] [[Category:Tmp check]] [[DICStatus::implemented]]
	\|format=UL		\|format=UL
	}}		}}
Line 23:		Line 23:
	{{Related Articles}}		{{Related Articles}}

	[[Category: CCMDB.accdb]]		[[Category:CCMDB.accdb]]
	[[Category: Main Form]]		[[Category:Main Form]]

Ttenbergen: Text replacement - "CCMDB.mdb" to "CCMDB.accdb"

2019-09-22T16:42:46Z

Text replacement - "CCMDB.mdb" to "CCMDB.accdb"

← Older revision		Revision as of 11:42, 22 September 2019
Line 1:		Line 1:
	The '''"Pre-send Checker"''' button on the main screen of [[CCMDB.~~mdb~~]] applies the same checks that will happen automaticlaly before sending.		The '''"Pre-send Checker"''' button on the main screen of [[CCMDB.accdb]] applies the same checks that will happen automaticlaly before sending.

	== Use ==		== Use ==
Line 6:		Line 6:

	==What is actually checked==		==What is actually checked==
	''This data may be out-of date, for the actual checks see the Tmp_checker module in [[CCMDB.~~mdb~~]].''		''This data may be out-of date, for the actual checks see the Tmp_checker module in [[CCMDB.accdb]].''

	The following things get checked, in this order:		The following things get checked, in this order:
Line 16:		Line 16:

	=== checks against current tmp projects ===		=== checks against current tmp projects ===
	{{#ask: [[DICApp::CCMDB.~~mdb~~]] [[Category: Tmp check]] [[DICStatus::implemented]]		{{#ask: [[DICApp::CCMDB.accdb]] [[Category: Tmp check]] [[DICStatus::implemented]]
	\|format=UL		\|format=UL
	}}		}}
Line 23:		Line 23:
	{{Related Articles}}		{{Related Articles}}

	[[Category: CCMDB.~~mdb~~]]		[[Category: CCMDB.accdb]]
	[[Category: Main Form]]		[[Category: Main Form]]

Ttenbergen: /* What is actually checked */

2019-01-17T03:53:40Z

What is actually checked

← Older revision		Revision as of 22:53, 16 January 2019
Line 12:		Line 12:
	# [[Check duplicate patient]]		# [[Check duplicate patient]]
	# are there any TMP entries not consistent with table s_tmp? ([[query s_tmp_project_item_consistent]])		# are there any TMP entries not consistent with table s_tmp? ([[query s_tmp_project_item_consistent]])
	# any [[#checks against current tmp projects]]		# any [[#checks against current tmp projects]] (see below)
	# are there any patients with [[Eliminating a diagnosis from collection\|diagnoses we are eliminating]]?		# are there any patients with [[Eliminating a diagnosis from collection\|diagnoses we are eliminating]]?

Ttenbergen: /* checks against current tmp projects */

2019-01-17T03:52:53Z

checks against current tmp projects

← Older revision		Revision as of 22:52, 16 January 2019
Line 16:		Line 16:

	=== checks against current tmp projects ===		=== checks against current tmp projects ===
	{{#ask: [[DICApp::CCMDB.mdb]] [[Category: Tmp check]]		{{#ask: [[DICApp::CCMDB.mdb]] [[Category: Tmp check]] [[DICStatus::implemented]]
	\|format=UL		\|format=UL
	}}		}}

Ttenbergen at 03:52, 17 January 2019

2019-01-17T03:52:18Z

← Older revision		Revision as of 22:52, 16 January 2019
Line 10:		Line 10:
	The following things get checked, in this order:		The following things get checked, in this order:
	# are there any patients that don't have the [[Minimal Data Set]]?		# are there any patients that don't have the [[Minimal Data Set]]?
	# are there any TMP entries not consistent with table s_tmp?		# [[Check duplicate patient]]
	# [[~~Postal Code~~]]		# are there any TMP entries not consistent with table s_tmp? ([[query s_tmp_project_item_consistent]])
	# ~~various checks for~~ [[~~:Category:Project~~]]		# any [[#checks against current tmp projects]]
	# are there any patients with [[Eliminating a diagnosis from collection\|diagnoses we are eliminating]]?		# are there any patients with [[Eliminating a diagnosis from collection\|diagnoses we are eliminating]]?
	# [[~~query s_tmp_project_item_consistent~~]]
			=== checks against current tmp projects ===
			{{#ask: [[DICApp::CCMDB.mdb]] [[Category: Tmp check]]
			\|format=UL
			}}

			== Related articles ==
			{{Related Articles}}

	[[Category: CCMDB.mdb]]		[[Category: CCMDB.mdb]]
	[[Category: Main Form]]		[[Category: Main Form]]

Ttenbergen: Text replacement - "Category:All Projects" to "Category:Project"

2019-01-03T05:27:00Z

Text replacement - "Category:All Projects" to "Category:Project"

← Older revision		Revision as of 00:27, 3 January 2019
Line 12:		Line 12:
	# are there any TMP entries not consistent with table s_tmp?		# are there any TMP entries not consistent with table s_tmp?
	# [[Postal Code]]		# [[Postal Code]]
	# various checks for [[:Category:~~All Projects~~]]		# various checks for [[:Category:Project]]
	# are there any patients with [[Eliminating a diagnosis from collection\|diagnoses we are eliminating]]?		# are there any patients with [[Eliminating a diagnosis from collection\|diagnoses we are eliminating]]?
	# [[query s_tmp_project_item_consistent]]		# [[query s_tmp_project_item_consistent]]

Ttenbergen: /* What is actually checked */

2018-09-22T15:13:47Z

What is actually checked

← Older revision		Revision as of 10:13, 22 September 2018
Line 14:		Line 14:
	# various checks for [[:Category:All Projects]]		# various checks for [[:Category:All Projects]]
	# are there any patients with [[Eliminating a diagnosis from collection\|diagnoses we are eliminating]]?		# are there any patients with [[Eliminating a diagnosis from collection\|diagnoses we are eliminating]]?
			# [[query s_tmp_project_item_consistent]]

	[[Category: CCMDB.mdb]]		[[Category: CCMDB.mdb]]
	[[Category: Main Form]]		[[Category: Main Form]]

Ttenbergen: link fix

2016-10-31T16:53:01Z

link fix

← Older revision		Revision as of 11:53, 31 October 2016
Line 12:		Line 12:
	# are there any TMP entries not consistent with table s_tmp?		# are there any TMP entries not consistent with table s_tmp?
	# [[Postal Code]]		# [[Postal Code]]
	# various checks for [[:Category:~~Special Short Term~~ Projects ~~\| Special Short Term Projects]], e.g.~~		# various checks for [[:Category:All Projects]]
	~~#* [[QAInf]]~~
	~~#* [[QASeptic~~]]
	# are there any patients with [[Eliminating a diagnosis from collection\|diagnoses we are eliminating]]?		# are there any patients with [[Eliminating a diagnosis from collection\|diagnoses we are eliminating]]?

	[[Category: CCMDB.mdb]]		[[Category: CCMDB.mdb]]
	[[Category: Main Form]]		[[Category: Main Form]]

Ttenbergen: updated article after questions about the button...

2014-09-04T17:45:39Z

updated article after questions about the button...

← Older revision		Revision as of 12:45, 4 September 2014
Line 1:		Line 1:
	~~When complete patients are being~~ [[~~Sending Patients \|sent~~]] ~~some data is also sent for patients who are not yet complete, for example:~~		The '''"Pre-send Checker"''' button on the main screen of [[CCMDB.mdb]] applies the same checks that will happen automaticlaly before sending.
	* [[Minimal Data Set]]
	* certain [[:Category: Special Short Term Projects]]
	* certain [[:Category: All Projects]] data

	~~Since these patients don't have~~ the ~~[[RecordStatus field]] set to "complete" that can not be used as a trigger to ensure all~~ is ~~correct before sending. For that reason, this data is checked when either the~~ '''~~Send Records~~''' or the '~~''Pre-~~send ~~TmpV2 Checker'''~~ button ~~is pressed~~.		== Use ==
			Use of the button is '''completely optional'''. It is intended so collectors can check if their data is complete before leaving the ward, so they don't need to go back to get additional information when they try to send, and sending rejects their data.
			The same checks get applied automatically before sending, so there is no need to click this button before sending.

	==What is actually checked==		==What is actually checked==
Line 10:		Line 9:

	The following things get checked, in this order:		The following things get checked, in this order:

	# are there any patients that don't have the [[Minimal Data Set]]?		# are there any patients that don't have the [[Minimal Data Set]]?
	# are there any TMP entries not consistent with table s_tmp?		# are there any TMP entries not consistent with table s_tmp?
			# [[Postal Code]]
	# various checks for [[:Category:Special Short Term Projects \| Special Short Term Projects]], e.g.		# various checks for [[:Category:Special Short Term Projects \| Special Short Term Projects]], e.g.
	#* [[QAInf]]		#* [[QAInf]]

Ttenbergen: /* What is actually checked */

2013-07-02T19:46:04Z

What is actually checked

← Older revision		Revision as of 14:46, 2 July 2013
Line 11:		Line 11:
	The following things get checked, in this order:		The following things get checked, in this order:

	~~First, a number of tests get run successively on every record in the table L_TmpV2:~~		# are there any patients that don't have the [[Minimal Data Set]]?
	~~# a patient must exist for every entry in L_TmpV2~~		# are there any TMP entries not consistent with table s_tmp?
	# the ~~patient must have a '''location'''~~		# various checks for [[:Category:Special Short Term Projects \| Special Short Term Projects]], e.g.
	#*some tmp studies only apply in some location, and those checks will fail if this were not ~~entered~~		#* [[QAInf]]
	~~# there must be an item for every entry in L_TmpV2~~		#* [[QASeptic]]
	# various checks for [[:Category:Special Short Term Projects \| Special Short Term Projects]]		# are there any patients with [[Eliminating a diagnosis from collection\|diagnoses we are eliminating]]?
	# ~~various checks for~~ [[~~ER Wait~~]]

	~~Then, a number of tests are run on the entire L_TmpV2 table:~~
	# ~~do all patients that ought to have a move, have one?~~
	# are ~~there several moves with identical times?~~
	~~# are there two consecutive transfusions in < 5min?~~

	~~Then there is one check that is run at this time even though it's not really related to tmp:~~
	* Are there any patients ~~that don't have the~~ [[~~Minimal Data Set~~]]?

	[[Category: CCMDB.mdb]]		[[Category: CCMDB.mdb]]
	[[Category: Main Form]]		[[Category: Main Form]]