Query check transfer ready tmp for each Boarding Loc: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = [[Transfer Ready DtTm tmp entry]] should never be before the first [[Boarding Loc]] of a profile
| DIC_summary = There should be a [[Transfer Ready DtTm tmp entry]] for each [[Boarding Loc]] entry of a profile
| DIC_related_concepts = Transfer Ready DtTm tmp entry; Boarding Loc
| DIC_related_concepts = Transfer Ready DtTm tmp entry; Boarding Loc
| DIC_firmness = hard
| DIC_firmness = hard
| DIC_timing = incomplete
| DIC_timing = complete
| DIC_app = CCMDB.accdb
| DIC_app = CCMDB.accdb
| DIC_coding = query ''check_transfer_ready_tmp_LT_first_Boarding_Loc''
| DIC_coding = query ''check_transfer_ready_tmp_LT_first_Boarding_Loc''
| DIC_status = ready to implement
| DIC_status = ready to implement
| DIC_implementation_date =  
| DIC_implementation_date = 2021-01-28
}}
}}
The count of non-ER [[Boarding Loc]] should be the same as the count of [[Transfer Ready DtTm tmp entry]].
== Log ==
* 2021-01-28 - defined and implemented


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

Revision as of 19:41, 2021 January 28

Data Integrity Checks
Summary: There should be a Transfer Ready DtTm tmp entry for each Boarding Loc entry of a profile
Related: Transfer Ready DtTm tmp entry, Boarding Loc
Firmness: hard
Timing: complete
App: CCMDB.accdb
Coding: query check_transfer_ready_tmp_LT_first_Boarding_Loc
Uses L Problem table: not relevant for this app
Status: ready to implement
Implementation Date: 2021-01-28
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:

The count of non-ER Boarding Loc should be the same as the count of Transfer Ready DtTm tmp entry.

Log

  • 2021-01-28 - defined and implemented

Related articles

Related articles: