CCMDB Wiki

CCMDB.mdb Change Log 2017: Difference between revisions

← Older edit
m Text replacement - "[[Category: " to "[[Category:"
 
(81 intermediate revisions by 3 users not shown)
Line 9: Line 9:
== Versions ==
== Versions ==
=== next  ===
=== next  ===
* [[ER Delay#CCDMB Data Integrity Checks]]
* send queries for CCI / ICD10
* had look at https://ccmdb.kuality.ca/index.php?title=ACCU_borrow&curid=4858&diff=54582&oldid=50899 but have questions.
* [[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 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 ===
=== 2017-11-30 ===
not rolled out yet [[User:TinaBot|TinaBot]] 16:50, 2017 November 30 (CST)
rolled out Ttenbergen 17:56, 2017 December 6 (CST)
* tweak to data in [[s_dispo table]]: STB ER(direct) changed from being listed as OAK to STB
* 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 ===
=== 2017-11-28 ===
rolled out TTenbergen 16:58, 2017 November 28 (CST)
rolled out TTenbergen 16:58, 2017 November 28 (CST)
* updated [[L_CCI subform]]
* 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
** 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
*** tweaked further so they contain ''all'' entries again once the record worked on goes out of focus
Line 27: Line 146:
=== 2017-11-25 ===
=== 2017-11-25 ===
rolled out Ttenbergen 18:19, 2017 November 26 (CST)
rolled out Ttenbergen 18:19, 2017 November 26 (CST)
* updated [[L_CCI subform]]
* updated L_CCI subform
** changed sorting and filtering in dropdowns
** changed sorting and filtering in dropdowns
** added dropdown to filter first list to T, D, I
** 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#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  
** made L_CCI_subform#Picklist (the "P" button) functionality  
* added [[table s_CCI_Picklist]]
* added [[S CCI Picklist table]]
* updated [[ICD10 Chooser form]]
* updated [[ICD10 Chooser form]]
** items on list are now links to the corresponding wiki articles
** items on list are now links to the corresponding wiki articles
Line 43: Line 162:
=== 2017-11-13 ===
=== 2017-11-13 ===
rolled out Ttenbergen 17:41, 2017 November 15 (CST)
rolled out Ttenbergen 17:41, 2017 November 15 (CST)
* added [[s_CCI_1 table]], [[s_CCI_2 table]], [[s_CCI_3 table]]
* added [[s_CCI_1 table]], [[s_CCI_2 table]], s_CCI_3 table
* removed s_CCI table
* removed s_CCI table
* updated [[L_CCI table]], added fields [[CCI_1_ID]], [[CCI_2_ID]], [[CCI_3_ID]], removed field CCI_ID
* updated L_CCI table, added fields CCI_1_ID, CCI_2_ID, CCI_3_ID, removed field CCI_ID
* added [[query L CCI Resolver]]
* added [[query L_CCI_Combined]]
* updated [[L CCI subform]]
* 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]]
* 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
* added form CCI_Chooser
Line 55: Line 174:
* in [[s_dispo table]]:  
* in [[s_dispo table]]:  
** changed [[VIC_S4]] to be active again but only as [[Previous Location]]
** 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]],[[VIC_N4]] and [[VIC_N4C]] to be "service_type" TC
** changed [[River Ridge Transition Care Environment]] to be [[loc_type]] TCE
** changed [[River Ridge Transition Care Environment]] to be [[loc_type]] TCE


Line 66: Line 185:
* in [[s_dispo table]]:  
* in [[s_dispo table]]:  
** updated names of the [[CAU]]s from * - CAU to *_CAU to be consistent with other inpatient locations
** 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
** edited [[VIC_N5C]] and [[VIC_N5C]] to have service type ''SubAcute'', as discussed with Julie


=== 2017-11-07 ===
=== 2017-11-07 ===
Line 100: Line 219:
** [[S ICD10 Charlson Como conditions table]]
** [[S ICD10 Charlson Como conditions table]]
** [[S ICD10 table]]
** [[S ICD10 table]]
** [[S ICD10 Blocks table]]
** S ICD10 Blocks table
** [[S ICD10 Block Dxs table]]
** S ICD10 Block Dxs table
* [[Influenza tracking]] - added "suspected"
* [[Influenza tracking]] - added "suspected"
* unchecked in [[s_dispo table]]: 'VIC UC(direct)' [[Previous Location]]
* unchecked in [[s_dispo table]]: 'VIC UC(direct)' [[Previous Location]]
Line 108: Line 227:
rolled out Ttenbergen 17:38, 2017 October 12 (CDT)
rolled out Ttenbergen 17:38, 2017 October 12 (CDT)
* added [[Influenza tracking]]
* added [[Influenza tracking]]
* added [[s_dispo table]] entries for [[:Category:CAU]] and [[Direct admit]] and [[Parked in ER]]
* 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  
* edited query ''check_previous_location_vs_service_inconsistent'' to allow  
** [[Previous Service]] = family medicine when [[Previous Location]] medicine ward where we collect.
** [[Previous Service]] = family medicine when [[Previous Location]] medicine ward where we collect.
Line 132: Line 251:
* ICD10:  
* ICD10:  
** added [[No procedure entered]] to s_CCI table to prevent null errors
** added [[No procedure entered]] to s_CCI table to prevent null errors
** added [[No diagnosis entered]] to [[s_ICD10 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.
** updated the forms to link the data properly to the patient, before all data would have showed for all patients.


Line 149: Line 268:
*** s_CCI table
*** s_CCI table
*** [[L_ICD10 table]], added some sample data
*** [[L_ICD10 table]], added some sample data
*** [[L_CCI table]]
*** L_CCI table
** added [[Patient viewer tab ICD10]]  
** added [[Patient Viewer Tab ICD10]]  
** added subform ''L_ICD10_subform''
** added subform ''L_ICD10_subform''
** added subform ''L_CCI_subform''
** added subform ''L_CCI_subform''
Line 164: Line 283:
rolled out Ttenbergen 09:31, 2017 August 3 (CDT)
rolled out Ttenbergen 09:31, 2017 August 3 (CDT)
Somehow 2017-08-01 got overwritten on server, re-doing changes
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)
* 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
* changed tab order on viewer to stop at Notes field


=== 2017-08-01 ===
=== 2017-08-01 ===
rolled out from Con's desk [[User:CMarks|CMarks]] 13:50, 2017 August 1 (CDT)
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)
* 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 ===
=== 2017-07-31 ===
Line 176: Line 295:
** update query ''check_overstay_not_entered''
** update query ''check_overstay_not_entered''
** deleted query ''check_overstay_still_has_enter_line'' Ttenbergen 09:58, 2017 July 31 (CDT)
** deleted query ''check_overstay_still_has_enter_line'' Ttenbergen 09:58, 2017 July 31 (CDT)
** updated query ''check_overstay_no_colour_not_transferred'' into ''check_overstay_no_colour'' and removed the transferred check, done differently now. 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 ===
=== 2017-Jul-29 ===
Rolled out Ttenbergen 01:03, 2017 July 30 (CDT)
Rolled out Ttenbergen 01:03, 2017 July 30 (CDT)
* changes to [[S AllDiagnoses]]  
* changes to [[s_AllDiagnoses table]]
** added [[Medical Assistance In Dying]] Ttenbergen 21:13, 2017 July 29 (CDT)
** 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)
** changed wording for and to [[Necrotizing soft tissue infections (necrotizing fasciitis, myonecrosis, gas or clostridial gangrene etc.)]]Ttenbergen 21:41, 2017 July 29 (CDT)
Line 189: Line 308:
* changed colour generator
* changed colour generator
** make gray if comes from medicine ward at same site where we collect
** make gray if comes from medicine ward at same site where we collect
*** added query ''check_overstay_pt_from_our_med''
*** added [[query check_overstay_pt_from_our_med]]
** excluded DPST info from colour generation
** excluded DPST info from colour generation
*** disabled code that used to check DPST entries
*** disabled code that used to check DPST entries
Line 198: Line 317:
** added call to CreateMail when red
** 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)
* 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 246: 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 280: 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 288: 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 297: 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 312: 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 321: 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"