Centralized data front end.mdb Change Log 2015: Difference between revisions

(79 intermediate revisions by the same user not shown)

Line 1:

''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''

This article is the change log for [[Centralized data front end.~~mdb~~]]. See [[Centralized data front end.~~mdb~~ Change Request]] for requested changes.

This article is the change log for [[Centralized data front end.accdb]]. See [[Centralized data front end.accdb Change Request]] for requested changes.

== Change Log ==

=== 2015-Aug-19 ===

copied to x: Ttenbergen 14:13, 2015 August 24 (CDT)

* added one-time queries 1_acp__test, 1_acp_admit and 1_acp_end. Emailed Pagasa, Julie and Trish with details. Ttenbergen 13:20, 2015 August 24 (CDT)

* added one-time query 1_change_complication_CAP_to_HAP. Emailed Julie, Trish and Pagasa with details. Ttenbergen 13:35, 2015 August 24 (CDT)

=== 2015-Aug-13 ===

rolled out Ttenbergen 09:53, 2015 August 19 (CDT)

* as discussed with Julie, removed irrelevant fields from

** query ''L_Tasks'' Ttenbergen 11:39, 2015 August 13 (CDT)

** query ''L_Log_PHI_time_hm'' Ttenbergen 12:36, 2015 August 13 (CDT)

* added ''S dispo legacy codes'' (later removed) table and query ''s_dispo_combiner'' (later removed) to address some legacy data and reporting issues Ttenbergen 08:53, 2015 August 17 (CDT)

* update for [[Processing errors in patient data#Contact the data collector for additional info]]

** added ''[[L Communication Notes table]]'' to Function confirm_files_and_links() Ttenbergen 09:22, 2015 August 17 (CDT)

** added code to [["email collector about patient data" button]]/Sub generate_mail_Click to add note to [[L Communication Notes table]] and to set [[RecordStatus field]] to "questioned" unless it was "incomplete" Ttenbergen 11:18, 2015 August 17 (CDT)

** added L_Communication_Notes data to query [[Query J in-process records]] Ttenbergen 13:55, 2015 August 17 (CDT)

* checking for non-empty queries

** added module Query_processor

** added sub Query_processor.Check_Queries_matching

** added "PLs" and "NDCs" button to PatientList Ttenbergen 14:42, 2015 August 17 (CDT)

** added "link_suspects" button to LinkList Ttenbergen 14:49, 2015 August 17 (CDT)

=== 2015-Aug-06 ===

copied to x:\ Ttenbergen 17:40, 2015 August 6 (CDT)

* corected query ''NDC_Pacemaker_acquired_wo_TISS'', had false positives Ttenbergen 17:40, 2015 August 6 (CDT)

* added [[S dispo table]] to connector function Ttenbergen 17:40, 2015 August 6 (CDT)

=== 2015-Jul-16 ===

copied to x:\ Ttenbergen 16:14, 2015 July 30 (CDT)

* removed queries SAS_* as requested by email from Julie 2015-07-15 -- Ttenbergen 10:43, 2015 July 16 (CDT)

* updated the following queries to omit records listed in [[L_Problem]] Ttenbergen 16:07, 2015 July 30 (CDT)

** query ''link_suspect_medicine_to_med_no_partner''

** query ''link_suspect_from_partner_no_match''

** query ''link_suspect_from_ICU_but_single_encounter''

** query ''link_suspect_to_ICU_but_single_encounter''

* wrote temporary queries to update L_Problem with these, then deleted those queries; updated [[Centralized_data.accdb]] L_Problem. Ttenbergen 16:07, 2015 July 30 (CDT)

=== 2015-May-28 ===

rolled Ttenbergen 17:18, 2015 June 24 (CDT)

* added [[L_Problem]] to the connector module Ttenbergen 14:13, 2015 June 24 (CDT)

* added query ''NDC_Pacemaker_acquired_wo_TISS'' as per SQL email from Pagasa Ttenbergen 17:16, 2015 June 22 (CDT)

* added TISS note to [["Re-connect Data" button]] Ttenbergen 14:54, 2015 June 24 (CDT)

* updated query ''NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2'' to exclude medicine patients. Ttenbergen 16:18, 2015 June 24 (CDT)

=== 2015-May-27 ===

copied to master Ttenbergen 14:32, 2015 May 28 (CDT)

* removed temporary query ''3_RnD_clean_tmp_dates'', had been applied in [[Centralized_data.accdb]]_Change_Log#2015-May-26]] Ttenbergen 11:41, 2015 May 27 (CDT)

* changed form ''PatientList'', deleted sex and chart column and squished rest together so Pagasa won't have to scroll back and forth. Ttenbergen 14:30, 2015 May 28 (CDT)

=== 2015-May-14 ===

copied to master Ttenbergen 17:04, 2015 May 20 (CDT)

* updated function phins_cleaned , use L_PHI not L_Log Ttenbergen 12:56, 2015 May 14 (CDT)

=== 2015-May-11 ===

copied to master Ttenbergen 14:57, 2015 May 13 (CDT)

* corrections to algorithm for [[Generate Person IDs]] Ttenbergen 11:39, 2015 May 13 (CDT)

* added Function Complete_exists() to check for [[RecordStatus]] "complete" in CFE (which should not exist)

** [["Re-connect Data" button]] on main form

** "vet all sent" button on PatientList

=== 2015-Apr-16 ===

copied to master Ttenbergen 14:31, 2015 April 20 (CDT)

* fixed [[Query L Labs total]], was grouping rather than summing on most fields. Ttenbergen 14:14, 2015 April 16 (CDT)

* updating query ''link_suspect_medicine_to_med_no_partner'', was including critical care locations.

=== 2015-APR-02-2 ===

rolled Ttenbergen 17:01, 2015 April 2 (CDT)

* added query ''NDC_Pacemaker_TISS_wo_acquired'' to find pts with [[TISS28]] item 42 pacemaker insertion who don't have corresponding acquired dx 76334 Ttenbergen 15:58, 2015 April 2 (CDT)

* removed module SHA256 as we decided on different method. Ttenbergen 16:07, 2015 April 2 (CDT)

* added query ''3_RnD_clean_tmp_dates'' to be run and deleted some day, tracked in [[Centralized_data.accdb]] Requested Changes]]. Ttenbergen 17:01, 2015 April 2 (CDT)

=== 2015-APR-02 ===

rolled Ttenbergen 12:09, 2015 April 2 (CDT)

* added index L_Log for Person_ID Ttenbergen 11:10, 2015 April 2 (CDT)

* set [[L_Person table|L_Person]].death to null for all since it will only be used for PCH deaths now Ttenbergen 11:10, 2015 April 2 (CDT)

* added code to Form View to blank out [[Person_ID]] when PHIN is edited or [[PseudoPHIN]] button is pushed. Ttenbergen 12:09, 2015 April 2 (CDT)

=== 2015-APR-01 ===

rolled Ttenbergen 17:07, 2015 April 1 (CDT)

* added [[Person_ID]] field to query [[L_Log_PHI]] Ttenbergen 15:05, 2015 April 1 (CDT)

* changing encounter_processing module Sub Encounter_processor() to delete inconsistent linkages and then replace with clean ones Ttenbergen 17:07, 2015 April 1 (CDT)

=== 2015-Feb-11 ===

rolled to x:\

* updated [[Encounter processing]] and hooked it up to button in main form.

* updated the count test on re-connecting that warns if the numbers in L_Log and L_PHI are not same; had wrong order of precedence

=== 2015-Jan-22 ===

~~do before rolling out~~:

rolled to x: Ttenbergen 17:40, 2015 February 5 (CST)

~~- update L_Person to be same as in dev, ie add PHIN (long) and last_update (date)~~

~~not rolled yet~~ Ttenbergen 13:28, 2015 ~~January 22~~ (CST)

* setting up for [[Encounter processing]]

** added tables [[L_Person]] and [[L_Hospitalization]] to Function ''confirm_files_and_links()'' that is triggered by the "Re-connect data" button

** added tables [[L_Person table]] and [[L_Hospitalization]] to Function ''confirm_files_and_links()'' that is triggered by the "Re-connect data" button

** added query ''encounter_lister''

** added module ''Encounter_processing'' with Sub ''Encounter_processor()''

** inf query ''L_Log_PHI_time_hm'' added fields [[Person_ID]] and Hospitalization_ID

* added Report R_CompletePt

** created query ''L_Pharm_total

** created query ''L_Labs_total''

** created table ''R_CompletePtList

** created query r_completePtFilter to subset the report

** created report ''R_completePT''

** created sub-report ''R_CompletePt_Comos''

** created sub-report ''R_CompletePT_Dxs''

** created sub-report ''R_CompletePT_Pharm_total''

** created sub-report ''R_CompletePT_Labs_total''

* clean-up

** deleted old query ''Labs_Flowsheet_sum_fungins''

* updated query ''link_suspect_medicine_to_med_no_partner'' to eliminate false-positives for H4H; actually was a complete re-write, Pagasa please test

=== 2015-Jan-20 ===

Line 24:

Line 124:

** ''1_Var2_BRR_2_cleanout_Var2''

* updated query ''created_Apache_details'' to be 15-(GCS) (was just GCS).

* changed var2 dropdown to draw row content the same way as Var 1 (as in CCMDB.~~mdb~~) Ttenbergen 18:01, 2015 January 19 (CST)

* changed var2 dropdown to draw row content the same way as Var 1 (as in CCMDB.accdb) Ttenbergen 18:01, 2015 January 19 (CST)

* added query ''L_Dxs_w_primary'' which includes a field "is_primary" to allow easy searching for primary_dxs. uses query ''Primary_admit'' Ttenbergen 18:24, 2015 January 19 (CST)

* deleted old legacy query ''1_time_only_set_3000_tr_date_to_null'' Ttenbergen 20:18, 2015 January 19 (CST)

[[Category: Development Documentation]]

[[Category:Development Documentation]]

[[category:2013 data upgrades]]

[[category: 2013 data upgrades]]

[[Category: Centralized data front end.~~mdb~~]]

[[Category:Centralized data front end.accdb]]

@@ Line 1: / Line 1: @@
 ''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''
-This article is the change log for [[Centralized data front end.mdb]]. See [[Centralized data front end.mdb Change Request]] for requested changes.
+This article is the change log for [[Centralized data front end.accdb]]. See [[Centralized data front end.accdb Change Request]] for requested changes.
 == Change Log ==
+=== 2015-Aug-19 ===
+copied to x: Ttenbergen 14:13, 2015 August 24 (CDT)
+* added one-time queries 1_acp__test, 1_acp_admit and 1_acp_end. Emailed Pagasa, Julie and Trish with details. Ttenbergen 13:20, 2015 August 24 (CDT)
+* added one-time query 1_change_complication_CAP_to_HAP. Emailed Julie, Trish and Pagasa with details. Ttenbergen 13:35, 2015 August 24 (CDT)
+=== 2015-Aug-13 ===
+rolled out Ttenbergen 09:53, 2015 August 19 (CDT)
+* as discussed with Julie, removed irrelevant fields from
+** query ''L_Tasks'' Ttenbergen 11:39, 2015 August 13 (CDT)
+** query ''L_Log_PHI_time_hm'' Ttenbergen 12:36, 2015 August 13 (CDT)
+* added ''S dispo legacy codes'' (later removed) table and query ''s_dispo_combiner'' (later removed) to address some legacy data and reporting issues Ttenbergen 08:53, 2015 August 17 (CDT)
+* update for [[Processing errors in patient data#Contact the data collector for additional info]]
+** added ''[[L Communication Notes table]]'' to Function confirm_files_and_links() Ttenbergen 09:22, 2015 August 17 (CDT)
+** added code to [["email collector about patient data" button]]/Sub generate_mail_Click to add note to [[L Communication Notes table]] and to set [[RecordStatus field]] to "questioned" unless it was "incomplete" Ttenbergen 11:18, 2015 August 17 (CDT)
+** added L_Communication_Notes data to query [[Query J in-process records]] Ttenbergen 13:55, 2015 August 17 (CDT)
+* checking for non-empty queries
+** added module Query_processor
+** added sub Query_processor.Check_Queries_matching
+** added "PLs" and "NDCs" button to PatientList Ttenbergen 14:42, 2015 August 17 (CDT)
+** added "link_suspects" button to LinkList Ttenbergen 14:49, 2015 August 17 (CDT)
+=== 2015-Aug-06 ===
+copied to x:\ Ttenbergen 17:40, 2015 August 6 (CDT)
+* corected query ''NDC_Pacemaker_acquired_wo_TISS'', had false positives Ttenbergen 17:40, 2015 August 6 (CDT)
+* added [[S dispo table]] to connector function Ttenbergen 17:40, 2015 August 6 (CDT)
+=== 2015-Jul-16 ===
+copied to x:\ Ttenbergen 16:14, 2015 July 30 (CDT)
+* removed queries SAS_* as requested by email from Julie 2015-07-15 -- Ttenbergen 10:43, 2015 July 16 (CDT)
+* updated the following queries to omit records listed in [[L_Problem]] Ttenbergen 16:07, 2015 July 30 (CDT)
+** query ''link_suspect_medicine_to_med_no_partner''
+** query ''link_suspect_from_partner_no_match''
+** query ''link_suspect_from_ICU_but_single_encounter''
+** query ''link_suspect_to_ICU_but_single_encounter''
+* wrote temporary queries to update L_Problem with these, then deleted those queries; updated [[Centralized_data.accdb]] L_Problem. Ttenbergen 16:07, 2015 July 30 (CDT)
+=== 2015-May-28 ===
+rolled Ttenbergen 17:18, 2015 June 24 (CDT)
+* added [[L_Problem]] to the connector module Ttenbergen 14:13, 2015 June 24 (CDT)
+* added query ''NDC_Pacemaker_acquired_wo_TISS'' as per SQL email from Pagasa Ttenbergen 17:16, 2015 June 22 (CDT)
+* added TISS note to [["Re-connect Data" button]] Ttenbergen 14:54, 2015 June 24 (CDT)
+* updated query ''NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2'' to exclude medicine patients. Ttenbergen 16:18, 2015 June 24 (CDT)
+=== 2015-May-27 ===
+copied to master Ttenbergen 14:32, 2015 May 28 (CDT)
+* removed temporary query ''3_RnD_clean_tmp_dates'', had been applied in [[Centralized_data.accdb]]_Change_Log#2015-May-26]] Ttenbergen 11:41, 2015 May 27 (CDT)
+* changed form ''PatientList'', deleted sex and chart column and squished rest together so Pagasa won't have to scroll back and forth. Ttenbergen 14:30, 2015 May 28 (CDT)
+=== 2015-May-14 ===
+copied to master Ttenbergen 17:04, 2015 May 20 (CDT)
+* updated function  phins_cleaned , use L_PHI not L_Log Ttenbergen 12:56, 2015 May 14 (CDT)
+=== 2015-May-11 ===
+copied to master Ttenbergen 14:57, 2015 May 13 (CDT)
+* corrections to algorithm for [[Generate Person IDs]] Ttenbergen 11:39, 2015 May 13 (CDT)
+* added Function Complete_exists() to check for [[RecordStatus]] "complete" in CFE (which should not exist)
+** [["Re-connect Data" button]] on main form
+** "vet all sent" button on PatientList
+=== 2015-Apr-16 ===
+copied to master Ttenbergen 14:31, 2015 April 20 (CDT)
+* fixed [[Query L Labs total]], was grouping rather than summing on most fields. Ttenbergen 14:14, 2015 April 16 (CDT)
+* updating query ''link_suspect_medicine_to_med_no_partner'', was including critical care locations.
+=== 2015-APR-02-2 ===
+rolled Ttenbergen 17:01, 2015 April 2 (CDT)
+* added query ''NDC_Pacemaker_TISS_wo_acquired'' to find pts with [[TISS28]] item 42 pacemaker insertion who don't have corresponding acquired dx 76334 Ttenbergen 15:58, 2015 April 2 (CDT)
+* removed module SHA256 as we decided on different method. Ttenbergen 16:07, 2015 April 2 (CDT)
+* added query ''3_RnD_clean_tmp_dates'' to be run and deleted some day, tracked in [[Centralized_data.accdb]] Requested Changes]]. Ttenbergen 17:01, 2015 April 2 (CDT)
+=== 2015-APR-02 ===
+rolled Ttenbergen 12:09, 2015 April 2 (CDT)
+* added index L_Log for Person_ID Ttenbergen 11:10, 2015 April 2 (CDT)
+* set [[L_Person table|L_Person]].death to null for all since it will only be used for PCH deaths now Ttenbergen 11:10, 2015 April 2 (CDT)
+* added code to Form View to blank out [[Person_ID]] when PHIN is edited or [[PseudoPHIN]] button is pushed. Ttenbergen 12:09, 2015 April 2 (CDT)
+=== 2015-APR-01 ===
+rolled Ttenbergen 17:07, 2015 April 1 (CDT)
+* added [[Person_ID]] field to query [[L_Log_PHI]] Ttenbergen 15:05, 2015 April 1 (CDT)
+* changing encounter_processing module Sub Encounter_processor() to delete inconsistent linkages and then replace with clean ones Ttenbergen 17:07, 2015 April 1 (CDT)
+=== 2015-Feb-11 ===
+rolled to x:\
+* updated [[Encounter processing]] and hooked it up to button in main form.
+* updated the count test on re-connecting that warns if the numbers in L_Log and L_PHI are not same; had wrong order of precedence
 === 2015-Jan-22 ===
- do before rolling out:
+rolled to x: Ttenbergen 17:40, 2015 February 5 (CST)
- - update L_Person to be same as in dev, ie add PHIN (long) and last_update (date)
-not rolled yet Ttenbergen 13:28, 2015 January 22 (CST)
 * setting up for [[Encounter processing]]
-** added tables [[L_Person]] and [[L_Hospitalization]] to Function ''confirm_files_and_links()'' that is triggered by the "Re-connect data" button
+** added tables [[L_Person table]] and [[L_Hospitalization]] to Function ''confirm_files_and_links()'' that is triggered by the "Re-connect data" button
 ** added query ''encounter_lister''
 ** added module ''Encounter_processing'' with Sub ''Encounter_processor()''
+** inf query ''L_Log_PHI_time_hm'' added fields [[Person_ID]] and Hospitalization_ID
+* added Report R_CompletePt
+** created query ''L_Pharm_total
+** created query ''L_Labs_total''
+** created table ''R_CompletePtList
+** created query r_completePtFilter to subset the report
+** created report ''R_completePT''
+** created sub-report ''R_CompletePt_Comos''
+** created sub-report ''R_CompletePT_Dxs''
+** created sub-report ''R_CompletePT_Pharm_total''
+** created sub-report ''R_CompletePT_Labs_total''
+* clean-up
+** deleted old query ''Labs_Flowsheet_sum_fungins''
+* updated query ''link_suspect_medicine_to_med_no_partner'' to eliminate false-positives for H4H; actually was a complete re-write, Pagasa please test
 === 2015-Jan-20 ===
@@ Line 24: / Line 124: @@
 ** ''1_Var2_BRR_2_cleanout_Var2''
 * updated query ''created_Apache_details'' to be 15-(GCS) (was just GCS).
-* changed var2 dropdown to draw row content the same way as Var 1 (as in CCMDB.mdb) Ttenbergen 18:01, 2015 January 19 (CST)
+* changed var2 dropdown to draw row content the same way as Var 1 (as in CCMDB.accdb) Ttenbergen 18:01, 2015 January 19 (CST)
 * added query ''L_Dxs_w_primary'' which includes a field "is_primary" to allow easy searching for primary_dxs. uses query ''Primary_admit'' Ttenbergen 18:24, 2015 January 19 (CST)
 * deleted old legacy query ''1_time_only_set_3000_tr_date_to_null'' Ttenbergen 20:18, 2015 January 19 (CST)
-[[Category: Development Documentation]]
+[[Category:Development Documentation]]
-[[category:2013 data upgrades]]
+[[category: 2013 data upgrades]]
-[[Category: Centralized data front end.mdb]]
+[[Category:Centralized data front end.accdb]]