Link suspect transfer ready greater than dispo: Difference between revisions

Latest revision as of 19:37, 2021 January 28

This page contains Legacy Content.

Explanation: Query retired because we no longer use Transfer Ready DtTm field, and because this can and will be done in CCMDB.accdb by query check_transfer_DtTm_during_admission for the new Transfer Ready DtTm tmp entry.
Successor: query check_transfer_DtTm_during_admission

Click Expand to show legacy content.

Data Integrity Checks
Summary:	Checks for records that have Transfer Ready DtTm field is greater than Dispo DtTm field.
Related:	Dispo DtTm field
Firmness:	hard check
Timing:	always
App:	Centralized data front end.accdb
Coding:	query Link_suspect_transfer_ready_greater_than_dispo
Uses L Problem table:	No
Status:	retired
Implementation Date:	2020/02/21
Backlogged:	No

There were some remaining errors in this query but they were all old, and were added to L Problem table

@@ Line 1: / Line 1: @@
 {{LegacyContent
-|explanation=Query retired because we no longer use [[Transfer Ready DtTm field]], and because this can and will be done in [[CCMDB.accdb]] by [[query check_transfer_ready_tmp_GT_Dispo]] for the new [[Transfer Ready DtTm tmp entry]].
+|explanation=Query retired because we no longer use [[Transfer Ready DtTm field]], and because this can and will be done in [[CCMDB.accdb]] by [[query check_transfer_DtTm_during_admission]] for the new [[Transfer Ready DtTm tmp entry]].
-|successor=[[query check_transfer_ready_tmp_GT_Dispo]]
+|successor=[[query check_transfer_DtTm_during_admission]]
 |content=