View source for CCMDB.mdb Change Log 2016

__NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. -->
'''''see [[Log (disambiguation)]] for other uses of the term "Log"
''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''. See [[Rolling out changes]] for the process of rolling out changes. 

The CCMDB.mdb '''Change Log''' logs changes made to the CCMDB.mdb. New entries should be made at the top to be immediately apparent. 

Enter '''[[requested CCMDB changes for the next version]]''' in that article. 

== Versions ==
*go to [[CCMDB.mdb Change Log 2017]]

=== 2016-Dec-next ===
* remove the old s_ tables that are no longer used. then remove from wiki. 

=== 2016-Dec-29 ===
rolled out Ttenbergen 10:58, 2016 December 29 (CST)
* fix for [[MSCOMCT2.ocx error]] - referring to modern counterpart. Ttenbergen 10:58, 2016 December 29 (CST)

=== 2016-Dec-08 ===
Rolled out [[User:Haubel|Haubel]] 12:27, 2016 December 8 (CST)

*Format for [["generate email" button]]
** Time format changed to match the way it is displayed on the [[patient viewer]] form. (24 hour format)

=== 2016-Dec-07 ===
(was rolled out)Ttenbergen
Changes collectors will want to know: 
* on [[patient viewer]]
* added [["generate email" button]]
* added [[Venous blood gas (labs)]] to Labs tab 
* re-enabled opening records that are already sent, but with warning

Background changes: 
* updated dx sending to no longer include "rank" since it's not populated or used any longer
** query ''Send_Centralized_L_Dxs_update'' already didn't have it
** updated query ''Send_Centralized_L_Dxs_append''
** query ''Send_Centralized_L_Dxs_delete'' didn't include fiel
* update Log sending to stop sending [[SAPS BP Field]] Ttenbergen 11:53, 2016 December 7 (CST)
** query ''Send_Centralized_1L_Log_append''
** query ''Send_Centralized_1L_Log_update''
** query ''send_Centralized_1L_Log__intermediate''
* update Labs sending to include [[Venous blood gas (labs)]]
** query ''Send_Centralized_L_Labs_Flowsheet__intermediate''
** query ''Send_Centralized_L_Labs_Flowsheet_update''
** query ''Send_Centralized_L_Labs_Flowsheet_append''
** query ''Send_Centralized_L_Labs_Flowsheet_delete'' did not need editing Ttenbergen 11:57, 2016 December 7 (CST)

=== 2016-Nov-28 ===
rolled out Ttenbergen 10:26, 2016 November 28 (CST)
* updating sending to work with changes in [[Centralized_data.accdb]]_Change_Log#2016-Nov-24]] Ttenbergen 10:08, 2016 November 28 (CST)
** cleaned up some old commented out code Ttenbergen 10:21, 2016 November 28 (CST)
** updated query ''send_check_centralized_is_owner'' which was still looking at R_Location Ttenbergen 10:21, 2016 November 28 (CST)

=== 2016-Nov-24 ===
rolled out Ttenbergen 16:19, 2016 November 24 (CST)
* added entries to [[s_dispo table]] for [[Dialysis Unit]] Ttenbergen 16:17, 2016 November 24 (CST)

=== 2016-Nov-21 ===
rolled out Ttenbergen 10:05, 2016 November 24 (CST)
* updated Sub ''Legacy_Hider()'' 
** hide "DC Treatment" label for medicine Ttenbergen 15:48, 2016 November 21 (CST)
** remove some old variables that are no longer used Ttenbergen 15:48, 2016 November 21 (CST)
* updated controls in CCMDB so the only allow items in dropdown (was allowing anything) Ttenbergen 15:54, 2016 November 21 (CST)
** [[DC Treatment]] 
** [[LTV]]

===2016-Nov-17===
rolled Ttenbergen 16:11, 2016 November 17 (CST)
* changed color for HSC_EMIPs in s_dispo table Ttenbergen 15:08, 2016 November 17 (CST)
* eliminated use of Sub Pivoter and table send_dxs

===2016-Nov-15===
Rolled out. [[User:Haubel|Haubel]] 12:23, 2016 November 15 (CST)
* The following tables were put back (taken out for version 2016-Nov-14-2)
** send_comos
** send_dxs
** send_dxs_acqu
** send_pharm
Users were getting an error when clicking on the "D" checkbox: "The Microsoft Access database engine cannot find the input table or query 'send_dxs'.  Make sure it exists and that its name is spelled correctly"

===2016-Nov-14-2===
rolled out Ttenbergen 17:20, 2016 November 14 (CST)

'''Functional changes: '''
* updated following to use query ''Primary_admit'' instead of the old ''send_dxs'' table that has not been used in ages:
** query ''Check_ORDx__from_OR_no_ORDx*''
** query ''Check_ORDx__not_from_OR_OrDx''
* ''Accept_DtTm_missing'' field not sent
** added to query ''Send_Centralized_1L_Log_append''
** added to query ''Send_Centralized_1L_Log_update''
** added to query ''send_Centralized_1L_Log__intermediate''

'''Cleanup, should be invisible to collectors:'''
* deleted old tables: 
** table ''send_dxs''  
** table ''send_comos''
** table ''send_dxs_acqu''
** table ''send_pharm''
** table ''sent_pharm_dont delete send_pharm it messes up query Eds_CC''
* updated query ''Send_Centralized_1L_Log_append''
** removed R_Location,  R_AdmitFrom, R_DischargedTo, R_HospitalPrevious, R_SurviveExpire, R_AdmDate, R_AdmTime, R_TRDate, R_TRTime, R_DisDate, R_DisTime, Var1, Var2, Var3, Var4, Var5, Var6
* updated query ''send_Centralized_1L_Log__intermediate'' 
** removed R_Location,  R_AdmitFrom, R_DischargedTo, R_HospitalPrevious, R_SurviveExpire, R_AdmDate, R_AdmTime, R_TRDate, R_TRTime, R_DisDate, R_DisTime, Var1, Var2, Var3, Var4, Var5, Var6
* updated query ''Send_Centralized_1L_Log_update'' 
** removed R_Location,  R_AdmitFrom, R_DischargedTo, R_HospitalPrevious, R_SurviveExpire, R_AdmDate, R_AdmTime, R_TRDate, R_TRTime, R_DisDate, R_DisTime, Var1, Var2, Var3, Var4, Var5, Var6
* deleted old queries var1opts, var2opts, var3opts, var4opts, var5opts, var6opts, zz_procedures, s_tmp_ER_Wait_*, s_tmp_Postal_duplicate, TmpCheck_Dupl_SmartPump, Check_pt_multiples_pre_2016-06-30, check_minimal_data_set_incomplete_2016-11-04, check_minimal_data_set_incomplete_old, check_tmp_no_transfer_date
* deleted old table paste_errors, s_HospitalCodes_pre2015-07-06, peer_audit_partners, s_tmp_CRRT
* deleted a lot of old, commented out VBA

===2016-Nov-14===
rolled out Ttenbergen 11:51, 2016 November 14 (CST)
* changed colours for the HSC_EMIP entries on patient list Ttenbergen 11:32, 2016 November 14 (CST)
* fixed spelling for [[Crohns Disease]] from "Chrohn's Disease" Ttenbergen 11:42, 2016 November 14 (CST)
* confirmed that "no transfer date" and "ER Wait" entries were removed from dropdown Ttenbergen 11:44, 2016 November 14 (CST)

===2016-Nov-09===
Rolled out.  [[User:Haubel|Haubel]] 13:27, 2016 November 9 (CST)

* Criteria added to the [[Query check overstay not entered]] query to exclude EMIPs.

===2016-Nov-07-2===
rolled out Ttenbergen 17:16, 2016 November 7 (CST)
* updated send queries to include fields that were added to collection but not to send queries: 
** [[GCS sedated field]] Ttenbergen 15:36, 2016 November 7 (CST)
** ''Accept DtTm missing field'' Ttenbergen 16:25, 2016 November 7 (CST)
* commented out s_tmp_ER_wait* queries, none should need to run any longer since all that is in new date/location fields.
* removed "from" options from Overstay dropdown in tmp. Ttenbergen 16:53, 2016 November 7 (CST)
* confirmed that Overstay will not ignore missing ADLs when relevant. Ttenbergen 17:06, 2016 November 7 (CST)

===2016-Nov-07===
rolled out Ttenbergen 13:49, 2016 November 7 (CST)
* changed formatting for form ''dx_chooser'' and ''comoChooser'' to use same font as rest of app, which is bolder and easier to read. Ttenbergen 11:36, 2016 November 7 (CST)
* [[HSC_EMIP]]: added to [[s_dispo table]] and [[s_locations_allowed_collection table]] the following: '''HSC_EMIP_a, EMIP_b, EMIP_d, EMIP_h'''; 
**waiting for center numbers from Julie -Ttenbergen 13:19, 2016 November 7 (CST) (center numbers provided to Tina by Julie and Julie confirmed this.  So this is also done.  
* updated Function ''pt_is_from_PCH(Pat_ID)'' to no longer treat records with old location data differently Ttenbergen 13:38, 2016 November 7 (CST)
* removed DoCmd.OpenQuery "2016-08-29_off_ward_fixer" from main form opener; and removed the query Ttenbergen 13:38, 2016 November 7 (CST)

===2016-Nov-04===
Rolled out [[User:Haubel|Haubel]] 10:31, 2016 November 4 (CDT)
* Issue with [[query check_minimal_data_set_incomplete]] resulted from yesterday's change (Cleaning up old date checks project).  
** Locn_bad (column 5) changed from:
*** Locn_bad: IIf([dispo_dttm]<=#7/1/2016# And (IsNull([R_Location]) Or ([R_Location]="")),"Problem: empty","")
*** To: IIf([dispo_dttm]>now() And (IsNull([R_Location]) Or ([R_Location]="")),"Problem: empty","")
** admdate_bad (column 7) changed from:
*** admdate_bad: IIf([dispo_dttm]<=#7/1/2016# And (IsNull([r_admdate]) Or ([r_admdate]>Now())),"Problem: empty","")
*** To: admdate_bad: IIf([dispo_dttm]>now() And (IsNull([r_admdate]) Or ([r_admdate]>Now())),"Problem: empty","")

===2016-Nov-03===
Rolled out [[User:Haubel|Haubel]] 16:11, 2016 November 3 (CDT); on Herman's laptop. Ttenbergen 11:42, 2016 November 3 (CDT)
* Cleaning up old date checks project for the data we changed this year.
** Commented out [[Postal Code field]] check in Sub Temp_Checker_in_viewer [[User:Haubel|Haubel]] 14:28, 2016 November 3 (CDT)
** Commented out Public Const Dispo_transition_cate [[User:Haubel|Haubel]] 15:44, 2016 November 3 (CDT)

===2016-Oct-31===
rolled out Ttenbergen 11:42, 2016 November 3 (CDT)
* [[s_tmp table]]; cleaning up to be in sync with [[:Category:Project]] re what's active etc.

===2016-Oct-27-2===
rolled Ttenbergen 15:40, 2016 October 27 (CDT)
* [[Overstay_Predictor_Project_Collection_Instructions]] - edited query ''check_overstay_not_entered'' to accommodate transferred forms. Ttenbergen 15:40, 2016 October 27 (CDT)

===2016-Oct-27===
rolled out Ttenbergen 10:01, 2016 October 27 (CDT)
* updated the [[cross check]] for [[Overstay_Predictor_Project_Collection_Instructions]] so error msg will be specific and say that colour might be what is missing.

===2016-Oct-20===
rolled out Ttenbergen 17:13, 2016 October 26 (CDT)
* "Accept DtTm" required from own ER only
** checked Function from_ER()
** updated [[Query check_pt_from_ER]] to only trigger for own ER Ttenbergen 11:37, 2016 October 20 (CDT)
* [[ACP Status Collection in ICU]] - update to allow no date if checkbox is checked Ttenbergen 15:51, 2016 October 20 (CDT)
** table ''s_tmp'' - added label "no date" for bool_var Ttenbergen 15:51, 2016 October 20 (CDT)
** updated [[ACP_Status_collection_in_ICU#Collection_Instructions]] Ttenbergen 15:51, 2016 October 20 (CDT)
** [[query s_tmp_ACP]] - updated Ttenbergen 16:24, 2016 October 20 (CDT)
* minimal record set required for [[Overstay_Predictor_Project_Collection_Instructions#Changes_to_regular_minimal_data_collection_and_entry_required_for_the_Overstay_Project]]
** query ''s_tmp_no_overstay_colour'' - not used by queries or VBA, deleted query
** query ''check_overstay_not_entered'' 
*** confirmed used by VBA tmp_checker_in_viewer
*** updated to use new s_dispo and dttm fields

===2016-Oct-13===
rolled out Ttenbergen 11:11, 2016 October 13 (CDT)
* added '''real_collection''' column to [[s_dispo_table]]l; required for some [[cross check]]s in CFE, see [[Centralized_data_front_end.mdb_Change_Log_2016#2016-10-12-2]] Ttenbergen 11:11, 2016 October 13 (CDT)
* moved the [[Postal Code field]] and [[Province]] closer to the [[Pre-admit Inpatient Institution field]] Ttenbergen 14:31, 2016 October 12 (CDT)

===2016-Sep-29-2===
rolled out Ttenbergen 14:09, 2016 October 12 (CDT)
* [[s_dispo table]]: 
** updated several "Outside City - *" entries so they are visible appropriately in CFE even though they are inactive. Ttenbergen 16:25, 2016 September 29 (CDT)
** updated entry for "STB Hospice" to "STB Palliative" as per email and wiki discussions Ttenbergen 13:51, 2016 October 12 (CDT)

===2016-Sep-29===
rolled out Ttenbergen 10:25, 2016 September 29 (CDT)
* [[s_dispo table]]: 
** combined "Out-of-WPG - unknown" and "Outside City - unknown/other", only latter is active now. There had been two but one was legacy only. '''Need to combine in data and then remove the old line.''' Ttenbergen 09:52, 2016 September 29 (CDT)
** renamed "Winkler/Bethel/Boundary Trails*" to "Winkler/Bethel*" since there is a "Winkler/Boundary Trails". ''' Will need to fix data for pre-/post- amalgamation in 2001. ''' Ttenbergen 09:58, 2016 September 29 (CDT)
** made all entries for old Morden and Winkler records inactive, the OR/RR ones were mistakenly active. 
* updated Function ''Validate_Accept_DtTm()'' to use ''Accept DtTm missing field'' check box and to allow time = 0:00 Ttenbergen 10:15, 2016 September 29 (CDT)

===2016-Sep-26===
rolled out Ttenbergen 16:17, 2016 September 26 (CDT)
* fixed PHIN label in [[Patient Viewer]], had accidentally got changed last round Ttenbergen 09:44, 2016 September 26 (CDT)
* in [[s_dispo table]] changed care level for HSC_H6 to 6 to no longer require a [[Transfer Ready DtTm]] for transfers there. Ttenbergen 10:59, 2016 September 26 (CDT)

===2016-Sep-22-2===
rolled Ttenbergen 16:50, 2016 September 22 (CDT)
* cleaned out links to "new_*" tables, must have stopped a test in the middle of DB Converter
* labels to Web Links: off ward, dc treatment
* added ''Accept_DtTm_missing_field'' and [[GCS sedated field]]
* confirmed that GRA_EMIP now available as previous location
* in [[Patient Viewer]]
** changed top line labels to be consistent with arrive_dttm and dispo_dttm names as now used Ttenbergen 16:28, 2016 September 22 (CDT)
** changed labels of top line to be links to corresponding wiki articles Ttenbergen 16:28, 2016 September 22 (CDT)
* re-aligned the complete checkboxes with corresponding tabs Ttenbergen 16:28, 2016 September 22 (CDT)
* fixed date format inconsistency between Pharm/Lab and the Dispo screen, they should all be consistent now. Also made Birth Date consistent with that format. All same now. Ttenbergen 16:44, 2016 September 22 (CDT)
* changed tab order for Dispo Tab, pls let me know if tweaks are needed Ttenbergen 16:44, 2016 September 22 (CDT)
* added Arrive_DtTm and Dispo_DtTm to top of pharm and lab tabs for easy reference Ttenbergen 16:44, 2016 September 22 (CDT)

===2016-Sep-22===
Rolled out. [[User:Haubel|Haubel]] 07:54, 2016 September 22 (CDT) 
* Rolled back to previous version.  It was reported that centralized_data.mdb was not found.-- [[p:Herman Aubel]]

===2016-Sep-21===
Rolled out. [[User:Haubel|Haubel]] 22:56, 2016 September 21 (CDT) 
* Fixed field order for [[CRRT]] so that it sorts properly in Temp Study, item column dropdown list.-- [[p:Herman Aubel]]

===2016-Sep-20===
rolled out - restored to previous version as yesterdays roll out has a bug in it. [[User:TOstryzniuk|Trish Ostryzniuk]] 10:10, 2016 September 20 (CDT)

===2016-Sep-19===
rolled out Ttenbergen 16:58, 2016 September 19 (CDT)
* changed [[GRA_EMIP]] in [[s_dispo table]] to be available in [[Previous Location field]], was somehow missed Ttenbergen 16:10, 2016 September 19 (CDT)
* added control for [[GCS sedated field]] to [[Patient viewer]] apache tab Ttenbergen 16:28, 2016 September 19 (CDT)
* added control for ''Accept DtTm missing field'' to [[Patient viewer]] dispo tab Ttenbergen 16:28, 2016 September 19 (CDT)
* fixed some labels in [[Patient viewer]] that were not yet URLS to link to corresponding articles. Ttenbergen 16:54, 2016 September 19 (CDT)

===2016-Sep-16===
Rolled out. [[User:Haubel|Haubel]] 12:06, 2016 September 19 (CDT) 
* Fixed field order for [[CRRT]] so that it sorts properly in Temp Study, item column dropdown list.-- [[p:Herman Aubel]]

===2016-Sep-15-2===
rolled out Ttenbergen 17:31, 2016 September 15 (CDT)
* added field "order" to [[s_tmp table]] table
* updated form Viewer and form TmpV2_editor to use the new order field 
* added fields for [[CRRT]] to [[s_tmp table]] table

===2016-Sep-15===
rolled out Ttenbergen 17:09, 2016 September 15 (CDT)
* changes to facilitate [[CCMDB_data.mdb_Change_Log#2016-Sept-15]]Ttenbergen 10:29, 2016 September 15 (CDT)

===2016-Sep-14===
rolled out Ttenbergen 17:35, 2016 September 14 (CDT)
* added numbers to the [[s_Priorities table]] (11-20)) - this means '''there will be more numbers available in the diagnosis and acquired priority now'''. 
* added some "unknown" subchoices to [[s_dispo table]] as per email from Julie Ttenbergen 17:35, 2016 September 14 (CDT)

===2016-Sep-07===
rolled Ttenbergen 11:13, 2016 September 8 (CDT)
* change to [[s_dispo table]]: removed test entry "foo" Ttenbergen 13:56, 2016 September 7 (CDT)
* added the ADL tab back in for CC. Checkboxes got misalinged with it not there, and since it would show only for Medicine there was no easy way to keep them aligned. Ttenbergen 14:45, 2016 September 7 (CDT)
* updated [[ACP_Status_collection_in_ICU#CCDMB_Data_Integrity_Checks]]: 
** removed checks from function ''Temp_Checker_in_viewer()''
** updated query ''s_tmp_ACP''

=== 2016-Sept-1 ===
rolled Ttenbergen 15:00, 2016 September 1 (CDT)
* change to [[s_dispo table]]: made column "site" consistent with hospital for all entries for hospitals where we collect. Ttenbergen 15:00, 2016 September 1 (CDT)

=== 2016-Aug-31-3 ===
rolled Ttenbergen 17:40, 2016 August 31 (CDT)
* added Children's ICU to [[s_dispo table]] Ttenbergen 17:20, 2016 August 31 (CDT)

=== 2016-Aug-31-2 ===
rolled out - [[User:JMojica|JMojica]] 13:57, 2016 August 31 (CDT)
*change real name and ward  fields of s_dispo (i.e. STB_MICU to STB_ICMS, STB_CICU to STB_ICCS, CON_MICU to CON ICU, GRA_MICU to GRA ICU, OAK_MICU to OAK ICU, VIC_MICU to VIC ICU, STB_B5old to STB E6, STB_B4 to STB_B5)

=== 2016-Aug-31 ===
rolled out - Ttenbergen 10:16, 2016 August 31 (CDT)
* updated [[s_tmp table]] for [[ACP Status Collection in ICU]] to have a "not documented" line for both status and source Ttenbergen 09:58, 2016 August 31 (CDT)

=== 2016-Aug-29-2 ===
rolled out Ttenbergen 15:15, 2016 August 29 (CDT)
* added query ''2016-08-29_off_ward_fixer'' to run once and move content of pharm_complete field into off-ward field; this is to fix aftermath of the off-ward control being linked to pharm_complete field. Ttenbergen 15:08, 2016 August 29 (CDT)
** added to form_open event for main_form. Ttenbergen 15:08, 2016 August 29 (CDT)
* [[ACP Status Collection in ICU]] 
** confirmed that [[ACP_Status_collection_in_ICU#pairs_of_records]] works Ttenbergen 14:38, 2016 August 29 (CDT)
** updated query ''s_tmp_ACP'' to list missing int or date. Ttenbergen 14:59, 2016 August 29 (CDT)
* changed ADL tab to be visible only in Medicine Ttenbergen 14:38, 2016 August 29 (CDT)

=== 2016-Aug-29 ===
rolled out [[User:JMojica|JMojica]] 11:25, 2016 August 29 (CDT)
* fix the STB stepdown entry in [[s_dispo table]]

=== 2016-Aug-25 ===
rolled out Ttenbergen 19:12, 2016 August 25 (CDT)
* in form_view, corrected connection to the [[Off ward field]] - it had been wrongly connected the pharm_complete field. Ttenbergen 09:36, 2016 August 25 (CDT)
* clean-up: deleted table ''s_HospitalCodes_pre2015-07-06'' Ttenbergen 13:58, 2016 August 25 (CDT)
* tweaked form ''MainForm'' to show buttons, there is some glitch where it doesn't open full size. Ttenbergen 13:58, 2016 August 25 (CDT)
* integrating [[s_dispo table]] changes from Julie: 
** Manitoba Adolescent Treatment Center geog changed to WPG
** Whitmouth District Health Center has been changed to Whitemount District Health Center
** added a field "RHA", populated from Julie's table, filled WRHA for rest as appropriate
** added stepdown units HSC A3SDU, D3SDU, and A5SDU and STB A4SDU

=== 2016-Aug-22-2 ===
rolled out Ttenbergen 12:52, 2016 August 22 (CDT)
* changed [[s_dispo table]] entries for STB B5 to have ward B5 as well to make internally consistent with earlier changes Ttenbergen 12:52, 2016 August 22 (CDT)

=== 2016-Aug-22 ===
rolled out.  Ttenbergen 12:00, 2016 August 22 (CDT)
* updated [[Sedatives/Antidepressants]] to have the word "antidepressants" in it again, somehow that wasn't in [[s_AllDiagnoses table]] table even though was like that on wiki. Ttenbergen 11:57, 2016 August 22 (CDT)

=== 2016-Aug-18 ===
rolled out Ttenbergen 16:23, 2016 August 18 (CDT)
* inactivated old entries in [[s_tmp table]] table: 
** PostalCode - old [[Postal code collection]], now collected in [[Postal Code field]]
** Srv to ICU - old [[Service Sending to ICU]], now collected in [[Previous Service field]]

=== 2016-Aug-15 ===
rolled out Ttenbergen 15:38, 2016 August 15 (CDT)
* updated overstay to treat [[Chronic Health Facility]] in the same way as a [[Personal Care Home]]. Ttenbergen 15:38, 2016 August 15 (CDT)
** updated Function ''pt_is_from_PCH()''

=== 2016-Aug-04 ===
rolled Ttenbergen 16:45, 2016 August 4 (CDT)
* [[s_dispo table]]: 
** changed center numbers for [[STB_CCU]], [[STB_ACCU]], [[STB_CICU]] as per Julie
** after discussion with Julie re importing new data, changed
*** [[STB_B5]] to [[STB_B5old]]
*** STB_5B to [[STB_B5]]
* table [[s_locations_allowed_collection table]]
** changed where r_location pulls from to s_dispo
** changed relationship from s_locations to s_dispo
** changed STB_CCU to STB_ACCU

=== 2016-Aug-03 ===
rolled out Ttenbergen 11:19, 2016 August 4 (CDT)
* [[s_dispo table]]: 
** made [[STB_SICU]] inactive and changed to "STB_SICU (Legacy)". Ttenbergen 14:24, 2016 August 3 (CDT)
** inactivated [[STB_CCU]] and added [[STB_ACCU]] Ttenbergen 09:55, 2016 August 4 (CDT)
* updated table ''20160706_dispo''; was GRA Ward W3 -> GRA_N3, now -> GRA_S3 Ttenbergen 15:47, 2016 August 3 (CDT)

=== 2016-Jul-28 ===
rolled out Ttenbergen 10:06, 2016 July 28 (CDT)
* updated query ''L_Pharm_FlowSheet_sum'' and Sub ''PharmCheck()'' to use new dispo fields Ttenbergen 09:07, 2016 July 28 (CDT)

=== 2016-Jul-25-2 ===
rolled Ttenbergen 16:39, 2016 July 25 (CDT)
* in [[s_dispo table]], changed "HSC Cath Lab" to "HSC Cardiac cath lab", and "STB Cath Lab" to "STB Cardiac cath lab" Ttenbergen 16:22, 2016 July 25 (CDT)

=== 2016-Jul-25 ===
rolled out Ttenbergen 16:13, 2016 July 25 (CDT)
* DX codes
** inactivated code 12600 for [[Eclampsia]]
** fixed spelling for "Endometreitis" to "Endometritis" in [[Peripartum Problems]] and [[Postpartum problems other]]
** changed dx 13004 Torsades de Pointes to maindx Tachyarrythmias. Fixed [[Torsades De Pointes]], [[Tachyarrythmias]], [[Bradyarrythmias]]
* added view-only of accept and arrive dates to top of Apache tab, since that's when it needs to be known, and is used differently for Medicine vs. Critical Care Ttenbergen 10:51, 2016 July 25 (CDT)
* in [[s_dispo table]] fixed "Thompson-Thompson - ICU" to "Thompson - ICU"
* eliminated pre-dispo fields from patient viewer form and references from VBA Ttenbergen 11:17, 2016 July 25 (CDT)
* moved Dispo Tab to very left to replace old Reg/var/ADL tab
* renamed old Reg/var/ADL tab to "ADL"
* moved '''[[Province]], [[DOB]], [[Sex]], [[Registry Patient Type|Pt Type]], [[LTV]]''' fields to Dispo tab
* changed layout of medical records report to stop printing second page Ttenbergen 11:39, 2016 July 25 (CDT)

=== 2016-Jul-15 ===
rolled out Ttenbergen 13:26, 2016 July 15 (CDT)
* updated query ''send_Centralized_1L_Log__intermediate'' to use s_dispo table Ttenbergen 13:03, 2016 July 15 (CDT)
* updated query ''send_set_oLog_to_sent'' to use service_location instead of r_location Ttenbergen 13:20, 2016 July 15 (CDT)

=== 2016-Jul-11 ===
rolled Ttenbergen 17:59, 2016 July 11 (CDT)
* added [[ACCU borrow]] entries to [[s_tmp table]] table Ttenbergen 17:50, 2016 July 11 (CDT)
* added STB_5b_x to [[s_dispo table]] Ttenbergen 17:59, 2016 July 11 (CDT)

=== 2016-Jul-07-2 ===
rolled Ttenbergen 17:26, 2016 July 8 (CDT)
* more updates to s_tables to accomodate [[Conversion of old registry fields to new dispo fields]] Ttenbergen 15:29, 2016 July 8 (CDT)
* update to query ''send_phi'' Ttenbergen 17:26, 2016 July 8 (CDT)

=== 2016-Jul-07 ===
rolled Ttenbergen 14:52, 2016 July 7 (CDT)
* updated  - added "legacy empty" for [[Conversion of old registry fields to new dispo fields]]
** [[s_pre_acute_living_situation table]] 
** updated [[s_previous_service table]]
* updated query ''send_PHI'', PHI was not getting proper D_IDs Ttenbergen 14:52, 2016 July 7 (CDT)

=== 2016-Jul-06 ===
rolled Ttenbergen 09:57, 2016 July 7 (CDT)
* updated [[s_dispo table]] by adding records needed for [[Conversion of old registry fields to new dispo fields]]
** previous Location - done
* updated tmp_checker to no longer require [[Service Sending to ICU]]

=== 2016-Jul-05-3 ===
rolled out Ttenbergen 17:14, 2016 July 5 (CDT)
* update to query ''Patient_List'' to fix report ''MR_List_Oldest_discharge_first'' ([[MR List]]) Ttenbergen 17:12, 2016 July 5 (CDT)

=== 2016-Jul-05-2 ===
rolled Ttenbergen 10:38, 2016 July 5 (CDT)
* updated function Validate_Accept_DtTm() with better error message.
* removed sub dispo_yellower, integrated content with Sub Reg_Yellower() instead, there had been duplication. Ttenbergen 10:24, 2016 July 5 (CDT)
* updated [[Function Dispo Chronological()]] to make accept/arrive checks same for Med and ICU Ttenbergen 10:24, 2016 July 5 (CDT)
* updated form_view to show on top "Arrive DtTm" instead of admit, and [[Dispo_DtTm]] instead of discharge Ttenbergen 10:37, 2016 July 5 (CDT)

=== 2016-Jul-05 ===
rolled out Ttenbergen 09:53, 2016 July 5 (CDT)
* updated function Overlap() to cope with discharge dates that are null. Doesn't need to cope with null admit dates because those are not allowed as part of [[Minimal Data Set]]. Ttenbergen 09:53, 2016 July 5 (CDT) 
* updated function Validate_Accept_DtTm() to cope with non-ER cases. Ttenbergen 09:53, 2016 July 5 (CDT)

=== 2016-Jul-04-4 ===
rolled out Ttenbergen 14:52, 2016 July 4 (CDT)
* updated Function LOS() and PharmCheck() to use new fields Ttenbergen
* Temp_Checker_in_viewer() stop postal code checking for dispo_dttm > 2016-07-01

* Transition_Coordinator_colour() admit dttm
* pt_is_from_PCH()
* changed s_tmp table so Overstay - "Enter where from" is no longer automatically entered for new patients, and no longer active. Using [[Pre acute living situation]] instead now for this.

=== 2016-Jul-04-3 ===
rolled Ttenbergen 11:34, 2016 July 4 (CDT)
* updated Dispo_Chronological() to require accept before arrive from ER only for medicine patients. Ttenbergen 11:34, 2016 July 4 (CDT)

=== 2016-Jul-04-2 ===
rolled Ttenbergen 10:49, 2016 July 4 (CDT)
* query ''Check_ORDx__not_from_OR_OrDx''

=== 2016-Jul-04 ===
rolled out Ttenbergen 10:16, 2016 July 4 (CDT)
* updated to use [[Service/Location]] to make [D_ID]
** query ''Send_Centralized_L_Como__intermediate''
** query ''Send_Centralized_L_Dxs__intermediate''
** query ''Send_Centralized_L_Pharm_Flowsheet__intermediate''
** query ''Send_Centralized_L_TmpV2__intermediate''

=== 2016-Jun-30-2 ===
rolled out Ttenbergen 16:44, 2016 July 3 (CDT)
* updates to change to new fields and eliminate checks of old fields after June 2016
** function ''Validate_Survive_Expire()''
** function ''AdFrom_same_ICU()''
** function ''DisTo_same_ICU()''
** function ''DisTo_Emerg()''
** function ''Validate_Var1()''
** function ''Validate_Var2()''
** query ''check_OR_from_but_not_Surgical_Type''
** query ''check_tmp_no_transfer_date'' 
** query ''s_tmp_CCU_Service_shouldntve''
** query ''s_tmp_ER_Wait_chronological''
** query ''s_tmp_ER_Wait_from_ER_no_ER_Wait''
** query ''s_tmp_ER_Wait_has_tmp_not_from_ER''
** [[query s_tmp_QAInf_LT_48_hrs_after_admit]]
** query ''s_tmp_Service_Sending_to_ICU''

* clean-up of old content (deleted)
** query ''check_peer_audit_audit_serial_reg_send''
** query ''check_peer_audit_invalid_serial_audited''
** query ''check_peer_audit_location_bad''
** query ''s_tmp_ACP-old''
** query ''s_tmp_Transfusion_count
** query ''s_tmp_transfusion_gt_5min
** report ''SentReport''
** report ''SentReport CompleteNow subreport''

* added check for 00:00 to functions Validate_Accept_DtTm(), Validate_Arrive_DtTm(), Validate_Dispo_DtTm()
* [[s_dispo table]] - added STB Hospice Ttenbergen 17:02, 2016 June 30 (CDT)

* [[Patient List]]
** query ''Patient_List''
** form ''PatientList'' and its VBA
** [[MR List]] report ''MR_List_Oldest_discharge_first''

* added [[off ward field]] to send queries
** query ''Send_Centralized_1L_Log_append''
** query ''Send_Centralized_1L_Log_update''
** query ''send_Centralized_1L_Log__intermediate''

* change how [[D_ID]] is generated to use [[Service/Location field]] Ttenbergen 16:41, 2016 July 3 (CDT)
** query ''Send_Centralized_1L_Log_append''

=== 2016-Jun-30 ===
rolled Ttenbergen 09:27, 2016 June 30 (CDT)
* [[query check_minimal_data_set_incomplete]] - confirmed "[Arrive_DtTm]>Nz([Transfer_Ready_DtTm]"
* updated tab order of new [[off ward field]] to be consistent with rest of form; this might have caused a few accidental entries in that field if people hit "space" at the wrong time while not in another field. Ttenbergen 09:24, 2016 June 30 (CDT)

=== 2016-Jun-28-3 ===
rolled out Ttenbergen 20:16, 2016 June 28 (CDT)
* [[query check_minimal_data_set_incomplete]] - removed check for accept dttm and other fixes to that query Ttenbergen 20:07, 2016 June 28 (CDT)

=== 2016-Jun-28-2 ===
rolled Ttenbergen 11:12, 2016 June 28 (CDT)
* updated [[query check_minimal_data_set_incomplete]], was doing wrong check for dispo_dttm Ttenbergen 11:05, 2016 June 28 (CDT)

=== 2016-Jun-28 ===
rolled Ttenbergen 10:13, 2016 June 28 (CDT)
* fixed problem marker I had set up and forgot to remove, displayed as "is this still live?" Ttenbergen 09:54, 2016 June 28 (CDT)
* fixed function from_ER, bad table name Ttenbergen 10:02, 2016 June 28 (CDT)

=== 2016-Jun-27 ===
rolled out Ttenbergen 20:24, 2016 June 27 (CDT)
* updated [[query check_previous_location_vs_service_inconsistent]] to allow Nephrology for HSC Medicine wards; also changed the CCU check to allow only critical care or cardiology Ttenbergen 09:48, 2016 June 27 (CDT)
* update to function Panelling_admit_transfer_same(Pat_ID) Ttenbergen 10:34, 2016 June 27 (CDT)
** include both [[Panelling or Discharge Planning]] codes (90601, 90601)
* updated [[Off ward field]], it was set to invisible
* updated checks for ''Accept DtTm field''; the field is now required only if the pt came from ER 

Updating to ignore patients with [[Dispo DtTm]] after 2016-07-01
* Sub ''RnVars_Yellower()''
* Function ''AdFrom_Var1_reconcile()
* Function ''DisTo_Var2_reconcile()
* Function long_LOS()
* Function Hosp_Previous_Admit()
* query ''Check_ORDx__from_OR_no_ORDx''
* query ''Check_ORDx__not_from_OR_OrDx''
* [[Minimal Data Set]]

=== 2016-Jun-23 ===
rolled out Ttenbergen 17:02, 2016 June 23 (CDT)
* added [[off_ward field]]

=== 2016-Jun-22 ===
rolled out Ttenbergen 16:59, 2016 June 22 (CDT)
* update to PHIN cross check, it didn't allow numbers > 130000000 but the error didn't explain that; check is still for same, but now error is fixed Ttenbergen 10:32, 2016 June 22 (CDT)
* cross-check for [[Panelling or Discharge Planning]] and [[Transfer Ready DtTm field]]
** the old check was done twice, got rid of the one in tmp_checker using query ''check_panelled_primary_but_adm_NE_tr'', will now only run from Panelling_admit_transfer_same(Pat_ID), deleted query
* added code to load [[CCMDB_data.mdb_Change_Log#2016-Jun-22]] Ttenbergen 16:57, 2016 June 22 (CDT)

=== 2016-Jun-20 ===
rolled outTtenbergen 10:35, 2016 June 20 (CDT)
* updated [[Query Check_Renal_IncompatibleDxs]] which was giving false errors for patients with CRF and certain renal dxs.  Ttenbergen 09:56, 2016 June 20 (CDT)

=== 2016-Jun-16 ===
rolled out Ttenbergen 16:55, 2016 June 16 (CDT)
* fix [[Previous Service field]] cross check: updated [[query check_previous_location_vs_service_inconsistent]] to exclude CCU from checks, since CCU pts can be from Cardiology. Ttenbergen 10:19, 2016 June 16 (CDT)
* for inpatient transfers within the region, Previous location and Pre-admit inpatient institution should be same.
** created [[query check_prev_pre-admit_consistent]] to list when not so
** created function ''prev_pre_admit_consistent'' to check that query
** added call to that function to ''RnVars_Yellower''

=== 2016-Jun-09 ===
rolled Ttenbergen 16:59, 2016 June 13 (CDT)

* dispo cross check
** [[cross check]] to make sure that patients with [[Previous Location field]] critical care have [[Previous Service field]] critical care, and patients from medicine have previous service medicine; [[query check_previous_location_vs_service_inconsistent]] and function ''previous_location_vs_service_inconsistent'' Ttenbergen 13:53, 2016 June 13 (CDT)

* changed timing of call to function Transfer_Ready_DtTm_vs_Location_vs_Dispo so it isn't a gopher triplet; should only be called once now. Ttenbergen 09:43, 2016 June 13 (CDT)        

* Changed wording for [[Fournier's gangrene (fulminating tissue infection of perineum)]] to ...perineum rather than ...scrotum. Ttenbergen 12:43, 2016 June 9 (CDT)

* [[s_dispo table]]
** renamed/added fields, see http://ccmdb.kuality.ca/index.php?title=S_dispo_table&type=revision&diff=48643&oldid=47159
** removed HSC_B3S, had been added by mistake, emailed Judy about it Ttenbergen 14:05, 2016 June 9 (CDT)
** populated some fields as requested by email from JMojica
** changed RRs and ORs to not be inpatient locations and to be temporary Ttenbergen 09:11, 2016 June 13 (CDT)

* tmp
** updated overstay ''enter "from"'' to ''enter where from'' because the double-quotes were breaking form tmp_editor Ttenbergen 10:39, 2016 June 13 (CDT)
** tmp tab - added "sort" button to re-sort once ACPs have been entered; the recent autosort I added was making it difficult to enter things, this button can be used to sort when entry is done Ttenbergen 11:39, 2016 June 13 (CDT)

=== 2016-Jun-08-2 ===
rolled Ttenbergen 16:36, 2016 June 8 (CDT)
* [[Alias ID collection]] - changed collection options, see article for detail.

=== 2016-Jun-08 ===
rolled Ttenbergen 10:48, 2016 June 8 (CDT)
* fixes starting with ver 2016-Jun-06
* fixed query ''s_tmp_ACP_unpaired'' to exclude records for "not documented" Ttenbergen 10:22, 2016 June 8 (CDT)

=== 2016-Jun-02 ===
reverted to this version for now to let people work while we work out what went wrong. Ttenbergen 09:28, 2016 June 8 (CDT)

=== 2016-Jun-07 ===
*this version not good - causing staff to not be able to open CCMDB at all. Staff instructed to use time to catch up and WIKI, recent changes, question, answers, clean up instructions.[[User:TOstryzniuk|Trish Ostryzniuk]] 13:58, 2016 June 7 (CDT) 
rolled Ttenbergen 10:14, 2016 June 7 (CDT)
* commented out the line Still_Good = Still_Good And Not Reject_a_query("s_tmp_ACP_unpaired", "The following patients do not have a pair of records for at least one ACP entry. See http://ccmdb.kuality.ca/index.php?title=ACP_Status_collection_in_ICU") located in the Tmp_Checker module of CCMDB. 09:59, 2016 June 7 (CDT)

=== 2016-Jun-06 ===
rolled Ttenbergen 16:46, 2016 June 6 (CDT)
* changed tmp tab to help organize [[ACP Status Collection in ICU]]: sort by integer first, before sorting by other fields. This would become messy if we use the integer for something else in the future but should work nice for now. Ttenbergen 10:28, 2016 June 6 (CDT)
* added check to ensure paired records for [[ACP Status Collection in ICU]]. Ttenbergen 10:50, 2016 June 6 (CDT)
* added button to make [[Previous Location field]] equal to [[Pre-admit Inpatient Institution field]]. Ttenbergen 11:57, 2016 June 6 (CDT)
* added query ''check_dispo_lower_acuity_than_location'' and Function ''Transfer_Ready_DtTm_vs_Location_vs_Dispo'' to [[cross check]] for allowed missing [[Transfer_Ready_DtTm_field]] but to launch question window if missing Ttenbergen 14:13, 2016 June 6 (CDT)

=== 2016-Jun-02 ===
rolled out Ttenbergen 17:31, 2016 June 2 (CDT)
* changed GRA_W3  to GRA_S3 to table ''s_tmp_er_wait_r_locations'' Ttenbergen 09:51, 2016 June 2 (CDT)
* disabled check for [[Visit Admit DtTm field]] in ''Function Dispo_Chronological()''; the content of the field is direct copy from EPR so might be inconsistent with actual arrival and/or accept times Ttenbergen 09:56, 2016 June 2 (CDT)
* [[Query s tmp apostrophe in comment]] was not giving proper error message, does now. Ttenbergen 10:05, 2016 June 2 (CDT)
* confirmed that all ERs are '''not available''' in dropdown for [[Dispo field]]. Ttenbergen 11:14, 2016 June 2 (CDT)
* updated query ''Send_Centralized_1L_Log_update'', which was not updating [[Dispo_DtTm field]] properly Ttenbergen 13:48, 2016 June 2 (CDT)

=== 2016-May-27 ===
rolled Ttenbergen 10:04, 2016 May 27 (CDT)
* fixed new GRA_S3, wasn't visible. Ttenbergen 10:04, 2016 May 27 (CDT)

=== 2016-May-26-2 ===
rolled Ttenbergen 17:54, 2016 May 26 (CDT)
* LongLOS for Dispo
** added fields to [[s_dispo table]]: meanLOS3STD and workshare_real Ttenbergen 17:04, 2016 May 26 (CDT)
** created new code in Function long_LOS() to check the new dispo fields Ttenbergen 17:04, 2016 May 26 (CDT)

=== 2016-May-26 ===
rolled Ttenbergen 13:38, 2016 May 26 (CDT)
* [[GRA W3]] -> [[GRA_S3]] changes: Ttenbergen 13:01, 2016 May 26 (CDT)
** s_dispo added
** s_locations added
** s_varOptions added
* updated s_dispo table to cope with workload shared locations; removed the _a locations from previous inpatient location dropdown. Ttenbergen 09:55, 2016 May 26 (CDT)
* internal [[cross check]] review
** made Dispo_Yellower use same method as View_Yellower. Ttenbergen 10:18, 2016 May 26 (CDT)
** changed ADL_Yellower to use same method as View_Yellower. Ttenbergen 10:18, 2016 May 26 (CDT)
* implemented [[Function Dispo Chronological()‎‎]] Ttenbergen 13:35, 2016 May 26 (CDT)

=== 2016-May-25-2 ===
rolled out Ttenbergen 13:08, 2016 May 25 (CDT)
* fixed [[s_dispo table]] and [[s_locations_allowed_collection table]] to allow collection of [[HSC CCU]] Ttenbergen 12:57, 2016 May 25 (CDT)

=== 2016-May-25 ===
rolled Ttenbergen 11:42, 2016 May 25 (CDT)
* updated [[s_dispo table]] to cope with workload shared locations. Ttenbergen 11:13, 2016 May 25 (CDT)
* updated [[s_locations_allowed_collection table]] table to allow for sorting "usual" to top Ttenbergen 11:28, 2016 May 25 (CDT)
* updated query ''s_serviceLocation_local'' to new sorting; I entered what I thought would be right but '''if you'd like a different sorting for your location please comment at [[s_locations_allowed_collection table]].''' Ttenbergen 11:36, 2016 May 25 (CDT)
* added HSC_B3S to [[s_dispo table]] Ttenbergen 11:40, 2016 May 25 (CDT)

=== 2016-May-20 ===
rolled Ttenbergen 10:09, 2016 May 20 (CDT)
* fix for [[Service/Location field]] empty Ttenbergen 09:52, 2016 May 20 (CDT)
* fix for [[s_dispo table]] to populate location_name properly for new rural OR and RR entries Ttenbergen 10:09, 2016 May 20 (CDT)

=== 2016-May-19 ===
rolled out Ttenbergen 14:37, 2016 May 19 (CDT)
* updated the [[ACP Status Collection in ICU]] entry for Orders so that only the "enter" one is automatically populated. Ttenbergen 10:28, 2016 May 19 (CDT)
* added OR and RR to out-of-town s_dispo entries Ttenbergen 11:04, 2016 May 19 (CDT)
* removed "?" button from [[Service/Location field]], since it will only be allowed local entries, so list will be short Ttenbergen 11:04, 2016 May 19 (CDT)
* updated dropdown for [[Service/Location field]] to only show options allowed for this laptop based on the settings. Ttenbergen 11:07, 2016 May 19 (CDT)

=== 2016-May-11 ===
rolled Ttenbergen 17:35, 2016 May 16 (CDT)
* changed "urologic" to "urology" in [[s_previous_service table]] Ttenbergen 09:52, 2016 May 11 (CDT)
* updated patient view to have the following entries fill the available height on the laptop screens that are now larger than when the program was initially designed. Ttenbergen 13:58, 2016 May 16 (CDT)
** dx
** como
** labs
** tmp
** pharm
* removed all ERs from being options in [[Dispo field]]
* added [[HSC_EMIP]] Ttenbergen 14:59, 2016 May 16 (CDT)

=== 2016-May-09 ===
rolled Ttenbergen 17:38, 2016 May 9 (CDT)
* added location to [[MR List]] Ttenbergen 10:39, 2016 May 9 (CDT)
* [[ACP Status Collection in ICU]]: 
** updated query ''s_tmp_ACP'' to only trigger if ''Arrive DtTm field'' >= 2016-05-01
** made the old options with begin and end unavailable Ttenbergen 14:10, 2016 May 9 (CDT)

=== 2016-May-06 ===
rolled Ttenbergen 09:14, 2016 May 6 (CDT)
* correction to sending changes from yesterday Ttenbergen 09:14, 2016 May 6 (CDT)

=== 2016-May-05 ===
rolled out Ttenbergen 17:19, 2016 May 5 (CDT)
* adding [[cross check]]s for [[2016 Time and Place changes]] Ttenbergen 15:12, 2016 May 5 (CDT)
** made fields mandatory not empty to check registry checkbox complete Ttenbergen 15:12, 2016 May 5 (CDT)
** made ''Transfer_Ready_DtTm_vs_status()'' to check [[Transfer Ready DtTm field]] against [[TR info status field]] Ttenbergen 15:12, 2016 May 5 (CDT)
** [[Postal_Code_field#CCDMB_Data_Integrity_Checks]] Ttenbergen 15:34, 2016 May 5 (CDT)
* added [[TR_info_status field]] to sending, changed queries
** send_Centralized_1L_Log__intermediate
** Send_Centralized_1L_Log_append
** Send_Centralized_1L_Log_update

=== 2016-May-04 ===
rolled out Ttenbergen 16:36, 2016 May 4 (CDT)
* [[ACP_Status_collection_in_ICU#CCDMB_Data_Integrity_Checks]] Ttenbergen 16:07, 2016 May 4 (CDT)

=== 2016-May-03 ===
rolled Ttenbergen 12:14, 2016 May 3 (CDT)
* changed dropdown for [[Previous Service field]]
** "direct admit" taken out, the new structure does not need it Ttenbergen 10:47, 2016 May 3 (CDT)
** added "Neurology" and "Oncology"
* added fields for [[ACP Status Collection in ICU]] Ttenbergen 12:11, 2016 May 3 (CDT)

=== 2016-Apr-25 ===
rolled Ttenbergen 19:10, 2016 April 28 (CDT)
* [[s_dispo table]]:
** made sure that all the PCH entries are not available as [[Pre-admit Inpatient Institution field]]; confirmed with Allan Garland that these are not inpatient situations. Ttenbergen 09:25, 2016 April 27 (CDT)
** simplified and shortened some names as discussed with Julie, Trish and Laura Ttenbergen 16:05, 2016 April 27 (CDT)
** inactivated a buncha wards as we don't collect on, thanks for the heads-up Laura
* [[s_previous_service table]] - added "critical care" for completeness Ttenbergen 17:03, 2016 April 27 (CDT)
* added [[TR info status field]] Ttenbergen 19:05, 2016 April 28 (CDT)
* changed code to cope with [[CCMDB_data.mdb_Change_Log#2016-04-28]] Ttenbergen 19:05, 2016 April 28 (CDT)

=== 2016-Apr-25 ===
rolled Ttenbergen 19:59, 2016 April 25 (CDT)
* updated Dispo tab layout; some labels had got separated from their fields. Ttenbergen 17:28, 2016 April 25 (CDT)
* updated [[s_dispo table]]:
** [[HSC Nursing Home Ward]]:  entry for "HSC Nursing Home" to not mention (GG7) any longer. Ttenbergen 18:08, 2016 April 25 (CDT)
** shortened hospital names (town only or town/name where applicable) Ttenbergen 18:59, 2016 April 25 (CDT)
** changed gra_w3 to gra_s3 Ttenbergen 19:59, 2016 April 25 (CDT)
* added [[2016 Time and Place changes]] fields to [[sending]]
** updated query ''send_Centralized_1L_Log__intermediate'' Ttenbergen 19:14, 2016 April 25 (CDT)
** updated query ''Send_Centralized_1L_Log_update'' Ttenbergen 19:30, 2016 April 25 (CDT)
** updated query ''Send_Centralized_1L_Log_append'' Ttenbergen 19:30, 2016 April 25 (CDT)

=== 2016-Apr-18 ===
rolled Ttenbergen 19:26, 2016 April 18 (CDT)
* Added "N/A" button for [[Postal Code field‎]] Ttenbergen 16:31, 2016 April 18 (CDT)
* changed "left AMA" to "AMA (left against medical advice)" so it pops up if collector starts typing "AMA" Ttenbergen 16:31, 2016 April 18 (CDT)
* added filter to fields in "S dispo chooser" to only show the entries actually allowed for the field that started the form (e.g. no "died" in previous location) Ttenbergen 18:28, 2016 April 18 (CDT)
* updated sub ''Convert_DB()'' to download [[CCMDB_data.mdb_Change_Log#2016-04-18]] Ttenbergen 18:48, 2016 April 18 (CDT)
* added [[Visit Admit DtTm field]] in dispo tab Ttenbergen 19:02, 2016 April 18 (CDT)
* added "Manitoba PCH outside of Winnipeg" and "Winnipeg PCH" to [[s_dispo table]] Ttenbergen 19:14, 2016 April 18 (CDT)

=== 2016-Apr-14 (shows as 2016-Apr-13) ===
rolled Ttenbergen 17:56, 2016 April 14 (CDT)
* took "HSC" out of default settings for form ''s_dispo_chooser'' Ttenbergen 12:27, 2016 April 14 (CDT)
* added STB_EMIP to s_dispo table Ttenbergen 14:47, 2016 April 14 (CDT)
* wiggled query ''send_check_centralized_is_owner'' but nothing got changed. Even though, re-saving it seems to have fixed an issue Pagasa had re-sending dome data. Ttenbergen 15:44, 2016 April 14 (CDT)

=== 2016-Apr-13 ===
rolled Ttenbergen 16:32, 2016 April 13 (CDT)
* changed the "magic" buttons on the Dispo tab to "?" buttons to be consistent with the buttons used in the diagnosis tab; there the "?" button opens the filter and the "magic want" button re-sorts the list. Ttenbergen 14:57, 2016 April 13 (CDT)
* changed hover-overs for these buttons to say "open filter wizard" Ttenbergen 14:57, 2016 April 13 (CDT)
* added hints to [[Dispo field]]: died and AMA Ttenbergen 14:57, 2016 April 13 (CDT)
* added button to set ''Accept_DtTm field'' to ''Arrive_DtTm field'' for convenience since they are often the same. Ttenbergen 15:46, 2016 April 13 (CDT)
* updated validation for DOB, it would not error properly when empty in some circumstances. Ttenbergen 15:59, 2016 April 13 (CDT)

=== 2016-Apr-11 ===
rolled Ttenbergen 18:24, 2016 April 11 (CDT)
* fixed [[Patient List]] form sorting button for [[LastOpened DtTm field]], had not been working Ttenbergen 15:40, 2016 April 11 (CDT)
* changed tab order to Pre-acute Living Situation -> Postal Code -> Pre-Admit Inpatient Institution (if applicable) -> Previous Location, then DtTm -> Previous Service with DtTm next -> Service Location -> Transfer Ready DtTm -> Dispo DtTm -> Dispo Ttenbergen 15:43, 2016 April 11 (CDT)

=== 2016-Apr-07-2 ===
rolled earlier today Ttenbergen 15:40, 2016 April 11 (CDT)
* deleted old tmp tables starting with 1_ and old queries 1_tmp_* - Ttenbergen 15:32, 2016 April 7 (CDT)
* deleted old query "Check_Como_UniquePriority" Ttenbergen 15:41, 2016 April 7 (CDT)
* removed the code that moved cursor to start of [[Transfer_Ready_DtTm field]] Ttenbergen 13:53, 2016 April 11 (CDT)

=== 2016-Apr-07 ===
rolled out Ttenbergen 12:19, 2016 April 7 (CDT)
* changed the sort order of [[Previous Service field]] drop down but only did after roll-out, will go out with next. Ttenbergen 10:04, 2016 April 5 (CDT)
* fixed +/- buttons for [[Dispo DtTm field]] - thanks Con for flagging! Ttenbergen 12:19, 2016 April 7 (CDT)
* updated input mask for [[Transfer Ready DtTm field]], it wasn't allowing typed entry - thanks Con for flagging! Ttenbergen 12:19, 2016 April 7 (CDT)
* There are still ''Accept_DtTm_field#editing_difficulties | editing difficulties'' - see there for details on a new thing to try. Ttenbergen 12:19, 2016 April 7 (CDT)

=== 2016-Apr-05 ===
rolled Ttenbergen 09:55, 2016 April 5 (CDT)
* changed when time is written to [[LastOpened DtTm field]], previous version hung up when other changes to the data were also madeTtenbergen 10:04, 2016 April 5 (CDT)
* fixed hover hint for the close with and without update buttons, it had been opposite of what button said Ttenbergen 10:04, 2016 April 5 (CDT)
* changes sort order for pre-admit inpatient location Ttenbergen 10:04, 2016 April 5 (CDT)

=== 2016-Apr-04-2 ===
rolled Ttenbergen 14:58, 2016 April 4 (CDT)
* [[LastOpened DtTm field]] - removed automated update when opening file and added a "reviewed" button in [[Patient Viewer]] instead - Ttenbergen 13:24, 2016 April 4 (CDT) 
** '''Collectors: I have disabled the "x" button for this form, you will now have to use either the close with or without changes buttons.''' Ttenbergen 14:56, 2016 April 4 (CDT)
* some additional clean-up in patient viewer module that should have no impact, just cleaned out dead code Ttenbergen 13:24, 2016 April 4 (CDT)
* '''Accept_DtTm_field#editing_difficulties | date/time fields in 2016 Time and Place changes''' - changed so they should be properly editable now, please see article, try and let me know how goes in the article at the link Ttenbergen 14:56, 2016 April 4 (CDT)

=== 2016-Apr-04 ===
rolled Ttenbergen 12:00, 2016 April 4 (CDT)
* added option "CICU" for [[CCU Service Tracking]], see change in collection instruction on that page - Ttenbergen 11:41, 2016 April 4 (CDT)
** added option to [[s_tmp table]] table - Ttenbergen 11:41, 2016 April 4 (CDT)
** updated query ''s_tmp_CCU_Service_shouldntve'' to allow STB_CICU to enter - Ttenbergen 11:41, 2016 April 4 (CDT)

=== 2016-Mar-31 ===
rolled Ttenbergen 11:45, 2016 March 31 (CDT)
* made "home" available in [[s_dispo table]], it had unintentionally become inactive Ttenbergen 11:16, 2016 March 31 (CDT)
* [[Project_ABO_TEE#CCDMB_Data_Integrity_Checks]] - updated [[cross check]] to only trigger when [[RecordStatus]] complete Ttenbergen 11:16, 2016 March 31 (CDT)

=== 2016-Mar-24 ===
rolled Ttenbergen 19:35, 2016 March 25 (CDT)
''' before rolling, fix db converter break'''
* [[Alias ID collection]] - added required entry to [[s_tmp table]] table
* more [[2016 Time and Place changes]]
** '''changed the labels for all the fields on the dispo tab to hyperlinks to the wiki, ie you can click the label and it will take you to the article about the field''' Ttenbergen 20:39, 2016 March 24 (CDT)
** changed [[Previous Service field]] to say "not on our list", "not" was missing
** added in [[Transfer Ready DtTm field]] Ttenbergen 14:58, 2016 March 24 (CDT)
** updated DtTm fields to not show or require seconds Ttenbergen 14:58, 2016 March 24 (CDT)
** added input masks to the dates so you don't need to enter the ":" and such Ttenbergen 20:05, 2016 March 24 (CDT)
** updated [[s_dispo table]] table so [[Previous Location field]] can now contain ERs from rural Manitoba Ttenbergen 20:46, 2016 March 24 (CDT)
** made label for [[LastOpened DtTm field]] into link to wiki Ttenbergen 21:10, 2016 March 24 (CDT)
** added button to open "S dispo chooser" to [[Pre-admit Inpatient Institution field]] button, had missed that on first round Ttenbergen 21:46, 2016 March 24 (CDT)

* [[Project ABO TEE]] [[cross check]]s: reviewed query ''s_tmp_ABO_TEE_checks''
* [[Medical Incompetency tracking]] - was still available to collect, made unavailable Ttenbergen 18:18, 2016 March 25 (CDT)

=== 2016-Mar-21 ===
rolled out Ttenbergen 13:51, 2016 March 22 (CDT)
* [[2016 Time and Place changes]]
** updating new dispo tab dropdowns
** reviewed ''[[s_pre_acute_living_situation table]]'' and linked into form Ttenbergen 11:35, 2016 March 21 (CDT)
** reviewed ''[[s_previous_service table]]'' and linked into form Ttenbergen 11:35, 2016 March 21 (CDT)
** reviewed ''[[s_dispo table]]'' and link into forms Ttenbergen 13:42, 2016 March 22 (CDT)
** updated form "s_dispo chooser" and how it is triggered from form [[Patient viewer]] Ttenbergen 13:42, 2016 March 22 (CDT)
* added "Nephrology" and "unknown" to [[S_previous_service_table]] and [[s_tmp table]] for [[Service Sending to ICU]] Ttenbergen 17:21, 2016 March 21 (CDT)

=== 2016-Mar-16 ===
rolled Ttenbergen 17:44, 2016 March 16 (CDT)
* made [[Med Var 5]] OVZ for collection of [[OVER]] available for Medicine at STB Ttenbergen 10:56, 2016 March 16 (CDT)
* fixed [[ACP_Status_collection_in_ICU#CCDMB_Data_Integrity_Checks]]
** added query ''s_tmp_ACP'' Ttenbergen 12:17, 2016 March 16 (CDT)
** added code in ''s_tmp_ACP'' to run query Ttenbergen 12:17, 2016 March 16 (CDT)
* Patient Viewer Form
** Increased size of components to make use of the laptops we have now, these were still small from old laptops Ttenbergen 15:28, 2016 March 16 (CDT)
** added screen to pilot [[2016 Time and Place changes]]
* ccmdb_data: updated code to pull [[CCMDB_data.mdb_Change_Log#2016-03-16]]
* PatientList: added column for [[LastOpened_DtTm field]]and code to set it automatically; the column is not manually editable. Ttenbergen 17:39, 2016 March 16 (CDT)

=== 2016-Mar-14-2 ===
not rolled yet Ttenbergen 13:52, 2016 March 14 (CDT)
* Test rolled to STB_CICU and HSC_A4; had unrelated issues with news and backup for both, holding off for now. 

* deleted table Pharm_out, not sure what that was even about Ttenbergen 13:52, 2016 March 14 (CDT)
* updated module DB_Converter to accommodate new [[CCMDB_data.mdb_Change_Log#2016-03-07]] Ttenbergen 14:41, 2016 March 14 (CDT)

=== 2016-Mar-14 ===
rolled out Ttenbergen 10:24, 2016 March 14 (CDT)
* updated table ''[[S locations allowed collection table]]'' 
** content:
*** listed the new STB_EMIP properly for all STB Medicine laptops
*** removed entry STB_5B_x
*** removed old STB_B5 laptop entries
** structure: update fields to be dropdowns based on table ''[[S Locations]]''

=== 2016-Mar-07 ===
rolled Ttenbergen 13:38, 2016 March 7 (CST)
* added "STB_EMIP" to table [[S Locations]] Ttenbergen 13:38, 2016 March 7 (CST)

=== 2016-Feb-29 ===
rolled out Ttenbergen 16:38, 2016 February 29 (CST)
* WRHA changed policy on [[VRE, ESBL and MRO Colonization]] so removed from table [[s_AllDiagnoses table]] the following because we are no longer screening for colonization: 
** 9900 - Colonization with Resistant Organisms (without Infection) with any pathogen
** 9922 - VRE colonization
** 9924 - ESBL colonization
* keeping only explicit 9948; since that's last remaining colonization, changing article name to [[MRSA Colonization (without Infection)]]

=== 2016-Feb-25 ===
rolled Ttenbergen 15:52, 2016 February 25 (CST)
* added "PEI" to "New Brunswick  /  Newfoundland  /  Nova Scotia" in [[S HospitalCodes table]] Ttenbergen 15:50, 2016 February 25 (CST)

=== 2016-Feb-17 ===
rolled Ttenbergen 12:24, 2016 February 17 (CST)
* fixed spelling for [[Friedreich's Ataxia]] Ttenbergen 12:10, 2016 February 17 (CST)

=== 2016-Feb-08 ===
(this must have been rolled because the version was feb 9 after this...)
* addressing [[:Category:Unusually coded infections]]: 
** making c-diff pathogen unavailable for coding 
*** added "active" column to [[S_Pathogens table]] Ttenbergen 14:43, 2016 February 8 (CST)
*** made all except [[Clostridium difficile]] active Ttenbergen 14:43, 2016 February 8 (CST)
*** updated the dropdown in the patient view, diagnosis tab, to list only active pathogens Ttenbergen 14:43, 2016 February 8 (CST)
** discussed coding for [[Viral Hepatitis]] and left as is, because it already only allows collection of this in one way, even if that way is inconsistent with other pathogen coding. Ttenbergen 14:52, 2016 February 8 (CST)
** [[Meningoencephalitis]] 
*** disabled collection for 7700 with pathogen, has to be collected as explicit dx to prevent invalid combinations Ttenbergen 14:52, 2016 February 8 (CST)

=== 2016-Jan-25 ===
rolled out Ttenbergen 13:00, 2016 February 1 (CST)
* added [[Medical Incompetency tracking]] Ttenbergen 16:10, 2016 January 25 (CST)
** disabled because we are not ready Ttenbergen 12:54, 2016 February 1 (CST)
* added query 's_tmp_ABO_TEE_checks' to implement checks for [[Project ABO TEE]] Ttenbergen 12:54, 2016 February 1 (CST)

=== 2016-Jan-21 ===
rolled Ttenbergen 08:49, 2016 January 21 (CST)
* tweak to yesterdays update

=== 2016-Jan-20 ===
rolled Ttenbergen 15:40, 2016 January 20 (CST)
* changed forms to make it impossible to add, delete or edit comos. Thanks to Joanna for making me aware this was not locked out. Ttenbergen 11:53, 2016 January 20 (CST)
** ComoChooser
** DxChooser

=== 2016-Jan-11 ===
Rolled out Ttenbergen 22:09, 2016 January 11 (CST)
* added to s_varoptions S5, new psych location for GRA. Ttenbergen 17:19, 2016 January 11 (CST)
* corrected query ''s_tmp_ER_Wait_long_delay'' for [[ER Wait]], it was not detecting anything. '''Collectors will have to put a comment in tmp if the delay is > 3 days.''' The error msg will remind them about this. Ttenbergen 17:19, 2016 January 11 (CST)
* added query '''s_tmp_ER_Wait_duplicate_entry''' - doesn't allow more than one [[ER Wait]] entry. Ttenbergen 22:02, 2016 January 11 (CST)
*both HSC_ICUd and HSC_ICUa laptops accepted the change - Lori

=== 2016-Jan-06 ===
rolled Ttenbergen 13:18, 2016 January 6 (CST)
* updated form dxChooser to exclude dxs with collection_allowed = false Ttenbergen 13:17, 2016 January 6 (CST)

[[Category:CCMDB.accdb]]
[[Category:Change Logs CCMDB]]