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-Dec-23

re-rolled Ttenbergen 15:20, 2014 December 23 (CST)

• added CR4, A3, E3 and L&D to s_varoptions for STB
• changed patient viewer form layout
  • added colour background for dates and from/to info
  • re-arranged some fields for better grouping and background
• fixed integrity checks AdFrom_Var1_reconcile and Disto_Var2_reconcile for 7 Oaks, their abbreviation in from/to is non-std
• fixed query s_tmp_brr_dx_inconsistent, was looking at dx 100.03 instead of 100.01

2014-Dec-17

rolled Ttenbergen 19:32, 2014 December 17 (CST)

• BRR
  • added cooling BRR/XBR to table s_tmp
  • removed BRR/XBR from table s_VarNames
  • updated table s_varOptions to only give blank as an option; pre-existing BRR entries will still be visible Ttenbergen 17:37, 2014 December 17 (CST)
  • removed Function Var2_BRR_reconcile() Ttenbergen 18:09, 2014 December 17 (CST)
  • added query s_tmp_BRR_DX_inconsistent Ttenbergen 18:09, 2014 December 17 (CST)
  • in module tmp_checker, added BRR checking content to
  • updated Function Validate_Var2() to not trigger old check Ttenbergen 18:09, 2014 December 17 (CST)
• fixed Function uncheck_tmp() which would not have unchecked tmp properly.
• ICU Var1/2
  • changed table s_varOptions
  • updated function Legacy_hider so it shows Var 1 for ICU
  • updated table s_VarNames to label properly
  • changed dropdown sources in Form View to give ICU and Med both the Var 1 options for Var1 and Var2.
  • changed functions AdFrom_Var1_reconcile and DisTo_Var2_reconcile to run for both ICU and Med Ttenbergen 18:57, 2014 December 17 (CST)

2014-Dec-11

rolled to all Ttenbergen 15:39, 2014 December 11 (CST)

• re-enabled ADL bathing tab stop, had accidentally disabled it
• fixing tabbing and stopping on PatientList
• added colour coding for location to PatientList to help reduce wrong locations for laptops that collect multiple locations
• added button to sort by location
• tweaks to tabbing and field order on Patient Viewer

2014-Dec-10

moved to master for some beta testers but not rolled yet

• corrected the Discharge Date in the nwe top-of-frm fields introduced last version Ttenbergen 11:11, 2014 December 10 (CST)
• changed layout and tab order of registry screen to integrate the new fields and reflect work flow Ttenbergen 11:11, 2014 December 10 (CST)
• Apache_Scoring Function ApScore_AaDO2(AaDO2) to return 0 of AaDO2 is 0 or negative; as confirmed with Julie, if AaDO2 is null, score will be null. Ttenbergen 11:16, 2014 December 10 (CST)

2014-Dec-07

rolled Ttenbergen 19:44, 2014 December 8 (CST) Changes collectors will want to know about:

• Changed the Patient Viewer to show the admit and discharge dates in the top row; these are only displays and can't be edited, editing still happens in Reg tab. The change was made because you always need those dates to check labs and cultures etc, so having them prominently visible will reduce clicking back and forth. The data I removed from the top is now on the bottom of the reg tab. Ttenbergen 19:33, 2014 December 8 (CST)

Behind the scenes...

• spelling fix to Apache scoring function Transfer_delay. Should not affect CCMDB use, just for consistency. Ttenbergen 23:27, 2014 December 7 (CST)
• fix to Apache_scoring function ApScore_PO2 Ttenbergen 23:36, 2014 December 7 (CST)

2014-Dec-05-2

rolled Ttenbergen 14:36, 2014 December 5 (CST)

• updated query s_tmp_ER_Wait_chronological to trigger if the date in ER wait entries is blank Ttenbergen 14:36, 2014 December 5 (CST)

2014-Dec-05

rolled earlier today Ttenbergen 11:22, 2014 December 5 (CST)

• added code to fix references to excel to work for either v11 or v14

2014-Dec-04

rolled Ttenbergen 16:28, 2014 December 4 (CST)

• fixing APACHE scoring to make ranges continuous.
  • function ApScore_HeartRate Ttenbergen 14:20, 2014 December 4 (CST)
  • Function ApScore_Temp
  • Function ApScore_RespRate
  • Function ApScore_MeanBP
  • Function ApScore_SerCO2 Ttenbergen 14:49, 2014 December 4 (CST)
  • Function ApScore_pH
  • Function ApScore_Na
  • Function ApScore_Hemat
  • Function ApScore_K
  • Function ApScore_WBC
  • Function ApScore_Creat Ttenbergen 15:21, 2014 December 4 (CST)
  • Function ApScore_AaDO2
  • Function ApScore_PO2 Ttenbergen 15:33, 2014 December 4 (CST)

2014-Dec-02

rolled out Ttenbergen 11:12, 2014 December 2 (CST)

• removed sub "open_in_excel" no longer used
• fixed references again, will need better solution for that.

2014-Dec-01

rolled dec 1 around 20:00

• tweaked error checking for blank transfer date in CC, wasn't catching discharge to wards Ttenbergen 14:17, 2014 December 1 (CST)

2014-Nov-26

rolled Ttenbergen 07:55, 2014 November 26 (CST)

• removed excel reference fix, it was breaking things for people; looking for a solution that will work for all. Ttenbergen 07:55, 2014 November 26 (CST)

2014-Nov-12

not rolled yet Ttenbergen 09:59, 2014 November 13 (CST) changes collectors don't need to know

• added code to automatically change reference from Excel 14 to 11 so laptops with Access 2003 don't get error on open; now that my laptop has both 2003 and 2010 they were getting library reference error for Excel 14 Ttenbergen 09:59, 2014 November 13 (CST)
• H4H changes (to implement Serial_number#HSC_H4H_Serial_number_share_plan_guide)
  • table s_locations
    • added to: HSC_H4H_a, HSC_H4H_b, HSC_H4H_d, HSC_H4H_h
    • made HSC_H4H inactive
  • updated table s_locations_allowed_collection to show the new options in listings
• table s_locations inactivated HSC_H7, HSC_OVER, confirmed that STB_B5 is inactivated
• table s_alldiagnoses fixed spelling for Other Congenital heart Problem - Transposition of Great Vessels from transportation
• Long LOS errors (eliminated quadruple errors)
  • added field meanLOS3STD to table s_locations
  • imported Julie's meanLOS3STD values
  • changed function long_LOS to use the new cut-offs instead of the arbitrary old ones

2014-Nov-5 - 2

rolled Ttenbergen 17:20, 2014 November 12 (CST)

changes collectors don't need to know

• changed default background colour for D and T labels for checkboxes to -2147483633; not sure why they were not. Ttenbergen 15:25, 2014 November 12 (CST)
• added "Questioned" to s_Recordstatus as required by CFE - Ttenbergen 17:18, 2014 November 12 (CST)
• fixed entry for ICU Var 4 - Parked in ER, had been impossible to enter for who knows how long... Ttenbergen 17:20, 2014 November 12 (CST)

2014-Nov-5

rolled Nov 5

• query s_tmp_ER_Wait_chronological was complaining about ANY tmp dates, not just ER Wait; fixed

2014-Nov-4

rolled Nov 4 Reference error, needed to ensure that references Excel 11 not 14

2014-Nov-3

rolled Nov 3

need to know

• changed query s_tmp_ER_Wait_has_tmp_not_from_ER to only check if ITEM = ER admit (ie ignore direct admits)
• medicine transfer date error (tmp vs no transfer) was looking at admit date instead instead of transfer date, fixed
• changed the check for registry patient type, it will now only give error if someone is from OR or recovery but not listed as surgicel; before it also checked other

things. (Changed query check_OR_from_but_not_Surgical_Type based on s_admitDischarge surgical field)

• fixed actual error message for bad registry patient type, it said something about bad ORDX before
• some collectors had mentioned problems with the check for ER wait being before/after admit; reviewed query s_tmp_ER_Wait_chronological, it seems to be right, let

me know if not.

• collectors were getting error "the following patients have an er wait date that" but no list. The list was displaying off bottom of the screen where one would need to scroll... changed location to where it should be visible.
• confirmed that sending while previously "sent" patients are still on the list should be possible; sent out email to find out what problems people appear to be having with this.
• collectors were getting error "You entered an expression that has no value" at end of sending; changed the naming of the log file to eliminate this, please let me know if this still shows up
• Critical Care - some locations were getting error about trach tasks and dxs being inconsistent. Changed query check_trach_dx_task to eliminate the error thatsome locations have been getting about inconsistent trach diagnoses and tasks because, of course, cc doesn't do tasks.
• collectors were getting errors that transfer dates are required even for ward-to-ward transfers. I can't remember what the rules were for that and the wiki is down, so excluding patients discharged to ward from transfer date requirement for now; need to review what the story was when wiki is back up. (function Validate_TransDate())don't need to know
• changed buttons for tmp date "now" to only include date, not current time.
• changed send delay log to use LaptopLocation()

2014-10-28

rolled around then...

• added code to look for a testing variable "SendTest" in A_Info that would cause test sending to go to a different location

2014-Oct-22 - 2

rolled with old version number because it was a quick fix Ttenbergen 10:27, 2014 October 23 (CDT)

• fixed query Check OR from but not Surgical Type Ttenbergen 10:27, 2014 October 23 (CDT)

2014-Oct-22

Was rolled out because I forgot to compact prior to the previous roll... Ttenbergen 16:45, 2014 October 22 (CDT)

2014-Oct-06

rolled out Ttenbergen 16:41, 2014 October 22 (CDT)

Changes Collectors should know about

• changed province entry for Newfoundland in S Provinces from NF o NL; also changed sort order of dropdown to have MB at the top. Ttenbergen 11:48, 2014 October 22 (CDT)
• updated Minimal_Data_Set#CCDMB_Data_Integrity_Checks. Ttenbergen 12:46, 2014 October 22 (CDT)
• new consistency check Check OR from but not Surgical Type Ttenbergen 15:50, 2014 October 22 (CDT)

Changes Collectors don't need to know about

• removed remnants of PDA Pending.mdb: Ttenbergen 11:41, 2014 October 9 (CDT)
  • removed commented out code from sending
  • removed query Pending_Julie
• added code to the send sub to push a log of delay times to Z:\ICU_DATA_COLLECTION\Output\logs\send_delay_logs for review and possible speed up.

2014-Sep-15

rolled out Ttenbergen 18:59, 2014 October 6 (CDT)

• changes collectors should know about:
  • changed [[]] checks ()
  • removed warnings for >9 or >6 dxs/comos, no longer relevant 18:05, 2014 October 6 (CDT)
  • implemented Trach_Task#CCDMB Data Integrity Checks Ttenbergen 18:44, 2014 October 6 (CDT)
• changes collectors might care about:
  • the send delays are now being sent to the regional server so we can analyze and make faster.
• details not relevant to collectors
  • updated Temp_Checker_in_viewer() to give proper errors, there were "weird" errors for 5 character pcs before. Ttenbergen 16:23, 2014 October 6 (CDT)
  • created module binary_compares and function is_valid_postalcode to do this. Ttenbergen 16:23, 2014 October 6 (CDT)
• added code to sending Send_Data() that will put program delays in sending into Regional Server\Output\send_delay_log.csv Ttenbergen 17:28, 2014 October 6 (CDT)

2014-Sep-03

rolled out Ttenbergen 10:32, 2014 September 15 (CDT)

• changes collectors might notice
  • 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)
  • updated main dx name for dx codes 831** to "Other Head/Neck-OR Procedures" from just "Other procedures"
  • updated main dx name for dx codes 199** to "Other cardiovascular problems" from just "Other problems"
  • updated Debridement - Cardiovascular from old wording "Wound Debridement" Ttenbergen 16:29, 2014 September 11 (CDT)
• changes that should be invisible
  • disabled sending to PDA_Pending.mdb Ttenbergen 10:26, 2014 September 15 (CDT)
  • changed way send_dttm is use to ensure local settings date format can not mess up the time stamp in centralized. Ttenbergen 10:26, 2014 September 15 (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 CVA-Cerebral Vascular Accident - 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 Pat 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)

• 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)
• fixed wording for some dxs:
  • 46300 Sedatives/Antidepressants Ttenbergen 14:19, 2014 July 7 (CDT)
  • 25001 Lupus Pneumonitis Ttenbergen 14:19, 2014 July 7 (CDT)
  • 8200 "Necrotizing soft tissue infections" to "Necrotizing soft tissue infections (necrotizing fasciitis, myonecrosis, Gas OR clostridial gangrene etc.)" for Necrotizing soft tissue infections (necrotizing fasciitis, myonecrosis, gas or clostridial gangrene etc.)

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 table 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 table 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.accdb 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.accdb 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.accdb - 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 table; 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 s_GCS table. 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 table 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)