Query check CCI each count vs LOS: Difference between revisions

Line 1:

~~‎We~~ have had some medical [[:Category:Labs Imaging]] count entries that are so high that they are likely errors~~. This check is supposed to do that~~.

‎{{Data Integrity Check

| DIC_summary = Confirm that a [[:Category:Labs Imaging]] count is not unreasonably high

| DIC_related_concepts = [[:Category:Labs Imaging]], [[LOS]], [[ArriveDtTm]], [[DispoDtTm]]

| DIC_firmness = hard check

| DIC_timing = complete

| DIC_app = CCMDB.mdb

| DIC_coding = how to find this in containing program, eg. SAS file, function name, query name...

| DIC_status = ready to implement

| DIC_implementation_date =

}}

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

=== 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.

Line 32:

Line 42:

|}

~~=== How the~~ checks ~~will work===~~

At the time you set the patient to complete a check will run to find out if any of the ‎imaging counts are out of range. If none are you won't see this. If a check is out of range you will get an error, and then a list showing the out of range value.

~~Confirm if the value is~~ correct~~. If it is wrong, fix it. If it is correct and the count was in fact unusually high, then enter a lower number and sent Pagasa an email with the correct count.~~

~~{{CCMDB Data Integrity Checks| ready to implement}}~~

[[category:Labs]]

@@ Line 1: / Line 1: @@
-‎We have had some medical [[:Category:Labs Imaging]] count entries that are so high that they are likely errors. This check is supposed to do that.
+‎{{Data Integrity Check
+| DIC_summary = Confirm that a [[:Category:Labs Imaging]] count is not unreasonably high
+| DIC_related_concepts = [[:Category:Labs Imaging]], [[LOS]], [[ArriveDtTm]], [[DispoDtTm]]
+| DIC_firmness = hard check
+| DIC_timing = complete
+| DIC_app = CCMDB.mdb
+| DIC_coding = how to find this in containing program, eg. SAS file, function name, query name...
+| DIC_status = ready to implement
+| DIC_implementation_date =
+}}
+We have had some medical [[:Category:Labs Imaging]] count entries that are so high that they are likely errors.
 === 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.
@@ Line 32: / Line 42: @@
 |}
-=== How the checks will work===
+{{CCMDB.mdb cross checks triggering for correct values}}
-At the time you set the patient to complete a check will run to find out if any of the ‎imaging counts are out of range. If none are you won't see this. If a check is out of range you will get an error, and then a list showing the out of range value.
-Confirm if the value is correct. If it is wrong, fix it. If it is correct and the count was in fact unusually high, then enter a lower number and sent Pagasa an email with the correct count.
-{{CCMDB Data Integrity Checks| ready to implement}}
 [[category:Labs]]