CCMDB.mdb Change Log 2018

From CCMDB Wiki
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.

The CCMDB.mdb Change Log logs changes made to the CCMDB.mdb. New entries should be made at the top to be immediately apparent.

Enter requested CCMDB changes for the next version in that article.

Versions

next

  • If you enter CCI entry, then click “delete” you get null error; need to get nicer error
  • update component 2 on L_CCI_Component_subform so it only lists what is allowed. This turns out to be tricky...
  • review and fix L_ICD10_APACHE_Dx query

2018-06-20

not rolled out yet Ttenbergen 15:44, 2018 June 20 (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)

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)

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)

  • update to CCI Chooser form - the category filter was showing nothing for Obstetric and Misc. As it should not, since there are none. But then it should also not list them.
  • fixed spelling for No Comorbidities (ICD10 code) in s_ICD10 table. Ttenbergen 16:56, 2018 April 5 (CDT)
  • updated s_CCI_2 table to use different codes for Inspection, Exploration (70d) and [[]](70i). Both were 70 and that got them mixed up. Ttenbergen 13:43, 2018 April 6 (CDT)
  • updated s_dispo table: disabled "VIC - ER" Ttenbergen 13:44, 2018 April 6 (CDT)
  • updated s_ICD10 table:
    • set end date for "Y57.8 - Drug NOS used appropriately, adverse effect (reaction, allergy, hypersensitivity)" to today Ttenbergen 13:50, 2018 April 6 (CDT)
    • deleted ICD10_ID field since we won't be using it now (coding actual ICD10 code instead)

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)