Query check ICD10 date: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_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]]
| DIC_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]]
| DIC_related_concepts = [[ICD10 Diagnosis]], [[Acquired Diagnosis]], [[Admit Diagnosis]], [[Comorbid Diagnosis]], [[Dx Type]], [[Dx Date]] or [[Dx Date unknown]]
| DIC_related_concepts = ICD10 Diagnosis; Acquired Diagnosis; Admit Diagnosis; Comorbid Diagnosis; Dx Type; Dx Date; Dx Date unknown
| DIC_firmness = hard check  
| DIC_firmness = hard check  
| DIC_timing = complete
| DIC_timing = complete

Revision as of 16:00, 26 October 2018

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
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. 
  • Categories:  
  • form:

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

Related articles

Related articles: