CCMDB.mdb Change Log 2017: Difference between revisions
Ttenbergen (talk | contribs) m link fix |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (19 intermediate revisions by the same user not shown) | |||
| Line 50: | 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 104: | 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 127: | 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 165: | Line 165: | ||
* 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 | * 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]] | ||
| Line 174: | 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 185: | 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 219: | 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 227: | 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 269: | Line 269: | ||
*** [[L_ICD10 table]], added some sample data | *** [[L_ICD10 table]], added some sample data | ||
*** L_CCI table | *** 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 283: | 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 295: | 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 === | ||
| Line 308: | 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 317: | 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 365: | 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 399: | 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 407: | 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 416: | 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 431: | 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 440: | 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]] | ||