CCMDB.mdb Change Log 2014: Difference between revisions

m cat
m Text replacement - "[[Category: " to "[[Category:"
 
(24 intermediate revisions by 2 users not shown)
Line 142: Line 142:
* confirmed that sending while previously "sent" patients are still on the list should be possible; sent out email to find out what problems people appear to be having with this.
* confirmed that sending while previously "sent" patients are still on the list should be possible; sent out email to find out what problems people appear to be having with this.
* collectors were getting error "You entered an expression that has no value" at end of sending; changed the naming of the log file to eliminate this, please let me know if this still shows up
* collectors were getting error "You entered an expression that has no value" at end of sending; changed the naming of the log file to eliminate this, please let me know if this still shows up
* Critical Care - some locations were getting error about trach tasks and dxs being inconsistent. Changed query ''check_trach_dx_task'' to eliminate the error thatsome locations have been getting about inconsistent trach diagnoses and tasks because, of course, cc doesn't do tasks.
* Critical Care - some locations were getting error about trach tasks and dxs being inconsistent. Changed [[query check_trach_dx_task]] to eliminate the error thatsome locations have been getting about inconsistent trach diagnoses and tasks because, of course, cc doesn't do tasks.
* collectors were getting errors that transfer dates are required even for ward-to-ward transfers. I can't remember what the rules were for that and the wiki is down, so excluding patients discharged to ward from transfer date requirement for now; need to review what the story was when wiki is back up. (function Validate_TransDate())don't need to know
* collectors were getting errors that transfer dates are required even for ward-to-ward transfers. I can't remember what the rules were for that and the wiki is down, so excluding patients discharged to ward from transfer date requirement for now; need to review what the story was when wiki is back up. (function Validate_TransDate())don't need to know
* changed buttons for tmp date "now" to only include date, not current time.  
* changed buttons for tmp date "now" to only include date, not current time.  
Line 153: Line 153:
=== 2014-Oct-22 - 2 ===
=== 2014-Oct-22 - 2 ===
rolled with old version number because it was a quick fix Ttenbergen 10:27, 2014 October 23 (CDT)
rolled with old version number because it was a quick fix Ttenbergen 10:27, 2014 October 23 (CDT)
* fixed [[Check OR from but not Surgical Type]] Ttenbergen 10:27, 2014 October 23 (CDT)
* fixed query ''Check OR from but not Surgical Type'' Ttenbergen 10:27, 2014 October 23 (CDT)


=== 2014-Oct-22 ===
=== 2014-Oct-22 ===
Line 164: Line 164:
* changed province entry for Newfoundland in [[S Provinces]] from NF o NL; also changed sort order of dropdown to have MB at the top. Ttenbergen 11:48, 2014 October 22 (CDT)
* changed province entry for Newfoundland in [[S Provinces]] from NF o NL; also changed sort order of dropdown to have MB at the top. Ttenbergen 11:48, 2014 October 22 (CDT)
* updated [[Minimal_Data_Set#CCDMB_Data_Integrity_Checks]]. Ttenbergen 12:46, 2014 October 22 (CDT)
* updated [[Minimal_Data_Set#CCDMB_Data_Integrity_Checks]]. Ttenbergen 12:46, 2014 October 22 (CDT)
* new consistency check [[Check OR from but not Surgical Type]] Ttenbergen 15:50, 2014 October 22 (CDT)
* new consistency check ''Check OR from but not Surgical Type'' Ttenbergen 15:50, 2014 October 22 (CDT)


Changes Collectors don't need to know about
Changes Collectors don't need to know about
Line 191: Line 191:
** moved the close button on the view form to the left so it's visible on old laptops running Access 2010 Ttenbergen 16:29, 2014 September 4 (CDT)
** moved the close button on the view form to the left so it's visible on old laptops running Access 2010 Ttenbergen 16:29, 2014 September 4 (CDT)
** updated main dx name for dx codes 831** to "Other Head/Neck-OR Procedures" from just "Other procedures"
** updated main dx name for dx codes 831** to "Other Head/Neck-OR Procedures" from just "Other procedures"
** updated main dx name for dx codes 199** to "[[cardiovascular other problems]]" from just "Other problems"
** updated main dx name for dx codes 199** to "[[Other cardiovascular problems]]" from just "Other problems"
** updated [[Debridement - Cardiovascular]] from old wording "Wound Debridement" Ttenbergen 16:29, 2014 September 11 (CDT)
** updated [[Debridement - Cardiovascular]] from old wording "Wound Debridement" Ttenbergen 16:29, 2014 September 11 (CDT)
* changes that should be invisible
* changes that should be invisible
** disabled sending to [[PDA_Pending.mdb]] Ttenbergen 10:26, 2014 September 15 (CDT)
** disabled sending to [[PDA_Pending.mdb]] Ttenbergen 10:26, 2014 September 15 (CDT)
** changed way send_dttm is use to ensure local settings date format can not mess up the time stamp in centralized. Ttenbergen 10:26, 2014 September 15 (CDT)
** changed way send_dttm is use to ensure local settings date format can not mess up the time stamp in [[centralized_data.mdb]]. Ttenbergen 10:26, 2014 September 15 (CDT)


=== 2014-Aug-25 ===
=== 2014-Aug-25 ===
rolled out Ttenbergen 11:42, 2014 September 3 (CDT)
rolled out Ttenbergen 11:42, 2014 September 3 (CDT)
* changed spelling of dx code [[Art/Ven Embolus/Thrombus]] 13209 to inNominate Ttenbergen 09:31, 2014 August 25 (CDT)
* changed spelling of dx code [[Art/Ven Embolus/Thrombus]] 13209 to inNominate Ttenbergen 09:31, 2014 August 25 (CDT)
* changed wording for [[50507 - CVA-Cerebral Venous Thrombosis]] from Superior Sagital Sinus (should have been sagittal but that was the spelling...) Ttenbergen 09:51, 2014 August 25 (CDT)
* changed wording for [[CVA-Cerebral Vascular Accident | CVA-Cerebral Vascular Accident - '''CVA-Cerebral Venous Thrombosis''']] from Superior Sagital Sinus (should have been sagittal but that was the spelling...) Ttenbergen 09:51, 2014 August 25 (CDT)
* updated labs_flowsheet form so it will hopefully work when using font magnification... ('''Trish or Joyce to test''') Ttenbergen 12:47, 2014 August 26 (CDT)
* updated labs_flowsheet form so it will hopefully work when using font magnification... ('''Trish or Joyce to test''') Ttenbergen 12:47, 2014 August 26 (CDT)
* fixed spelling for "sending complete" Ttenbergen 12:59, 2014 August 26 (CDT)
* fixed spelling for "sending complete" Ttenbergen 12:59, 2014 August 26 (CDT)
* added code to the patient list open button to change focus away from the Patient ID to prevent accidental edits. Ttenbergen 13:04, 2014 August 26 (CDT)
* added code to the patient list open button to change focus away from the [[Pat ID]] to prevent accidental edits. Ttenbergen 13:04, 2014 August 26 (CDT)
* [[L_Log not updated for location, sex and type]]: updated query ''send_Centralized_1L_Log_update'' which was not updating the following fields:  
* [[L_Log not updated for location, sex and type]]: updated query ''send_Centralized_1L_Log_update'' which was not updating the following fields:  
** actually used and relevant in long-term data
** actually used and relevant in long-term data
Line 239: Line 239:
* changed sending so pharm and labs are not synched for medicine, waste of time. Ttenbergen 14:53, 2014 August 7 (CDT)
* changed sending so pharm and labs are not synched for medicine, waste of time. Ttenbergen 14:53, 2014 August 7 (CDT)
* cleaned up send_progress form (had some leftovers) and moved ICU-only stuff over to the side in it - Ttenbergen 14:57, 2014 August 7 (CDT)
* cleaned up send_progress form (had some leftovers) and moved ICU-only stuff over to the side in it - Ttenbergen 14:57, 2014 August 7 (CDT)
* updated error message given when centralized_data.mdb not found on server to contact main office. - Ttenbergen 14:59, 2014 August 7 (CDT)
* updated error message given when [[centralized_data.mdb]] not found on server to contact main office. - Ttenbergen 14:59, 2014 August 7 (CDT)


=== 2014-Jul-31-2 ===
=== 2014-Jul-31-2 ===
rolled out Ttenbergen 11:02, 2014 August 7 (CDT)
rolled out Ttenbergen 11:02, 2014 August 7 (CDT)
* updated the s_alldiagnoses with version in centralized_data.mdb for consistency Ttenbergen 13:36, 2014 July 31 (CDT)
* updated the s_alldiagnoses with version in [[centralized_data.mdb]] for consistency Ttenbergen 13:36, 2014 July 31 (CDT)
* corrected [[AaDO2]] scoring calculation to not be Null if AaDO2 <=0 Ttenbergen 16:41, 2014 July 31 (CDT)
* corrected [[AaDO2]] scoring calculation to not be Null if AaDO2 <=0 Ttenbergen 16:41, 2014 July 31 (CDT)
* disabled ARF change query, it omitted that only those set to "enter" should be set to "". oi. Ttenbergen 10:39, 2014 August 7 (CDT)
* disabled ARF change query, it omitted that only those set to "enter" should be set to "". oi. Ttenbergen 10:39, 2014 August 7 (CDT)
Line 277: Line 277:
rolled out Ttenbergen 16:06, 2014 July 28 (CDT)
rolled out Ttenbergen 16:06, 2014 July 28 (CDT)
* constrained the dropdown for Apache ARF to only existing content, which will prevent a "blank" from being entered Ttenbergen 10:36, 2014 July 21 (CDT)
* constrained the dropdown for Apache ARF to only existing content, which will prevent a "blank" from being entered Ttenbergen 10:36, 2014 July 21 (CDT)
* updated error message when sending record that already exists as not-incomplete in centralized_data.mdb to state that most likely this is because of a wrong location or patient ID. Ttenbergen 11:09, 2014 July 24 (CDT)
* updated error message when sending record that already exists as not-incomplete in [[centralized_data.mdb]] to state that most likely this is because of a wrong location or patient ID. Ttenbergen 11:09, 2014 July 24 (CDT)
* updated new patient generator to set Form_View.Ap_ARF = Null for medicine patients for consistent data in the back end. - Ttenbergen 14:59, 2014 July 28 (CDT)
* updated new patient generator to set Form_View.Ap_ARF = Null for medicine patients for consistent data in the back end. - Ttenbergen 14:59, 2014 July 28 (CDT)
* added update code to set all existing medicine patients ARF to null Ttenbergen 15:04, 2014 July 28 (CDT)
* added update code to set all existing medicine patients ARF to null Ttenbergen 15:04, 2014 July 28 (CDT)
Line 304: Line 304:
** 46300 [[Sedatives/Antidepressants]] Ttenbergen 14:19, 2014 July 7 (CDT)
** 46300 [[Sedatives/Antidepressants]] Ttenbergen 14:19, 2014 July 7 (CDT)
** 25001 [[Lupus Pneumonitis]] Ttenbergen 14:19, 2014 July 7 (CDT)
** 25001 [[Lupus Pneumonitis]] Ttenbergen 14:19, 2014 July 7 (CDT)
** 8200 [[Necrotizing soft tissue infections]] to [[Necrotizing soft tissue infections (necrotizing fasciitis, myonecrosis, Gas OR clostridial gangrene etc.)]]
** 8200 "Necrotizing soft tissue infections" to "Necrotizing soft tissue infections (necrotizing fasciitis, myonecrosis, Gas OR clostridial gangrene etc.)" for [[Necrotizing soft tissue infections (necrotizing fasciitis, myonecrosis, gas or clostridial gangrene etc.)]]


=== 2014-Jul-03 ===
=== 2014-Jul-03 ===
Line 327: Line 327:
* changed [[s_Locations]] to make STB_A5 and STB_B4 inactive - Ttenbergen 10:08, 2014 June 25 (CDT)
* changed [[s_Locations]] to make STB_A5 and STB_B4 inactive - Ttenbergen 10:08, 2014 June 25 (CDT)
* deleted old dev query ''s_charlson_comorbid_wiki_list_generator'' Ttenbergen 10:30, 2014 June 25 (CDT)
* deleted old dev query ''s_charlson_comorbid_wiki_list_generator'' Ttenbergen 10:30, 2014 June 25 (CDT)
* messed around with [[S charlson dxs]] and dependencies of to eliminate duplication and potential for confusion Ttenbergen 11:14, 2014 June 25 (CDT)
* messed around with [[s_charlson_dxs table]] and dependencies of to eliminate duplication and potential for confusion Ttenbergen 11:14, 2014 June 25 (CDT)
* '''to fix sending''' - re-enabled function overlap from last update, is used during sending after all... Ttenbergen 10:22, 2014 June 26 (CDT)
* '''to fix sending''' - re-enabled function overlap from last update, is used during sending after all... Ttenbergen 10:22, 2014 June 26 (CDT)


Line 335: Line 335:
** reverted that change until Trish has had a change to stage the change over. Ttenbergen 17:31, 2014 June 12 (CDT)
** reverted that change until Trish has had a change to stage the change over. Ttenbergen 17:31, 2014 June 12 (CDT)
* integrated change from v [[#2014-Jun-11]]. Ttenbergen 16:40, 2014 June 12 (CDT)
* integrated change from v [[#2014-Jun-11]]. Ttenbergen 16:40, 2014 June 12 (CDT)
* updated [[Wegener's Granulomatosis / Granulomatosis with polyangiitis]] in [[s_alldiagnoses]] Ttenbergen 15:42, 2014 June 19 (CDT)
* updated [[Wegener's Granulomatosis / Granulomatosis with polyangiitis]] in [[s_AllDiagnoses table]] Ttenbergen 15:42, 2014 June 19 (CDT)
* changed Apache admit type to not allow anything other than dropdown values and blank, blank will not allow checking apache complete. Ttenbergen 12:41, 2014 June 23 (CDT)
* changed Apache admit type to not allow anything other than dropdown values and blank, blank will not allow checking apache complete. Ttenbergen 12:41, 2014 June 23 (CDT)
* fixes to s_alldiagnoses legacy entries: disallow collection for 3097, 84602, 79497, 39997, 83197, 80697, 59997, 77797, 84897, 21997, should have been like that already but was missed during imports and updates somehow Ttenbergen 12:48, 2014 June 23 (CDT)
* fixes to s_alldiagnoses legacy entries: disallow collection for 3097, 84602, 79497, 39997, 83197, 80697, 59997, 77797, 84897, 21997, should have been like that already but was missed during imports and updates somehow Ttenbergen 12:48, 2014 June 23 (CDT)
* imported newest version of module ''Apache_Scoring'' from [[Centralized data front end.mdb]] Ttenbergen 13:18, 2014 June 23 (CDT)
* imported newest version of module ''Apache_Scoring'' from [[Centralized_data_front_end.accdb]] Ttenbergen 13:18, 2014 June 23 (CDT)
** made some tweaks to integrate it Ttenbergen 14:00, 2014 June 23 (CDT)
** made some tweaks to integrate it Ttenbergen 14:00, 2014 June 23 (CDT)
** renamed Apache scoring callers in module check_forms so they are never same as in ApacheScoring Ttenbergen 13:21, 2014 June 23 (CDT)
** renamed Apache scoring callers in module check_forms so they are never same as in ApacheScoring Ttenbergen 13:21, 2014 June 23 (CDT)
Line 348: Line 348:
*Laptop B3 to allow location HSC_H4H.
*Laptop B3 to allow location HSC_H4H.
*I rolled it out.[[User:TOstryzniuk|Trish Ostryzniuk]] 12:07, 2014 June 11 (CDT)
*I rolled it out.[[User:TOstryzniuk|Trish Ostryzniuk]] 12:07, 2014 June 11 (CDT)
**Tina will have to integrate this minor change with the copy of ccmdb.mdb program she may have on her laptop.[[User:TOstryzniuk|Trish Ostryzniuk]] 12:08, 2014 June 11 (CDT)
**Tina will have to integrate this minor change with the copy of [[CCMDB.accdb]] program she may have on her laptop.[[User:TOstryzniuk|Trish Ostryzniuk]] 12:08, 2014 June 11 (CDT)
*** Done for version [[#2014-Jun-12]] Ttenbergen 16:40, 2014 June 12 (CDT)
*** Done for version [[#2014-Jun-12]] Ttenbergen 16:40, 2014 June 12 (CDT)


Line 376: Line 376:


====other changes====
====other changes====
* imported the apache_scoring module as used in centralized front end, was changed there and they are supposed to be the same. No need to roll for this, change has no effect on function of ccmdb.mdb - Ttenbergen 10:20, 2014 May 5 (CDT)
* imported the apache_scoring module as used in centralized front end, was changed there and they are supposed to be the same. No need to roll for this, change has no effect on function of [[CCMDB.accdb]] - Ttenbergen 10:20, 2014 May 5 (CDT)
* made s_admitDischarge same as elsewhere, ie incl. setting FP and FR to "surgical" and making sure that the Grace and HSC Nursing home entry is present. Ttenbergen 15:55, 2014 May 8 (CDT)
* made s_admitDischarge same as elsewhere, ie incl. setting FP and FR to "surgical" and making sure that the Grace and HSC Nursing home entry is present. Ttenbergen 15:55, 2014 May 8 (CDT)
* implementing limitation for locations dropdown to only those collected by this laptop
* implementing limitation for locations dropdown to only those collected by this laptop
** added table ''s_locations_allowed_collection'' Ttenbergen 11:14, 2014 June 2 (CDT)
** added table ''s_locations_allowed_collection'' Ttenbergen 11:14, 2014 June 2 (CDT)
** updated query ''s_Locations_local'' to use new table to restrict options Ttenbergen 11:17, 2014 June 2 (CDT)
** updated query ''s_Locations_local'' to use new table to restrict options Ttenbergen 11:17, 2014 June 2 (CDT)
* get Birth_MY into centralized_data.mdb
* get Birth_MY into [[centralized_data.mdb]]
** updated queries ''send_Centralized_1L_Log__intermediate'', ''Send_Centralized_1L_Log_append'' and ''Send_Centralized_1L_Log_update''Ttenbergen 11:29, 2014 June 2 (CDT)
** updated queries ''send_Centralized_1L_Log__intermediate'', ''Send_Centralized_1L_Log_append'' and ''Send_Centralized_1L_Log_update''Ttenbergen 11:29, 2014 June 2 (CDT)
* imported from centralized newest versions of  
* imported from centralized newest versions of  
Line 390: Line 390:
=== 2014-05-01 ===
=== 2014-05-01 ===
rolled - Ttenbergen 15:13, 2014 May 1 (CDT)
rolled - Ttenbergen 15:13, 2014 May 1 (CDT)
* fixed query "send_set_oLog_to_sent" to properly link on Pat_ID ''and location'', which was missing, leading to seemingly random patients being set to "Sent". This should address [[Bug - Incomplete patients are being set to "sent" in Centralized data.mdb]]. Ttenbergen 10:26, 2014 May 1 (CDT)
* fixed query "send_set_oLog_to_sent" to properly link on Pat_ID ''and location'', which was missing, leading to seemingly random patients being set to "Sent". This should address [[Bug - Incomplete patients are being set to "sent" in Centralized_data.accdb]]. Ttenbergen 10:26, 2014 May 1 (CDT)
* query "Minimal_dataset_incomplete", [[Minimal Data Set]]
* query "Minimal_dataset_incomplete", [[Minimal Data Set]]
** confirmed that there is no check for admit time; some collectors were entering fake times to be able to sent Ttenbergen 10:43, 2014 May 1 (CDT)
** confirmed that there is no check for admit time; some collectors were entering fake times to be able to sent Ttenbergen 10:43, 2014 May 1 (CDT)
Line 420: Line 420:
=== 2014-03-13 ===
=== 2014-03-13 ===
rolled out Ttenbergen 10:41, 2014 March 24 (CDT)
rolled out Ttenbergen 10:41, 2014 March 24 (CDT)
* changing how data is transferred to [[centralized_data.mdb]]
* changing how data is transferred to [[[[centralized_data.mdb]]]]
** changed the send_centralized_ queries to include both incomplete and complete patients
** changed the send_centralized_ queries to include both incomplete and complete patients
** added code near the end of sending to set [[RecordStatus field]] to "sent" in centralized as well, was only done in ccmdb_data.mdb before. Ttenbergen 11:26, 2014 March 21 (CDT)
** added code near the end of sending to set [[RecordStatus field]] to "sent" in centralized as well, was only done in ccmdb_data.mdb before. Ttenbergen 11:26, 2014 March 21 (CDT)
Line 431: Line 431:
=== 2014-03-06 ===
=== 2014-03-06 ===
rolled out Ttenbergen 14:48, 2014 March 6 (CST)
rolled out Ttenbergen 14:48, 2014 March 6 (CST)
* reinstates comorbid [[Viral Hepatitis]] into [[S_alldiagnoses]]; had been deleted in January because the 00 subcode should not be used for dxs any more, but still needs to be there for comos. Ttenbergen 14:48, 2014 March 6 (CST)
* reinstates comorbid [[Viral Hepatitis]] into [[s_AllDiagnoses table]]; had been deleted in January because the 00 subcode should not be used for dxs any more, but still needs to be there for comos. Ttenbergen 14:48, 2014 March 6 (CST)


=== 2014-03-05 ===
=== 2014-03-05 ===
Line 445: Line 445:
rolled out Ttenbergen 15:15, 2014 March 3 (CST)
rolled out Ttenbergen 15:15, 2014 March 3 (CST)
* de-activated the [[Allied Health Consults]] project entries in s_tmp - Ttenbergen 16:11, 2014 February 28 (CST)
* de-activated the [[Allied Health Consults]] project entries in s_tmp - Ttenbergen 16:11, 2014 February 28 (CST)
* confirmed that send function is checking that centralized_data.mdb is present - Ttenbergen 16:36, 2014 February 28 (CST)
* confirmed that send function is checking that [[centralized_data.mdb]] is present - Ttenbergen 16:36, 2014 February 28 (CST)
* confirmed that dates in registry now work consistently re input mask vs format - Ttenbergen 16:38, 2014 February 28 (CST)
* confirmed that dates in registry now work consistently re input mask vs format - Ttenbergen 16:38, 2014 February 28 (CST)
* added checks for [[ER Wait]] validation: Ttenbergen 17:12, 2014 February 28 (CST)
* added checks for [[ER Wait]] validation: Ttenbergen 17:12, 2014 February 28 (CST)
** s_tmp_ER_Wait_has_tmp_not_from_ER
** s_tmp_ER_Wait_has_tmp_not_from_ER
** s_tmp_ER_Wait_from_ER_no_ER_Wait
** s_tmp_ER_Wait_from_ER_no_ER_Wait
* removed table [[s_tmp_moverequired]] since it is not used any more. Ttenbergen 10:12, 2014 March 3 (CST)
* removed table s_tmp_moverequired since it is not used any more. Ttenbergen 10:12, 2014 March 3 (CST)
* updated query '''s_tmp_project_item_consistent''' (run by pre-send checker) to accommodate tmp entries without item/values, needed to accommodate new "No Transfer Date" entry Ttenbergen 15:11, 2014 March 3 (CST)
* updated [[query s_tmp_project_item_consistent]] (run by [[Pre-send Checker]]) to accommodate tmp entries without item/values, needed to accommodate new "No Transfer Date" entry Ttenbergen 15:11, 2014 March 3 (CST)


=== 2014-01-29 ===
=== 2014-01-29 ===
Line 483: Line 483:


* refactored function CCMDB_age to be able to use it with parameters (birth, admit). Ttenbergen 15:40, 2014 January 2 (CST)
* refactored function CCMDB_age to be able to use it with parameters (birth, admit). Ttenbergen 15:40, 2014 January 2 (CST)
* commented out functions GCS_Eye, GCS_motor, GCS_verbal. Don't seem to be used anywhere, and if they were, the scores should now come from table s_GCS. Ttenbergen 16:08, 2014 January 2 (CST)
* commented out functions GCS_Eye, GCS_motor, GCS_verbal. Don't seem to be used anywhere, and if they were, the scores should now come from [[s_GCS table]]. Ttenbergen 16:08, 2014 January 2 (CST)
** updated Transition Coordinator function to draw Apache scoring from new location Ttenbergen 18:39, 2014 January 15 (CST)
** updated Transition Coordinator function to draw Apache scoring from new location Ttenbergen 18:39, 2014 January 15 (CST)
* changed function Ap_Chronic to be able to take CH and AT as parameters rather than draw from form Ttenbergen 16:08, 2014 January 2 (CST)
* changed function Ap_Chronic to be able to take CH and AT as parameters rather than draw from form Ttenbergen 16:08, 2014 January 2 (CST)
Line 499: Line 499:
** Function ApScore_WBC
** Function ApScore_WBC
** moved in Function Ap_Chronic
** moved in Function Ap_Chronic
* fixed spelling for [[Polycythemia Rubra Vera]] in [[s_AllDiagnoses]] Ttenbergen 10:19, 2014 January 6 (CST)
* fixed spelling for [[Polycythemia Rubra Vera]] in [[s_AllDiagnoses table]] Ttenbergen 10:19, 2014 January 6 (CST)
* added yes/no column "choosable" to table s_AP_Chronic; added record "0HasChronic" as unchoosable record, updated form_view.ap_Chronic to draw from revised table. Ttenbergen 10:19, 2014 January 10 (CST)
* added yes/no column "choosable" to table s_AP_Chronic; added record "0HasChronic" as unchoosable record, updated form_view.ap_Chronic to draw from revised table. Ttenbergen 10:19, 2014 January 10 (CST)
* added column "surgical" to table s_AdmitDischarge. Ttenbergen 10:28, 2014 January 10 (CST)
* added column "surgical" to table s_AdmitDischarge. Ttenbergen 10:28, 2014 January 10 (CST)
* cleaned defunct HanDBase columns out of table s_AP_AdmitType. Ttenbergen 10:43, 2014 January 10 (CST)
* cleaned defunct HanDBase columns out of table s_AP_AdmitType. Ttenbergen 10:43, 2014 January 10 (CST)
* added ''NH Nursing Home HSC'' to [[s_AdmitDischarge]]
* added ''NH Nursing Home HSC'' to [[s_AdmitDischarge]]
* added ''W4'' to [[s_varOptions]] var1/2 entries for Grace  
* added ''W4'' to s_varOptions var1/2 entries for Grace  
* integrated changes to closeNavPane() and MinimizeRibbons() that were made for Access 2010 but were breaking 2003 and were reverted. Tested on Con's laptop and on mine, work now. Ttenbergen 16:10, 2014 January 15 (CST)
* integrated changes to closeNavPane() and MinimizeRibbons() that were made for Access 2010 but were breaking 2003 and were reverted. Tested on Con's laptop and on mine, work now. Ttenbergen 16:10, 2014 January 15 (CST)


[[Category: CCMDB.mdb]]
[[Category:CCMDB.accdb]]
[[Category: Change Logs CCMDB]]
[[Category:Change Logs CCMDB]]