Query check ICD10 date

From CCMDB Wiki
Jump to navigation Jump to search
Data Integrity Checks
Summary: Acquired Diagnosis / Complication must have Dx Date or Dx Date unknown, other Dx Type must have neither, and must be Admit DtTm<Dx_Date<Dispo_DtTm
Related: ICD10 Diagnosis, Acquired Diagnosis, Admit Diagnosis, Comorbid Diagnosis, Dx Type, Dx Date, Dx Date unknown, Dispo DtTm field, Service tmp entry
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: query check_ICD10_date
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2018-10-01
Backlogged: No
  • Cargo

  • SMW

  • Categories: 
  • form:

If this check changes, consider whether Query check CCI Date should be changed the same way.


  • 2022-03-31 - updated to use first Service tmp entry instead of "Accept DtTm"
  • 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: