Query check transfer ready tmp for each Boarding Loc: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 13: | Line 13: | ||
== nr of entries == | == nr of entries == | ||
{{ | {{DiscussTask | AJTT | ||
* I implemented this query and tested it on Steph's data, and none of the profiles have more than one [[Transfer Ready DtTm tmp entry]]. From how I read the article, there should be one per [[Boarding Loc]] - is that not how collectors are understanding this? [[User:Ttenbergen|Ttenbergen]] 18:58, 2021 January 28 (CST) | * I implemented this query and tested it on Steph's data, and none of the profiles have more than one [[Transfer Ready DtTm tmp entry]]. From how I read the article, there should be one per [[Boarding Loc]] - is that not how collectors are understanding this? [[User:Ttenbergen|Ttenbergen]] 18:58, 2021 January 28 (CST) | ||
** This was discussed at task and as an example in medicine program the decision made was to consider all medicine collection units as having equal status, so transfers between medicine units are considered lateral moves; so there is usually only one transfer ready date/time entry per profile not per boarding location. | ** This was discussed at task and as an example in medicine program the decision made was to consider all medicine collection units as having equal status, so transfers between medicine units are considered lateral moves; so there is usually only one transfer ready date/time entry per profile not per boarding location. | ||
Line 20: | Line 20: | ||
== ER entries == | == ER entries == | ||
{{Discuss | | {{Discuss | AJTT | ||
* For medicine patients accepted and cared for in ER (one boarding location) then transferred to a medical unit, there isn't a transfer ready date/time because the patient was not ready for a lower level hierarchy of care but made a lateral move. Same concept applies for medicine unit to medicine unit moves. (Pam) | * For medicine patients accepted and cared for in ER (one boarding location) then transferred to a medical unit, there isn't a transfer ready date/time because the patient was not ready for a lower level hierarchy of care but made a lateral move. Same concept applies for medicine unit to medicine unit moves. (Pam) | ||
** That is ''not necessarily'' true. They might want to send a pt home but can't because pt now needs home care, but once home care is in place they can discharge from ER. [[User:Ttenbergen|Ttenbergen]] 10:55, 2021 February 1 (CST) | ** That is ''not necessarily'' true. They might want to send a pt home but can't because pt now needs home care, but once home care is in place they can discharge from ER. [[User:Ttenbergen|Ttenbergen]] 10:55, 2021 February 1 (CST) |
Revision as of 11:56, 2021 February 1
Data Integrity Checks | |
Summary: | There should be a Transfer Ready DtTm tmp entry for each Boarding Loc entry of a profile |
Related: | Transfer Ready DtTm tmp entry, Boarding Loc |
Firmness: | hard |
Timing: | complete |
App: | CCMDB.accdb |
Coding: | query check_transfer_ready_tmp_for_each_Boarding_Loc |
Uses L Problem table: | not relevant for this app |
Status: | needs review |
Implementation Date: | |
Backlogged: | true |
The count of non-ER Boarding Loc should be the same as the count of Transfer Ready DtTm tmp entry.
nr of entries
AJTT
|
ER entries
AJTT
|
Log
- 2021-01-28 - defined
Related articles
Related articles: |