CCMDB.mdb Change Log 2014

From CCMDB Wiki
Revision as of 15:29, 2014 September 4 by Ttenbergen (talk | contribs) (→‎2014-Sep-03: u)
Jump to navigation Jump to search

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-Sep-03

not rolled yet Ttenbergen 11:42, 2014 September 3 (CDT)

  • changed field AP Admit Type in View to only allow items on list. Ttenbergen 12:55, 2014 September 4 (CDT)
  • moved the close button on the view form to the left so it's visible on old laptops running Access 2010 Ttenbergen 16:29, 2014 September 4 (CDT)

2014-Aug-25

rolled out Ttenbergen 11:42, 2014 September 3 (CDT)

  • changed spelling of dx code Art/Ven Embolus/Thrombus 13209 to inNominate Ttenbergen 09:31, 2014 August 25 (CDT)
  • changed wording for 50507 - CVA-Cerebral Venous Thrombosis from Superior Sagital Sinus (should have been sagittal but that was the spelling...) Ttenbergen 09:51, 2014 August 25 (CDT)
  • updated labs_flowsheet form so it will hopefully work when using font magnification... (Trish or Joyce to test) Ttenbergen 12:47, 2014 August 26 (CDT)
  • fixed spelling for "sending complete" Ttenbergen 12:59, 2014 August 26 (CDT)
  • added code to the patient list open button to change focus away from the Patient ID to prevent accidental edits. Ttenbergen 13:04, 2014 August 26 (CDT)
  • L_Log not updated for location, sex and type: updated query send_Centralized_1L_Log_update which was not updating the following fields:
    • actually used and relevant in long-term data
      • R_Location
      • R_Sex
      • R_Type
        • emailed main office about these Ttenbergen 11:22, 2014 September 3 (CDT)
    • protocol-only fields not relevant for long-term data
      • R_Complete
      • ADL_Complete
      • Ap_Complete
      • ApLab_Complete
      • Labs_Complete
      • Tmp_Complete
      • Como_Complete
      • Diag_Complete
      • Pharm_Complete
      • Pharm_Flow_Complete

2014-Aug-14

rolled Ttenbergen 14:51, 2014 August 18 (CDT)

  • changes collectors might care about
    • updated L_BPs form to explain that data needs to come from there to have correct points Ttenbergen 14:52, 2014 August 14 (CDT)
    • updated form_view to hide AP points and BP Helper in Medicine; not relevant there. Ttenbergen 15:43, 2014 August 14 (CDT)
    • updated tmpV2_editor form to list links to wiki. Ttenbergen 12:41, 2014 August 18 (CDT)
    • updated query minimal_data_set_incomplete, wasn't doing check for admit date and time correctly. Ttenbergen 11:54, 2014 August 18 (CDT)
  • changes collectors may not notice
    • confirmed APpts for BP are right Ttenbergen 15:43, 2014 August 14 (CDT)
    • added column "comment_label" and "instruction_url" to table s_tmp to be able to give better field labelling in tmp edit view - Ttenbergen 15:49, 2014 August 14 (CDT)
    • updated s_tmp instructions and URLs to work for new setup Ttenbergen 16:11, 2014 August 14 (CDT)

2014-Aug-07

rolled out Ttenbergen 15:02, 2014 August 7 (CDT)

  • updated code for Validate_ARF, it was no longer detecting missing entries now that field set to null. - Ttenbergen 14:50, 2014 August 7 (CDT)
  • changed sending so pharm and labs are not synched for medicine, waste of time. Ttenbergen 14:53, 2014 August 7 (CDT)
  • cleaned up send_progress form (had some leftovers) and moved ICU-only stuff over to the side in it - Ttenbergen 14:57, 2014 August 7 (CDT)
  • updated error message given when centralized_data.mdb not found on server to contact main office. - Ttenbergen 14:59, 2014 August 7 (CDT)

2014-Jul-31-2

rolled out Ttenbergen 11:02, 2014 August 7 (CDT)

  • updated the s_alldiagnoses with version in centralized_data.mdb for consistency Ttenbergen 13:36, 2014 July 31 (CDT)
  • corrected AaDO2 scoring calculation to not be Null if AaDO2 <=0 Ttenbergen 16:41, 2014 July 31 (CDT)
  • disabled ARF change query, it omitted that only those set to "enter" should be set to "". oi. Ttenbergen 10:39, 2014 August 7 (CDT)
  • changed diagnosis Non Cardiac CP/CP NYD to Non Cardiac Chest Pain incl. NYD for easier searching Ttenbergen 10:59, 2014 August 7 (CDT)

2014-Jul-31

rolled earlier today Ttenbergen 13:36, 2014 July 31 (CDT)

  • removed s "stop" I forgot in the code Ttenbergen 13:36, 2014 July 31 (CDT)
  • added a "sending done" msg to the end of the send process Ttenbergen 13:36, 2014 July 31 (CDT)

2014-Jul-29-3

rolled out Ttenbergen 10:27, 2014 July 31 (CDT)

  • update sending
    • no more batch number, replaced with date & time
    • commented out old audit code that relied on the batch number
    • eliminated send report
    • eliminated automatic opening of .csv
  • updated form send_progress
    • no more report field
    • eliminated some detail entries early on since that is not where the delay is
    • added more detail in the centralized section, since that seems to be where things are slow

2014-Jul-29-2

rolled out Ttenbergen 12:21, 2014 July 29 (CDT)

  • moved the code to update the ARF data to when first opening Ttenbergen 12:21, 2014 July 29 (CDT)

2014-Jul-29

rolled out Ttenbergen 10:14, 2014 July 29 (CDT)

  • updated ARF dropdown to allow "" to set back to if needed. Ttenbergen 21:07, 2014 July 28 (CDT)
  • changed ARF update code for medicine to not require confirmation for updating records. Ttenbergen 10:14, 2014 July 29 (CDT)

2014-Jul-21

rolled out Ttenbergen 16:06, 2014 July 28 (CDT)

  • constrained the dropdown for Apache ARF to only existing content, which will prevent a "blank" from being entered Ttenbergen 10:36, 2014 July 21 (CDT)
  • updated error message when sending record that already exists as not-incomplete in centralized_data.mdb to state that most likely this is because of a wrong location or patient ID. Ttenbergen 11:09, 2014 July 24 (CDT)
  • updated new patient generator to set Form_View.Ap_ARF = Null for medicine patients for consistent data in the back end. - Ttenbergen 14:59, 2014 July 28 (CDT)
  • added update code to set all existing medicine patients ARF to null Ttenbergen 15:04, 2014 July 28 (CDT)
  • added code to validate_phin when running validate_chart since the former checks for the two to not be the same. Ttenbergen 15:13, 2014 July 28 (CDT)
  • confirmed that the output for PHI does send all records on list each time, ie. if PHI data gets updated for a patient it should arrive as input for phi.mdb. Ttenbergen 16:03, 2014 July 28 (CDT)

2014-Jul-14

rolled out - Ttenbergen 10:11, 2014 July 17 (CDT)

  • updated pharmacy tab with hover hints for Drugs_Collected#counted_drugs Ttenbergen 12:24, 2014 July 14 (CDT)
  • in table s_tmp changed "instruction" for postal code entry in CCMDB to say Postal Code into comment, checkbox if unavailable" (has "is" before) - Ttenbergen 14:06, 2014 July 14 (CDT)
  • table s_provinces
    • deleted columns rhdrinfo_ and rhdrid_ which are ancient leftovers from the PDA synching software HanDBase 15:45, 2014 July 14 (CDT)
  • added checks for wrong postal codes (compare PC/province first letter)
  • made hover hint for drugs "factor Xa inhibitors" = Fondaparinux (arixtra), Rivaroxaban (xarelto), Apixaban (Eliquis)" as per update to Drugs_Collected - Ttenbergen 16:26, 2014 July 14 (CDT)

2014-Jul-09

rolled Ttenbergen 10:12, 2014 July 9 (CDT)

  • updated connection routine for sending, it had a flaw that was previously hidden but came out with the last update disconnecting properly. Ttenbergen 09:31, 2014 July 9 (CDT)
  • changed caption for progress screen to "Send Progress" Ttenbergen 09:31, 2014 July 9 (CDT)
  • updated progress form added line for duplicate checker since that is where it hung for me, want to find out if that is the occasional slow-down people are getting... Ttenbergen 09:50, 2014 July 9 (CDT)

2014-Jul-07

rolled Ttenbergen 15:09, 2014 July 7 (CDT)

2014-Jul-03

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

  • sending problem for Bosentan
  • 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)
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.mdb_Change_Log_2014&oldid=40305"