Link suspect transfer ready before arrive date: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
(4 intermediate revisions by the same user not shown)
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
{{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
|DIC_related_concepts= Transfer Ready DtTm field
|DIC_firmness=hard check
|DIC_firmness=hard check
|DIC_coding=query ''Link_suspect_transfer_ready_before_arrive_date''
|DIC_coding=query ''Link_suspect_transfer_ready_before_arrive_date''
|DIC_implementation_date=2020/02/21
|DIC_implementation_date=2020/02/21
|DIC_status=implemented
|DIC_status=retired
|DIC_LProblem=False
|DIC_LProblem=False
|DIC_app=Centralized data front end.accdb
|DIC_app=Centralized data front end.accdb
Line 11: Line 16:
}}
}}


== Log ==
There were some remaining errors in this query but they were all old, and were added to [[L Problem table]]
* 2021-01-21 - changed it so it looks at Accept_DtTm first.


== Related articles ==
== Related articles ==
{{Related Articles}}
{{Related Articles}}


 
}}
[[Category:Registry checks]]
[[Category:Registry checks]]

Latest revision as of 14:32, 2022 April 21

Legacy Content

This page contains Legacy Content.

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
  • Cargo


  • SMW


  • Categories: 
  • form:

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

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Link_suspect_transfer_ready_before_arrive_date&oldid=155713"