CCMDB.mdb Change Log 2016

From CCMDB Wiki
Revision as of 20:10, 2016 March 24 by Ttenbergen (talk | contribs) (→‎2016-Mar-24: log)
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

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-24

not rolled yet Ttenbergen 11:26, 2016 March 24 (CDT) before rolling, fix db converter break

  • Alias ID collection - added required entry to s_tmp table
  • more 2016 Time and Place changes
    • changed Previous Service field to say "not on our list", "not" was missing
    • added in Transfer Ready DtTm field Ttenbergen 14:58, 2016 March 24 (CDT)
    • updated DtTm fields to not show or require seconds Ttenbergen 14:58, 2016 March 24 (CDT)
    • added input masks to the dates so you don't need to enter the ":" and such Ttenbergen 20:05, 2016 March 24 (CDT)
    • changed the labels for all the fields on the dispo tab to hyperlinks to the wiki, ie you can click the label and it will take you to the article about the field Ttenbergen 20:39, 2016 March 24 (CDT)
    • updated s_dispo table table so Previous Location field can now contain ERs from rural Manitoba Ttenbergen 20:46, 2016 March 24 (CDT)
    • made label for Last Opened field into link to wiki Ttenbergen 21:10, 2016 March 24 (CDT)

To do

  • more 2016 Time and Place changes
    • update dropdowns so they auto-limit for e.g. death only in dispo
    • outside winnipeg hospital ER the pas --- goes blank
    • make instructions for magic wand button
  • abotee fix re Julie's email
  • CRRT update re. Julie's email

2016-Mar-21

rolled out Ttenbergen 13:51, 2016 March 22 (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)

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)
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.mdb_Change_Log_2016&oldid=47241"