CCMDB.mdb Change Log 2009: Difference between revisions

m Text replacement - "Category:CCMDB.mdb" to "Category:CCMDB.accdb"
m Text replacement - "ccmdb.mdb" to "ccmdb.accdb"
Line 210: 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 356: 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 418: 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 474: 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 480: 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)
Line 493: 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)