Query Check BL TR combiner null: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(One intermediate revision by the same user not shown)
Line 18: Line 18:
{{Related Articles}}
{{Related Articles}}


[[Category: Admit/Discharge]]
[[Category:Admit/Discharge]]
[[Category: Transfer Ready]]
[[Category:Transfer Ready]]

Latest revision as of 10:56, 30 July 2025

Data Integrity Checks
Summary: Checks that all Boarding Loc / Transfer Ready DtTm tmp entry pairs have a non-null combiner integer.
Related: Transfer Ready DtTm tmp entry, Boarding Loc
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: Query check_BL_TR_combiner_null
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2022-07-13
Backlogged: No
  • Cargo


  • SMW


  • Categories:  
  • form:

Checks that all Boarding Locs and Transfer Ready DtTm tmp entrys have non-null combiners. Query check transfer ready tmp for each Boarding Loc checks that they are paired, but it turns out a common null also satisfies that check, but would later cause problems with the data.

Log

  • 2022-07-13 - implemented

Related Articles

Related articles: