Query check CCI if no then none - Revision history

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

2025-07-30T16:56:42Z

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

← Older revision		Revision as of 11:56, 30 July 2025
Line 16:		Line 16:
	{{Related Articles}}		{{Related Articles}}

	[[Category: CCI]]		[[Category:CCI]]
	[[Category: CCI Px check‎]]		[[Category:CCI Px check‎]]

Ttenbergen at 04:32, 21 January 2021

2021-01-21T04:32:16Z

← Older revision		Revision as of 23:32, 20 January 2021
Line 6:		Line 6:
	\| DIC_app = CCMDB.accdb		\| DIC_app = CCMDB.accdb
	\| DIC_coding = query ''check_CCI_if_no_then_none''		\| DIC_coding = query ''check_CCI_if_no_then_none''
	\| DIC_status = ~~needs review~~		\| DIC_status = implemented
	\| DIC_implementation_date = ~~2018~~-10-14		\| DIC_implementation_date = 2021-01-20
	}}		}}

	~~{{TT \| param might be in wrong spot~~, ~~must test~~ this query}}		== Log ==
			* 2021-01-20 - the check never worked because it wasn't matching Pat_ID correctly; this was fixed today, meaning effectively this query was only implemented today, so changing the implementation date above.

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

Ttenbergen at 03:08, 21 January 2021

2021-01-21T03:08:25Z

← Older revision		Revision as of 22:08, 20 January 2021
Line 6:		Line 6:
	\| DIC_app = CCMDB.accdb		\| DIC_app = CCMDB.accdb
	\| DIC_coding = query ''check_CCI_if_no_then_none''		\| DIC_coding = query ''check_CCI_if_no_then_none''
	\| DIC_status = ~~implemented~~		\| DIC_status = needs review
	\| DIC_implementation_date = 2018-10-14		\| DIC_implementation_date = 2018-10-14
	}}		}}

			{{TT \| param might be in wrong spot, must test this query}}

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

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

2019-09-22T16:45:17Z

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

← Older revision		Revision as of 11:45, 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 = query ''check_CCI_if_no_then_none''		\| DIC_coding = query ''check_CCI_if_no_then_none''
	\| DIC_status = implemented		\| DIC_status = implemented

Ttenbergen at 03:26, 27 October 2018

2018-10-27T03:26:49Z

← Older revision		Revision as of 22:26, 26 October 2018
Line 1:		Line 1:
	{{Data Integrity Check		{{Data Integrity Check
	\| DIC_summary = If [[No procedure performed]] in [[CCI Picklist]] there must be no other entries in [[CCI Picklist]] or [[CCI Component]]		\| DIC_summary = If [[No procedure performed]] in [[CCI Picklist]] there must be no other entries in [[CCI Picklist]] or [[CCI Component]]
	\| DIC_related_concepts = [[CCI Picklist~~]], [[~~CCI Component~~]], [[~~No procedure performed]]		\| DIC_related_concepts = CCI Picklist; CCI Component; No procedure performed
	\| DIC_firmness = hard check		\| DIC_firmness = hard check
	\| DIC_timing = complete		\| DIC_timing = complete

Ttenbergen at 20:41, 14 October 2018

2018-10-14T20:41:37Z

← Older revision		Revision as of 15:41, 14 October 2018
Line 6:		Line 6:
	\| DIC_app = CCMDB.mdb		\| DIC_app = CCMDB.mdb
	\| DIC_coding = query ''check_CCI_if_no_then_none''		\| DIC_coding = query ''check_CCI_if_no_then_none''
	\| DIC_status = ~~ready to implement~~		\| DIC_status = implemented
	\| DIC_implementation_date =		\| DIC_implementation_date = 2018-10-14
	}}		}}

	* need to make sure each pt has at least one CCI entry, possibly [[No procedure performed]].

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

Ttenbergen: Created page with "{{Data Integrity Check | DIC_summary = If No procedure performed in CCI Picklist there must be no other entries in CCI Picklist or CCI Component | DIC_related..."

2018-10-14T19:13:31Z

Created page with "{{Data Integrity Check | DIC_summary = If No procedure performed in CCI Picklist there must be no other entries in CCI Picklist or CCI Component | DIC_related..."

New page

{{Data Integrity Check
| DIC_summary = If [[No procedure performed]] in [[CCI Picklist]] there must be no other entries in [[CCI Picklist]] or [[CCI Component]]
| DIC_related_concepts = [[CCI Picklist]], [[CCI Component]], [[No procedure performed]]
| DIC_firmness = hard check
| DIC_timing = complete
| DIC_app = CCMDB.mdb
| DIC_coding = query ''check_CCI_if_no_then_none''
| DIC_status = ready to implement
| DIC_implementation_date =
}}

* need to make sure each pt has at least one CCI entry, possibly [[No procedure performed]].

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

[[Category: CCI]]
[[Category: CCI Px check‎]]