Query check tmp Service and Boarding Loc during admission timeframe: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 14: | Line 14: | ||
{{Discuss | | {{Discuss | | ||
* [[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. | * [[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]] start dttm could well be before the arrive dttm. | * 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. | ||
}} | }} | ||
Revision as of 10:34, 2021 March 10
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 |
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
- 2021-01-15 - check defined
Related articles
Related articles: |
|