Query check ICD10 duplicates: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
| DIC_summary = [[ICD10 Diagnoses]] (except for [[:Category:Pathogens]] or [[:Category:Antibiotic resistance]] and [[:Category:Mechanism]]) can't be entered in duplicate. | | DIC_summary = [[Admit Diagnosis|Admit]] and [[Comorbid Diagnosis|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. | ||
| DIC_related_concepts = | | DIC_related_concepts = [[Admit Diagnosis]], [[Comorbid Diagnosis]] <!--This would include almost all ICD10 diagnoses in related concepts, which would not be helpful to list, so excluded them. --> | ||
| DIC_firmness = hard check | | DIC_firmness = hard check | ||
| DIC_timing = complete | | DIC_timing = complete | ||
| Line 10: | Line 10: | ||
}} | }} | ||
== Log == | == Log == | ||
* 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 | * 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]] | * 2019-03-25 - excluded dxs in [[:Category:Pathogens]], [[:Category:Antibiotic resistance]] and [[:Category:Mechanism]] | ||
Revision as of 11:18, 16 February 2022
| 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-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: |