LAU Collection Project: Difference between revisions
Ttenbergen (talk | contribs) →Collection Instructions: removed Dispo_field#Home_vs_Home_with_Support because now collected in general, added LAU OT/PT consults |
Ttenbergen (talk | contribs) No edit summary |
||
| (25 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
== Collection Instructions == | == Collection Instructions == | ||
* Population: 200 charts per site, for those sites with Geri | * Population: 200 charts per site, for those sites with [[Geri Rehab]] and [[LAU]], 50 charts for [[Geri Rehab]] and 150 for [[LAU]] with the following [[Service/Location]] entries: | ||
** [[LAU]] | |||
*** COH_LAU | |||
*** SOH_LAU | |||
*** VGH_LAU | |||
** [[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 9: | 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 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]] === | |||
* 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 === | ||
* data collectors will use their regular laptop for LAU collection and regular [[CCMDB.accdb]] for this project | * data collectors will use their regular laptop for LAU collection and regular [[CCMDB.accdb]] for this project | ||
| Line 28: | 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 86: | Line 98: | ||
* considered whether new entries were required for [[s_Cognos_Services table]] and [[s_Cognos_Units table]]; they are not | * considered whether new entries were required for [[s_Cognos_Services table]] and [[s_Cognos_Units table]]; they are not | ||
}} | }} | ||
== Collection dates == | |||
* Collection will happen between {{LAU Collection StartDt}} and {{LAU Collection EndDt}} | |||
* The record set contains [[Dispo DtTm]] between | |||
** VGH Oct 6, 2024 and Dec 31, 2024 | |||
** SOGH Dec 3,2024 and Dec 31, 2024 | |||
** CGH Nov 22, 2024 and Dec 31, 2024 | |||
== Identifying the project dataset == | == Identifying the project dataset == | ||
* [[Service/Location]] joined with [[s_dispo table]] will have | * [[Service/Location]] joined with [[s_dispo table]] will have [[S dispo.loc type]] = "LAU" | ||
** 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 98: | 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 | *]] | ||