CCMDB.mdb Change Log 2017

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

• ubernext
  • had look at [[1]] but have questions.

• review service cross check fixes; apparently STB can't enter service "from ER" when pt arrives from Emerg.

2017-Jul-29

• changes to S AllDiagnoses
  • added Medical Assistance In Dying Ttenbergen 21:13, 2017 July 29 (CDT)
  • changed wording for and to Necrotizing soft tissue infections (necrotizing fasciitis, myonecrosis, gas or clostridial gangrene etc.)Ttenbergen 21:41, 2017 July 29 (CDT)
• fix hyperlinks to First Name and Last Name wiki articles from patient list. Ttenbergen 21:41, 2017 July 29 (CDT)

• Overstay Predictor Project Collection Instructions changes:
  • Found way to email from CCMDB even when offline
• changed colour generator
  • make gray if comes from medicine ward at same site where we collect
    • added query check_overstay_pt_from_our_med
  • excluded DPST info from colour generation
    • disabled code that used to check DPST entries
• eliminated auto-entries for DPST in tmp
  • unchecked auto-entry in s_tmp table
• implement manager notification
  • moved Sub CreateMail to module Global_
  • added call to CreateMail when red

2017-06-28-3

rolled out CMarks 15:24, 2017 June 28 (CDT)

• tab order re-fix, last did not work. CMarks 15:24, 2017 June 28 (CDT)

2017-06-28-2

rolled out Ttenbergen 12:50, 2017 June 28 (CDT)

• tweaked tab order so it goes from "record" field to "notes" field. Ttenbergen 12:50, 2017 June 28 (CDT)

2017-06-28

rolled out Ttenbergen 12:18, 2017 June 28 (CDT)

• tweaked dx tab so it behaves better when screen is not fully wide enough. Ttenbergen 12:18, 2017 June 28 (CDT)

2017-06-27

rolled out Ttenbergen 10:44, 2017 June 27 (CDT)

• made form components wider to make use of screens that have higher resolution these days:
  • dxs
  • comos
  • tmp
• added not to labs tab to only collect old labs for patients started before we stopped.

2017-06-05-2

rolled out Ttenbergen 16:11, 2017 June 20 (CDT)

• added province and Postal code to tab order on Dispo tab Ttenbergen 13:29, 2017 June 5 (CDT)
• removed s_VarNames table and s_varOptions table as part of ongoing clean-up from pre-centralized collection Ttenbergen 13:53, 2017 June 6 (CDT)
• added VBG to tab order in Labs tab. Ttenbergen 16:11, 2017 June 20 (CDT)

2017-06-05

rolled out - Ttenbergen 12:41, 2017 June 5 (CDT)

• updated s_dispo table for Children's - ICU and STB_5B_x as per request from Julie; this should only affect her reports. Ttenbergen 12:41, 2017 June 5 (CDT)
• updated Labs form so the VBG total lists properly. Ttenbergen 12:41, 2017 June 5 (CDT)

2017-05-10

rolled out. Ttenbergen 14:01, 2017 May 18 (CDT)

• no changes yet (reverted some I started on because I was down the wrong track)
• updated the labs sum form so the columns line up with the columns in the labs form; they had not since I added whitespace in the labs form ages ago. Surprised no one told me about this. Ttenbergen 13:46, 2017 May 18 (CDT)

2017-May-07

rolled out Ttenbergen 09:48, 2017 May 10 (CDT)

• update to s_FIO2 table as per discussion in FiO2: added entry for flush for 15L ie 70% Ttenbergen 15:37, 2017 May 7 (CDT)

2017-Apr-28

rolled Ttenbergen 09:37, 2017 April 28 (CDT)

• updated query s_tmp_apostrophe_in_comment to fix check for apostrophes

2017-Apr-27

rolled Ttenbergen 16:38, 2017 April 27 (CDT)

• updated send functionality to properly check for apostrophes in tmp comments (they mess with Julie's data and are not allowed)
  • added query s_tmp_apostrophe_in_comment to do this

2017-Apr-25

not rolled out Ttenbergen 10:37, 2017 April 25 (CDT)

• update s_tmp table
  • set to true MCHP column as requested by Julie in email. Ttenbergen 10:37, 2017 April 25 (CDT)
  • deleted old entries that have no corresponding entries in L_TmpV2 Ttenbergen 10:37, 2017 April 25 (CDT)
    • "ABO TEE_" became "A_T*"
    • "ACP Status*" became "ACP*"
    • "DeviceUse" - DeviceUse Study no data for...

2017-Apr-12

rolled out Ttenbergen 09:28, 2017 April 12 (CDT)

• updated CRRT entry for Form Missing' or 'Form not done' to ask to call Ryan (s_tmp table).

2017-Apr-11-2

rolled out Ttenbergen 16:43, 2017 April 11 (CDT)

• updated the s_dispo table to not allow HSC_EMIP_a-d as previous location. Should not have been allowed before, just correcting. Ttenbergen 16:43, 2017 April 11 (CDT)
• added "MCHP" column to s_tmp table. Ttenbergen 16:48, 2017 April 11 (CDT)

2017-Apr-11

rolled out Ttenbergen 15:34, 2017 April 11 (CDT)

• added the label "rank" to int_var for all CRRT entries. See change to collection instructions at CRRT. Ttenbergen 15:34, 2017 April 11 (CDT)

2017-Apr-05

rolled out Ttenbergen 01:56, 2017 April 5 (CDT)

• made visible again on the labs tab the labs that will now come from Category:DSM Labs Extract, and Angio coronary field and Angio others field Ttenbergen 14:36, 2017 April 3 (CDT)

2017-Mar-14

rolled out Ttenbergen 14:51, 2017 April 3 (CDT)

• working on allowing no labs - no change was required for this, since the instruction of entering one line of "nothing" still applies even if we no longer count those labs.
• made invisible on the labs tab the labs that will now come from Category:DSM Labs Extract, and Angio coronary field and Angio others field Ttenbergen 14:36, 2017 April 3 (CDT)
• updated Check_ORDx table to no longer make AAA Repair, AVR Repair/Replace and TAA Repair require an OR as these are now often done in the cath lab Ttenbergen 14:06, 2017 April 3 (CDT)
• we will stop using Aspiration (early presentation, documented aspiration) (see article for details); made inactive in the Table S Pathogens. Ttenbergen 14:42, 2017 April 3 (CDT)

2017-Mar-02

rolled out Ttenbergen 13:58, 2017 March 2 (CST)

• re-enabled the dropdowns for QA Septic Shock in s_tmp table Ttenbergen 13:58, 2017 March 2 (CST)

2017-Feb-07

rolled out Ttenbergen 17:48, 2017 February 7 (CST)

• updated structure of S_Tmp table to make "order" into a single (real) rather than byte (integer) so sorting can include decimal point changes rather than updating everything lower in the list.- Ttenbergen 17:46, 2017 February 7 (CST)
• updated s_tmp table to accommodate dropdown changes for AcceptDateSource- Ttenbergen 17:46, 2017 February 7 (CST)

2017-Jan-30

Rolled out Haubel 12:21, 2017 January 30 (CST)

• DB_converter updated to the new version of ccmdb_data.mdb (2017-01-30)

2017-Jan-25

rolled out Ttenbergen 11:22, 2017 January 25 (CST)

• adding entries for AcceptDateSource to S Tmp table Ttenbergen 11:22, 2017 January 25 (CST)

2017-Jan-23

Rolled out Haubel 16:38, 2017 January 23 (CST)

• Broken hyperlink for ARF (APACHE) fixed

2017-Jan-16

Rolled out Haubel 14:08, 2017 January 16 (CST)

• Format for "generate email" button
  • Time format changed to match the way it is displayed on the patient viewer form. (24 hour format)

2017-Jan-05

rolled out Ttenbergen 08:24, 2017 January 9 (CST)

• removed requirement to fill in ACP Status collection in ICU Ttenbergen 08:24, 2017 January 9 (CST)

2017-Jan-05

rolled out Ttenbergen 13:38, 2017 January 5 (CST)

• removed BirthMY from sending, updated
  • Send_Centralized_1L_Log_update
  • Send_Centralized_1L_Log_append
  • send_Centralized_1L_Log__intermediate
• removed reference that causes MSCOMCT2.ocx error: removed reference to MSCOMCTL.ocx. I can't remember why we needed it, and it didn't give a compile error when I removed it. Ttenbergen 13:19, 2017 January 5 (CST)
• inactivated s_tmp table entries for ACP Status collection in ICU Ttenbergen 13:12, 2017 January 5 (CST)