Centralized import from Ed.mdb: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "S:\MED\CCMED" to "S:\MED\MED_CCMED" |
||
| (12 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 | * From output folder on Regional server: copy pharmacy.mdb into: mdbs_to_import | ||
**Julie must provide a copy of latest TASKS.xls to put in mdbs_to_import folder (not the | **Julie must provide a copy of latest TASKS.xls to put in mdbs_to_import folder (not the TASKS_1.mdb on server). | ||
* copy From ''' | * copy From '''{{S:\MED\MED_CCMED}}Pagasa\CCData\rawdata''': cc_rawdata and med_rawdata content | ||
* 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 | *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. | *when you open front end, there is a '''link table button''', press it to link in TISS28.accdb. | ||
== resolutions for differences between (ed's and legacy) and centralized == | == resolutions for differences between (ed's and legacy) and centralized == | ||
| Line 29: | 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. | ||
=== Importing Pharmacy.mdb === | === Importing Pharmacy.mdb === | ||
| Line 46: | Line 40: | ||
== Change Log == | == Change Log == | ||
===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 === | ===2014-05-08 === | ||
copied to x:\ Ttenbergen 15:56, 2014 May 8 (CDT) | 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 and HSC Nursing | * 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 === | === ver 2014-05-05 === | ||
| Line 112: | 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 | ** 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 | ** fix import for [[R_type]] and [[R dc treat]] | ||
=== ver 2014-02-09 === | === ver 2014-02-09 === | ||
| Line 144: | 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) | ||