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-Jun-06

rolled Ttenbergen 16:46, 2016 June 6 (CDT)

• changed tmp tab to help organize ACP Status collection in ICU: sort by integer first, before sorting by other fields. This would become messy if we use the integer for something else in the future but should work nice for now. Ttenbergen 10:28, 2016 June 6 (CDT)
• added check to ensure paired records for ACP Status collection in ICU. Ttenbergen 10:50, 2016 June 6 (CDT)
• added button to make Previous Location field equal to Pre-admit Inpatient Institution field. Ttenbergen 11:57, 2016 June 6 (CDT)
• added query check_dispo_lower_acuity_than_location and Function Transfer_Ready_DtTm_vs_Location_vs_Dispo to cross check for allowed missing Transfer_Ready_DtTm_field but to launch question window if missing Ttenbergen 14:13, 2016 June 6 (CDT)

2016-Jun-02

rolled out Ttenbergen 17:31, 2016 June 2 (CDT)

• changed GRA_W3 to GRA_S3 to table s_tmp_er_wait_r_locations Ttenbergen 09:51, 2016 June 2 (CDT)
• disabled check for Visit Admit DtTm field in Function Dispo_Chronological(); the content of the field is direct copy from EPR so might be inconsistent with actual arrival and/or accept times Ttenbergen 09:56, 2016 June 2 (CDT)
• apostrophe checker for tmp notes was not giving proper error message, does now. Ttenbergen 10:05, 2016 June 2 (CDT)
• confirmed that all ERs are not available in dropdown for Dispo field. Ttenbergen 11:14, 2016 June 2 (CDT)
• updated query Send_Centralized_1L_Log_update, which was not updating Dispo_DtTm field properly Ttenbergen 13:48, 2016 June 2 (CDT)

2016-May-27

rolled Ttenbergen 10:04, 2016 May 27 (CDT)

• fixed new GRA_S3, wasn't visible. Ttenbergen 10:04, 2016 May 27 (CDT)

2016-May-26-2

rolled Ttenbergen 17:54, 2016 May 26 (CDT)

• LongLOS for Dispo
  • added fields to s_dispo table: meanLOS3STD and workshare_real Ttenbergen 17:04, 2016 May 26 (CDT)
  • created new code in Function long_LOS() to check the new dispo fields Ttenbergen 17:04, 2016 May 26 (CDT)

2016-May-26

rolled Ttenbergen 13:38, 2016 May 26 (CDT)

• GRA W3 -> GRA_S3 changes: Ttenbergen 13:01, 2016 May 26 (CDT)
  • s_dispo added
  • s_locations added
  • s_varOptions added
• updated s_dispo table to cope with workload shared locations; removed the _a locations from previous inpatient location dropdown. Ttenbergen 09:55, 2016 May 26 (CDT)
• internal cross check review
  • made Dispo_Yellower use same method as View_Yellower. Ttenbergen 10:18, 2016 May 26 (CDT)
  • changed ADL_Yellower to use same method as View_Yellower. Ttenbergen 10:18, 2016 May 26 (CDT)
• implemented Dispo Chronological‎‎ Ttenbergen 13:35, 2016 May 26 (CDT)

2016-May-25-2

rolled out Ttenbergen 13:08, 2016 May 25 (CDT)

• fixed s_dispo table and s_locations_allowed_collection to allow collection of HSC CCU Ttenbergen 12:57, 2016 May 25 (CDT)

2016-May-25

rolled Ttenbergen 11:42, 2016 May 25 (CDT)

• updated s_dispo table to cope with workload shared locations. Ttenbergen 11:13, 2016 May 25 (CDT)
• updated s_locations_allowed_collection table to allow for sorting "usual" to top Ttenbergen 11:28, 2016 May 25 (CDT)
• updated query s_serviceLocation_local to new sorting; I entered what I thought would be right but if you'd like a different sorting for your location please comment at s_locations_allowed_collection. Ttenbergen 11:36, 2016 May 25 (CDT)
• added HSC_B3S to s_dispo table Ttenbergen 11:40, 2016 May 25 (CDT)

2016-May-20

rolled Ttenbergen 10:09, 2016 May 20 (CDT)

• fix for Service/Location field empty Ttenbergen 09:52, 2016 May 20 (CDT)
• fix for s_dispo table to populate location_name properly for new rural OR and RR entries Ttenbergen 10:09, 2016 May 20 (CDT)

2016-May-19

rolled out Ttenbergen 14:37, 2016 May 19 (CDT)

• updated the ACP Status collection in ICU entry for Orders so that only the "enter" one is automatically populated. Ttenbergen 10:28, 2016 May 19 (CDT)
• added OR and RR to out-of-town s_dispo entries Ttenbergen 11:04, 2016 May 19 (CDT)
• removed "?" button from Service/Location field, since it will only be allowed local entries, so list will be short Ttenbergen 11:04, 2016 May 19 (CDT)
• updated dropdown for Service/Location field to only show options allowed for this laptop based on the settings. Ttenbergen 11:07, 2016 May 19 (CDT)

2016-May-11

rolled Ttenbergen 17:35, 2016 May 16 (CDT)

• changed "urologic" to "urology" in s_previous_service table Ttenbergen 09:52, 2016 May 11 (CDT)
• updated patient view to have the following entries fill the available height on the laptop screens that are now larger than when the program was initially designed. Ttenbergen 13:58, 2016 May 16 (CDT)
  • dx
  • como
  • labs
  • tmp
  • pharm
• removed all ERs from being options in Dispo field
• added HSC_EMIP Ttenbergen 14:59, 2016 May 16 (CDT)

2016-May-09

rolled Ttenbergen 17:38, 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
  • made the old options with begin and end unavailable Ttenbergen 14:10, 2016 May 9 (CDT)

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)