CCMDB.accdb Change Log 2019

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-15

not rolled yet. Ttenbergen 17:48, 2019 January 15 (CST)

• set Lung abscess so it can accept a pathogen - updated wiki page and s_ICD10_Categories table

2019-01-14-1

rolled out Ttenbergen 10:35, 2019 January 15 (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.
• fixed sort order for magic wand in L ICD10 subform

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":
  • ICP monitor (Placement of implanted, invasive intracranial pressure monitoring device)
  • PD (Peritoneal dialysis)
  • HD (Hemodialysis)
  • CRRT (incl volume removal via PRISMA device)

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:
  • Check function preAdmit NE Location
  • Check function previous NE Location
  • Check function location NE dispo
• 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
  • Query check_ICD10_ESRD_vs_AP_ARF
  • Query check_ICD10_ESRD_vs_ARF

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
  • Query s_tmp_QASeptic_Dx_no_tmp_ICD10
  • Query s_tmp_QASeptic_tmp_no_dx
  • Query check CCI must have entry

2018-...

• see CCMDB.mdb Change Log 2018