CCMDB.mdb Change Log 2016: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (23 intermediate revisions by the same user not shown) | |||
| Line 48: | Line 48: | ||
=== 2016-Nov-28 === | === 2016-Nov-28 === | ||
rolled out Ttenbergen 10:26, 2016 November 28 (CST) | rolled out Ttenbergen 10:26, 2016 November 28 (CST) | ||
* updating sending to work with changes in [[Centralized_data. | * updating sending to work with changes in [[Centralized_data.accdb]]_Change_Log#2016-Nov-24]] Ttenbergen 10:08, 2016 November 28 (CST) | ||
** cleaned up some old commented out code Ttenbergen 10:21, 2016 November 28 (CST) | ** cleaned up some old commented out code Ttenbergen 10:21, 2016 November 28 (CST) | ||
** updated query ''send_check_centralized_is_owner'' which was still looking at R_Location Ttenbergen 10:21, 2016 November 28 (CST) | ** updated query ''send_check_centralized_is_owner'' which was still looking at R_Location Ttenbergen 10:21, 2016 November 28 (CST) | ||
| Line 117: | Line 117: | ||
Rolled out. [[User:Haubel|Haubel]] 13:27, 2016 November 9 (CST) | Rolled out. [[User:Haubel|Haubel]] 13:27, 2016 November 9 (CST) | ||
* Criteria added to the [[ | * Criteria added to the [[Query check overstay not entered]] query to exclude EMIPs. | ||
===2016-Nov-07-2=== | ===2016-Nov-07-2=== | ||
| Line 123: | Line 123: | ||
* updated send queries to include fields that were added to collection but not to send queries: | * updated send queries to include fields that were added to collection but not to send queries: | ||
** [[GCS sedated field]] Ttenbergen 15:36, 2016 November 7 (CST) | ** [[GCS sedated field]] Ttenbergen 15:36, 2016 November 7 (CST) | ||
** | ** ''Accept DtTm missing field'' Ttenbergen 16:25, 2016 November 7 (CST) | ||
* commented out s_tmp_ER_wait* queries, none should need to run any longer since all that is in new date/location fields. | * commented out s_tmp_ER_wait* queries, none should need to run any longer since all that is in new date/location fields. | ||
* removed "from" options from Overstay dropdown in tmp. Ttenbergen 16:53, 2016 November 7 (CST) | * removed "from" options from Overstay dropdown in tmp. Ttenbergen 16:53, 2016 November 7 (CST) | ||
| Line 154: | Line 154: | ||
===2016-Oct-31=== | ===2016-Oct-31=== | ||
rolled out Ttenbergen 11:42, 2016 November 3 (CDT) | rolled out Ttenbergen 11:42, 2016 November 3 (CDT) | ||
* [[s_tmp table]]; cleaning up to be in sync with [[:Category: | * [[s_tmp table]]; cleaning up to be in sync with [[:Category:Project]] re what's active etc. | ||
===2016-Oct-27-2=== | ===2016-Oct-27-2=== | ||
| Line 162: | Line 162: | ||
===2016-Oct-27=== | ===2016-Oct-27=== | ||
rolled out Ttenbergen 10:01, 2016 October 27 (CDT) | rolled out Ttenbergen 10:01, 2016 October 27 (CDT) | ||
* updated the cross check for [[Overstay_Predictor_Project_Collection_Instructions]] so error msg will be specific and say that colour might be what is missing. | * updated the [[cross check]] for [[Overstay_Predictor_Project_Collection_Instructions]] so error msg will be specific and say that colour might be what is missing. | ||
===2016-Oct-20=== | ===2016-Oct-20=== | ||
rolled out Ttenbergen 17:13, 2016 October 26 (CDT) | rolled out Ttenbergen 17:13, 2016 October 26 (CDT) | ||
* | * "Accept DtTm" required from own ER only | ||
** checked Function from_ER() | ** checked Function from_ER() | ||
** updated | ** updated [[Query check_pt_from_ER]] to only trigger for own ER Ttenbergen 11:37, 2016 October 20 (CDT) | ||
* [[ACP Status | * [[ACP Status Collection in ICU]] - update to allow no date if checkbox is checked Ttenbergen 15:51, 2016 October 20 (CDT) | ||
** table ''s_tmp'' - added label "no date" for bool_var Ttenbergen 15:51, 2016 October 20 (CDT) | ** table ''s_tmp'' - added label "no date" for bool_var Ttenbergen 15:51, 2016 October 20 (CDT) | ||
** updated [[ACP_Status_collection_in_ICU#Collection_Instructions]] Ttenbergen 15:51, 2016 October 20 (CDT) | ** updated [[ACP_Status_collection_in_ICU#Collection_Instructions]] Ttenbergen 15:51, 2016 October 20 (CDT) | ||
** query | ** [[query s_tmp_ACP]] - updated Ttenbergen 16:24, 2016 October 20 (CDT) | ||
* minimal record set required for [[Overstay_Predictor_Project_Collection_Instructions#Changes_to_regular_minimal_data_collection_and_entry_required_for_the_Overstay_Project]] | * minimal record set required for [[Overstay_Predictor_Project_Collection_Instructions#Changes_to_regular_minimal_data_collection_and_entry_required_for_the_Overstay_Project]] | ||
** query ''s_tmp_no_overstay_colour'' - not used by queries or VBA, deleted query | ** query ''s_tmp_no_overstay_colour'' - not used by queries or VBA, deleted query | ||
| Line 181: | Line 181: | ||
===2016-Oct-13=== | ===2016-Oct-13=== | ||
rolled out Ttenbergen 11:11, 2016 October 13 (CDT) | rolled out Ttenbergen 11:11, 2016 October 13 (CDT) | ||
* added '''real_collection''' column to [[s_dispo_table]]l; required for some cross | * added '''real_collection''' column to [[s_dispo_table]]l; required for some [[cross check]]s in CFE, see [[Centralized_data_front_end.mdb_Change_Log_2016#2016-10-12-2]] Ttenbergen 11:11, 2016 October 13 (CDT) | ||
* moved the [[Postal Code field]] and [[Province]] closer to the [[Pre-admit Inpatient Institution field]] Ttenbergen 14:31, 2016 October 12 (CDT) | * moved the [[Postal Code field]] and [[Province]] closer to the [[Pre-admit Inpatient Institution field]] Ttenbergen 14:31, 2016 October 12 (CDT) | ||
| Line 196: | Line 196: | ||
** renamed "Winkler/Bethel/Boundary Trails*" to "Winkler/Bethel*" since there is a "Winkler/Boundary Trails". ''' Will need to fix data for pre-/post- amalgamation in 2001. ''' Ttenbergen 09:58, 2016 September 29 (CDT) | ** renamed "Winkler/Bethel/Boundary Trails*" to "Winkler/Bethel*" since there is a "Winkler/Boundary Trails". ''' Will need to fix data for pre-/post- amalgamation in 2001. ''' Ttenbergen 09:58, 2016 September 29 (CDT) | ||
** made all entries for old Morden and Winkler records inactive, the OR/RR ones were mistakenly active. | ** made all entries for old Morden and Winkler records inactive, the OR/RR ones were mistakenly active. | ||
* updated Function ''Validate_Accept_DtTm()'' to use | * updated Function ''Validate_Accept_DtTm()'' to use ''Accept DtTm missing field'' check box and to allow time = 0:00 Ttenbergen 10:15, 2016 September 29 (CDT) | ||
===2016-Sep-26=== | ===2016-Sep-26=== | ||
| Line 207: | Line 207: | ||
* cleaned out links to "new_*" tables, must have stopped a test in the middle of DB Converter | * cleaned out links to "new_*" tables, must have stopped a test in the middle of DB Converter | ||
* labels to Web Links: off ward, dc treatment | * labels to Web Links: off ward, dc treatment | ||
* added | * added ''Accept_DtTm_missing_field'' and [[GCS sedated field]] | ||
* confirmed that GRA_EMIP now available as previous location | * confirmed that GRA_EMIP now available as previous location | ||
* in [[Patient Viewer]] | * in [[Patient Viewer]] | ||
| Line 232: | Line 232: | ||
* changed [[GRA_EMIP]] in [[s_dispo table]] to be available in [[Previous Location field]], was somehow missed Ttenbergen 16:10, 2016 September 19 (CDT) | * changed [[GRA_EMIP]] in [[s_dispo table]] to be available in [[Previous Location field]], was somehow missed Ttenbergen 16:10, 2016 September 19 (CDT) | ||
* added control for [[GCS sedated field]] to [[Patient viewer]] apache tab Ttenbergen 16:28, 2016 September 19 (CDT) | * added control for [[GCS sedated field]] to [[Patient viewer]] apache tab Ttenbergen 16:28, 2016 September 19 (CDT) | ||
* added control for | * added control for ''Accept DtTm missing field'' to [[Patient viewer]] dispo tab Ttenbergen 16:28, 2016 September 19 (CDT) | ||
* fixed some labels in [[Patient viewer]] that were not yet URLS to link to corresponding articles. Ttenbergen 16:54, 2016 September 19 (CDT) | * fixed some labels in [[Patient viewer]] that were not yet URLS to link to corresponding articles. Ttenbergen 16:54, 2016 September 19 (CDT) | ||
| Line 241: | Line 241: | ||
===2016-Sep-15-2=== | ===2016-Sep-15-2=== | ||
rolled out Ttenbergen 17:31, 2016 September 15 (CDT) | rolled out Ttenbergen 17:31, 2016 September 15 (CDT) | ||
* added field "order" to [[ | * added field "order" to [[s_tmp table]] table | ||
* updated form Viewer and form TmpV2_editor to use the new order field | * updated form Viewer and form TmpV2_editor to use the new order field | ||
* added fields for [[CRRT]] to [[s_tmp]] table | * added fields for [[CRRT]] to [[s_tmp table]] table | ||
===2016-Sep-15=== | ===2016-Sep-15=== | ||
| Line 251: | Line 251: | ||
===2016-Sep-14=== | ===2016-Sep-14=== | ||
rolled out Ttenbergen 17:35, 2016 September 14 (CDT) | rolled out Ttenbergen 17:35, 2016 September 14 (CDT) | ||
* added numbers to the [[s_Priorities]] | * added numbers to the [[s_Priorities table]] (11-20)) - this means '''there will be more numbers available in the diagnosis and acquired priority now'''. | ||
* added some "unknown" subchoices to [[s_dispo table]] as per email from Julie Ttenbergen 17:35, 2016 September 14 (CDT) | * added some "unknown" subchoices to [[s_dispo table]] as per email from Julie Ttenbergen 17:35, 2016 September 14 (CDT) | ||
| Line 276: | Line 276: | ||
=== 2016-Aug-31 === | === 2016-Aug-31 === | ||
rolled out - Ttenbergen 10:16, 2016 August 31 (CDT) | rolled out - Ttenbergen 10:16, 2016 August 31 (CDT) | ||
* updated [[s_tmp table]] for [[ACP Status | * updated [[s_tmp table]] for [[ACP Status Collection in ICU]] to have a "not documented" line for both status and source Ttenbergen 09:58, 2016 August 31 (CDT) | ||
=== 2016-Aug-29-2 === | === 2016-Aug-29-2 === | ||
| Line 282: | Line 282: | ||
* added query ''2016-08-29_off_ward_fixer'' to run once and move content of pharm_complete field into off-ward field; this is to fix aftermath of the off-ward control being linked to pharm_complete field. Ttenbergen 15:08, 2016 August 29 (CDT) | * added query ''2016-08-29_off_ward_fixer'' to run once and move content of pharm_complete field into off-ward field; this is to fix aftermath of the off-ward control being linked to pharm_complete field. Ttenbergen 15:08, 2016 August 29 (CDT) | ||
** added to form_open event for main_form. Ttenbergen 15:08, 2016 August 29 (CDT) | ** added to form_open event for main_form. Ttenbergen 15:08, 2016 August 29 (CDT) | ||
* [[ACP Status | * [[ACP Status Collection in ICU]] | ||
** confirmed that [[ACP_Status_collection_in_ICU#pairs_of_records]] works Ttenbergen 14:38, 2016 August 29 (CDT) | ** confirmed that [[ACP_Status_collection_in_ICU#pairs_of_records]] works Ttenbergen 14:38, 2016 August 29 (CDT) | ||
** updated query ''s_tmp_ACP'' to list missing int or date. Ttenbergen 14:59, 2016 August 29 (CDT) | ** updated query ''s_tmp_ACP'' to list missing int or date. Ttenbergen 14:59, 2016 August 29 (CDT) | ||
| Line 312: | Line 312: | ||
=== 2016-Aug-18 === | === 2016-Aug-18 === | ||
rolled out Ttenbergen 16:23, 2016 August 18 (CDT) | rolled out Ttenbergen 16:23, 2016 August 18 (CDT) | ||
* inactivated old entries in [[ | * inactivated old entries in [[s_tmp table]] table: | ||
** PostalCode - old [[Postal code collection]], now collected in [[Postal Code field]] | ** PostalCode - old [[Postal code collection]], now collected in [[Postal Code field]] | ||
** Srv to ICU - old [[Service Sending to ICU]], now collected in [[Previous Service field]] | ** Srv to ICU - old [[Service Sending to ICU]], now collected in [[Previous Service field]] | ||
| Line 369: | Line 369: | ||
=== 2016-Jul-11 === | === 2016-Jul-11 === | ||
rolled Ttenbergen 17:59, 2016 July 11 (CDT) | rolled Ttenbergen 17:59, 2016 July 11 (CDT) | ||
* added [[ACCU borrow]] entries to [[ | * added [[ACCU borrow]] entries to [[s_tmp table]] table Ttenbergen 17:50, 2016 July 11 (CDT) | ||
* added STB_5b_x to [[s_dispo table]] Ttenbergen 17:59, 2016 July 11 (CDT) | * added STB_5b_x to [[s_dispo table]] Ttenbergen 17:59, 2016 July 11 (CDT) | ||
| Line 399: | Line 399: | ||
* removed sub dispo_yellower, integrated content with Sub Reg_Yellower() instead, there had been duplication. Ttenbergen 10:24, 2016 July 5 (CDT) | * removed sub dispo_yellower, integrated content with Sub Reg_Yellower() instead, there had been duplication. Ttenbergen 10:24, 2016 July 5 (CDT) | ||
* updated [[Function Dispo Chronological()]] to make accept/arrive checks same for Med and ICU Ttenbergen 10:24, 2016 July 5 (CDT) | * updated [[Function Dispo Chronological()]] to make accept/arrive checks same for Med and ICU Ttenbergen 10:24, 2016 July 5 (CDT) | ||
* updated form_view to show on top | * updated form_view to show on top "Arrive DtTm" instead of admit, and [[Dispo_DtTm]] instead of discharge Ttenbergen 10:37, 2016 July 5 (CDT) | ||
=== 2016-Jul-05 === | === 2016-Jul-05 === | ||
| Line 446: | Line 446: | ||
** query ''s_tmp_ER_Wait_from_ER_no_ER_Wait'' | ** query ''s_tmp_ER_Wait_from_ER_no_ER_Wait'' | ||
** query ''s_tmp_ER_Wait_has_tmp_not_from_ER'' | ** query ''s_tmp_ER_Wait_has_tmp_not_from_ER'' | ||
** query | ** [[query s_tmp_QAInf_LT_48_hrs_after_admit]] | ||
** query ''s_tmp_Service_Sending_to_ICU'' | ** query ''s_tmp_Service_Sending_to_ICU'' | ||
| Line 499: | Line 499: | ||
** include both [[Panelling or Discharge Planning]] codes (90601, 90601) | ** include both [[Panelling or Discharge Planning]] codes (90601, 90601) | ||
* updated [[Off ward field]], it was set to invisible | * updated [[Off ward field]], it was set to invisible | ||
* updated checks for | * updated checks for ''Accept DtTm field''; the field is now required only if the pt came from ER | ||
Updating to ignore patients with [[Dispo DtTm]] after 2016-07-01 | Updating to ignore patients with [[Dispo DtTm]] after 2016-07-01 | ||
| Line 524: | Line 524: | ||
=== 2016-Jun-20 === | === 2016-Jun-20 === | ||
rolled outTtenbergen 10:35, 2016 June 20 (CDT) | rolled outTtenbergen 10:35, 2016 June 20 (CDT) | ||
* updated [[Query | * updated [[Query Check_Renal_IncompatibleDxs]] which was giving false errors for patients with CRF and certain renal dxs. Ttenbergen 09:56, 2016 June 20 (CDT) | ||
=== 2016-Jun-16 === | === 2016-Jun-16 === | ||
| Line 538: | Line 538: | ||
* dispo cross check | * dispo cross check | ||
** cross check to make sure that patients with [[Previous Location field]] critical care have [[Previous Service field]] critical care, and patients from medicine have previous service medicine; [[query check_previous_location_vs_service_inconsistent]] and function ''previous_location_vs_service_inconsistent'' Ttenbergen 13:53, 2016 June 13 (CDT) | ** [[cross check]] to make sure that patients with [[Previous Location field]] critical care have [[Previous Service field]] critical care, and patients from medicine have previous service medicine; [[query check_previous_location_vs_service_inconsistent]] and function ''previous_location_vs_service_inconsistent'' Ttenbergen 13:53, 2016 June 13 (CDT) | ||
* changed timing of call to function Transfer_Ready_DtTm_vs_Location_vs_Dispo so it isn't a gopher triplet; should only be called once now. Ttenbergen 09:43, 2016 June 13 (CDT) | * changed timing of call to function Transfer_Ready_DtTm_vs_Location_vs_Dispo so it isn't a gopher triplet; should only be called once now. Ttenbergen 09:43, 2016 June 13 (CDT) | ||
| Line 573: | Line 573: | ||
=== 2016-Jun-06 === | === 2016-Jun-06 === | ||
rolled Ttenbergen 16:46, 2016 June 6 (CDT) | rolled Ttenbergen 16:46, 2016 June 6 (CDT) | ||
* changed tmp tab to help organize [[ACP Status | * changed tmp tab to help organize [[ACP Status Collection in ICU]]: sort by integer first, before sorting by other fields. This would become messy if we use the integer for something else in the future but should work nice for now. Ttenbergen 10:28, 2016 June 6 (CDT) | ||
* added check to ensure paired records for [[ACP Status | * added check to ensure paired records for [[ACP Status Collection in ICU]]. Ttenbergen 10:50, 2016 June 6 (CDT) | ||
* added button to make [[Previous Location field]] equal to [[Pre-admit Inpatient Institution field]]. Ttenbergen 11:57, 2016 June 6 (CDT) | * added button to make [[Previous Location field]] equal to [[Pre-admit Inpatient Institution field]]. Ttenbergen 11:57, 2016 June 6 (CDT) | ||
* added query ''check_dispo_lower_acuity_than_location'' and Function ''Transfer_Ready_DtTm_vs_Location_vs_Dispo'' to cross check for allowed missing [[Transfer_Ready_DtTm_field]] but to launch question window if missing Ttenbergen 14:13, 2016 June 6 (CDT) | * added query ''check_dispo_lower_acuity_than_location'' and Function ''Transfer_Ready_DtTm_vs_Location_vs_Dispo'' to [[cross check]] for allowed missing [[Transfer_Ready_DtTm_field]] but to launch question window if missing Ttenbergen 14:13, 2016 June 6 (CDT) | ||
=== 2016-Jun-02 === | === 2016-Jun-02 === | ||
| Line 582: | Line 582: | ||
* changed GRA_W3 to GRA_S3 to table ''s_tmp_er_wait_r_locations'' Ttenbergen 09:51, 2016 June 2 (CDT) | * changed GRA_W3 to GRA_S3 to table ''s_tmp_er_wait_r_locations'' Ttenbergen 09:51, 2016 June 2 (CDT) | ||
* disabled check for [[Visit Admit DtTm field]] in ''Function Dispo_Chronological()''; the content of the field is direct copy from EPR so might be inconsistent with actual arrival and/or accept times Ttenbergen 09:56, 2016 June 2 (CDT) | * disabled check for [[Visit Admit DtTm field]] in ''Function Dispo_Chronological()''; the content of the field is direct copy from EPR so might be inconsistent with actual arrival and/or accept times Ttenbergen 09:56, 2016 June 2 (CDT) | ||
* apostrophe | * [[Query s tmp apostrophe in comment]] was not giving proper error message, does now. Ttenbergen 10:05, 2016 June 2 (CDT) | ||
* confirmed that all ERs are '''not available''' in dropdown for [[Dispo field]]. Ttenbergen 11:14, 2016 June 2 (CDT) | * confirmed that all ERs are '''not available''' in dropdown for [[Dispo field]]. Ttenbergen 11:14, 2016 June 2 (CDT) | ||
* updated query ''Send_Centralized_1L_Log_update'', which was not updating [[Dispo_DtTm field]] properly Ttenbergen 13:48, 2016 June 2 (CDT) | * updated query ''Send_Centralized_1L_Log_update'', which was not updating [[Dispo_DtTm field]] properly Ttenbergen 13:48, 2016 June 2 (CDT) | ||
| Line 603: | Line 603: | ||
** s_varOptions added | ** s_varOptions added | ||
* updated s_dispo table to cope with workload shared locations; removed the _a locations from previous inpatient location dropdown. Ttenbergen 09:55, 2016 May 26 (CDT) | * updated s_dispo table to cope with workload shared locations; removed the _a locations from previous inpatient location dropdown. Ttenbergen 09:55, 2016 May 26 (CDT) | ||
* internal cross check review | * internal [[cross check]] review | ||
** made Dispo_Yellower use same method as View_Yellower. Ttenbergen 10:18, 2016 May 26 (CDT) | ** made Dispo_Yellower use same method as View_Yellower. Ttenbergen 10:18, 2016 May 26 (CDT) | ||
** changed ADL_Yellower to use same method as View_Yellower. Ttenbergen 10:18, 2016 May 26 (CDT) | ** changed ADL_Yellower to use same method as View_Yellower. Ttenbergen 10:18, 2016 May 26 (CDT) | ||
| Line 626: | Line 626: | ||
=== 2016-May-19 === | === 2016-May-19 === | ||
rolled out Ttenbergen 14:37, 2016 May 19 (CDT) | rolled out Ttenbergen 14:37, 2016 May 19 (CDT) | ||
* updated the [[ACP Status | * updated the [[ACP Status Collection in ICU]] entry for Orders so that only the "enter" one is automatically populated. Ttenbergen 10:28, 2016 May 19 (CDT) | ||
* added OR and RR to out-of-town s_dispo entries Ttenbergen 11:04, 2016 May 19 (CDT) | * added OR and RR to out-of-town s_dispo entries Ttenbergen 11:04, 2016 May 19 (CDT) | ||
* removed "?" button from [[Service/Location field]], since it will only be allowed local entries, so list will be short Ttenbergen 11:04, 2016 May 19 (CDT) | * removed "?" button from [[Service/Location field]], since it will only be allowed local entries, so list will be short Ttenbergen 11:04, 2016 May 19 (CDT) | ||
| Line 646: | Line 646: | ||
rolled Ttenbergen 17:38, 2016 May 9 (CDT) | rolled Ttenbergen 17:38, 2016 May 9 (CDT) | ||
* added location to [[MR List]] Ttenbergen 10:39, 2016 May 9 (CDT) | * added location to [[MR List]] Ttenbergen 10:39, 2016 May 9 (CDT) | ||
* [[ACP Status | * [[ACP Status Collection in ICU]]: | ||
** updated query ''s_tmp_ACP'' to only trigger if | ** updated query ''s_tmp_ACP'' to only trigger if ''Arrive DtTm field'' >= 2016-05-01 | ||
** made the old options with begin and end unavailable Ttenbergen 14:10, 2016 May 9 (CDT) | ** made the old options with begin and end unavailable Ttenbergen 14:10, 2016 May 9 (CDT) | ||
| Line 656: | Line 656: | ||
=== 2016-May-05 === | === 2016-May-05 === | ||
rolled out Ttenbergen 17:19, 2016 May 5 (CDT) | rolled out Ttenbergen 17:19, 2016 May 5 (CDT) | ||
* adding cross | * adding [[cross check]]s for [[2016 Time and Place changes]] Ttenbergen 15:12, 2016 May 5 (CDT) | ||
** made fields mandatory not empty to check registry checkbox complete Ttenbergen 15:12, 2016 May 5 (CDT) | ** made fields mandatory not empty to check registry checkbox complete Ttenbergen 15:12, 2016 May 5 (CDT) | ||
** made ''Transfer_Ready_DtTm_vs_status()'' to check [[Transfer Ready DtTm field]] against [[TR info status field]] Ttenbergen 15:12, 2016 May 5 (CDT) | ** made ''Transfer_Ready_DtTm_vs_status()'' to check [[Transfer Ready DtTm field]] against [[TR info status field]] Ttenbergen 15:12, 2016 May 5 (CDT) | ||
| Line 674: | Line 674: | ||
** "direct admit" taken out, the new structure does not need it Ttenbergen 10:47, 2016 May 3 (CDT) | ** "direct admit" taken out, the new structure does not need it Ttenbergen 10:47, 2016 May 3 (CDT) | ||
** added "Neurology" and "Oncology" | ** added "Neurology" and "Oncology" | ||
* added fields for [[ACP Status | * added fields for [[ACP Status Collection in ICU]] Ttenbergen 12:11, 2016 May 3 (CDT) | ||
=== 2016-Apr-25 === | === 2016-Apr-25 === | ||
| Line 702: | Line 702: | ||
* Added "N/A" button for [[Postal Code field]] Ttenbergen 16:31, 2016 April 18 (CDT) | * Added "N/A" button for [[Postal Code field]] Ttenbergen 16:31, 2016 April 18 (CDT) | ||
* changed "left AMA" to "AMA (left against medical advice)" so it pops up if collector starts typing "AMA" Ttenbergen 16:31, 2016 April 18 (CDT) | * changed "left AMA" to "AMA (left against medical advice)" so it pops up if collector starts typing "AMA" Ttenbergen 16:31, 2016 April 18 (CDT) | ||
* added filter to fields in | * added filter to fields in "S dispo chooser" to only show the entries actually allowed for the field that started the form (e.g. no "died" in previous location) Ttenbergen 18:28, 2016 April 18 (CDT) | ||
* updated sub ''Convert_DB()'' to download [[CCMDB_data.mdb_Change_Log#2016-04-18]] Ttenbergen 18:48, 2016 April 18 (CDT) | * updated sub ''Convert_DB()'' to download [[CCMDB_data.mdb_Change_Log#2016-04-18]] Ttenbergen 18:48, 2016 April 18 (CDT) | ||
* added [[Visit Admit DtTm field]] in dispo tab Ttenbergen 19:02, 2016 April 18 (CDT) | * added [[Visit Admit DtTm field]] in dispo tab Ttenbergen 19:02, 2016 April 18 (CDT) | ||
| Line 718: | Line 718: | ||
* changed hover-overs for these buttons to say "open filter wizard" Ttenbergen 14:57, 2016 April 13 (CDT) | * changed hover-overs for these buttons to say "open filter wizard" Ttenbergen 14:57, 2016 April 13 (CDT) | ||
* added hints to [[Dispo field]]: died and AMA Ttenbergen 14:57, 2016 April 13 (CDT) | * added hints to [[Dispo field]]: died and AMA Ttenbergen 14:57, 2016 April 13 (CDT) | ||
* added button to set | * added button to set ''Accept_DtTm field'' to ''Arrive_DtTm field'' for convenience since they are often the same. Ttenbergen 15:46, 2016 April 13 (CDT) | ||
* updated validation for DOB, it would not error properly when empty in some circumstances. Ttenbergen 15:59, 2016 April 13 (CDT) | * updated validation for DOB, it would not error properly when empty in some circumstances. Ttenbergen 15:59, 2016 April 13 (CDT) | ||
| Line 737: | Line 737: | ||
* fixed +/- buttons for [[Dispo DtTm field]] - thanks Con for flagging! Ttenbergen 12:19, 2016 April 7 (CDT) | * fixed +/- buttons for [[Dispo DtTm field]] - thanks Con for flagging! Ttenbergen 12:19, 2016 April 7 (CDT) | ||
* updated input mask for [[Transfer Ready DtTm field]], it wasn't allowing typed entry - thanks Con for flagging! Ttenbergen 12:19, 2016 April 7 (CDT) | * updated input mask for [[Transfer Ready DtTm field]], it wasn't allowing typed entry - thanks Con for flagging! Ttenbergen 12:19, 2016 April 7 (CDT) | ||
* There are still | * There are still ''Accept_DtTm_field#editing_difficulties | editing difficulties'' - see there for details on a new thing to try. Ttenbergen 12:19, 2016 April 7 (CDT) | ||
=== 2016-Apr-05 === | === 2016-Apr-05 === | ||
| Line 750: | Line 750: | ||
** '''Collectors: I have disabled the "x" button for this form, you will now have to use either the close with or without changes buttons.''' Ttenbergen 14:56, 2016 April 4 (CDT) | ** '''Collectors: I have disabled the "x" button for this form, you will now have to use either the close with or without changes buttons.''' Ttenbergen 14:56, 2016 April 4 (CDT) | ||
* some additional clean-up in patient viewer module that should have no impact, just cleaned out dead code Ttenbergen 13:24, 2016 April 4 (CDT) | * some additional clean-up in patient viewer module that should have no impact, just cleaned out dead code Ttenbergen 13:24, 2016 April 4 (CDT) | ||
* ''' | * '''Accept_DtTm_field#editing_difficulties | date/time fields in 2016 Time and Place changes''' - changed so they should be properly editable now, please see article, try and let me know how goes in the article at the link Ttenbergen 14:56, 2016 April 4 (CDT) | ||
=== 2016-Apr-04 === | === 2016-Apr-04 === | ||
rolled Ttenbergen 12:00, 2016 April 4 (CDT) | rolled Ttenbergen 12:00, 2016 April 4 (CDT) | ||
* added option "CICU" for [[CCU Service Tracking]], see change in collection instruction on that page - Ttenbergen 11:41, 2016 April 4 (CDT) | * added option "CICU" for [[CCU Service Tracking]], see change in collection instruction on that page - Ttenbergen 11:41, 2016 April 4 (CDT) | ||
** added option to [[s_tmp]] table - Ttenbergen 11:41, 2016 April 4 (CDT) | ** added option to [[s_tmp table]] table - Ttenbergen 11:41, 2016 April 4 (CDT) | ||
** updated query ''s_tmp_CCU_Service_shouldntve'' to allow STB_CICU to enter - Ttenbergen 11:41, 2016 April 4 (CDT) | ** updated query ''s_tmp_CCU_Service_shouldntve'' to allow STB_CICU to enter - Ttenbergen 11:41, 2016 April 4 (CDT) | ||
| Line 761: | Line 761: | ||
rolled Ttenbergen 11:45, 2016 March 31 (CDT) | rolled Ttenbergen 11:45, 2016 March 31 (CDT) | ||
* made "home" available in [[s_dispo table]], it had unintentionally become inactive Ttenbergen 11:16, 2016 March 31 (CDT) | * made "home" available in [[s_dispo table]], it had unintentionally become inactive Ttenbergen 11:16, 2016 March 31 (CDT) | ||
* [[Project_ABO_TEE#CCDMB_Data_Integrity_Checks]] - updated cross check to only trigger when [[RecordStatus]] complete Ttenbergen 11:16, 2016 March 31 (CDT) | * [[Project_ABO_TEE#CCDMB_Data_Integrity_Checks]] - updated [[cross check]] to only trigger when [[RecordStatus]] complete Ttenbergen 11:16, 2016 March 31 (CDT) | ||
=== 2016-Mar-24 === | === 2016-Mar-24 === | ||
rolled Ttenbergen 19:35, 2016 March 25 (CDT) | rolled Ttenbergen 19:35, 2016 March 25 (CDT) | ||
''' before rolling, fix db converter break''' | ''' before rolling, fix db converter break''' | ||
* [[Alias ID collection]] - added required entry to [[s_tmp]] table | * [[Alias ID collection]] - added required entry to [[s_tmp table]] table | ||
* more [[2016 Time and Place changes]] | * more [[2016 Time and Place changes]] | ||
** '''changed the labels for all the fields on the dispo tab to hyperlinks to the wiki, ie you can click the label and it will take you to the article about the field''' Ttenbergen 20:39, 2016 March 24 (CDT) | ** '''changed the labels for all the fields on the dispo tab to hyperlinks to the wiki, ie you can click the label and it will take you to the article about the field''' Ttenbergen 20:39, 2016 March 24 (CDT) | ||
| Line 775: | Line 775: | ||
** updated [[s_dispo table]] table so [[Previous Location field]] can now contain ERs from rural Manitoba Ttenbergen 20:46, 2016 March 24 (CDT) | ** updated [[s_dispo table]] table so [[Previous Location field]] can now contain ERs from rural Manitoba Ttenbergen 20:46, 2016 March 24 (CDT) | ||
** made label for [[LastOpened DtTm field]] into link to wiki Ttenbergen 21:10, 2016 March 24 (CDT) | ** made label for [[LastOpened DtTm field]] into link to wiki Ttenbergen 21:10, 2016 March 24 (CDT) | ||
** added button to open | ** added button to open "S dispo chooser" to [[Pre-admit Inpatient Institution field]] button, had missed that on first round Ttenbergen 21:46, 2016 March 24 (CDT) | ||
* [[Project ABO TEE]] cross | * [[Project ABO TEE]] [[cross check]]s: reviewed query ''s_tmp_ABO_TEE_checks'' | ||
* [[Medical Incompetency tracking]] - was still available to collect, made unavailable Ttenbergen 18:18, 2016 March 25 (CDT) | * [[Medical Incompetency tracking]] - was still available to collect, made unavailable Ttenbergen 18:18, 2016 March 25 (CDT) | ||
| Line 787: | Line 787: | ||
** reviewed ''[[s_previous_service table]]'' and linked into form Ttenbergen 11:35, 2016 March 21 (CDT) | ** reviewed ''[[s_previous_service table]]'' and linked into form Ttenbergen 11:35, 2016 March 21 (CDT) | ||
** reviewed ''[[s_dispo table]]'' and link into forms Ttenbergen 13:42, 2016 March 22 (CDT) | ** reviewed ''[[s_dispo table]]'' and link into forms Ttenbergen 13:42, 2016 March 22 (CDT) | ||
** updated form | ** updated form "s_dispo chooser" and how it is triggered from form [[Patient viewer]] Ttenbergen 13:42, 2016 March 22 (CDT) | ||
* added "Nephrology" and "unknown" to [[S_previous_service_table]] and [[s_tmp]] for [[Service Sending to ICU]] Ttenbergen 17:21, 2016 March 21 (CDT) | * added "Nephrology" and "unknown" to [[S_previous_service_table]] and [[s_tmp table]] for [[Service Sending to ICU]] Ttenbergen 17:21, 2016 March 21 (CDT) | ||
=== 2016-Mar-16 === | === 2016-Mar-16 === | ||
| Line 842: | Line 842: | ||
* addressing [[:Category:Unusually coded infections]]: | * addressing [[:Category:Unusually coded infections]]: | ||
** making c-diff pathogen unavailable for coding | ** making c-diff pathogen unavailable for coding | ||
*** added "active" column to [[ | *** added "active" column to [[S_Pathogens table]] Ttenbergen 14:43, 2016 February 8 (CST) | ||
*** made all except [[Clostridium difficile]] active Ttenbergen 14:43, 2016 February 8 (CST) | *** made all except [[Clostridium difficile]] active Ttenbergen 14:43, 2016 February 8 (CST) | ||
*** updated the dropdown in the patient view, diagnosis tab, to list only active pathogens Ttenbergen 14:43, 2016 February 8 (CST) | *** updated the dropdown in the patient view, diagnosis tab, to list only active pathogens Ttenbergen 14:43, 2016 February 8 (CST) | ||
| Line 870: | Line 870: | ||
* corrected query ''s_tmp_ER_Wait_long_delay'' for [[ER Wait]], it was not detecting anything. '''Collectors will have to put a comment in tmp if the delay is > 3 days.''' The error msg will remind them about this. Ttenbergen 17:19, 2016 January 11 (CST) | * corrected query ''s_tmp_ER_Wait_long_delay'' for [[ER Wait]], it was not detecting anything. '''Collectors will have to put a comment in tmp if the delay is > 3 days.''' The error msg will remind them about this. Ttenbergen 17:19, 2016 January 11 (CST) | ||
* added query '''s_tmp_ER_Wait_duplicate_entry''' - doesn't allow more than one [[ER Wait]] entry. Ttenbergen 22:02, 2016 January 11 (CST) | * added query '''s_tmp_ER_Wait_duplicate_entry''' - doesn't allow more than one [[ER Wait]] entry. Ttenbergen 22:02, 2016 January 11 (CST) | ||
*both | *both HSC_ICUd and HSC_ICUa laptops accepted the change - Lori | ||
=== 2016-Jan-06 === | === 2016-Jan-06 === | ||
| Line 876: | Line 876: | ||
* updated form dxChooser to exclude dxs with collection_allowed = false Ttenbergen 13:17, 2016 January 6 (CST) | * updated form dxChooser to exclude dxs with collection_allowed = false Ttenbergen 13:17, 2016 January 6 (CST) | ||
[[Category: CCMDB. | [[Category:CCMDB.accdb]] | ||
[[Category: Change Logs CCMDB]] | [[Category:Change Logs CCMDB]] | ||