|
|
| Line 5: |
Line 5: |
|
| |
|
| == Change Log == | | == Change Log == |
| Starting 27 May 2008 the change log will be stored here. | | Starting 27 May 2008 the change log will be stored in the [[CCMDB.mdb Change Log]]. |
| | |
| * 27 May 08 - Added check to prevent midnight/empty admit time from being sent. Changed minimum value for [[WBC]] to 0.02 be consistent with Ed's program's checks.
| |
| | |
| === Import of earlier change log ==
| |
| ==== Tina's Log ====
| |
| Enter at the top from now on
| |
| | |
| May 2 - checking that Data-Cleaning Items are checked already.
| |
| | |
| Apr 2 - re-added "changed Smartpump checks to allow Vic to enter date/time" which was overwritten by a later change, I assume.
| |
| | |
| Mar 13 - changed Smartpump checks to allow Vic to enter date/time
| |
| | |
| Mar 10 - fixed error checking for smartpump to actually prevent send on error instead of just giving message. Sent to Test_trish for testing.
| |
| | |
| Feb 8 - starting changes for checks after chat with Pagasa, and processing for Smartpump study starting March 1.
| |
| - at HSC anything but a single move to <r_location> for someone admitted via ER will be flagged
| |
| - if two moves have the same move-date-time, they will be flagged
| |
| There will be further changes out of the meeting with Pagasa, but I wanted to get a version with the smartpumo updates into testing for now.
| |
| | |
| | |
| Feb 4 - updated tmpV2 checker to stop checking transfusions against packed cells; file now with Trish for testing.
| |
| | |
| Jan 28 - Updated Moves checker to flag moves <= admit and >= discharge (was < and >); copied to Trish_Test for testing
| |
| | |
| Jan 15
| |
| File is still down for HanDBase testing. Also did a correction to coding for discharge-to fields that are legitimately empty. Rolled out, but still on hold.
| |
| | |
| Jan 10
| |
| Stephanie asked me to add GRA_W4 to s_tmp and that she had discussed with Trish, so I did
| |
| | |
| Jan 9
| |
| added fields for Handbase synching to all tables, r*_...
| |
| | |
| Dec 18
| |
| Made and reverted changes for decubitus ulcer and to start writing to TmpV2_1 because the original got corrupted. Returned file to Trish several times since last update, but forgot to update log.
| |
| | |
| Dec 11-12
| |
| Adding Chart Number isnumeric check
| |
| Adding Decubitus ulcer study and checks.
| |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| -------------------
| |
| old records in whatever order...
| |
| | |
| Nov 10 @ 9:30
| |
| Made changes to file sending so StB ICU (old Access) and
| |
| all other sites can use the same ccmdb.mdb
| |
| | |
| Nov 14 @11:00
| |
| Changed sort order for Var1 and Var2 and deleted ICUs from that list.
| |
| | |
| Nov 15 @13:30
| |
| Changed Pagasa Output to show discharge dates even if there is no discharge time. Wasn't doing that before...
| |
| | |
| ---
| |
| Didn't enter into here while Trish was away, will start again now.
| |
| ---
| |
| | |
| Sep 25 @10:00
| |
| Fixed the Moves Checker, it was giving an error for move-time out of admit-discharge time, but it was not locking out. Does now.
| |
| | |
| Sep 25 @13:30
| |
| Taking down the master file for updates:
| |
| - Make AutoRanker for Labs and Pharm from Cost Data
| |
| - Change Var1-6 on the PDA to dropdowns
| |
| - Make an error checker to reject no moves for people admitted from ER in Tmp
| |
| | |
| Dec 5 @2:07
| |
| Changing output to tmpV2 to only send moves when complete
| |
| advised trish to go ahead and change s_tmp so that euro score
| |
| will only be sent once when complete.
| |
| | |
| ==== Trish's Log ====
| |
| Nov 8 @ 1500
| |
| Trish playing with latest version of CCMDB on desk top.
| |
| Trying to sort the ACCESS s_admitdischarge table by code.
| |
| Tina had fixed ACCESS so that it catches NO VALUES for ADL.
| |
| Works
| |
| | |
| | |
| Nov 8 @ 1710 hrs - roll out to all sites from Master.
| |
| Trish along with Tina, sorted the ADMIT from and discharge to
| |
| table in ACCESS.
| |
| Trish added STB ambulatory care to admit from or discharge to.
| |
| We excluded the option of BLANK in the ADMIT from table.
| |
| Copied to MASTER on twister
| |
| Rolled out to all site.
| |
| | |
| | |
| Nov 10.2006
| |
| trish Added M3 to variable 1 & 2 drop down table (RNVAR form )
| |
| in ACCESS and in S-variables 1 & 2.
| |
| Forgot how to sort so that M3 code is not at the bottom
| |
| Tina........could you do this? (Tina sorted).
| |
| | |
| Also, I see MICU, SICU, also CCU and IICU listed a number of
| |
| times in Var 1 or 2 drop down. These should not be there.
| |
| Not sure if I can take them out of here?
| |
| please advise. (Tina fixed ICU's taken out of this list).
| |
| | |
| | |
| Nov 15.06 @ 1855 Pm
| |
| Rollout batch file ran. All sites updated.
| |
| | |
| Nov 22.06
| |
| ACCESS drop down list is missing infection code 80 spinal ABCESS Drainage.
| |
| seems that in the DX column there is no YES or NO.
| |
| YES applied.
| |
| Rolled out to all sites successfully.
| |
| | |
| Nov 27.06 1220 PM
| |
| Address with Tina Nov 23. Data collectors are able to send
| |
| patient file in with MISSING DX green sheets.
| |
| If they do not ADD a page for green sheets, ACCESS will allowing
| |
| sending blank pages and it shows up in greensheet.mdb
| |
| as missing.
| |
| Waiting for Tina to fix.
| |
| | |
| - also: serial number sequence order. Collector as accidentatly
| |
| assigning a wrong serial number. For example: Galye B5
| |
| Serial sequence is 2630-2680, yet for one patient she assigned
| |
| a serial number of 3640 which is way off.
| |
| | |
| Tina - anyway to catch numbers that are way out of range from
| |
| sequence that are sent in?
| |
| | |
| April 11 7 12.2007
| |
| Trish - added code 831-9, and 542. Fixed 884 so that it can
| |
| be used in both main Dx & comorbid. Rolled out to all sites.
| |
| | |
| September 24,2007- Oct 12.2007 ROLLED OUT Oct 12.07
| |
| Code 763-sub code 01,02,20,21 word clarification
| |
| Thrombolytic infusion:
| |
| 763-01 Thrombolytic infusion Regional (PVD & plugged catheters)
| |
| 763-02 Thrombolytic infusion Strokes
| |
| 763-20 Thrombolytic infusion Cardiac
| |
| 763-21 Thrombolytic infusion Pulmonary Embolus
| |
| | |
| Corretion to s-all DX s spelling: Myeglobinemia
| |
| | |
| NEW CODE- as per Dr. Roberts:
| |
| 763-38 Line insertion ONLY as primary reason for admission
| |
| | |
| Tina working on FILTERS for MOVES for Med database
| |
| | |
| New CODE
| |
| Lung transplant
| |
| 805-04 Cadaver Donor
| |
| 805-05 Living Donor
| |
| | |
| Nov 22.07 Trish
| |
| s_tmp MOVES
| |
| VIC -N2 removed (surgery on 4th floor will be know as S2)
| |
| VIC -SS2 changed to S2. SS2 is an error.
| |
| Rolled out
| |
| | |
| Nov 27.07 1850 hrs
| |
| ACCESS
| |
| s_admitdischarge table is missing code GA - vic ambulatory care.
| |
| It is in the handibase admitdischarge table.
| |
| updated ACCESS in Master and rolled out.
| |
| | |
| Dec 6.07 1655 hrs
| |
| ACCESS
| |
| s_tmp - Tina fixed so that move data is only sent once when complete.
| |
| Euroscore set so that data in only sent once.
| |
| Rolled out
| |
| | |
| Dec 13.07
| |
| issues with TMV2 crashing & locking up. Problem started Dec 11 or 12.
| |
| Tina not sure of the cause. tina replaced with Tmpv2_1 and will
| |
| merge tmpv2 data with tmpv2_1. Because of this problem people could
| |
| not send. CSV file would arrive but moves and tasks would not.
| |
| Tested - able to sent out with out crashing.
| |
| ROLLED OUT
| |
| | |
| Dec 17.2007
| |
| Decubitus Ulcer items added, but decided that it is labor intensive and
| |
| not cost effective to enter into tmpv2_1, so it has been deleted.
| |
| Tested -all items related to decubitus deleted including s_tmp
| |
| for handibase Tina has fixed up.
| |
| Tested - able to send out without any problems. Jan and Pagasa checked.
| |
| ROLLED OUT
| |
| | |
| Jan 4.08 Code 875 Radio Active Iodine TX code added.
| |
| Rolled out
| |
| | |
| Jan 10.08
| |
| Trish aware of GRACE-W4 added to tmp file for MOVES. Tina has added
| |
| to MASTER and rolled out. Trish copied latest to her desktop
| |
| | |
| Jan 21.08
| |
| Tina rolled out a CCMDB: PC transfusion audit crosschecking with lab PC count.
| |
| | |
| Jan 22.08
| |
| STB reported sending problems. Tina fixed tmpv2 PC transfusion checking
| |
| with lab PC count. Rolled out before Regional server crashed.
| |
| Regional server is up and down last 2 days.
| |
| | |
| Jan 23.08
| |
| Code 361 & 805 Main Dx label clarification. Instead of both being Renal Transplant:
| |
| 361 Renal Transplant Problems & 805 Renal Transplant Surgery.
| |
| Updated in s-alldiagnosis for ACCESS and Handibase.
| |
| Ed also fixed ICU and Medicine ICU database labels.
| |
| Trish copied to Master.
| |
| Rolled out to all sites.
| |
| | |
| Jan 25.08
| |
| ACCESS and Handibase table updates.
| |
| 1. s_tmp MOVE-updated to inlcude GRA S2 (orthopedics ward)
| |
| 2. s_ADMITDISCH -update to include St Amant center. Code AW.
| |
| | |
| Rolled out
| |
| | |
| Jan 29.08
| |
| ACCESS & Handibase changes
| |
| 1. s-pathogen table updated with subcode 95 West Nile.
| |
| ACCESS changes
| |
| 2. Move before ADMIT or AFTER discharge - trapping in ACCESS so data collector
| |
| can't send in with this type of error.
| |
| 3. Tina fixed so that a NAME is not allowed in the chart number slot.
| |
| 4. Date and time at the top of the ACCESS screen (beside chart number),
| |
| this date is now the admission date and time not the file creation date and time.
| |
| | |
| Rolled out
| |
| | |
| Jan 31.08 1800 hrs
| |
| ACCESS - s-admitdischarge missing St Amant center code AW.
| |
| Not sure what happen. Copy on desktop prior to making change had the change in it.
| |
| Fixed
| |
| Copy to MASTER
| |
| | |
| Rolled out
| |
| | |
| Feb 4.08@ 1425 hrs
| |
| Transfusion study stopped Jan 31.08.
| |
| Tina DISABLED the cross checking in ACCESS of # of transfusions in tmp
| |
| vs # PC in Lab.
| |
| (cross check was so PC in labs = # of transfusion in
| |
| tmp before sending allowed).
| |
| | |
| Rolled out
| |
| | |
| Feb 12.08 1700 hrs
| |
| Testing latest updates to CCMDB - PUMP AUDIT for March 1.08 with numbers 1-8
| |
| for comment options.
| |
| Problem with ACCESS blocking admit from HA or BA with a move. HA or BA may or may not
| |
| have a move. If there is a move, then comment "ER", must be
| |
| included.
| |
| | |
| Plan to roll out February 25.08 when TINA returns for vacation. Reminder in Outlook.
| |
| | |
| | |
| Feb 13.08 1200 hrs.
| |
| Tina blocked the out the MOVE from HA check. Will work on testing move checks
| |
| when she returns on February 25.08
| |
| | |
| Current verion I have copied to desk top and will continue to test.
| |
| If okay will roll out after February 25.08
| |
| | |
| Feb 14.08
| |
| Feb 4.08 Version in MASTER updated DX
| |
| NEW CODE 763-39 ECHMO
| |
| Updated s-allDX in MASTER CCMDB and s-all DX for handibase.
| |
| rolled out
| |
| | |
| Feb 25.08 1310 hrs
| |
| Tested. This is the Feb 13.08 version (feb 13 note above).
| |
| Changes: Some moves, Colleague Pump audit for March 3 to 23
| |
| Problems with pump audit found.
| |
| Copied to Master & rolled out with bugs.
| |
| | |
| Feb 26.08 1800 hrs. Tina fixed and applied following rules in ACCESS:
| |
| | |
| 1. If Guardian Software used then:
| |
| -check mark YES
| |
| - no integer variable should be allowed
| |
| -manually typed it comments not needed.
| |
| | |
| 2. If Guardian software not used then:
| |
| -check mark NO
| |
| -an integer variable code required (1 to 7)
| |
| -manually typed in comment not needed
| |
| | |
| 3. If Guardian software not used then:
| |
| -check mark NO
| |
| -integer variable code 8 is used
| |
| -a manually typed in comment is needed
| |
| | |
| 4. Julie- 1 to7 int_var should be converted A to G as agreed by Julie and Tina
| |
| This is to keep comment codes consistent to last audit.
| |
| Tested
| |
| Copied to Master
| |
| Rolled out 1910
| |
| | |
| March 7.08 1045
| |
| 763-39 missing from S_allDiagnosis in ACCESS. Not sure why. back up copy on Trish
| |
| Desktop show code and this was the version copied into MASTER, as per note above.
| |
| Re-inputted it into s_ALLDX in MASTER.
| |
| Rolled out to all sites.
| |
| | |
| Mar 10 1520 hrs
| |
| Tina fixed error checking for smartpump to actually prevent send on error instead of just giving message.
| |
| Tested - trap is working not allowing to SEND if there are still errors in smart pump.
| |
| Copied to Master.
| |
| Rolled out to site.
| |
| | |
| Mar 13.08 1430 hrs.
| |
| Tina changed Smartpump checks to allow VIC to enter date/time in DtTm_var field.
| |
| this is an exception for VIC.
| |
| When VIC sends in Data, Pagasa to copy and paste DtTM_var field to collection dt/time field.
| |
| Update copied up to VIC medicine ONLY
| |
| | |
| | |
|
| |
|
|
| |
|