LAU Collection Project: Difference between revisions

m Text replacement - "Centralized data.mdb" to "Centralized data.accdb"
No edit summary
 
(3 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]]  
{{DL|
* 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.[[User:Lkaita|Lisa Kaita]] 07:59, 11 April 2025 (CDT)
** You must have made a decision how to collect this... what was it? Can we add a one-liner or so and take out the discussion? [[User:Ttenbergen|Ttenbergen]] 13:46, 7 July 2025 (CDT)
}}
* [[Service tmp entry]] - no special instructions
* [[Service tmp entry]] - no special instructions
* special tmp entries for this:  
* special tmp entries for this:  
Line 24: Line 18:
** [[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 112: 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 [[Centralized data.accdb]] so this sample becomes its own record set, and delete the records from the master db
** 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 119: 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 | *]]