Query check ICD10 awaiting has Transfer Ready DtTm: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m Text replacement - "format=list" to "format=plainlist" |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (8 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
| DIC_summary = Any patient who has code in [[:Category:Awaiting/delayed transfer]] has to have a [[Transfer Ready DtTm]] on a different day than their [[Dispo DtTm]]. | |DIC_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]]. | ||
| DIC_related_concepts = | |DIC_related_concepts=Awaiting/delayed transfer to long-term care/PCH inside or outside of Winnipeg; Transfer Ready DtTm tmp entry | ||
| DIC_firmness = hard check | |DIC_firmness=hard check | ||
| 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=implemented | ||
| DIC_status = implemented | |DIC_app=CCMDB.accdb | ||
| | |DIC_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]]. | 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 == | == Log == | ||
2019-01-22 - added requirement that [[Transfer Ready DtTm]] must be on different date than [[Dispo_DtTm]]. | * 2022-06-30 - [[Change from Awaiting/delayed dx codes to Transfer Ready DtTm]] was mostly reverted. We are now only collecting [[Awaiting/delayed transfer to long-term care/PCH inside or outside of Winnipeg]]. Confirmed that no changes are required to the check to accommodate this change. [[User:Ttenbergen|Ttenbergen]] 15:47, 2022 June 30 (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 DtTm]]) '''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: | |||
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 | |||
FROM ((L_Log INNER JOIN L_ICD10 ON L_Log.Pat_ID = L_ICD10.Pat_ID) INNER JOIN s_ICD10_Categories ON L_ICD10.ICD10_code = s_ICD10_Categories.ICD10_code) LEFT JOIN (SELECT L_TmpV2.Pat_ID, L_TmpV2.Project, L_TmpV2.date_var, L_TmpV2.time_var FROM L_TmpV2 WHERE (((L_TmpV2.Project)="Transfer Ready DtTm") AND ((L_TmpV2.date_var) Is Not Null))) AS L_TmpV2_transfer_ready_DtTm ON L_Log.Pat_ID = L_TmpV2_transfer_ready_DtTm.Pat_ID | |||
WHERE (((L_Log.Pat_ID)=[param]) AND ((s_ICD10_Categories.ICD10_category)="Awaiting/delayed transfer") AND ((L_Log.Transfer_Ready_DtTm) Is Null) AND ((L_TmpV2_transfer_ready_DtTm.date_var) Is Null)) OR (((L_Log.Pat_ID)=[param]) AND ((s_ICD10_Categories.ICD10_category)="Awaiting/delayed transfer") AND ((DateValue(Nz([Dispo_DtTm],#1/1/1900#))<>DateValue(Nz([Transfer_Ready_DtTm],Nz([date_var],[Dispo_DtTm]))))=False)); | |||
--> | |||
* 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]]. | |||
== Related articles == | == Related articles == | ||
Latest revision as of 14:47, 2022 June 30
| 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, 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
- 2022-06-30 - Change from Awaiting/delayed dx codes to Transfer Ready DtTm was mostly reverted. We are now only collecting Awaiting/delayed transfer to long-term care/PCH inside or outside of Winnipeg. Confirmed that no changes are required to the check to accommodate this change. Ttenbergen 15:47, 2022 June 30 (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 DtTm) 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.