Link suspect transfer ready before arrive date: Difference between revisions

Latest revision as of 13:32, 21 April 2022

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:	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=
 {{Data Integrity Check
-|DIC_summary=Checks for records that have [[Transfer Ready DtTm field]] is before [[Arrive_DtTm field]].
+|DIC_summary=Checks for records that have [[Transfer Ready DtTm field]] is before ''Arrive_DtTm field''.
-|DIC_related_concepts=Arrive DtTm field; Transfer Ready DtTm field
+|DIC_related_concepts= Transfer Ready DtTm field
 |DIC_firmness=hard check
 |DIC_coding=query ''Link_suspect_transfer_ready_before_arrive_date''