Query check ICD10 awaiting has Transfer Ready DtTm: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 5: | Line 5: | ||
|DIC_timing=complete | |DIC_timing=complete | ||
|DIC_coding=Query ''check_ICD10_awaiting_has_Transfer_Ready_DtTm'' | |DIC_coding=Query ''check_ICD10_awaiting_has_Transfer_Ready_DtTm'' | ||
|DIC_status= | |DIC_status=implemented | ||
|DIC_app=CCMDB.accdb | |DIC_app=CCMDB.accdb | ||
|DIC_backlogged=No | |DIC_backlogged=No | ||
| Line 13: | Line 13: | ||
== Log == | == Log == | ||
* 2021-06-11 - This had been implemented that as "error if any record with awaiting code has either (no [[Transfer Ready DtTm]] and no [[Transfer Ready Tmp entry]]) '''or (there is a Transfer ready dttm (old or new) that is the same as the Dispo DtTm)'''. That made sense when there could only be one Transfer ready dttm, but now that there can be more, the bold part would have to be ''(... and there is not at least one Transfer Date that is not the same as the Dispo DtTm)''. That one would be pretty messy to set up, and have limited benefit, so I will remove that second check from the query. Emailed Julie so if she feels strongly about the second part we can review. [[User:Ttenbergen|Ttenbergen]] 16:17, 2021 June 11 (CDT) | * 2021-06-11 - This had been implemented that as "error if any record with awaiting code has either (no [[Transfer Ready DtTm tmp entry]] and no [[Transfer Ready Tmp entry]]) '''or (there is a Transfer ready dttm (old or new) that is the same as the Dispo DtTm)'''. That made sense when there could only be one Transfer ready dttm, but now that there can be more, the bold part would have to be ''(... and there is not at least one Transfer Date that is not the same as the Dispo DtTm)''. That one would be pretty messy to set up, and have limited benefit, so I will remove that second check from the query. Emailed Julie so if she feels strongly about the second part we can review. [[User:Ttenbergen|Ttenbergen]] 16:17, 2021 June 11 (CDT) | ||
<!-- old query: | <!-- old query: | ||
SELECT L_Log.Pat_ID, L_ICD10.ICD10_code, s_ICD10_Categories.ICD10_category, L_Log.Transfer_Ready_DtTm AS old_TRDT, L_TmpV2_transfer_ready_DtTm.date_var AS New_TRDT, L_Log.Dispo_DtTm, DateValue(Nz([Dispo_DtTm],#1/1/1900#))<>DateValue(Nz([Transfer_Ready_DtTm],Nz([date_var],[Dispo_DtTm]))) AS DiffDate | SELECT L_Log.Pat_ID, L_ICD10.ICD10_code, s_ICD10_Categories.ICD10_category, L_Log.Transfer_Ready_DtTm AS old_TRDT, L_TmpV2_transfer_ready_DtTm.date_var AS New_TRDT, L_Log.Dispo_DtTm, DateValue(Nz([Dispo_DtTm],#1/1/1900#))<>DateValue(Nz([Transfer_Ready_DtTm],Nz([date_var],[Dispo_DtTm]))) AS DiffDate | ||
Revision as of 15:18, 2021 June 11
| Data Integrity Checks | |
| Summary: | Any patient who has code in Category:Awaiting/delayed transfer has to have a (Transfer Ready DtTm or Transfer Ready DtTm tmp entry) on a different day than their Dispo DtTm. |
| Related: | Awaiting/delayed transfer to long-term care/PCH inside or outside of Winnipeg, Change from Awaiting/delayed dx codes to Transfer Ready DtTm, Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm, Template:ICD10 Guideline AwaitingTransfer, Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days, Task Team Meeting - Rolling Agenda and Minutes 2021, Transfer Ready DtTm tmp entry |
| Firmness: | hard check |
| Timing: | complete |
| App: | CCMDB.accdb |
| Coding: | Query check_ICD10_awaiting_has_Transfer_Ready_DtTm |
| Uses L Problem table: | not relevant for this app |
| Status: | implemented |
| Implementation Date: | not entered |
| Backlogged: | No |
As per Template:ICD10 Guideline AwaitingTransfer, an awaiting code should be entered if actual discharge is "not on the same calendar day". So, everyone who has an awaiting code has to have Dispo DtTm on different day from Transfer Ready DtTm.
Log
- 2021-06-11 - This had been implemented that as "error if any record with awaiting code has either (no Transfer Ready DtTm tmp entry and no Transfer Ready Tmp entry) or (there is a Transfer ready dttm (old or new) that is the same as the Dispo DtTm). That made sense when there could only be one Transfer ready dttm, but now that there can be more, the bold part would have to be (... and there is not at least one Transfer Date that is not the same as the Dispo DtTm). That one would be pretty messy to set up, and have limited benefit, so I will remove that second check from the query. Emailed Julie so if she feels strongly about the second part we can review. Ttenbergen 16:17, 2021 June 11 (CDT)
- 2020-01-28 - re-instated the check
- 2020-10-15 - suspending the check until new collection scheme for Transfer Ready DtTm tmp entry is settled in
- 2019-01-22 - added requirement that Transfer Ready DtTm must be on different date than Dispo_DtTm.