CCMDB.mdb Change Log 2017

From CCMDB Wiki
Revision as of 10:55, 2019 March 21 by Ttenbergen (talk | contribs) (→‎2017-10-14: those were removed at some point so removing links)
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. 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

2017-12-20

rolled out Ttenbergen 17:11, 2017 December 21 (CST)

  • update to form CCI Chooser to accept the "pick" button on first click.
  • added project Influenza treated to s_tmp table. Ttenbergen 16:47, 2017 December 21 (CST)

2017-12-13-5

rolled out. Ttenbergen 14:12, 2017 December 19 (CST)

  • Changing the Clinical Assessment Units to be loc_type ward instead of ER. Ttenbergen 13:55, 2017 December 13 (CST)
  • updated L_CCI subform, second line dropdown was not showing right when re-opening form.
  • updated Regional Server path to "\\ad.wrha.mb.ca\wrha\REGION\Shared\ICU_DATA_COLLECTION\", then reverted that because trust relationship is against old path.

2017-12-13-4

rolled out Ttenbergen 09:03, 2017 December 13 (CST)

Removed as discussed in Check ORDx:

  • table Check_ORDx
  • query Check_ORDx__from_OR_no_ORDx
  • query Check_ORDx__not_from_OR_OrDx

Updated

  • form Diags

2017-12-13-3

Rolled out Ttenbergen 08:28, 2017 December 13 (CST) updated queries to omit the old date and location stuff deleted in most recent version.

  • Primary_admit

Disabled queries as discussed in Check ORDx:

  • Check_ORDx__from_OR_no_ORDx
  • Check_ORDx__not_from_OR_OrDx

2017-12-13-2

rolled out to everyone. Ttenbergen 07:52, 2017 December 13 (CST)

  • updated query check_brr... to omit the old date and location stuff deleted in most recent version.

2017-12-13

rolled. CMarks 07:31, 2017 December 13 (CST)

2017-12-07-3

not rolled yet Ttenbergen 13:20, 2017 December 7 (CST)

  • ER Delay cross checks:
    • added query check_ER_Delay_not_too_big
    • updated Function Dispo_Chronological() to use the query to give warning when checking complete box
  • L_ICD10 subform - changed the sorting for diagnosis dropdown to list alphabetically rather than by ICD10 code. Ttenbergen 11:55, 2017 December 8 (CST)
  • removed a bunch of old locations/times stuff from module Converters:
    • AdDt_combined()
    • DisDt_combined()
    • TrDt_combined()
    • previous_hospital()
    • location()
    • AdFrom()
    • disto()
    • Function stupid_date()
  • removed a bunch of old locations/times stuff from module CheckForms:
    • Hosp_Previous_Current()
  • updated ApScr_age_caller() to use new

2017-12-07-2

rolled out Ttenbergen 13:58, 2017 December 7 (CST)

2017-12-07

rolled out Ttenbergen 13:20, 2017 December 7 (CST)

  • correction to tmp cross checks that went wrong in last update Ttenbergen 13:20, 2017 December 7 (CST)

2017-12-06

rolled out Ttenbergen 13:04, 2017 December 7 (CST)

2017-11-30

rolled out Ttenbergen 17:56, 2017 December 6 (CST)

  • in s_dispo table
    • STB ER(direct) changed from being listed as OAK to STB
    • VIC_ER set to inactive; emailed VIC ladies to make sure this won't cause a problem
  • fixed ICD10 dropdown in ICD10 tab, somehow had got locked, should work now. Ttenbergen 19:15, 2017 December 5 (CST)
  • updated L_CCI subform: added +, -, * buttons for Px_Date
  • updated L_ICD10 subform:
  • updated L_ICD10 table: added columns Dx_Date_unknown, Dx Primary
  • s_ICD10 table
    • removed category columns and some others we won't be using that way
    • imported new content from wiki
  • ACCU borrow cross checks:
    • s_tmp_ACCU_Borrow_chronicity_hard
    • s_tmp_ACCU_Borrow_2_hr_soft
    • s_tmp_ACCU_off_ward
    • s_tmp_ACCU_twin
  • Labs removal
    • updated forms L_Labs_Flowsheet and L_Labs_Flowsheet_sum to remove labs no longer done manually. Ttenbergen 17:31, 2017 December 6 (CST)

2017-11-28

rolled out TTenbergen 16:58, 2017 November 28 (CST)

  • updated L_CCI subform
    • fixed dropdowns for CCI2 and CCI3 so they contain relevant sub-lists based on CCI1; set up before but was not working right
      • tweaked further so they contain all entries again once the record worked on goes out of focus
    • removed the T/D/I dropdown because it was hiding previously entered items of a different-than-current T/D/I. It now lives in CCI Chooser form
    • added "sort alphabetical" and "sort date" buttons
  • added T/D/I dropdown and filter to CCI Chooser form

2017-11-25

rolled out Ttenbergen 18:19, 2017 November 26 (CST)

  • updated L_CCI subform
    • changed sorting and filtering in dropdowns
    • added dropdown to filter first list to T, D, I
    • made L_CCI_subform#Duplicator (the "2x" button) to twin the current record, for repeat procedures, so only the date would need to be entered
    • made L_CCI_subform#Picklist (the "P" button) functionality
  • added S CCI Picklist table
  • updated ICD10 Chooser form
    • items on list are now links to the corresponding wiki articles

2017-11-20

rolled out Ttenbergen 16:36, 2017 November 20 (CST)

  • in s_dispo table, changed VIC_S3 to be available again; we still have patients who were admitted from there, even if all patients admitted to there are gone. Ttenbergen 16:29, 2017 November 20 (CST)
  • Notes field: corrected a much earlier fix to guard against a bug when there is too much text in Notes. Ttenbergen 16:29, 2017 November 20 (CST)

2017-11-13

rolled out Ttenbergen 17:41, 2017 November 15 (CST)

2017-11-08-3

rolled Ttenbergen 10:45, 2017 November 9 (CST)

2017-11-08-2

rolled out Ttenbergen 16:10, 2017 November 8 (CST)

2017-11-08

rolled out Ttenbergen 11:42, 2017 November 8 (CST)

  • in s_dispo table:
    • updated names of the CAUs from * - CAU to *_CAU to be consistent with other inpatient locations
    • edited VIC_N5C and VIC_N5C to have service type SubAcute, as discussed with Julie

2017-11-07

rolled out Ttenbergen 08:59, 2017 November 7 (CST) tweak to a dx window problem that snuck in with changes to CID10 window

2017-11-06

rolled out

2017-10-25-2

Rolled out Ttenbergen 16:01, 2017 November 6 (CST)

  • updated the interface for entering ICD10 codes to search a little more similar to current dx coding.
  • imported a first round of the s_ICD10 table
  • in s_dispo table
    • inactivated VIC_S3 and VIC_S4
    • inactivated HSC Nursing Home Ward Ttenbergen 22:03, 2017 October 31 (CDT)
    • added program "Med" to HSC_H6 and HSC_EMIP
    • changed names for *_ER (CAU) to *_CAU (CAU)

2017-10-25

rolled Ttenbergen 11:49, 2017 October 25 (CDT)

  • added VIC_N4C to old VIC MICU dropdown.

2017-10-14

rolled out Ttenbergen 20:39, 2017 October 23 (CDT)

2017-10-10-2

rolled out Ttenbergen 17:38, 2017 October 12 (CDT)

2017-10-10

rolled out Ttenbergen 13:19, 2017 October 10 (CDT)

2017-09-20

rolled out Ttenbergen 17:37, 2017 September 20 (CDT)

  • added to s_dispo table:
    • VIC urgent care
    • OAK urgent care (inactive for now)
    • CON urgent care (inactive for now)
  • ICD10:
    • added No procedure entered to s_CCI table to prevent null errors
    • added No Dx Entered to s_ICD10 table to prevent null errors
    • updated the forms to link the data properly to the patient, before all data would have showed for all patients.

2017-09-14

rolled out Ttenbergen 21:19, 2017 September 18 (CDT)

  • grammar change in emails for red overstay patients.
  • deleted tables S tmp er wait r locations which should no longer be used by anything. There are others I should clean out but worried about scope creep here tonight... Ttenbergen 22:39, 2017 September 14 (CDT)
  • added to s_dispo table and s_locations_allowed_collection table table
  • changed tmp entry for QA Infection CLI to say just "Central Line Infection" again as it did originally; removed the Basil instructions because we will do it differently now and don't want to have to change the option each time we change instructions. see QA Infection CLI and QA Infection VAP for collection instruction change.
  • ICD10/CCI

2017-08-24

rolled out Ttenbergen 17:27, 2017 August 24 (CDT)

2017-08-03

rolled out Ttenbergen 09:31, 2017 August 3 (CDT) Somehow 2017-08-01 got overwritten on server, re-doing changes

2017-08-01

rolled out from Con's desk CMarks 13:50, 2017 August 1 (CDT)

2017-07-31

rolled out Ttenbergen 09:58, 2017 July 31 (CDT)

  • tmp check for overstay,
    • update query check_overstay_not_entered
    • deleted query check_overstay_still_has_enter_line Ttenbergen 09:58, 2017 July 31 (CDT)
    • updated query check_overstay_no_colour_not_transferred into query check_overstay_no_colour and removed the transferred check, done differently now. Ttenbergen 09:58, 2017 July 31 (CDT)

2017-Jul-29

Rolled out Ttenbergen 01:03, 2017 July 30 (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
    • excluded DPST info from colour generation
      • disabled code that used to check DPST entries
  • eliminated auto-entries for DPST in tmp
  • 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 comments in s_tmp table (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)

2017-Mar-14

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

2017-Mar-02

rolled out 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)

2017-Jan-23

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

2017-Jan-16

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

2017-Jan-05

rolled out 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)