CCMDB.mdb Change Log 2015

see Log (disambiguation) for other uses of the term "Log" see the Development Documentation Category for other development logs

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

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 checks: 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.mdb
  • 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 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 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: 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 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 locations and serial number sharing 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 locations and serial number sharing 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 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.mdb 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 hider function 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 (http://answers.microsoft.com/en-us/office/forum/office_2007-access/memo-field-could-not-update-currently-locked-by/d5c8163a-7ce5-484f-80d4-98c1a8c92160)Ttenbergen 14:30, 2015 January 19 (CST)

2015-Jan-5

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 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 hospices, allow access from all sites: GH - Grace Hospice, JH-Jocelyn House, BH - Brummitt-Feasby ALS House
• S_AdmitDischarge: added ZH-Hospice Care Center