Query check dx primary not exactly one: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
m Text replacement - "CCMDB.mdb" to "CCMDB.accdb"
Line 7: Line 7:
|DIC_status=implemented
|DIC_status=implemented
|DIC_LProblem=No
|DIC_LProblem=No
|DIC_app=CCMDB.mdb
|DIC_app=CCMDB.accdb
}}
}}
Incidentally, this check also makes sure that at least one Admit Diagnosis must be present, so this doesn't need to be checked separately.
Incidentally, this check also makes sure that at least one Admit Diagnosis must be present, so this doesn't need to be checked separately.

Revision as of 11:01, 22 September 2019

Data Integrity Checks
Summary: There has to be exactly one dx per patient with Dx Primary checked, and it has to be an Admit Diagnosis
Related: Dx Primary, Admit Diagnosis, Primary Admit Diagnosis
Firmness: hard check
Timing: always
App: CCMDB.accdb
Coding: query check_dx_primary_not_exactly_one
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2018-10-01
Backlogged: true
  • Cargo


  • SMW


  • Categories:  
  • form:

Incidentally, this check also makes sure that at least one Admit Diagnosis must be present, so this doesn't need to be checked separately.

Related articles

Related articles: