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

updated overstay which was not properly considering dxs...

To Do:

• fix s_tmp_overstay_Dementia_adm_como
• tweaked other parts of overstay, with more tweaks to come

2019-01-24

rolled about half an hour ago Ttenbergen 16:17, 2019 January 24 (CST) Changes collectors will want to know about:

• added Abnormal blood chemistry NOS to s_ICD10 table
• fixed false positive in query s_tmp_IICU_consult_DtTm
• disabled Query s tmp Borrow sensible DtTm vs no borrow for now, wrong premise since these are autoentries, need to review.

2019-01-23

rolled out Ttenbergen 08:26, 2019 January 24 (CST)

• updated Query check ICD10 ESRD vs ARF to exclude patients with kidney transplant on this admission.
• implemented:
  • query s_tmp_Borrow_sensible_DtTm_vs_no_borrow
  • query s_tmp_Borrow_duplicates

2019-01-22-1

rolled outTtenbergen 13:56, 2019 January 23 (CST)

• tweaked bug in
  • Query check ICD10 awaiting has Transfer Ready DtTm
  • Query check ICD10 mechanism vs trauma

2019-01-22

rolled out Ttenbergen 15:14, 2019 January 22 (CST)

• updated Px Count field in L CCI Picklist subform and L CCI Component subform to be able to show numbers >99 Ttenbergen 15:55, 2019 January 21 (CST)
• updated pre-send checker to give a message whether it passes or fails, it was running quietly
• updated sending so it fails more strongly when there is an error during sending; specifically, it should now no longer set patient records to "sent" in CCMDB, or to "complete" in centralized.
• implemented Query check ICD10 mechanism vs trauma
• updated Query check_ICD10_awaiting_has_Transfer_Ready_DtTm to require that Transfer Ready DtTm must be on different date than Dispo_DtTm if there is an awaiting code.
• implemented query s_tmp_IICU_consult_dispo_to_IICU_but_no_tmp to require an IICU consult entry for every patient discharged to HSC_IICU
• implemented Query check_ICD10_trach_dxs_consistent to require that any pt who has a code implying a tracheostomy also has Tracheostomy, has one coded

2019-01-21

rolled out Ttenbergen 15:42, 2019 January 21 (CST) Changes Collectors will want to know about:

• updated Sending so it works again...

Behind the scenes changes:

• retired Query check VAP admit must be from ICU

2019-01-17

rolled out Ttenbergen 09:37, 2019 January 21 (CST)

Just fixes this time.

• fixed color generation for Overstay - updated query check_pt_from_pch
• fixed IICU consult - updated query s_tmp_IICU_consult_DtTm
• fixed "param" errors and missing queries- added code to resolve param if there is more than one.
• tweaked pre-send Checker so it gives no-error msg again
• resolved error in checking for duplicate patients.

2019-01-16

rolled out Ttenbergen 09:45, 2019 January 17 (CST)

• tweaked the new error coding further.
• specifically, it was breaking overstay coding and giving some "param" errors - hopefully I caught all of those now.

2019-01-15

rolled out Ttenbergen 23:21, 2019 January 16 (CST) Stuff collectors should care about:

• hoping to make errors easier to find - errors launched by checkboxes will now also show the query that raised them, hopefully providing additional help in finding out what is wrong. - updated Function Reject_a_query_PatID to use parameters, and all queries to use parameters.
• set Lung abscess so it can accept a pathogen - updated wiki page and s_ICD10_Categories table
• updated cross check for IICU consult to have the checkbox work according to collection instructions (cross check was giving false positives) - updated Query s tmp IICU consult DtTm Ttenbergen 10:14, 2019 January 16 (CST)
• fixed links in error messages that didn't use to open wiki pages - updated field in form data_integrity_check and function Err_hURLer
• updated Pre-send Checker and Send button to make sure both run the same checks - moved Check duplicate patient from sending only to the code that runs from pre-send checker.
• tweaked height of tab content again to hopefully eliminate scrolling.

Behind the scenes stuff:

• cleaned defunct and commented code out of function tmpChecker and deleted queries:
  • query s_tmp_QAInf_basic
  • query s_tmp_QAInf_dx_no_tmp
  • query s_tmp_QAInf_tmp_no_dx
  • query s_tmp_QAInf_LT_48_hrs_after_admit
  • Check BRR/XBR vs cardiac arrest dx
  • query s_tmp_ACP
  • query check_trach_dx_task
  • "111_dxCodeTRanslate" - never ended up being used
  • ACCU borrow queries "query s_tmp_ACCU_Borrow_chronicity_hard, "query s_tmp_ACCU_Borrow_2_hr_soft", "query s_tmp_ACCU_off_ward", "query s_tmp_ACCU_twin"
• cleared out Function has_multiples()
• cleared out old code from Sub Dx_Checker()

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