CCMDB.mdb Change Log 2017: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (46 intermediate revisions by the same user not shown) | |||
| Line 9: | Line 9: | ||
== Versions == | == Versions == | ||
=== next === | === next === | ||
* | * send queries for CCI / ICD10 | ||
* [[L_CCI_Component table]] | |||
* [[L_CCI_Picklist table]] | |||
=== 2017-12-13- | === 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. | updated queries to omit the old date and location stuff deleted in most recent version. | ||
* ''Primary_admit'' | * ''Primary_admit'' | ||
Disabled queries as discussed in [[ | Disabled queries as discussed in [[Check ORDx]]: | ||
* ''Check_ORDx__from_OR_no_ORDx'' | * ''Check_ORDx__from_OR_no_ORDx'' | ||
* ''Check_ORDx__not_from_OR_OrDx'' | * ''Check_ORDx__not_from_OR_OrDx'' | ||
| Line 26: | Line 50: | ||
=== 2017-12-13 === | === 2017-12-13 === | ||
rolled. [[User:CMarks|CMarks]] 07:31, 2017 December 13 (CST) | rolled. [[User:CMarks|CMarks]] 07:31, 2017 December 13 (CST) | ||
* updated query | * 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 === | === 2017-12-07-3 === | ||
not rolled yet Ttenbergen 13:20, 2017 December 7 (CST) | not rolled yet Ttenbergen 13:20, 2017 December 7 (CST) | ||
* [[ER Delay]] cross | * [[ER Delay]] [[cross check]]s: | ||
** added query ''check_ER_Delay_not_too_big'' | ** added query ''check_ER_Delay_not_too_big'' | ||
** updated ''Function Dispo_Chronological()'' to use the query to give warning when checking complete box | ** updated ''Function Dispo_Chronological()'' to use the query to give warning when checking complete box | ||
| Line 55: | Line 79: | ||
* ''Convert_DB()'': | * ''Convert_DB()'': | ||
** updated the table translation for [[L_Log table]] and [[L_Dxs table]] to omit the removed fields | ** 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 | ** added code to add in [[L_ICD10 table]] and L_CCI table | ||
* ''DB_Connect()'': updated to add in [[L_ICD10 table]] and | * ''DB_Connect()'': updated to add in [[L_ICD10 table]] and L_CCI table | ||
* removed a bunch of old locations/times stuff from module ''Converters'': | * removed a bunch of old locations/times stuff from module ''Converters'': | ||
| Line 80: | Line 104: | ||
=== 2017-12-07 === | === 2017-12-07 === | ||
rolled out Ttenbergen 13:20, 2017 December 7 (CST) | rolled out Ttenbergen 13:20, 2017 December 7 (CST) | ||
* correction to tmp cross | * correction to tmp [[cross check]]s that went wrong in last update Ttenbergen 13:20, 2017 December 7 (CST) | ||
=== 2017-12-06 === | === 2017-12-06 === | ||
| Line 94: | Line 118: | ||
** VIC_ER set to inactive; emailed VIC ladies to make sure this won't cause a problem | ** 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) | * fixed ICD10 dropdown in ICD10 tab, somehow had got locked, should work now. Ttenbergen 19:15, 2017 December 5 (CST) | ||
* updated | * updated L_CCI subform: added +, -, * buttons for [[Px_Date]] | ||
* updated [[L_ICD10 subform]]: | * updated [[L_ICD10 subform]]: | ||
** added +, -, * buttons for [[Dx_Date]] | ** added +, -, * buttons for [[Dx_Date]] | ||
| Line 103: | Line 127: | ||
** removed category columns and some others we won't be using that way | ** removed category columns and some others we won't be using that way | ||
** imported new content from wiki | ** imported new content from wiki | ||
* [[ACCU borrow]] cross | * [[ACCU borrow]] [[cross check]]s: | ||
** s_tmp_ACCU_Borrow_chronicity_hard | ** s_tmp_ACCU_Borrow_chronicity_hard | ||
** s_tmp_ACCU_Borrow_2_hr_soft | ** s_tmp_ACCU_Borrow_2_hr_soft | ||
| Line 113: | Line 137: | ||
=== 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 | * 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 122: | 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 | * 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 | ** 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 | ** made L_CCI_subform#Picklist (the "P" button) functionality | ||
* added [[table | * 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 138: | 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]], | * added [[s_CCI_1 table]], [[s_CCI_2 table]], s_CCI_3 table | ||
* removed s_CCI table | * removed s_CCI table | ||
* updated | * updated L_CCI table, added fields CCI_1_ID, CCI_2_ID, CCI_3_ID, removed field CCI_ID | ||
* added [[query | * added [[query L_CCI_Combined]] | ||
* updated | * 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 150: | 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 | ** 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 161: | 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 | ** edited [[VIC_N5C]] and [[VIC_N5C]] to have service type ''SubAcute'', as discussed with Julie | ||
=== 2017-11-07 === | === 2017-11-07 === | ||
| Line 195: | 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 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 203: | 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 227: | 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 | ** 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 244: | 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 | ||
** added [[Patient | ** 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 259: | 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 | * 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 | * 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 271: | 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 | ** 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 [[ | * 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 284: | 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 | *** 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 293: | Line 317: | ||
** added call to CreateMail when red | ** added call to CreateMail when red | ||
* for [[QA_Septic_Shock#Consistency_Checks]], changed query | * 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 341: | 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 | * 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 375: | 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 [[ | * 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 383: | 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 [[ | * 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 392: | 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 [[ | * adding entries for [[AcceptDateSource]] to [[s_tmp table]] table Ttenbergen 11:22, 2017 January 25 (CST) | ||
=== 2017-Jan-23 === | === 2017-Jan-23 === | ||
| Line 407: | 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 | * removed requirement to fill in [[ACP Status Collection in ICU]] Ttenbergen 08:24, 2017 January 9 (CST) | ||
=== 2017-Jan-05 === | === 2017-Jan-05 === | ||
| Line 416: | 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 | * inactivated [[s_tmp table]] entries for [[ACP Status Collection in ICU]] Ttenbergen 13:12, 2017 January 5 (CST) | ||
[[Category: CCMDB. | [[Category:CCMDB.accdb]] | ||
[[Category: Change Logs CCMDB]] | [[Category:Change Logs CCMDB]] | ||