LAU Collection Project: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) No edit summary |
||
| (11 intermediate revisions by 2 users not shown) | |||
| Line 6: | Line 6: | ||
*** VGH_LAU | *** VGH_LAU | ||
** [[Geri Rehab]] | ** [[Geri Rehab]] | ||
*** | *** SOH_Geriatrics | ||
*** | *** VGH_Geriatrics | ||
* 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]] | ||
| Line 14: | Line 14: | ||
** [[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]] === | ||
* If the first [[Service tmp entry]] is an [[LAU]] service and [[Boarding Loc]], and the patient is later transferred to [[Geri Rehab]], create a second profile for the admission to the [[Service tmp entry]] [[Geri Rehab]] and [[Boarding Loc]] | * If the first [[Service tmp entry]] is an [[LAU]] service and [[Boarding Loc]], and the patient is later transferred to [[Geri Rehab]], create a second profile for the admission to the [[Service tmp entry]] [[Geri Rehab]] and [[Boarding Loc]] | ||
=== Laptop setting changes during LAU collection === | === Laptop setting changes during LAU collection === | ||
| Line 41: | 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 103: | 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 110: | 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 117: | 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 | *]] | ||