CCMDB.mdb Change Log 2016: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "S_Tmp" to "s_tmp table" |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (6 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 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=== | ||
| Line 169: | Line 169: | ||
** checked Function from_ER() | ** checked Function from_ER() | ||
** updated [[Query check_pt_from_ER]] to only trigger for own ER Ttenbergen 11:37, 2016 October 20 (CDT) | ** 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) | ||
| 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 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 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 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 ''Arrive DtTm field'' >= 2016-05-01 | ** 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 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 === | ||
| Line 777: | Line 777: | ||
** 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) | ** 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 877: | Line 877: | ||
[[Category:CCMDB.accdb]] | [[Category:CCMDB.accdb]] | ||
[[Category: Change Logs CCMDB]] | [[Category:Change Logs CCMDB]] | ||