Query check CCI TISS NrDays GT LOS: Difference between revisions

Revision as of 11:28, 21 January 2021

Data Integrity Checks
Summary:	There are more TISS Item Px_Dates than there are days between the first Service tmp entry and Dispo DtTm
Related:	CCI Picklist, Service tmp entry, Dispo DtTm
Firmness:	hard check
Timing:	incomplete
App:	CCMDB.accdb
Coding:	query check_CCI_TISS_NrDays_GT_LOS
Uses L Problem table:	not relevant for this app
Status:	ready to implement
Implementation Date:
Backlogged:	true

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

@@ 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''
@@ Line 9: / Line 9: @@
 | DIC_implementation_date =
 }}
+This check can be done on incomplete records because even for those there is never a reason there would be extra TISS days.
 Will replace [[Query TISS Errors missing days]]; [[Query TISS Errors NrTISSDays NE LOS]]
-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
+* 2021-01-21 - check defined
 == Related articles ==