LAU Collection Project: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
Line 2: Line 2:


== Collection Instructions ==
== Collection Instructions ==
* just a checkllist for now of things we will need to include:  
* just a check list for now of things we will need to include:  
* [[Boarding Loc]] - no [[Transfer Ready DtTm tmp entry]] for the LAU collection
* [[Boarding Loc]] - no [[Transfer Ready DtTm tmp entry]] for the LAU collection
* [[Service tmp entry]] - no special instructions
* [[Service tmp entry]] - no special instructions
* Population: Lisa has organized charts and will provide collectors with a list
* special tmp entries for this:  
* special tmp entries for this:  


=== Laptop setting changes during LAU collection ===
* data collectors will 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


==setup==
==setup==
Line 61: Line 69:
* 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
}}
}}
== Processing / Analysis ==
* Project folder:
\\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\CCMDB_Special_Projects\LAU collection

Revision as of 17:48, 3 March 2025

More details to come

Collection Instructions

Laptop setting changes during LAU collection

  • data collectors will 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

setup

click to see specific additions   
  • table additions:
    • to S dispo table: VGH_LAU, SOH_LAU, COH_LAU
    • to s_tmp table for Service tmp entry:
      • COH MedicineLowAc/General
      • COH ALC Med LowAc/Panel Appr PCH
      • SOH Medicine LowAc/General
      • SOH ALCMedLowAc/Panel in Process
      • SOH Rehabilitation/Geriatrics
      • VGH medicine LowAc/General
      • VGH Rehabilitation/Geriatrics
      • VGH medicine LowAc/Community other
      • VGH medicine LowAc/Panel in Process
      • VGH medicine LowAc/Homecare
      • VGH medicine LowAc/Panel Appr other
      • VGH medicine LowAc/Panel Appr PCH
    • to s_tmp table for Boarding Loc:
      • COH-N1N
      • COH-N3E
      • COH-N3W
      • SOH-3BU1
      • SOH-3BU2
      • SOH-3BU3
      • SOH-3BU4
      • SOH-3BU5
      • SOH-3BU6
      • SOH-3BU7
      • SOH-3A10
      • SOH-3A11
      • SOH-3A12
      • SOH-5BU1
      • SOH-5BU2
      • SOH-5BU3
      • SOH-5BU4
      • SOH-5BU5
      • SOH-5BU6
      • SOH-5BU7
      • SOH-4BU4
      • SOH-4BU5
      • SOH-4BU6
      • SOH-4BU7
      • SOH-4AU8
      • SOH-4AU9
      • SOH-4AU11
      • SOH-4AU12
      • VGH-NU4N
      • VGH-NU4S
      • VGH-NU5N
      • VGH-NU5S
  • considered whether new entries were required for s_Cognos_Services table and s_Cognos_Units table; they are not

Processing / Analysis

  • Project folder:

\\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\CCMDB_Special_Projects\LAU collection