CCMDB Wiki

CCMDB.mdb Change Log 2015: Difference between revisions

← Older edit
m u
m Text replacement - "[[Category: " to "[[Category:"
 
(161 intermediate revisions by 2 users not shown)
Line 1: Line 1:
__NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. -->
'''''see [[Log (disambiguation)]] for other uses of the term "Log"
'''''see [[Log (disambiguation)]] for other uses of the term "Log"
''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''
''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''
Line 7: Line 8:


== Versions ==
== Versions ==
=== 2015-Dec-16 ===
rolled Ttenbergen 16:38, 2015 December 16 (CST)
* cross-checks for [[ACP Status Collection in ICU]] Ttenbergen 16:21, 2015 December 16 (CST)
=== 2015-Nov-25 ===
rolled. - Ttenbergen 10:02, 2015 December 8 (CST)
* [[Service Sending to ICU]] - made checks run only for CC Ttenbergen 10:02, 2015 December 8 (CST)
=== 2015-Nov-25 ===
rolled out Ttenbergen 22:27, 2015 December 7 (CST)
* [[Service Sending to ICU]]
** [[cross check]]s: all ICU patients must have an entry and the "item" can not be "enter" or "". Ttenbergen 20:49, 2015 December 7 (CST)
** auto entry: every new ICU patient will have a record in tmp tab for this, but item will be "enter" and must be updated. Ttenbergen 20:49, 2015 December 7 (CST)
** added option "z_not an inpatient" Ttenbergen 22:27, 2015 December 7 (CST)
=== 2015-Nov-16 ===
rolled to all, ie the changes that were beta tested at HSC are now rolled to all as well. Ttenbergen 10:34, 2015 November 16 (CST)
* updated the dxChooser form to list only dxs where collection_allowed is true (Thanks Joyce for pointing out this problem) Ttenbergen 10:34, 2015 November 16 (CST)
=== 2015-Nov-10 ===
rolled to HSC for testing. Ttenbergen 11:51, 2015 November 10 (CST)
* updated the database checks to only run upon changed if the checkbox is already set. Without this would have brought up a bunch of gophers for incomplete patients.
=== 2015-Oct-19 ===
Beta rolled to HSC as discussed with Trish. Ttenbergen 18:02, 2015 November 9 (CST)
* removed boarding column from [[s_dispo table]] Ttenbergen 16:55, 2015 October 19 (CDT)
* deleted query ''1_sDispoOutputter'' Ttenbergen 16:55, 2015 October 19 (CDT)
* reviewed table ''s_preAcuteLivingSituation'' that was added previously but not documented Ttenbergen 17:04, 2015 October 19 (CDT)
* added table ''s_previousService'' Ttenbergen 17:04, 2015 October 19 (CDT)
* made inactive [[Respiratory Arrest]] Ttenbergen 13:45, 2015 October 22 (CDT)
* added checks to catch if changes are made to a record after the checkboxes are set to complete:
** added checks to '''DX''' form for deletes and inserts, updates were already checked Ttenbergen 16:42, 2015 November 9 (CST)
** added checks to '''Como''' form for deletes and inserts and updates, there were not any inside that form, just called from checkbox  Ttenbergen 16:42, 2015 November 9 (CST)
** added checks for '''Labs''' form for deletes and inserts and updates, there were not any inside that form, just called from checkbox Ttenbergen 17:31, 2015 November 9 (CST)
** added checks for '''Pharm''' form for deletes and inserts and updates, there were not any inside that form, just called from checkbox Ttenbergen 17:31, 2015 November 9 (CST)
** added checks for '''Tmp''' form for deletes and inserts and updates, there were not any inside that form, just called from checkbox Ttenbergen 17:34, 2015 November 9 (CST)
=== 2015-Oct-02 ===
rolled Ttenbergen 17:08, 2015 October 2 (CDT)
* removed STB A5 from [[S Locations]]. Ttenbergen 13:27, 2015 October 2 (CDT)
* updated Var1/var2 to not be mandatory for ICU... this had changed at some point, can't remember details, and Gail pointed out the problem. Ttenbergen 13:39, 2015 October 2 (CDT)
=== 2015-Sep-21 ===
rolled Ttenbergen 13:07, 2015 September 21 (CDT)
* fixed wording for [[Neurodevelopmental disorder]], had made a mistake cut/pasting it. Ttenbergen 13:07, 2015 September 21 (CDT)
=== 2015-Sep-16 ===
rolled Ttenbergen 16:51, 2015 September 17 (CDT)
* confirmed that "Caesarian Section" is in table [[Check_ORDx]]
* added [[HIPEC - Hyperthermic IntraPeritoneal Chemotherapy]] Ttenbergen 16:44, 2015 September 17 (CDT)
* added [[Neurodevelopmental disorder]] Ttenbergen 16:44, 2015 September 17 (CDT)
=== 2015-Aug-17 ===
rolled out Ttenbergen 09:20, 2015 August 24 (CDT)
* [[Panelling_or_Discharge_Planning#CCDMB_Data_Integrity_Checks]]
** imported query ''Primary_admit'' from [[CFE]] and updated for use in [[CCMDB.accdb]]
** added query ''check_panelled_primary_but_adm_NE_tr''
** added check to module Tmp_Checker Ttenbergen 16:06, 2015 August 17 (CDT)
* fixed [[Transfer_Ready_date_and_time#CCDMB_Data_Integrity_Checks]] for ICU, it was letting through empties as long as there was anything in the Notes field, no more. Ttenbergen 10:31, 2015 August 19 (CDT)
=== 2015-Aug-13 ===
rolled out Ttenbergen 08:56, 2015 August 17 (CDT)
* added [[ECMO Veno-venous]] and [[ECMO Veno-arterial]] to table [[Check_ORDx]] to allow collection as [[Primary Admit Diagnosis]] for patients who come from the OR. Ttenbergen 11:57, 2015 August 13 (CDT)
* removed field "old_hospital_code" from [[S_dispo table]], it now lives in ''S dispo legacy codes table'' Ttenbergen 17:08, 2015 August 13 (CDT)
=== 2015-Jul-23 ===
rolled Ttenbergen 09:46, 2015 August 10 (CDT)
* updated data in s_dispo and related s_ tables. Ttenbergen 10:15, 2015 August 6 (CDT)
* as decided at task meeting:
** added [[Other Psychological Disturbance]] to [[s_AllDiagnoses table]] Ttenbergen 15:02, 2015 August 6 (CDT)
** added "z_other" to [[Service Sending to ICU]] Ttenbergen 15:04, 2015 August 6 (CDT)
** added [[s_tmp table]] entries for [[ACP Status Collection in ICU]] Ttenbergen 15:42, 2015 August 6 (CDT)
=== 2015-Jul-14 ===
rolled out Ttenbergen 11:34, 2015 July 23 (CDT)
* removed exemption for STB_CICU from Function AdFrom_same_ICU() Ttenbergen 21:05, 2015 July 14 (CDT)
* changed [[ECMO]] entry in [[s_AllDiagnoses table]] Ttenbergen 11:33, 2015 July 23 (CDT)
** changed "collection_allowed" for 76339 to false
** added [[ECMO Veno-venous]] 76342
** added [[ECMO Veno-arterial]] 76343
=== 2015-Jun-30 ===
rolled Ttenbergen 10:44, 2015 July 8 (CDT)
* updated Function ''AdFrom_same_ICU'' to no longer exempt STB_MICU
* changed query ''s_tmp_ER_Wait_from_ER_no_ER_Wait'' to only trigger on complete records
* updated [[S Locations]] - added columns for "center" and "service_type" for Julie's reporting
* updated [[S dispo table]] with some of the updates discussed at s_dispo meeting Ttenbergen 11:43, 2015 July 6 (CDT)
* [[Hospital previous]]
** added "active" column to [[S HospitalCodes]]
** added legacy codes in as inactive
** updated form ''view'' to list only "active" options in the Hops Prev drop down; made drop down list more rows
===2015-Jun-24-2===
rolled Ttenbergen 11:54, 2015 June 24 (CDT)
* removed [[Service Sending to ICU]] cross-check query ''s_tmp_Service_Sending_to_ICU'' since it partially depends on previous inpatient location which we don't track yet. Ttenbergen 11:54, 2015 June 24 (CDT)
===2015-Jun-24===
rolled Ttenbergen 10:38, 2015 June 24 (CDT)
* updated [[Service Sending to ICU]] cross-check query ''s_tmp_Service_Sending_to_ICU'' to only trigger for patients in CC location that don't come from CC admit_from. Ttenbergen 10:38, 2015 June 24 (CDT)
===2015-Jun-22===
rolled out Ttenbergen 16:07, 2015 June 22 (CDT)
* added to [[s_AllDiagnoses table]]: [[Adult failure to thrive]] Ttenbergen 13:56, 2015 June 22 (CDT)
* removed query and check for s_tmp_CCU_Service_missing for [[CCU Service Tracking]] Ttenbergen 14:01, 2015 June 22 (CDT)
* added to [[s_tmp table]]: options for [[Service Sending to ICU]] Ttenbergen 14:55, 2015 June 22 (CDT)
* [[s_AdmitDischarge]]: added "inpatient" column to be able to run checks for [[Service Sending to ICU]] Ttenbergen 15:35, 2015 June 22 (CDT)
* added cross-check queries ''s_tmp_Service_Sending_to_ICU'' and ''s_tmp_Service_Sending_to_ICU_duplicate'' for [[Service Sending to ICU]] Ttenbergen 15:35, 2015 June 22 (CDT)
* added cb_pick_Click() for s_dispo_chooser to update viewer; no data structure yet, so doesn't do anything yet Ttenbergen 15:45, 2015 June 22 (CDT)
* made prevInptLocation invisible for now, implementation not done yet Ttenbergen 15:52, 2015 June 22 (CDT)
===2015-Jun-03===
rolled out. Ttenbergen 17:55, 2015 June 3 (CDT)
* imported [[s_dispo table]] and related work-in-progress queries and tables from skipped version 2015-06-01. Ttenbergen 13:24, 2015 June 3 (CDT)
* implemented Dispo_Chooser form, not yet hooked up. Ttenbergen 17:55, 2015 June 3 (CDT)
===2015-Jun-02x===
rolled out Ttenbergen 09:20, 2015 June 2 (CDT)
* updated query s_tm+ccu_service_missing to only trigger for STB_MICU patients Ttenbergen 09:17, 2015 June 2 (CDT)
* removed MsgBox "not done yet" Ttenbergen 09:17, 2015 June 2 (CDT)
* reinstated the input mask for the tmp time Ttenbergen 09:17, 2015 June 2 (CDT)
===2015-Jun-01===
not rolled yet Ttenbergen 10:41, 2015 June 1 (CDT)
* created [[s_dispo table]] Ttenbergen 17:37, 2015 June 1 (CDT)
===2015-May-28===
rolled out Ttenbergen 10:26, 2015 June 1 (CDT)
* adding [[CCU Service Tracking]]
** added options to table ''[[s_tmp table]]'' Ttenbergen 15:47, 2015 May 28 (CDT)
** added code to module Tmp_Checker to run the queries Ttenbergen 16:27, 2015 May 28 (CDT)
** adding code to check that consecutive locations are not same...
* removed input mask from tmp time field, wasn't working right Ttenbergen 16:57, 2015 May 28 (CDT)
===2015-May-20===
rolled out Ttenbergen 17:33, 2015 May 25 (CDT)
* changed table [[s_AdmitDischarge]] location "Outside City" to "Outside City unknown" Ttenbergen 16:00, 2015 May 25 (CDT)
===2015-May-14===
rolled out Ttenbergen 09:46, 2015 May 20 (CDT)
* correction to [[Trach_Task#CCDMB_Data_Integrity_Checks]], was detecting any dx code ending in 101,102,103 not only trach task ones. Ttenbergen 09:40, 2015 May 20 (CDT)
===2015-May-11===
rolled out Ttenbergen 18:16, 2015 May 14 (CDT)
* added Rifampicin, Rifampin to hover-over for anti-tb drugs Ttenbergen 15:52, 2015 May 13 (CDT)
* removed twin entry for Var2 GH at GRA, it now should be a generic entry for all sites. This would have prevented Shirley from entering a discharge to GH from Vic. Ttenbergen 16:01, 2015 May 13 (CDT)
* updates and fixes to [[Trach_Task#CCDMB_Data_Integrity_Checks]] Ttenbergen 18:14, 2015 May 14 (CDT)
===2015-May-4-6===
rolled out Ttenbergen 11:32, 2015 May 11 (CDT)
* no longer requiring er wait entry for incomplete patients. If a patient is complete, still required where applicable. If entered, still checking for consistency as before. (changed query ''s_tmp_ER_Wait_from_ER_no_ER_Wait'') Ttenbergen 17:11, 2015 May 4 (CDT)
* updated query ''check_overstay_not_entered'' to get its program() from that function rather than the ending letters of the location Ttenbergen 09:13, 2015 May 11 (CDT)
* disallowed collection of plain code 7700 ([[Meningoencephalitis]]) since we have only specific pathogens allowed for this, and they each have a listed diagnosis (rather than infection coding with pathogen)Ttenbergen 10:31, 2015 May 11 (CDT)
** checked [[centralized_data.mdb]] and there were no records where this data was bad Ttenbergen 10:31, 2015 May 11 (CDT)
* disabled several legacy diagnoses that were still collectable; emailed Trish/Julie to find out what to do with CFE data.
* [[Tracheostomy Site Infection]] (disabled dx 77408 and enabled 9308)
===2015-May-4-5===
rolled Ttenbergen 13:56, 2015 May 4 (CDT)
* removed some references to defunct fields in L_Pharm_Flow that kept the program from compiling. Ttenbergen 13:46, 2015 May 4 (CDT)
* changed field formatting for dates in Medical Records report to yyyymmmdd hh:nn, was showing differently for different people and therefore putting ### into fields Ttenbergen 13:56, 2015 May 4 (CDT)
===2015-May-4-4===
rolled Ttenbergen 12:07, 2015 May 4 (CDT)
* more date field width issues... Ttenbergen 12:07, 2015 May 4 (CDT)
===2015-May-4-3===
rolled Ttenbergen 11:42, 2015 May 4 (CDT)
* updated table ''s_tmp_er_wait_r_locations'' to accommodate changes in [[#2015-May-4-2]] Ttenbergen 11:42, 2015 May 4 (CDT)
===2015-May-4-2===
rolled Ttenbergen 11:14, 2015 May 4 (CDT)
* found some error checks that apply to HSC_ICUs that didn't translate to new location designations, fixed. Ttenbergen 11:06, 2015 May 4 (CDT)
* corrected the new names for [[HSC ICU workload splitting]] Ttenbergen 11:06, 2015 May 4 (CDT)
* updated functions ''AdFrom_same_ICU'' and ''DisTo_same_ICU'' to check new locations and also check HSC IICU Ttenbergen 11:06, 2015 May 4 (CDT)
===2015-May-4===
rolled out Ttenbergen 10:32, 2015 May 4 (CDT)
* made discharge date field wider again, was showing "###" as it will when it doesn't have space for all of a date Ttenbergen 10:12, 2015 May 4 (CDT)
* made date fields wider in medical records report, no idea what changed and why they would not be wide enough now. Ttenbergen 10:21, 2015 May 4 (CDT)
* made date wider in labs tab, May dates are wider than other months. Ttenbergen 10:32, 2015 May 4 (CDT)
* re-instating the code to make things work with Access 2003, not working for Grace otherwise. Ttenbergen 10:21, 2015 May 4 (CDT)
===2015-Apr-30===
rolled Ttenbergen 16:57, 2015 April 30 (CDT)
* tweak to make sure new HSC ICU locations show up properly in dropdowns. Ttenbergen 16:57, 2015 April 30 (CDT)
===2015-Apr-01===
was rolled earlier today Ttenbergen 16:57, 2015 April 30 (CDT)
* visible
** '''eliminated some stuff from sending''' that we don't need any longer now that we use Centralized rather than TMSX Ttenbergen 10:29, 2015 April 30 (CDT)
** changed diagnosis category for [[Adrenalectomy]] to "Other OR" Ttenbergen 10:18, 2015 April 1 (CDT)
** changed date formats in patient list to make them more similar to the format used in the patient viewer. Ttenbergen 15:54, 2015 April 29 (CDT)
** added check that there '''can't be more than one''' entry for [[Comfort Care]] per pt. Ttenbergen 16:21, 2015 April 29 (CDT)
** Added new HSC MICU locations as per [[HSC ICU workload splitting]] and inactivated old ones. Ttenbergen 16:58, 2015 April 29 (CDT)
* likely invisible
** renamed query ''L_Labs_Flowsheet_sum'' to [[Query L Labs total]] for consistency. Ttenbergen 14:15, 2015 April 16 (CDT)
** added query ''s_tmp_comfort_care_gt_one'' for [[cross check]] for more than one entry for [[Comfort Care]] per pt. Ttenbergen 16:21, 2015 April 29 (CDT)
** as discussed with Julie, changed module sending function Send_Data to no longer send to [[Tasks 1.mdb]],[[Imaging.mdb]],[[Pharmacy.mdb]] and [[TmpV2 1.mdb]]
** as discussed with Trish, changed module sending function Send_Data to no longer send TMS output .csvs
* edited form send_progress form to delete the things we no longer do Ttenbergen 10:36, 2015 April 30 (CDT)
* deleted queries EdsCC and EdsMed that were used in [[Output for TMSX and MedTMS | sending to TMSX]]
* deleted queries z_d_id_maker, z_log_test, s_tcc_test and z_tree_test, 2013* Ttenbergen 10:48, 2015 April 30 (CDT)
* deleted old send queries that are no longer used:  send_imaging, send_tasks, send_tasks_master, send_tmp, send_tmp_audit Ttenbergen 10:48, 2015 April 30 (CDT)
* deleted old query 20130311_pharm_converter that was used only once when we changed the system Ttenbergen 10:48, 2015 April 30 (CDT)
* imported [[CCMDB.accdb]] into a new clean file; TMSX stuff had been the hold-up. Ttenbergen 11:15, 2015 April 30 (CDT)
* changed MainForm open code to not eliminate 2003 excel reference code Ttenbergen 11:15, 2015 April 30 (CDT)
===2015-Mar-30===
rolled Ttenbergen 12:22, 2015 March 30 (CDT)
* changed diagnoses
** "Iatrogenic Baclofen OD" to "Baclofen OD" Ttenbergen 10:30, 2015 March 30 (CDT)
** category for [[Adrenalectomy]] to "GU OR"  - Ttenbergen 10:30, 2015 March 30 (CDT)
** category for [[Abscess_Drainage-Neck]] from “other OR procedures to “Head/Neck-OR” Ttenbergen 10:18, 2015 April 1 (CDT)
** como names to help coding for [[Renal insufficiency-mild (creatinine 160-240 mmol)‎]] and [[Renal insufficiency-mild (creatinine 160-240 mmol)]] Ttenbergen 12:14, 2015 March 30 (CDT)
* removed some legacy code that cleaned up A_Info table in 2013Ttenbergen 10:32, 2015 March 30 (CDT)
* fixed sub MinimizeRibbons() to always hide the top ribbon on startup Ttenbergen 10:46, 2015 March 30 (CDT)
===2015-Feb-05===
rolled Ttenbergen 17:38, 2015 February 5 (CST)
* made sure ARF label from most recent previous version is only visible for critical care. Ttenbergen 14:57, 2015 February 5 (CST)
===2015-Feb-04===
rolled out Ttenbergen 11:35, 2015 February 4 (CST)
* added ''STB_5B_x'' to table ''s_tmp_er_wait_r_locations'' so that error checking will work properly, was giving false-positive pre-send error Ttenbergen 10:16, 2015 February 4 (CST)
* [[Hospice]] - confirmed that JH, GH and BH are in table ''s_varOptions''; added the descriptions as well.
* moved window for query ''s_tmp_ER_Wait_has_tmp_not_from_ER'' higher on the screen, it was hidden at the bottom of the screen requiring scrolling before.
* updated form ''View''
** [[LTV]]
*** changed label from "filter" to "LTV"
*** eliminated options no longer used from drop-down
*** made label into link to wiki
*** added the field to the  [[Sub Check_Forms.Legacy_Hider()]] so it is shown only for CC as wiki says only used for CC
* removed some erratic code from module tmp_checker that was trying to set form components when it is not run from that form
* [[ARF]]
** added hover-over hint to arf field; if you click in and hover over it it will tell criteria
** changed label into link to [[ARF (APACHE)]]
===2015-Jan-15===
Rolled out Ttenbergen 16:32, 2015 January 19 (CST)
* added notes column to table [[S_AdmitDischarge]]. Ttenbergen 15:29, 2015 January 15 (CST)
* implement [[Serial_number#STB_5B:_Serial_number_share_plan]]
** added location STB_5B_X to table ''[[S Locations]]'' and to table ''s_locations_allowed_collection''
* added code to cause error if the [[Notes field]] has too much content (
https://answers.microsoft.com/en-us/msoffice/forum/all/memo-field-could-not-update-currently-locked-by/d5c8163a-7ce5-484f-80d4-98c1a8c92160) Ttenbergen 14:30, 2015 January 19 (CST)
===2015-Jan-5===
===2015-Jan-5===
not rolled yet Ttenbergen 12:25, 2015 January 5 (CST)
rolled out Ttenbergen 15:26, 2015 January 15 (CST)
* updated table s_tmp to hide QAInf, QASeptic and Cooling from Medicine where it is not collected. Ttenbergen 12:25, 2015 January 5 (CST)
* updated table s_tmp to hide [[QAInf]], [[QASeptic]] and [[Cooling]] from Medicine where it is not collected. Ttenbergen 12:25, 2015 January 5 (CST)
 
* updated function Validate_DOB(); it was doing a soft-reject at age 107, will now do hard reject at age 120 Ttenbergen 10:55, 2015 January 15 (CST)
* changed s_Pathogens PCP (pneumoystic carinii) to PJP (Pneumocystis jiroveci) Ttenbergen 10:57, 2015 January 15 (CST)
* S_VarOptions: added var1/2 locations for [[hospice]]s, allow access from all sites: GH - Grace Hospice, JH-Jocelyn House, BH - Brummitt-Feasby ALS House
* [[S_AdmitDischarge]]: added ZH-Hospice Care Center


[[Category: IT Instructions]]
[[Category:CCMDB.accdb]]
[[Category: Development Documentation]]
[[Category:Change Logs CCMDB]]
[[Category: Change Logs CCMDB]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.mdb_Change_Log_2015"