| Data Integrity Checks
|
| Summary:
|
* there has to be exactly one dx per patient with Dx Primary checked
|
| Related:
|
[[Dx Primary]]
|
| Firmness:
|
hard check
|
| Timing:
|
|
| App:
|
CCMDB.mdb
|
| 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
|
"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.
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