Query check CCI Date

From CCMDB Wiki
Jump to navigation Jump to search
Data Integrity Checks
Summary: Px Date must be sensible when compared to first Service tmp entry and Dispo_DtTm
Related: Px Date, Service tmp entry, Dispo_DtTm, Px Type
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: query check_CCI_Date
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2018-10-14
Backlogged: true
  • Cargo

  • SMW

  • Categories: 
  • form:

If this check changes, consider whether Query check ICD10 date should be changed the same way.


  • 2022-03-31 - updated to use first Service tmp entry instead of "Accept DtTm"
  • 2021-03-24 - Julie flagged a false negative that was probably from before the last log
  • 2021-01-20 - confirmed that both dates before admit and after dispo are caught.
  • 2020-10-15 - changed start limit from "Arrive DtTm" to "Accept DtTm" since we now collect data on pts starting at ER arrival, and the EMIP distinction is going away.

Related Articles

Related articles: