Query NDC cardioversion dx vs TISS: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
(2 intermediate revisions by the same user not shown) | |||
Line 6: | Line 6: | ||
|DIC_coding=query ''Query NDC_cardioversion_dx_vs_TISS'' | |DIC_coding=query ''Query NDC_cardioversion_dx_vs_TISS'' | ||
|DIC_implementation_date=2019-01-06 | |DIC_implementation_date=2019-01-06 | ||
|DIC_status= | |DIC_status=retired | ||
|DIC_app= | |DIC_app=Centralized data front end.accdb | ||
|DIC_backlogged=No | |DIC_backlogged=No | ||
}} | }} | ||
Line 17: | Line 17: | ||
Excluded because it would cause false positives: | Excluded because it would cause false positives: | ||
* if both are present dates should be the same; since there could be more than one, matching multiple would require a different query to specifically match dates and only for existing ones; if we decide this is required we can revisit. | * if both are present dates should be the same; since there could be more than one, matching multiple would require a different query to specifically match dates and only for existing ones; if we decide this is required we can revisit. | ||
== Log == | |||
* 2021-10-07 - deleted query from [[CFE]] | |||
* 2020-10-01 - collectoin of [[Cardioversion (TISS Item)]] stopped so this query became irrelevant. | |||
== Related articles == | == Related articles == | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category:TISS28 | [[Category:TISS28 check]] | ||
[[Category:CCI Px check]] | [[Category:CCI Px check]] |
Latest revision as of 15:20, 14 April 2022
Data Integrity Checks | |
Summary: | If pt has Acquired Procedure Cardioversion (EXCLUDE defibrillation-we are not tracking), then the TISS28 item T26 & 27 - Cardioversion (TISS Item) (T41) must be marked. |
Related: | Cardioversion (TISS Item), Acquired Procedure, Cardioversion (EXCLUDE defibrillation-we are not tracking) |
Firmness: | hard check |
Timing: | complete |
App: | Centralized data front end.accdb |
Coding: | query Query NDC_cardioversion_dx_vs_TISS |
Uses L Problem table: | not entered |
Status: | retired |
Implementation Date: | 2019-01-06 |
Backlogged: | No |
Three tests
- if there is Acquired Procedure Cardioversion (EXCLUDE defibrillation-we are not tracking) (a collect first item) then there must be at least one T26 & 27 - Cardioversion (TISS Item)
- if there is even one T26 & 27 - Cardioversion (TISS Item), then there must be a Acquired Procedure Cardioversion (EXCLUDE defibrillation-we are not tracking)
Excluded because it would cause false positives:
- if both are present dates should be the same; since there could be more than one, matching multiple would require a different query to specifically match dates and only for existing ones; if we decide this is required we can revisit.
Log
- 2021-10-07 - deleted query from CFE
- 2020-10-01 - collectoin of Cardioversion (TISS Item) stopped so this query became irrelevant.