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

m Text replacement - "Centralized data.mdb" to "Centralized data.accdb"
m Text replacement - "[[Category: " to "[[Category:"
 
(3 intermediate revisions by the same user not shown)
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.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 ===
=== 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.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)
* 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 ===
Line 129: Line 129:




[[Category: Development Documentation]]
[[Category:Development Documentation]]
[[category: 2013 data upgrades]]
[[category: 2013 data upgrades]]
[[Category: Centralized data front end.accdb]]
[[Category:Centralized data front end.accdb]]