Query s tmp check combined Boarding Loc and TransferReadyDtTm: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 5: Line 5:
|DIC_timing=complete
|DIC_timing=complete
|DIC_coding= query s_tmp_check_combined_Boarding_Loc_and_TransferReadyDtTm
|DIC_coding= query s_tmp_check_combined_Boarding_Loc_and_TransferReadyDtTm
|DIC_implementation_date=2021-03-24
|DIC_implementation_date=2021-03-31
|DIC_status=ready to implement
|DIC_status=ready to implement
|DIC_LProblem=
|DIC_LProblem=
|DIC_app=CCMDB.accdb
|DIC_app=CCMDB.accdb
|DIC_backlogged=No
|DIC_backlogged=No
}}
{{Discuss |
* Started implementing this and realized that it will cause a lot of backlog errors. How to we ramp this up? Only run query on completes - that would leave Julie with bad data until complete. Only run query for data after a certain date? Give collectors a.e. a week to update all still active on laptop - that would be a lot or records in some of the locations that have a big backlog. Related info on [[Transfer Ready DtTm tmp entry]], [[Boarding Loc]] and [[Template:Combined instructions for Transfer Ready DtTm and Boarding Loc]]. Thoughts? [[User:Ttenbergen|Ttenbergen]] 15:37, 2021 March 24 (CDT)
}}
}}


== Log ==
== Log ==
2021-03-24 started implementing
2021-03-31 implemented


== Related articles ==  
== Related articles ==  

Revision as of 11:14, 2021 March 31

Data Integrity Checks
Summary: Validates that there are only matching pairs of Transfer Ready DtTm tmp entry and Boarding Loc as per Template:Combined instructions for Transfer Ready DtTm and Boarding Loc.
Related: Boarding Loc, Transfer Ready DtTm tmp entry
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: query s_tmp_check_combined_Boarding_Loc_and_TransferReadyDtTm
Uses L Problem table: not relevant for this app
Status: ready to implement
Implementation Date: 2021-03-31
Backlogged: No
  • Cargo


  • SMW


  • Categories: 
  • form:

Log

2021-03-31 implemented

Related articles

Related articles: