Query check CCI TISS NrDays GT LOS: Difference between revisions

(13 intermediate revisions by the same user not shown)

Line 1:

{{Data Integrity Check

| DIC_summary = There ~~has to be a~~ TISS ~~entry in [[CCI Picklist]] with a~~ [[Px_Date]] ~~for each date~~ between [[~~Accept DtTm~~]] and [[Dispo DtTm]]

| DIC_summary = There are more TISS Item [[Px_Date]]s than there are days between the first [[Service tmp entry]] and [[Dispo DtTm]]

| DIC_related_concepts = CCI Picklist; ~~No TISS Item (TISS Item)~~

| DIC_related_concepts = CCI Picklist; Service tmp entry; Dispo DtTm

| DIC_firmness = hard check

| DIC_timing = ~~complete~~

| DIC_timing = incomplete

| DIC_app = CCMDB.accdb

| DIC_coding = query ''~~check_CCI_TISS_each_day~~''

| DIC_coding = query ''check_CCI_TISS_NrDays_GT_LOS''

| DIC_status = ~~ready to implement~~

| DIC_status = implemented

| DIC_implementation_date =

| DIC_implementation_date = 2021-01-21

}}

~~Will replace [[Query TISS Errors missing days]]; [[Query TISS Errors NrTISSDays NE LOS]]~~

This check can be done on incomplete records because even for those there is never a reason there would be extra TISS days.

~~Likely implementation: Count the datevalue(px_dates)~~ for ~~the Pat_ID. There have to~~ be ~~at least as many PX dates as there are~~ days ~~between Accept and Dispo. That would not look for continuity explicitly, but it would do so implicitly when combined with the date check that doesn’t allow dates outside of the admission range~~.

== Log ==

* 2021-01-20 - check defined and implemented

* 2023-11-25 - updated to use new function admission_program([L_Log.Pat_ID])

* 2021-01-21 - check defined and implemented

== Related articles ==

Line 23:

Line 21:

[[Category:CCI]]

[[Category:CCI Px check‎]]

[[Category:TISS28 checks]]

[[Category:TISS28 check]]

[[Category:Registry checks]]

[[Category:Length of stay]]

[[Category:TISS28 timing checks]]

@@ Line 1: / Line 1: @@
 {{Data Integrity Check
-| DIC_summary = There has to be a TISS entry in [[CCI Picklist]] with a [[Px_Date]] for each date between [[Accept DtTm]] and [[Dispo DtTm]]
+| DIC_summary = There are more TISS Item [[Px_Date]]s than there are days between the first [[Service tmp entry]] and [[Dispo DtTm]]
-| DIC_related_concepts = CCI Picklist; No TISS Item (TISS Item)
+| DIC_related_concepts = CCI Picklist; Service tmp entry; Dispo DtTm
 | DIC_firmness = hard check
-| DIC_timing = complete
+| DIC_timing = incomplete
 | DIC_app = CCMDB.accdb
-| DIC_coding = query ''check_CCI_TISS_each_day''
+| DIC_coding = query ''check_CCI_TISS_NrDays_GT_LOS''
-| DIC_status = ready to implement
+| DIC_status = implemented
-| DIC_implementation_date =
+| DIC_implementation_date = 2021-01-21
 }}
-Will replace [[Query TISS Errors missing days]]; [[Query TISS Errors NrTISSDays NE LOS]]
+This check can be done on incomplete records because even for those there is never a reason there would be extra TISS days.
-Likely implementation: Count the datevalue(px_dates) for the Pat_ID. There have to be at least as many PX dates as there are days between Accept and Dispo. That would not look for continuity explicitly, but it would do so implicitly when combined with the date check that doesn’t allow dates outside of the admission range.
 == Log ==
-* 2021-01-20 - check defined and implemented
+* 2023-11-25 - updated to use new function admission_program([L_Log.Pat_ID])
+* 2021-01-21 - check defined and implemented
 == Related articles ==
@@ Line 23: / Line 21: @@
 [[Category:CCI]]
 [[Category:CCI Px check‎]]
-[[Category:TISS28 checks]]
+[[Category:TISS28 check]]
+[[Category:Registry checks]]
+[[Category:Length of stay]]
+[[Category:TISS28 timing checks]]