CCMDB Wiki

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

← Older edit
→2016-10-31: rolled out
 
(64 intermediate revisions by 5 users not shown)
Line 2: Line 2:
''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''
''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 ==
== Change Log ==
*Go to: [[Centralized data front end.accdb Change Log 2017]]


=== binocs are slow ===
=== 2016-12-08 ===
* binocs are slow now. Why is that? Ttenbergen 09:42, 2016 October 31 (CDT)
rolled out 16:39, 2016 December 8 (CST)
** '''Pagasa notified that fast again now; still slow on my PC, not sure what's up, waiting for further reports from Pagasa''' Ttenbergen 11:59, 2016 October 31 (CDT)
* fixed
** tested copies of front-end as far back as mid-August, and they are just as slow now. Ttenbergen 10:07, 2016 October 31 (CDT)
**p_count_of_admissions query [[User:JMojica|JMojica]] 16:31, 2016 December 8 (CST)
** something change in data?
** p_summary_discharges
*** none of the changes in [[Centralized_data.mdb_Change_Log]] should cause this
** p_outstanding_discharges
** any updates applied that might mess this?
** p_outstanding_admits
** p_outstandings
 
=== 2016-12-07 ===
rolled out Ttenbergen 17:29, 2016 December 7 (CST)
* [[Reconnect_check_missing_L Tables_content query]]  - updated to not use old dispo fields any more. Ttenbergen 17:29, 2016 December 7 (CST)
* deleted old legacy tab in patient viewer Ttenbergen 17:29, 2016 December 7 (CST)
* searched for remaining mentions of r_adm and r_dis etc and commented them out Ttenbergen 17:29, 2016 December 7 (CST)
* removed old s_ tables from connector code and from currently connected tables Ttenbergen 17:29, 2016 December 7 (CST)
* removed old commented out VBA Ttenbergen 17:29, 2016 December 7 (CST)
 
=== 2016-12-01 ===
rolled out Ttenbergen 16:30, 2016 December 1 (CST)
* updated the Sub ''populate_linking_pairs()'' to sort by (accept_dttm if available, else arrive_dttm) rather than arrive_dttm. Ttenbergen 11:58, 2016 December 1 (CST)
 
=== 2016-11-29 ===
Rolled Out [[User:Haubel|Haubel]] 16:53, 2016 November 29 (CST)
 
Following Queries Changed:
*PL_2PHIN_Fake_or_blank
**Got rid of  L_Log_PHI.R_AdmDate
**Replaced by L_Log!Arrive_DtTm and L_Log!Accept_DtTm
 
*PL_Chart_9_Digit
**Got rid of L_Log_Phi.R_Location
**Replaced by L_Log_PHI.Service_Location
**Got rid of L_Log_PHI.R_AdmDate
**Replaced by L_Log!Arrive_DtTm and L_Log!Accept_DtTm
 
*PL_SameCHART_Site_Diff_PHIN
**Got rid of L_Log_PHI.R_AdmDate
**Replaced by L_Log!Arrive_DtTm and L_Log!Accept_DtTm
 
*PL_SamePHIN_Diff_LN_FN_DOB_Sex
**Got rid of L_Log_Phi.R_Location
**Replaced by L_Log_PHI.Service_Location
 
*PL_SamePHIN_Site_Diff_chart
**Got rid of L_Log_PHI.R_AdmDate
**Replaced by L_Log!Arrive_DtTm and L_Log!Accept_DtTm
 
Remains as is:
*Several active references to R_AdmDate still exist in the "View" form that have been left unmodified since it's not clear what to replace them with (L_Log!Arrive_DtTm or L_Log!Accept_DtTm).  These controls are in the Reg & Var tab.
**cb_ad_dt_down_Click()
**cb_ad_dt_now_Click()
**cb_ad_dt_up_Click()
 
=== 2016-11-28 ===
rolled out Ttenbergen 10:57, 2016 November 28 (CST)
* updated query ''L_Log_PHI'' to no longer require the pre-dispo fields. Ttenbergen 10:55, 2016 November 28 (CST)
 
=== 2016-11-21 ===
rolled out Ttenbergen 15:57, 2016 November 24 (CST)
* added Sub ''old_field_cleanup_20161121()'' to clean out old fields in L_Log.
* confirmed that Pagasa's forms are in my master
* updated [[link_suspect_mismatch_to_ours__incomplete query]] to fix [[L Problem table]] use Ttenbergen 10:16, 2016 November 24 (CST)
* updated/confirmed queries to have D_ID as first columns so they will work with form dropdown, and to include [[L Problem table]] reference:
** [[link_suspect_dead_then_alive query]]
** [[link_suspect_mismatch_from_ours__incomplete query]]
** [[link_suspect_mismatch_pre_inpt__ours_incomplete query]]
** [[link_suspect_mismatch_to_ours__incomplete query]]
** [[link_suspect_negative_transit_time query]]
** [[link_suspect_not_same_visitAdmitDtTm query]]
 
=== 2016-11-17 ===
Pagasa has the master due to the extra forms I made for her Ttenbergen 15:21, 2016 November 17 (CST)
 
=== 2016-11-14 ===
rolled out Ttenbergen 17:02, 2016 November 14 (CST)
* updated query ''link_suspect_negative_transit_time'' with SQL sent by Pagasa that we worked out on her PC some time ago. Ttenbergen 16:41, 2016 November 14 (CST)
* added [[GCS sedated field]] to form viewer Ttenbergen 17:24, 2016 November 14 (CST)
 
=== 2016-11-07 ===
rolled out Ttenbergen 13:52, 2016 November 7 (CST)
* added [[Visit Admit DtTm field]] to the handshake form:
** updated Sub ''likely_match_finder''
** updated form ''likely_match''
* updated the link_* forms to not have date restriction, ie show even old errors. We may need to review this again because there are LOTS of errors. Ttenbergen 13:52, 2016 November 7 (CST)


=== 2016-10-31 ===
=== 2016-10-31 ===
rolled out Ttenbergen 15:13, 2016 November 3 (CDT)
rolled out Ttenbergen 15:13, 2016 November 3 (CDT)
* added query ''link_suspect_not_same_visitAdmitDtTm'' as designed with Pagasa; added link to [[L_Problems table]] to hide false positivesTtenbergen 15:06, 2016 October 31 (CDT)
* added [[link_suspect_not_same_visitAdmitDtTm query ]] as designed with Pagasa; added link to [[L Problem table]] to hide false positivesTtenbergen 15:06, 2016 October 31 (CDT)
* query ''NDC_VAP_unacceptable_date'' listing false positives; fixed and added in L_Problems exemption. Ttenbergen 15:09, 2016 November 3 (CDT)
* query ''[[query NDC_VAP_unacceptable_date]]'' listing false positives; fixed and added in [[L Problem table]]  exemption. Ttenbergen 15:09, 2016 November 3 (CDT)


=== 2016-10-27-3 ===
=== 2016-10-27-3 ===
rolled out Ttenbergen 17:07, 2016 October 27 (CDT)
rolled out Ttenbergen 17:07, 2016 October 27 (CDT)
* query ''NDC_VAP_unacceptable_date'' - had false negative, added restriction where date can't be after [[dispo_DtTm]]
* query ''query NDC_VAP_unacceptable_date'' - had false negative, added restriction where date can't be after [[dispo_DtTm]]
* form viewer - allowing inactive values for previous location and pre-admit inpatient location
* form viewer - allowing inactive values for [[Previous Location]] and [[Pre-admit Inpatient Institution]]


=== 2016-10-27-2 ===
=== 2016-10-27-2 ===
Line 80: Line 158:
rolled Ttenbergen 17:01, 2016 September 19 (CDT)
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)
* 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)
* removed query ''ages'' that used to calculate [[age]], since Julie gets this from [[Created_Variables_Common_2021 table]] Ttenbergen 15:07, 2016 September 19 (CDT)


===2016-09-08===
===2016-09-08===
rolled out Ttenbergen 16:27, 2016 September 8 (CDT)
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]].  
*[[Postal Code field]] updates to table ''Postal_Code_Master'' to integrate file sent to [[p:Julie Mojica]] by [[Marc Silva]].  
** imported postal_to_RHA table
** imported postal_to_RHA table
** generated queries ''2016-09-08_Postalcodes_add_nonexisting'' and ''2016-09-08_Postalcodes_update_RHAs''
** generated queries ''2016-09-08_Postalcodes_add_nonexisting'' and ''2016-09-08_Postalcodes_update_RHAs''
Line 105: Line 183:
===2016-08-25===
===2016-08-25===
rolled out Ttenbergen 19:51, 2016 August 25 (CDT)
rolled out Ttenbergen 19:51, 2016 August 25 (CDT)
* [[Postal code cross check]]  
* [[query NDC_Bad_Postal_Code]]  
** deleted query ''ND_Sub_postalCode'', no longer needed now that the data is in L_Log
** 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.
** updated query ''NDC_Bad_Postal_Code'' to use new [[Postal Code field]] and limit to arrive > 2015-01-01 and not incomplete.
Line 121: Line 199:
** updated the delete button to no longer ignore errors, and to delete from table ''tblTISSPatient'' as well. Ttenbergen 10:40, 2016 August 18 (CDT)
** 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
* TISS queries
** updated queries ''NDC_Pacemaker_acquired_wo_TISS'' and ''NDC_Pacemaker_TISS_wo_acquired'' to consider known error list L_Problem
** updated queries ''"NDC_Pacemaker_acquired_wo_TISS"'' and ''"NDC_Pacemaker_TISS_wo_acquired"'' to consider known error list [[L Problem table]]
** removed old queries ''TISS_form_missing_dates'', ''TISS_form_present_date_range''
** removed old queries ''TISS_form_missing_dates'', ''TISS_form_present_date_range''


Line 131: Line 209:
<had been rolled>
<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)
* 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
* added false positives that we will not fix to [[L Problem table]]  for [[link_suspect_negative_transit_time query]]
* made the city ERs available in teh Dispo dropdown in Form View Ttenbergen 15:18, 2016 August 8 (CDT)
* made the city ERs available in teh Dispo dropdown in Form View Ttenbergen 15:18, 2016 August 8 (CDT)


Line 182: Line 260:
** query ''PL_SameCHART_Site_Diff_PHIN''
** query ''PL_SameCHART_Site_Diff_PHIN''
** query ''PL_2PHIN _Fake_or_blank''
** query ''PL_2PHIN _Fake_or_blank''
** query ''[[PL_1orphans]]''
** query ''[[Reconnect_check_orphans query ]]''
** query ''P_Summary_Discharges_FiscalYear''
** query ''P_Summary_Discharges_FiscalYear''
** query ''P_Summary_Discharges''
** query ''P_Summary_Discharges''
Line 190: Line 268:
** query ''P_Count_of_sent''
** query ''P_Count_of_sent''
** query ''P_Count_of_Admissions''
** query ''P_Count_of_Admissions''
** query ''NDC_VAP_unacceptable_date''
** query ''query NDC_VAP_unacceptable_date''
** query ''NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2''
** query ''NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2''
** query ''NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2''
** query ''Query query NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2''
** query ''NDC_Pacemaker_acquired_wo_TISS''
** query ''NDC_Pacemaker_acquired_wo_TISS''
** query ''NDC_Missing_TransferDate_wPivot''
** query ''NDC_Missing_TransferDate_wPivot''
** query ''NDC_discharged_incomplete''
** query ''query NDC_discharged_incomplete''
** query ''NDC_CLI_unacceptable_date''
** query ''NDC_CLI_unacceptable_date''
** query ''NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2''
** query ''NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2''
** query ''NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2''
** query ''query NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2''
** query ''ND_Sub_postalCode''
** query ''ND_Sub_postalCode''
** query ''Multiple_Encounter''
** query ''Multiple_Encounter''
Line 214: Line 292:
rolled with caution that push pull won't work right now. Ttenbergen 16:34, 2016 July 5 (CDT)
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'''''
* changed "Re-Connect Data" button to draw from c:\ccmdb_program\ccmdb.accdb instead; '''''must update batch files to correspond'''''
* changing to use new fields
* changing to use new fields
** query ''ages'' - [[age]]
** query ''ages'' - [[age]]
** query ''created_Apache_details'' - [[Created Variables]]
** 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 ''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 J in-process records]] - now pulls [[Service/Location]]
** query ''Labs_requester''
** query ''Labs_requester''
** query ''TISS_admitted_date_range''
** query ''TISS_admitted_date_range''
Line 260: Line 338:
=== 2016-01-28 ===
=== 2016-01-28 ===
rolled out Ttenbergen 15:50, 2016 January 28 (CST)
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)
* updating ''[[Reconnect_check_missing_L Tables_content query]]'' to not list incompletes even for dxs. Ttenbergen 15:50, 2016 January 28 (CST)


=== 2016-01-21 ===
=== 2016-01-21 ===
rolled out.--Ttenbergen 17:19, 2016 January 21 (CST)
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)
* added CFE ''[[Reconnect_check_missing_L Tables_content query]]'' 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)
* updated query ''ADL_Scores'' to refer to ALERT rather than MOST Ttenbergen 17:26, 2016 January 21 (CST)


Line 270: Line 348:
[[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]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.mdb_Change_Log_2016"