LAU Collection Project: Difference between revisions
Ttenbergen (talk | contribs) No edit summary |
Ttenbergen (talk | contribs) No edit summary |
||
| (7 intermediate revisions by 2 users not shown) | |||
| Line 10: | Line 10: | ||
* Use the next [[Pat ID]] in your series, there is no need to manage them separately for this project | * Use the next [[Pat ID]] in your series, there is no need to manage them separately for this project | ||
* [[Boarding Loc]] - use [[Transfer Ready DtTm]] to determine [[Transfer Ready DtTm tmp entry]] | * [[Boarding Loc]] - use [[Transfer Ready DtTm]] to determine [[Transfer Ready DtTm tmp entry]] | ||
* [[Service tmp entry]] - no special instructions | * [[Service tmp entry]] - no special instructions | ||
* special tmp entries for this: | * special tmp entries for this: | ||
** [[LAU collection readmission data]] | ** [[LAU collection readmission data]] | ||
** [[Project Consults data]] | ** [[Project Consults data]] | ||
** [[ACP Status Collection | ** [[ACP Status Collection]] | ||
** [[LAU OT/PT consults]] | ** [[LAU OT/PT consults]] | ||
** [[LAU Public Trustee]] | ** [[LAU Public Trustee]] | ||
** [[LAU LTC consult]] | ** [[LAU LTC consult]] | ||
=== problems with [[Transfer Ready DtTm]] == | |||
* Dan was right, this field is a mess trying to use our current definition with a population of patients that don't really fit an acute medicine profile. If the patient went to Rehab the [[Transfer Ready DtTm]] will reflect the time they are accepted, if they became palliative the [[Transfer Ready DtTm]] will reflect when they became so, otherwise much of this was a judgment call, as many would be deemed transfer ready on admission by our definition. | |||
* Decided to code time when the MD wrote medically stable for dc planning | |||
=== Special Scenario - pt spends time in both [[LAU]] and [[Geri Rehab]] === | === Special Scenario - pt spends time in both [[LAU]] and [[Geri Rehab]] === | ||
| Line 37: | Line 40: | ||
*** added automatic "not entered" record to [[s_tmp table]] | *** added automatic "not entered" record to [[s_tmp table]] | ||
*** added [[Query check Project Consults data]] | *** added [[Query check Project Consults data]] | ||
** [[ACP Status Collection | ** [[ACP Status Collection]] | ||
*** added options to [[s_tmp table]] | *** added options to [[s_tmp table]] | ||
*** added [[query check ACP Status Collection | *** added [[query check ACP Status Collection]] | ||
** [[LAU collection readmission data]] | ** [[LAU collection readmission data]] | ||
*** added [[query check_LAU_collection_readmission_data]] | *** added [[query check_LAU_collection_readmission_data]] | ||
| Line 99: | Line 102: | ||
* Collection will happen between {{LAU Collection StartDt}} and {{LAU Collection EndDt}} | * Collection will happen between {{LAU Collection StartDt}} and {{LAU Collection EndDt}} | ||
* The record set contains [[Dispo DtTm]] between | * The record set contains [[Dispo DtTm]] between | ||
** VGH Oct 6, 2024 and Dec 31, 2024 | |||
and | ** SOGH Dec 3,2024 and Dec 31, 2024 | ||
** CGH Nov 22, 2024 and Dec 31, 2024 | |||
== Identifying the project dataset == | == Identifying the project dataset == | ||
| Line 106: | Line 110: | ||
** will have program = "Med" because a bunch of functionality is tied in with Program, so if we made it "LAU" or "Family Med" we would need to make major changes to code and queries | ** will have program = "Med" because a bunch of functionality is tied in with Program, so if we made it "LAU" or "Family Med" we would need to make major changes to code and queries | ||
** Julie is aware that this needs to be considered for the duration of the project collection | ** Julie is aware that this needs to be considered for the duration of the project collection | ||
** after collection we can split [[ | ** after collection we can split [[Centralized_data.accdb]] so this sample becomes its own record set, and delete the records from the master db | ||
*** this will need to be done before the next export to MCHP for sure | *** this will need to be done before the next export to MCHP for sure | ||
| Line 113: | Line 117: | ||
\\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\CCMDB_Special_Projects\LAU collection | \\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\CCMDB_Special_Projects\LAU collection | ||
[[Category: LAU Collection Project | *]] | [[Category:LAU Collection Project | *]] | ||