Edit Data Integrity Check: Function Dispo Chronological()

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:	Function Dispo_Chronological()
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:

{{LegacyContent |explanation=[[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]] |successor=various [[cross check]]s against [[Boarding Loc]] and [[Service tmp entry]] |content= Retired as part of [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]] as there is nothing left to check here, and all the tmp based checks are already done elsewhere. The check will generate an error if: * ''Arrive DtTm'' has to be before or equal to ''Accept DtTm'' * ''Arrive DtTm'' has to be before or equal ''Transfer Ready DtTm'' * ''Arrive DtTm'' has to be before [[Dispo DtTm ]] * ''Transfer Ready DtTm'' has to be before [[Dispo DtTm ]] * [[Dispo DtTm ]] has to be before Now() / today No checks on [[Visit Admit DtTm field]] since taken direct from [[EPR]], so it is what it is. == Transfer vs (accept vs arrive) == In the real world, the ''Transfer Ready DtTm'' could well be between ''Accept DtTm'' and ''Arrive DtTm''. Our check would flag this as an error. As per [[Task Team Meeting - Rolling Agenda and Minutes 2019|ICU Database Task Group Meeting – January 24, 2019 | Task Meeting 209-01-24]] point 8 it was decided to continue to only allow a transfer date after arrival date. The rationale was that we don't care about time wasted outside of our units/wards, only on our units. == Related checks == * [[Check Function Panelling admit transfer same]] == Log == * 2022-04-21 - removed check * 2020-10-15 - removed checks against [[Transfer Ready DtTm]] since that field is being retired, see [[Transfer Ready DtTm tmp entry]] for any replacements [[Category:2016 Time and Place changes]] [[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