|
|
| (127 intermediate revisions by 12 users not shown) |
| Line 1: |
Line 1: |
| The '''CCMDB.mdb''' is the Access program the PDAs sync into. It screens the data for internal consistency and ranges, and then exports it in a format that can be imported into TMSX. | | The '''CCMDB.accdb''' is a Microsoft Access database, with the name being the acronym for '''Critical Care Medicine Database'''. CCMDB.accdb screens the data for internal consistency and ranges, and then exports it for further processing during [[Sending Patients | sending]]. |
|
| |
|
| Each PDA has a combo of two Access databases associated to it: a ccmdb.mdb file which is identical for all until synced into, and a [[settings.mdb]] which contains location specific information such as the path to the regional server, and the hospital and ward names. Any data in the ccmdb.mdb is considered transient, the file can be replaced with an empty new version at any time. Rolling out new versions is done by batch and a file that is currently open will not be overwritten.
| | == Updating of CCMDB.accdb Program == |
| Additionally, this programs folder contains a \Master directory where the master version of the ccmdb.mdb is stored. Any changes required to the program can be made on this master file, and then rolled out by copying the master\updt_all.bat batch file to a local drive (batch code can’t cope with running from an unnamed drive) and running it.
| | Rolling out new versions of [[CCMDB.accdb]] is done by Tina or Lisa using [[:Category: Batch Files | a batch file]] called [[updt_all.bat]]. See the update [[Log]] for information about changes, and see [[Requested CCMDB changes for the next version | Requested Changes]] for changes planned for the future. |
|
| |
|
| == Change Log == | | == Data in the CCMDB.accdb == |
| Starting 27 May 2008 the change log will be stored here.
| | Data in CCMDB.accdb is stored in |
| | * c:\ccmdb_data\CCMDB data.mdb |
| | * see: [[CCMDB data.mdb]] |
| | See also [[Laptop Setup]] |
|
| |
|
| * 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.
| | == Form Sizes == |
| | The form sizes on the laptops are continuously being tweaked to accommodate, especially, any of the laptops we use. |
| | The form size was increased to accommodate the screens on the laptops which are small but have a high native resolution. |
|
| |
|
| === Import of earlier change log == | | == Password == |
| ==== Tina's Log ====
| | Located: \\AD.WRHA.MB.CA\WRHA\HSC\SHARED\WRHA\WRHA_CCMED\Passwords_mainoffice\Passwords_MainOffice_use.xlsx |
| Enter at the top from now on
| |
|
| |
|
| May 2 - checking that Data-Cleaning Items are checked already.
| | The password for the [[CCMDB.accdb]] is known as "the tasty password". If you don't know it, and need to know it, talk to [[p:Trish Ostryzniuk |Trish]] or any data collector. All data collectors need to be thoughtful as to who they give this password out to. |
|
| |
|
| Apr 2 - re-added "changed Smartpump checks to allow Vic to enter date/time" which was overwritten by a later change, I assume.
| | The [[CCMDB.accdb]] is using the same password everywhere. This used to be required to make sure the PDAs work. It is now required because collectors cover at different locations and using different passwords would get people to write them down. Since laptops are encrypted, and accessed using the user's network password, this should not be a problem. |
|
| |
|
| Mar 13 - changed Smartpump checks to allow Vic to enter date/time
| | == Related articles == |
| | {{Related Articles}} |
|
| |
|
| Mar 10 - fixed error checking for smartpump to actually prevent send on error instead of just giving message. Sent to Test_trish for testing.
| | [[Category: IT Instructions]] |
| | | [[Category: Data Repository]] |
| Feb 8 - starting changes for checks after chat with Pagasa, and processing for Smartpump study starting March 1.
| | [[Category: CCMDB.accdb | *]] |
| - at HSC anything but a single move to <r_location> for someone admitted via ER will be flagged
| | [[Category: Password]] |
| - 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
| |
| | |
| | |
| | |
| | |
| ==Additional Info Required==
| |
| some of these as separate pages
| |
| *''''' Checking your Data in Access
| |
| *''''' starting Access
| |
| *''''' filtering to complete only
| |
| *''''' Yellow fields and error messages
| |
| *''''' Sending your data | |
| *''''' Deleting data once you have the OK, ...
| |
| | |
| | |
| {{discussion}}
| |
| == Discussion ==
| |
| * any thoughts
| |
| | |
| | |
| | |
| {{stub}}
| |
| [[Category:IT Instructions]] | |