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

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)