CCMDB Wiki

CCMDB.mdb Change Log 2009

Revision as of 17:19, 5 June 2009 by TOstryzniuk (talk | contribs) (→June 5, 2009)

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. When a change is tested and rolled out it is also documented here.

The 2009 CCMDB Change Log

start next entry

(please leave to provide edit link for small section)


June 5, 2009

  • S_tmp for CCMDB & HanDBase updated with Catheter09 study items
  • S_alldiagnosis updated Isolation-Task item to include another option (glove and gown)
  • Tested
  • Master CCMDB on Regional server updated. The ccmdb version that was in Master was re labeled as Version 11L.
  • rolled out.--TOstryzniuk 18:01, 5 June 2009 (CDT)

June 3.2009

2 Jun 09

  • Added a Delete Final-Checks button and functionality to the main form. Ttenbergen 16:47, 2 June 2009 (CDT)

May 27, 2009

Made some more changes as per Laptop Testing:

  • added diagnosis chooser

copied down for v0.10L this morning, following changes:

  • amended GCS verbal to state "vented" for the last three, output remains the same; now saying:
    • 6 vented-appears oriented
    • 7 vented-? oriented
    • 8 vented-no response
  • now accepting 0 doses and 0 days if drug is "No Drug"
  • fixed filter-complete bug that appeared during development somehow
  • added como chooser
  • made entry template for date of birth consistent with rest (dd-mmm-yyyy)

The ccmdb.mdb crashed as well. I recovered it. There should be no problems due to this, just adding this here for the record.

April 28, 2009

  • V0.7 copied down from Regional server Test_trish to desktop and snych into.
  • Copied back up to Master test_trish in folder called FROM TRISH v0.7 sycn into.
  • Not testedTOstryzniuk 20:54, 28 April 2009 (CDT)

April 27, 2009

V0.6 copied down from Regional server Test_Trish to desktop and synch into.

April 27, 2009

v0.7 - still coding

  • fixed a send problem that started with the changes to no labs/pharm
  • adding laptop switch in settings so that "exit program" button backs up to sd card before closing.

April 24, 2009

v0.6 uploaded to Trish_Test @ 21:11

  • fixed L_Lab checks to default counts to 0
  • fixed L_Lab checks to flag if “no labs” is used in conjunction with other labs
  • completely disabled checking for urine output since we don’t collect it any more
  • Missing pathogen now generates error msg and is not yellow when there is no error
  • Set following outputs regardless of what is in the data:
    • SerUrea: "<=9.0"
    • Urine: "No Value"
    • DBili: "No Value"
    • CPAP:"No"
  • Problem fixed with PHIN checker
  • changed ADL checks to reject all except acceptable values, and separated the check from the Reg and Variables check since it has its own checkmark
  • fixed task error so it doesn’t get overwritten by a blank
  • streamlined the checks to avoid running unnecessary repeats
  • (moved comments from here to requested changes)

April 23, 2009

  • Synch'd test data into V0.5 and copied back up to TEST_Trish on regional server into a folder call April 23.09 v0.5 FROM TRISH.
  • testing away.......problems forwarded to Tina.TOstryzniuk 18:02, 23 April 2009 (CDT)

April 22, 2009 - v0.5

  • planted in Test_Trish. Copied down to Trish's desktop for testing.

April 15, 2009 - v0.4

Currently being tested

  1. NO LABS and NO Pharmacy: removed no lab/pharm box, replaced with "no labs" and "no pharm" entries in L_Labs and L_Pharm, changed the check functions to accomodate this. PROBLEM: Can mark FINAL CHECK when no pharm or lab.--TOstryzniuk 15:52, 15 April 2009 (CDT)
  2. Added requirement and check for ICU Var 2 BRR, XBR if dx Witnessed Cardiac Arrest 100-2 in ADMIT or COMPLICATION DX. UPDATE: tested, this trap works.--TOstryzniuk 15:52, 15 April 2009 (CDT)
  3. setting button is now back on main ccmdb screen.
  4. Elimination of SAPSII items on the APACHE II screen
    • total Bilirubin, CPAP, urine CC;s, Urea,SAP_Systolic,
    • also - eliminate APACHE II Active TX field.
  5. CCMDB no longer requires Registry Patient Type to be entered (this was done earlier, but I don't think it was logged then--Ttenbergen 13:12, 23 April 2009 (CDT)]])
  6. Prevent discharge time = 0:00 getting through(this was done earlier, but I don't think it was logged then--Ttenbergen 13:12, 23 April 2009 (CDT)Ttenbergen)

April 10, 2009_Ver 0

  • DX code 794-28 Banding esophageal varices added to s_allDX table for CCMDB and HanDBase.
  • Copied to Programs\Master on Twister
  • rolled out to sites.--TOstryzniuk 15:24, 9 April 2009 (CDT)

April 3, 2009_Ver 0.1

  • Tina copied TEST version 0 of ccmdb.mdb to TEST_Trish on the Regional Server. Needs testing.
  • Tina have you come up with a version number scheme?_--TOstryzniuk 20:36, 4 April 2009 (CDT)
  • Seems that Tina has done this but didn't update info here. I see we are currently testing Ver 0.1 for Laptops.--TOstryzniuk 15:24, 9 April 2009 (CDT)

April 2, 2009_Ver 0

  • DX code 763-41 Impella-percutaneous VAD added to s_alldiagnosis tables in both Access (ccmdb.mdb) and HanDBase.
  • tested
  • rolled out to all sites.TOstryzniuk 17:35, 2 April 2009 (CDT)

March 19, 2009_Ver 0

RE: Cooling Protocol ICU Var 2 TAG for Witnessed Cardiac Arrest (100-2).

  • XBR added to Var 2 s_variables for HanDBase & ACCESS and form view in ACCESS.
  • Version Feb 6.09 tested, rolled out.--TOstryzniuk 15:26, 19 March 2009 (CDT)
  • Go HERE to review information regarding data integrity check rule.--TOstryzniuk 15:26, 19 March 2009 (CDT)
    • Tina still needs to program this rule into newer version of ACCESS so that check is automated. The version rolled out (Feb 6.09 ver) has information on the ACCESS form and s_table however the rule is not programmed into the new version that was being tested before she left on vacation.--TOstryzniuk 15:26, 19 March 2009 (CDT)

March 10, 2009

  • S_LOCATION for HanDBase updated on regional server added HSC_TEST.
    • NEW ACCESS (ccmdb.mdb) development & testing- Tina copied down to TEST_TRISH on Regional Server for testing.
      • trish copied to desktop, sych'd and copied back up to TEST_TRISH.
  • testing in progress.--TOstryzniuk 16:48, 10 March 2009 (CDT)
        • Progress of testing ACCESS: Lots of bugs. Problem items sent to Tina. No further testing until Tina returns from vacation and changes are made for further testing
          • suggestion to Tina: It would be helpful to have version numbers associated with CCMDB.mdb's so that we can keep track of updates.--TOstryzniuk 17:53, 16 March 2009 (CDT)
            • Done.

February 12, 2009

  • copying down ccmdb for requested chances as per below Ttenbergen 11:24, 12 February 2009 (CST)
  • added following
    • ICU Patients with Witnessed Cardiac Arrest (100-02) must have ICU Var 2= (BRR or XBR)
    • Check adm/discharge location against ICU patient location, can't be same
    • MI TPA 10210 you must not coexist with other MI 102-XX Note: update Myocardial infarction when uploading update!
  • for future laptop use
    • added "Show FinalChecks" button to be able to list and delete all files with FinalCheck set, e.g. after sending
    • added capability to add new records in Access. This required major changes, so thorough testing for weird errors is required. Ttenbergen 16:43, 26 February 2009 (CST)
  • Trish, let me know when you are ready to test and roll, for now I have not put it onto Trish_test as I will be adding more for the laptop functionality. Since you are on vacation right now I don't want to be held up until you are done testing. LEt me know when you have a chance.Ttenbergen 14:14, 18 February 2009 (CST)

February 6, 2009_Ver 0

  • IT Bugs
  • TASK bug Feb 5.09 (if CPAP YES then Isolation set to TOTAL when files are SENT out from ACCESS)
  • Tested. Bug elimimated--GONE!
  • Copied to MASTER on Regional Server
  • updated rolled out to all PDA's (version Feb 6.09).--TOstryzniuk 18:52, 6 February 2009 (CST)

February 5, 2009

Tina is stealing the master file to fix a bug.Ttenbergen 18:02, 5 February 2009 (CST) Fixed the bug listed in IT Bugs#Tasks Isolation Bug, sent to Trish for testing. Ttenbergen 18:18, 5 February 2009 (CST)

January 30, 2009

  • s_tmp MOVES table
  • the ward STB_B3 has been added to the moves table (s_tmp) for ccmdb & HanDBase.
  • Master ccmdb on Regional Server updated
  • rolled out
  • TOstryzniuk 14:56, 30 January 2009 (CST)

January 14, 2009

  • s_FIO2 table's for ACCESS (ccmdb) and HanDBase updated to include OxyMask FIO2 guess-ta-mits.
  • Master on Regional Server updated.
  • rolled out
  • TOstryzniuk 19:06, 14 January 2009 (CST)
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.mdb_Change_Log_2009&oldid=12816"