CCMDB.mdb Change Log 2014: Difference between revisions

(167 intermediate revisions by 2 users not shown)

Line 7:

== 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 table|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|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 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 i'''f''' 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)

Line 16:

Line 327:

* 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)

* 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)

Line 24:

Line 335:

** 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)

* 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.~~mdb~~]] Ttenbergen 13:18, 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)

* eliminated [[Pentaspan]] and [[Voluven]] from Labs collection screen on laptops Ttenbergen 14:20, 2014 June 23 (CDT)

===2014-Jun-11===

Line 37:

Line 348:

*Laptop B3 to allow location HSC_H4H.

*I rolled it out.[[User:TOstryzniuk|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.[[User:TOstryzniuk|Trish Ostryzniuk]] 12:08, 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.[[User:TOstryzniuk|Trish Ostryzniuk]] 12:08, 2014 June 11 (CDT)

*** Done for version [[#2014-Jun-12]] Ttenbergen 16:40, 2014 June 12 (CDT)

Line 65:

Line 376:

====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)

* 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

Line 120:

Line 431:

=== 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)

* 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 ===

Line 139:

Line 450:

** 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)

* 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)

* 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 ===

Line 172:

Line 483:

* 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)

* 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)

Line 188:

Line 499:

** Function ApScore_WBC

** moved in Function Ap_Chronic

* fixed spelling for [[Polycythemia Rubra Vera]] in [[s_AllDiagnoses]] Ttenbergen 10:19, 2014 January 6 (CST)

* 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

* 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)

[[Category: ~~IT Instructions]]~~

[[Category:CCMDB.accdb]]

~~[[Category: Development Documentation~~]]

[[Category: Change Logs CCMDB]]

@@ Line 7: / Line 7: @@
 == 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 table|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|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 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 i'''f''' 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)
@@ Line 16: / Line 327: @@
 * 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)
+* 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)
@@ Line 24: / Line 335: @@
 ** 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)
+* 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.mdb]] Ttenbergen 13:18, 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)
+* eliminated [[Pentaspan]] and [[Voluven]] from Labs collection screen on laptops Ttenbergen 14:20, 2014 June 23 (CDT)
 ===2014-Jun-11===
@@ Line 37: / Line 348: @@
 *Laptop B3 to allow location HSC_H4H.
 *I rolled it out.[[User:TOstryzniuk|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.[[User:TOstryzniuk|Trish Ostryzniuk]] 12:08, 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.[[User:TOstryzniuk|Trish Ostryzniuk]] 12:08, 2014 June 11 (CDT)
 *** Done for version [[#2014-Jun-12]] Ttenbergen 16:40, 2014 June 12 (CDT)
@@ Line 65: / Line 376: @@
 ====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)
+* 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
@@ Line 120: / Line 431: @@
 === 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)
+* 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 ===
@@ Line 139: / Line 450: @@
 ** 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)
+* 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)
+* 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 ===
@@ Line 172: / Line 483: @@
 * 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)
+* 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)
@@ Line 188: / Line 499: @@
 ** Function ApScore_WBC
 ** moved in Function Ap_Chronic
-* fixed spelling for [[Polycythemia Rubra Vera]] in [[s_AllDiagnoses]] Ttenbergen 10:19, 2014 January 6 (CST)
+* 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
+* 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)
-[[Category: IT Instructions]]
+[[Category:CCMDB.accdb]]
-[[Category: Development Documentation]]
 [[Category: Change Logs CCMDB]]