CCMDB.accdb Change Log 2019: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 3: Line 3:


== Versions ==
== Versions ==
==== 2019-04-15 ====
not rolled out yet Ttenbergen 21:06, 2019 April 15 (CDT)
* fixed typo in [[s_ICD10 table]]: "Disoder of mediastinum, NOS" --> [[Disorder of mediastinum, NOS]] Ttenbergen 21:06, 2019 April 15 (CDT)
==== 2019-04-10 ====
==== 2019-04-10 ====
rolled out Ttenbergen 16:07, 2019 April 15 (CDT)
rolled out Ttenbergen 16:07, 2019 April 15 (CDT)

Revision as of 21:06, 2019 April 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-04-15

not rolled out yet Ttenbergen 21:06, 2019 April 15 (CDT)

2019-04-10

rolled out Ttenbergen 16:07, 2019 April 15 (CDT)

2019-04-08

rolled out Ttenbergen 23:34, 2019 April 8 (CDT)

2019-03-27-3

rolled out Ttenbergen 16:36, 2019 March 27 (CDT)

2019-03-27-2

rolled out Ttenbergen 15:57, 2019 March 27 (CDT)

2019-03-27

rolled Ttenbergen 12:33, 2019 March 27 (CDT)

  • tweak to the diagnosis cross checks, they were still trying to do things with the old form. Ttenbergen 12:33, 2019 March 27 (CDT)

2019-03-25

rolled out last night. Ttenbergen 10:38, 2019 March 27 (CDT)

Changes collectors will want to know about:

  • renamed ICD10 diagnoses that had ", poisoning by non-pharmaceutical" to just ", poisoning" since there were too many exceptions otherwise
  • updated the Patient Viewer form to not tab to the DOB field when leaving the Notes field. (Thanks Debbie!)
  • changed Bronchitis, acute or chronic not specified, infectious or noninfectious to be a potential infection (Thanks Michelle!)
  • All 2018 patients have been sent, so:
    • disabled the old "Diagnoses" and "Labs" tabs; they will be fully removed at a later time; fixed up checkbox locations. Ttenbergen 18:43, 2019 March 25 (CDT)

Changes behind the scenes:

  • removed L_Dxs, L_Comos, L_Labs from
    • reconnector
    • db converter
    • sending
  • commented out all code in the Labs, Como, Dxs forms
  • removed query Check_ApARF_CRF
  • excluded some dxs from Query check ICD10 duplicates

2019-03-20

rolled out Ttenbergen 17:58, 2019 March 20 (CDT)

2019-03-13

rolled out Ttenbergen 13:42, 2019 March 20 (CDT)

2019-03-11-2

rolled out Ttenbergen 13:23, 2019 March 13 (CDT)

Changes collectors will want to know about:

  • Sending will now disconnect from wifi at start of sending, and re-connect once sending is done. This was necessary because being on wifi significantly slows down and occasionally breaks some of the queries.

Changes collectors likely don't care about:

2019-03-11

rolled out Ttenbergen 10:38, 2019 March 11 (CDT)

  • further tweaks to code that runs when tabbing out of Notes field.

2019-03-09

rolled out

Changes collectors will want to know about:

2019-03-07

rolled out Ttenbergen 10:33, 2019 March 7 (CST) Changes collectors will want to know about:

2019-03-06

rolled out Ttenbergen 10:22, 2019 March 6 (CST) changes collectors will want to know about:

behind the scenes changes:

  • updated Function Reject_a_query to return true/rejected when the query fails to ensure fail safe; this way if a query fails the test will return an error. This will mean that if there are errors during cross checks or sending collectors will no longer think "but it allowed me to send" or "but it allowed me to check complete".

2019-02-13

rolled out Ttenbergen 10:06, 2019 February 14 (CST)

Changes collectors will want to know about:

Behind the scenes changes:

2019-02-06-1

rolled out Ttenbergen 09:37, 2019 February 6 (CST)

2019-02-05

rolled out Ttenbergen 09:23, 2019 February 6 (CST)

Changes collectors will want to know about:

Changes behind the scenes:

  • updated overstay function to use function CCMDB_Age

2019-01-30

rolled out Ttenbergen 22:54, 2019 February 5 (CST)

Changes collectors will want to know about

Behind the scenes changes

2019-01-24

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

2019-01-23

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

2019-01-22-1

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

2019-01-22

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

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:

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:

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

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:

2019-01-10

rolled outTtenbergen 13:33, 2019 January 10 (CST) Things collectors will want to know:

2019-01-09

not rolled out yet Ttenbergen 10:06, 2019 January 9 (CST) Things collectors will want to know about:

Things collectors would only care about if things were not working right:

2019-01-03-1

rolled out Ttenbergen 10:06, 2019 January 9 (CST)

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)

2019-01-02-1

was rolled

2019-01-02

rolled out Ttenbergen 08:15, 2019 January 2 (CST)

2018-...