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
| 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]] or [[Dx Date unknown]]
| DIC_firmness = hard check  
| DIC_firmness = hard check  
Line 9: Line 9:
| DIC_implementation_date = 2018-10-01
| DIC_implementation_date = 2018-10-01
}}
}}
'''If this check changes, consider whether [[Px Chronological]] should be changed the same way.'''


== Related articles ==
== Related articles ==

Revision as of 17:41, 27 September 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 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: