CCMDB.mdb Change Log 2014

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

2014-02-28

rolled out Ttenbergen 15:15, 2014 March 3 (CST)

• de-activated the Allied Health Consults project entries in s_tmp - Ttenbergen 16:11, 2014 February 28 (CST)
• confirmed that send function is checking that centralized_data.mdb is present - Ttenbergen 16:36, 2014 February 28 (CST)
• confirmed that dates in registry now work consistently re input mask vs format - Ttenbergen 16:38, 2014 February 28 (CST)
• added checks for ER Wait validation: Ttenbergen 17:12, 2014 February 28 (CST)
  • s_tmp_ER_Wait_has_tmp_not_from_ER
  • s_tmp_ER_Wait_from_ER_no_ER_Wait
• removed table s_tmp_moverequired since it is not used any more. Ttenbergen 10:12, 2014 March 3 (CST)
• updated query s_tmp_project_item_consistent (run by pre-send checker) to accommodate tmp entries without item/values, needed to accommodate new "No Transfer Date" entry Ttenbergen 15:11, 2014 March 3 (CST)

2014-01-29

Rolled out Ttenbergen 15:37, 2014 February 28 (CST)

• confirmed problem when HCT or WBC are using floating point numbers between ranges in the APACHE Scoring table. Emailed Trish to find out what to do. Ttenbergen 16:11, 2014 January 27 (CST)
• added test for appropriate number of decimal places to the Apache scoring code; this was instead of making the ranges gapless. Initially I thought that Julie's code had them gapless, but it doesn't, so I give up; testing for the appropriate number of decimal places should prevent errors. If #ofdps is too high, the function will return a -99 and give an error. Ttenbergen 14:34, 2014 February 5 (CST)
• decided not to add the initials at send time
• updated s_alldiagnosis entry for HAP to list as "Pneumonia-Hospital Acquired HAP"
• removed legacy options ft, h, p from s_varoptions, see ICU Var 6 - AMA for details Ttenbergen 14:01, 2014 February 27 (CST)
  • changed s_varnames to reflect same Ttenbergen 14:03, 2014 February 27 (CST)
• increased column width for field project on tmp form. Ttenbergen 15:10, 2014 February 28 (CST)
• added No transfer time to s_tmp - Ttenbergen 15:16, 2014 February 28 (CST)

2014-01-27

rolled out. Ttenbergen 14:40, 2014 January 29 (CST)

• fix to send process, there was a problem with the update to open Excel after sending. Ttenbergen 14:40, 2014 January 29 (CST)

2014-01-16

rolled out Ttenbergen 18:23, 2014 January 26 (CST)

• imported new version of module apache_scoring from centralized_front_end. Ttenbergen 22:23, 2014 January 16 (CST)
• fixed AaDO2 coding and updated AaDO2 helper form to use it Ttenbergen 14:20, 2014 January 26 (CST)
• changed RecordStatus field in PatientViewer so field can't be set to blank. Fields currently set to blank won't be affected, but can't set to blank now. Ttenbergen 14:35, 2014 January 26 (CST)
• imported s_admitDischarge as used in importer, ie incl old inactive options Ttenbergen 14:48, 2014 January 26 (CST)
  • added NG nursing home Grace Ttenbergen 14:48, 2014 January 26 (CST)
  • changed admit-from and discharge-to drop-downs to reflect to only list active options Ttenbergen 14:50, 2014 January 26 (CST)
• updated function validate_chart to reject a chart number with length >=9 (ie likely a misplaced PHINTtenbergen 15:41, 2014 January 26 (CST)
• added sub open_in_excel to test excel version and open as appropriate during send Ttenbergen 17:50, 2014 January 26 (CST)

2014-01-02

rolled outTtenbergen 19:05, 2014 January 15 (CST)

• refactored function CCMDB_age to be able to use it with parameters (birth, admit). Ttenbergen 15:40, 2014 January 2 (CST)
• commented out functions GCS_Eye, GCS_motor, GCS_verbal. Don't seem to be used anywhere, and if they were, the scores should now come from table s_GCS. Ttenbergen 16:08, 2014 January 2 (CST)
  • updated Transition Coordinator function to draw Apache scoring from new location Ttenbergen 18:39, 2014 January 15 (CST)
• changed function Ap_Chronic to be able to take CH and AT as parameters rather than draw from form Ttenbergen 16:08, 2014 January 2 (CST)
• made module Apache_Scoring; changed apache scoring on Form View and in module Check_Forms to use it
  • Function ApScore_HeartRate
  • Function ApScore_Temp
  • Function ApScore_RespRate
  • Function ApScore_MeanBP
  • Function Ap_MeanBP
  • Function ApScore_SerCO2
  • Function ApScore_pH
  • Function ApScore_Na
  • Function ApScore_Hemat
  • Function ApScore_K
  • Function ApScore_WBC
  • moved in Function Ap_Chronic
• fixed spelling for Polycythemia Rubra Vera in s_AllDiagnoses Ttenbergen 10:19, 2014 January 6 (CST)
• added yes/no column "choosable" to table s_AP_Chronic; added record "0HasChronic" as unchoosable record, updated form_view.ap_Chronic to draw from revised table. Ttenbergen 10:19, 2014 January 10 (CST)
• added column "surgical" to table s_AdmitDischarge. Ttenbergen 10:28, 2014 January 10 (CST)
• cleaned defunct HanDBase columns out of table s_AP_AdmitType. Ttenbergen 10:43, 2014 January 10 (CST)
• added NH Nursing Home HSC to s_AdmitDischarge
• added W4 to s_varOptions var1/2 entries for Grace
• integrated changes to closeNavPane() and MinimizeRibbons() that were made for Access 2010 but were breaking 2003 and were reverted. Tested on Con's laptop and on mine, work now. Ttenbergen 16:10, 2014 January 15 (CST)