Query check tmp Service and Boarding Loc during admission timeframe
Jump to navigation
Jump to search
| 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 |
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
Related articles
| Related articles: |