Query check CCI TISS NrDays GT LOS: Difference between revisions

(8 intermediate revisions by the same user not shown)

Line 3:

| 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_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

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

* 2021-01-21 - check defined and implemented

== Related articles ==

Line 22:

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 3: / Line 3: @@
 | 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_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
+* 2023-11-25 - updated to use new function admission_program([L_Log.Pat_ID])
+* 2021-01-21 - check defined and implemented
 == Related articles ==
@@ Line 22: / 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]]