Sub Dx Checker

From CCMDB Wiki
Revision as of 16:18, 24 November 2018 by Ttenbergen (talk | contribs) (Created page with "{{Data Integrity Check | DIC_summary = Runs most Category:Old_dx_check, Category:ICD10 Dx check, Category:CCI Px check, and a few other checks for dxs | DIC_rel...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
Data Integrity Checks
Summary: Runs most Category:Old_dx_check, Category:ICD10 Dx check, Category:CCI Px check, and a few other checks for dxs
Related: ICD10 collection
Firmness: hard check
Timing:
App: CCMDB.mdb
Coding: Sub Dx_Checker
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2008-01-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:

This Sub runs when the checkbox for D is checked. It runs many of the other DIC queries, but it also does some checks via VBA:

  • makes sure all fields of a dx in old codes are checked
  • makes sure that only dx codes appropriate as tasks have type task
  • checks that only patients with an MI are getting MI TPA
  • checks that pt with admit code panelling or discharge planning has transfer ready dttm = admit dttm
  • checks for duplicates
  • makes sure there is at least one admit dx