Query check ICD10 date

From CCMDB Wiki
Revision as of 17:41, 27 September 2018 by Ttenbergen (talk | contribs)
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 Arrive_DtTm<Dx_Date<Dispo_DtTm
Related: [[ICD10 Diagnosis, Acquired Diagnosis, Admit Diagnosis, Comorbid Diagnosis, Dx Type, Dx Date or Dx Date unknown]]
Firmness: hard check
Timing: complete
App: CCMDB.mdb
Coding: query check ICD10 date
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2018-10-01
Backlogged: true
  • Cargo


  • SMW
"CCMDB.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. Property "DICRelatedConcepts" (as page type) with input value "ICD10 Diagnosis]], Acquired Diagnosis, Admit Diagnosis, Comorbid Diagnosis, Dx Type, Dx Date or [[Dx Date unknown" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.
  • Categories:  
  • form:

If this check changes, consider whether Px Chronological should be changed the same way.

Related articles

Related articles: