Query check CCI Component duplicates
Jump to navigation
Jump to search
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.accdb |
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.
Log
- 2023-11-25 - checked query as part of Change to having each collector collect both programs on the same laptop and found it to not use the usual column names.
Related articles
Related articles: |