CCMDB Wiki

CCMDB.mdb Change Log 2009: Difference between revisions

← Older edit
m Text replacement - "s_Tmp" to "s_tmp table"
 
(31 intermediate revisions by 2 users not shown)
Line 1: Line 1:
*See [[CCMDB.mdb Change Log 2010]]
''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''
''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''


Line 11: Line 13:
Rolled out [[User:Ttenbergen|Ttenbergen]] 18:40, 29 December 2009 (CST)
Rolled out [[User:Ttenbergen|Ttenbergen]] 18:40, 29 December 2009 (CST)
====Status====
====Status====
*Copied to trish desktop.  Not rolled out yet.
{{Discussion}} 
*Questions emailed to Tina - RE: CON data used for test files and also question about 3 or more L_files for every item??--[[User:TOstryzniuk|TOstryzniuk]] 12:33, 24 December 2009 (CST)
** Questions addressed with Trish, rolling out. [[User:Ttenbergen|Ttenbergen]] 18:40, 29 December 2009 (CST)
*V1.991-can't remember what the change was, but it's updated now. [[User:Ttenbergen|Ttenbergen]] 15:58, 23 December 2009 (CST)
Further changes:
Further changes:
* updates to peer audit partners table for Pat HSC and Debbie StB[[User:Ttenbergen|Ttenbergen]] 14:34, 30 December 2009 (CST)
* updates to peer audit partners table for Pat HSC and Debbie StB--[[User:Ttenbergen|Ttenbergen]] 14:34, 30 December 2009 (CST)


===v 1.99===
===v 1.99===
Line 25: Line 22:
====Changes====
====Changes====
* pathogen field now mandatory; previously if the pathogen was deleted the entire diagnosis would not show up in the output .csv; if there is no pathogen, the default "No Value" needs to be used.  
* pathogen field now mandatory; previously if the pathogen was deleted the entire diagnosis would not show up in the output .csv; if there is no pathogen, the default "No Value" needs to be used.  
* fixed Vic_s3 entry for peer_audit_table, was Vic-S3 (changed manually for Shirley to send)
* fixed Vic_s3 entry for peer_audit_table, was Vic-S3 (changed manually for [[p:Shirley Kiesman]] to send)
* function that refreshes connection to L_settings now checks for existence of the table before trying to delete it. In the past, if the table was not there, initiation would fail.
* function that refreshes connection to L_settings now checks for existence of the table before trying to delete it. In the past, if the table was not there, initiation would fail.
* s_tmp_QASeptic_Dx_no_tmp now excludes patient IDs in the peer audit range
* "query s_tmp_QASeptic_Dx_no_tmp" now excludes patient IDs in the peer audit range
* s_tmp_QASeptic_tmp_no_dx now excludes patient IDs in the peer audit range
* [[query s_tmp_QASeptic_tmp_no_dx]] now excludes patient IDs in the peer audit range
* s_tmp_QAInf_tmp_no_dx now excludes patient IDs in the peer audit range  
* [[query s_tmp_QAInf_tmp_no_dx]] now excludes patient IDs in the peer audit range  
* s_tmp_QAInf_dx_no_tmp now excludes patient IDs in the peer audit range
* [[query s_tmp_QAInf_dx_no_tmp]] now excludes patient IDs in the peer audit range
 


===v 1.9852===
===v 1.9852===
Line 39: Line 35:
*When you open Access you will see on the front page bottom right Version 1.9852.  If you don't have this version after you synch your PDA or run New and backup if you have a Laptop, please let Tina or I know ASAP. --[[User:TOstryzniuk|TOstryzniuk]] 17:38, 16 December 2009 (CST)
*When you open Access you will see on the front page bottom right Version 1.9852.  If you don't have this version after you synch your PDA or run New and backup if you have a Laptop, please let Tina or I know ASAP. --[[User:TOstryzniuk|TOstryzniuk]] 17:38, 16 December 2009 (CST)
*[[Peer Audit Partners]] table - HSC_A4 to audit HSC_B3 added to this table.  HSC_A4 to audit HSC_D4 already there.--[[User:TOstryzniuk|TOstryzniuk]] 18:58, 16 December 2009 (CST)
*[[Peer Audit Partners]] table - HSC_A4 to audit HSC_B3 added to this table.  HSC_A4 to audit HSC_D4 already there.--[[User:TOstryzniuk|TOstryzniuk]] 18:58, 16 December 2009 (CST)
[[Image:Christmas stocking.gif]]
*sent back to Test_Trish for Testing[[User:Ttenbergen|Ttenbergen]]
*sent back to Test_Trish for Testing[[User:Ttenbergen|Ttenbergen]]
*copied to Trish_Desktop.--[[User:TOstryzniuk|TOstryzniuk]] 17:57, 10 December 2009 (CST)
*copied to Trish_Desktop.--[[User:TOstryzniuk|TOstryzniuk]] 17:57, 10 December 2009 (CST)
Line 60: Line 55:
** send module for checking CC/Med
** send module for checking CC/Med
** check_peer_audit_audit_serial_reg_send and vs or ???
** check_peer_audit_audit_serial_reg_send and vs or ???
{{Discussion}}
*Is item above an integrity check?
** fixed up peer audit table--[[User:TOstryzniuk|TOstryzniuk]] 22:55, 9 December 2009 (CST)
** fixed up peer audit table--[[User:TOstryzniuk|TOstryzniuk]] 22:55, 9 December 2009 (CST)
** s_alldiangonsis - Dermatomyocitis & Von Willebrand Disease- spelling fix--[[User:TOstryzniuk|TOstryzniuk]] 22:55, 9 December 2009 (CST)
** s_alldiangonsis - Dermatomyocitis & Von Willebrand Disease- spelling fix--[[User:TOstryzniuk|TOstryzniuk]] 22:55, 9 December 2009 (CST)
Line 85: Line 78:
**added to CCMDB STB_5B to:  s_Var options (var 1 & 2), S_Tmp_moves_required, S_Location --Trish
**added to CCMDB STB_5B to:  s_Var options (var 1 & 2), S_Tmp_moves_required, S_Location --Trish
**NOTE: HanDBase: added STB_5B to: s_Var1Opts, s_Var2Opts, s_locations, S_tmp.pdb (moves.--Trish
**NOTE: HanDBase: added STB_5B to: s_Var1Opts, s_Var2Opts, s_locations, S_tmp.pdb (moves.--Trish
{{Discussion}}
* added query "check_peer_audit_audit_serial_reg_send" to ensure no peer audit serial numbers (111-140) get sent with non peer audit (regular) serial numbers.  
* added query "check_peer_audit_audit_serial_reg_send" to ensure no peer audit serial numbers (111-140) get sent with non peer audit (regular) serial numbers. Is this what you meant Tina?--[[User:TOstryzniuk|TOstryzniuk]] 19:18, 30 November 2009 (CST)
* added query "check_peer_audit_invalid_serial_audited" to ensure that no non peer audit serial numbers get sent as peer audit files.
* added query "check_peer_audit_invalid_serial_audited" to ensure that no non peer audit serial numbers get sent as peer audit files.
* edited query "Pending_Julie" and "Pending_Pagasa" to exclude peer audit serial numbers
* edited query "Pending_Julie" and "Pending_Pagasa" to exclude peer audit serial numbers
Line 106: Line 98:


*added to S_tmp for HanDBase and CCMDB - for Project Catheter 09 Item W - Not Applicable.--[[User:TOstryzniuk|TOstryzniuk]] 17:25, 4 November 2009 (CST)
*added to S_tmp for HanDBase and CCMDB - for Project Catheter 09 Item W - Not Applicable.--[[User:TOstryzniuk|TOstryzniuk]] 17:25, 4 November 2009 (CST)
* fixed error in pharmacy check where a duplicate priority just gave the error "False" - thanks for the pointer [[Betty DeVlaming | Betty]] [[User:Ttenbergen|Ttenbergen]] 14:27, 29 October 2009 (CDT)
* fixed error in pharmacy check where a duplicate priority just gave the error "False" - thanks for the pointer [[p:Betty DeVlaming | Betty]] [[User:Ttenbergen|Ttenbergen]] 14:27, 29 October 2009 (CDT)
* patient view called from PatienList no longer has record navgation buttons on the bottom [[User:Ttenbergen|Ttenbergen]] 11:24, 30 October 2009 (CDT)
* patient view called from PatienList no longer has record navgation buttons on the bottom [[User:Ttenbergen|Ttenbergen]] 11:24, 30 October 2009 (CDT)
* removed Greensheets tab [[User:Ttenbergen|Ttenbergen]] 11:27, 30 October 2009 (CDT)
* removed Greensheets tab [[User:Ttenbergen|Ttenbergen]] 11:27, 30 October 2009 (CDT)
Line 127: Line 119:


=== V1.965 ===
=== V1.965 ===
* removed requirement for date to be between admit and discharge for [[QA Infection Audit]].
* removed requirement for date to be between admit and discharge for [[QA Infection]].
* Rolled out. [[User:Ttenbergen|Ttenbergen]] 09:24, 22 October 2009 (CDT)
* Rolled out. [[User:Ttenbergen|Ttenbergen]] 09:24, 22 October 2009 (CDT)
**STB_E6 was missing from the S_location for Access.  Added in.
**STB_E6 was missing from the S_location for Access.  Added in.
Line 155: Line 147:


* modified tmpv2 edit form to no longer have the record selection and navigator buttons. Not needed, it only gets one record.
* modified tmpv2 edit form to no longer have the record selection and navigator buttons. Not needed, it only gets one record.
* changed checks for [[QA Infection Audit]] to include Medicine as per request from Dr Roberts/Trish
* changed checks for [[QA Infection]] to include Medicine as per request from Dr Roberts/Trish


=== v1.95 ===
=== v1.95 ===
Line 187: Line 179:
=== v1.90 ===
=== v1.90 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 17:46, 30 September 2009 (CDT)
rolled out [[User:Ttenbergen|Ttenbergen]] 17:46, 30 September 2009 (CDT)
* implementation of some [[Renal Coding Considerations]]
* implementation of some [[Renal Coding Considerations (old)]]
** [[Check Renal IncomaptibleDxs]]
** [[query Check Renal IncompatibleDxs]]
** [[Check ApARF CRF]]
** [[Query 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
* 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.
* 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]]
* added [[s_tmp table]] entries for [[QA Septic Shock]]


=== v1.89 ===
=== v1.89 ===
Line 200: Line 192:


* rolled out [[User:Ttenbergen|Ttenbergen]] 12:46, 25 September 2009 (CDT)
* rolled out [[User:Ttenbergen|Ttenbergen]] 12:46, 25 September 2009 (CDT)
**minor update to overlap function for [[Duplicate patient check]],  
**minor update to overlap function for [[Check duplicate patient]],  


*rolled out [[User:Ttenbergen|Ttenbergen]] 15:23, 24 September 2009 (CDT)
*rolled out [[User:Ttenbergen|Ttenbergen]] 15:23, 24 September 2009 (CDT)
** change for [[Catheter09]]
** change for [[Catheter09]]
** fixed and re-enabled [[Duplicate patient check]]
** fixed and re-enabled [[Check duplicate patient]]
** checks for [[Check_ORDx]]
** checks for [[Check_ORDx]]


Line 218: Line 210:
=== v1.87 ===
=== v1.87 ===
Took out check for duplicate patients because it found way too many. Will review logic. Rolled out. [[User:Ttenbergen|Ttenbergen]] 13:19, 15 September 2009 (CDT)
Took out check for duplicate patients because it found way too many. Will review logic. Rolled out. [[User:Ttenbergen|Ttenbergen]] 13:19, 15 September 2009 (CDT)
*added comorbid code 54300 [[Huntington's Disease]] to s_Alldiagnosis for ccmdb.mdb. Rolled out.--[[User:TOstryzniuk|TOstryzniuk]] 17:18, 15 September 2009 (CDT)
*added comorbid code 54300 [[Huntington's Disease]] to s_Alldiagnosis for [[CCMDB.accdb]]. Rolled out.--[[User:TOstryzniuk|TOstryzniuk]] 17:18, 15 September 2009 (CDT)
*problem with corrupt s-alldiagnosis.  Tina restored and rolled out.__16 September 2009
*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.__[[User:TOstryzniuk|TOstryzniuk]] 12:22, 17 September 2009 (CDT)
*added '''comorbid''' [[Huntington's Disease]] to S_CharlsonComorbid.pbd for HanDBase.  Rolled out.__[[User:TOstryzniuk|TOstryzniuk]] 12:22, 17 September 2009 (CDT)
Line 240: Line 232:
rolled out [[User:Ttenbergen|Ttenbergen]] 10:45, 3 September 2009 (CDT)
rolled out [[User:Ttenbergen|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.  
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 consistency checks for [[QA Infection]] so Medicine will not be asked to enter date
* fixed error checking for XBR BRR
* fixed error checking for XBR BRR


Line 255: Line 247:
* 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
* 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...  
* currently looking for a way to prevent exiting out of program without dropping relationships...  
* fix to the checks for [[QA Infection Audit]]
* fix to the checks for [[QA Infection]]
[[User:Ttenbergen|Ttenbergen]] 17:55, 25 August 2009 (CDT)
[[User:Ttenbergen|Ttenbergen]] 17:55, 25 August 2009 (CDT)


Line 364: Line 356:


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


Line 408: Line 400:


===June 3.2009===
===June 3.2009===
*[[Catheter09]] - foley catheter study for STB medicine - s_tmp updated for [[HanDBase]] and [[CCMDB.mdb]].---[[User:TOstryzniuk|TOstryzniuk]] 18:47, 3 June 2009 (CDT)
*[[Catheter09]] - foley catheter study for STB medicine - s_tmp updated for HanDBase and [[CCMDB.mdb]].---[[User:TOstryzniuk|TOstryzniuk]] 18:47, 3 June 2009 (CDT)
 


===2 Jun 09 ===
===2 Jun 09 ===
Line 415: Line 406:


=== May 27, 2009 ===
=== May 27, 2009 ===
Made some more changes as per [[Laptop Testing]]:
Made some more changes as per "Laptop Testing" (article defunct [[User:Ttenbergen|Ttenbergen]] 17:44, 6 May 2010 (CDT)):
* added diagnosis chooser
* added diagnosis chooser
copied down for v0.10L this morning, following changes:  
copied down for v0.10L this morning, following changes:  
Line 427: Line 418:
* made entry template for date of birth consistent with rest (dd-mmm-yyyy)
* 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.
The [[CCMDB.accdb]] crashed as well. I recovered it. There should be no problems due to this, just adding this here for the record.


===April 28, 2009===
===April 28, 2009===
Line 483: Line 474:


===April 3, 2009_Ver 0.1===
===April 3, 2009_Ver 0.1===
*Tina copied TEST version 0 of ccmdb.mdb to TEST_Trish on the Regional Server. Needs testing.
*Tina copied TEST version 0 of [[CCMDB.accdb]] to TEST_Trish on the Regional Server. Needs testing.


*Tina have you come up with a version number scheme?_--[[User:TOstryzniuk|TOstryzniuk]] 20:36, 4 April 2009 (CDT)
*Tina have you come up with a version number scheme?_--[[User:TOstryzniuk|TOstryzniuk]] 20:36, 4 April 2009 (CDT)
Line 489: Line 480:


===April 2, 2009_Ver 0===
===April 2, 2009_Ver 0===
*DX code 763-41 [[Impella-percutaneous VAD]] added to s_alldiagnosis tables in both Access (ccmdb.mdb) and HanDBase.  
*DX code 763-41 [[Impella-percutaneous VAD]] added to s_alldiagnosis tables in both Access (ccmdb.accdb) and HanDBase.  
*tested
*tested
*'''rolled out''' to all sites.[[User:TOstryzniuk|TOstryzniuk]] 17:35, 2 April 2009 (CDT)
*'''rolled out''' to all sites.[[User:TOstryzniuk|TOstryzniuk]] 17:35, 2 April 2009 (CDT)


===March 19, 2009_Ver 0===
===March 19, 2009_Ver 0===
RE: '''Cooling Protocol [[ICU Var 2]] TAG for Witnessed Cardiac Arrest (100-2)'''.  
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.
*'''[[XBR]]''' added to Var 2 s_variables for HanDBase & ACCESS and form view in ACCESS.
*Version Feb 6.09 tested, rolled out.--[[User:TOstryzniuk|TOstryzniuk]] 15:26, 19 March 2009 (CDT)
*Version Feb 6.09 tested, rolled out.--[[User:TOstryzniuk|TOstryzniuk]] 15:26, 19 March 2009 (CDT)
Line 502: Line 493:
===March 10, 2009===
===March 10, 2009===
*S_LOCATION for HanDBase updated on regional server added '''HSC_TEST'''.
*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.
**NEW ACCESS (ccmdb.accdb) 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.
***trish copied to desktop, sych'd and copied back up to TEST_TRISH.
*testing in progress.--[[User:TOstryzniuk|TOstryzniuk]] 16:48, 10 March 2009 (CDT)
*testing in progress.--[[User:TOstryzniuk|TOstryzniuk]] 16:48, 10 March 2009 (CDT)
Line 512: Line 503:
* copying down ccmdb for requested chances as per below [[User:Ttenbergen|Ttenbergen]] 11:24, 12 February 2009 (CST)
* copying down ccmdb for requested chances as per below [[User:Ttenbergen|Ttenbergen]] 11:24, 12 February 2009 (CST)
* added following
* added following
** ICU Patients with Witnessed Cardiac Arrest (100-02) must have [[ICU Var 2 | ICU Var 2]]= ([[BRR]] or XBR)
** 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
** 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!'''''
** MI TPA 10210 you must not coexist with other MI 102-XX '''''Note: update [[Myocardial infarction]] when uploading update!'''''
Line 529: Line 520:
=== February 5, 2009 ===
=== February 5, 2009 ===
Tina is stealing the master file to fix a bug.[[User:Ttenbergen|Ttenbergen]] 18:02, 5 February 2009 (CST)
Tina is stealing the master file to fix a bug.[[User:Ttenbergen|Ttenbergen]] 18:02, 5 February 2009 (CST)
Fixed the bug listed in [[IT Bugs#Tasks Isolation Bug]], sent to Trish for testing. [[User:Ttenbergen|Ttenbergen]] 18:18, 5 February 2009 (CST)
Fixed the bug listed in IT Bugs#Tasks Isolation Bug, sent to Trish for testing. [[User:Ttenbergen|Ttenbergen]] 18:18, 5 February 2009 (CST)


===January 30, 2009===
===January 30, 2009===
Line 545: Line 536:




 
[[Category:CCMDB.accdb]]
[[Category: Questions]]
[[Category:Change Logs CCMDB]]
[[Category: IT Instructions]]
[[Category: Questions_IT]]
[[Category:Development Documentation]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.mdb_Change_Log_2009"