CCMDB.mdb Change Log 2010: Difference between revisions

(97 intermediate revisions by 3 users not shown)

Line 1:

See '''[[CCMDB.mdb Change Log 2011]]'''

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

The CCMDB.mdb '''Change Log''' logs changes made to the CCMDB.mdb, including lock-downs when one person is making changes so that no one else makes changes at the same time. New entries should be made at the top to be immediately apparent. Discussions should be added at the level of individual changes if they correspond to a change, and at the end of the article if they relate to the change process in general. When a change is tested and rolled out it is also documented here.

The CCMDB.mdb '''Change Log''' logs changes made to the CCMDB.mdb, including lock-downs when one person is making changes so that no one else makes changes at the same time. New entries should be made at the top to be immediately apparent. Discussions should be added at the level of individual changes if they correspond to a change, and at the end of the article if they relate to the change process in general; make sure you mark any discussion with <nowiki> {{discussion}} </nowiki> so it doesn't get lost in the fray. When a change is tested and rolled out it is also documented here.

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

* replicated bug; added ~30 patients without filling anything into the patient data. Then I got some "can't open a query errors", after closing those twice and trying again I go the error:

:: Title: Microsoft Office Access

:: Msg: There isn't enough memory to perform this operation. Close unneeded programs and try the operation again.

== Versions ==

===v2010-12-31===

Rolled out to Med to get some early testing if possible. Med won't use labs but the data structure still will need to auto-convert. [[User:Ttenbergen|Ttenbergen]] 12:15, 31 December 2010 (CST)

* set up 3rd draft of the new labs screen [[User:Ttenbergen|Ttenbergen]] 13:15, 24 December 2010 (CST)

* second draft of lab form, made lab labels diagonal on top, implemented HSC hiding. [[User:Ttenbergen|Ttenbergen]] 16:14, 23 December 2010 (CST)

* modified EdsCC query that outputs data to Ed to accomodate new Labs setup. [[User:Ttenbergen|Ttenbergen]] 16:52, 23 December 2010 (CST)

* made new EdsCC compatible with ed's output specification [[User:Ttenbergen|Ttenbergen]] 17:55, 23 December 2010 (CST)

* changed date field so it also has time [[User:Ttenbergen|Ttenbergen]] 12:35, 24 December 2010 (CST)

* made values mandatory for Labs to ensure blank lab entry causes no problem [[User:Ttenbergen|Ttenbergen]] 12:38, 24 December 2010 (CST)

* fixed type for "tampornade" for 4 entries in s_alldiagnoses [[User:Ttenbergen|Ttenbergen]] 12:31, 24 December 2010 (CST)

* added to s_Location table HSC_[[OVER]]

* added to S_Tmp for moves HSC_H7N and HSC_H7T

* changed end date for QA Septic to 31 Mar 2011

* [[Early ID study]] set up

** added entries to s_tmp [[User:Ttenbergen|Ttenbergen]] 13:29, 24 December 2010 (CST)

* made conversion function from old DB structure to new (module and sub DB_Converter()) [[User:Ttenbergen|Ttenbergen]] 14:08, 30 December 2010 (CST) and [[User:Ttenbergen|Ttenbergen]] 16:53, 30 December 2010 (CST)

* changed forms to no longer look for e.g. L_Settings etc. [[User:Ttenbergen|Ttenbergen]]

* removed "edit patients" button and funnel on the viewer [[User:Ttenbergen|Ttenbergen]] 16:53, 30 December 2010 (CST)

* added room numbers [[User:Ttenbergen|Ttenbergen]] 16:56, 30 December 2010 (CST)

* got rid of autopsy option for survive/expire field. [[User:Ttenbergen|Ttenbergen]] 18:04, 30 December 2010 (CST)

* added an error log table; for now it would need to be accessed from the backups for analysis. [[User:Ttenbergen|Ttenbergen]] 18:29, 30 December 2010 (CST)

===v1.9952===

rolled out [[User:Ttenbergen|Ttenbergen]] 12:22, 29 November 2010 (CST)

further cleanup and doing changes requested deep in the wiki...

* removed city hospitals from [[S_HospitalCodes]] as per [[Hospital previous]] (yesterday) [[User:Ttenbergen|Ttenbergen]] 10:59, 4 November 2010 (CDT)

** St. Boniface 5 5 1

** Grace 3 3 1

** Seven Oaks 11 11 1

** Misericordia 4 4 1

** Rehab Center for Children 17 17 1

** Health Sciences 16 16 1

** [[Deer Lodge (DLC)]] Center Inc. 19 19 1

** Riverview Health Center 6 6 1

** Victoria 7 7 1

** Children Hospital 8 8 1

** Concordia 9 9 1

* deleted Greensheets form

* added [[Re-sort button]] [[Image:Resort button.GIF]] to dx, como, labs and pharm forms. [[User:Ttenbergen|Ttenbergen]] 11:23, 4 November 2010 (CDT)

* fixed "find" button error in dx_chooser form [[User:Ttenbergen|Ttenbergen]] 11:31, 29 November 2010 (CST)

* added expireds' notes to Pagasa's pending [[User:Ttenbergen|Ttenbergen]] 11:36, 29 November 2010 (CST)

* added GRA_EMIP to s_locations [[User:Ttenbergen|Ttenbergen]] 11:37, 29 November 2010 (CST)

* added HSC_H7 to s_locations as per request from Gail Hall. [[User:Ttenbergen|Ttenbergen]] 12:10, 29 November 2010 (CST)

===v1.9951===

* c: rolled out [[User:Ttenbergen|Ttenbergen]] 13:42, 2 November 2010 (CDT)

** added

*** var 2 H7 Med HSC

*** var 1 H7 Med HSC

** changed Labs V2

*** 40 PT/PTT 0 -1 9999 (i.e. to not be collected at HSC

** removed (as per [[ICU Var 6 - various uses]])

*** Var 6 "S" CC Study - pt enrolled in a study

* took out call to Alt_locn() that was causing send to hang [[User:Ttenbergen|Ttenbergen]] 13:42, 2 November 2010 (CDT)

* b: changes got_data() so it will not crash when log file has already been written. Rolled out. [[User:Ttenbergen|Ttenbergen]] 09:28, 2 November 2010 (CDT)

* a: removed a reference that was causing program to crash on opening.[[User:Ttenbergen|Ttenbergen]] 17:08, 1 November 2010 (CDT)

Rolled out [[User:Ttenbergen|Ttenbergen]] 14:51, 1 November 2010 (CDT)

continuing updates where I left off with 1.995 to get the bug fixes out

* removed following functions that are not used anywhere any longer... [[User:Ttenbergen|Ttenbergen]] 14:03, 27 October 2010 (CDT)

** alt_locn()

** laptop()

** set_relationships()

** create_rel(...)

** drop_relationships()

* added

** Var Option Program Hosp Description

** 2 PY1 Med HSC Psych

** 2 PY3 Med HSC Psych

** 1 PY1 Med HSC Psych

** 1 PY3 Med HSC Psych

* consolidating databasestarter() and laptopopener() in prep for going with new data structure

* making program quit (Application.Quit) if

** there is no or bad settings.mdb or

** no data files/tables

** any of the tables missing

* Adding apache points

** age + pts added to apache tab[[User:Ttenbergen|Ttenbergen]] 12:15, 28 October 2010 (CDT)

* deleted old PDA references from [[S_AP_Chronic table]] [[User:Ttenbergen|Ttenbergen]] 13:55, 28 October 2010 (CDT)

* added "fill" versions of Task dxs to use for automatic population

** Task Tracheostomy - Fill 100099

** Task Hemodialysis - Fill 100199

** Task Peritoneal Dialysis - Fill 100299

** Task BiPAP or CPAP - Fill 100399

** Task Isolation - Fill 100499

* added code to cb_addPt_Click() to automatically enter the "fill" tasks to new med patients [[User:Ttenbergen|Ttenbergen]] 15:12, 29 October 2010 (CDT)

* confirmed that dx_checker code to make sure that fill tasks will not be allowed to be sent before changing them to something real.

* eliminated from s_varOptions, and updated ICU Var 1 and ICU Var 2 - BRR

** 1 OBS CC CON Obser.Unit in ER for telemetry

** 2 MAP CC MI care map

* changed program so contents of "'''notes'''" field are written to Pagasa's PDA Status.csv automatically when sending [[User:Ttenbergen|Ttenbergen]] 12:35, 1 November 2010 (CDT)

* temporarily added got_data() to Database_Starter() to make sure everyone received c:\ccmdb_data\ccmdb_data.mdb [[User:Ttenbergen|Ttenbergen]] 13:52, 1 November 2010 (CDT)

===v1.995===

Updt 1.995a Rolled out [[User:Ttenbergen|Ttenbergen]] 13:57, 26 October 2010 (CDT)

* update to the drug list to some remaining existing hidden drugs. [[User:Ttenbergen|Ttenbergen]] 13:57, 26 October 2010 (CDT)

rolled out to apply bug fixes [[User:Ttenbergen|Ttenbergen]] 15:39, 25 October 2010 (CDT)

* added S_Labs_V2 [[User:Ttenbergen|Ttenbergen]] 16:58, 22 October 2010 (CDT)

* added sorting button for FinalCheck to PatientList in preparation for removing "edit patients" and "filter" buttons.[[User:Ttenbergen|Ttenbergen]] 09:59, 25 October 2010 (CDT)

* to ensure common usage the master [[CCMDB.accdb]] now uses the external data as well, i.e. internal L_ tables are not an option any longer [[User:Ttenbergen|Ttenbergen]] 10:42, 25 October 2010 (CDT)

* deleted ancient old L_Tmp that had been kept not to break any PDA syncs [[User:Ttenbergen|Ttenbergen]] 10:54, 25 October 2010 (CDT)

* fixed "visible" setting for bracket and score on Apache screen so it won't show up in Medicine [[User:Ttenbergen|Ttenbergen]] 12:45, 25 October 2010 (CDT)

* applied MS kb907836 by grouping and ungrouping controls in both patient list and viewer to fix out-of-memory error. Was able to open and close pts from patient list >50 times without bug, before ~25 would crash it. '''Please let me know if there are further memory errors after this version.''' [[User:Ttenbergen|Ttenbergen]] 13:01, 25 October 2010 (CDT)

* changed the Pharmacy/Drugs list; re-instated the versions that I had deleted so that existing entries are preserved, but made them so they can't be entered in the future any longer.

* started work on Public Sub new_db_structure_consolidation(), will roll out without this to get the fixes out there [[User:Ttenbergen|Ttenbergen]] 15:20, 25 October 2010 (CDT)

===ver1.994===

Line 14:

Line 129:

* added New Dx 76325 - [[Cardiac ablation]] [[User:Ttenbergen|Ttenbergen]] 13:39, 22 October 2010 (CDT)

* re-allowed editing for Record field right in [[Patient List]] - I had locked out all fields earlier because this form can't run checks, but since the Record field is not checked nothing wrong with having it accessible right in the list. Also, made it into a drop-down. [[User:Ttenbergen|Ttenbergen]] 13:39, 22 October 2010 (CDT)

* corrected some code in TmpChecker() that was allowing to send even if there was an error. [[User:Ttenbergen|Ttenbergen]] 13:53, 22 October 2010 (CDT)

* corrected some code in [[Function TmpChecker]] that was allowing to send even if there was an error. [[User:Ttenbergen|Ttenbergen]] 13:53, 22 October 2010 (CDT)

* fixed error where no initials in settings file would crash sending [[User:Ttenbergen|Ttenbergen]] 13:53, 22 October 2010 (CDT)

* cleaned up pharm list [[User:Ttenbergen|Ttenbergen]] 14:29, 22 October 2010 (CDT)

Line 75:

Line 190:

===v1.9938===

Reverted due to bugs[[User:Ttenbergen|Ttenbergen]] 16:18, 15 July 2010 (CDT)

* patient list changes~~, please comment at '''[[Feedback Request - Patient List]]'''~~

* patient list changes

** added "Find Patient" button to patient list

** disabled editing on the patient list to prevent bypassing checks

Line 85:

Line 200:

* deleted remnants of CPAP, SerUrea, DBili, UrineOutput, ActiveTx since no longer used [[User:Ttenbergen|Ttenbergen]] 10:54, 9 June 2010 (CDT)

* changed font for instructions for tmp so they show up completely on form (some hidden off to right now)

* changed order of apache labs - please comment at ''' [[Feedback Request - Apache Labs Order]]'''

* changed order of apache labs - please comment at ''' Feedback Request - Apache Labs Order'''

* made sorting of Admit From and Discharge To such that local options (based on settings table) list first. [[User:Ttenbergen|Ttenbergen]] 11:17, 9 June 2010 (CDT)

* changed lables for Var 3 and 5 to fit into the spaces

Line 95:

Line 210:

* limited labs in drop-down to those collected at location (ie HSC vs Others) [[User:Ttenbergen|Ttenbergen]] 15:41, 2 July 2010 (CDT)

* changed ABG order as per following: [[User:Ttenbergen|Ttenbergen]] 16:02, 2 July 2010 (CDT)

** ABG information in the standard order: Ph, then PCO2, then pO2 ~~{{discussion}}~~

** ABG information in the standard order: Ph, then PCO2, then pO2

*** where does FIO2 figure in this list? [[User:Ttenbergen|Ttenbergen]] 11:05, 9 June 2010 (CDT)

**** Tina usually when an ABG is reported, the FiO2 is last but for our purposes it could be listed as first because this is something that we usually look at first to determine which ABG to use in the apache score.--[[User:LKolesar|LKolesar]] 13:51, 9 June 2010 (CDT)

Line 116:

Line 231:

* removed following line which causes error in Access 2002 under certain circumstances

** Application.automationsecurity = 2 ' means "msoAutomationSecurityLow" without reference necessary

* change double-click on notes so that current changes to notes field (and rest of record) are written to DB before opening notes form. Thanks to Shirley for catching and describing this! [[User:Ttenbergen|Ttenbergen]] 10:35, 29 April 2010 (CDT)

* change double-click on notes so that current changes to notes field (and rest of record) are written to DB before opening notes form. Thanks to [[p:Shirley Kiesman-retired, Dec 31, 2018 | Shirley Kiesman]] for catching and describing this! [[User:Ttenbergen|Ttenbergen]] 10:35, 29 April 2010 (CDT)

===V1.9934===

Line 135:

Line 250:

* took pH out of ABG testing[[User:Ttenbergen|Ttenbergen]] 10:11, 14 April 2010 (CDT)

* added Apache scores and score-listers to Apache values. [[User:Ttenbergen|Ttenbergen]] 10:11, 14 April 2010 (CDT)

** Should the apache scores be visible for medicine, for those values collected in both programs? ~~{{discussion}}~~ [[User:Ttenbergen|Ttenbergen]] 10:11, 14 April 2010 (CDT)

** Should the apache scores be visible for medicine, for those values collected in both programs? [[User:Ttenbergen|Ttenbergen]] 10:11, 14 April 2010 (CDT)

* added "Add Patient" to patient list form, to be able to add patients from there rather than having to do so from the patient editor page. [[User:Ttenbergen|Ttenbergen]] 10:45, 14 April 2010 (CDT)

* made function "add_record_status" to add record_status field to L_Log in preparation for new data repository. This has to be done locally for laptops since we don't have central access to the data, so automation was required. [[User:Ttenbergen|Ttenbergen]] 10:28, 15 April 2010 (CDT)

Line 202:

Line 317:

* [[BP Helper button]] added, '''not yet functional'''

* Changed the way check functions access data from using using "Set this_db = CurrentDb" to accessing CurrentDB directly; had used this_db to address a different error earlier on which no longer seems to be a problem

* changed [[Check Renal IncompatibleDxs]] to implement changes in [[~~Renal_Coding_Considerations~~#Competing_Diagnoses]]

* changed [[query Check Renal IncompatibleDxs]] to implement changes in [[Renal Coding Considerations (old)#Competing_Diagnoses]]

* changed [[Pending_Julie]] to list discharge ''dates'' even if a '''''time''''' is not entered

Line 222:

Line 337:

Changed batch files to create a total of 20 previous versions for each location to retain data. [[User:Ttenbergen|Ttenbergen]] 12:21, 30 November 2009 (CST)

* [[Updt all.bat]] changes complete

* [["News and backup~~" batch file~~]] changes complete

* [[News and backup]] changes complete

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

[[Category:CCMDB.accdb]]

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

[[Category:Change Logs CCMDB]]

[[Category: Change Logs CCMDB]]

@@ Line 1: / Line 1: @@
+See '''[[CCMDB.mdb Change Log 2011]]'''
 ''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''
-The CCMDB.mdb '''Change Log''' logs changes made to the CCMDB.mdb, including lock-downs when one person is making changes so that no one else makes changes at the same time. New entries should be made at the top to be immediately apparent. Discussions should be added at the level of individual changes if they correspond to a change, and at the end of the article if they relate to the change process in general. When a change is tested and rolled out it is also documented here.
+The CCMDB.mdb '''Change Log''' logs changes made to the CCMDB.mdb, including lock-downs when one person is making changes so that no one else makes changes at the same time. New entries should be made at the top to be immediately apparent. Discussions should be added at the level of individual changes if they correspond to a change, and at the end of the article if they relate to the change process in general; make sure you mark any discussion with <nowiki> {{discussion}} </nowiki> so it doesn't get lost in the fray. When a change is tested and rolled out it is also documented here.
 == 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)
+* replicated bug; added ~30 patients without filling anything into the patient data. Then I got some "can't open a query errors",  after closing those twice and trying again I go the error:
+:: Title: Microsoft Office Access
+:: Msg: There isn't enough memory to perform this operation. Close unneeded programs and try the operation again.
 == Versions ==
+===v2010-12-31===
+Rolled out to Med to get some early testing if possible. Med won't use labs but the data structure still will need to auto-convert. [[User:Ttenbergen|Ttenbergen]] 12:15, 31 December 2010 (CST)
+* set up 3rd draft of the new labs screen [[User:Ttenbergen|Ttenbergen]] 13:15, 24 December 2010 (CST)
+* second draft of lab form, made lab labels diagonal on top, implemented HSC hiding. [[User:Ttenbergen|Ttenbergen]] 16:14, 23 December 2010 (CST)
+* modified EdsCC query that outputs data to Ed to accomodate new Labs setup. [[User:Ttenbergen|Ttenbergen]] 16:52, 23 December 2010 (CST)
+* made new EdsCC compatible with ed's output specification [[User:Ttenbergen|Ttenbergen]] 17:55, 23 December 2010 (CST)
+* changed date field so it also has time [[User:Ttenbergen|Ttenbergen]] 12:35, 24 December 2010 (CST)
+* made values mandatory for Labs to ensure blank lab entry causes no problem [[User:Ttenbergen|Ttenbergen]] 12:38, 24 December 2010 (CST)
+* fixed type for "tampornade" for 4 entries in s_alldiagnoses [[User:Ttenbergen|Ttenbergen]] 12:31, 24 December 2010 (CST)
+* added to s_Location table HSC_[[OVER]]
+* added to S_Tmp for moves HSC_H7N and HSC_H7T
+* changed end date for QA Septic to 31 Mar 2011
+* [[Early ID study]] set up
+** added entries to s_tmp [[User:Ttenbergen|Ttenbergen]] 13:29, 24 December 2010 (CST)
+* made conversion function from old DB structure to new (module and sub DB_Converter()) [[User:Ttenbergen|Ttenbergen]] 14:08, 30 December 2010 (CST) and [[User:Ttenbergen|Ttenbergen]] 16:53, 30 December 2010 (CST)
+* changed forms to no longer look for e.g. L_Settings etc. [[User:Ttenbergen|Ttenbergen]]
+* removed "edit patients" button and funnel on the viewer [[User:Ttenbergen|Ttenbergen]] 16:53, 30 December 2010 (CST)
+* added room numbers [[User:Ttenbergen|Ttenbergen]] 16:56, 30 December 2010 (CST)
+* got rid of autopsy option for survive/expire field. [[User:Ttenbergen|Ttenbergen]] 18:04, 30 December 2010 (CST)
+* added an error log table; for now it would need to be accessed from the backups for analysis. [[User:Ttenbergen|Ttenbergen]] 18:29, 30 December 2010 (CST)
+===v1.9952===
+rolled out [[User:Ttenbergen|Ttenbergen]] 12:22, 29 November 2010 (CST)
+further cleanup and doing changes requested deep in the wiki...
+* removed city hospitals from [[S_HospitalCodes]] as per [[Hospital previous]] (yesterday) [[User:Ttenbergen|Ttenbergen]] 10:59, 4 November 2010 (CDT)
+** St. Boniface	5	5	1
+** Grace	3	3	1
+** Seven Oaks	11	11	1
+** Misericordia	4	4	1
+** Rehab Center for Children	17	17	1
+** Health Sciences	16	16	1
+** [[Deer Lodge (DLC)]] Center Inc.	19	19	1
+** Riverview Health Center	6	6	1
+** Victoria	7	7	1
+** Children Hospital 	8	8	1
+** Concordia	9	9	1
+* deleted Greensheets form
+* added [[Re-sort button]] [[Image:Resort button.GIF]] to dx, como, labs and pharm forms. [[User:Ttenbergen|Ttenbergen]] 11:23, 4 November 2010 (CDT)
+* fixed "find" button error in dx_chooser form [[User:Ttenbergen|Ttenbergen]] 11:31, 29 November 2010 (CST)
+* added expireds' notes to Pagasa's pending [[User:Ttenbergen|Ttenbergen]] 11:36, 29 November 2010 (CST)
+* added GRA_EMIP to s_locations [[User:Ttenbergen|Ttenbergen]] 11:37, 29 November 2010 (CST)
+* added HSC_H7 to s_locations as per request from Gail Hall. [[User:Ttenbergen|Ttenbergen]] 12:10, 29 November 2010 (CST)
+===v1.9951===
+* c: rolled out [[User:Ttenbergen|Ttenbergen]] 13:42, 2 November 2010 (CDT)
+** added
+*** var 2	H7	Med	HSC
+*** var 1	H7	Med	HSC
+** changed Labs V2
+*** 40	PT/PTT	0	-1	9999 (i.e. to not be collected at HSC
+** removed (as per [[ICU Var 6 - various uses]])
+*** Var 6	"S"	CC		Study - pt enrolled in a study
+* took out call to Alt_locn() that was causing send to hang [[User:Ttenbergen|Ttenbergen]] 13:42, 2 November 2010 (CDT)
+* b: changes got_data() so it will not crash when log file has already been written. Rolled out. [[User:Ttenbergen|Ttenbergen]] 09:28, 2 November 2010 (CDT)
+* a: removed a reference that was causing program to crash on opening.[[User:Ttenbergen|Ttenbergen]] 17:08, 1 November 2010 (CDT)
+Rolled out [[User:Ttenbergen|Ttenbergen]] 14:51, 1 November 2010 (CDT)
+continuing updates where I left off with 1.995 to get the bug fixes out
+* removed following functions that are not used anywhere any longer... [[User:Ttenbergen|Ttenbergen]] 14:03, 27 October 2010 (CDT)
+** alt_locn()
+** laptop()
+** set_relationships()
+** create_rel(...)
+** drop_relationships()
+* added
+** Var	Option	Program	Hosp	Description
+** 2	PY1	Med	HSC	Psych
+** 2	PY3	Med	HSC	Psych
+** 1	PY1	Med	HSC	Psych
+** 1	PY3	Med	HSC	Psych
+* consolidating databasestarter() and laptopopener() in prep for going with new data structure
+* making program quit (Application.Quit) if
+** there is no or bad settings.mdb or
+** no data files/tables
+** any of the tables missing
+* Adding apache points
+** age + pts added to apache tab[[User:Ttenbergen|Ttenbergen]] 12:15, 28 October 2010 (CDT)
+* deleted old PDA references from [[S_AP_Chronic table]] [[User:Ttenbergen|Ttenbergen]] 13:55, 28 October 2010 (CDT)
+* added "fill" versions of Task dxs to use for automatic population
+** Task	Tracheostomy - Fill		100099
+** Task	Hemodialysis - Fill		100199
+** Task	Peritoneal Dialysis - Fill	100299
+** Task	BiPAP or CPAP - Fill		100399
+** Task	Isolation - Fill		100499
+* added code to cb_addPt_Click() to automatically enter the "fill" tasks to new med patients [[User:Ttenbergen|Ttenbergen]] 15:12, 29 October 2010 (CDT)
+* confirmed that dx_checker code to make sure that fill tasks will not be allowed to be sent before changing them to something real.
+* eliminated from s_varOptions, and updated ICU Var 1 and ICU Var 2 - BRR
+** 1	OBS	CC	CON	Obser.Unit in ER for telemetry
+** 2	MAP	CC		MI care map
+* changed program so contents of "'''notes'''" field are written to Pagasa's PDA Status.csv automatically when sending [[User:Ttenbergen|Ttenbergen]] 12:35, 1 November 2010 (CDT)
+* temporarily added got_data() to Database_Starter() to make sure everyone received c:\ccmdb_data\ccmdb_data.mdb [[User:Ttenbergen|Ttenbergen]] 13:52, 1 November 2010 (CDT)
+===v1.995===
+Updt 1.995a Rolled out [[User:Ttenbergen|Ttenbergen]] 13:57, 26 October 2010 (CDT)
+* update to the drug list to some remaining existing hidden drugs. [[User:Ttenbergen|Ttenbergen]] 13:57, 26 October 2010 (CDT)
+rolled out to apply bug fixes [[User:Ttenbergen|Ttenbergen]] 15:39, 25 October 2010 (CDT)
+* added S_Labs_V2 [[User:Ttenbergen|Ttenbergen]] 16:58, 22 October 2010 (CDT)
+* added sorting button for FinalCheck to PatientList in preparation for removing "edit patients" and "filter" buttons.[[User:Ttenbergen|Ttenbergen]] 09:59, 25 October 2010 (CDT)
+* to ensure common usage the master [[CCMDB.accdb]] now uses the external data as well, i.e. internal L_ tables are not an option any longer [[User:Ttenbergen|Ttenbergen]] 10:42, 25 October 2010 (CDT)
+* deleted ancient old L_Tmp that had been kept not to break any PDA syncs [[User:Ttenbergen|Ttenbergen]] 10:54, 25 October 2010 (CDT)
+* fixed "visible" setting for bracket and score on Apache screen so it won't show up in Medicine [[User:Ttenbergen|Ttenbergen]] 12:45, 25 October 2010 (CDT)
+* applied MS kb907836 by grouping and ungrouping controls in both patient list and viewer to fix out-of-memory error. Was able to open and close pts from patient list >50 times without bug, before ~25 would crash it. '''Please let me know if there are further memory errors after this version.''' [[User:Ttenbergen|Ttenbergen]] 13:01, 25 October 2010 (CDT)
+* changed the Pharmacy/Drugs list; re-instated the versions that I had deleted so that existing entries are preserved, but made them so they can't be entered in the future any longer.
+* started work on Public Sub new_db_structure_consolidation(), will roll out without this to get the fixes out there [[User:Ttenbergen|Ttenbergen]] 15:20, 25 October 2010 (CDT)
 ===ver1.994===
@@ Line 14: / Line 129: @@
 * added New Dx 76325 - [[Cardiac ablation]] [[User:Ttenbergen|Ttenbergen]] 13:39, 22 October 2010 (CDT)
 * re-allowed editing for Record field right in [[Patient List]] - I had locked out all fields earlier because this form can't run checks, but since the Record field is not checked nothing wrong with having it accessible right in the list. Also, made it into a drop-down. [[User:Ttenbergen|Ttenbergen]] 13:39, 22 October 2010 (CDT)
-* corrected some code in TmpChecker() that was allowing to send even if there was an error. [[User:Ttenbergen|Ttenbergen]] 13:53, 22 October 2010 (CDT)
+* corrected some code in [[Function TmpChecker]] that was allowing to send even if there was an error. [[User:Ttenbergen|Ttenbergen]] 13:53, 22 October 2010 (CDT)
 * fixed error where no initials in settings file would crash sending [[User:Ttenbergen|Ttenbergen]] 13:53, 22 October 2010 (CDT)
 * cleaned up pharm list [[User:Ttenbergen|Ttenbergen]] 14:29, 22 October 2010 (CDT)
@@ Line 75: / Line 190: @@
 ===v1.9938===
 Reverted due to bugs[[User:Ttenbergen|Ttenbergen]] 16:18, 15 July 2010 (CDT)
-* patient list changes, please comment at '''[[Feedback Request - Patient List]]'''
+* patient list changes
 ** added "Find Patient" button to patient list
 ** disabled editing on the patient list to prevent bypassing checks
@@ Line 85: / Line 200: @@
 * deleted remnants of CPAP, SerUrea, DBili, UrineOutput, ActiveTx since no longer used [[User:Ttenbergen|Ttenbergen]] 10:54, 9 June 2010 (CDT)
 * changed font for instructions for tmp so they show up completely on form (some hidden off to right now)
-* changed order of apache labs - please comment at ''' [[Feedback Request - Apache Labs Order]]'''
+* changed order of apache labs - please comment at ''' Feedback Request - Apache Labs Order'''
 * made sorting of Admit From and Discharge To such that local options (based on settings table) list first. [[User:Ttenbergen|Ttenbergen]] 11:17, 9 June 2010 (CDT)
 * changed lables for Var 3 and 5 to fit into the spaces
@@ Line 95: / Line 210: @@
 * limited labs in drop-down to those collected at location (ie HSC vs Others) [[User:Ttenbergen|Ttenbergen]] 15:41, 2 July 2010 (CDT)
 * changed ABG order as per following: [[User:Ttenbergen|Ttenbergen]] 16:02, 2 July 2010 (CDT)
-** ABG information in the standard order:  Ph, then PCO2, then pO2 {{discussion}}
+** ABG information in the standard order:  Ph, then PCO2, then pO2
 *** where does FIO2 figure in this list? [[User:Ttenbergen|Ttenbergen]] 11:05, 9 June 2010 (CDT)
 **** Tina usually when an ABG is reported, the FiO2 is last but for our purposes it could be listed as first because this is something that we usually look at first to determine which ABG to use in the apache score.--[[User:LKolesar|LKolesar]] 13:51, 9 June 2010 (CDT)
@@ Line 116: / Line 231: @@
 * removed following line which causes error in Access 2002 under certain circumstances
 ** Application.automationsecurity = 2 ' means "msoAutomationSecurityLow" without reference necessary
-* change double-click on notes so that current changes to notes field (and rest of record) are written to DB before opening notes form. Thanks to Shirley for catching and describing this! [[User:Ttenbergen|Ttenbergen]] 10:35, 29 April 2010 (CDT)
+* change double-click on notes so that current changes to notes field (and rest of record) are written to DB before opening notes form. Thanks to [[p:Shirley Kiesman-retired, Dec 31, 2018 | Shirley Kiesman]] for catching and describing this! [[User:Ttenbergen|Ttenbergen]] 10:35, 29 April 2010 (CDT)
 ===V1.9934===
@@ Line 135: / Line 250: @@
 * took pH out of ABG testing[[User:Ttenbergen|Ttenbergen]] 10:11, 14 April 2010 (CDT)
 * added Apache scores and score-listers to Apache values. [[User:Ttenbergen|Ttenbergen]] 10:11, 14 April 2010 (CDT)
-** Should the apache scores be visible for medicine, for those values collected in both programs? {{discussion}} [[User:Ttenbergen|Ttenbergen]] 10:11, 14 April 2010 (CDT)
+** Should the apache scores be visible for medicine, for those values collected in both programs? [[User:Ttenbergen|Ttenbergen]] 10:11, 14 April 2010 (CDT)
 * added "Add Patient" to patient list form, to be able to add patients from there rather than having to do so from the patient editor page. [[User:Ttenbergen|Ttenbergen]] 10:45, 14 April 2010 (CDT)
 * made function "add_record_status" to add record_status field to L_Log in preparation for new data repository. This has to be done locally for laptops since we don't have central access to the data, so automation was required. [[User:Ttenbergen|Ttenbergen]] 10:28, 15 April 2010 (CDT)
@@ Line 202: / Line 317: @@
 * [[BP Helper button]] added, '''not yet functional'''
 * Changed the way check functions access data from using using "Set this_db = CurrentDb" to accessing CurrentDB directly; had used this_db to address a different error earlier on which no longer seems to be a problem
-* changed [[Check Renal IncompatibleDxs]] to implement changes in [[Renal_Coding_Considerations#Competing_Diagnoses]]
+* changed [[query Check Renal IncompatibleDxs]] to implement changes in [[Renal Coding Considerations (old)#Competing_Diagnoses]]
 * changed [[Pending_Julie]] to list discharge ''dates'' even if a '''''time''''' is not entered
@@ Line 222: / Line 337: @@
 Changed batch files to create a total of 20 previous versions for each location to retain data. [[User:Ttenbergen|Ttenbergen]] 12:21, 30 November 2009 (CST)
 * [[Updt all.bat]] changes complete
-* [["News and backup" batch file]] changes complete
+* [[News and backup]] changes complete
-[[Category: IT Instructions]]
+[[Category:CCMDB.accdb]]
-[[Category:Development Documentation]]
+[[Category:Change Logs CCMDB]]
-[[Category: Change Logs CCMDB]]