CCMDB Wiki

CCMDB.mdb Change Log 2009: Difference between revisions

← Older edit
m Text replacement - "s_Tmp" to "s_tmp table"
 
(21 intermediate revisions by 2 users not shown)
Line 22: 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 56: 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 101: 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 122: 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 150: 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 182: 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 IncompatibleDxs]]
** [[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 195: 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 213: 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 235: 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 250: 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 359: 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 421: 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 477: 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 483: 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 496: 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 506: 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 523: 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 539: Line 536:




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