CCMDB.mdb Change Log 2010: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Text replacement - "Category:CCMDB.mdb" to "Category:CCMDB.accdb")
m (Text replacement - "ccmdb.mdb" to "ccmdb.accdb")
Line 117: Line 117:
* added S_Labs_V2 [[User:Ttenbergen|Ttenbergen]] 16:58, 22 October 2010 (CDT)
* added S_Labs_V2 [[User:Ttenbergen|Ttenbergen]] 16:58, 22 October 2010 (CDT)
* added sorting button for FinalCheck to PatientList in preparation for removing "edit patients" and "filter" buttons.[[User:Ttenbergen|Ttenbergen]] 09:59, 25 October 2010 (CDT)
* added sorting button for FinalCheck to PatientList in preparation for removing "edit patients" and "filter" buttons.[[User:Ttenbergen|Ttenbergen]] 09:59, 25 October 2010 (CDT)
* to ensure common usage the master ccmdb.mdb now uses the external data as well, i.e. internal L_ tables are not an option any longer [[User:Ttenbergen|Ttenbergen]] 10:42, 25 October 2010 (CDT)
* to ensure common usage the master ccmdb.accdb now uses the external data as well, i.e. internal L_ tables are not an option any longer [[User:Ttenbergen|Ttenbergen]] 10:42, 25 October 2010 (CDT)
* deleted ancient old L_Tmp that had been kept not to break any PDA syncs [[User:Ttenbergen|Ttenbergen]] 10:54, 25 October 2010 (CDT)
* deleted ancient old L_Tmp that had been kept not to break any PDA syncs [[User:Ttenbergen|Ttenbergen]] 10:54, 25 October 2010 (CDT)
* fixed "visible" setting for bracket and score on Apache screen so it won't show up in Medicine [[User:Ttenbergen|Ttenbergen]] 12:45, 25 October 2010 (CDT)
* fixed "visible" setting for bracket and score on Apache screen so it won't show up in Medicine [[User:Ttenbergen|Ttenbergen]] 12:45, 25 October 2010 (CDT)

Revision as of 10:55, 2020 June 10

See CCMDB.mdb Change Log 2011

see the Development Documentation Category for other development logs

The CCMDB.mdb Change Log logs changes made to the CCMDB.mdb, including lock-downs when one person is making changes so that no one else makes changes at the same time. New entries should be made at the top to be immediately apparent. Discussions should be added at the level of individual changes if they correspond to a change, and at the end of the article if they relate to the change process in general; make sure you mark any discussion with {{discussion}} so it doesn't get lost in the fray. When a change is tested and rolled out it is also documented here.

Bugs & Requested Changes

Bug reports and requested changes have been popping up in different places. Please post article-specific things under the article (e.g. a tmp study's consistency check is broken). Please put general concerns under Requested CCMDB changes for the next version. Thanks, Ttenbergen 12:58, 29 October 2009 (CDT)

  • replicated bug; added ~30 patients without filling anything into the patient data. Then I got some "can't open a query errors", after closing those twice and trying again I go the error:
Title: Microsoft Office Access
Msg: There isn't enough memory to perform this operation. Close unneeded programs and try the operation again.

Versions

v2010-12-31

Rolled out to Med to get some early testing if possible. Med won't use labs but the data structure still will need to auto-convert. Ttenbergen 12:15, 31 December 2010 (CST)

  • set up 3rd draft of the new labs screen Ttenbergen 13:15, 24 December 2010 (CST)
  • second draft of lab form, made lab labels diagonal on top, implemented HSC hiding. Ttenbergen 16:14, 23 December 2010 (CST)
  • modified EdsCC query that outputs data to Ed to accomodate new Labs setup. Ttenbergen 16:52, 23 December 2010 (CST)
  • made new EdsCC compatible with ed's output specification Ttenbergen 17:55, 23 December 2010 (CST)
  • changed date field so it also has time Ttenbergen 12:35, 24 December 2010 (CST)
  • made values mandatory for Labs to ensure blank lab entry causes no problem Ttenbergen 12:38, 24 December 2010 (CST)
  • fixed type for "tampornade" for 4 entries in s_alldiagnoses Ttenbergen 12:31, 24 December 2010 (CST)
  • added to s_Location table HSC_OVER
  • added to S_Tmp for moves HSC_H7N and HSC_H7T
  • changed end date for QA Septic to 31 Mar 2011
  • Early ID study set up
    • added entries to s_tmp Ttenbergen 13:29, 24 December 2010 (CST)
  • made conversion function from old DB structure to new (module and sub DB_Converter()) Ttenbergen 14:08, 30 December 2010 (CST) and Ttenbergen 16:53, 30 December 2010 (CST)
  • changed forms to no longer look for e.g. L_Settings etc. Ttenbergen
  • removed "edit patients" button and funnel on the viewer Ttenbergen 16:53, 30 December 2010 (CST)
  • added room numbers Ttenbergen 16:56, 30 December 2010 (CST)
  • got rid of autopsy option for survive/expire field. Ttenbergen 18:04, 30 December 2010 (CST)
  • added an error log table; for now it would need to be accessed from the backups for analysis. Ttenbergen 18:29, 30 December 2010 (CST)

v1.9952

rolled out Ttenbergen 12:22, 29 November 2010 (CST)

further cleanup and doing changes requested deep in the wiki...

  • removed city hospitals from S_HospitalCodes as per Hospital previous (yesterday) Ttenbergen 10:59, 4 November 2010 (CDT)
    • St. Boniface 5 5 1
    • Grace 3 3 1
    • Seven Oaks 11 11 1
    • Misericordia 4 4 1
    • Rehab Center for Children 17 17 1
    • Health Sciences 16 16 1
    • Deer Lodge Center Inc. 19 19 1
    • Riverview Health Center 6 6 1
    • Victoria 7 7 1
    • Children Hospital 8 8 1
    • Concordia 9 9 1
  • deleted Greensheets form
  • added Re-sort button to dx, como, labs and pharm forms. Ttenbergen 11:23, 4 November 2010 (CDT)
  • fixed "find" button error in dx_chooser form Ttenbergen 11:31, 29 November 2010 (CST)
  • added expireds' notes to Pagasa's pending Ttenbergen 11:36, 29 November 2010 (CST)
  • added GRA_EMIP to s_locations Ttenbergen 11:37, 29 November 2010 (CST)
  • added HSC_H7 to s_locations as per request from Gail Hall. Ttenbergen 12:10, 29 November 2010 (CST)

v1.9951

  • c: rolled out Ttenbergen 13:42, 2 November 2010 (CDT)
    • added
      • var 2 H7 Med HSC
      • var 1 H7 Med HSC
    • changed Labs V2
      • 40 PT/PTT 0 -1 9999 (i.e. to not be collected at HSC
    • removed (as per ICU Var 6 - various uses)
      • Var 6 "S" CC Study - pt enrolled in a study
  • took out call to Alt_locn() that was causing send to hang Ttenbergen 13:42, 2 November 2010 (CDT)
  • b: changes got_data() so it will not crash when log file has already been written. Rolled out. Ttenbergen 09:28, 2 November 2010 (CDT)
  • a: removed a reference that was causing program to crash on opening.Ttenbergen 17:08, 1 November 2010 (CDT)

Rolled out Ttenbergen 14:51, 1 November 2010 (CDT) continuing updates where I left off with 1.995 to get the bug fixes out

  • removed following functions that are not used anywhere any longer... Ttenbergen 14:03, 27 October 2010 (CDT)
    • alt_locn()
    • laptop()
    • set_relationships()
    • create_rel(...)
    • drop_relationships()
  • added
    • Var Option Program Hosp Description
    • 2 PY1 Med HSC Psych
    • 2 PY3 Med HSC Psych
    • 1 PY1 Med HSC Psych
    • 1 PY3 Med HSC Psych
  • consolidating databasestarter() and laptopopener() in prep for going with new data structure
  • making program quit (Application.Quit) if
    • there is no or bad settings.mdb or
    • no data files/tables
    • any of the tables missing
  • Adding apache points
    • age + pts added to apache tabTtenbergen 12:15, 28 October 2010 (CDT)
  • deleted old PDA references from S AP Chronic table Ttenbergen 13:55, 28 October 2010 (CDT)
  • added "fill" versions of Task dxs to use for automatic population
    • Task Tracheostomy - Fill 100099
    • Task Hemodialysis - Fill 100199
    • Task Peritoneal Dialysis - Fill 100299
    • Task BiPAP or CPAP - Fill 100399
    • Task Isolation - Fill 100499
  • added code to cb_addPt_Click() to automatically enter the "fill" tasks to new med patients Ttenbergen 15:12, 29 October 2010 (CDT)
  • confirmed that dx_checker code to make sure that fill tasks will not be allowed to be sent before changing them to something real.
  • eliminated from s_varOptions, and updated ICU Var 1 and ICU Var 2 - BRR
    • 1 OBS CC CON Obser.Unit in ER for telemetry
    • 2 MAP CC MI care map
  • changed program so contents of "notes" field are written to Pagasa's PDA Status.csv automatically when sending Ttenbergen 12:35, 1 November 2010 (CDT)
  • temporarily added got_data() to Database_Starter() to make sure everyone received c:\ccmdb_data\ccmdb_data.mdb Ttenbergen 13:52, 1 November 2010 (CDT)

v1.995

Updt 1.995a Rolled out Ttenbergen 13:57, 26 October 2010 (CDT)

  • update to the drug list to some remaining existing hidden drugs. Ttenbergen 13:57, 26 October 2010 (CDT)

rolled out to apply bug fixes Ttenbergen 15:39, 25 October 2010 (CDT)

  • added S_Labs_V2 Ttenbergen 16:58, 22 October 2010 (CDT)
  • added sorting button for FinalCheck to PatientList in preparation for removing "edit patients" and "filter" buttons.Ttenbergen 09:59, 25 October 2010 (CDT)
  • to ensure common usage the master ccmdb.accdb now uses the external data as well, i.e. internal L_ tables are not an option any longer Ttenbergen 10:42, 25 October 2010 (CDT)
  • deleted ancient old L_Tmp that had been kept not to break any PDA syncs Ttenbergen 10:54, 25 October 2010 (CDT)
  • fixed "visible" setting for bracket and score on Apache screen so it won't show up in Medicine Ttenbergen 12:45, 25 October 2010 (CDT)
  • applied [1] by grouping and ungrouping controls in both patient list and viewer to fix out-of-memory error. Was able to open and close pts from patient list >50 times without bug, before ~25 would crash it. Please let me know if there are further memory errors after this version. Ttenbergen 13:01, 25 October 2010 (CDT)
  • changed the Pharmacy/Drugs list; re-instated the versions that I had deleted so that existing entries are preserved, but made them so they can't be entered in the future any longer.
  • started work on Public Sub new_db_structure_consolidation(), will roll out without this to get the fixes out there Ttenbergen 15:20, 25 October 2010 (CDT)

ver1.994

Rolled out Ttenbergen 16:22, 22 October 2010 (CDT)

  • MR report button on main form opens report with all patients who have "record" set to "MR" for printing to order charts from MR.
  • added New Dx 76325 - Cardiac ablation Ttenbergen 13:39, 22 October 2010 (CDT)
  • re-allowed editing for Record field right in Patient List - I had locked out all fields earlier because this form can't run checks, but since the Record field is not checked nothing wrong with having it accessible right in the list. Also, made it into a drop-down. Ttenbergen 13:39, 22 October 2010 (CDT)
  • corrected some code in Function TmpChecker that was allowing to send even if there was an error. Ttenbergen 13:53, 22 October 2010 (CDT)
  • fixed error where no initials in settings file would crash sending Ttenbergen 13:53, 22 October 2010 (CDT)
  • cleaned up pharm list Ttenbergen 14:29, 22 October 2010 (CDT)
    • made propofol bolus sort after inf by adding space before "inf"
    • deleted duplicate Milrinone inf entry
    • deleted duplicate Ceftazidime IV 500mg
    • deleted duplicate ASA Tab 81 mg (there is an 81.25)
    • deleted duplicate Ramipril 1.25mg (dupl. has "tab" in name like all the counterparts so I kept that one, same #s)
    • made milrinone bolus sort after inf by adding space before "inf"
  • For both DxChooser and ComoChooser:
    • made font bigger and combined listings for Main and SubDx to save spaceTtenbergen 14:29, 22 October 2010 (CDT)
    • added variable to allow program to go back to the most recently opened category (different var for Dx and Comorbid) Ttenbergen 14:57, 22 October 2010 (CDT)
  • fixed the implementation of the default drug sort to default to the most common doseTtenbergen 15:22, 22 October 2010 (CDT)
  • added code to open the output data automatically upon sending. Might as well automate this since collectors are now to check this themselves rather than call Pagasa. Ttenbergen 16:11, 22 October 2010 (CDT)
  • defaulted patient type to "Medical" for all new patients on medicine laptops. Ttenbergen 16:17, 22 October 2010 (CDT)

v1.9939

fixes:

  • v1.9939g - rolled out Ttenbergen 16:04, 21 October 2010 (CDT)
    • added S4 to the Var1/2 dropdown
  • v1.9939f - rolled out Ttenbergen 09:58, 21 October 2010 (CDT)
    • added E4 & S4 to the move places at the Grace
  • v1.9939e - rolled out Ttenbergen 17:09, 26 August 2010 (CDT)
    • made AdmitFrom, DischargeTo, HospitalPrevious dropdowns wider
    • changed BRR/XBR/Var2 checker to check if a form is open before setting fields to yellow to prevent crash on opening a patient with an existing error. Will probably have to do this for other checks as I find out about them.
  • v1.9939d - rolled out Ttenbergen 09:08, 24 August 2010 (CDT)
    • disabled setfocus in remaining uncheckers, was stalling program during FIO2 entry
    • confirmed that Home is now on top of discharge-to list
    • fixed tab-stops in Apache form
    • fixed tab-stops in Diagnoses form
    • changed tmp form so you no longer need to click the pencil before clicking edit
    • fixed hospital-previous sort order to (in-town, in province, in country) and then alphabetical
    • confirmed that the pathogen list is sorted (nothing or waiting and stuff) and then alphabetical
  • v1.9939c - rolled outTtenbergen 16:12, 20 August 2010 (CDT)
    • as Shirley pointed out, there is not really a point to count Comos since they are prioritized behind the scenes, so I am removing that check
    • fixed function that checks for too many entries in dx/drug/labs, was not working when no error.
  • v1.9939b - changed unchecker to not crash on PHIN check; rolled out Ttenbergen 11:08, 20 August 2010 (CDT)
  • v1.9939a - removed greensheet orphan check; rolled out Ttenbergen 09:33, 20 August 2010 (CDT)

rolled out Ttenbergen Aug 19

  • new version to fix what went wrong in previous, reverted one.
  • fixes
    • changed error checking in New Patient button routine, wasn't working right
    • fixed automatic release of sL_Records
    • for some reason pt list wasn't opening pts any longer, does again now
    • fixed layout of the complete-check boxes to correspond to new tab layout
    • fixed record field's tab order so that tabbing out of it will not go to an undefined record, silly thing
  • new stuff
    • Made chart# field wider, HSC uses 7+1 digits
    • fixed gotoo with two oo in laptop_data_path that caused an error at HSC to regular goto
    • put "home" at top of discharge-to list
    • reinstated macro sec setting changer; had previously been implemented, but caused error on StB Med PC because it had an old version of Access. That PC is no longer used with this program, so I re-instated it
    • removed references to GreenSheets
    • changed too-many checks so they only run when clicking the complete-check boxes. This should reduce a few errors

v1.9938

Reverted due to bugsTtenbergen 16:18, 15 July 2010 (CDT)

  • patient list changes
    • added "Find Patient" button to patient list
    • disabled editing on the patient list to prevent bypassing checks
    • added sorting buttons both ways for all columns in Patient List
  • added H7 as an option for tmp moves Ttenbergen 13:09, 7 June 2010 (CDT)
  • fixed phin field so it's never scientific notation Ttenbergen 13:12, 7 June 2010 (CDT)
  • made checkbox in tmp form into an actual checkbox on the tmp form Ttenbergen 13:15, 7 June 2010 (CDT)
  • moved registry tab to be first (wonder why it wasn't, hope there wasn't a reason Ttenbergen 13:18, 7 June 2010 (CDT)
  • deleted remnants of CPAP, SerUrea, DBili, UrineOutput, ActiveTx since no longer used Ttenbergen 10:54, 9 June 2010 (CDT)
  • changed font for instructions for tmp so they show up completely on form (some hidden off to right now)
  • changed order of apache labs - please comment at Feedback Request - Apache Labs Order
  • made sorting of Admit From and Discharge To such that local options (based on settings table) list first. Ttenbergen 11:17, 9 June 2010 (CDT)
  • changed lables for Var 3 and 5 to fit into the spaces
  • put PaO2/AaDO2 score onto main apache formTtenbergen 11:02, 9 June 2010 (CDT)
  • changed un-checking functions so they will not crash with BRR/XBR error when opening from patient list Ttenbergen 13:32, 9 June 2010 (CDT)
  • changed labchecker so e.g. duplicate labs entered after checking the error box can no longer get through. Ttenbergen 14:52, 2 July 2010 (CDT)
  • changed location box so it only accepts values in the dropdown list to prevent crash in tmp checker. Ttenbergen 14:54, 2 July 2010 (CDT)
  • changed pharmacy drop-down so that the most likely dose is the one that appears first, as per request by Laura Ttenbergen
  • limited labs in drop-down to those collected at location (ie HSC vs Others) Ttenbergen 15:41, 2 July 2010 (CDT)
  • changed ABG order as per following: Ttenbergen 16:02, 2 July 2010 (CDT)
    • ABG information in the standard order: Ph, then PCO2, then pO2
      • where does FIO2 figure in this list? Ttenbergen 11:05, 9 June 2010 (CDT)
        • Tina usually when an ABG is reported, the FiO2 is last but for our purposes it could be listed as first because this is something that we usually look at first to determine which ABG to use in the apache score.--LKolesar 13:51, 9 June 2010 (CDT)
  • added a column called "active" to the s_tmp table and changed all tmp related drop-downs to only list records where active is true Ttenbergen 16:12, 2 July 2010 (CDT)
  • correction to tableexists function, original could have never said "no" Ttenbergen 15:35, 16 July 2010 (CDT)

v1.9937

Rolled out. Ttenbergen 12:27, 17 May 2010 (CDT)

  • fixed ABG helper Ttenbergen 17:47, 13 May 2010 (CDT)
  • changed serCO2 apscore to be blank if ABGs are used Ttenbergen 12:13, 14 May 2010 (CDT)
  • fixed bug that left an admit or acquired dx blank without generating an error if the pathogen was blanked out. error only affected laptop locations.
    • Note: Ed's program would have caught a blank dx unless the blank one was the last one. So, this could not have led to pts without any data, but it could have led to a lowest priority dx missing. The pathogen data is defaulted to "No Value", so someone would have had to delete that for this bug to manifest itself . Ttenbergen 12:27, 17 May 2010 (CDT)

V1.9936

Rolled out Ttenbergen 12:07, 5 May 2010 (CDT)

  • made 763-30 (Defibrillator implant) non-mandatory OR as per email from Trish/Laura

V1.9935

Re-rolled because the original was of a bad version. Ttenbergen 10:35, 29 April 2010 (CDT)

  • removed following line which causes error in Access 2002 under certain circumstances
    • Application.automationsecurity = 2 ' means "msoAutomationSecurityLow" without reference necessary
  • change double-click on notes so that current changes to notes field (and rest of record) are written to DB before opening notes form. Thanks to Shirley Kiesman for catching and describing this! Ttenbergen 10:35, 29 April 2010 (CDT)

V1.9934

Rolled out Ttenbergen 10:12, 23 April 2010 (CDT)

  • hiding the ABG Checker button for medicine since they don't collect ABG. Ttenbergen 16:43, 22 April 2010 (CDT)
  • fixed pH checking stuff Ttenbergen 10:11, 23 April 2010 (CDT)

V1.9933

Rolled out. ' --Ttenbergen 15:16, 22 April 2010 (CDT)

  • CCMDB.mdb allowed entering an item for a project it was not associated with. Working on fix Ttenbergen 16:12, 30 March 2010 (CDT)
  • fixed tab order in Registry tab Ttenbergen 11:40, 9 April 2010 (CDT)
  • fix to ApDO2 calculator, form wasn't updating properly Ttenbergen 15:03, 9 April 2010 (CDT)
  • added automated settings changes to Database_starter function for full menus, correct macro security settings, auto-compact, automatically find with "any part of field"; some of these changes would only work once Access is restarted, so these are largely to ensure things stay set the right way.Ttenbergen 15:53, 9 April 2010 (CDT)
  • added "find dx" button to the Dx chooser to facilitate searching for diagnoses. Ttenbergen 16:01, 9 April 2010 (CDT)
  • made "view" button in patient list into binoculars and moved buttons/labels to save screen space. Ttenbergen 16:06, 9 April 2010 (CDT)
  • made "type" label in DX lister into a button that will re-sort the list to standard sorting; when entering directly this will make it easier to read the listing and make sure all is in there. Ttenbergen 09:37, 12 April 2010 (CDT)
  • took pH out of ABG testingTtenbergen 10:11, 14 April 2010 (CDT)
  • added Apache scores and score-listers to Apache values. Ttenbergen 10:11, 14 April 2010 (CDT)
    • Should the apache scores be visible for medicine, for those values collected in both programs? Ttenbergen 10:11, 14 April 2010 (CDT)
  • added "Add Patient" to patient list form, to be able to add patients from there rather than having to do so from the patient editor page. Ttenbergen 10:45, 14 April 2010 (CDT)
  • made function "add_record_status" to add record_status field to L_Log in preparation for new data repository. This has to be done locally for laptops since we don't have central access to the data, so automation was required. Ttenbergen 10:28, 15 April 2010 (CDT)
  • changed the notes field so that double-clicking the notes field will open it in a much larger window. Ttenbergen 15:50, 16 April 2010 (CDT)
  • changed Patient List and Viewer to open in maximized version. Ttenbergen 13:58, 20 April 2010 (CDT)
  • added "close" button to patient list. Ttenbergen 13:58, 20 April 2010 (CDT)

t1

test-fix 1: commented out add_record_status since it does not work on linked tables (i.e. on laptops). Change rolled to TestersTtenbergen 09:27, 21 April 2010 (CDT)

t2

test-fix 2:

  • fixed old error where non-overlapping duplicates were not allowed. didn't know this was still an issue.

Change rolled to Testers -Ttenbergen 14:06, 21 April 2010 (CDT)

t3

test-fix 3:

  • followed request to change sort order of pathogens to have the following first (codes 59 65 68 92 to top) :
    • negative culture
    • no culture sent
    • unknown pathogen
    • Aspiration ...

Change rolled to Testers-Ttenbergen 14:18, 21 April 2010 (CDT)

t4

test-fix 4:

  • fixed bug in ApDO2 chooser

Change rolled to Testers-Ttenbergen 15:06, 21 April 2010 (CDT)

t5

tweaks to duplicate checker; Change rolled to Testers-Ttenbergen 14:19, 22 April 2010 (CDT)

TESTING COMMENTS

  • Testers for version 1.9933 put you comments here. Thanks--TOstryzniuk 15:20, 19 April 2010 (CDT)

V1.9932

Put file into master for Trish to fix up peer-audit and roll. Ttenbergen 09:44, 12 March 2010 (CST)

  • Edited dx name for severe sepsis, original included definition and was too long to list properly in any fields.
    • Currently investigating other long dxs with TrishTtenbergen 14:19, 9 March 2010 (CST)
      • Decided to leave other long DXs alone for now for expedience. Ttenbergen 09:44, 12 March 2010 (CST)
  • ECHMO and co fix. Ttenbergen 14:48, 10 March 2010 (CST)
    • fixed spelling of ECMO (was ECHMO) in s_alldiagnoses
    • added ECMO and Line insertion as non-mandatory reasons for admission from OR, see Check_ORDx
    • made ECHMO -> ECMO change in s_handbase as well.Ttenbergen 14:51, 10 March 2010 (CST)
      • if ECMO, is in admit DX slots then must be from the OR.TOstryzniuk 15:24, 11 March 2010 (CST)
        • I'd rather keep this "can be". The ECMO case Laura told me about actually had ECMO put on in the ER. Ttenbergen 09:34, 12 March 2010 (CST)
  • Removed STB_B5 from s_locations. Ttenbergen 09:44, 12 March 2010 (CST)

V1.9931

added the following to peer_audits_partners and rolled out:

  • VIC S4 VIC_S5 Shirley - added 2010-03-03 as per Shirley's request due to Tara's LOA
  • VIC S5 VIC_S3 Wendy - added 2010-03-03 as per Shirley's request due to Tara's LOA

Ttenbergen 14:26, 3 March 2010 (CST)

V1.993

V1.993 Status

Rolled out. Ttenbergen 11:47, 24 February 2010 (CST)

V1.993 Changes

  • changed end date for QA Septic Shock: QASeptic_Stop = #12/31/2010#
  • pathogen listing made wider
  • ensured dx sorting is same in dx form data source (changed query in properties) as in send_dxs (changed L_DiagnosesSort) to fix bug where two dxs of equal priority would give OR_DX error to the exclusion of the actual priority error. This didn't affect output because a duplicate priority error would have been launched if the other error had not happened first.
  • ABG Helper button and form added to facilitate AaDO2 calculation
  • BP Helper button added, not yet functional
  • Changed the way check functions access data from using using "Set this_db = CurrentDb" to accessing CurrentDB directly; had used this_db to address a different error earlier on which no longer seems to be a problem
  • changed query Check Renal IncompatibleDxs to implement changes in Renal Coding Considerations (old)#Competing_Diagnoses
  • changed Pending_Julie to list discharge dates even if a time is not entered

V1.992

Status

  • Copy back to Master and rolled out.--TOstryzniuk 18:18, 14 January 2010 (CST)
  • rolled out Ttenbergen 11:24, 7 January 2010 (CST)

Changes

  • changes to Peer Audit Partners table.--STB_B5 added. Gayles PDA is know as B5 not E6 because location_setting are hard coded into HanDBase. --TOstryzniuk 20:00, 20 January 2010 (CST)
  • changes to Peer Audit Partners table made.--TOstryzniuk 18:18, 14 January 2010 (CST)
  • duplicate checker changed to disregard audit patients (an audit patient might move to a collector's home ward). Tina

V 1.991

  • Peer audit table comment column added to include Original PDA location setting and other notes for IT and data processing. Rolled out.TOstryzniuk 17:26, 4 January 2010 (CST)

Batch File Changes

~Nov-dev 2009 Changed batch files to create a total of 20 previous versions for each location to retain data. Ttenbergen 12:21, 30 November 2009 (CST)