Query check tmp AHC: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) No edit summary |
|||
| Line 17: | Line 17: | ||
* dttms must be chronological for groupings linked by int_var | * dttms must be chronological for groupings linked by int_var | ||
* if there is an option entry the consult can not be "never addressed" | * if there is an option entry the consult can not be "never addressed" | ||
{{DL| * if there is referral sent there must be a referral received entry and a consult dealt with entry[[User:Lkaita|Lisa Kaita]] 11:31, 7 August 2025 (CDT) }} | {{DL| | ||
* if there is referral sent there must be a referral received entry and a consult dealt with entry[[User:Lkaita|Lisa Kaita]] 11:31, 7 August 2025 (CDT) | |||
** pt could die in between? consult could go missing? In a way those would be really the ones we would want to know about, no? I suppose we could make it a soft check... [[User:Ttenbergen|Ttenbergen]] 16:26, 19 August 2025 (CDT) | |||
}} | |||
{{DJ| others? }} | {{DJ| others? }} | ||
Revision as of 15:26, 19 August 2025
| Data Integrity Checks | |
| Summary: | For patients with Previous Location ER at same site there should be a Boarding Loc ER. |
| Related: | Project AHC, Site, SentDtTm, Admit DtTm, Dispo DtTm |
| Firmness: | hard check |
| Timing: | complete |
| App: | CCMDB.accdb |
| Coding: | query check_tmp_AHC |
| Uses L Problem table: | not relevant for this app |
| Status: | needs review |
| Implementation Date: | not entered |
| Backlogged: | No |
Cross-checks for Project AHC.
Consistency Checks
- must have an entry to send
- dttms within admission
- dttms must be chronological for groupings linked by int_var
- if there is an option entry the consult can not be "never addressed"
|
|
|
others? |
Log
- 2025-07-20 - preliminary data review and initial cross check definitions
- 2025-07-02 - collection started
Related articles
| Related articles: |