CCMDB Wiki

Centralized import from Ed.mdb: Difference between revisions

← Older edit
m Text replacement - "S:\MED\CCMED" to "S:\MED\MED_CCMED"
 
(26 intermediate revisions by 2 users not shown)
Line 7: Line 7:


* get newest version from x:\ (\\Hsc1msfp0001\med_ccmed\CCMDB\Centralized import from Ed\copy contents of this folder to one folder on your desktop)
* get newest version from x:\ (\\Hsc1msfp0001\med_ccmed\CCMDB\Centralized import from Ed\copy contents of this folder to one folder on your desktop)
* From output folder on Regional server: copy pharmacy.mdb, tasks_1.mdb and tmpv2_1.mdb into mdbs_to_import
* From output folder on Regional server: copy pharmacy.mdb into:  mdbs_to_import
* copy From '''X:\Data Cleaning''': cc_rawdata and med_rawdata contents\
**Julie must provide a copy of latest TASKS.xls to put in mdbs_to_import folder (not the TASKS_1.mdb on server).
**CC_raw_data: Reg, apache, lab, pharm
* copy From '''{{S:\MED\MED_CCMED}}Pagasa\CCData\rawdata''': cc_rawdata and med_rawdata content
**Med_raw_data: Reg, apache, lab, ADL
* open centralized import from ed.mdb
* open centralized import from ed.mdb
* open Modules, go to module "Import", run Public Sub Import().
* open Modules, go to module "Import", run Public Sub Import().
* EXIT out when done (large X to right screen)
* EXIT out when done (large X to right screen)
* Final Step:FROM the Ed import folder on your own desktop, copy centralized.mdb, PHI.mdb TO the centralized Front end practice folder on your desktop.
* Final Step:FROM the Ed import folder on your own desktop, copy centralized.mdb, PHI.mdb TO the centralized Front end practice folder on your desktop.
*you can also copy from X:\TISS28\Database\TISS28_data.mdb to the centralized Front end practice folder on your own desktop
*you can also copy from {{S:\MED\MED_CCMED}}TISS28\Database\TISS28_data.mdb to the centralized Front end practice folder on your own desktop
*when you open front end, there is a link table button, press it to link in TISS28.mdb.
*when you open front end, there is a '''link table button''', press it to link in TISS28.accdb.
*As of Friday Feb 14, S_ALLDiagnosis table is not linked, so after you do the above, and you open centralized front end on your desktop you will need to use link manager to relink the S_ALLDIAGNOSIS table.


== resolutions for differences between (ed's and legacy) and centralized ==
== resolutions for differences between (ed's and legacy) and centralized ==
Line 28: Line 26:
=== duplicates ===
=== duplicates ===
turned out there were a few duplicates in ed's where a serial was used twice for the same hospital/location. These were resolved in Ed's data and should not be a problem for the final import.
turned out there were a few duplicates in ed's where a serial was used twice for the same hospital/location. These were resolved in Ed's data and should not be a problem for the final import.
=== Apache, LOS, etc ===
Importing these into a table "L_Aux".


=== Importing Pharmacy.mdb ===
=== Importing Pharmacy.mdb ===
Line 41: Line 36:


== Change Requests ==
== Change Requests ==
See:[[Change Priorities]]- issue with missing data in L_task and also missing from L_DX after import done with this version.[[User:TOstryzniuk|Trish Ostryzniuk]] 11:58, 2014 May 6 (CDT)
* import tmp_v2 data after [[L TmpV2 multi-entry clean-up]]
* import tmp_v2 data after [[L TmpV2 multi-entry clean-up]]


== Change Log ==
== Change Log ==
=== ver 2014-03-28 ===
===2014-05-13 ===
copied to x:\ Ttenbergen 12:19, 2014 May 14 (CDT)
* fixed queries tmp_importer_* to handle date and time properly.  Ttenbergen 14:03, 2014 May 13 (CDT)
 
===2014-05-09 ===
copied to x:\ Ttenbergen 16:27, 2014 May 9 (CDT)
* changed query "orig_med_to_L_Log" from
**::AP_AdmitType: IIf(IsNull([surgical]) Or IsNull([es]),Null,IIf([r_AdmDate]<#2007/Jan/01#,"Medical",IIf([ES]="Y","Elect.Surg",IIf([surgical]=False,"Medical","Surg.Emerg"))))
**To
**::AP_AdmitType: IIf(IsNull([surgical]) Or IsNull([es]),Null,IIf([r_AdmDate]>#2007/Jan/01#,"Medical",IIf([ES]="Y","Elect.Surg",IIf([surgical]=False,"Medical","Surg.Emerg"))))
 
===2014-05-08 ===
copied to x:\ Ttenbergen 15:56, 2014 May 8 (CDT)
* made s_admitDischarge same as elsewhere, ie incl. setting FP and FR to "surgical" and making sure that the [[Grace Nursing Home Ward]] and [[HSC Nursing Home Ward]] entry is present. Ttenbergen 15:56, 2014 May 8 (CDT)
 
=== ver 2014-05-05 ===
copied to x:\ Ttenbergen 10:59, 2014 May 5 (CDT)
* updated import for CC apache to set all Renal/ARF nulls to ''false'' as per Trish. Ttenbergen 10:59, 2014 May 5 (CDT)
 
=== ver 2014-05-01 ===
copied to x: Ttenbergen 20:31, 2014 May 1 (CDT)
* changed the import for medicine and cc L_Log to import as null apache elements that are null in Ed's
** ap_chronic
** ap_admitType
** ap_ARF
* fixed query "orig_med_tasks_from_Juliexls_peritoneal", was entering wrong dx code. Ttenbergen 19:38, 2014 May 1 (CDT)
*likely included the fix to [[Admit Type for APACHE II]] elective surgery (ES) Tina to confirm.[[User:TOstryzniuk|Trish Ostryzniuk]] 16:00, 2014 May 2 (CDT)
 
=== ver 2014-03-24 ===
not rolled yet but used for 03-28 import Ttenbergen 15:58, 2014 March 24 (CDT)
not rolled yet but used for 03-28 import Ttenbergen 15:58, 2014 March 24 (CDT)
* reinstated line that cleans out L_PHI, it had got omitted when I changed the clean-up to just copy a clean centralized rather than slowly delete content. Ttenbergen 15:58, 2014 March 24 (CDT)
* reinstated line that cleans out L_PHI, it had got omitted when I changed the clean-up to just copy a clean centralized rather than slowly delete content. Ttenbergen 15:58, 2014 March 24 (CDT)
* fixed queries "orig_med_to_L_Log" and "orig_cc_to_L_Log" , were mixing up emerg and elect surgery ( see also [[Admit Type for APACHE II]] and [[ES]]) Ttenbergen 15:03, 2014 March 27 (CDT)
* '''tasks are not being imported


=== ver 2014-03-10 ===
=== ver 2014-03-10 ===
Line 91: Line 117:
* fixed ''orig_med_to_L_Log'' and ''orig_cc_to_L_Log'' to:  
* fixed ''orig_med_to_L_Log'' and ''orig_cc_to_L_Log'' to:  
** import R_DischargedTo properly. Ttenbergen 13:37, 2014 February 13 (CST)
** import R_DischargedTo properly. Ttenbergen 13:37, 2014 February 13 (CST)
** import sex as full words rather than initial letters to make same as ccmdb.mdb Ttenbergen 16:14, 2014 February 13 (CST)
** import sex as full words rather than initial letters to make same as [[CCMDB.accdb]] Ttenbergen 16:14, 2014 February 13 (CST)
** fix import for R_Type and R_DC_Treat
** fix import for [[R_type]] and [[R dc treat]]


=== ver 2014-02-09 ===
=== ver 2014-02-09 ===
Line 123: Line 149:
** imported table s_ADLOptions to resolve entries needed for l_log.adl_* fields Ttenbergen (2013 December 23)
** imported table s_ADLOptions to resolve entries needed for l_log.adl_* fields Ttenbergen (2013 December 23)
** updated query orig_cc_to_L_Log to include ADLs Ttenbergen (2013 December 23)
** updated query orig_cc_to_L_Log to include ADLs Ttenbergen (2013 December 23)
* link to [[s_GCS]] in centralized.mdb Ttenbergen 12:44, 2013 December 30 (CST)
* link to [[s_GCS table]] in centralized.mdb Ttenbergen 12:44, 2013 December 30 (CST)
* updated query orig_cc_to_L_Log to use s_GCS to populate with values used in CCMDB rather than scores from TMSX Ttenbergen 12:44, 2013 December 30 (CST)
* updated query orig_cc_to_L_Log to use s_GCS table to populate with values used in CCMDB rather than scores from TMSX Ttenbergen 12:44, 2013 December 30 (CST)
* changed study 99999 fix to only delete if ((orig_cc_reg.STUDY)=99999 '''and''' (orig_cc_reg.CHART)=999999999);" Ttenbergen 12:49, 2013 December 30 (CST)
* changed study 99999 fix to only delete if ((orig_cc_reg.STUDY)=99999 '''and''' (orig_cc_reg.CHART)=999999999);" Ttenbergen 12:49, 2013 December 30 (CST)
* confirmed that L_Labs_Flowsheet has values, ready for validation Ttenbergen 12:55, 2013 December 30 (CST)
* confirmed that L_Labs_Flowsheet has values, ready for validation Ttenbergen 12:55, 2013 December 30 (CST)
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_import_from_Ed.mdb"