Query s tmp Boarding Loc date item: Difference between revisions

Revision as of 11:49, 2022 April 21

Data Integrity Checks
Summary:	Validates entries for Boarding Loc
Related:	Boarding Loc, service tmp entry, Dispo DtTm
Firmness:	hard check
Timing:	complete
App:	CCMDB.accdb
Coding:	query s_tmp_Boarding_Loc_date_item
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2020/06/03
Backlogged:	No

Date_var and Time_var must not be on or after Dispo DtTm
Item should not be the same as the Service/Location for Medicine profile
When having a boarding location, both date and time must be present. Should not have missing time.

2022-03-31
- removed "no borrow" references since we have not used those in a long time
- removed some old distinction between Med and CC that is no longer relevant
- updated to use first Service tmp entry instead of "Accept DtTm"
2020-11-06 removed requirement "Date_var and Time_var must not be before "Arrive DtTm" until we can work out #first boarding loc question

Related articles:
S tmp table ‎ (← links) Pre-send Checker ‎ (← links) Dispo DtTm field ‎ (← links) Data Integrity Checks ‎ (← links) Query s tmp apostrophe in comment ‎ (← links) Boarding Loc ‎ (← links) CCMDB.accdb Change Log 2020 ‎ (← links) Service tmp entry ‎ (← links) CCMDB.accdb Change Log 2022 ‎ (← links)

@@ Line 19: / Line 19: @@
 ** removed "no borrow" references since we have not used those in a long time
 ** removed some old distinction between Med and CC that is no longer relevant
-** updated to use first [[Service tmp entry]] instead of [[Accept DtTm]]
+** updated to use first [[Service tmp entry]] instead of "Accept DtTm"
-* 2020-11-06 removed requirement "Date_var and Time_var must not be before [[Arrive DtTm]]" until we can work out [[#first boarding loc question]]
+* 2020-11-06 removed requirement "Date_var and Time_var must not be before "Arrive DtTm" until we can work out [[#first boarding loc question]]
 == Related articles ==