Check Sub PharmCheck - Revision history

Ttenbergen: updated documentation, the check was already doing this right since it uses LOS

2022-04-19T20:38:32Z

updated documentation, the check was already doing this right since it uses LOS

← Older revision		Revision as of 15:38, 19 April 2022
Line 1:		Line 1:
	{{Data Integrity Check		{{Data Integrity Check
	\| DIC_summary = ~~checks that every~~ CC pt has at least one pharmacy record (possibly all zeros), ~~that patients don~~'t ~~have more drug days than~~ LOS~~, disallows complete check if [[Arrive DtTm]] or [[Dispo DtTm]] are missing because that would break max count check~~,		\| DIC_summary = Every CC record has to have at least one pharmacy record (possibly all zeros), and the number of drug days can't be GT LOS,
	\| DIC_related_concepts = Pharmacy collection~~; Service tmp entry~~; LOS		\| DIC_related_concepts = Pharmacy collection; LOS
	\| DIC_firmness = hard check		\| DIC_firmness = hard check
	\| DIC_timing = complete		\| DIC_timing = complete

Ttenbergen at 19:23, 31 March 2022

2022-03-31T19:23:33Z

← Older revision		Revision as of 14:23, 31 March 2022
Line 1:		Line 1:
	{{Data Integrity Check		{{Data Integrity Check
	\| DIC_summary = checks that every CC pt has at least one pharmacy record (possibly all zeros), that patients don't have more drug days than LOS, disallows complete check if [[Arrive DtTm]] or [[Dispo DtTm]] are missing because that would break max count check,		\| DIC_summary = checks that every CC pt has at least one pharmacy record (possibly all zeros), that patients don't have more drug days than LOS, disallows complete check if [[Arrive DtTm]] or [[Dispo DtTm]] are missing because that would break max count check,
	\| DIC_related_concepts = Pharmacy collection; ~~Accept DtTm~~; LOS		\| DIC_related_concepts = Pharmacy collection; Service tmp entry; LOS
	\| DIC_firmness = hard check		\| DIC_firmness = hard check
	\| DIC_timing = complete		\| DIC_timing = complete

Ttenbergen at 19:21, 31 March 2022

2022-03-31T19:21:10Z

← Older revision		Revision as of 14:21, 31 March 2022
Line 1:		Line 1:
	{{Data Integrity Check		{{Data Integrity Check
	\| DIC_summary = checks that every CC pt has at least one pharmacy record (possibly all zeros), that patients don't have more drug days than LOS, disallows complete check if [[Arrive DtTm]] or [[Dispo DtTm]] are missing because that would break max count check,		\| DIC_summary = checks that every CC pt has at least one pharmacy record (possibly all zeros), that patients don't have more drug days than LOS, disallows complete check if [[Arrive DtTm]] or [[Dispo DtTm]] are missing because that would break max count check,
	\| DIC_related_concepts = Pharmacy collection~~; Arrive DtTm~~; Accept DtTm; LOS		\| DIC_related_concepts = Pharmacy collection; Accept DtTm; LOS
	\| DIC_firmness = hard check		\| DIC_firmness = hard check
	\| DIC_timing = complete		\| DIC_timing = complete
Line 37:		Line 37:

	== Log ==		== Log ==
	* 2022-03-31 - updated ~~to use first [[Service tmp entry]] instead of [[Accept DtTm]]~~		* 2022-03-31 - updated no longer check for starting time since that is now checked from minimal data set query

	== Related articles ==		== Related articles ==

Ttenbergen at 19:19, 31 March 2022

2022-03-31T19:19:32Z

← Older revision		Revision as of 14:19, 31 March 2022
Line 35:		Line 35:
	* if three are duplicate priorities, an error is generated		* if three are duplicate priorities, an error is generated
	* if one of the entries is "No Pharm" and there are other entries, an error is generated}}		* if one of the entries is "No Pharm" and there are other entries, an error is generated}}

			== Log ==
			* 2022-03-31 - updated to use first [[Service tmp entry]] instead of [[Accept DtTm]]

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


	[[Category:Length of stay]]		[[Category:Length of stay]]

Ttenbergen at 21:01, 13 May 2021

2021-05-13T21:01:44Z

← Older revision		Revision as of 16:01, 13 May 2021
Line 1:		Line 1:
	{{Data Integrity Check		{{Data Integrity Check
	\| DIC_summary = checks that every CC pt has at least one pharmacy record (possibly all zeros), that patients don't have more drug days than LOS, disallows complete check if [[Arrive DtTm]] or [[Dispo DtTm]] are missing because that would break max count check,		\| DIC_summary = checks that every CC pt has at least one pharmacy record (possibly all zeros), that patients don't have more drug days than LOS, disallows complete check if [[Arrive DtTm]] or [[Dispo DtTm]] are missing because that would break max count check,
	\| DIC_related_concepts = Pharmacy collection; Arrive DtTm; Accept DtTm, LOS		\| DIC_related_concepts = Pharmacy collection; Arrive DtTm; Accept DtTm; LOS
	\| DIC_firmness = hard check		\| DIC_firmness = hard check
	\| DIC_timing = complete		\| DIC_timing = complete

Ttenbergen at 22:01, 5 May 2021

2021-05-05T22:01:50Z

← Older revision		Revision as of 17:01, 5 May 2021
Line 1:		Line 1:
	{{Data Integrity Check		{{Data Integrity Check
	\| DIC_summary = checks that every CC pt has at least one pharmacy record (possibly all zeros), that patients don't have more drug days than LOS, disallows complete check if [[Arrive DtTm]] or [[Dispo DtTm]] are missing because that would break max count check,		\| DIC_summary = checks that every CC pt has at least one pharmacy record (possibly all zeros), that patients don't have more drug days than LOS, disallows complete check if [[Arrive DtTm]] or [[Dispo DtTm]] are missing because that would break max count check,
	\| DIC_related_concepts = Pharmacy collection, Arrive DtTm, Accept DtTm, LOS		\| DIC_related_concepts = Pharmacy collection; Arrive DtTm; Accept DtTm, LOS
	\| DIC_firmness = hard check		\| DIC_firmness = hard check
	\| DIC_timing = complete		\| DIC_timing = complete

Ttenbergen: uses a function LOS() so that part is no longer relevant

2021-05-05T22:01:30Z

uses a function LOS() so that part is no longer relevant

← Older revision		Revision as of 17:01, 5 May 2021
Line 1:		Line 1:
	{{Data Integrity Check		{{Data Integrity Check
	\| DIC_summary = checks that every CC pt has at least one pharmacy record (possibly all zeros), that patients don't have more drug days than LOS, disallows complete check if [[Arrive DtTm]] or [[Dispo DtTm]] are missing because that would break max count check,		\| DIC_summary = checks that every CC pt has at least one pharmacy record (possibly all zeros), that patients don't have more drug days than LOS, disallows complete check if [[Arrive DtTm]] or [[Dispo DtTm]] are missing because that would break max count check,
	\| DIC_related_concepts = Pharmacy collection		\| DIC_related_concepts = Pharmacy collection, Arrive DtTm, Accept DtTm, LOS
	\| DIC_firmness = hard check		\| DIC_firmness = hard check
	\| DIC_timing = complete		\| DIC_timing = complete
Line 12:		Line 12:
	* each patient has to have at least one line of no entries (implemented)		* each patient has to have at least one line of no entries (implemented)

	* maximum count for any drug must be < LOS~~+2 if calculated using admit date/time & discharge date/~~(~~time or 23:59 if unavailable~~)		uses function LOS() to calculate the LOS
	** implemented as LOS ~~= CLng(Nz(Form_View.R_DisDate) + nz(Form_View.R_DisTime, 1)) - Nz(Form_View.R_AdmDate, 0))~~

	PharmCheck used to be used to do internal consistency checks on Pharmacy data. No longer used since change in Pharmacy data structure 2012-01-01. See [[Pharmacy_collection#Data_Integrity_Rules]] for data consistency checking in new paradigm.		PharmCheck used to be used to do internal consistency checks on Pharmacy data. No longer used since change in Pharmacy data structure 2012-01-01. See [[Pharmacy_collection#Data_Integrity_Rules]] for data consistency checking in new paradigm.

Ttenbergen at 21:53, 5 May 2021

2021-05-05T21:53:33Z

← Older revision		Revision as of 16:53, 5 May 2021
Line 1:		Line 1:
	{{Data Integrity Check		{{Data Integrity Check
	\| DIC_summary = checks that every CC pt has at least one pharmacy record (possibly all zeros), that patients don't have drug days than LOS, disallows complete check if [[Arrive DtTm]] or [[Dispo DtTm]] are missing because that would break max count check,		\| DIC_summary = checks that every CC pt has at least one pharmacy record (possibly all zeros), that patients don't have more drug days than LOS, disallows complete check if [[Arrive DtTm]] or [[Dispo DtTm]] are missing because that would break max count check,
	\| DIC_related_concepts = Pharmacy collection		\| DIC_related_concepts = Pharmacy collection
	\| DIC_firmness = hard check		\| DIC_firmness = hard check
Line 9:		Line 9:
	\| DIC_implementation_date = 2012-01-01		\| DIC_implementation_date = 2012-01-01
	}}		}}



	* each patient has to have at least one line of no entries (implemented)		* each patient has to have at least one line of no entries (implemented)
Line 16:		Line 14:
	* maximum count for any drug must be < LOS+2 if calculated using admit date/time & discharge date/(time or 23:59 if unavailable)		* maximum count for any drug must be < LOS+2 if calculated using admit date/time & discharge date/(time or 23:59 if unavailable)
	** implemented as LOS = CLng(Nz(Form_View.R_DisDate) + nz(Form_View.R_DisTime, 1)) - Nz(Form_View.R_AdmDate, 0))		** implemented as LOS = CLng(Nz(Form_View.R_DisDate) + nz(Form_View.R_DisTime, 1)) - Nz(Form_View.R_AdmDate, 0))


	PharmCheck used to be used to do internal consistency checks on Pharmacy data. No longer used since change in Pharmacy data structure 2012-01-01. See [[Pharmacy_collection#Data_Integrity_Rules]] for data consistency checking in new paradigm.		PharmCheck used to be used to do internal consistency checks on Pharmacy data. No longer used since change in Pharmacy data structure 2012-01-01. See [[Pharmacy_collection#Data_Integrity_Rules]] for data consistency checking in new paradigm.
Line 39:		Line 36:
	* if three are duplicate priorities, an error is generated		* if three are duplicate priorities, an error is generated
	* if one of the entries is "No Pharm" and there are other entries, an error is generated}}		* if one of the entries is "No Pharm" and there are other entries, an error is generated}}

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


			[[Category:Length of stay]]

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

2019-09-22T16:43:06Z

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

← Older revision		Revision as of 11:43, 22 September 2019
Line 4:		Line 4:
	\| DIC_firmness = hard check		\| DIC_firmness = hard check
	\| DIC_timing = complete		\| DIC_timing = complete
	\| DIC_app = CCMDB.~~mdb~~		\| DIC_app = CCMDB.accdb
	\| DIC_coding = Sub ''PharmCheck''		\| DIC_coding = Sub ''PharmCheck''
	\| DIC_status = implemented		\| DIC_status = implemented

Ttenbergen at 00:56, 27 October 2018

2018-10-27T00:56:37Z

← Older revision		Revision as of 19:56, 26 October 2018
Line 1:		Line 1:
	{{Data Integrity Check		{{Data Integrity Check
	\| DIC_summary = checks that every CC pt has at least one pharmacy record (possibly all zeros), that patients don't have drug days than LOS, disallows complete check if [[Arrive DtTm]] or [[Dispo DtTm]] are missing because that would break max count check,		\| DIC_summary = checks that every CC pt has at least one pharmacy record (possibly all zeros), that patients don't have drug days than LOS, disallows complete check if [[Arrive DtTm]] or [[Dispo DtTm]] are missing because that would break max count check,
	\| DIC_related_concepts = ~~PharmCheck~~		\| DIC_related_concepts = Pharmacy collection
	\| DIC_firmness = hard check		\| DIC_firmness = hard check
	\| DIC_timing = complete		\| DIC_timing = complete