Function Dispo Chronological(): Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "cross checks" to "cross checks" |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{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= | |||
{{Data Integrity Check | {{Data Integrity Check | ||
|DIC_summary=Checks that the registry times are in a sensible chronological order. | |DIC_summary=Checks that the registry times are in a sensible chronological order. | ||
|DIC_related_concepts= | |DIC_related_concepts= Dispo DtTm | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|DIC_timing=always | |DIC_timing=always | ||
|DIC_coding=Function Dispo_Chronological() | |DIC_coding=Function Dispo_Chronological() | ||
|DIC_implementation_date=2016-05-25 | |DIC_implementation_date=2016-05-25 | ||
|DIC_status= | |DIC_status=retired | ||
|DIC_app=CCMDB.accdb | |DIC_app=CCMDB.accdb | ||
|DIC_backlogged=No | |DIC_backlogged=No | ||
}} | }} | ||
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: | 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 | * [[Dispo DtTm ]] has to be before Now() / today | ||
| Line 20: | Line 29: | ||
== Transfer vs (accept vs arrive) == | == Transfer vs (accept vs arrive) == | ||
In the real world, the | 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 == | == Related checks == | ||
| Line 26: | Line 35: | ||
== Log == | == Log == | ||
2020-10-15 | * 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:2016 Time and Place changes]] | ||
[[Category:Registry checks]] | [[Category:Registry checks]] | ||
}} | |||