CCMDB.mdb Change Log 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.

Parallel Master File Changes

Trish has made a few administrative updates to the master file while we develop the laptop version. These changes should be tracked in this section to make sure they get consolidated with the laptop version. Once incorporated, I will move the change into the main log.

• all changes to Master are currently included in the laptop version as of v1.3 Ttenbergen 12:49, 14 July 2009 (CDT)

Laptop Version Change Log

Active Tx - unknown version and date

• Not sure in which version this was done, but the active tx link is no longer shown in ccmdb v1.6.

Received go-ahead from Trish to get rid of Active Tx field. The field itself will need to stay due to its presence in HanDBase but I will make it invisible in CCMDB.mdb. Also, the output will be corrected to always state the negative. This will become active when the currently testing version rolls out.

Change made:

• hidden active tx field in for CC (was already hidden for Med after MOST)
• change output so that active tx is always positive

Discussion

(the request had been for it to be always negative, but the output since the change has been to be always positive. Does Julie want this changed to be always negative? Template:Discussion

V1.6

Added checking for minimum data set. Before this, missing location data would break the pending queries. Rolled out.Ttenbergen 15:04, 28 July 2009 (CDT)

09 jul 22 - v1.4 FIO2 + sending + Local L_ Tables + Notes

Rolled out to Vic and GRA_MICU, will copy down next time they use the news batch while logged onto the network. Also copied to Test_Trish. Ttenbergen 13:13, 22 July 2009 (CDT)

• changed FIO2 dropdown to display the percentage after choosing, not the modality; this may still cause confusion, see FIO2
• confirmed sending for CC
• reinstated the local L_Tables that will be required for running this version with the PDAs. These will be deleted and replaced by linked tables if L_Settings says that a laptop is used. I still need to figure out how to re-introduce the relationships into the program for the local tables.
• fixed the error that was being caused by the notes field
• added a reset button to the main form as temp fix for the object-with problem, as I can not find the cause at this time

July 16 - CC sending - v1.3

• Fixed CC sending. There are problems with the export specs that keep coming up, hopefully fixed for good this time since I redid them. Ttenbergen 12:46, 14 July 2009 (CDT)

(I had not rolled it out on Jul 14, so more change:)

• changed default for Pharmacy entry to "No Drugs" to be consistent with Labs. Also made that entry to be limited to the list, which it had not been. Ttenbergen 15:42, 16 July 2009 (CDT)

v1.2 FIO2 dropdown fix

Now displays all 3 columns, not just percentages.Ttenbergen 16:00, 9 July 2009 (CDT)

v1.1 output fixes

The laptops are now in pilot testing mode at the Vic, so I have changed versions to 1.<subversion> V1.1:

• re-write of the output functions for Critical Care and Medicine to deal with Access limitations.Ttenbergen 14:53, 9 July 2009 (CDT)

June 24.09

• S-tmp for CCMDB & HanDBase - Var 5 - H7 added. This is to tagged all HSC H4H patient that are in H7 starting June 24.09
• rolled out to sites.--TOstryzniuk 13:04, 24 June 2009 (CDT)

19 June 2009

made v0.14 with following changes:

• added zoombox for notes (if you click into notes, a bigger edit window pops up)
• added check to filter to not filter if there are no patients with record set to "C" to prevent errors
• fixed checks to run after changes for labs and pharmacy
• hidden Database details window to prevent inadvertent changes
• added a check in sending that tests for a regional server connection
• records dropdown now uses table stored in settings as source; settings button allows editing of that dropdown

These changes require an update of the settings file and the data file, so they can't be set up until I visit the Vic on Tuesday.Ttenbergen 15:37, 19 June 2009 (CDT)

June 18.09

• 2000 hrs -"send complete" in s-tmp ccmdb.mdb for H1N1. TOstryzniuk 20:14, 18 June 2009 (CDT)
• 1650 hrs-CCMDB.mdb-check sent when complete for H1N1 as per discussion with Julie. Rolled out.TOstryzniuk 17:04, 18 June 2009 (CDT)

• added H1N1 negative to s_tmp in Handibase and CCMDB.mdb.
• copied to master from trish desktop
• rolled out.TOstryzniuk 12:50, 18 June 2009 (CDT)

13 Jun 09

Moved ver 0.11L to Test_Trish for testing by Vic VicCollectors - can you copy this to the laptop for testing? Let me know if you need help!

• re-incorporate the s_* files changed since the laptop version split off the Master.
• change time format in L_TmpV2 to be same as others
• fix expired requiring discharge location
• added button to delete final-checked records (i.e. after sending)

Ttenbergen 16:21, 12 June 2009 (CDT)

June 12, 2009

• s_tmp for CCMDB & HanDBase: Catheter09 - "UTI post in" label changed to "got UTI". Display problem because label on letter too long.
• tested.
• copy to master on Regional Server.
• rolled out to sites.TOstryzniuk TOstryzniuk 16:12, 12 June 2009 (CDT)

June 11, 2009

• latest version of CCMDB and S-Tmp rolled out. (does not include laptops tested at VIC)TOstryzniuk 13:21, 11 June 2009 (CDT)

June 10, 2009

• fixed up Catheter09 s_tmp for Handbase. UTI label should be "UTI post in" to make it the same as CCMDB s_tmp.
• H1N1 suspected & H1H1 confirmed options added to TMP. Will start tagging all patients retrospective and new admits. For more information see article H1N1.
• s_TMP: MOVES: VIC_S3 added back in.
• Copy of trish testing ccmdb to Master on Regional server.TOstryzniuk 20:37, 10 June 2009 (CDT)
• still seeing a graphical checkbox on PDA in L_tmpv2 for "UTI post in". Waiting for Tina to advise on this before roll out.
  • How is seeing a graphical checkbox for UTI Post in a problem? It was assigned to the check box variable, was it not? Ttenbergen 13:30, 11 June 2009 (CDT)

June 9, 2009

• Catheter09 - s_tmp for ccmdb & HanDBase. Updated with an additional reason for insertion: R-unknown. Rolled out to sites.--TOstryzniuk 18:30, 9 June 2009 (CDT)

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

• Catheter09 - foley catheter study for STB medicine - s_tmp updated for HanDBase and CCMDB.mdb.---TOstryzniuk 18:47, 3 June 2009 (CDT)

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)