CCMDB.mdb Change Log 2017: Difference between revisions

(166 intermediate revisions by 5 users not shown)

Line 8:

== Versions ==

===~~Before Oct 3~~.17===

=== next ===

*~~add VIC_N4~~ to ~~s_dispo~~ table to ~~both Pam~~ and ~~Shirley~~'~~s laptop~~

* send queries for CCI / ICD10

**~~Pam and Shirley~~ to ~~get back~~ to ~~Trish by Sept 19 as~~ to ~~which ward will be their primary. S5 or N5~~.[[User:~~TOstryzniuk~~|~~Trish Ostryzniuk~~]] 16:11, 2017 ~~September 14~~ (~~CDT~~)

* [[L_CCI_Component table]]

** ~~{{discussion}} The s_dispo~~ is the ~~same on all laptops. I suspect you mean it should be available as~~ a ~~service~~/location ~~for them~~ to ~~enter on those laptops~~? ~~I will assume~~ that ~~is what you meant~~ and ~~change it like~~ that. ~~If that~~ was right, ~~pls remove~~ the ~~discussion~~ (and ~~request since done~~)~~. Is that~~'s ~~not what you meant~~, ~~we need~~ to ~~talk~~. Ttenbergen 22:32, 2017 ~~September~~ 14 (CDT)

* [[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 ===

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]]

=== ~~next~~ ===

=== 2017-10-10-2 ===

* ~~ubernext~~

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

** ~~had look at https~~:~~//ccmdb~~.~~kuality.ca/index.php?title~~=~~ACCU_borrow&curid~~=~~4858&diff~~=~~54582&oldid~~=~~50899 but have questions.~~

* added [[Influenza tracking]]

** ~~review service cross check fixes; apparently STB can't enter service "from ER" when pt arrives from Emerg~~.

* 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 22:32, 2017 September 14 (CDT)

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 ===

Line 33:

Line 283:

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)

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

* 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 ===

Line 45:

Line 295:

** 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 ''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 ===

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)

** 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 58:

Line 308:

* changed colour generator

** 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

*** disabled code that used to check DPST entries

Line 67:

Line 317:

** 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 ===

Line 115:

Line 365:

=== 2017-Apr-27 ===

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

Line 149:

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)

* 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 ===

Line 157:

Line 407:

=== 2017-Feb-07 ===

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)

Line 166:

Line 416:

=== 2017-Jan-25 ===

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 ===

Line 181:

Line 431:

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

* removed requirement to fill in [[ACP Status Collection in ICU]] Ttenbergen 08:24, 2017 January 9 (CST)

=== 2017-Jan-05 ===

Line 190:

Line 440:

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

* 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]]

@@ Line 8: / Line 8: @@
 == Versions ==
-===Before Oct 3.17===
+=== next  ===
-*add VIC_N4 to s_dispo table to both Pam and Shirley's laptop
+* send queries for CCI / ICD10
-**Pam and Shirley to get back to Trish by Sept 19 as to which ward will be their primary. S5 or N5.[[User:TOstryzniuk|Trish Ostryzniuk]] 16:11, 2017 September 14 (CDT)
+* [[L_CCI_Component table]]
-** {{discussion}} The s_dispo is the same on all laptops. I suspect you mean it should be available as a service/location for them to enter on those laptops? I will assume that is what you meant and change it like that. If that was right, pls remove the discussion (and request since done). Is that's not what you meant, we need to talk. Ttenbergen 22:32, 2017 September 14 (CDT)
+* [[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 ===
+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]]
-=== next  ===
+=== 2017-10-10-2 ===
-* ubernext
+rolled out Ttenbergen 17:38, 2017 October 12 (CDT)
-** had look at https://ccmdb.kuality.ca/index.php?title=ACCU_borrow&curid=4858&diff=54582&oldid=50899 but have questions.
+* added [[Influenza tracking]]
-** review service cross check fixes; apparently STB can't enter service "from ER" when pt arrives from Emerg.
+* 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 22:32, 2017 September 14 (CDT)
+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 ===
@@ Line 33: / Line 283: @@
 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)
+* 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)
+* 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 ===
@@ Line 45: / Line 295: @@
 ** 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 ''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 ===
 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)
 ** 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 58: / Line 308: @@
 * changed colour generator
 ** 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
 *** disabled code that used to check DPST entries
@@ Line 67: / Line 317: @@
 ** 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 ===
@@ Line 115: / Line 365: @@
 === 2017-Apr-27 ===
 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
@@ Line 149: / 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)
 * 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 ===
@@ Line 157: / Line 407: @@
 === 2017-Feb-07 ===
 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)
@@ Line 166: / Line 416: @@
 === 2017-Jan-25 ===
 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 ===
@@ Line 181: / Line 431: @@
 === 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)
+* removed requirement to fill in [[ACP Status Collection in ICU]] Ttenbergen 08:24, 2017 January 9 (CST)
 === 2017-Jan-05 ===
@@ Line 190: / Line 440: @@
 ** 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)
+* 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]]