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

• send queries for CCI / ICD10
• L_CCI_Component table
• L_CCI_Picklist table

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)

• updated query check_minimal_data_set_incomplete to omit the old date and location stuff deleted in most recent version. 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)

• Charlson Comorbidities in ICD10 codes infrastructure
  • updated s_ICD10_Charlson_Como_conditions table
  • made s_ICD10_Charlson_Como_patterns table
  • made s_ICD10_Charlson_Comorbids query

• Old Field Cleanup
  • confirming that field is not part of sending any more.
    • Ap SapsSysBP field
    • old fields starting with R_
    • old fields starting with Var
    • L_Dxs table.rank
  • removed from CCMDB_Data.mdb, see CCMDB_data.mdb_Change_Log#2017-Dec-11
• removed the dropdown tables that used to service the removed fields:
  • s_AdmitDischarge table
  • s_HospitalCodes table
  • s_Locations table (no page, not sure why)

• Convert_DB():
  • updated the table translation for L_Log table and L_Dxs table to omit the removed fields
  • added code to add in L_ICD10 table and L_CCI table

• DB_Connect(): updated to add in L_ICD10 table and L_CCI table

• 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)

• in s_dispo table actually changed the ER (Direct) to ER (Parked)

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)

• added Accept Loc Park to s_tmp table
• changed the ER (direct)s to ER (parked) in s_dispo table
• fixed problem with ICD10 "?" button that was caused by latest update

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:
  • added +, -, * buttons for Dx_Date
  • added checkbox for Dx_Date_unknown
  • added checkbox for Dx Primary
• 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)

• added s_CCI_1 table, s_CCI_2 table, s_CCI_3 table
• removed s_CCI table
• updated L_CCI table, added fields CCI_1_ID, CCI_2_ID, CCI_3_ID, removed field CCI_ID
• added query L_CCI_Combined
• updated L CCI subform
• in s_dispo table, removed program "Med" to HSC_H6; should never have been added as per definition of program in s_dispo table
• added form CCI_Chooser

2017-11-08-3

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

• in s_dispo table:
  • changed VIC_S4 to be active again but only as Previous Location
  • changed River Ridge Transition Care Environment,VIC_N4 and VIC_N4C to be "service_type" TC
  • changed River Ridge Transition Care Environment to be loc_type TCE

2017-11-08-2

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

• correction to s_locations_allowed_collection table to make GRA_N5a, GRA_S3a available on Stephanie's laptop

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

• tweak to s_ICD10 table HSC CAU, GRA CAU, STB CAU: made all inpatient=true, temporary=false

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)

• added to S ICD10 table
  • field min_nr_grouped_with to accommodate minimum Combined ICD10 codes
  • field Charlson_condition, links to S ICD10 Charlson Como conditions table
    • removed como_points field, not relevant on its own without condition
• added following tables:
  • S ICD10 Charlson Como conditions table
  • S ICD10 table
  • S ICD10 Blocks table
  • S ICD10 Block Dxs table
• Influenza tracking - added "suspected"
• unchecked in s_dispo table: 'VIC UC(direct)' Previous Location

2017-10-10-2

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

• added Influenza tracking
• added s_dispo table entries for Category:CAU and Direct admit and Parked in ER tmp entry
• edited query check_previous_location_vs_service_inconsistent to allow
  • Previous Service = family medicine when Previous Location medicine ward where we collect.
  • Previous Service = Cardiology when Previous Location STB_ACCU

2017-10-10

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

• in s_dispo table
  • added VIC_N4C (also added to S locations allowed collection table table to enable collection)
  • added River Ridge Transition Care Environment
  • changed center: N5C to 248, S5C to 249
• hid labs that are no longer collected manually; will delete if no problems in a month.

• confirmed
  • VIC_N5C, VIC_S5C, VIC_N4C allowed for Pre-admit Inpatient Institution

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
  • VIC S5C
  • VIC N5C
  • VIC_N4
• 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
  • added tables
    • s_ICD10 table, added some sample data
    • s_CCI table
    • L_ICD10 table, added some sample data
    • L_CCI table
  • added Patient Viewer Tab ICD10
  • added subform L_ICD10_subform
  • added subform L_CCI_subform

2017-08-24

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

• Added "unstageable" stage to following dxs:
  • Ulcers - Decubitus only
  • Ulcers - Diabetic foot only
  • Ulcers - Lower Extremity & other

2017-08-03

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

• updated query check_overstay_pt_from_our_med Ttenbergen 09:31, 2017 August 3 (CDT)
• changed tab order on viewer to stop at Notes field

2017-08-01

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

• updated overstay query check_overstay_pt_from_our_med which checks for coming from collected ward to cope with e.g. HSC_H4Ha 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)

• changes to s_AllDiagnoses table
  • 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

• for QA_Septic_Shock#Consistency_Checks, changed "query s_tmp_QASeptic_Dx_no_tmp" so it will only trigger for patients with RecordStatus complete - work-around of entering something wrong will no longer be required. As Requested by Trish in Requested CCMDB changes for the next version a while ago, just saw it. Ttenbergen 00:49, 2017 July 30 (CDT)

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)

• 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 S_Pathogens table. 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 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 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)