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 ==
=== 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 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: 
** 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'' 
** 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 Pointe]], [[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 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]] 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 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)
* apostrophe checker for tmp notes 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]] 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 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]].''' 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 checks 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 [[Last Opened 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 [[Last Opened 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)
* [[Last Opened 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 - 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
* 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 [[Last Opened 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 checks: 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]] 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 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]]'' 
** 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]] 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 [[Table S Pathogens]] 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 ICUd and 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.mdb]]
[[Category: Change Logs CCMDB]]