LAU Collection Project: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Created page with "More details to come ==setup== * Added data items to the tables in CCMDB.accdb Change Log 2025#2025-03-03 ** to S dispo table: VGH_LAU, SOH_LAU, COH_LAU"
 
Line 1: Line 1:
More details to come
More details to come
== Collection Instructions ==
* just a checkllist for now of things we will need to include:
* [[Boarding Loc]] - no [[Transfer Ready DtTm tmp entry]] for the LAU collection
* [[Service tmp entry]] - no special instructions
* special tmp entries for this:


==setup==
==setup==
* Added data items to the tables in [[CCMDB.accdb Change Log 2025#2025-03-03]]
* Added data items to the tables in [[CCMDB.accdb Change Log 2025#2025-03-03]]
{{Collapsable | always = click to see specific additions
| full=* table additions:
** to [[S dispo table]]: VGH_LAU, SOH_LAU, COH_LAU
** 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
}}

Revision as of 17:23, 3 March 2025

More details to come

Collection Instructions


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