Query check tmp Service and Boarding Loc during admission timeframe: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) (Created page with "{{Data Integrity Check |DIC_summary=Service tmp entry values must be consistent with the Program |DIC_related_concepts=Service tmp entry; Program |DIC_firmness=hard ch...") |
Ttenbergen (talk | contribs) m (→Log) |
||
| (10 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
|DIC_summary=[[Service tmp entry]] | |DIC_summary=[[Service tmp entry]] and [[Boarding Loc]] date and time var need to be between [[Admit DtTm]] and [[Dispo DtTm]]. | ||
|DIC_related_concepts=Service tmp entry; | |DIC_related_concepts=Service tmp entry; Boarding Loc; Dispo DtTm; Admit DtTm | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|DIC_timing=complete | |||
|DIC_coding=query ''check_tmp_Service_and_Boarding_Loc_during_admission_timeframe'' | |DIC_coding=query ''check_tmp_Service_and_Boarding_Loc_during_admission_timeframe'' | ||
|DIC_implementation_date=2021-01-15 | |DIC_implementation_date=2021-01-15 | ||
|DIC_status= | |DIC_status=implemented | ||
|DIC_app=CCMDB.accdb | |DIC_app=CCMDB.accdb | ||
|DIC_backlogged=No | |DIC_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 == | == Log == | ||
* 2021-01-15 - check | * 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 == | ||
Latest revision as of 15:24, 2022 July 12
| 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: |
|