CCMDB Wiki

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

← Older edit
m Text replacement - "[[Category: " to "[[Category:"
 
(23 intermediate revisions by the same user not shown)
Line 18: Line 18:
=== 2016-12-07 ===
=== 2016-12-07 ===
rolled out Ttenbergen 17:29, 2016 December 7 (CST)
rolled out Ttenbergen 17:29, 2016 December 7 (CST)
* [[Query_NDC_missing_L_Tables_content]]  - updated to not use old dispo fields any more. 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)
* 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)
* searched for remaining mentions of r_adm and r_dis etc and commented them out Ttenbergen 17:29, 2016 December 7 (CST)
Line 68: Line 68:
* added Sub ''old_field_cleanup_20161121()'' to clean out old fields in L_Log.
* added Sub ''old_field_cleanup_20161121()'' to clean out old fields in L_Log.
* confirmed that Pagasa's forms are in my master
* confirmed that Pagasa's forms are in my master
* updated [[link_suspect_mismatch_to_ours__incomplete query]] to fix [[L Problems table]] use Ttenbergen 10:16, 2016 November 24 (CST)
* 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 Problems table]] reference:  
* 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_dead_then_alive query]]
** [[link_suspect_mismatch_from_ours__incomplete query]]
** [[link_suspect_mismatch_from_ours__incomplete query]]
Line 94: Line 94:
=== 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 Problem 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 144: Line 144:
* 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)
* 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)
** was run.  Ttenbergen 17:57, 2016 October 3 (CDT)
** was run.  Ttenbergen 17:57, 2016 October 3 (CDT)
* added (and ran) queries for [[Centralized_data.mdb_Change_Log#2016-Oct-03]]
* added (and ran) queries for [[Centralized_data.accdb]]_Change_Log#2016-Oct-03]]
** they were run. Ttenbergen 17:51, 2016 October 3 (CDT)
** they were run. Ttenbergen 17:51, 2016 October 3 (CDT)


Line 158: 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===
Line 183: 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 199: 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 209: 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 260: 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 268: 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 292: 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 338: 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 L Tables content]]'' 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 L Tables content]]'' 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)




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