Edit Data Integrity Check: Query check transfer DtTm during admission

Summary (what is the check, one-liner):
links to related pages:	Transfer Ready DtTm tmp entryDispo DtTm fieldBoarding Loc ×Transfer Ready DtTm tmp entry ×Dispo DtTm field ×Boarding Loc
Firmness (is this a warning only (soft check) or will it stop sending (hard check) - applicable only in CCMDB.accdb app):	None/unknown  hard check  soft check
Timing (does this query run for all records or only complete ones):	None/unknown  complete  always
Name of the function or query this is implemented as:	query ''check_transfer_DtTm_during_admission''
Implementation date:
Implementation Status:	needs reviewready to implementimplementednot enterednot feasibledeclinedretired
L_Problem (are false positive special cases addressed in table L_Problems - applicable only in CFE):	None/unknown  yes  no
App:	CCMDB.accdbCentralized data front end.accdbTISS28.accdbSAPDSM Labs Consistency check.accdb
Backlogged (is this query cleaned up to date or backlogged? Applicable only in CFE):

Free text:

This check runs at pre-send checker time and considers all records except deleted ones. == Log == * 2022-06-29 - confirmed that this catches this problem; records with it still seem to show up in CFE, not sure how that's possible * 2021-02-03 broke check into two, since we can check date in range always, but date present only when record is complete. * 2021-01-28 implemented == Related articles == {{Related Articles}} [[Category:Transfer Ready]]

Save page Show preview Show changes Cancel