CCMDB.mdb Change Log 2018

From CCMDB Wiki
Revision as of 08:42, 2020 May 26 by Ttenbergen (talk | contribs) (link fixes due to page name changes)
Jump to navigation Jump to search

See Log (disambiguation) for other uses of the term "Log". See the Development Documentation Category for other development logs. See Rolling out changes for the process of rolling out changes. Enter requested CCMDB changes for the next version in that article.

Versions

2018-12-21

rolled out Ttenbergen 21:19, 2019 January 1 (CST)

Changes collectors will want to know about:

Changes behind the scenes: Collectors will only care about these if they went wrong...

2018-12-20-2

rolled out Ttenbergen 21:27, 2018 December 20 (CST)

Change collectors will want to know about:

behind the scenes...

2018-12-20

rolled out Ttenbergen 10:12, 2018 December 20 (CST)

2018-12-17

rolled out Ttenbergen 22:31, 2018 December 18 (CST)

Changes Collectors will want to know about:

2018-12-14

rolled out Ttenbergen 20:22, 2018 December 16 (CST) Changes collectors will want to know about:

2018-12-04

rolled out Ttenbergen 10:23, 2018 December 4 (CST)

  • reduce the number of times that the ER Delay error shows up

2018-12-02

SEE THE NEXT CHANGE AS WELL, BOTH DONE THIS WEEKEND

rolled out Ttenbergen 20:26, 2018 December 2 (CST)

  • Collectors should see no difference, except maybe fewer of the lock errors during sending
    • updated properties for all send*append and send*update query to Record Locks = no locks

2018-11-27-1

rolled out Ttenbergen 02:05, 2018 December 1 (CST) Changes collectors will want to know about

a bunch of spelling tweaks in the substance category   

Changes that are mostly behind the scenes

2018-11-27

rolled out Ttenbergen 11:33, 2018 November 27 (CST) Changes collectors will want to know

behind the scenes or minor changes

  • tweaked wording of the error message given when a cross check finds an error.
  • tweaked the size of the patient viewer form so it fits on a laptop screen without scrolling

2018-11-26-1

rolled out Ttenbergen 22:44, 2018 November 26 (CST)

2018-11-26

not rolled out yet Ttenbergen 13:27, 2018 November 26 (CST)

2018-11-25

rolled out Ttenbergen 00:27, 2018 November 26 (CST) Changes collectors will want to know about

2018-11-23

rolled out Ttenbergen 22:11, 2018 November 24 (CST)

Changes collectors will want to know about

Behind the scenes changes:

  • removed old, unused queries:
    • query Check_Dx_UniqueDx
    • query Check_Dx_UniquePriority
    • query Check_Como_Unique
  • removed the Vic locations and added the STB Med locations to s_locations_allowed_collection table
  • made inactive AcceptDateSource that was stopped in March

2018-11-22

rolled out

2018-11-21

rolled out Ttenbergen 18:52, 2018 November 21 (CST)

2018-11-19

rolled out Ttenbergen 22:12, 2018 November 20 (CST) changes collectors will want to know about

  • none, only fixes this time

behind the scenes changes

2018-11-19

rolled out Ttenbergen 09:10, 2018 November 19 (CST)

  • several minor tweaks to the last round of queries

2018-11-13

rolled out Ttenbergen 00:42, 2018 November 19 (CST) Collectors will want to know:

Behind the scenes stuff...

2018-11-12

rolled out Ttenbergen 20:00, 2018 November 12 (CST) Changed collectors should know about:

Behind the scenes changes:

  • implemented function include_pt() to be able to only check patients with Pat_ID ending in 8, and later be able to change it to all patients by single place edit.
  • deleted old temporary query "2018_04_03_L_ICD10_translator"
  • imported from CFE query L_CCI_Combined and its subquery L_CCI_Combined_ComponentSubQ]]
  • tweaked query check_dx_primary_not_exactly_one so it will only consider Admit Diagnosis

2018-11-08-1

rolled out Ttenbergen 20:54, 2018 November 9 (CST)

2018-11-08

rolled out Ttenbergen 22:06, 2018 November 8 (CST) Changes Collectors should know about:

2018-11-07-1

rolled out Ttenbergen 11:20, 2018 November 7 (CST)

2018-11-07

rolled out Ttenbergen 11:13, 2018 November 7 (CST)

2018-11-05

rolled out Ttenbergen 13:45, 2018 November 6 (CST) when this rolls I need to test that the Windows 10 folks now get the log showing up

2018-11-02

rolled out - PTorres 09:55, 2018 November 2 (CDT)

  • Added in s_Record Status "Discontinued"
  • Updated hospital names in s_dispo table done by Julie Mojica

2018-10-30

rolled out Ttenbergen 11:31, 2018 October 31 (CDT)

2018-10-30

rolled out Ttenbergen 09:36, 2018 October 30 (CDT)

  • further tweaking of notes field checks: commented out requery command that was causing re-set of form on tabbing out. Will need to find out a way to write before requery.Ttenbergen 09:36, 2018 October 30 (CDT)

2018-10-26-1

rolled out Ttenbergen 12:12, 2018 October 29 (CDT)

  • changed function notes checker to requery data before checking it to prevent the error were getting when leaving notes field if there was bad data in WBC
  • deleted old tables send_dxs_acqu and send_pharm
  • updated sending so that database gets closed after tables are linked (to clean up)
  • changed queries ODBC Timeout to 120 to see if this will improve the disconnect network problem
  • updated error email when sending goes wrong in hopes that now it will show the proper error Nr, not zero.
  • updated L_ICD10_subform to default sort to
    • Dx type (admit, …)
    • Priority
    • Date
    • Description

2018-10-26

rolled out Ttenbergen 11:54, 2018 October 26 (CDT)

  • reverted to 2015-10-17 due to problems introduced by ..-24
  • re-imported from newer version Query check dx primary lowest priority
  • re-applied ADL hiding from prev version
  • re-applied picklist name fixes
  • re-applied patient list wiki link update

2018-10-25

not rolled yet Ttenbergen 10:32, 2018 October 25 (CDT)

  • updated Function runQuery to give more meaningful error when there is a problem during sending. Ttenbergen 10:32, 2018 October 25 (CDT)
  • updated form Patient List to change the wiki links to the little icons like in form patient viewer. Corrected link to LastChanged DtTm field. Ttenbergen 16:22, 2018 October 25 (CDT)

2018-10-24

rolled out Ttenbergen 09:39, 2018 October 25 (CDT)

2018-10-17

rolled out Ttenbergen 10:03, 2018 October 22 (CDT)

2018-10-15-2

rolled out Ttenbergen 22:46, 2018 October 15 (CDT)

2018-10-15-1

rolled out Ttenbergen 15:59, 2018 October 15 (CDT)

2018-10-15

rolled out Ttenbergen 15:12, 2018 October 15 (CDT)

2018-10-11

rolled out Ttenbergen 18:24, 2018 October 14 (CDT)

  • Should not be visible to collecors:
    • updating a bunch of old code to improve error handling, should be invisible to collectors
    • removed a bunch of old calls to err_logger that did nothing from:
      • Function get_a_info
      • Function initial_control_empty_check
      • Sub LabCheck
      • Validate_PHIN
      • Function Reject_a_query
      • Function Reject_a_query_PatID
      • Function reject_pharm
      • Function reject_lab
      • Sub Convert_DB()
    • deleted Function Reject_too_many that is no longer used

2018-10-09

rolled out Ttenbergen 23:32, 2018 October 9 (CDT)

2018-10-03-2

rolled out Ttenbergen 12:39, 2018 October 3 (CDT)

2018-10-03

rolled out Ttenbergen 10:59, 2018 October 3 (CDT)

2018-10-01

rolled out Ttenbergen 14:12, 2018 October 1 (CDT)

  • fix to query check_dx_primary_lowest_priority Ttenbergen 08:36, 2018 October 1 (CDT)
  • update to Dx_Checker to make the error messages more meaningful. Ttenbergen 08:41, 2018 October 1 (CDT)
  • changed name of STB_HOBS to STB_IMCU
  • tweak for call of query s_tmp_QAInf_basic that had somehow sprouted an "s" Ttenbergen 14:02, 2018 October 1 (CDT)

2018-09-25

rolled out Ttenbergen 22:02, 2018 September 30 (CDT)

2018-09-06

rolled out Ttenbergen 09:46, 2018 September 25 (CDT)

2018-09-05-2

rolled out Ttenbergen 10:11, 2018 September 6 (CDT)

2018-09-05

rolled out Ttenbergen 13:27, 2018 September 5 (CDT)

  • S ICD10 APACHE Dx patterns table - replaced with Julies version which adds columns weight, index, DxGrp and DxGrp_label as requested by 2018-08-24 email from Julie Ttenbergen 13:26, 2018 September 5 (CDT)
  • s_CCI_Picklist table - re-wrote code 1.HZ.53.GR-FS because it had some invisible character at the beginning that was displacing it in sorts. Ttenbergen 10:14, 2018 September 5 (CDT)
  • Project Borrow arrive - changed "no borrow" option in s_tmp table so it could be entered manually in case it had been changed to a location and then needed to be changed back to "no borrow". Ttenbergen 09:33, 2018 September 5 (CDT)

2018-08-13

rolled out Ttenbergen 17:36, 2018 August 13 (CDT)

2018-07-31

rolled out Ttenbergen 20:23, 2018 July 31 (CDT)

2018-07-26

rolled out Ttenbergen 18:50, 2018 July 29 (CDT)

2018-07-17

rolled out Ttenbergen 22:13, 2018 July 17 (CDT)

2018-07-12

rolled out Ttenbergen 11:46, 2018 July 17 (CDT)

2018-06-27

rolled out Ttenbergen 16:44, 2018 July 11 (CDT)

2018-06-20

rolled out Ttenbergen 11:07, 2018 June 21 (CDT)

2018-05-30-1

rolled out Ttenbergen 17:06, 2018 June 19 (CDT)

2018-05-30-1

rolled out Ttenbergen 20:05, 2018 May 30 (CDT)

2018-05-30

rolled out Ttenbergen 10:51, 2018 May 30 (CDT)

  • in s_dispo table,
    • inactivated Misericordia - ER
    • added Misericordia - UC (as inactive) in anticipation of updating data as per Urgent Care Ttenbergen 09:31, 2018 May 30 (CDT)
  • in s_ICD10 table
  • in L_ICD10 subform, added code to prevent error and give meaningful error msg when someone tries to simply delete a dx entry rather than the whole row. Ttenbergen 10:31, 2018 May 30 (CDT)
  • in L_CCI_Picklist subform, added code to prevent error and give meaningful error msg when someone tries to simply delete a dx entry rather than the whole row.
  • in L_CCI_Component subform, added code to prevent error and give meaningful error msg when someone tries to simply delete a dx entry rather than the whole row.

2018-05-17

rolled out Ttenbergen 17:06, 2018 May 24 (CDT)

2018-05-09-1

rolled out Ttenbergen 18:23, 2018 May 16 (CDT)

2018-05-09

rolled out Ttenbergen 10:22, 2018 May 9 (CDT)

  • removing Registry Patient Type
    • deleted from Dispo tab in Patient Viewer
    • deleted references from Sub Reg_Yellower()
    • deleted Function Validate_Pt_Type()
    • deleted Sub R_Type_AfterUpdate()
    • updated sending functions
      • query Send_Centralized_1L_Log_update
      • query Send_Centralized_1L_Log_append
      • there is no delete query for L_Log
      • query send_Centralized_1L_Log__intermediate
    • deleted query check_OR_from_but_not_Surgical_Type; did not find any calls to it so it appears it wasn't actually used.
  • removed some code remnants that had long been commented out, mostly from the old date/time/location structure

2018-05-07

rolled out Ttenbergen 17:37, 2018 May 8 (CDT)

2018-05-03

rolled out Ttenbergen 09:36, 2018 May 3 (CDT)

2018-04-24

rolled out Ttenbergen 17:21, 2018 April 25 (CDT)

2018-04-12

rolled out Ttenbergen 09:23, 2018 April 19 (CDT)

2018-04-11

rolled out Ttenbergen 15:29, 2018 April 12 (CDT)

2018-04-10-1

rolled out Ttenbergen 21:31, 2018 April 10 (CDT)

2018-04-10

rolled out.Trish Ostryzniuk 16:21, 2018 April 10 (CDT)

  • add New Tmp project: [[ICUotherService].-- Trish Ostryzniuk 16:16, 2018 April 10 (CDT)
  • renamed AXR plain film to "Abdominal plain X-ray (AXR)"

2018-04-09-1

rolled outTtenbergen 11:43, 2018 April 9 (CDT)

2018-04-09

rolled out Ttenbergen 09:35, 2018 April 9 (CDT)

  • removed ICD10_ID field from L_ICD10 subform as well Ttenbergen 09:35, 2018 April 9 (CDT)

2018-04-05-1

rolled out Ttenbergen 14:13, 2018 April 6 (CDT)

2018-04-05

rolled out Ttenbergen 09:37, 2018 April 5 (CDT)

  • fixed Sub dx_pick_cb_Click() to work with new ICD10 table Ttenbergen 09:37, 2018 April 5 (CDT)

2018-04-03

rolled out Ttenbergen 21:49, 2018 April 4 (CDT)

  • changes to accommodate CCMDB_data.mdb_Change_Log#2017-Dec-20
    • updated module Convert_DB() to look for L_CCI_Component table and L_CCI_Picklist table instead of L_CCI as we figured initially
    • updated module Sending Sub OpenOutputDBs()
    • updated L_ICD10_subform to use new ICD10 code field
    • updated L_Charlson_Diagnoses query
    • updated L_ICD10_APACHE_Comorbids query
    • updated L_ICD10_APACHE_Dx query - as far as it goes, this one is still not right.
    • added send queries
      • Send_Centralized_L_CCI_Picklist__intermediate query
      • Send_Centralized_L_CCI_Picklist_delete
      • Send_Centralized_L_CCI_Picklist_update
      • Send_Centralized_L_CCI_Picklist_append
      • Send_Centralized_L_CCI_Component__intermediate
      • Send_Centralized_L_CCI_component_delete
      • Send_Centralized_L_CCI_Component_update
      • Send_Centralized_L_CCI_Component_append
      • Send_Centralized_L_ICD10__intermediate
      • Send_Centralized_L_ICD10_delete (confirmed, no change)
      • Send_Centralized_L_ICD10_update
      • Send_Centralized_L_ICD10_append

Non-to-do

  • L_CCI needs no resolving, since it already has not had any contents for some time.
  • moving the newer CCI tables won't work because this will be the new CCMDB.mdb and they will be already overwritten
  • so, CCI will start out empty.

2018-04-02

rolled out Ttenbergen 11:52, 2018 April 3 (CDT)

2018-03-22

not rolled yet Ttenbergen 17:46, 2018 March 22 (CDT)

2018-03-20

rolled out Ttenbergen 21:29, 2018 March 20 (CDT)

2018-03-14

rolled out Ttenbergen 21:05, 2018 March 14 (CDT)

  • updating diagnosis names and spellings that had been added/changed on wiki over the last few months. Ttenbergen 19:48, 2018 March 14 (CDT)
  • fixed links to the wiki pages from the CCI tab Ttenbergen 00:31, 2018 March 15 (CDT)

2018-03-08

rolled out Ttenbergen 13:22, 2018 March 13 (CDT)

2018-03-07

rolled out Ttenbergen 18:29, 2018 March 7 (CST)

2018-03-05

rolled out Ttenbergen 15:01, 2018 March 6 (CST)

2018-02-18

rolled out Ttenbergen 17:52, 2018 February 28 (CST)

  • much further messing with CCI data and forms
  • updated query check_previous_location_vs_service_inconsistent to allow STB_CICU to enter Cardiac Surgery as Previous Service.

2018-02-01

rolled out. Ttenbergen <late afternoon>, 2018 February 16 (CST)

  • replaced L_CCI_subform with:
  • updated cross checks for ER_Delay
    • query check_ER_Delay_not_too_big
    • error msg in Function Dispo_Chronological()
  • updated Function Regional_server() to use Regional_server = "\\ad.wrha.mb.ca\wrha\REGION\Shared\ICU_DATA_COLLECTION\" (from REGIONWRHA to REGION)

2018-01-31

rolled out Ttenbergen 17:49, 2018 January 31 (CST)

  • additional tweaks to Accept Loc Park
    • confirmed query s_tmp_Accept_Log_Park_prev_no_tmp
    • updated query s_tmp_Accept_Log_Park_tmp_no_prev

2018-01-30

rolled out Ttenbergen 13:54, 2018 January 30 (CST)

  • fix to L ICD10 subform, still wasn't setting the primary dx checkbox properly, now does.

2018-02-02 (mis-dated)

had been rolled out... Ttenbergen 13:54, 2018 January 30 (CST)

2018-01-21

rolled out Ttenbergen 19:04, 2018 January 23 (CST)

  • confirmed that pre-send-checker would catch duplicate diagnosesTtenbergen 13:51, 2018 January 21 (CST)
  • added for Accept Loc Park:
    • nursing stations Ttenbergen 13:51, 2018 January 21 (CST)
    • added cross checks:
      • query s_tmp_Accept_Log_Park_prev_no_tmp
      • query s_tmp_Accept_Log_Park_tmp_no_prev
  • in ICD10 tab, fixed the primary dx checkbox that had been linked to the date unknown field (as the date unknown field was linked to as well) Ttenbergen 14:19, 2018 January 21 (CST)
  • ER_Delay#CCDMB_Data_Integrity_Checks_(implemented) (query check_ER_Delay_not_too_big)
    • reduced ICU delay to 4hrs
    • fixed problem where wasn't finding errors before, confirmed working
  • confirmed that there will be an error if trying to send Pharmacy without at least one line. Ttenbergen 14:42, 2018 January 21 (CST)
  • confirmed that can enter Previous Service "Cardiology" when Previous Location is STB_ACCU.
  • Split CCI and ICD10 tabs. Ttenbergen 19:02, 2018 January 23 (CST)

2018-01-10

rolled out Ttenbergen 18:01, 2018 January 10 (CST)

2018-01-09

rolled out Ttenbergen 09:18, 2018 January 9 (CST)

2018-01-04

rolled out Ttenbergen 19:08, 2018 January 4 (CST)

  • added sending for L_CCI table and L_ICD10 table Ttenbergen 17:31, 2018 January 4 (CST)
    • updated Send_Data()
    • updated Sub OpenOutputDBs Ttenbergen 17:35, 2018 January 4 (CST)
    • updated Sub CloseOutputDBs Ttenbergen 17:35, 2018 January 4 (CST)
    • added queries:
      • Send_Centralized_L_CCI__intermediate
      • Send_Centralized_L_ICD10__intermediate
      • Send_Centralized_L_CCI_delete
      • Send_Centralized_L_ICD10_delete
      • Send_Centralized_L_CCI_update
      • Send_Centralized_L_ICD10_update
      • Send_Centralized_L_CCI_append
      • Send_Centralized_L_ICd10_append

2017-12-28

Rolled out Ttenbergen 13:24, 2018 January 4 (CST)

  • removed Angio coronary field and Angio others field from labs tab in patient viewer Ttenbergen 17:01, 2017 December 28 (CST)
  • updated the pick button in ICD10 Chooser form to no longer requery the L ICD10 subform as this was resorting the dxs and collectors then had to find the one they had just entered to finish the entry. Ttenbergen 18:44, 2017 December 28 (CST)
  • ACCU borrow - fix to cross check query s_tmp_ACCU_Borrow_chronicity_hard; was using obsdate and obstime, when it should have used date_var and time_var. Ttenbergen 13:13, 2018 January 4 (CST)