Change to having each collector collect both programs on the same laptop

We need to be able to have collectors follow patients from Medicine to CC and vice versa, and to collect both programs on the same laptop. This page documents the move from single-program CCMDB.accdb (SP) to CC+Med CCMDB.accdb (DP).

State of transition

• copying and starting of records updated and in testing
• cross-checks updated and almost ready for testing

• still to do:
  • decide how patient allocation and assignment should work in the future
  • update Cognos2 matcher query to show both programs

detection of program

• In SP we detected this based on Settings
• For DP this will need to be based on Service/Location for each admission
• created function admission_program(Pat_ID) and query admission_program to provide this

dropdown availability

• The Service/Location dropdowns were previously filtered by site and program; changed these to be filtered only by site. This is done by Query s serviceLocation local. It used to be based on S locations allowed collection table from when we allocated workload based on units; since this is no longer done, we deleted that table.
  • changed on Patient viewer

Implementation details for setup with two different copies of CCMDB.accdb on same laptop - not the solution we will use

We did the roll-out for this for the H6 laptop. Ran into several issues with Reconnect check orphans query and News and Backup. H6 remains doubled up, all other laptops are one program only for now. Initial configuration - need to back out of this News and backup Laptop configuration Add the locations that were available for the other laptop to s_locations_allowed_collection table running the newest News and Backup script Backup.bat will update itself to always back up and pull newest versions in a way that works for both setups. do the twinning on the laptop by running the Regional Server\Maintenance\Combine_CM\ccmdb_CM_twinner.ps1 (full address: \\ad.wrha.mb.ca\WRHA\REGION\SHARED\ICU_DATA_COLLECTION\Maintenance\Combine_CM\ccmdb_CM_twinner.ps1) script Implementation details Two copies of ccmdb.accdb need to be present, since you can't open a second instance of the same file. A powershell script opens the two files in the correct order. A shortcut launches the powershell script. desktop shortcut    double-clicking on a powerscript file will by default open it in an editor, so we made a shortcut to run the script instead of editing it. powershell script details    the script ccmdb_starter_both.ps1 opens the first file with command line parameters, waits for the user to click enter, and then opens the second one powershell was used because batch would not process command line parameters right the two file starts are separated by user having to click OK in the script to make sure they are actually logged in in the correct order implementation inside CCMDB_*.accdb    The program attempts to read the data file name from the command line via VBA using Command(). If no command line parameter is given the old standard ccmdb_data.mdb is used. Paths not taken same ccmdb.accdb, different command line parameters    this didn't allow opening the second instance while the first is open. collecting programs in same Access DB - reconsidered and heading that way    This would require major changes to cross checks, form hiding and other places, and since we are likely moving away to SF it wasn't worth it. Store data file path info in settings    The settings are stored in the data file, so CCMDB.accdb wouldn't know where to get the data. Related articles Related articles: Settings (CCMBD.mdb) ‎ (← links) S locations allowed collection table ‎ (← links) Reconnect check orphans query ‎ (← links) Legacy Content ‎ (← links) Query check CCI Component duplicates ‎ (← links) Query s serviceLocation local ‎ (← links) Cognos2 matcher query ‎ (← links) Query s tmp Boarding Loc ER delay reasonable ‎ (← links) CCMDB.accdb Change Log 2023 ‎ (← links) Function admission program(Pat ID) ‎ (← links) Instructions to Clean CSS when moving to Combined Program Collection ‎ (← links) CCMDB.accdb Change Log 2024 ‎ (← links) Category:Change to having each collector collect both programs on the same laptop ‎ (← links)