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 13: Line 13:


{{Discuss |  
{{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. Thoughts? [[User:Ttenbergen|Ttenbergen]] 15:37, 2021 March 24 (CDT)
* 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)
}}
}}



Revision as of 15:53, 2021 March 24

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-24
Backlogged: No
  • Cargo


  • SMW


  • Categories: 
  • form:
  • SMW


  • Cargo


  • Categories

Log

2021-03-24 started implementing

Related articles

Related articles: