CCMDB Wiki

CCMDB.mdb Change Log 2017: Difference between revisions

← Older edit
m →next: more to do
m Text replacement - "[[Category: " to "[[Category:"
 
(185 intermediate revisions by 5 users not shown)
Line 8: Line 8:


== Versions ==
== Versions ==
=== next ===
=== next ===
* implement task "review accu borrow"
* send queries for CCI / ICD10
* implement task "...necrotizing..."
* [[L_CCI_Component table]]
* confirm task "CCMDB dispo screen tabbing"
* [[L_CCI_Picklist table]]
* fix hyperlinks to firs and last name wiki articles from patient list.
 
* add dx/procedure code for [[Medical Assistance In Dying]]
=== 2017-12-20 ===
* review service cross check fixes; apparently STB can't enter service "from ER" when pt arrives from Emerg.
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 Unit]]s 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. [[User:CMarks|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. [[User:CMarks|CMarks]] 07:31, 2017 December 13 (CST)
 
=== 2017-12-07-3 ===
not rolled yet Ttenbergen 13:20, 2017 December 7 (CST)
* [[ER Delay]] [[cross check]]s:
** 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 check]]s 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 check]]s:
** 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_N5]]a, [[GRA_S3]]a 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 [[CAU]]s 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 [[User:CMarks|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_H4H'''''a''''' [[User:CMarks|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 ===
=== 2017-06-28-3 ===
Line 62: Line 365:
=== 2017-Apr-27 ===
=== 2017-Apr-27 ===
rolled Ttenbergen 16:38, 2017 April 27 (CDT)
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)
* 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
** added query ''s_tmp_apostrophe_in_comment'' to do this


Line 96: Line 399:
* 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)
* 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)
* 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)
* 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 ===
=== 2017-Mar-02 ===
Line 104: Line 407:
=== 2017-Feb-07 ===
=== 2017-Feb-07 ===
rolled out Ttenbergen 17:48, 2017 February 7 (CST)
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 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)
* updated s_tmp table to accommodate dropdown changes for [[AcceptDateSource]]- Ttenbergen 17:46, 2017 February 7 (CST)


Line 113: Line 416:
=== 2017-Jan-25 ===
=== 2017-Jan-25 ===
rolled out Ttenbergen 11:22, 2017 January 25 (CST)
rolled out Ttenbergen 11:22, 2017 January 25 (CST)
* adding entries for [[AcceptDateSource]] to [[S Tmp]] table 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 ===
=== 2017-Jan-23 ===
Line 128: Line 431:
=== 2017-Jan-05 ===
=== 2017-Jan-05 ===
rolled out Ttenbergen 08:24, 2017 January 9 (CST)
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)
* removed requirement to fill in [[ACP Status Collection in ICU]] Ttenbergen 08:24, 2017 January 9 (CST)


=== 2017-Jan-05 ===
=== 2017-Jan-05 ===
Line 137: Line 440:
** send_Centralized_1L_Log__intermediate
** 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)
* 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)
* inactivated [[s_tmp table]] entries for [[ACP Status Collection in ICU]] Ttenbergen 13:12, 2017 January 5 (CST)




[[Category: CCMDB.mdb]]
[[Category:CCMDB.accdb]]
[[Category: Change Logs CCMDB]]
[[Category:Change Logs CCMDB]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.mdb_Change_Log_2017"