Link suspect transfer ready before arrive date: Difference between revisions

Revision as of 18:37, 28 January 2021

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 before Arrive_DtTm field.
Related:	Arrive DtTm field, Transfer Ready DtTm field
Firmness:	hard check
Timing:	always
App:	Centralized data front end.accdb
Coding:	query Link_suspect_transfer_ready_before_arrive_date
Uses L Problem table:	False
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_LT_first_Boarding_Loc]] 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_LT_first_Boarding_Loc]]
+|successor=[[query check_transfer_DtTm_during_admission]]
 |content=