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.

Bugs

Date/Time

• New version of laptop has errors in the data set rule. It is giving a null value error after you enter a time. We could before this version just type in the time and not use the :/ and now it comes up as an error.gogogirl 14:38, 6 October 2009 (CDT)
  • Thanks for the report, and for making me aware we needed this spot for it. Chances are if you got this problem, so does everyone else, since all collectors use the same CCMDB.mdb again now. Which field are you working with when this problem arises? And, I seem to remember you guys having some involvement with eHealth over there lately. What was done? Ttenbergen 14:51, 6 October 2009 (CDT)
    • It is in the registry page. Not on the temp studies when you also use

a time. It seems only to really be the time field in registry page. I am not aware of issues with ehealth. No wireless yet.gogogirl 15:09, 6 October 2009 (CDT)

Laptop Version Change Log

v1.92

rolled out Ttenbergen 14:36, 6 October 2009 (CDT)

• changed some output repositories to use shorter, more appropriately length strings for location and site
• caught an error for sending audit data to tmpv2

v1.91

rolled out. Ttenbergen 14:21, 2 October 2009 (CDT)

• re-enabled LOS check
• fixed error in ARF checker

v1.90

rolled out Ttenbergen 17:46, 30 September 2009 (CDT)

• implementation of some Renal Coding Considerations
  • Check Renal IncomaptibleDxs
  • Check ApARF CRF
• fixes to the APACHE value checks, errors for the first patient on a send list and some other stuff was getting through
• changed the temp studies tab to have edit buttons. when the edit button is used to edit entries, the correct label is shown dynamically drawn from s_tmp.
• added s_Tmp entries for QA Septic Shock

v1.89

• rolled out Ttenbergen 12:24, 29 September 2009 (CDT)
  • minor update to CheckORDXs function (wasn't working for entering new patient)
  • minor uptate to Check_pt_multiples to exclude out-of-province patients for PHIN checks.

• rolled out Ttenbergen 12:46, 25 September 2009 (CDT)
  • minor update to overlap function for Duplicate patient check,

• rolled out Ttenbergen 15:23, 24 September 2009 (CDT)
  • change for Catheter09
  • fixed and re-enabled Duplicate patient check
  • checks for Check_ORDx

v1.88

rolled out. Ttenbergen ~18:00, 23 September 2009 (CDT)

• eliminated PHIN and DOB from the minimal data set as per Minimal Data Set
• fixed date error for QA Infections to state ICU Infection Audit entries must have a date between the admit and discharge dates
• Tasks.mdb --> Tasks_1.mdb to fix bug on regional server/Twister connection
• removed duplicate data and empty box from Sent Report

re-rolled to fix another bug in "sending" and sent report change. Ttenbergen 11:25, 24 September 2009 (CDT)

v1.87

Took out check for duplicate patients because it found way too many. Will review logic. Rolled out. Ttenbergen 13:19, 15 September 2009 (CDT)

• added comorbid code 54300 Huntington's Disease to s_Alldiagnosis for ccmdb.mdb. Rolled out.--TOstryzniuk 17:18, 15 September 2009 (CDT)
• problem with corrupt s-alldiagnosis. Tina restored and rolled out.__16 September 2009
• added comorbid Huntington's Disease to S_CharlsonComorbid.pbd for HanDBase. Rolled out.__TOstryzniuk 12:22, 17 September 2009 (CDT)
• there was a problem with tables still being related, preventing synching, corrected and rolled out. Ttenbergen 09:25, 23 September 2009 (CDT)

v1.86

rolled out Ttenbergen 15:53, 14 September 2009 (CDT)

• fix GCS checking; Medicine data falsely didn't have this check applied since we moved to MOST collection. Ttenbergen 14:00, 9 September 2009 (CDT)

• create an error launching on opening if there are any multiples of patients based on any of the following:
  • same PHIN
  • same chart#
  • same first name, last name and DOB

• implemented Peer_Audit#Data_Sending

• fixed Pharmacy conversion issue. Since implementation of the new version we were not dividing by base quantity.
• re rolled out because some sites had files opened therefore didn't get update.--TOstryzniuk 18:22, 14 September 2009 (CDT)

v1.85

rolled out Ttenbergen 10:45, 3 September 2009 (CDT) Note: this was accidentally rolled out with the V still displayed as 1.84 on the main form.

• fixed consistency checks for QA Infection Audit so Medicine will not be asked to enter date
• fixed error checking for XBR BRR

v1.84

rolled out Ttenbergen 10:49, 27 August 2009 (CDT)

• added unwittnessed arrest to integrity rules for BRR
• discontinued output of PDA pending.xls based on from Trish 20 Aug 09

v1.83

Rolled out. Ttenbergen 09:17, 26 August 2009 (CDT)

• improved error when table relationship can not be set because a corresponding record does not exist in L_Log.
• fixed orphans query, which didn't include L_TmpV2
• got rid of legacy old orphan form code
• added code to drop all relationships if orphans are found, in order to make sure that the next synch will not be impeded by them
• currently looking for a way to prevent exiting out of program without dropping relationships...
• fix to the checks for QA Infection Audit

Ttenbergen 17:55, 25 August 2009 (CDT)

v1.82

not sure what happened in it, it was rolled out and is current version as of Ttenbergen 17:20, 25 August 2009 (CDT)

v1.81

Rolled out Ttenbergen 16:13, 20 August 2009 (CDT)

• improved the error given when the Regional Server can't be found
• confirmed that tmp_checker works with missing admit time
• removed TISS check box, as no one was using it
• disabled GreenSheet sending
• added ICU Infection Audit

v1.8

Rolled out Ttenbergen 16:45, 12 August 2009 (CDT)

• fixed bug: if a location was not entered for any patient the Tmp Checker was failing.

v1.79

Rolled out Ttenbergen 17:33, 11 August 2009 (CDT)

• made form and font sizes a lot bigger to better accomodate the laptops smaller screens. If this causes problems, lower your screen resolution.
• sorted patient list by serial number when in record view
• added S4 to the moves table.

v1.78

Rolled out Ttenbergen 14:04, 10 August 2009 (CDT)

• fixed relationship dropper to properly drop all relationships. Some were being retained, preventing the PDAs from synching properly.

v1.77

rolled out Ttenbergen 16:43, 5 August 2009 (CDT)

• added VA (Vic Ambulatory) to s_admitdischarge

v1.76

Rolled out. Ttenbergen 14:58, 5 August 2009 (CDT)

• fixed bug where Var2 wanted XBR/BRR for Medicine
• fixed bug where diagnosis pick list included como-only options

v1.75 ADLs in CC

Rolled out to laptop locations and test_trish. Ttenbergen 17:57, 30 July 2009 (CDT)

• hiding ADLs for CC
• added relationship builder to allow synching into this program with the PDAs.

(The laptop ccmdb depends on relationships to delete dx, como, etc records associated with a patient. However, relationships mess up the synch process. Relationships are now built programmatically when "main form" opens, and are deleted when the exit button is closed to close the main form. This means everyone will need to make sure to close the app with the exit button on the main form to make sure synching works.

This new functionality should not affect the laptops, so I am rolling it out to them. If Trish can find the time to test this with a PDA sync tomorrow including a send, and if it works, we should be able to roll this out to everyone. )

v1.7 Isolation output fix, minimum dataset, como sort order, autopsy field

Has been rolled out to laptop users. Ttenbergen 17:32, 30 July 2009 (CDT)

• fixed isolation output to be same as Master, see Isolation Bug
• fixed minimal dataset checking to allow absence of PHIN for non-MB patients
• changed co-morbid output from sorting by como-points descending to como-points descending and como-code ascending, to ensure that the same set of comorbids will always result in the same output. There might be a better secondary sort, e.g. an index of secondary como scores, but that would need to be developed and is not part of this update.
• the autopsy field always outputs as "N" now for all, regardless of what is entered. I can not remove the options from the DB since PDAs need them. DCs will need to be instructed in Survive / Expired / Autopsy field to stop collecting this as it is no longer being output

disabled green sheet checking - unknown version and date

• it's disabled in v1.6, i.e. green sheet entries are no longer required, but still being send for now.

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

• 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?
  • discussed with Julie. Doesn't matter. Just keep it positive. TOstryzniuk 14:17, 18 August 2009 (CDT)

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)