Query check tmp Service and Boarding Loc during admission timeframe

Data Integrity Checks
Summary:	Service tmp entry and Boarding Loc date and time var need to be between Admit DtTm and Dispo DtTm.
Related:	Service tmp entry, Boarding Loc, Dispo DtTm, Admit DtTm
Firmness:	hard check
Timing:	complete
App:	CCMDB.accdb
Coding:	query check_tmp_Service_and_Boarding_Loc_during_admission_timeframe
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2021-01-15
Backlogged:	No

• Cargo

• SMW

• Categories:  

• form:

The component of the check that requires that the times are before the Dispo DtTm was implemented, the check at the beginning of the admission was not.

Log

• 2022-07-12 added requirement that the service or boarding loc entry must be "active" in s_tmp table
• 2022-05-02 was still using Accept and Arrive DtTm, replaced with Admit DtTm
• 2021-09-23 updated from TR >= Dispo to TR > Dispo and to only run the check on completes
• 2021-09-22
  • included check for blanks
  • included checking Boarding Loc - this was only checking Service tmp entry so far
  • defined the check so it uses the new definition of AdminDttm to consolidate the old and the new way
• 2021-01-15 - check defined