Query check tmp BedHeld - Revision history

Ttenbergen: Text replacement - "cross check " to "cross check "

2025-06-20T19:25:39Z

Text replacement - "cross check " to "cross check "

← Older revision		Revision as of 14:25, 20 June 2025
Line 20:		Line 20:
	* 2023-07-06 - the query is being called out of tmp checker, so it must be running now, considering question dealt with		* 2023-07-06 - the query is being called out of tmp checker, so it must be running now, considering question dealt with
	* 2023-05-02 - query defined and written but waiting to find out if this can be before complete or only after (emailed)		* 2023-05-02 - query defined and written but waiting to find out if this can be before complete or only after (emailed)
	* 2023-01-11 - Discussed at JALT and decided to not have a cross check for "procedure" against "[[Dispo]]"		* 2023-01-11 - Discussed at JALT and decided to not have a [[cross check]] for "procedure" against "[[Dispo]]"
	* 2023-01-10 - Julie identified needed checks		* 2023-01-10 - Julie identified needed checks

Ttenbergen at 21:05, 8 January 2025

2025-01-08T21:05:34Z

← Older revision		Revision as of 16:05, 8 January 2025
Line 14:		Line 14:
	* if [[BedHeldEnd DtTm]] = [[Dispo DtTm]] and [[Dispo]] = '''"AMA (left against medical advice)"''', should be "'''AMA protocol'''" and vice versa		* if [[BedHeldEnd DtTm]] = [[Dispo DtTm]] and [[Dispo]] = '''"AMA (left against medical advice)"''', should be "'''AMA protocol'''" and vice versa
	* for item in ("'''AMA (AWOL)'''", "'''AMA (Protocol)'''"), [[Dispo]] needs to be "AMA" and vice versa		* for item in ("'''AMA (AWOL)'''", "'''AMA (Protocol)'''"), [[Dispo]] needs to be "AMA" and vice versa
	* if record has [[Dispo]="AMA (left against medical advice)" there must be a [[BedHeldEnd DtTm]] entry		* if record has [[Dispo]]="AMA (left against medical advice)" there must be a [[BedHeldEnd DtTm]] entry

	== Log ==		== Log ==
	* 2025-01-08 - updated [[query check_tmp_BedHeld]] to also flag if record has [[Dispo]="AMA (left against medical advice)" but no [[BedHeldEnd DtTm]] entry		* 2025-01-08 - updated [[query check_tmp_BedHeld]] to also flag if record has [[Dispo]]="AMA (left against medical advice)" but no [[BedHeldEnd DtTm]] entry
	* 2023-07-06 - the query is being called out of tmp checker, so it must be running now, considering question dealt with		* 2023-07-06 - the query is being called out of tmp checker, so it must be running now, considering question dealt with
	* 2023-05-02 - query defined and written but waiting to find out if this can be before complete or only after (emailed)		* 2023-05-02 - query defined and written but waiting to find out if this can be before complete or only after (emailed)

Ttenbergen at 21:05, 8 January 2025

2025-01-08T21:05:18Z

← Older revision		Revision as of 16:05, 8 January 2025
Line 14:		Line 14:
	* if [[BedHeldEnd DtTm]] = [[Dispo DtTm]] and [[Dispo]] = '''"AMA (left against medical advice)"''', should be "'''AMA protocol'''" and vice versa		* if [[BedHeldEnd DtTm]] = [[Dispo DtTm]] and [[Dispo]] = '''"AMA (left against medical advice)"''', should be "'''AMA protocol'''" and vice versa
	* for item in ("'''AMA (AWOL)'''", "'''AMA (Protocol)'''"), [[Dispo]] needs to be "AMA" and vice versa		* for item in ("'''AMA (AWOL)'''", "'''AMA (Protocol)'''"), [[Dispo]] needs to be "AMA" and vice versa
			* if record has [[Dispo]="AMA (left against medical advice)" there must be a [[BedHeldEnd DtTm]] entry

	== Log ==		== Log ==
			* 2025-01-08 - updated [[query check_tmp_BedHeld]] to also flag if record has [[Dispo]="AMA (left against medical advice)" but no [[BedHeldEnd DtTm]] entry
	* 2023-07-06 - the query is being called out of tmp checker, so it must be running now, considering question dealt with		* 2023-07-06 - the query is being called out of tmp checker, so it must be running now, considering question dealt with
	* 2023-05-02 - query defined and written but waiting to find out if this can be before complete or only after (emailed)		* 2023-05-02 - query defined and written but waiting to find out if this can be before complete or only after (emailed)

Ttenbergen at 18:55, 24 April 2024

2024-04-24T18:55:52Z

← Older revision		Revision as of 13:55, 24 April 2024
Line 1:		Line 1:
	{{Data Integrity Check		{{Data Integrity Check
	\|DIC_summary=~~Validates that the DtTm~~ for ~~the first~~ [[~~Service tmp entry]] is the same as that for the first [[Boarding Loc~~]] ~~entry~~		\|DIC_summary=Sanity check for [[BedHeldEnd DtTm]]
	\|DIC_related_concepts=BedHeldEnd DtTm; Dispo DtTm		\|DIC_related_concepts=BedHeldEnd DtTm; Dispo DtTm
	\|DIC_firmness=hard check		\|DIC_firmness=hard check

Ttenbergen at 19:55, 6 July 2023

2023-07-06T19:55:21Z

← Older revision		Revision as of 14:55, 6 July 2023
Line 5:		Line 5:
	\|DIC_timing=complete		\|DIC_timing=complete
	\|DIC_coding=query ''check_tmp_BedHeld''		\|DIC_coding=query ''check_tmp_BedHeld''
	\|DIC_status=~~needs review~~		\|DIC_implementation_date=2023-05-02
			\|DIC_status=implemented
	\|DIC_app=CCMDB.accdb		\|DIC_app=CCMDB.accdb
	\|DIC_backlogged=No		\|DIC_backlogged=No
	}}		}}

	~~{{Todo~~
	~~\| who = Tina~~
	~~\| todo_added = 2023-05-11~~
	~~\| todo_action = 2023-05-11~~
	~~\| question = _dev_ccmdb~~
	* }}

	* dttm entry is always required		* dttm entry is always required
	* for item in ("'''AMA (AWOL)'''", "'''Procedure'''"), [[BedHeldEnd DtTm]] must always be after [[Dispo DtTm]]		* for item in ("'''AMA (AWOL)'''", "'''Procedure'''"), [[BedHeldEnd DtTm]] must always be after [[Dispo DtTm]]
Line 23:		Line 16:

	== Log ==		== Log ==
			* 2023-07-06 - the query is being called out of tmp checker, so it must be running now, considering question dealt with
	* 2023-05-02 - query defined and written but waiting to find out if this can be before complete or only after (emailed)		* 2023-05-02 - query defined and written but waiting to find out if this can be before complete or only after (emailed)
	* 2023-01-11 - Discussed at JALT and decided to not have a cross check for "procedure" against "[[Dispo]]"		* 2023-01-11 - Discussed at JALT and decided to not have a cross check for "procedure" against "[[Dispo]]"

Ttenbergen at 15:17, 11 May 2023

2023-05-11T15:17:22Z

← Older revision		Revision as of 10:17, 11 May 2023
Line 9:		Line 9:
	\|DIC_backlogged=No		\|DIC_backlogged=No
	}}		}}

			{{Todo
			\| who = Tina
			\| todo_added = 2023-05-11
			\| todo_action = 2023-05-11
			\| question = _dev_ccmdb
			* }}

	* dttm entry is always required		* dttm entry is always required

Ttenbergen at 18:09, 3 May 2023

2023-05-03T18:09:17Z

← Older revision		Revision as of 13:09, 3 May 2023
Line 12:		Line 12:
	* dttm entry is always required		* dttm entry is always required
	* for item in ("'''AMA (AWOL)'''", "'''Procedure'''"), [[BedHeldEnd DtTm]] must always be after [[Dispo DtTm]]		* for item in ("'''AMA (AWOL)'''", "'''Procedure'''"), [[BedHeldEnd DtTm]] must always be after [[Dispo DtTm]]
	* if [[BedHeldEnd DtTm]] = [[Dispo DtTm]] and [[Dispo]] = ''AMA'', should be "'''AMA protocol'''" and vice versa		* if [[BedHeldEnd DtTm]] = [[Dispo DtTm]] and [[Dispo]] = '''"AMA (left against medical advice)"''', should be "'''AMA protocol'''" and vice versa
	* for item in ("'''AMA (AWOL)'''", "'''AMA (Protocol)'''"), [[Dispo]] needs to be "AMA" and vice versa		* for item in ("'''AMA (AWOL)'''", "'''AMA (Protocol)'''"), [[Dispo]] needs to be "AMA" and vice versa

Ttenbergen at 17:06, 2 May 2023

2023-05-02T17:06:56Z

← Older revision		Revision as of 12:06, 2 May 2023
Line 12:		Line 12:
	* dttm entry is always required		* dttm entry is always required
	* for item in ("'''AMA (AWOL)'''", "'''Procedure'''"), [[BedHeldEnd DtTm]] must always be after [[Dispo DtTm]]		* for item in ("'''AMA (AWOL)'''", "'''Procedure'''"), [[BedHeldEnd DtTm]] must always be after [[Dispo DtTm]]
	* if [[BedHeldEnd DtTm]] = [[Dispo DtTm]] and [[Dispo]] = ''AMA'', should be "'''AMA protocol'''"		* if [[BedHeldEnd DtTm]] = [[Dispo DtTm]] and [[Dispo]] = ''AMA'', should be "'''AMA protocol'''" and vice versa
	* for item in ("'''AMA (AWOL)'''", "'''AMA (Protocol)'''"), [[Dispo]] needs to be "AMA" and vice versa		* for item in ("'''AMA (AWOL)'''", "'''AMA (Protocol)'''"), [[Dispo]] needs to be "AMA" and vice versa

Ttenbergen at 14:54, 2 May 2023

2023-05-02T14:54:53Z

← Older revision		Revision as of 09:54, 2 May 2023
Line 16:		Line 16:

	== Log ==		== Log ==
	* 2023-05-02 - query ~~started~~		* 2023-05-02 - query defined and written but waiting to find out if this can be before complete or only after (emailed)
	* 2023-01-11 - Discussed at JALT and decided to not have a cross check for "procedure" against "[[Dispo]]"		* 2023-01-11 - Discussed at JALT and decided to not have a cross check for "procedure" against "[[Dispo]]"
	* 2023-01-10 - Julie identified needed checks		* 2023-01-10 - Julie identified needed checks

Ttenbergen at 14:44, 2 May 2023

2023-05-02T14:44:26Z

← Older revision		Revision as of 09:44, 2 May 2023
Line 10:		Line 10:
	}}		}}

			* dttm entry is always required
	* for item in ("'''AMA (AWOL)'''", "'''Procedure'''"), [[BedHeldEnd DtTm]] must always be after [[Dispo DtTm]]		* for item in ("'''AMA (AWOL)'''", "'''Procedure'''"), [[BedHeldEnd DtTm]] must always be after [[Dispo DtTm]]
	* if [[BedHeldEnd DtTm]] = [[Dispo DtTm]] and [[Dispo]] = ''AMA'', should be '''AMA protocol'''		* if [[BedHeldEnd DtTm]] = [[Dispo DtTm]] and [[Dispo]] = ''AMA'', should be "'''AMA protocol'''"
	* if item = '''AMA ~~protocol~~''' or '''AMA (Protocol)''' ~~the dttm entry is still required~~		* for item in ("'''AMA (AWOL)'''", "'''AMA (Protocol)'''"), [[Dispo]] needs to be "AMA" and vice versa
	* for item = '''AMA (AWOL)~~''' AMA entries~~, [[Dispo]] needs to be "AMA"

	== Log ==		== Log ==
	* 2023-01-11 Discussed at JALT and decided to not have a cross check for "procedure" against "[[Dispo]]"		* 2023-05-02 - query started
	* 2023-01-10 Julie identified needed checks		* 2023-01-11 - Discussed at JALT and decided to not have a cross check for "procedure" against "[[Dispo]]"
			* 2023-01-10 - Julie identified needed checks

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