Query check Transfer DtTm after paired BL and before later BL: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) (Created page with "{{Data Integrity Check |DIC_summary=For each pair, the Transfer Ready DtTm tmp entry should never be earlier any Boarding Loc dttm, nor later than the next Boarding Loc |DIC_related_concepts=Transfer Ready DtTm tmp entry; Dispo DtTm field; Boarding Loc |DIC_timing=always |DIC_coding=query ''check_transfer_DtTm_during_admission'' |DIC_implementation_date=2022-05-03 |DIC_status=ready to implement |DIC_app=CCMDB.accdb |DIC_backlogged=No }} This check runs at pr...") |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 3: | Line 3: | ||
|DIC_related_concepts=Transfer Ready DtTm tmp entry; Dispo DtTm field; Boarding Loc | |DIC_related_concepts=Transfer Ready DtTm tmp entry; Dispo DtTm field; Boarding Loc | ||
|DIC_timing=always | |DIC_timing=always | ||
|DIC_coding=query '' | |DIC_coding=query ''check_pairs_transfer_DtTm_after_BoardingLoc'' | ||
|DIC_implementation_date=2022-05-03 | |DIC_implementation_date=2022-05-03 | ||
|DIC_status=ready to implement | |DIC_status=ready to implement |
Revision as of 13:46, 2022 May 3
Data Integrity Checks | |
Summary: | For each pair, the Transfer Ready DtTm tmp entry should never be earlier any Boarding Loc dttm, nor later than the next Boarding Loc |
Related: | Transfer Ready DtTm tmp entry, Dispo DtTm field, Boarding Loc |
Firmness: | not entered |
Timing: | always |
App: | CCMDB.accdb |
Coding: | query check_pairs_transfer_DtTm_after_BoardingLoc |
Uses L Problem table: | not relevant for this app |
Status: | ready to implement |
Implementation Date: | 2022-05-03 |
Backlogged: | No |
This check runs at pre-send checker time and considers all records except deleted ones.
Log
- 2022-05-03 - implementing
Related articles
Related articles: |