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-Jul-07

not rolled yetTtenbergen 12:58, 2014 July 7 (CDT)

• added code to disconnect centralized when opening, hopefully this will fix intermittent slowness when a new version comes down. Collectors, please let me know! Ttenbergen 12:58, 2014 July 7 (CDT)

2014-Jul-03

rolled out Ttenbergen 16:55, 2014 July 3 (CDT)

• sending problem for Bosentan
  • updated query Send_Pharmacy, had been sending 0 for bosentan for long time
    • last change to this section was CCMDB.mdb_Change_Log_2013#2013-11-18
• sending problem for fungins
  • query Send_Centralized_L_Pharm_Flowsheet_update was sending azoles value to fungins since built; corrected now, but we need to update the data from pharmacy.mdb Ttenbergen 16:46, 2014 July 3 (CDT)

2014-Jul-02

rolled out Ttenbergen 14:13, 2014 July 2 (CDT)

• enabled Lab collection for all labs at HSC Ttenbergen 14:13, 2014 July 2 (CDT)

2014-Jun-23

rolled Ttenbergen 14:28, 2014 June 27 (CDT)

• imported query s_charlson_score from earlier version, accidentally got deleted in last update. that was causing errors when running overstay button, should be fixed now. Ttenbergen 13:12, 2014 June 27 (CDT)
• changed table s_charlson_dxs to not duplicate values that should come from s_alldiagnoses. Ttenbergen 14:07, 2014 June 27 (CDT)

2014-Jun-23

rolled out Ttenbergen 10:56, 2014 June 26 (CDT)

• changed s_Locations to make STB_A5 and STB_B4 inactive - Ttenbergen 10:08, 2014 June 25 (CDT)
• deleted old dev query s_charlson_comorbid_wiki_list_generator Ttenbergen 10:30, 2014 June 25 (CDT)
• messed around with S charlson dxs and dependencies of to eliminate duplication and potential for confusion Ttenbergen 11:14, 2014 June 25 (CDT)
• to fix sending - re-enabled function overlap from last update, is used during sending after all... Ttenbergen 10:22, 2014 June 26 (CDT)

2014-Jun-12

rolled...Ttenbergen 15:21, 2014 June 23 (CDT)

• changed lab collection form to allow HSC collectors to enter labs. Ttenbergen 16:40, 2014 June 12 (CDT)
  • reverted that change until Trish has had a change to stage the change over. Ttenbergen 17:31, 2014 June 12 (CDT)
• integrated change from v #2014-Jun-11. Ttenbergen 16:40, 2014 June 12 (CDT)
• updated Wegener's Granulomatosis / Granulomatosis with polyangiitis in s_alldiagnoses Ttenbergen 15:42, 2014 June 19 (CDT)
• changed Apache admit type to not allow anything other than dropdown values and blank, blank will not allow checking apache complete. Ttenbergen 12:41, 2014 June 23 (CDT)
• fixes to s_alldiagnoses legacy entries: disallow collection for 3097, 84602, 79497, 39997, 83197, 80697, 59997, 77797, 84897, 21997, should have been like that already but was missed during imports and updates somehow Ttenbergen 12:48, 2014 June 23 (CDT)
• imported newest version of module Apache_Scoring from Centralized data front end.mdb Ttenbergen 13:18, 2014 June 23 (CDT)
  • made some tweaks to integrate it Ttenbergen 14:00, 2014 June 23 (CDT)
  • renamed Apache scoring callers in module check_forms so they are never same as in ApacheScoring Ttenbergen 13:21, 2014 June 23 (CDT)
• commented out function overlap, not being called from anywhere and makes no sense Ttenbergen 13:24, 2014 June 23 (CDT)
• eliminated Pentaspan and Voluven from Labs collection screen on laptops Ttenbergen 14:20, 2014 June 23 (CDT)

2014-Jun-11

NOTE to TINA: Trish added to s_locations_allowed_collection

• Laptop B3 to allow location HSC_H4H.
• I rolled it out.Trish Ostryzniuk 12:07, 2014 June 11 (CDT)
  • Tina will have to integrate this minor change with the copy of ccmdb.mdb program she may have on her laptop.Trish Ostryzniuk 12:08, 2014 June 11 (CDT)
    • Done for version #2014-Jun-12 Ttenbergen 16:40, 2014 June 12 (CDT)

2014-06-04

not rolled yet Ttenbergen 11:17, 2014 June 4 (CDT)

• changes collectors don't need to know
  • added utility query z_d_id_maker

2014-06-03

rolled out Ttenbergen 11:17, 2014 June 4 (CDT)

• updated close button function on main form to also run compact_runner on close to make data files as small as possible. Ttenbergen 10:46, 2014 June 4 (CDT)
• changed table s_locations_allowed_collection to allow Pam to collect S3 at the Vic Ttenbergen 11:17, 2014 June 4 (CDT)

2014-06-02-2

rolled out Ttenbergen 13:37, 2014 June 3 (CDT)

• added HSC_CCU to allowed collection locations for HSC MICU laptop in table s_locations_allowed_collection. Ttenbergen 13:37, 2014 June 3 (CDT)

2014-06-02

rolled out Ttenbergen 14:03, 2014 June 2 (CDT)

• fixes to APACHE Scoring tie in....

2014-05-05

rolled Ttenbergen 12:27, 2014 June 2 (CDT)

Changes Collectors need to know about

• implemented limitation for locations dropdown to only those collected by this laptop
• added a progress indicator for sending; form send_progress will be opened and times will be updated to "now" as sending progresses.Ttenbergen 12:19, 2014 June 2 (CDT)

other changes

• imported the apache_scoring module as used in centralized front end, was changed there and they are supposed to be the same. No need to roll for this, change has no effect on function of ccmdb.mdb - Ttenbergen 10:20, 2014 May 5 (CDT)
• made s_admitDischarge same as elsewhere, ie incl. setting FP and FR to "surgical" and making sure that the Grace and HSC Nursing home entry is present. Ttenbergen 15:55, 2014 May 8 (CDT)
• implementing limitation for locations dropdown to only those collected by this laptop
  • added table s_locations_allowed_collection Ttenbergen 11:14, 2014 June 2 (CDT)
  • updated query s_Locations_local to use new table to restrict options Ttenbergen 11:17, 2014 June 2 (CDT)
• get Birth_MY into centralized_data.mdb
  • updated queries send_Centralized_1L_Log__intermediate, Send_Centralized_1L_Log_append and Send_Centralized_1L_Log_updateTtenbergen 11:29, 2014 June 2 (CDT)
• imported from centralized newest versions of
  • s_admitdischarge
  • s_locations
  • module Apache_Scoring

2014-05-01

rolled - Ttenbergen 15:13, 2014 May 1 (CDT)

• fixed query "send_set_oLog_to_sent" to properly link on Pat_ID and location, which was missing, leading to seemingly random patients being set to "Sent". This should address Bug - Incomplete patients are being set to "sent" in Centralized data.mdb. Ttenbergen 10:26, 2014 May 1 (CDT)
• query "Minimal_dataset_incomplete", Minimal Data Set
  • confirmed that there is no check for admit time; some collectors were entering fake times to be able to sent Ttenbergen 10:43, 2014 May 1 (CDT)
  • added restriction to not allow admit or discharge dates in the future Ttenbergen 10:43, 2014 May 1 (CDT)
• updated module "Apache_Scoring" to reflect changes requested: adjustments (in bracket) to APACHE Scoring table done on APRIL 23.14 (see edit history). Would need to check and update centralized front end.
  • AaDo: 201(200)-349
  • PO2: 61-69 (70)
  • CO2: <=14 ((<15)
  • PH: <=7.14 (<7.15)
  • K: <=2.4 (<2.5)
  • HCT: <=19.9 (<20)
  • WBC: <0.9 (<1)
• changed the way sent_dttm is generated for centralized Ttenbergen 12:26, 2014 May 1 (CDT)
  • added a table "A_SentDtTm" to store just one column and one line
  • added code to sending to set that record to Now()
  • changed query "send_Centralized_1L_Log__intermediate" to use that date as SentDtTm.
• added DOB check to run before generating Overstay colour when button is pressed. Ttenbergen 12:31, 2014 May 1 (CDT)
• added check so when entering admit date, if the date is more than one month before today, there will be an error. Error can be clicked past, will not affect sending Ttenbergen 12:34, 2014 May 1 (CDT)
• added code to prevent re-sending while a .csv file with same name exists. Ttenbergen 12:41, 2014 May 1 (CDT)

2014-04-24

rolled Ttenbergen 17:10, 2014 April 24 (CDT)

• changed query send_check_centralized_is_owner to also consider "vetted" as owned by centralized. Ttenbergen 14:18, 2014 April 24 (CDT)

2014-03-27

not rolled yet Ttenbergen 15:06, 2014 March 27 (CDT)

• updated query "minimal_data_set_incomplete"; it wasn't checking on missing admit dates, but should be as per Minimal Data Set - Ttenbergen 15:06, 2014 March 27 (CDT)

2014-03-13

rolled out Ttenbergen 10:41, 2014 March 24 (CDT)

• changing how data is transferred to centralized_data.mdb
  • changed the send_centralized_ queries to include both incomplete and complete patients
  • added code near the end of sending to set RecordStatus field to "sent" in centralized as well, was only done in ccmdb_data.mdb before. Ttenbergen 11:26, 2014 March 21 (CDT)

2014-03-10

rolled out. Ttenbergen 13:13, 2014 March 13 (CDT)

• Fixed reinstated Viral Hepatitis, in s_alldiagnoses it said viral hepatitis A. Ttenbergen 09:21, 2014 March 10 (CDT)
• fiddled with the hover hints for pharmacy; they were not working, open/editing them fixed it. Ttenbergen 13:13, 2014 March 13 (CDT)

2014-03-06

rolled out Ttenbergen 14:48, 2014 March 6 (CST)

• reinstates comorbid Viral Hepatitis into S_alldiagnoses; had been deleted in January because the 00 subcode should not be used for dxs any more, but still needs to be there for comos. Ttenbergen 14:48, 2014 March 6 (CST)

2014-03-05

was rolled out ~ 11:11, 2014 March 5 (CST) Ttenbergen 10:41, 2014 March 6 (CST)

• disabled queries s_tmp_ER_Wait_from_ER_no_ER_Wait and s_tmp_ER_Wait_has_tmp_not_from_ER as they didn't accommodate EMIPs and direct admits in current state. Need to figure out how to fix that, but disabled for now so collectors can send. Ttenbergen 11:11, 2014 March 5 (CST)

2014-03-03

rolled. Ttenbergen 17:19, 2014 March 3 (CST)

• fixed queries s_tmp_ER_Wait_from_ER_no_ER_Wait and s_tmp_ER_Wait_has_tmp_not_from_ER to limit checking to local ER Ttenbergen 16:38, 2014 March 3 (CST)
  • added table s_tmp_er_wait_r_locations to do

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)