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-May-09

not rolled yet Ttenbergen 10:28, 2016 May 9 (CDT)

• added location to MR List Ttenbergen 10:39, 2016 May 9 (CDT)
• ACP Status collection in ICU: updated query s_tmp_ACP to only trigger if [[Arrive DtTm field] >= 2016-05-01

2016-May-06

rolled Ttenbergen 09:14, 2016 May 6 (CDT)

• correction to sending changes from yesterday Ttenbergen 09:14, 2016 May 6 (CDT)

2016-May-05

rolled out Ttenbergen 17:19, 2016 May 5 (CDT)

• adding cross checks for 2016 Time and Place changes Ttenbergen 15:12, 2016 May 5 (CDT)
  • made fields mandatory not empty to check registry checkbox complete Ttenbergen 15:12, 2016 May 5 (CDT)
  • made Transfer_Ready_DtTm_vs_status() to check Transfer Ready DtTm field against TR info status field Ttenbergen 15:12, 2016 May 5 (CDT)
  • Postal_Code_field#CCDMB_Data_Integrity_Checks Ttenbergen 15:34, 2016 May 5 (CDT)
• added TR_info_status field to sending, changed queries
  • send_Centralized_1L_Log__intermediate
  • Send_Centralized_1L_Log_append
  • Send_Centralized_1L_Log_update

2016-May-04

rolled out Ttenbergen 16:36, 2016 May 4 (CDT)

• ACP_Status_collection_in_ICU#CCDMB_Data_Integrity_Checks Ttenbergen 16:07, 2016 May 4 (CDT)

2016-May-03

rolled Ttenbergen 12:14, 2016 May 3 (CDT)

• changed dropdown for Previous Service field
  • "direct admit" taken out, the new structure does not need it Ttenbergen 10:47, 2016 May 3 (CDT)
  • added "Neurology" and "Oncology"
• added fields for ACP Status collection in ICU Ttenbergen 12:11, 2016 May 3 (CDT)

2016-Apr-25

rolled Ttenbergen 19:10, 2016 April 28 (CDT)

• s_dispo table:
  • made sure that all the PCH entries are not available as Pre-admit Inpatient Institution field; confirmed with Allan Garland that these are not inpatient situations. Ttenbergen 09:25, 2016 April 27 (CDT)
  • simplified and shortened some names as discussed with Julie, Trish and Laura Ttenbergen 16:05, 2016 April 27 (CDT)
  • inactivated a buncha wards as we don't collect on, thanks for the heads-up Laura
• s_previous_service table - added "critical care" for completeness Ttenbergen 17:03, 2016 April 27 (CDT)
• added TR info status field Ttenbergen 19:05, 2016 April 28 (CDT)
• changed code to cope with CCMDB_data.mdb_Change_Log#2016-04-28 Ttenbergen 19:05, 2016 April 28 (CDT)

2016-Apr-25

rolled Ttenbergen 19:59, 2016 April 25 (CDT)

• updated Dispo tab layout; some labels had got separated from their fields. Ttenbergen 17:28, 2016 April 25 (CDT)
• updated s_dispo table:
  • HSC Nursing Home Ward: entry for "HSC Nursing Home" to not mention (GG7) any longer. Ttenbergen 18:08, 2016 April 25 (CDT)
  • shortened hospital names (town only or town/name where applicable) Ttenbergen 18:59, 2016 April 25 (CDT)
  • changed gra_w3 to gra_s3 Ttenbergen 19:59, 2016 April 25 (CDT)
• added 2016 Time and Place changes fields to sending
  • updated query send_Centralized_1L_Log__intermediate Ttenbergen 19:14, 2016 April 25 (CDT)
  • updated query Send_Centralized_1L_Log_update Ttenbergen 19:30, 2016 April 25 (CDT)
  • updated query Send_Centralized_1L_Log_append Ttenbergen 19:30, 2016 April 25 (CDT)

2016-Apr-18

rolled Ttenbergen 19:26, 2016 April 18 (CDT)

• Added "N/A" button for Postal Code field‎ Ttenbergen 16:31, 2016 April 18 (CDT)
• changed "left AMA" to "AMA (left against medical advice)" so it pops up if collector starts typing "AMA" Ttenbergen 16:31, 2016 April 18 (CDT)
• added filter to fields in S dispo chooser to only show the entries actually allowed for the field that started the form (e.g. no "died" in previous location) Ttenbergen 18:28, 2016 April 18 (CDT)
• updated sub Convert_DB() to download CCMDB_data.mdb_Change_Log#2016-04-18 Ttenbergen 18:48, 2016 April 18 (CDT)
• added Visit Admit DtTm field in dispo tab Ttenbergen 19:02, 2016 April 18 (CDT)
• added "Manitoba PCH outside of Winnipeg" and "Winnipeg PCH" to s_dispo table Ttenbergen 19:14, 2016 April 18 (CDT)

2016-Apr-14 (shows as 2016-Apr-13)

rolled Ttenbergen 17:56, 2016 April 14 (CDT)

• took "HSC" out of default settings for form s_dispo_chooser Ttenbergen 12:27, 2016 April 14 (CDT)
• added STB_EMIP to s_dispo table Ttenbergen 14:47, 2016 April 14 (CDT)
• wiggled query send_check_centralized_is_owner but nothing got changed. Even though, re-saving it seems to have fixed an issue Pagasa had re-sending dome data. Ttenbergen 15:44, 2016 April 14 (CDT)

2016-Apr-13

rolled Ttenbergen 16:32, 2016 April 13 (CDT)

• changed the "magic" buttons on the Dispo tab to "?" buttons to be consistent with the buttons used in the diagnosis tab; there the "?" button opens the filter and the "magic want" button re-sorts the list. Ttenbergen 14:57, 2016 April 13 (CDT)
• changed hover-overs for these buttons to say "open filter wizard" Ttenbergen 14:57, 2016 April 13 (CDT)
• added hints to Dispo field: died and AMA Ttenbergen 14:57, 2016 April 13 (CDT)
• added button to set Accept_DtTm field to Arrive_DtTm field for convenience since they are often the same. Ttenbergen 15:46, 2016 April 13 (CDT)
• updated validation for DOB, it would not error properly when empty in some circumstances. Ttenbergen 15:59, 2016 April 13 (CDT)

2016-Apr-11

rolled Ttenbergen 18:24, 2016 April 11 (CDT)

• fixed Patient List form sorting button for Last Opened field, had not been working Ttenbergen 15:40, 2016 April 11 (CDT)
• changed tab order to Pre-acute Living Situation -> Postal Code -> Pre-Admit Inpatient Institution (if applicable) -> Previous Location, then DtTm -> Previous Service with DtTm next -> Service Location -> Transfer Ready DtTm -> Dispo DtTm -> Dispo Ttenbergen 15:43, 2016 April 11 (CDT)

2016-Apr-07-2

rolled earlier today Ttenbergen 15:40, 2016 April 11 (CDT)

• deleted old tmp tables starting with 1_ and old queries 1_tmp_* - Ttenbergen 15:32, 2016 April 7 (CDT)
• deleted old query "Check_Como_UniquePriority" Ttenbergen 15:41, 2016 April 7 (CDT)
• removed the code that moved cursor to start of Transfer_Ready_DtTm field Ttenbergen 13:53, 2016 April 11 (CDT)

2016-Apr-07

rolled out Ttenbergen 12:19, 2016 April 7 (CDT)

• changed the sort order of Previous Service field drop down but only did after roll-out, will go out with next. Ttenbergen 10:04, 2016 April 5 (CDT)
• fixed +/- buttons for Dispo DtTm field - thanks Con for flagging! Ttenbergen 12:19, 2016 April 7 (CDT)
• updated input mask for Transfer Ready DtTm field, it wasn't allowing typed entry - thanks Con for flagging! Ttenbergen 12:19, 2016 April 7 (CDT)
• There are still editing difficulties - see there for details on a new thing to try. Ttenbergen 12:19, 2016 April 7 (CDT)

2016-Apr-05

rolled Ttenbergen 09:55, 2016 April 5 (CDT)

• changed when time is written to Last Opened field, previous version hung up when other changes to the data were also madeTtenbergen 10:04, 2016 April 5 (CDT)
• fixed hover hint for the close with and without update buttons, it had been opposite of what button said Ttenbergen 10:04, 2016 April 5 (CDT)
• changes sort order for pre-admit inpatient location Ttenbergen 10:04, 2016 April 5 (CDT)

2016-Apr-04-2

rolled Ttenbergen 14:58, 2016 April 4 (CDT)

• Last Opened field - removed automated update when opening file and added a "reviewed" button in Patient Viewer instead - Ttenbergen 13:24, 2016 April 4 (CDT)
  • Collectors: I have disabled the "x" button for this form, you will now have to use either the close with or without changes buttons. Ttenbergen 14:56, 2016 April 4 (CDT)
• some additional clean-up in patient viewer module that should have no impact, just cleaned out dead code Ttenbergen 13:24, 2016 April 4 (CDT)
• date/time fields in 2016 Time and Place changes - changed so they should be properly editable now, please see article, try and let me know how goes in the article at the link Ttenbergen 14:56, 2016 April 4 (CDT)

2016-Apr-04

rolled Ttenbergen 12:00, 2016 April 4 (CDT)

• added option "CICU" for CCU Service Tracking, see change in collection instruction on that page - Ttenbergen 11:41, 2016 April 4 (CDT)
  • added option to s_tmp table - Ttenbergen 11:41, 2016 April 4 (CDT)
  • updated query s_tmp_CCU_Service_shouldntve to allow STB_CICU to enter - Ttenbergen 11:41, 2016 April 4 (CDT)

2016-Mar-31

rolled Ttenbergen 11:45, 2016 March 31 (CDT)

• made "home" available in s_dispo table, it had unintentionally become inactive Ttenbergen 11:16, 2016 March 31 (CDT)
• Project_ABO_TEE#CCDMB_Data_Integrity_Checks - updated cross check to only trigger when RecordStatus complete Ttenbergen 11:16, 2016 March 31 (CDT)

2016-Mar-24

rolled Ttenbergen 19:35, 2016 March 25 (CDT) before rolling, fix db converter break

• Alias ID collection - added required entry to s_tmp table
• more 2016 Time and Place changes
  • 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)
  • 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)
  • 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)
  • added button to open S dispo chooser to Pre-admit Inpatient Institution field button, had missed that on first round Ttenbergen 21:46, 2016 March 24 (CDT)

• Project ABO TEE cross checks: reviewed query s_tmp_ABO_TEE_checks
• Medical Incompetency tracking - was still available to collect, made unavailable Ttenbergen 18:18, 2016 March 25 (CDT)

2016-Mar-21

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