CCMDB.mdb Change Log 2016

From CCMDB Wiki
Jump to navigationJump to search

see Log (disambiguation) for other uses of the term "Log" see the 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-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 Haubel 12:27, 2016 December 8 (CST)

2016-Dec-07

(was rolled out)Ttenbergen Changes collectors will want to know:

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)

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)

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. 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. Haubel 13:27, 2016 November 9 (CST)

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:
  • 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 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 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 Haubel 14:28, 2016 November 3 (CDT)
    • Commented out Public Const Dispo_transition_cate Haubel 15:44, 2016 November 3 (CDT)

2016-Oct-31

rolled out Ttenbergen 11:42, 2016 November 3 (CDT)

2016-Oct-27-2

rolled Ttenbergen 15:40, 2016 October 27 (CDT)

2016-Oct-27

rolled out Ttenbergen 10:01, 2016 October 27 (CDT)

2016-Oct-20

rolled out Ttenbergen 17:13, 2016 October 26 (CDT)

2016-Oct-13

rolled out Ttenbergen 11:11, 2016 October 13 (CDT)

2016-Sep-29-2

rolled out Ttenbergen 14:09, 2016 October 12 (CDT)

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

2016-Sep-29

rolled out Ttenbergen 10:25, 2016 September 29 (CDT)

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

2016-Sep-26

rolled out Ttenbergen 16:17, 2016 September 26 (CDT)

  • fixed PHIN label in Patient Viewer, had accidentally got changed last round Ttenbergen 09:44, 2016 September 26 (CDT)
  • in s_dispo table changed care level for HSC_H6 to 6 to no longer require a Transfer Ready DtTm for transfers there. Ttenbergen 10:59, 2016 September 26 (CDT)

2016-Sep-22-2

rolled Ttenbergen 16:50, 2016 September 22 (CDT)

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

2016-Sep-22

Rolled out. Haubel 07:54, 2016 September 22 (CDT)

  • Rolled back to previous version. It was reported that centralized_data.mdb was not found.-- p:Herman Aubel

2016-Sep-21

Rolled out. Haubel 22:56, 2016 September 21 (CDT)

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

2016-Sep-20

rolled out - restored to previous version as yesterdays roll out has a bug in it. Trish Ostryzniuk 10:10, 2016 September 20 (CDT)

2016-Sep-19

rolled out Ttenbergen 16:58, 2016 September 19 (CDT)

2016-Sep-16

Rolled out. Haubel 12:06, 2016 September 19 (CDT)

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

2016-Sep-15-2

rolled out Ttenbergen 17:31, 2016 September 15 (CDT)

  • added field "order" to S Tmp table
  • updated form Viewer and form TmpV2_editor to use the new order field
  • added fields for CRRT to s_tmp table

2016-Sep-15

rolled out Ttenbergen 17:09, 2016 September 15 (CDT)

2016-Sep-14

rolled out Ttenbergen 17:35, 2016 September 14 (CDT)

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

2016-Sep-07

rolled Ttenbergen 11:13, 2016 September 8 (CDT)

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

2016-Sept-1

rolled Ttenbergen 15:00, 2016 September 1 (CDT)

  • change to s_dispo table: made column "site" consistent with hospital for all entries for hospitals where we collect. Ttenbergen 15:00, 2016 September 1 (CDT)

2016-Aug-31-3

rolled Ttenbergen 17:40, 2016 August 31 (CDT)

  • added Children's ICU to s_dispo table Ttenbergen 17:20, 2016 August 31 (CDT)

2016-Aug-31-2

rolled out - 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)

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
  • changed ADL tab to be visible only in Medicine Ttenbergen 14:38, 2016 August 29 (CDT)

2016-Aug-29

rolled out JMojica 11:25, 2016 August 29 (CDT)

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)

2016-Aug-18

rolled out Ttenbergen 16:23, 2016 August 18 (CDT)

2016-Aug-15

rolled out Ttenbergen 15:38, 2016 August 15 (CDT)

2016-Aug-04

rolled Ttenbergen 16:45, 2016 August 4 (CDT)

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
  • 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, 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)

2016-Jul-07

rolled Ttenbergen 14:52, 2016 July 7 (CDT)

2016-Jul-06

rolled Ttenbergen 09:57, 2016 July 7 (CDT)

2016-Jul-05-3

rolled out Ttenbergen 17:14, 2016 July 5 (CDT)

  • update to query Patient_List to fix report MR_List_Oldest_discharge_first (MR List) Ttenbergen 17:12, 2016 July 5 (CDT)

2016-Jul-05-2

rolled Ttenbergen 10:38, 2016 July 5 (CDT)

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

2016-Jul-05

rolled out Ttenbergen 09:53, 2016 July 5 (CDT)

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

2016-Jul-04-4

rolled out Ttenbergen 14:52, 2016 July 4 (CDT)

  • updated Function LOS() and PharmCheck() to use new fields Ttenbergen
  • Temp_Checker_in_viewer() stop postal code checking for dispo_dttm > 2016-07-01
  • Transition_Coordinator_colour() admit dttm
  • pt_is_from_PCH()
  • changed s_tmp table so Overstay - "Enter where from" is no longer automatically entered for new patients, and no longer active. Using Pre acute living situation instead now for this.

2016-Jul-04-3

rolled Ttenbergen 11:34, 2016 July 4 (CDT)

  • updated Dispo_Chronological() to require accept before arrive from ER only for medicine patients. Ttenbergen 11:34, 2016 July 4 (CDT)

2016-Jul-04-2

rolled Ttenbergen 10:49, 2016 July 4 (CDT)

  • query Check_ORDx__not_from_OR_OrDx

2016-Jul-04

rolled out Ttenbergen 10:16, 2016 July 4 (CDT)

  • updated to use Service/Location to make [D_ID]
    • query Send_Centralized_L_Como__intermediate
    • query Send_Centralized_L_Dxs__intermediate
    • query Send_Centralized_L_Pharm_Flowsheet__intermediate
    • query Send_Centralized_L_TmpV2__intermediate

2016-Jun-30-2

rolled out Ttenbergen 16:44, 2016 July 3 (CDT)

  • updates to change to new fields and eliminate checks of old fields after June 2016
    • function Validate_Survive_Expire()
    • function AdFrom_same_ICU()
    • function DisTo_same_ICU()
    • function DisTo_Emerg()
    • function Validate_Var1()
    • function Validate_Var2()
    • query check_OR_from_but_not_Surgical_Type
    • query check_tmp_no_transfer_date
    • query s_tmp_CCU_Service_shouldntve
    • query s_tmp_ER_Wait_chronological
    • query s_tmp_ER_Wait_from_ER_no_ER_Wait
    • query s_tmp_ER_Wait_has_tmp_not_from_ER
    • query s_tmp_QAInf_LT_48_hrs_after_admit
    • query s_tmp_Service_Sending_to_ICU
  • clean-up of old content (deleted)
    • query check_peer_audit_audit_serial_reg_send
    • query check_peer_audit_invalid_serial_audited
    • query check_peer_audit_location_bad
    • query s_tmp_ACP-old
    • query s_tmp_Transfusion_count
    • query s_tmp_transfusion_gt_5min
    • report SentReport
    • report SentReport CompleteNow subreport
  • added check for 00:00 to functions Validate_Accept_DtTm(), Validate_Arrive_DtTm(), Validate_Dispo_DtTm()
  • s_dispo table - added STB Hospice Ttenbergen 17:02, 2016 June 30 (CDT)
  • Patient List
    • query Patient_List
    • form PatientList and its VBA
    • MR List report MR_List_Oldest_discharge_first
  • added off ward field to send queries
    • query Send_Centralized_1L_Log_append
    • query Send_Centralized_1L_Log_update
    • query send_Centralized_1L_Log__intermediate
  • change how D_ID is generated to use Service/Location field Ttenbergen 16:41, 2016 July 3 (CDT)
    • query Send_Centralized_1L_Log_append

2016-Jun-30

rolled Ttenbergen 09:27, 2016 June 30 (CDT)

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

2016-Jun-28-3

rolled out Ttenbergen 20:16, 2016 June 28 (CDT)

2016-Jun-28-2

rolled Ttenbergen 11:12, 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)

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)

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)

2016-Jun-16

rolled out Ttenbergen 16:55, 2016 June 16 (CDT)

2016-Jun-09

rolled Ttenbergen 16:59, 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)
  • 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)

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.Trish Ostryzniuk 13:58, 2016 June 7 (CDT)

rolled Ttenbergen 10:14, 2016 June 7 (CDT)

2016-Jun-06

rolled Ttenbergen 16:46, 2016 June 6 (CDT)

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

2016-Jun-02

rolled out Ttenbergen 17:31, 2016 June 2 (CDT)

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

2016-May-27

rolled Ttenbergen 10:04, 2016 May 27 (CDT)

  • fixed new GRA_S3, wasn't visible. Ttenbergen 10:04, 2016 May 27 (CDT)

2016-May-26-2

rolled Ttenbergen 17:54, 2016 May 26 (CDT)

  • LongLOS for Dispo
    • added fields to s_dispo table: meanLOS3STD and workshare_real Ttenbergen 17:04, 2016 May 26 (CDT)
    • created new code in Function long_LOS() to check the new dispo fields Ttenbergen 17:04, 2016 May 26 (CDT)

2016-May-26

rolled Ttenbergen 13:38, 2016 May 26 (CDT)

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

2016-May-25-2

rolled out Ttenbergen 13:08, 2016 May 25 (CDT)

2016-May-25

rolled Ttenbergen 11:42, 2016 May 25 (CDT)

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

2016-May-20

rolled Ttenbergen 10:09, 2016 May 20 (CDT)

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

2016-May-19

rolled out Ttenbergen 14:37, 2016 May 19 (CDT)

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

2016-May-11

rolled Ttenbergen 17:35, 2016 May 16 (CDT)

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

2016-May-09

rolled Ttenbergen 17:38, 2016 May 9 (CDT)

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

2016-May-06

rolled Ttenbergen 09:14, 2016 May 6 (CDT)

  • correction to sending changes from yesterday Ttenbergen 09:14, 2016 May 6 (CDT)

2016-May-05

rolled out Ttenbergen 17:19, 2016 May 5 (CDT)

2016-May-04

rolled out Ttenbergen 16:36, 2016 May 4 (CDT)

2016-May-03

rolled Ttenbergen 12:14, 2016 May 3 (CDT)

  • changed dropdown for Previous Service field
    • "direct admit" taken out, the new structure does not need it Ttenbergen 10:47, 2016 May 3 (CDT)
    • added "Neurology" and "Oncology"
  • added fields for ACP Status collection in ICU Ttenbergen 12:11, 2016 May 3 (CDT)

2016-Apr-25

rolled Ttenbergen 19:10, 2016 April 28 (CDT)

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

2016-Apr-25

rolled Ttenbergen 19:59, 2016 April 25 (CDT)

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

2016-Apr-18

rolled Ttenbergen 19:26, 2016 April 18 (CDT)

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

2016-Apr-14 (shows as 2016-Apr-13)

rolled Ttenbergen 17:56, 2016 April 14 (CDT)

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

2016-Apr-13

rolled Ttenbergen 16:32, 2016 April 13 (CDT)

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

2016-Apr-11

rolled Ttenbergen 18:24, 2016 April 11 (CDT)

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

2016-Apr-07-2

rolled earlier today Ttenbergen 15:40, 2016 April 11 (CDT)

  • deleted old tmp tables starting with 1_ and old queries 1_tmp_* - Ttenbergen 15:32, 2016 April 7 (CDT)
  • deleted old query "Check_Como_UniquePriority" Ttenbergen 15:41, 2016 April 7 (CDT)
  • removed the code that moved cursor to start of Transfer_Ready_DtTm field Ttenbergen 13:53, 2016 April 11 (CDT)

2016-Apr-07

rolled out Ttenbergen 12:19, 2016 April 7 (CDT)

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

2016-Apr-05

rolled Ttenbergen 09:55, 2016 April 5 (CDT)

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

2016-Apr-04-2

rolled Ttenbergen 14:58, 2016 April 4 (CDT)

  • LastOpened DtTm field - removed automated update when opening file and added a "reviewed" button in Patient Viewer instead - Ttenbergen 13:24, 2016 April 4 (CDT)
    • Collectors: I have disabled the "x" button for this form, you will now have to use either the close with or without changes buttons. Ttenbergen 14:56, 2016 April 4 (CDT)
  • some additional clean-up in patient viewer module that should have no impact, just cleaned out dead code Ttenbergen 13:24, 2016 April 4 (CDT)
  • 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)

2016-Mar-24

rolled Ttenbergen 19:35, 2016 March 25 (CDT) before rolling, fix db converter break

2016-Mar-21

rolled out Ttenbergen 13:51, 2016 March 22 (CDT)

2016-Mar-16

rolled Ttenbergen 17:44, 2016 March 16 (CDT)

2016-Mar-14-2

not rolled yet Ttenbergen 13:52, 2016 March 14 (CDT)

  • Test rolled to STB_CICU and HSC_A4; had unrelated issues with news and backup for both, holding off for now.
  • deleted table Pharm_out, not sure what that was even about Ttenbergen 13:52, 2016 March 14 (CDT)
  • updated module DB_Converter to accommodate new CCMDB_data.mdb_Change_Log#2016-03-07 Ttenbergen 14:41, 2016 March 14 (CDT)

2016-Mar-14

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

  • updated table S locations allowed collection table
    • content:
      • listed the new STB_EMIP properly for all STB Medicine laptops
      • removed entry STB_5B_x
      • removed old STB_B5 laptop entries
    • structure: update fields to be dropdowns based on table S Locations

2016-Mar-07

rolled Ttenbergen 13:38, 2016 March 7 (CST)

  • added "STB_EMIP" to table S Locations Ttenbergen 13:38, 2016 March 7 (CST)

2016-Feb-29

rolled out Ttenbergen 16:38, 2016 February 29 (CST)

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)

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 HSC_ICUd and HSC_ICUa laptops accepted the change - Lori

2016-Jan-06

rolled Ttenbergen 13:18, 2016 January 6 (CST)

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