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
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]].
|successor=[[query check_transfer_ready_tmp_LT_first_Boarding_Loc]]
|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]].
Line 5: Line 10:
|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
|DIC_backlogged=No
|DIC_backlogged=No
}}
}}
== . ==
 
.
There were some remaining errors in this query but they were all old, and were added to [[L Problem table]]
== Log ==
* 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]]

Revision as of 19:20, 2021 January 27

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