View source for Centralized data front end.mdb Change Log 2016

__NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. -->
''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.

== Change Log ==

=== next round ===
* These have to wait for back-populated data to be right. 
** query ''link_suspect_from_ours_single_encounter'' replaces following: 
*** query ''link_suspect_from_ICU_but_single_encounter''
*** query ''link_suspect_from_partner_no_match''
** query ''link_suspect_medicine_to_med_no_partner''
** query ''link_suspect_to_ICU_but_single_encounter

===2016-09-29===
not rolled out yet Ttenbergen 13:09, 2016 September 29 (CDT)
* added module updaters with sub Morden_Winkler_Boundarytrails() and several helper functions to update groups of items in s_dispo Ttenbergen 13:09, 2016 September 29 (CDT)
** they were run '''NOT YET'''
* added (and ran) queries for [[Centralized_data.mdb_Change_Log#2016-Oct-03]]
** they were run... Ttenbergen 17:51, 2016 October 3 (CDT)

===2016-09-28_2===
rolled out HAubel 14:30, 2016 September 28 (CDT)
* View Form's pt_demo_getter function updated with the new fields Accept_DtTm, Arrive_DtTm and Dispo_DtTm that generate the email snippet that gets executed by the cb_email_facilitator and cb_put_on_clipboard buttons.

===2016-09-28===
rolled out Ttenbergen 09:52, 2016 September 28 (CDT)
* updated query ''P_Count_of_Admissions'' to remove the s_locations table Ttenbergen 09:14, 2016 September 28 (CDT)

===2016-09-14===
rolled Ttenbergen 17:01, 2016 September 19 (CDT)
* Made viewer same as CCMDB (ADL Tab and moved reg fields we continue to use into the Dispo tab)
* removed query ''ages'' that used to calculate [[age]], since Julie gets this from [[created_variables_common table]] Ttenbergen 15:07, 2016 September 19 (CDT)

===2016-09-08===
rolled out Ttenbergen 16:27, 2016 September 8 (CDT)
*[[Postal Code field]] updates to table ''Postal_Code_Master'' to integrate file sent to [[Julie Mojica]] by [[Marc Silva]]. 
** imported postal_to_RHA table
** generated queries ''2016-09-08_Postalcodes_add_nonexisting'' and ''2016-09-08_Postalcodes_update_RHAs''
* cleaned out created_variables_*, they will be re-populated when their queries are run, just to do a proper compact/repair. Ttenbergen 16:26, 2016 September 8 (CDT)

===2016-09-01-2===
rolled out Ttenbergen 15:20, 2016 September 1 (CDT)
* working on pre fields, added queries 2016-09-01_* to fix problems.
* removed the hour/minute breakdowns from query L_Log_PHI to make it faster, they were no longer used. Ttenbergen 14:49, 2016 September 1 (CDT)

===2016-09-01===
rolled out Ttenbergen 10:56, 2016 September 1 (CDT)
* added control to form viewer for [[Off ward field]]. Ttenbergen 10:32, 2016 September 1 (CDT)
* added query ''2016-09-01_med_off_ward_pharm_fix'' to copy pharm_complete content to off ward field for med patients, the off ward control had been connected to that instead. Ttenbergen 10:47, 2016 September 1 (CDT)

===2016-08-31===
rolled Ttenbergen 17:41, 2016 August 31 (CDT)
* form view: updated the D_ID wizard related fields to work right. Ttenbergen 16:06, 2016 August 31 (CDT)

===2016-08-25===
rolled out Ttenbergen 19:51, 2016 August 25 (CDT)
* [[Postal code cross check]] 
** deleted query ''ND_Sub_postalCode'', no longer needed now that the data is in L_Log
** updated query ''NDC_Bad_Postal_Code'' to use new [[Postal Code field]] and limit to arrive > 2015-01-01 and not incomplete.

===2016-08-17===
Rolled out Ttenbergen 16:45, 2016 August 18 (CDT)
* D_ID affecting fields: 
** changed [[Service/Location field]], [[Pat_ID]] field and [[D_ID]] to not be editable directly and to open ''form D_ID_wizard''
** created form ''form D_ID_wizard'' to take care of the change in D_ID that would be triggered by changes in either field
* patient viewer form: 
** moved "program" field to top right, it was inconsistently spread across tabs
** moved "dispo" tab to the left and made it the default
** moved "Reg ADL Var" tab to right and added a LEGACY label on top of it, no more edits to this should be required.
* PatientList form
** updated the delete button to no longer ignore errors, and to delete from table ''tblTISSPatient'' as well. Ttenbergen 10:40, 2016 August 18 (CDT)
* TISS queries
** updated queries ''NDC_Pacemaker_acquired_wo_TISS'' and ''NDC_Pacemaker_TISS_wo_acquired'' to consider known error list L_Problem
** removed old queries ''TISS_form_missing_dates'', ''TISS_form_present_date_range''

===2016-08-15===
rolled out Ttenbergen 12:56, 2016 August 15 (CDT)
* added query ''2016-08-15_PL_Sex_error_fixer'' and table ''2016-08-15_PL_Sex_error'' to facilitate fixing large number of errors in query ''PL_SamePHIN_Diff_LN_FN_DOB_Sex'' that had gone undetected earlier. They will be removed again in future versions as they will work for the current errors only. -  Ttenbergen 09:54, 2016 August 15 (CDT)

===2016-08-08===
<had been rolled>
* restored 3 queries ''2016-05-26_GRAW3*'' that had not been run; let Pagasa know they will be available in this version. Ttenbergen 15:12, 2016 August 8 (CDT)
* added false positives that we will not fix to table L_Problems for query link_suspect_negative_transit_time
* made the city ERs available in teh Dispo dropdown in Form View Ttenbergen 15:18, 2016 August 8 (CDT)

===2016-07-28-2===
rolled Ttenbergen 17:22, 2016 July 28 (CDT)
* updated ''populate_linking_pairs()'' to use new dispo fields Ttenbergen 16:48, 2016 July 28 (CDT)
* changes of link_suspect_* queries to use new Dispo system:
** query ''link_suspect_dead_then_aliv''e - updated
** query ''link_suspect_negative_transit_time'' - updated
** try out query ''link_suspect_mismatch_from_ours''
* deleted unused query ''link_susp_intermediate_potential_location_partner''

===2016-07-28===
rolled Ttenbergen 11:05, 2016 July 28 (CDT)
* updated Sub ''likely_match_finder'' to list patient even if previous_location or dispo are not yet filled in Ttenbergen 11:05, 2016 July 28 (CDT)

===2016-07-27===
rolled Ttenbergen 14:56, 2016 July 27 (CDT)
* updated code behind handshake button to use new dispo fields Ttenbergen 14:56, 2016 July 27 (CDT)

===2016-07-25===
rolled out Ttenbergen 17:09, 2016 July 25 (CDT)
* changed ''function cbo_QuerySelector_Click()'' to sort by arr (arrival date) rather than adm (admit date) Ttenbergen 17:05, 2016 July 25 (CDT)

===2016-07-15===
rolled Ttenbergen 09:28, 2016 July 15 (CDT)
* changed query for form_view to pull from s_dispo instead of s_location. Ttenbergen 09:06, 2016 July 15 (CDT)

===2016-07-11===
rolled Ttenbergen 18:03, 2016 July 11 (CDT)
* built query ''20160706___postalcode_importer'' and ''20160706___postalcode_maker''
* fixed query ''20160706___PreAcute_maker''
* updated query ''PatientList'' to work while not all data has moved to dispo fields. Ttenbergen 15:58, 2016 July 11 (CDT)

===2016-07-08===
was rolled...
* more queries ''20160706___*''
* module ''2016-07_dispo_convert''

===2016-07-06===
(must have rolled) 
* query ''Patient_List'' to use new fields. Ttenbergen 16:20, 2016 July 7 (CDT)
* form ''PatientList'' Ttenbergen 16:20, 2016 July 7 (CDT)
* many changes toward [[Conversion of old registry fields to new dispo fields]] Ttenbergen 16:20, 2016 July 7 (CDT)

===2016-07-06===
rolled Ttenbergen 15:06, 2016 July 7 (CDT)
* updated queries for new DISPO fields
** query ''PL_SamePHIN_Diff_LN_FN_DOB_Sex''
** query ''PL_SameCHART_Site_Diff_PHIN''
** query ''PL_2PHIN _Fake_or_blank''
** query ''[[PL_1orphans]]''
** query ''P_Summary_Discharges_FiscalYear''
** query ''P_Summary_Discharges''
** query ''P_Outstandings_Discharges''
** query ''P_Outstandings_Admits''
** query ''P_Outstandings''
** query ''P_Count_of_sent''
** query ''P_Count_of_Admissions''
** query ''NDC_VAP_unacceptable_date''
** query ''NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2''
** query ''NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2''
** query ''NDC_Pacemaker_acquired_wo_TISS''
** query ''NDC_Missing_TransferDate_wPivot''
** query ''NDC_discharged_incomplete''
** query ''NDC_CLI_unacceptable_date''
** query ''NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2''
** query ''NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2''
** query ''ND_Sub_postalCode''
** query ''Multiple_Encounter''
* for [[Conversion of old registry fields to new dispo fields]]
** table ''20160706 Pre acute living situation field_translator''

=== 2016-07-05 ===
rolled with caution that push pull won't work right now. Ttenbergen 16:34, 2016 July 5 (CDT)
*Updates to 
** query ''Created_...
** query ''Created_...
** query ''L_Log_PHI''

=== 2016-07-04 ===
rolled with caution that push pull won't work right now. Ttenbergen 16:34, 2016 July 5 (CDT)

* changed "Re-Connect Data" button to draw from c:\ccmdb_program\ccmdb.mdb instead; '''''must update batch files to correspond'''''
* changing to use new fields
** query ''ages'' - [[age]]
** query ''created_Apache_details'' - [[Created Variables]]
** query ''L_Log_PHI'' - added new fields and changed ward, hosp, program to draw from [[s_dispo table]]
** query ''J_in-process_records'' - now pulls [[Service/Location]]
** query ''Labs_requester''
** query ''TISS_admitted_date_range''
** query ''PatientList''
** query ''PL_SamePHIN_Site_Diff_chart''

* clean-up
** deleted query ''created_variables_select''
** deleted query ''Created_Variables_ts''
** deleted query ''created_vars_selectonly''
** deleted table 's_HospitalCodes_updt''
** deleted query ''L_Log_PHI_time_hm'', use ''L_Log_PHI'' instead
** deleted query ''L_Dispo''
** deleted table ''R_completePTList''
** deleted table ''s_dispo_legacy_codes''
** deleted query ''s_dispo_combiner''
** deleted query ''s_locations_local''

=== 2016-05-26 ===
rolled Ttenbergen 13:09, 2016 May 26 (CDT)
* removing some old one-of queries that should be done with Ttenbergen 11:01, 2016 May 26 (CDT)
** 1_acp__test
** 1_acp_admit
** 1_acp_end
** 1_change_complication_CAP_to_HAP
** 11_5B_adm
** 11_5B_dis
* added three queries starting with ''2016-05-26_GRAW3_to_S3'' to do conversion; emailed Pagasa to run them Ttenbergen 13:08, 2016 May 26 (CDT)

=== 2016-05-05 ===
rolled out Ttenbergen 21:24, 2016 May 4 (CDT)
* added three new tables [[S_dispo table]], [[S_pre_acute_living_situation table]], [[S_previous_service_table]] to reconnector code Ttenbergen 21:07, 2016 May 4 (CDT)
* added fields on Pagasa's form Ttenbergen 21:07, 2016 May 4 (CDT)
* added query L_Dispo for Julie to access in SAS to resolve the entries as text Ttenbergen 21:20, 2016 May 4 (CDT)

=== 2016-04-14 ===
rolled Ttenbergen 17:55, 2016 April 14 (CDT)
* fixed password protection to be same as our other programs. Ttenbergen 17:55, 2016 April 14 (CDT)

=== 2016-01-28 ===
rolled out Ttenbergen 15:50, 2016 January 28 (CST)
* updating ''[[Query NDC missing Ls]]'' to not list incompletes even for dxs. Ttenbergen 15:50, 2016 January 28 (CST)

=== 2016-01-21 ===
rolled out.--Ttenbergen 17:19, 2016 January 21 (CST)
* added CFE ''[[Query NDC missing Ls]]'' to find missing mandatory child entries Ttenbergen 17:19, 2016 January 21 (CST)
* updated query ''ADL_Scores'' to refer to ALERT rather than MOST Ttenbergen 17:26, 2016 January 21 (CST)


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