Query check ICD10 date

From CCMDB Wiki
Jump to navigationJump 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 Arrive_DtTm<Dx_Date<Dispo_DtTm
Related: ICD10 Diagnosis, Acquired Diagnosis, Admit Diagnosis, Comorbid Diagnosis, Dx Type, Dx Date, Dx Date unknown, Dispo DtTm field, Accept DtTm field
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: 

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


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