Change from Awaiting/delayed dx codes to Transfer Ready DtTm: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
Line 1: Line 1:
We considered changing how we track where people who are awaiting are headed to store the details in [[Transfer Ready DtTm tmp entry]] instead of in a [[:Category:Awaiting/delayed transfer]] code. We found problems with the new method, which caused us to review what we are collecting and why, and we ended up reverting to the old method and then significantly limiting how many awaiting scenarios we collect at all.  
We considered changing how we track where people who are awaiting are headed to store the details in [[Transfer Ready DtTm tmp entry]] instead of in a [[:Category:Awaiting/delayed transfer]] code. We found problems with the new method, which caused us to review what we are collecting and why, and we ended up reverting to the old method and then significantly limiting how many awaiting scenarios we collect at all.  
{{SQL |
 
SELECT s_tmp.Value, Count(L_TmpV2.D_Tmp_ID) AS CountOfD_Tmp_ID, L_Log.RecordStatus
FROM (s_tmp INNER JOIN L_TmpV2 ON (s_tmp.Value {{=}} L_TmpV2.Item) AND (s_tmp.Study {{=}} L_TmpV2.Project)) INNER JOIN L_Log ON L_TmpV2.D_ID {{=}} L_Log.D_ID
GROUP BY s_tmp.Value, s_tmp.Study, L_Log.RecordStatus
HAVING (((s_tmp.Study){{=}} "Transfer Ready DtTm") AND ((L_Log.RecordStatus){{=}} "incomplete"))
ORDER BY s_tmp.Value;
}}


{{Collapsable  
{{Collapsable  

Latest revision as of 11:40, 2021 October 5

We considered changing how we track where people who are awaiting are headed to store the details in Transfer Ready DtTm tmp entry instead of in a Category:Awaiting/delayed transfer code. We found problems with the new method, which caused us to review what we are collecting and why, and we ended up reverting to the old method and then significantly limiting how many awaiting scenarios we collect at all.


Changed rolled back Continue to collect Transfer Ready with the old entries   

Currently we code a patient's reason for delay as ICD10 Category:Awaiting/delayed transfer code. After that, we are coding it as a value/item under Transfer Ready DtTm tmp entry.

Instructions for collectors

The instructions would have been: For any change to awaiting status after Jul 1, enter this as an Item of the profile's Transfer Ready DtTm tmp entry. This means a patient could have an awaiting code in the earlier part of their stay, but then use transfer ready awaiting drop-down in the later part of their stay.

Related articles

Related articles: