CCMDB.accdb Change Log 2019: Difference between revisions
Ttenbergen (talk | contribs) m (→2019-01-14-1) |
Ttenbergen (talk | contribs) m (→2019-01-14-1) |
||
| Line 7: | Line 7: | ||
* '''fixed the chart number sort in [[Patient List]] - this will help when you try to troubleshoot duplicate patients. ''' | * '''fixed the chart number sort in [[Patient List]] - this will help when you try to troubleshoot duplicate patients. ''' | ||
* '''fixed false positive when there legitimately are no CCIs''' - update [[query check_CCI_if_no_then_none]] | * '''fixed false positive when there legitimately are no CCIs''' - update [[query check_CCI_if_no_then_none]] | ||
* tweaked the width of first and last name fields on [[Patient List]] further after additional request. | |||
==== 2019-01-14 ==== | ==== 2019-01-14 ==== | ||
Revision as of 11:18, 2019 January 15
See Log (disambiguation) for other uses of the term "Log". See the Development Documentation Category for other development logs. See Rolling out changes for the process of rolling out changes. See also requested CCMDB changes for the next version and CCMDB.mdb Data Integrity Checks.
Versions
2019-01-14-1
not rolled out yet Ttenbergen 19:15, 2019 January 14 (CST)
- fixed the chart number sort in Patient List - this will help when you try to troubleshoot duplicate patients.
- fixed false positive when there legitimately are no CCIs - update query check_CCI_if_no_then_none
- tweaked the width of first and last name fields on Patient List further after additional request.
2019-01-14
rolled out Ttenbergen 10:58, 2019 January 14 (CST) Changes collectors will want to know about
- fixed the links to the CCI Collection Mode in the L CCI Picklist subform
- made the name fields wider in the Patient List
2019-01-10-1
rolled out Ttenbergen 10:17, 2019 January 14 (CST) Changes collectors probably want to know about:
- fixed problem that required entry of comorbid dx for patients discharged before Jan 1 - deleted "query check_ICD10_has_comorbid" which was an evil twin of query check_ICD10_Comorbids_Dx_present
- upped the font size of ICD10s and CCIs back up, and instead made those tabs and subforms much taller so they can show better on the external screens at least. This may mean scrolling in your CCMDB.mdb. Let me know how it works and we can tweak it further. ' - changed frame sizes in Patient viewer.
- updated sort order for ICD10 tab to be Adm, acq, como on default, and when using magic wand button - updated L ICD10 subform
Changes collectors probably don't care about:
- added Query s_ICD10_Chapter_block_dxs
- added S_ICD10_Chapter_block_pattern table
- removed S_ICD10_Block_Dxs table
2019-01-10
rolled outTtenbergen 13:33, 2019 January 10 (CST) Things collectors will want to know:
- reimported the CCI / ICD10 categories to reflect our reduction of CCI collection, see CCI Collection Modes in CCI Picklist.
- changed fonts on CCI and ICD10 screen to keep fields small but make fonts bigger
- added lines back into ICD10 tab that had gone missing.
- tweaked Query check CCI must have entry to eliminate false-positive
2019-01-09
not rolled out yet Ttenbergen 10:06, 2019 January 9 (CST) Things collectors will want to know about:
- made fonts smaller in ICD10 screen to make more lines fit on the screen
- split the CCI screen into a picklist screen and a component screen and made the font smaller to fit more on one screen
- made following "collect first":
Things collectors would only care about if things were not working right:
- fixed false positives in query check_AIDS_vs_HIV
- fixed false negative in query check CCI must have entry
- changed VBA so Query check CCI no admin entries actually gets called
- re-imported CCI Categories for CCMDB.mdb and ICD10 Categories for CCMDB.mdb
2019-01-03-1
rolled out Ttenbergen 10:06, 2019 January 9 (CST)
- retired Implanted device NOS, adjustment/management from S ICD10 table
- fixed spelling for BiPAP, CPAP, NIV, own ventilator (Mechanical ventilation, noninvasive) in s_CCI_Picklist table
- added Query check_ICD10_has_comorbid
- updated so they will work with the workload sharing locations:
- in function TmpChecker
- commented out QA_Inf checks since we are no longer doing that in ICD10/CCI
- commented out old ACCU borrow checks that have not been needed since 2018-07-19 and were replaced by different method
2019-01-03
rolled out Ttenbergen 14:22, 2019 January 3 (CST)
- fixed uncheckable dx box (updated Sub Dx_Checker() so the colours for boxes that it relies on are initialized correctly as before)
2019-01-02-2
rolled out Ttenbergen 16:05, 2019 January 2 (CST)
- updated Dx_Checker to write changes before checking; this is to fix the problem where checking dx checkbox does't necessarily stick. Ttenbergen 15:42, 2019 January 2 (CST)
- updated query L_ICD10_Charlson_Agepts which had negative scores in it
- added Dx_Type to Query L_ICD10_Charlson_dxs Ttenbergen 15:54, 2019 January 2 (CST)
- filtered Query L_ICD10_Charlson_component_points to only include Comorbid Diagnosis and Admit Diagnosis Ttenbergen 15:54, 2019 January 2 (CST)
2019-01-02-1
was rolled
- updated to not give Pat_ID error
2019-01-02
rolled out Ttenbergen 08:15, 2019 January 2 (CST)
- changed query s_CCI_Categories_Collection_Mode back to a table, having it as a query prevents entries of new CCI codes.
- updated to not give Pat_ID error