Sub Dx Checker

From CCMDB Wiki
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.accdb
Coding: Sub Dx_Checker
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2008-01-01
Backlogged: true
  • Cargo


  • SMW


  • 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