Query Check BL TR combiner null: Difference between revisions
Ttenbergen (talk | contribs) Created page with "{{Data Integrity Check |DIC_summary=Checks that all Boarding Loc / Transfer Ready DtTm tmp entry pairs have a non-null combiner integer. |DIC_related_concepts= Transfer Ready DtTm tmp entry; Boarding Loc |DIC_firmness=hard check |DIC_coding=Query check_BL_TR_combiner_null |DIC_status=ready to program |DIC_app=CCMDB.accdb |DIC_backlogged=No }} Checks that all Boarding Locs and Transfer Ready DtTm tmp entrys have non-null combiners. Query check transfer..." |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
|DIC_summary=Checks that all [[Boarding Loc]] / [[Transfer Ready DtTm tmp entry]] pairs have a non-null combiner integer. | |DIC_summary=Checks that all [[Boarding Loc]] / [[Transfer Ready DtTm tmp entry]] pairs have a non-null combiner integer. | ||
|DIC_related_concepts= Transfer Ready DtTm tmp entry; Boarding Loc | |DIC_related_concepts=Transfer Ready DtTm tmp entry; Boarding Loc | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|DIC_timing=complete | |||
|DIC_coding=Query check_BL_TR_combiner_null | |DIC_coding=Query check_BL_TR_combiner_null | ||
|DIC_status= | |DIC_implementation_date=2022-07-13 | ||
|DIC_status=implemented | |||
|DIC_app=CCMDB.accdb | |DIC_app=CCMDB.accdb | ||
|DIC_backlogged=No | |DIC_backlogged=No | ||
}} | }} | ||
Checks that all [[Boarding Loc]]s and [[Transfer Ready DtTm tmp entry]]s 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. | Checks that all [[Boarding Loc]]s and [[Transfer Ready DtTm tmp entry]]s 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 | ==Log== | ||
* 2022-07-13 - | * 2022-07-13 - implemented | ||
== Related Articles == | == Related Articles == | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category: Admit/Discharge]] | [[Category:Admit/Discharge]] | ||
[[Category: Transfer Ready]] | [[Category:Transfer Ready]] | ||