Query Check BL TR combiner null
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: | always |
App: | CCMDB.accdb |
Coding: | Query check_BL_TR_combiner_null |
Uses L Problem table: | not relevant for this app |
Status: | ready to program |
Implementation Date: | not entered |
Backlogged: | No |
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 - working on
Related Articles
Related articles: |