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) mNo edit summary |
||
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 [[Accept DtTm]] resp [[Arrive DtTm]] and [[Dispo DtTm]]. | ||
|DIC_related_concepts=Service tmp entry; Program | |DIC_related_concepts=Service tmp entry; Program | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|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=needs review | ||
|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. | |||
{{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. | |||
* 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. | |||
}} | }} | ||
== Log == | == Log == | ||
* 2021-01-15 - check | * 2021-01-15 - check defined | ||
== Related articles == | == Related articles == |
Revision as of 21:32, 2021 January 15
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, Program |
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: |
|