Query check CCI Date

From CCMDB Wiki
Jump to navigationJump to search
Data Integrity Checks
Summary: Px Date must be sensible when compared to Accept_DtTm and Dispo_DtTm
Related: Px Date, Accept_DtTm, 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: 

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


  • 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: