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-APR-01

not rolled yet - Ttenbergen 10:18, 2015 April 1 (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 2015-05-01 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