Edit Data Integrity Check: Query check ICD10 awaiting has Transfer Ready DtTm

Are you logged on?

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: CCMDB_legit.

Summary (what is the check, one-liner):
links to related pages:
Firmness (is this a warning only (soft check) or will it stop sending (hard check) - applicable only in CCMDB.accdb app):	None/unknown hard check soft check
Timing (does this query run for all records or only complete ones):	None/unknown complete always
Name of the function or query this is implemented as:	Query ''check_ICD10_awaiting_has_Transfer_Ready_DtTm''
Implementation date:
Implementation Status:
L_Problem (are false positive special cases addressed in table L_Problems - applicable only in CFE):	None/unknown yes no
App:
Backlogged (is this query cleaned up to date or backlogged? Applicable only in CFE):

Free text:

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. [[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)  * 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}} [[Category:Transfer Ready]] [[Category:ICD10 Dx check]] [[Category:Registry checks]]

Explain your edit, if you think it needs explanation (e.g. "as discussed with ...", or "content moved to ...", or "duplicate content, see ..."):

This is a minor edit

Watch this page

Cancel

Edit Data Integrity Check: Query check ICD10 awaiting has Transfer Ready DtTm

Navigation menu

Search