Centralized import from Ed.mdb: Difference between revisions

(38 intermediate revisions by 2 users not shown)

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)

* 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 Modules, go to module "Import", run Public Sub Import().

* 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.

*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 ==

Line 28:

Line 26:

=== 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.

~~=== Apache, LOS, etc ===~~

~~Importing these into a table "L_Aux".~~

=== Importing Pharmacy.mdb ===

Line 41:

Line 36:

== Change Requests ==

* [[L TmpV2 multi-entry clean-up]]

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]]

== 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 ===

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)

* 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 ===

not rolled out yet Ttenbergen 15:19, 2014 March 10 (CDT)

used for import of 2013-03-21 data, and rolled to x:\ - Ttenbergen 10:39, 2014 March 24 (CDT)

( not rolled out yet Ttenbergen 15:19, 2014 March 10 (CDT) but used for import already...)

* added (''and then removed'' since Julie already has this combined in tasks.xls below) queries to import iTISS items into L_Dxs (b see [[Tasks vs iTISS]]:

** query "orig_med_itiss19_to_L_Dxs"

Line 63:

Line 94:

** orig_med_tasks_from_Juliexls_trach

* removed the original tasks queries Ttenbergen 12:04, 2014 March 12 (CDT)

* fixed sub "get_cc_dxs" which was excluding imports for early records that had no serial/pat_id - Ttenbergen 13:55, 2014 March 14 (CDT)

* updated queries orig_cc_to_L_Log and orig_med_to_L_Log to fix importing for "type" field - Ttenbergen 14:32, 2014 March 14 (CDT)

* [[L TmpV2 multi-entry clean-up|fix tmp import]] setting up now: Import all TmpV2 that have the latest available tmp_sent_date) for a given patient-ward-stay.

* deleted table orig_m_tasks and orig_m_saps since we are not using them now Ttenbergen 16:02, 2014 March 17 (CDT)

* updated sub Clean_origs() to also include intermediate tables for tasks and tmp Ttenbergen 16:03, 2014 March 17 (CDT)

* changed module re-jigger subs to get dxs and comos to only pull for the program currently being processed, they were importing each dx for both the study supposed to and the same study number in the other program. Ttenbergen 12:43, 2014 March 21 (CDT)

* changed queries "orig_med_to_L_Log" and "orig_cc_to_L_Log" to set imported records to "vetted" to respond to new definition in [[RecordStatus field]]. Ttenbergen 13:29, 2014 March 21 (CDT)

=== ver 2014-03-06 ===

Line 79:

Line 117:

* 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 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 ===

Line 111:

Line 149:

** 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)

* 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)

* confirmed that L_Labs_Flowsheet has values, ready for validation Ttenbergen 12:55, 2013 December 30 (CST)

@@ 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)
-* 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 Modules, go to module "Import", run Public Sub Import().
 * 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.
-*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 ==
@@ Line 28: / Line 26: @@
 === 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.
-=== Apache, LOS, etc ===
-Importing these into a table "L_Aux".
 === Importing Pharmacy.mdb ===
@@ Line 41: / Line 36: @@
 == Change Requests ==
-* [[L TmpV2 multi-entry clean-up]]
+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]]
 == 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 ===
+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)
+* 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 ===
-not rolled out yet Ttenbergen 15:19, 2014 March 10 (CDT)
+used for import of 2013-03-21 data, and rolled to x:\ - Ttenbergen 10:39, 2014 March 24 (CDT)
+( not rolled out yet Ttenbergen 15:19, 2014 March 10 (CDT) but used for import already...)
 * added (''and then removed'' since Julie already has this combined in tasks.xls below) queries to import iTISS items into L_Dxs (b see [[Tasks vs iTISS]]:
 ** query "orig_med_itiss19_to_L_Dxs"
@@ Line 63: / Line 94: @@
 ** orig_med_tasks_from_Juliexls_trach
 * removed the original tasks queries Ttenbergen 12:04, 2014 March 12 (CDT)
+* fixed sub "get_cc_dxs" which was excluding imports for early records that had no serial/pat_id - Ttenbergen 13:55, 2014 March 14 (CDT)
+* updated queries orig_cc_to_L_Log and orig_med_to_L_Log to fix importing for "type" field - Ttenbergen 14:32, 2014 March 14 (CDT)
+* [[L TmpV2 multi-entry clean-up|fix tmp import]] setting up now: Import all TmpV2 that have the latest available tmp_sent_date) for a given patient-ward-stay.
+* deleted table orig_m_tasks and orig_m_saps since we are not using them now Ttenbergen 16:02, 2014 March 17 (CDT)
+* updated sub Clean_origs() to also include intermediate tables for tasks and tmp Ttenbergen 16:03, 2014 March 17 (CDT)
+* changed module re-jigger subs to get dxs and comos to only pull for the program currently being processed, they were importing each dx for both the study supposed to and the same study number in the other program. Ttenbergen 12:43, 2014 March 21 (CDT)
+* changed queries "orig_med_to_L_Log" and "orig_cc_to_L_Log" to set imported records to "vetted" to respond to new definition in [[RecordStatus field]]. Ttenbergen 13:29, 2014 March 21 (CDT)
 === ver 2014-03-06 ===
@@ Line 79: / Line 117: @@
 * 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 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 ===
@@ Line 111: / Line 149: @@
 ** 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)
-* 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)
 * confirmed that L_Labs_Flowsheet has values, ready for validation Ttenbergen 12:55, 2013 December 30 (CST)