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) m (→Log) |
||
| Line 13: | Line 13: | ||
== Log == | == Log == | ||
* 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-23 updated from TR >= Dispo to TR > Dispo and to only run the check on completes | ||
* 2021-09-22 | * 2021-09-22 | ||
Revision as of 14:51, 2022 May 2
| 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: | 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: | implemented |
| 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
- 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: |
|