Query check tmp Service and Boarding Loc during admission timeframe

From CCMDB Wiki
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.


  • 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

Related articles

Related articles: