CCMDB.mdb Change Log 2018: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "cross check " to "cross check " |
||
| Line 179: | Line 179: | ||
* '''changed [[Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days]] | * '''changed [[Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days]] | ||
behind the scenes or minor changes | behind the scenes or minor changes | ||
* tweaked wording of the error message given when a cross check finds an error. | * tweaked wording of the error message given when a [[cross check]] finds an error. | ||
* tweaked the size of the patient viewer form so it fits on a laptop screen without scrolling | * tweaked the size of the patient viewer form so it fits on a laptop screen without scrolling | ||
| Line 368: | Line 368: | ||
** added [[IICU consult]] to [[s_tmp table]] | ** added [[IICU consult]] to [[s_tmp table]] | ||
** added [[Query check_CCI_CRRT_vs_Tmp]] - '''you will need to start entering CCI entries for all CRRT patients''' | ** added [[Query check_CCI_CRRT_vs_Tmp]] - '''you will need to start entering CCI entries for all CRRT patients''' | ||
** added "Query s tmp QASeptic Dx no tmp", [[Query s tmp QASeptic tmp no dx]] checks for ICD10; '''[[QA Septic Shock]] will now also cross check against ICD10 diagnoses''' | ** added "Query s tmp QASeptic Dx no tmp", [[Query s tmp QASeptic tmp no dx]] checks for ICD10; '''[[QA Septic Shock]] will now also [[cross check]] against ICD10 diagnoses''' | ||
** added [[Query check_cooling_vs_arrest]] - you can only use [[Targeted Temperature Management (TTM)]] if you have a [[Cardiac arrest]] dx in ICD10 | ** added [[Query check_cooling_vs_arrest]] - you can only use [[Targeted Temperature Management (TTM)]] if you have a [[Cardiac arrest]] dx in ICD10 | ||
** added [[Query check_AIDS_vs_HIV]] - can't code [[HIV infection, asymptomatic]] and [[AIDS (disease due to HIV)]] for same record | ** added [[Query check_AIDS_vs_HIV]] - can't code [[HIV infection, asymptomatic]] and [[AIDS (disease due to HIV)]] for same record | ||
| Line 538: | Line 538: | ||
* in [[S_CCI_1 table]], changed "(T) Ventricle" to [[(T) Cardiac ventricle]] | * in [[S_CCI_1 table]], changed "(T) Ventricle" to [[(T) Cardiac ventricle]] | ||
* in [[S_CCI_Picklist table]], added [[Tracheostomy creation]] | * in [[S_CCI_Picklist table]], added [[Tracheostomy creation]] | ||
* confirmed that [[Postal_Code_field]] cross check doesn't allow lowercase | * confirmed that [[Postal_Code_field]] [[cross check]] doesn't allow lowercase | ||
* actually deleted query ''deleted query check_OR_from_but_not_Surgical_Type''; had logged this as done in [[#2018-05-09]] but evidently never did then. Ttenbergen 10:50, 2018 September 20 (CDT) | * actually deleted query ''deleted query check_OR_from_but_not_Surgical_Type''; had logged this as done in [[#2018-05-09]] but evidently never did then. Ttenbergen 10:50, 2018 September 20 (CDT) | ||
* fixed [[Patient List]] sorting by [[Chart number]]; ages ago that field was called "chart#" and it seems the buttons have been broken ever since that was changed. Ttenbergen 15:35, 2018 September 21 (CDT) | * fixed [[Patient List]] sorting by [[Chart number]]; ages ago that field was called "chart#" and it seems the buttons have been broken ever since that was changed. Ttenbergen 15:35, 2018 September 21 (CDT) | ||
| Line 919: | Line 919: | ||
==== 2018-02-02 (mis-dated) ==== | ==== 2018-02-02 (mis-dated) ==== | ||
had been rolled out... Ttenbergen 13:54, 2018 January 30 (CST) | had been rolled out... Ttenbergen 13:54, 2018 January 30 (CST) | ||
* fixes to cross check for [[Accept Loc Park]]; include [[Pre-admit Inpatient Institution]] = "NA / not applicable": | * fixes to [[cross check]] for [[Accept Loc Park]]; include [[Pre-admit Inpatient Institution]] = "NA / not applicable": | ||
** query ''s_tmp_Accept_Log_Park_prev_no_tmp'' | ** query ''s_tmp_Accept_Log_Park_prev_no_tmp'' | ||
** query ''s_tmp_Accept_Log_Park_tmp_no_prev'' | ** query ''s_tmp_Accept_Log_Park_tmp_no_prev'' | ||
| Line 972: | Line 972: | ||
* removed [[Angio coronary field]] and [[Angio others field]] from labs tab in patient viewer Ttenbergen 17:01, 2017 December 28 (CST) | * removed [[Angio coronary field]] and [[Angio others field]] from labs tab in patient viewer Ttenbergen 17:01, 2017 December 28 (CST) | ||
* updated the pick button in [[ICD10 Chooser form]] to no longer requery the [[L ICD10 subform]] as this was resorting the dxs and collectors then had to find the one they had just entered to finish the entry. Ttenbergen 18:44, 2017 December 28 (CST) | * updated the pick button in [[ICD10 Chooser form]] to no longer requery the [[L ICD10 subform]] as this was resorting the dxs and collectors then had to find the one they had just entered to finish the entry. Ttenbergen 18:44, 2017 December 28 (CST) | ||
* [[ACCU borrow]] - fix to cross check query ''s_tmp_ACCU_Borrow_chronicity_hard''; was using obsdate and obstime, when it should have used date_var and time_var. Ttenbergen 13:13, 2018 January 4 (CST) | * [[ACCU borrow]] - fix to [[cross check]] query ''s_tmp_ACCU_Borrow_chronicity_hard''; was using obsdate and obstime, when it should have used date_var and time_var. Ttenbergen 13:13, 2018 January 4 (CST) | ||
[[Category:CCMDB.accdb]] | [[Category:CCMDB.accdb]] | ||
[[Category: Change Logs CCMDB]] | [[Category: Change Logs CCMDB]] | ||