Query check dx primary not exactly one
Jump to navigation
Jump to search
| 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 |
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: |