CCMDB.mdb Change Log 2009: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "Renal Coding Considerations" to "Renal Coding Considerations (old)" |
Ttenbergen (talk | contribs) m Text replacement - "s_Tmp" to "s_tmp table" |
||
| (11 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 181: | Line 180: | ||
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 (old)]] | * implementation of some [[Renal Coding Considerations (old)]] | ||
** [[Check Renal IncompatibleDxs]] | ** [[query Check Renal IncompatibleDxs]] | ||
** [[ | ** [[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 [[ | * added [[s_tmp table]] entries for [[QA Septic Shock]] | ||
=== v1.89 === | === v1.89 === | ||
| Line 211: | 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 | *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 357: | Line 356: | ||
===June 18.09=== | ===June 18.09=== | ||
*2000 hrs -"send complete" in s-tmp | *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 419: | 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 | 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 475: | Line 474: | ||
===April 3, 2009_Ver 0.1=== | ===April 3, 2009_Ver 0.1=== | ||
*Tina copied TEST version 0 of | *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 481: | 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. | *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 494: | 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. | **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 537: | Line 536: | ||
[[Category:CCMDB. | [[Category:CCMDB.accdb]] | ||
[[Category:Change Logs CCMDB]] | [[Category:Change Logs CCMDB]] | ||