Query check CCI Component duplicates
| Data Integrity Checks | |
| Summary: | No duplication of CCI Component Px_Type, Px_Date |
| Related: | CCI Component, Px Type, Dx_Priority, No Dx Entered |
| Firmness: | hard check |
| Timing: | complete |
| App: | CCMDB.mdb |
| Coding: | query check_CCI_Component_duplicates |
| Uses L Problem table: | not relevant for this app |
| Status: | implemented |
| Implementation Date: | 2018-10-14 |
| Backlogged: | true |
- Px Type = Acquired – no same Px_Date and CCI code
- Px Type = Admit – no same CCI code (it should not have a Px_Date at all, dealt with by Query check CCI Date).
We are not currently planning to check for CCI Collection Modes being used correctly but this may change.
Waiting for...
We are reviewing some details in the definition of when to count or only enter once etc, so waiting to implement until that is settled.
Related articles
| Related articles: |