CCMDB.mdb Change Log 2009: Difference between revisions

(113 intermediate revisions by 3 users not shown)

Line 1:

*See [[CCMDB.mdb Change Log 2010]]

''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''

Line 5:

Line 7:

== Bugs & Requested Changes ==

Bug reports and requested changes have been popping up in different places. Please post article-specific things under the article (e.g. a tmp study's consistency check is broken). Please put general concerns under [[Requested CCMDB changes for the next version]]. Thanks, [[User:Ttenbergen|Ttenbergen]] 12:58, 29 October 2009 (CDT)

*Bug reports and requested changes have been popping up in different places. Please post article-specific things under the article (e.g. a tmp study's consistency check is broken). Please put general concerns under [[Requested CCMDB changes for the next version]]. Thanks, [[User:Ttenbergen|Ttenbergen]] 12:58, 29 October 2009 (CDT)

== Laptop Version Change Log ==

===V 1.991===

Rolled out [[User:Ttenbergen|Ttenbergen]] 18:40, 29 December 2009 (CST)

====Status====

Further changes:

* updates to peer audit partners table for Pat HSC and Debbie StB--[[User:Ttenbergen|Ttenbergen]] 14:34, 30 December 2009 (CST)

===v 1.99===

====Status====

moved to test_trish for testing. If there is no time to test, the changes are relatively minor and this could probably just be rolled. [[User:Ttenbergen|Ttenbergen]] 12:49, 23 December 2009 (CST)

====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.

* 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.

* "query s_tmp_QASeptic_Dx_no_tmp" 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

* [[query s_tmp_QAInf_tmp_no_dx]] 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===

====Status====

*Dec 17.09 - Tina fixed peer audit location table with STB_CICU (PDA is CVICU but alias used is CICU). Copy in Master and test trish & trish desktop.

*Dec 16.09 - Ver 1.985 rolled out to '''ALL''' Sites. Please synch you PDA or press new and backup to get updated version.

*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)

*sent back to Test_Trish for Testing[[User:Ttenbergen|Ttenbergen]]

*copied to Trish_Desktop.--[[User:TOstryzniuk|TOstryzniuk]] 17:57, 10 December 2009 (CST)

*copy to VIC_N5 for more testing.--[[User:TOstryzniuk|TOstryzniuk]] 17:57, 10 December 2009 (CST)

====Changes====

* minor fixes to fix items changed in prev. version

** sending module comments

** send_tasks and send_tasks_master changed back to include the audit serial range. had made separate send queries for the audit, but since there is already a serial number check this is not necessary. Also, the send_task_audit query wasn't actually being called, leading to data not being sent.

* minor update, doesn't need to be rolled out to everyone, already done for Lois [[User:Ttenbergen|Ttenbergen]] 11:16, 23 December 2009 (CST)

** changed the peer audit table entry for HSC_MICU from MICU1 to MICU. MICU only applies to directory because we had a problem with the file at some point, it does not apply to the peer audit.

===v 1.9851===

====Status====

* sent back to Test_Trish for Testing[[User:Ttenbergen|Ttenbergen]] 15:01, 9 December 2009 (CST)

*copy to CON_ICU & VIC_N5 for beta testing.[[User:TOstryzniuk|TOstryzniuk]] 22:55, 9 December 2009 (CST)

====Changes====

* minor fixes to fix items changed in prev. version

** send module for checking CC/Med

** check_peer_audit_audit_serial_reg_send and vs or ???

** 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)

===v 1.985===

remained dev version

====Status====

*put into test_trish for testing [[User:Ttenbergen|Ttenbergen]] 15:05, 24 November 2009 (CST)

*copied down to desk top from Test_Trish.

*'''Copied back into TRISH TEST on Regional Server so Tina can work with same copy.[[User:TOstryzniuk|TOstryzniuk]] 13:25, 25 November 2009 (CST)

* copied back to local for further changes as per [[Requested CCMDB changes for the next version]][[User:Ttenbergen|Ttenbergen]] 15:15, 30 November 2009 (CST)

* copied back to Test_Trish [[User:Ttenbergen|Ttenbergen]] 11:40, 1 December 2009 (CST)

====Changes====

*'''not rolled out yet''' [[User:Ttenbergen|Ttenbergen]] 12:36, 24 November 2009 (CST)

* made sorting of records implicit - Betty at Conc had records show up in random order.

* added date/time to the file name for [[Peer Audit]] output files.

* changed "Send_Tmp_audit" to include patient initials and admit date.

** changed TmpV2_1_audit.mdb to accommodate data

* Trish changes

**Fixed CCMDB S_TMP - R - routine foley change. It was entered in twice in this table.--Trish

**fixed S-admitdischarge. Had '''YY''' available. No such code. Changed to YX. S-TMP for handibase is correct.--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

* 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_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 "Send_Tasks_Master" and "Send_Tasks" to exclude peer audit serial numbers

* edited query "Send_Tmp_audit" to only send peer audit serial numbers

* edited query "Send_Tmp" to exclude peer audit serial numbers

* added queries "Send_Tasks_audit" and "Send_Tasks_Master_audit" to deal with audit sending

* added table "peer_audit_partners" and query "check_peer_audit_location_bad" to limit which patients can be sent as audits

===v 1.98-current version at all sites Except Vic N3 and CON who are testing most recent===

*'''November 23.09''' - '''rolled out''' to STB Medicine collectors only (STB_B4 changed to STB 5B on Nov 17.09.)

**added to CCMDB STB_5B to: s_Var options (var 1 & 2), S_Tmp_moves_required, S_Location

**HanDBase: added STB_5B to: s_Var1Opts, s_Var2Opts, s_locations, S_tmp.pdb (moves)[[User:TOstryzniuk|TOstryzniuk]] 13:25, 25 November 2009 (CST)

*'''November 17.09''' -code 49921 added to S_alldiagnosis for CCMDB and HanDBase. '''Rolled out'''.--[[User:TOstryzniuk|TOstryzniuk]] 15:22, 17 November 2009 (CST)

*'''November 9.09''' - Catheter09, '''S-Tmp''' CCMDB and HanDBase. Added '''R-routine foley change''' item. '''Rolled out'''.--[[User:TOstryzniuk|TOstryzniuk]] 20:16, 9 November 2009 (CST)

*'''rolled out''' with my big foot. Latest version in "Master". --[[User:TOstryzniuk|TOstryzniuk]] 17:25, 4 November 2009 (CST)

~~===v 1.98===~~

*rolled out with my big foot.--[[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)

* removed Greensheets tab [[User:Ttenbergen|Ttenbergen]] 11:27, 30 October 2009 (CDT)

** removed checks for greensheet and checkbox as well. [[User:Ttenbergen|Ttenbergen]] 12:31, 30 October 2009 (CDT)

* fixed problem where error in first record on the list would be flagged but unchecked [[User:Ttenbergen|Ttenbergen]] 12:31, 30 October 2009 (CDT)

==== Bug? Adding a patient ====

* I am unable to add a new patient, as you say above the patient view from the patient list no longer has the asterisk to add a new record/patient. I did backup to receive any new updates prior to opening & also a couple of times since. [[User:NMiller|NMiller]] 20:48, 4 November 2009 (CST)

** I don't think you were able to add a patient in the patient ''list'' ever (if you could none of the checks would kick in). Click on "Edit patients" instead, there is a "star" button available there. [[User:Ttenbergen|Ttenbergen]] 09:27, 5 November 2009 (CST)

=== v1.975 ===

Line 30:

Line 119:

=== 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)

**STB_E6 was missing from the S_location for Access. Added in.

Line 58:

Line 147:

* 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 ===

Line 90:

Line 179:

=== v1.90 ===

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

* 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 ===

Line 103:

Line 192:

* 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)

** change for [[Catheter09]]

** fixed and re-enabled [[~~Duplicate~~ patient ~~check~~]]

** fixed and re-enabled [[Check duplicate patient]]

** checks for [[Check_ORDx]]

Line 121:

Line 210:

=== 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)

*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

*added '''comorbid''' [[Huntington's Disease]] to S_CharlsonComorbid.pbd for HanDBase. Rolled out.__[[User:TOstryzniuk|TOstryzniuk]] 12:22, 17 September 2009 (CDT)

Line 143:

Line 232:

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.

* 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

Line 158:

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

* 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)

Line 267:

Line 356:

===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)

Line 311:

Line 400:

===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 ===

Line 318:

Line 406:

=== 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

copied down for v0.10L this morning, following changes:

Line 330:

Line 418:

* 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===

Line 386:

Line 474:

===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)

Line 392:

Line 480:

===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

*'''rolled out''' to all sites.[[User:TOstryzniuk|TOstryzniuk]] 17:35, 2 April 2009 (CDT)

===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.

*Version Feb 6.09 tested, rolled out.--[[User:TOstryzniuk|TOstryzniuk]] 15:26, 19 March 2009 (CDT)

Line 405:

Line 493:

===March 10, 2009===

*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.

*testing in progress.--[[User:TOstryzniuk|TOstryzniuk]] 16:48, 10 March 2009 (CDT)

Line 415:

Line 503:

* copying down ccmdb for requested chances as per below [[User:Ttenbergen|Ttenbergen]] 11:24, 12 February 2009 (CST)

* 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

** MI TPA 10210 you must not coexist with other MI 102-XX '''''Note: update [[Myocardial infarction]] when uploading update!'''''

Line 424:

Line 512:

===February 6, 2009_Ver 0===

*[[IT Bugs]]

*IT Bugs

*TASK bug Feb 5.09 (if CPAP YES then Isolation set to TOTAL when files are SENT out from ACCESS)

*Tested. Bug elimimated--GONE!

Line 432:

Line 520:

=== February 5, 2009 ===

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===

Line 448:

Line 536:

[[Category:CCMDB.accdb]]

~~[[Category: Questions]]~~

[[Category:Change Logs CCMDB]]

~~[[Category: IT Instructions]]~~

[[Category: ~~Questions_IT~~]]

[[Category:~~Development Documentation~~]]

@@ Line 1: / Line 1: @@
+*See [[CCMDB.mdb Change Log 2010]]
 ''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''
@@ Line 5: / Line 7: @@
 == Bugs & Requested Changes ==
-Bug reports and requested changes have been popping up in different places. Please post article-specific things under the article (e.g. a tmp study's consistency check is broken). Please put general concerns under [[Requested CCMDB changes for the next version]]. Thanks, [[User:Ttenbergen|Ttenbergen]] 12:58, 29 October 2009 (CDT)
+*Bug reports and requested changes have been popping up in different places. Please post article-specific things under the article (e.g. a tmp study's consistency check is broken). Please put general concerns under [[Requested CCMDB changes for the next version]]. Thanks, [[User:Ttenbergen|Ttenbergen]] 12:58, 29 October 2009 (CDT)
 == Laptop Version Change Log ==
+===V 1.991===
+Rolled out [[User:Ttenbergen|Ttenbergen]] 18:40, 29 December 2009 (CST)
+====Status====
+Further changes:
+* updates to peer audit partners table for Pat HSC and Debbie StB--[[User:Ttenbergen|Ttenbergen]] 14:34, 30 December 2009 (CST)
+===v 1.99===
+====Status====
+moved to test_trish for testing. If there is no time to test, the changes are relatively minor and this could probably just be rolled. [[User:Ttenbergen|Ttenbergen]] 12:49, 23 December 2009 (CST)
+====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.
+* 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.
+* "query s_tmp_QASeptic_Dx_no_tmp" 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
+* [[query s_tmp_QAInf_tmp_no_dx]] 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===
+====Status====
+*Dec 17.09 - Tina fixed peer audit location table with STB_CICU (PDA is CVICU but alias used is CICU).  Copy in Master and test trish & trish desktop.
+*Dec 16.09 - Ver 1.985 rolled out to '''ALL''' Sites. Please synch you PDA or press new and backup to get updated version.
+*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)
+*sent back to Test_Trish for Testing[[User:Ttenbergen|Ttenbergen]]
+*copied to Trish_Desktop.--[[User:TOstryzniuk|TOstryzniuk]] 17:57, 10 December 2009 (CST)
+*copy to VIC_N5 for more testing.--[[User:TOstryzniuk|TOstryzniuk]] 17:57, 10 December 2009 (CST)
+====Changes====
+* minor fixes to fix items changed in prev. version
+** sending module comments
+** send_tasks and send_tasks_master changed back to include the audit serial range. had made separate send queries for the audit, but since there is already a serial number check this is not necessary. Also, the send_task_audit query wasn't actually being called, leading to data not being sent.
+* minor update, doesn't need to be rolled out to everyone, already done for Lois [[User:Ttenbergen|Ttenbergen]] 11:16, 23 December 2009 (CST)
+** changed the peer audit table entry for HSC_MICU from MICU1 to MICU. MICU only applies to directory because we had a problem with the file at some point, it does not apply to the peer audit.
+===v 1.9851===
+====Status====
+* sent back to Test_Trish for Testing[[User:Ttenbergen|Ttenbergen]] 15:01, 9 December 2009 (CST)
+*copy to CON_ICU & VIC_N5 for beta testing.[[User:TOstryzniuk|TOstryzniuk]] 22:55, 9 December 2009 (CST)
+====Changes====
+* minor fixes to fix items changed in prev. version
+** send module for checking CC/Med
+** check_peer_audit_audit_serial_reg_send and vs or ???
+** 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)
+===v 1.985===
+remained dev version
+====Status====
+*put into test_trish for testing [[User:Ttenbergen|Ttenbergen]] 15:05, 24 November 2009 (CST)
+*copied down to desk top from Test_Trish.
+*'''Copied back into TRISH TEST on Regional Server so Tina can work with same copy.[[User:TOstryzniuk|TOstryzniuk]] 13:25, 25 November 2009 (CST)
+* copied back to local for further changes as per [[Requested CCMDB changes for the next version]][[User:Ttenbergen|Ttenbergen]] 15:15, 30 November 2009 (CST)
+* copied back to Test_Trish [[User:Ttenbergen|Ttenbergen]] 11:40, 1 December 2009 (CST)
+====Changes====
+*'''not rolled out yet''' [[User:Ttenbergen|Ttenbergen]] 12:36, 24 November 2009 (CST)
+* made sorting of records implicit - Betty at Conc had records show up in random order.
+* added date/time to the file name for [[Peer Audit]] output files.
+* changed "Send_Tmp_audit" to include patient initials and admit date.
+** changed TmpV2_1_audit.mdb to accommodate data
+* Trish changes
+**Fixed CCMDB S_TMP - R - routine foley change.  It was entered in twice in this table.--Trish
+**fixed S-admitdischarge.  Had '''YY''' available.  No such code. Changed to YX.  S-TMP for handibase is correct.--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
+* 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_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 "Send_Tasks_Master" and "Send_Tasks" to exclude peer audit serial numbers
+* edited query "Send_Tmp_audit" to only send peer audit serial numbers
+* edited query "Send_Tmp" to exclude peer audit serial numbers
+* added queries "Send_Tasks_audit" and "Send_Tasks_Master_audit" to deal with audit sending
+* added table "peer_audit_partners" and query "check_peer_audit_location_bad" to limit which patients can be sent as audits
+===v 1.98-current version at all sites Except Vic N3 and CON who are testing most recent===
+*'''November 23.09''' - '''rolled out''' to STB Medicine collectors only (STB_B4 changed to STB 5B on Nov 17.09.)
+**added to CCMDB STB_5B to:  s_Var options (var 1 & 2), S_Tmp_moves_required, S_Location
+**HanDBase: added STB_5B to: s_Var1Opts, s_Var2Opts, s_locations, S_tmp.pdb (moves)[[User:TOstryzniuk|TOstryzniuk]] 13:25, 25 November 2009 (CST)
+*'''November 17.09''' -code 49921 added to S_alldiagnosis for CCMDB and HanDBase.  '''Rolled out'''.--[[User:TOstryzniuk|TOstryzniuk]] 15:22, 17 November 2009 (CST)
+*'''November 9.09''' - Catheter09, '''S-Tmp''' CCMDB and HanDBase.  Added '''R-routine foley change''' item. '''Rolled out'''.--[[User:TOstryzniuk|TOstryzniuk]] 20:16, 9 November 2009 (CST)
+*'''rolled out''' with my big foot. Latest version in "Master". --[[User:TOstryzniuk|TOstryzniuk]] 17:25, 4 November 2009 (CST)
-===v 1.98===
-*rolled out with my big foot.--[[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)
 * removed Greensheets tab [[User:Ttenbergen|Ttenbergen]] 11:27, 30 October 2009 (CDT)
 ** removed checks for greensheet and checkbox as well. [[User:Ttenbergen|Ttenbergen]] 12:31, 30 October 2009 (CDT)
 * fixed problem where error in first record on the list would be flagged but unchecked [[User:Ttenbergen|Ttenbergen]] 12:31, 30 October 2009 (CDT)
+==== Bug? Adding a patient ====
+* I am unable to add a new patient, as you say above the patient view from the patient list no longer has the asterisk to add a new record/patient. I did backup to receive any new updates prior to opening & also a couple of times since. [[User:NMiller|NMiller]] 20:48, 4 November 2009 (CST)
+** I don't think you were able to add a patient in the patient ''list'' ever (if you could none of the checks would kick in). Click on "Edit patients" instead, there is a "star" button available there. [[User:Ttenbergen|Ttenbergen]] 09:27, 5 November 2009 (CST)
 === v1.975 ===
@@ Line 30: / Line 119: @@
 === 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)
 **STB_E6 was missing from the S_location for Access.  Added in.
@@ Line 58: / Line 147: @@
 * 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 ===
@@ Line 90: / Line 179: @@
 === v1.90 ===
 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
 * 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 ===
@@ Line 103: / Line 192: @@
 * 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)
 ** change for [[Catheter09]]
-** fixed and re-enabled [[Duplicate patient check]]
+** fixed and re-enabled [[Check duplicate patient]]
 ** checks for [[Check_ORDx]]
@@ Line 121: / Line 210: @@
 === 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)
-*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
 *added '''comorbid''' [[Huntington's Disease]] to S_CharlsonComorbid.pbd for HanDBase.  Rolled out.__[[User:TOstryzniuk|TOstryzniuk]] 12:22, 17 September 2009 (CDT)
@@ Line 143: / Line 232: @@
 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.
-* 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
@@ Line 158: / 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
 * 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)
@@ Line 267: / Line 356: @@
 ===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)
@@ Line 311: / Line 400: @@
 ===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 ===
@@ Line 318: / Line 406: @@
 === 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
 copied down for v0.10L this morning, following changes:
@@ Line 330: / Line 418: @@
 * 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===
@@ Line 386: / Line 474: @@
 ===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)
@@ Line 392: / Line 480: @@
 ===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
 *'''rolled out''' to all sites.[[User:TOstryzniuk|TOstryzniuk]] 17:35, 2 April 2009 (CDT)
 ===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.
 *Version Feb 6.09 tested, rolled out.--[[User:TOstryzniuk|TOstryzniuk]] 15:26, 19 March 2009 (CDT)
@@ Line 405: / Line 493: @@
 ===March 10, 2009===
 *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.
 *testing in progress.--[[User:TOstryzniuk|TOstryzniuk]] 16:48, 10 March 2009 (CDT)
@@ Line 415: / Line 503: @@
 * copying down ccmdb for requested chances as per below [[User:Ttenbergen|Ttenbergen]] 11:24, 12 February 2009 (CST)
 * 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
 ** MI TPA 10210 you must not coexist with other MI 102-XX '''''Note: update [[Myocardial infarction]] when uploading update!'''''
@@ Line 424: / Line 512: @@
 ===February 6, 2009_Ver 0===
-*[[IT Bugs]]
+*IT Bugs
 *TASK bug Feb 5.09 (if CPAP YES then Isolation set to TOTAL when files are SENT out from ACCESS)
 *Tested.  Bug elimimated--GONE!
@@ Line 432: / Line 520: @@
 === February 5, 2009 ===
 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===
@@ Line 448: / Line 536: @@
+[[Category:CCMDB.accdb]]
-[[Category: Questions]]
+[[Category:Change Logs CCMDB]]
-[[Category: IT Instructions]]
-[[Category: Questions_IT]]
-[[Category:Development Documentation]]