CCMDB.mdb Change Log 2016

see Log (disambiguation) for other uses of the term "Log" see the Development Documentation Category for other development logs

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

2016-Mar-21

not rolled yet Ttenbergen 11:35, 2016 March 21 (CDT)

• 2016 Time and Place changes
  • updating new dispo tab dropdowns
  • reviewed s_pre_acute_living_situation table and linked into form Ttenbergen 11:35, 2016 March 21 (CDT)
  • reviewed s_previous_service table and linked into form Ttenbergen 11:35, 2016 March 21 (CDT)
  • reviewed [[]] and link into forms Ttenbergen 13:42, 2016 March 22 (CDT)
  • updated form s_dispo Chooser and how it is triggered from form Patient viewer Ttenbergen 13:42, 2016 March 22 (CDT)
• added "Nephrology" and "unknown" to S_previous_service_table and s_tmp for Service Sending to ICU Ttenbergen 17:21, 2016 March 21 (CDT)

2016-Mar-16

rolled Ttenbergen 17:44, 2016 March 16 (CDT)

• made Med Var 5 OVZ for collection of OVER available for Medicine at STB Ttenbergen 10:56, 2016 March 16 (CDT)
• fixed ACP_Status_collection_in_ICU#CCDMB_Data_Integrity_Checks
  • added query s_tmp_ACP Ttenbergen 12:17, 2016 March 16 (CDT)
  • added code in s_tmp_ACP to run query Ttenbergen 12:17, 2016 March 16 (CDT)
• Patient Viewer Form
  • Increased size of components to make use of the laptops we have now, these were still small from old laptops Ttenbergen 15:28, 2016 March 16 (CDT)
  • added screen to pilot 2016 Time and Place changes
• ccmdb_data: updated code to pull CCMDB_data.mdb_Change_Log#2016-03-16
• PatientList: added column for LastOpened and code to set it automatically; the column is not manually editable. Ttenbergen 17:39, 2016 March 16 (CDT)

2016-Mar-14-2

not rolled yet Ttenbergen 13:52, 2016 March 14 (CDT)

• Test rolled to STB_CICU and HSC_A4; had unrelated issues with news and backup for both, holding off for now.

• deleted table Pharm_out, not sure what that was even about Ttenbergen 13:52, 2016 March 14 (CDT)
• updated module DB_Converter to accommodate new CCMDB_data.mdb_Change_Log#2016-03-07 Ttenbergen 14:41, 2016 March 14 (CDT)

2016-Mar-14

rolled out Ttenbergen 10:24, 2016 March 14 (CDT)

• updated table S locations allowed collection
  • content:
    • listed the new STB_EMIP properly for all STB Medicine laptops
    • removed entry STB_5B_x
    • removed old STB_B5 laptop entries
  • structure: update fields to be dropdowns based on table S Locations

2016-Mar-07

rolled Ttenbergen 13:38, 2016 March 7 (CST)

• added "STB_EMIP" to table S Locations Ttenbergen 13:38, 2016 March 7 (CST)

2016-Feb-29

rolled out Ttenbergen 16:38, 2016 February 29 (CST)

• WRHA changed policy on VRE, ESBL and MRO Colonization so removed from table S AllDiagnoses the following because we are no longer screening for colonization:
  • 9900 - Colonization with Resistant Organisms (without Infection) with any pathogen
  • 9922 - VRE colonization
  • 9924 - ESBL colonization
• keeping only explicit 9948; since that's last remaining colonization, changing article name to MRSA Colonization (without Infection)

2016-Feb-25

rolled Ttenbergen 15:52, 2016 February 25 (CST)

• added "PEI" to "New Brunswick / Newfoundland / Nova Scotia" in S HospitalCodes table Ttenbergen 15:50, 2016 February 25 (CST)

2016-Feb-17

rolled Ttenbergen 12:24, 2016 February 17 (CST)

• fixed spelling for Friedreich's Ataxia Ttenbergen 12:10, 2016 February 17 (CST)

2016-Feb-08

(this must have been rolled because the version was feb 9 after this...)

• addressing Category:Unusually coded infections:
  • making c-diff pathogen unavailable for coding
    • added "active" column to Table S Pathogens Ttenbergen 14:43, 2016 February 8 (CST)
    • made all except Clostridium difficile active Ttenbergen 14:43, 2016 February 8 (CST)
    • updated the dropdown in the patient view, diagnosis tab, to list only active pathogens Ttenbergen 14:43, 2016 February 8 (CST)
  • discussed coding for Viral Hepatitis and left as is, because it already only allows collection of this in one way, even if that way is inconsistent with other pathogen coding. Ttenbergen 14:52, 2016 February 8 (CST)
  • Meningoencephalitis
    • disabled collection for 7700 with pathogen, has to be collected as explicit dx to prevent invalid combinations Ttenbergen 14:52, 2016 February 8 (CST)

2016-Jan-25

rolled out Ttenbergen 13:00, 2016 February 1 (CST)

• added Medical Incompetency tracking Ttenbergen 16:10, 2016 January 25 (CST)
  • disabled because we are not ready Ttenbergen 12:54, 2016 February 1 (CST)
• added query 's_tmp_ABO_TEE_checks' to implement checks for Project ABO TEE Ttenbergen 12:54, 2016 February 1 (CST)

2016-Jan-21

rolled Ttenbergen 08:49, 2016 January 21 (CST)

• tweak to yesterdays update

2016-Jan-20

rolled Ttenbergen 15:40, 2016 January 20 (CST)

• changed forms to make it impossible to add, delete or edit comos. Thanks to Joanna for making me aware this was not locked out. Ttenbergen 11:53, 2016 January 20 (CST)
  • ComoChooser
  • DxChooser

2016-Jan-11

Rolled out Ttenbergen 22:09, 2016 January 11 (CST)

• added to s_varoptions S5, new psych location for GRA. Ttenbergen 17:19, 2016 January 11 (CST)
• corrected query s_tmp_ER_Wait_long_delay for ER Wait, it was not detecting anything. Collectors will have to put a comment in tmp if the delay is > 3 days. The error msg will remind them about this. Ttenbergen 17:19, 2016 January 11 (CST)
• added query s_tmp_ER_Wait_duplicate_entry - doesn't allow more than one ER Wait entry. Ttenbergen 22:02, 2016 January 11 (CST)
• both ICUd and ICUa laptops accepted the change - Lori

2016-Jan-06

rolled Ttenbergen 13:18, 2016 January 6 (CST)

• updated form dxChooser to exclude dxs with collection_allowed = false Ttenbergen 13:17, 2016 January 6 (CST)