Query check tmp AHC: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) No edit summary |
||
| (7 intermediate revisions by 2 users not shown) | |||
| Line 13: | Line 13: | ||
== Consistency Checks == | == Consistency Checks == | ||
* must have an entry | for each matching allied health discipline | ||
* | * at all times | ||
* | ** must have an entry for each allied health discipline | ||
* if there | ** if there is a date, it must be within the admission | ||
{{DL| | *** nz(date, now()) + nz(time, .9999) must be after admission | ||
{{ | *** nz(date, date()) + nz(time, 0) must be before nz(dispo_dttm, now) | ||
** '''not yet done''' - if item "not consulted" there must not be a date or time, and there must not be an AH_C_<the allied health team> entry for consult received | |||
* at complete time | |||
** if there is a time there has to be a date | |||
** if item in ("referral received", "Late consult received") then it must have the checkbox checked ("no dttm") or a date | |||
{{DL| | |||
** item must not be "not entered" | |||
* I implemented this one and 40 records in my test data have a "not entered" in complete data. Did I misunderstand the instructions? | |||
}} | |||
{{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) | |||
** this almost sounds like the opposite of how I would have understood the current instructions. I would have thought those to mean to only enter "consult received" if there was no good data for consult sent. How do we actually want to use this? | |||
}} | |||
== Log == | == Log == | ||
Latest revision as of 01:08, 22 November 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
for each matching allied health discipline
- at all times
- must have an entry for each allied health discipline
- if there is a date, it must be within the admission
- nz(date, now()) + nz(time, .9999) must be after admission
- nz(date, date()) + nz(time, 0) must be before nz(dispo_dttm, now)
- not yet done - if item "not consulted" there must not be a date or time, and there must not be an AH_C_<the allied health team> entry for consult received
- at complete time
- if there is a time there has to be a date
- if item in ("referral received", "Late consult received") then it must have the checkbox checked ("no dttm") or a date
|
|
|
|
|
Log
- 2025-07-20 - preliminary data review and initial cross check definitions
- 2025-07-02 - collection started
Related articles
| Related articles: |