CCMDB.mdb Change Log 2016: Difference between revisions

(114 intermediate revisions by 3 users not shown)

Line 8:

== Versions ==

===2016-~~Oct~~-12===

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

not rolled ~~yet~~ Ttenbergen 14:31, 2016 October 12 (CDT)

* moved the [[Postal Code field]] and [[Province ~~field~~]] closer to the [[Pre-admit Inpatient Institution field]] Ttenbergen 14:31, 2016 October 12 (CDT)

=== 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.mdb_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 checks 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===

Line 24:

Line 196:

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

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

Line 35:

Line 207:

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

* added ''Accept_DtTm_missing_field'' and [[GCS sedated field]]

* confirmed that GRA_EMIP now available as previous location

* in [[Patient Viewer]]

Line 47:

Line 219:

===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.-- [[Herman Aubel]]

* 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.-- [[Herman Aubel]]

* Fixed field order for [[CRRT]] so that it sorts properly in Temp Study, item column dropdown list.-- [[p:Herman Aubel]]

===2016-Sep-20===

Line 60:

Line 232:

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

* 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.-- [[Herman Aubel]]

* 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

* 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

* added fields for [[CRRT]] to [[s_tmp table]] table

===2016-Sep-15===

Line 79:

Line 251:

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

Line 136:

Line 308:

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

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

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

Line 156:

Line 328:

*** [[STB_B5]] to [[STB_B5old]]

*** STB_5B to [[STB_B5]]

* table ''s_locations_allowed_collection''

* table [[s_locations_allowed_collection table]]

** changed where r_location pulls from to s_dispo

** changed relationship from s_locations to s_dispo

Line 181:

Line 353:

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

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

Line 197:

Line 369:

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

Line 227:

Line 399:

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

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

Line 268:

Line 440:

** function ''Validate_Var1()''

** function ''Validate_Var2()''

** query ''[[check_OR_from_but_not_Surgical_Type]]''

** query ''check_OR_from_but_not_Surgical_Type''

** query ''check_tmp_no_transfer_date''

** query ''s_tmp_CCU_Service_shouldntve''

Line 274:

Line 446:

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

** query ''s_tmp_Service_Sending_to_ICU''

Line 300:

Line 472:

** query ''send_Centralized_1L_Log__intermediate''

* change how [[D_ID]] is generated to use [[~~Service_Location~~]] Ttenbergen 16:41, 2016 July 3 (CDT)

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

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

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

* updated [[query check_minimal_data_set_incomplete]], was doing wrong check for dispo_dttm Ttenbergen 11:05, 2016 June 28 (CDT)

=== 2016-Jun-28 ===

Line 323:

Line 495:

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

* 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

* 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

Line 352:

Line 524:

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

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

* 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 [[query check_prev_pre-admit_consistent]] to list when not so

** created ~~function~~ function ''prev_pre_admit_consistent'' to check that query

** created function ''prev_pre_admit_consistent'' to check that query

** added call to that function to ''RnVars_Yellower''

Line 366:

Line 538:

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

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

Line 410:

Line 582:

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

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

Line 438:

Line 610:

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

* 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 to allow for sorting "usual" to top Ttenbergen 11:28, 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]].''' Ttenbergen 11:36, 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)

Line 475:

Line 647:

* 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

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

Line 530:

Line 702:

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

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

Line 546:

Line 718:

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

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

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

Line 565:

Line 737:

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

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

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

Line 575:

Line 747:

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

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

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

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

Line 594:

Line 766:

rolled Ttenbergen 19:35, 2016 March 25 (CDT)

''' before rolling, fix db converter break'''

* [[Alias ID collection]] - added required entry to [[s_tmp]] table

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

Line 602:

Line 774:

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

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

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

Line 615:

Line 787:

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

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

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

Line 628:

Line 800:

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

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

Line 639:

Line 811:

=== 2016-Mar-14 ===

rolled out Ttenbergen 10:24, 2016 March 14 (CDT)

* updated table ''[[S locations allowed collection]]''

* updated table ''[[S locations allowed collection table]]''

** content:

*** listed the new STB_EMIP properly for all STB Medicine laptops

Line 652:

Line 824:

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

* 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

Line 670:

Line 842:

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

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

Line 698:

Line 870:

* 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

*both HSC_ICUd and HSC_ICUa laptops accepted the change - Lori

=== 2016-Jan-06 ===

Line 704:

Line 876:

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

[[Category: CCMDB.~~mdb~~]]

[[Category:CCMDB.accdb]]

[[Category: Change Logs CCMDB]]

@@ Line 8: / Line 8: @@
 == Versions ==
-===2016-Oct-12===
+*go to [[CCMDB.mdb Change Log 2017]]
-not rolled yet Ttenbergen 14:31, 2016 October 12 (CDT)
-* moved the [[Postal Code field]] and [[Province field]] closer to the [[Pre-admit Inpatient Institution field]] Ttenbergen 14:31, 2016 October 12 (CDT)
+=== 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.mdb_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 checks 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===
@@ Line 24: / Line 196: @@
 ** 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)
+* 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===
@@ Line 35: / Line 207: @@
 * 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]]
+* added ''Accept_DtTm_missing_field'' and [[GCS sedated field]]
 * confirmed that GRA_EMIP now available as previous location
 * in [[Patient Viewer]]
@@ Line 47: / Line 219: @@
 ===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.-- [[Herman Aubel]]
+* 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.-- [[Herman Aubel]]
+* Fixed field order for [[CRRT]] so that it sorts properly in Temp Study, item column dropdown list.-- [[p:Herman Aubel]]
 ===2016-Sep-20===
@@ Line 60: / Line 232: @@
 * 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)
+* 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.-- [[Herman Aubel]]
+* 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
+* 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
+* added fields for [[CRRT]] to [[s_tmp table]] table
 ===2016-Sep-15===
@@ Line 79: / Line 251: @@
 ===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 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)
@@ Line 136: / Line 308: @@
 === 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)
+* 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:
+* 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]]
@@ Line 156: / Line 328: @@
 *** [[STB_B5]] to [[STB_B5old]]
 *** STB_5B to [[STB_B5]]
-* table ''s_locations_allowed_collection''
+* table [[s_locations_allowed_collection table]]
 ** changed where r_location pulls from to s_dispo
 ** changed relationship from s_locations to s_dispo
@@ Line 181: / Line 353: @@
 ** 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]]
+** 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"
@@ Line 197: / Line 369: @@
 === 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 [[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)
@@ Line 227: / Line 399: @@
 * 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)
+* 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 ===
@@ Line 268: / Line 440: @@
 ** function ''Validate_Var1()''
 ** function ''Validate_Var2()''
-** query ''[[check_OR_from_but_not_Surgical_Type]]''
+** query ''check_OR_from_but_not_Surgical_Type''
 ** query ''check_tmp_no_transfer_date''
 ** query ''s_tmp_CCU_Service_shouldntve''
@@ Line 274: / Line 446: @@
 ** 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_QAInf_LT_48_hrs_after_admit]]
 ** query ''s_tmp_Service_Sending_to_ICU''
@@ Line 300: / Line 472: @@
 ** query ''send_Centralized_1L_Log__intermediate''
-* change how [[D_ID]] is generated to use [[Service_Location]] Ttenbergen 16:41, 2016 July 3 (CDT)
+* 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]"
+* [[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)
+* [[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)
+* updated [[query check_minimal_data_set_incomplete]], was doing wrong check for dispo_dttm Ttenbergen 11:05, 2016 June 28 (CDT)
 === 2016-Jun-28 ===
@@ Line 323: / Line 495: @@
 === 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)
+* 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
+* 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
@@ Line 352: / Line 524: @@
 === 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)
+* 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)
+* 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 [[query check_prev_pre-admit_consistent]] to list when not so
-** created function function ''prev_pre_admit_consistent'' to check that query
+** created function ''prev_pre_admit_consistent'' to check that query
 ** added call to that function to ''RnVars_Yellower''
@@ Line 366: / Line 538: @@
 * 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)
+** 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)
@@ Line 410: / Line 582: @@
 * 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)
+* [[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)
@@ Line 438: / Line 610: @@
 === 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)
+* 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 to allow for sorting "usual" to top Ttenbergen 11:28, 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]].''' Ttenbergen 11:36, 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)
@@ Line 475: / Line 647: @@
 * 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
+** 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)
@@ Line 530: / Line 702: @@
 * 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)
+* 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)
@@ Line 546: / Line 718: @@
 * 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)
+* 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)
+* 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)
@@ Line 565: / Line 737: @@
 * 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)
+* 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)
+* 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)
@@ Line 575: / Line 747: @@
 === 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)
+* [[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)
+* '''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)
+** 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)
@@ Line 594: / Line 766: @@
 rolled Ttenbergen 19:35, 2016 March 25 (CDT)
 ''' before rolling, fix db converter break'''
-* [[Alias ID collection]] - added required entry to [[s_tmp]] table
+* [[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)
@@ Line 602: / Line 774: @@
 ** 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)
+** 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)
+** 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''
@@ Line 615: / Line 787: @@
 ** 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)
+** 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)
+* 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 ===
@@ Line 628: / Line 800: @@
 ** 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)
+* 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 ===
@@ Line 639: / Line 811: @@
 === 2016-Mar-14 ===
 rolled out Ttenbergen 10:24, 2016 March 14 (CDT)
-* updated table ''[[S locations allowed collection]]''
+* updated table ''[[S locations allowed collection table]]''
 ** content:
 *** listed the new STB_EMIP properly for all STB Medicine laptops
@@ Line 652: / Line 824: @@
 === 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:
+* 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
@@ Line 670: / Line 842: @@
 * 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)
+*** 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)
@@ Line 698: / Line 870: @@
 * 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
+*both HSC_ICUd and HSC_ICUa laptops accepted the change - Lori
 === 2016-Jan-06 ===
@@ Line 704: / Line 876: @@
 * updated form dxChooser to exclude dxs with collection_allowed = false Ttenbergen 13:17, 2016 January 6 (CST)
-[[Category: CCMDB.mdb]]
+[[Category:CCMDB.accdb]]
 [[Category: Change Logs CCMDB]]