Query check CCI TISS NrDays LT LOS: Difference between revisions

(8 intermediate revisions by 2 users not shown)

Line 1:

{{Data Integrity Check

| DIC_summary = There are more TISS Item [[Px_Date]]s than there are days between the first [[Service tmp entry]] 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; Service tmp entry; Dispo DtTm

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

| DIC_firmness = hard check

|DIC_firmness=hard check

| DIC_timing = complete

|DIC_timing=complete

~~| DIC_app = CCMDB.accdb~~

|DIC_coding=query ''check_CCI_TISS_NrDays_LT_LOS''

| DIC_coding = query ''check_CCI_TISS_NrDays_LT_LOS''

|DIC_implementation_date=2021-01-21

| DIC_status = ~~ready to implement~~

|DIC_status=implemented

| ~~DIC_implementation_date~~ =

|DIC_app=CCMDB.accdb

|DIC_backlogged=No

}}

This check can only be done on '''complete''' records because collectors may not have had a chance to be up-to-date on incomplete records, so TISS days might be missing. Since it is triggered by checking the [[Diag Complete]] it will never run on incomplete patients.

This check can only be done on complete records because collectors may not have had a chance to be up-to-date on incomplete records, so TISS days might be missing.

== Log ==

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

* 2021-09-01 – query was limited to complete patients but is triggered when “D” is checked, so it never triggered at all

* 2021-01-21 - check defined

Line 18:

Line 20:

~~[[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 are more TISS Item [[Px_Date]]s than there are days between the first [[Service tmp entry]] 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; Service tmp entry; Dispo DtTm
+|DIC_related_concepts=CCI Picklist; Service tmp entry; Dispo DtTm
-| DIC_firmness = hard check
+|DIC_firmness=hard check
-| DIC_timing = complete
+|DIC_timing=complete
-| DIC_app = CCMDB.accdb
+|DIC_coding=query ''check_CCI_TISS_NrDays_LT_LOS''
-| DIC_coding = query ''check_CCI_TISS_NrDays_LT_LOS''
+|DIC_implementation_date=2021-01-21
-| DIC_status = ready to implement
+|DIC_status=implemented
-| DIC_implementation_date =
+|DIC_app=CCMDB.accdb
+|DIC_backlogged=No
 }}
+This check can only be done on '''complete''' records because collectors may not have had a chance to be up-to-date on incomplete records, so TISS days might be missing. Since it is triggered by checking the [[Diag Complete]] it will never run on incomplete patients.
-This check can only be done on complete records because collectors may not have had a chance to be up-to-date on incomplete records, so TISS days might be missing.
 == Log ==
+* 2023-11-25 - updated to use new function admission_program([L_Log.Pat_ID])
+* 2021-09-01 – query was limited to complete patients but is triggered when “D” is checked, so it never triggered at all
 * 2021-01-21 - check defined
@@ Line 18: / Line 20: @@
 {{Related Articles}}
-[[Category:CCI]]
 [[Category:CCI Px check‎]]
-[[Category:TISS28 checks]]
+[[Category:TISS28 check]]
+[[Category:Registry checks]]
+[[Category:Length of stay]]
+[[Category:TISS28 timing checks]]