CCMDB.mdb Change Log 2018: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "Check Inf Pathogens must have Infection requiring pathogen or Potential Infection" to "query Check_Inf_Pathogens_must_have_Infection_requiring_pathogen_or_Potential_Infection" |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 36: | Line 36: | ||
** added "precedence" field to [[s_ICD10_Charlson_Como_conditions table]] | ** added "precedence" field to [[s_ICD10_Charlson_Como_conditions table]] | ||
* updated [[Overstay Predictor Project Algorithm]] | * updated [[Overstay Predictor Project Algorithm]] | ||
* updated Function include_pt() that had previously only included D_IDs ending in 8 in CCI/ICD10 cross | * updated Function include_pt() that had previously only included D_IDs ending in 8 in CCI/ICD10 [[cross check]]s | ||
* re-imported [[CCI Categories for CCMDB.accdb]] and [[ICD10 Categories for CCMDB.accdb]] | * re-imported [[CCI Categories for CCMDB.accdb]] and [[ICD10 Categories for CCMDB.accdb]] | ||
| Line 92: | Line 92: | ||
rolled out Ttenbergen 10:23, 2018 December 4 (CST) | rolled out Ttenbergen 10:23, 2018 December 4 (CST) | ||
* '''reduce the number of times that the ER Delay error shows up ''' | * '''reduce the number of times that the ER Delay error shows up ''' | ||
** moved the call for | ** moved the call for "Query check_ER_Delay_not_too_big" from Function Dispo_Chronological to Function Validate_Accept_DtTm. | ||
==== 2018-12-02 ==== | ==== 2018-12-02 ==== | ||
| 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 432: | Line 432: | ||
** "Coronary angiogram (diagnostic cardiac catherization)" --> [[Angiogram, coronary (diagnostic cardiac catheterization)]] | ** "Coronary angiogram (diagnostic cardiac catherization)" --> [[Angiogram, coronary (diagnostic cardiac catheterization)]] | ||
* updated Sub Legacy_Hider() to properly hide the wiki links for ADLs for Critical Care patients. Ttenbergen 23:34, 2018 October 24 (CDT) | * updated Sub Legacy_Hider() to properly hide the wiki links for ADLs for Critical Care patients. Ttenbergen 23:34, 2018 October 24 (CDT) | ||
* tweaked cross | * tweaked [[cross check]]s that run when closing the [[Notes field]], which had been giving an error if the [[WBC]] field was empty Ttenbergen 23:52, 2018 October 24 (CDT) | ||
* fixed [[Query check dx primary lowest priority]], it was checking for lowest priority over all dxs, not just admit dxs Ttenbergen 09:33, 2018 October 25 (CDT) | * fixed [[Query check dx primary lowest priority]], it was checking for lowest priority over all dxs, not just admit dxs Ttenbergen 09:33, 2018 October 25 (CDT) | ||
| Line 458: | Line 458: | ||
rolled out Ttenbergen 18:24, 2018 October 14 (CDT) | rolled out Ttenbergen 18:24, 2018 October 14 (CDT) | ||
* '''relevant to collectors: ''' | * '''relevant to collectors: ''' | ||
** implemented CCI cross | ** implemented CCI [[cross check]]s: | ||
*** [[Query check CCI if no then none]] | *** [[Query check CCI if no then none]] | ||
*** [[Query check CCI component 1 and 2 compatible]] | *** [[Query check CCI component 1 and 2 compatible]] | ||
| Line 522: | Line 522: | ||
* [[CCMDB.accdb links to CCMDB wiki]] - edited the label for [[DOB]] to no longer be link, added little link icon to left of label. Please see and provide feedback at [[CCMDB.accdb links to CCMDB wiki]]. | * [[CCMDB.accdb links to CCMDB wiki]] - edited the label for [[DOB]] to no longer be link, added little link icon to left of label. Please see and provide feedback at [[CCMDB.accdb links to CCMDB wiki]]. | ||
* updated Function runQuery to generate an email with the relevant error rather than ask collectors to screen shoot and email. | * updated Function runQuery to generate an email with the relevant error rather than ask collectors to screen shoot and email. | ||
* removed [[No procedure performed]] from [[S_CCI_1 table]] because [[CCI Collection]] says to enter this from [[CCI Picklist]] - this will facilitate cross | * removed [[No procedure performed]] from [[S_CCI_1 table]] because [[CCI Collection]] says to enter this from [[CCI Picklist]] - this will facilitate [[cross check]]s | ||
* implemented checks and added to Sub Dx_Checker(): | * implemented checks and added to Sub Dx_Checker(): | ||
* [[Query check_dx_primary_lowest_priority]] | * [[Query check_dx_primary_lowest_priority]] | ||
| 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 902: | Line 902: | ||
**[[L CCI Picklist subform]] | **[[L CCI Picklist subform]] | ||
**[[L CCI Component subform]] | **[[L CCI Component subform]] | ||
* updated cross | * updated [[cross check]]s for [[ER_Delay]] | ||
** query ''check_ER_Delay_not_too_big'' | ** query ''check_ER_Delay_not_too_big'' | ||
** error msg in ''Function Dispo_Chronological()'' | ** error msg in ''Function Dispo_Chronological()'' | ||
| 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 928: | Line 928: | ||
* added for [[Accept Loc Park]]: | * added for [[Accept Loc Park]]: | ||
** nursing stations Ttenbergen 13:51, 2018 January 21 (CST) | ** nursing stations Ttenbergen 13:51, 2018 January 21 (CST) | ||
** added cross | ** added [[cross check]]s: | ||
*** 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 942: | Line 942: | ||
rolled out Ttenbergen 18:01, 2018 January 10 (CST) | rolled out Ttenbergen 18:01, 2018 January 10 (CST) | ||
* added "negative" for [[Influenza tracking]] | * added "negative" for [[Influenza tracking]] | ||
* Implemented as query check_ER_Delay_not_too_big.[[ER Delay]] | * Implemented as "query check_ER_Delay_not_too_big".[[ER Delay]] | ||
=== 2018-01-09 === | === 2018-01-09 === | ||
| 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]] | ||