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 = [[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_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: | ||
}} | }} | ||
{{Todo | |||
| who = Tina | |||
| question = | |||
* [[Past history, cancer (any type), believed cured]] needs to be allowed; | |||
| todo_added = 2022-02-17 | |||
| todo_action = 2022-02-17 | |||
}} | |||
== Log == | == Log == | ||
Revision as of 11:48, 17 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: |