CCMDB.mdb Change Log 2018

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
• In CCI, if you use the “?” to enter a new Dx you don’t get empty lines for the next, unless you re-sort

• update component 2 on L_CCI_Component_subform so it only lists what is allowed. This turns out to be tricky...

• remove ICD10_id from S ICD10 table.

• review and fix L_ICD10_APACHE_Dx query

2018-04-05-1

not rolled out yet Ttenbergen 16:06, 2018 April 5 (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)

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)

• added Sequelae of poliomyelitis (chronic weakness) to s_ICD10 table

• 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)

• updated L ICD10 subform to conditionally format the priority and dx fields to have different colours for odd and even priorities to make it easier to visually group Combined ICD10 codes. Ttenbergen 21:25, 2018 April 2 (CDT)
• updated s_dispo table
  • inactivated VIC_S5, VIC_N5, VIC_S4, VIC_S3, and VIC_N4

2018-03-22

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

• changed L_CCI_Picklist subform dropdown to sort first by catgory, then by description, making it alphabetical. Was sorted by code but that made no sense Ttenbergen 17:46, 2018 March 22 (CDT)
• added 1.LZ.35.HH-C6 Total parenteral nutrition (TPN) to s_CCI_Picklist table
• in s_ICD10 table fixed spelling for
  • Raynaud's syndrome/phenomenon Ttenbergen 18:42, 2018 March 22 (CDT)
  • Breast, inflammatory or infectious disorder of breast Ttenbergen 19:44, 2018 March 22 (CDT)
  • Klebsiella species - this one now is all species of ...

2018-03-20

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

• s_AllDiagnoses table; removed:
  • Pneumothorax generic 1100, should use specific
  • Pneumothorax iatrogenic 1101, should use Pneumothorax (iatrogenic)
  • old code 98090, should use Pneumothorax (iatrogenic)
  • Hemothorax generic 1000; should use specific
  • Hemothorax iatrogenic 10101, should use Hemothorax (iatrogenic)
• s_dispo table;
  • disabled generic Interventional Radiology
  • added HSC - Interventional Radiology
  • added STB - Interventional Radiology
• Patient viewer - updated tab order

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)

• updated s_dispo table
  • to allow GRA_CAU as Dispo
  • set acuity_level to NULL rather than 0 for HSC Cardiac cath Lab and STB Cardiac cath Lab; this was causing a warning for patients with dispo = cath lab and no Transfer Ready DtTm

2018-03-07

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

• added dxs as decided at task meeting:
  • Infectious organism, unknown
  • Stenotrophomonas species
  • Citrobacter species
  • Enterobacter species
  • Acinetobacter species
  • Kidney, acute renal failure, postprocedural
• updated L_CCI_Component_subform, component 2 wasn't working right.

2018-03-05

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

• fixed CCI links to wiki
• fixed dropdowns on CCI tab to look for "Category" instead of "TDI" since we now have more than T, D, and I
• updated the L_CCI_Component subform and L_CCI_Picklist subform to get rid of some bugs.

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:
  • L CCI Picklist subform
  • L CCI Component subform
• 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)

• fixes to cross check for Accept Loc Park; include Pre-admit Inpatient Institution = "NA / not applicable":
  • query s_tmp_Accept_Log_Park_prev_no_tmp
  • query s_tmp_Accept_Log_Park_tmp_no_prev

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)

• added "negative" for Influenza tracking
• Implemented as query check_ER_Delay_not_too_big.ER Delay

2018-01-09

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

• Added Awaiting Codes:
  • Awaiting/delayed transfer to home
  • Awaiting/delayed transfer to long-term care/PCH
  • Awaiting/delayed transfer to other acute care facility
  • Awaiting/delayed transfer to transitional care facility

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)