Query check tmp Service and Boarding Loc during admission timeframe

From CCMDB Wiki
Jump to navigationJump to search
Data Integrity Checks
Summary: Service tmp entry and Boarding Loc date and time var need to be between Accept DtTm resp Arrive DtTm and Dispo DtTm.
Related: Service tmp entry, Boarding Loc, Dispo DtTm
Firmness: hard check
Timing: always
App: CCMDB.accdb
Coding: query check_tmp_Service_and_Boarding_Loc_during_admission_timeframe
Uses L Problem table: not relevant for this app
Status: needs review
Implementation Date: 2021-01-15
Backlogged: No

  • Cargo

  • SMW

  • Categories: 

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.

  • Accept DtTm resp Arrive DtTm are largely duplication of the Service tmp entry and Boarding Loc dates and times. I believe we had discussed that we should therefore remove those fields eventually. So we should not implement a check now on fields we are planning to get rid of shortly.
  • Even if we kept the fields, Accept DtTm is only to be entered for pts from ER, so would not always be there, and the Service tmp entry start dttm could well be before the arrive dttm.
  • SMW

  • Cargo

  • Categories


  • 2021-01-15 - check defined

Related articles

Related articles: