LAU Collection Project: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 2: | Line 2: | ||
== Collection Instructions == | == Collection Instructions == | ||
* Population: 200 charts per site, for those sites with Geri rehab and LAU, 50 charts for Geri Rehab and 150 for LAU | * 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: | ||
** VGH_LAU | |||
** VGH Geriatrics | |||
** COH_LAU | |||
** SOH_LAU | |||
** SOH_ 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 12: | Line 17: | ||
** [[LAU OT/PT consults]] | ** [[LAU OT/PT consults]] | ||
===Special Scenario=== | === 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 === | ||
* 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 | ||
Revision as of 01:08, 12 March 2025
More details to come
Collection Instructions
- 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:
- VGH_LAU
- VGH Geriatrics
- COH_LAU
- SOH_LAU
- SOH_ Geriatrics
- 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
- Service tmp entry - no special instructions
- special tmp entries for this:
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
- data collectors will use their regular laptop for LAU collection and regular CCMDB.accdb for this project
- collection for this is at a different site, so you need to change a setting to make the site-specific options available in the dropdowns
- See Settings (CCMBD.mdb) for how to access the settings
- the one you need to change is for Hosp
- take note of your current entry to restore it to that to go back to regular collection
- settings are COH for Concordia, SOH for Seven Oaks, VGH for Victoria
- If you open a previously entered record for e.g. HSC while in e.g. VHG setting, some fields (eg. service location) will appear emtpy. The data is still there, but the dropdown doesn’t have it so the dropdown-driven box can’t show it. When you switch back to your usual setting the data will be visible, and it will remain visible in centralized_data.mdb either way.
Setup
- CCMDB.accdb Change Log 2025#2025-03-06
- Project Consults data
- added automatic "not entered" record to s_tmp table
- added Query check Project Consults data
- ACP Status Collection for LAU
- added options to s_tmp table
- added query check ACP Status Collection for LAU
- LAU collection readmission data
- Project Consults data
- CCMDB.accdb Change Log 2025#2025-03-04 - Added LAU collection readmission data and Project Consults data to s_tmp table
- CCMDB.accdb Change Log 2025#2025-03-03 - Added data items to the tables.
| click to see specific additions |
Identifying the project dataset
- 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
- Julie is aware that this needs to be considered for the duration of the project collection
- after collection we can split Centralized data.mdb 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
Processing / Analysis
- Project folder:
\\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\CCMDB_Special_Projects\LAU collection