Query check ICD10 duplicates
Data Integrity Checks | |
Summary: | Admit and Comorbid ICD10 Diagnoses (except for Category:Pathogens or Category:Antibiotic resistance and Category:Mechanism and Colonized with organism (not infected)) can't be entered in duplicate. |
Related: | Admit Diagnosis, Comorbid Diagnosis |
Firmness: | hard check |
Timing: | complete |
App: | CCMDB.accdb |
Coding: | query check_ICD10_duplicates |
Uses L Problem table: | not relevant for this app |
Status: | implemented |
Implementation Date: | 2022-02-10 |
Backlogged: | true |
Log
- 2022-02-17 - added Past history, cancer (any type), believed cured to allowed duplicates
- 2022-02-16 - excluded additional allowed duplication scenarios
- 2022-02-10 - the list to count had included lines for each category so there was much duplication. Broke out query to generate unique values first, now count works
- 2019-03-25 - excluded dxs in Category:Pathogens, Category:Antibiotic resistance and Category:Mechanism
![]() |
|
Related articles
Related articles: |