Query check CCI TISS NrDays GT LOS: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
m Ttenbergen moved page Query check CCI TISS each day to Query check CCI TISS NrDays GT LOS without leaving a redirect: need to break the check in two, one can run early
mNo edit summary
 
(11 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Data Integrity Check
{{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; Accept DtTm; 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 = incomplete
| DIC_app = CCMDB.accdb
| 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 ==
== 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 ==
== Related articles ==
Line 22: Line 21:
[[Category:CCI]]
[[Category:CCI]]
[[Category:CCI Px check‎]]
[[Category:CCI Px check‎]]
[[Category:TISS28 checks]]
[[Category:TISS28 check]]
[[Category:Registry checks]]
[[Category:Length of stay]]
[[Category:TISS28 timing checks]]

Latest revision as of 10:38, 2023 November 25

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: implemented
Implementation Date: 2021-01-21
Backlogged: true
  • Cargo


  • SMW


  • Categories:  
  • form:

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

Log

  • 2023-11-25 - updated to use new function admission_program([L_Log.Pat_ID])
  • 2021-01-21 - check defined and implemented

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_CCI_TISS_NrDays_GT_LOS&oldid=160454"