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

m Text replacement - "Centralized_data.mdb" to "Centralized data.accdb"
m Text replacement - "Centralized data.accdb" to "Centralized_data.accdb"
Line 38: Line 38:
** query ''link_suspect_from_ICU_but_single_encounter''
** query ''link_suspect_from_ICU_but_single_encounter''
** query ''link_suspect_to_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)
* 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 ===
=== 2015-May-28 ===
Line 49: Line 49:
=== 2015-May-27 ===
=== 2015-May-27 ===
copied to master Ttenbergen 14:32, 2015 May 28 (CDT)
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)
* 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)
* 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 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)
* 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)
* 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)
* 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 ===
=== 2015-APR-02 ===