CCMDB.mdb Change Log 2009

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.

• see Requested CCMDB changes for NEW version. This is the direct to Access data collection input that is being worked on.
• see CCMDB Change Log for 2008 for changes made and rolled out in 2008.

The 2009 CCMDB Change Log

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 Cardiac Arrest Witnessed 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.

April 10, 2009

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