Link suspect transfer ready greater than dispo: Difference between revisions

Latest revision as of 18:37, 28 January 2021

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_DtTm_during_admission]] for the new [[Transfer Ready DtTm tmp entry]].
+|successor=[[query check_transfer_DtTm_during_admission]]
+|content=
 {{Data Integrity Check
 |DIC_summary=Checks for records that have [[Transfer Ready DtTm field]] is greater than [[Dispo DtTm field]].
@@ Line 10: / Line 15: @@
 |DIC_backlogged=No
 }}
-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]].
 There were some remaining errors in this query but they were all old, and were added to [[L Problem table]]
 == Related articles ==
@@ Line 21: / Line 23: @@
 [[Category:Registry checks]]
+}}