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]].
+|DIC_summary=Checks for records that have [[Transfer Ready DtTm field]] is greater than [[Dispo DtTm field]].
 |DIC_related_concepts=Dispo DtTm field
 |DIC_firmness=hard check
 |DIC_coding=query ''Link_suspect_transfer_ready_greater_than_dispo''
-|DIC_status=implemented
+|DIC_implementation_date=2020/02/21
+|DIC_status=retired
 |DIC_LProblem=No
 |DIC_app=Centralized data front end.accdb
+|DIC_backlogged=No
 }}
+There were some remaining errors in this query but they were all old, and were added to [[L Problem table]]
 == Related articles ==
@@ Line 14: / Line 23: @@
 [[Category:Registry checks]]
+}}