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

(7 intermediate revisions by the same user not shown)

Line 38:

** 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.~~mdb~~ L_Problem. Ttenbergen 16:07, 2015 July 30 (CDT)

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

Line 44:

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

* 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.~~mdb_Change_Log~~#2015-May-26]] Ttenbergen 11:41, 2015 May 27 (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)

Line 59:

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 check for ~~"complete"~~ [[RecordStatus]] (~~see [[Cleaning up a failed send]]~~) to

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

** "re-connect ~~data~~" button on main form

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

** "vet all sent" button on PatientList

Line 72:

* 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~~.~~mdb~~ Requested Changes]]. Ttenbergen 17:01, 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 ===

Line 129:

[[Category: Development Documentation]]

[[Category:Development Documentation]]

[[category: 2013 data upgrades]]

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

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

@@ Line 38: / Line 38: @@
 ** 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.mdb L_Problem. Ttenbergen 16:07, 2015 July 30 (CDT)
+* 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 ===
@@ Line 44: / Line 44: @@
 * 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)
+* 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.mdb_Change_Log#2015-May-26]] Ttenbergen 11:41, 2015 May 27 (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)
@@ Line 59: / Line 59: @@
 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 check for "complete" [[RecordStatus]] (see [[Cleaning up a failed send]]) to
+* added Function Complete_exists() to check for [[RecordStatus]] "complete" in CFE (which should not exist)
-** "re-connect data" button on main form
+** [["Re-connect Data" button]] on main form
 ** "vet all sent" button on PatientList
@@ Line 72: / Line 72: @@
 * 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.mdb Requested Changes]]. Ttenbergen 17:01, 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 ===
@@ Line 129: / Line 129: @@
-[[Category: Development Documentation]]
+[[Category:Development Documentation]]
 [[category: 2013 data upgrades]]
-[[Category: Centralized data front end.accdb]]
+[[Category:Centralized data front end.accdb]]