Query check CCI each count vs LOS - Revision history

Ttenbergen at 21:50, 24 April 2024

2024-04-24T21:50:11Z

@@ Line 1: / Line 1: @@
 {{Data Integrity Check
 |DIC_summary=Confirm that a [[:Category:Labs Imaging]] count is not unreasonably high
-|DIC_related_concepts=
+|DIC_related_concepts=Blood gas, venous; Blood gas, arterial; CXR (plain film); Angiogram, aortic (any part of aorta); Angiogram, coronary (diagnostic cardiac catheterization); ECHO (echocardiogram of heart); Cardiac CT or Cardiac CT angiogram (with or without coronary arteries); Cardiac MRI; Cardiac nuclear scan (e.g. MUGA); Angiogram, cerebral (including vertebral arteries); CT of chest with PE protocol (CT angiogram of pulmonary vessels); Angiogram, artery NOS (except specifically coded); Angiogram, vein; Angiogram, pulmonary artery (pulmonary arteriogram); AXR (abdominal plain X-ray); LOS
 |DIC_firmness=soft check
 |DIC_timing=complete
@@ Line 24: / Line 9: @@
 |DIC_backlogged=No
 }}
 We have had some CCI count entries that are so high that they are likely errors.
 === CCI codes considered ===

Ttenbergen at 21:47, 24 April 2024

2024-04-24T21:47:59Z

← Older revision		Revision as of 16:47, 24 April 2024
Line 19:		Line 19:
	\|DIC_firmness=soft check		\|DIC_firmness=soft check
	\|DIC_timing=complete		\|DIC_timing=complete
	\|DIC_coding=query ''~~check_CCI_imaging_count_vs_LOS~~''		\|DIC_coding=query ''check_CCI_each_count_vs_LOS''
	\|DIC_status=needs review		\|DIC_status=needs review
	\|DIC_app=CCMDB.accdb		\|DIC_app=CCMDB.accdb

Ttenbergen: Ttenbergen moved page Query check CCI imaging count vs LOS to Query check CCI each count vs LOS without leaving a redirect

2024-04-24T21:47:42Z

Ttenbergen moved page Query check CCI imaging count vs LOS to Query check CCI each count vs LOS without leaving a redirect

← Older revision	Revision as of 16:47, 24 April 2024
(No difference)

Ttenbergen at 21:45, 24 April 2024

2024-04-24T21:45:22Z

← Older revision		Revision as of 16:45, 24 April 2024
Line 26:		Line 26:

	We have had some CCI count entries that are so high that they are likely errors.		We have had some CCI count entries that are so high that they are likely errors.

	~~=== Imaging codes considered ===~~
	* {{CCIPick ByCode\|2.ZZ.13.RA}}
	* {{CCIPick ByCode\|2.ZZ.13.RE}}
	* {{CCIPick ByCode\|3.GY.10.VA}}
	* {{CCIPick ByCode\|3.ID.10.V^}}
	* {{CCIPick ByCode\|3.IP.10.V^}}
	* {{CCIPick ByCode\|3.IP.30}}
	* {{CCIPick ByCode\|3.IP.20}}
	* {{CCIPick ByCode\|3.IP.40}}
	* {{CCIPick ByCode\|3.IP.70}}
	* {{CCIPick ByCode\|3.JM.10.V^}}
	* {{CCIPick ByCode\|3.JY.20}}
	* {{CCIPick ByCode\|3.KV.10.VX}}
	* {{CCIPick ByCode\|3.KX.10.VC}}
	* {{CCIPick ByCode\|3.IM.10.V^}}
	* {{CCIPick ByCode\|3.OT.10.VA}}





	{{CCMDB.accdb cross checks triggering for correct values}}		{{CCMDB.accdb cross checks triggering for correct values}}

	== ~~Checks~~ ==		=== CCI codes considered ===
	~~This uses [[Function LOS()]] to calculate the [[LOS]].~~

	~~=== List of~~ codes~~, pages and collection modes~~ ===
	{{#ask: [[Has CCI Picklist Code::2.ZZ.13.RA\|\|2.ZZ.13.RE\|\|3.GY.10.VA\|\|3.ID.10.V^\|\|3.IP.10.V^\|\|3.IP.30\|\|3.IP.20\|\|3.IP.40\|\|3.IP.70\|\|3.JM.10.V^\|\|3.JY.20\|\|3.KV.10.VX\|\|3.KX.10.VC\|\|3.IM.10.V^\|\|3.OT.10.VA]]		{{#ask: [[Has CCI Picklist Code::2.ZZ.13.RA\|\|2.ZZ.13.RE\|\|3.GY.10.VA\|\|3.ID.10.V^\|\|3.IP.10.V^\|\|3.IP.30\|\|3.IP.20\|\|3.IP.40\|\|3.IP.70\|\|3.JM.10.V^\|\|3.JY.20\|\|3.KV.10.VX\|\|3.KX.10.VC\|\|3.IM.10.V^\|\|3.OT.10.VA]]
	\|?Has CCI Picklist Code=Code		\|?Has CCI Picklist Code=Code
Line 61:		Line 37:
	}}		}}

	=== CCI collect count each ===		== Checks ==
			This uses [[Function LOS()]] to calculate the [[LOS]].

			=== [[Template:CCI collect count each\|CCI collect count each]] and [[Template:CCI collect each\|CCI collect each]] ===
	These should be checked.		These should be checked.

	=== CCI collect count days ===		=== [[Template:CCI collect count days\|CCI collect count days]] ===
	~~"CCI collect count days" should not be higher than LOS. See~~ [[query check_CCI_vs_LOS_count_days_component]] and [[query check_CCI_vs_LOS_count_days_picklist]].		Implemented by [[query check_CCI_vs_LOS_count_days_component]] and [[query check_CCI_vs_LOS_count_days_picklist]].

	=== CCI collect count units ===		=== [[Template:CCI collect count units\|CCI collect count units]] ===
	Discussed with Julie that this one is likely uncheckable. [[User:Ttenbergen\|Ttenbergen]] 15:47, 2021 September 2 (CDT)		Discussed with Julie that this one is likely uncheckable. [[User:Ttenbergen\|Ttenbergen]] 15:47, 2021 September 2 (CDT)

	~~=== CCI collect each ===~~
	~~Discussed with Julie and no specific checks required for this one.~~

	~~{{DT \| except now a bunch of these are collect each ones... }}~~

	== Log ==		== Log ==

Ttenbergen: /* Checks */

2024-04-24T21:21:32Z

Checks

← Older revision		Revision as of 16:21, 24 April 2024
Line 53:		Line 53:
	This uses [[Function LOS()]] to calculate the [[LOS]].		This uses [[Function LOS()]] to calculate the [[LOS]].

			=== List of codes, pages and collection modes ===
	{{#ask: [[Has CCI Picklist Code::2.ZZ.13.RA\|\|2.ZZ.13.RE\|\|3.GY.10.VA\|\|3.ID.10.V^\|\|3.IP.10.V^\|\|3.IP.30\|\|3.IP.20\|\|3.IP.40\|\|3.IP.70\|\|3.JM.10.V^\|\|3.JY.20\|\|3.KV.10.VX\|\|3.KX.10.VC\|\|3.IM.10.V^\|\|3.OT.10.VA]]		{{#ask: [[Has CCI Picklist Code::2.ZZ.13.RA\|\|2.ZZ.13.RE\|\|3.GY.10.VA\|\|3.ID.10.V^\|\|3.IP.10.V^\|\|3.IP.30\|\|3.IP.20\|\|3.IP.40\|\|3.IP.70\|\|3.JM.10.V^\|\|3.JY.20\|\|3.KV.10.VX\|\|3.KX.10.VC\|\|3.IM.10.V^\|\|3.OT.10.VA]]
	\|?Has CCI Collection Mode		\|?Has CCI Picklist Code=Code
			\|?Has CCI Collection Mode=Collection mode
	\|sort=Has CCI Collection Mode,Has CCI Picklist Code		\|sort=Has CCI Collection Mode,Has CCI Picklist Code
	\|order=asc,asc		\|order=asc,asc
Line 60:		Line 62:

	=== CCI collect count each ===		=== CCI collect count each ===
			These should be checked.

	=== CCI collect count days ===		=== CCI collect count days ===

Ttenbergen: /* What are likely maximum entries? */ deleted standard deviation info since we won't be using that now

2024-04-24T21:18:37Z

What are likely maximum entries?: deleted standard deviation info since we won't be using that now

← Older revision		Revision as of 16:18, 24 April 2024
Line 47:		Line 47:


	~~=== What are likely maximum entries? ===~~
	The count per patient stay is related to the [[LOS]]. The threshold limits are either Mean + 3 Standard Deviation or Maximum value of Chest X-ray count per patient day for various LOS category listed in the table below. They are derived from July 1988 to June 2017 Lab data. The LOS is based on calendar dates where partial stay is considered as full day.

	*LOS based on calendar dates = [[Function LOS()\|Function LOS()]] + 1
	** if patient is still in the unit, [[Dispo DtTm]] is replaced by today's date
	*** check is marked as only running on complete records, if that is so then we don't need to replace with today's date
	*Chest X-ray (CXR) per patient day = Number of chest X-rays / LOS Based on calendar dates

	~~{\| class="wikitable sortable"~~
	~~! LOS_days !! N !! Mean !! Std Dev !! Minimum !! Median !! 75th Pctl !! 90th Pctl !! 95th Pctl !! 99th Pctl !! Maximum !! mean + 3 Std Dev !! Limits of CXR per patient day~~
	\|-
	~~\|\|1 \|\|4021\|\|1.16\|\|0.42\|\|1\|\|1\|\|1\|\|2\|\|2\|\|3\|\|5\|\|2.42\|\|5~~
	\|-
	~~\|\|2 \|\|23910\|\|0.83\|\|0.31\|\|0.5\|\|1\|\|1\|\|1\|\|1.5\|\|2\|\|4\|\|1.76\|\|4~~
	\|-
	~~\|\|3-10 \|\|52600\|\|0.64\|\|0.34\|\|0.1\|\|0.67\|\|0.88\|\|1\|\|1.25\|\|1.6\|\|3\|\|1.66\|\|3~~
	\|-
	~~\|\|11-20\|\|7784\|\|0.7\|\|0.31\|\|0.05\|\|0.71\|\|0.92\|\|1.09\|\|1.19\|\|1.42\|\|2.47\|\|1.63\|\|2~~
	\|-
	~~\|\|21-30\|\|1870\|\|0.68\|\|0.3\|\|0.03\|\|0.69\|\|0.9\|\|1.05\|\|1.14\|\|1.36\|\|2.57\|\|1.58\|\|2~~
	\|-
	~~\|\|31-40\|\|660\|\|0.62\|\|0.3\|\|0.03\|\|0.64\|\|0.84\|\|1\|\|1.09\|\|1.32\|\|1.67\|\|1.52\|\|2~~
	\|-
	~~\|\|41-50\|\|311\|\|0.54\|\|0.29\|\|0.02\|\|0.53\|\|0.73\|\|0.93\|\|1.02\|\|1.21\|\|1.58\|\|1.41\|\|2~~
	\|-
	~~\|\|51-100\|\|347\|\|0.41\|\|0.26\|\|0.02\|\|0.38\|\|0.6\|\|0.76\|\|0.85\|\|1.12\|\|1.2\|\|1.19\|\|1~~
	\|-
	~~\|\|> 100\|\|101\|\|0.19\|\|0.21\|\|0.01\|\|0.11\|\|0.2\|\|0.48\|\|0.73\|\|0.88\|\|1.09\|\|0.82\|\|1~~
	\|-
	\|}

	{{CCMDB.accdb cross checks triggering for correct values}}		{{CCMDB.accdb cross checks triggering for correct values}}

Ttenbergen: /* CCI collect each */

2024-04-24T21:17:56Z

CCI collect each

← Older revision		Revision as of 16:17, 24 April 2024
Line 98:		Line 98:

	=== CCI collect each ===		=== CCI collect each ===
	Discussed with Julie and no specific checks required for this one.		Discussed with Julie and no specific checks required for this one.

			{{DT \| except now a bunch of these are collect each ones... }}

	== Log ==		== Log ==

Ttenbergen at 21:16, 24 April 2024

2024-04-24T21:16:21Z

← Older revision		Revision as of 16:16, 24 April 2024
Line 24:		Line 24:
	\|DIC_backlogged=No		\|DIC_backlogged=No
	}}		}}

			We have had some CCI count entries that are so high that they are likely errors.

	=== Imaging codes considered ===		=== Imaging codes considered ===
Line 42:		Line 44:
	* {{CCIPick ByCode\|3.OT.10.VA}}		* {{CCIPick ByCode\|3.OT.10.VA}}

	~~=== Discussion ===~~
	~~{{Discuss \|~~
	* Just came across this... the started query includes additional dxs now, as per [[#CCI collect count each]]. Does the proposed accepted count make sense for all the dxs? Your validation table was for CXR. [[User:Ttenbergen\|Ttenbergen]] 11:50, 2023 May 3 (CDT)
	** Did some checking on all 13 LAB Imaging from CCI picklist and found counts more than the LOS only in ECHO, AXR and CXR. Emailed Lisa and Pagasa March 14, 2024 to check if correct or not. Waiting for their feedbacks. In the email, I also propose another query (e.g. the counts per calendar day per patient must not be more than one) as alternative to the threshold limits LOS +- 3 STD shown below. --[[User:JMojica\|JMojica]] 10:55, 2024 March 18 (CDT)
	*** That query is tighter and would therefore have more false positives. What does Lisa think about that? [[User:Ttenbergen\|Ttenbergen]] 09:51, 2024 March 20 (CDT)
	**** I made some limits per LOS group for CXR, AXR, ECHO and Blood gases and emailed the results to Tina and Lisa 3/25/2024 for discussion. ---[[User:JMojica\|JMojica]] 13:28, 2024 March 25 (CDT)
	***** Further emails with Julie and Lisa about details. Discussed with Lisa who is reviewing some of the errors and will hold off until she is done. [[User:Ttenbergen\|Ttenbergen]] 12:46, 2024 April 8 (CDT)
	}}

	~~{{DT \|~~
	*

	~~We have had some medical [[:Category:Labs Imaging]] count entries that are so high that they are likely errors.~~

	=== What are likely maximum entries? ===		=== What are likely maximum entries? ===
Line 110:		Line 101:

	== Log ==		== Log ==
	* 2024-04-24 - implemented LOS <7 and count >10 (i.e. double digits, because that's a likely fumble finger mistake)		* 2024-04-24 -
			** implemented LOS <7 and count >10 (i.e. double digits, because that's a likely fumble finger mistake)
			** initially this was supposed to be for CXR, then general imaging, now all sorts of CCI entries
	* 2022-02-10 - confirmed that this would not be affected by the change of including a time in the [[Px Date]]		* 2022-02-10 - confirmed that this would not be affected by the change of including a time in the [[Px Date]]
	* 2022-01-19 - Julie confirmed that we don't need to check this per [[Boarding Loc]] - per profile is enough (especially since it's a soft check)		* 2022-01-19 - Julie confirmed that we don't need to check this per [[Boarding Loc]] - per profile is enough (especially since it's a soft check)

Ttenbergen at 21:13, 24 April 2024

2024-04-24T21:13:39Z

@@ Line 1: / Line 1: @@
 {{Data Integrity Check
 |DIC_summary=Confirm that a [[:Category:Labs Imaging]] count is not unreasonably high
-|DIC_related_concepts=CXR (plain film); LOS; Service tmp entry; Dispo DtTm
+|DIC_related_concepts=
 |DIC_firmness=soft check
 |DIC_timing=complete
@@ Line 9: / Line 24: @@
 |DIC_backlogged=No
 }}
-* Not currently implemented; starting point for the query exists but doesn't yet include Julie's values. Also, isn't being called from anywhere.
 === Discussion ===
@@ Line 21: / Line 52: @@
 {{DT |
-* We will set up a query that checks LOS <7 and count >10 (i.e. double digits)
 We have had some medical [[:Category:Labs Imaging]] count entries that are so high that they are likely errors.
@@ Line 63: / Line 91: @@
 == Checks ==
 This uses [[Function LOS()]] to calculate the [[LOS]].
 === CCI collect count each ===
 === CCI collect count days ===
@@ Line 85: / Line 110: @@
 == Log ==
 * 2022-02-10 - confirmed that this would not be affected by the change of including a time in the [[Px Date]]
 * 2022-01-19 - Julie confirmed that we don't need to check this per [[Boarding Loc]] - per profile is enough (especially since it's a soft check)

Ttenbergen: Ttenbergen moved page Query check CCI CXR vs LOS to Query check CCI imaging count vs LOS without leaving a redirect: Text replacement - "Query check CCI CXR vs LOS" to "Query check_CCI_imaging_count_vs_LOS"

2024-04-24T20:00:01Z

Ttenbergen moved page Query check CCI CXR vs LOS to Query check CCI imaging count vs LOS without leaving a redirect: Text replacement - "Query check CCI CXR vs LOS" to "Query check_CCI_imaging_count_vs_LOS"

← Older revision	Revision as of 15:00, 24 April 2024
(No difference)