CCMDB.accdb Change Log 2025: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 5: | Line 5: | ||
<!--Changes collectors '''don't''' need to know about:--> | <!--Changes collectors '''don't''' need to know about:--> | ||
--> | --> | ||
=== 2025-03-14 === | |||
not rolled yet | |||
'''<mark>Changes collectors need to know about:</mark>''' | |||
Changes collectors '''don't''' need to know about: | |||
* fixed typo in module converter that was giving an error when generating an [[Overstay2 colour]] | |||
=== 2025-03-11-1 === | === 2025-03-11-1 === | ||
Revision as of 11:13, 14 March 2025
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.accdb Data Integrity Checks. -->
2025-03-14
not rolled yet
Changes collectors need to know about:
Changes collectors don't need to know about:
- fixed typo in module converter that was giving an error when generating an Overstay2 colour
2025-03-11-1
rolled out Ttenbergen 01:32, 12 March 2025 (CDT)
Changes collectors need to know about:
- dispo s_dispo table - granularity Discharged to community:
- added "TRSF Group/Supportive housing", "TRSF to Correctional Facility", "Home with Support Services"
- LAU Collection Project:
- dispo s_dispo table - VGH_LAU, VGH_Geriatrics, COH_LAU, SOH_LAU, SOH_Geriatrics
- LAU OT/PT consults
Changes collectors don't need to know about:
- disabled Function program() which used to get its value from the a_info settings table; superseded by Function admission_program(Pat ID) but had left it with a meaningful error in case it gets triggered somewhere I had not found. Ttenbergen 16:11, 11 March 2025 (CDT)
2025-03-11
Rolled out Ttenbergen 01:21, 11 March 2025 (CDT)
Changes collectors need to know about:
- Changed to Category:Potential trauma since they can be non-traumatic diagnoses as well; updated in s_ICD10_Categories table as well:
- confirmed already in that category
- Respiratory tract, foreign body in (T17) - was already
2025-03-09
rolled out Ttenbergen 22:37, 9 March 2025 (CDT)
Changes collectors don't need to know about:
- LAU_collection_readmission_data - added no-record cross-check
2025-03-07-2
rolled out Ttenbergen 22:02, 7 March 2025 (CST)
Changes collectors don't need to know about:
- Project Consults data - added “no consult” to s_tmp table for SOH-UC, COH-UC and VGH-UC to satisfy Query check Project Consults data
2025-03-07-1
rolled out Ttenbergen 14:43, 7 March 2025 (CST)
Changes collectors don't need to know about:
- added Boarding Loc entries to s_tmp table for SOH-UC, COH-UC and VGH-UC
2025-03-07
rolled out Ttenbergen 09:27, 7 March 2025 (CST)
Changes collectors don't need to know about:
- fixed call to query check_LAU_collection_readmission_data that generated error that the db can't find the input table "LAU_collection_readmission_data"
2025-03-06
rolled out Ttenbergen 23:29, 6 March 2025 (CST)
Changes collectors don't need to know about:
- in preparation for LAU Collection Project:
- updated Sub Legacy_Hider() so it will treat Program = "LAU" the same as Program = "LAU"; without this, forms that are visible for only either CC or Med would not be visible for LAU records.
- this was reverted pending the outcome of LAU_Collection_Project#possible_problems_using_program_=_"LAU"
- Project Consults data
- added automatic "not entered" record to s_tmp table
- added Query check Project Consults data
- ACP Status Collection for LAU
- added options to s_tmp table
- added query check ACP Status Collection for LAU
- LAU collection readmission data
- updated Sub Legacy_Hider() so it will treat Program = "LAU" the same as Program = "LAU"; without this, forms that are visible for only either CC or Med would not be visible for LAU records.
- added as a mostly-twin of "home" to s_dispo table, but making it available only for dispo.
- TRSF Group/Supportive housing
- TRSF to Correctional Facility
- Home with supports
2025-03-04
copied to server, asking Lisa to roll out after re-importing Cognos Ttenbergen 09:40, 5 March 2025 (CST)
Changes collectors don't need to know about:
- added data items for LAU Collection Project to s_tmp table:
- updated "Hosp" dropdown in s_tmp table to current official values for Oaks, Conc and Vic: "COH";"SOH";"VGH"
2025-03-03
rolled out Ttenbergen 02:00, 4 March 2025 (CST)
Changes collectors don't need to know about:
- further prep for Project Overstay2: updated modules overstay2 and _Global with same changes as in CFE after update to ensure same overstay score as Julie
- added data items for LAU Collection Project
- to S dispo table: VGH_LAU, SOH_LAU, COH_LAU
- to S tmp table: the specific units listed on LAU Collection Project
2025-02-28-1
Lisa Kaita 12:22, 28 February 2025 (CST) Changes collectors need to know about:
- retired ICD 10 Past history of Covid-19 infection from S ICD10 table
- corrected my mistake reactivated COVID 19 infection and retired the appropriate one
2025-02-28
rolled out Lisa Kaita 09:12, 28 February 2025 (CST) Changes collectors need to know about:
- retired ICD 10 Past history of Covid-19 infection from S ICD10 table
2025-02-20
rolled out Ttenbergen 15:55, 20 February 2025 (CST)
Changes collectors don't need to know about:
- Prep for Project Overstay2
- changed the test entry in s_tmp table to match what the button generates; the previous value it entered was generating errors on sending because there was no corresponding value in s_tmp
2025-02-11
(Tina copied to server, Pagasa rolled it out) Ttenbergen 15:25, 12 February 2025 (CST) Changes collectors need to know about:
- added OS button to patient viewer form; it will eventually be used to generate colours for Project Overstay2; instructions to follow.
Changes collectors don't need to know about:
- changed to restore .dirty instead of DoCmd.RunCommand acCmdSaveRecord
- Function uncheck_reg() x2
- Prep for Project Overstay2
- added Overstay2, Overstay result to s_tmp table
- added OS button
- added code to colour the button
- added code to run when the button is clicked to Module Overstay2
- updated Sub GenerUpdate_tmp_entry to use Function runQuery instead of runsql
- changed to form_Current to run later, once pat_ID is initialized
- removed Function adl_sc - appears not to be used; use query adl_scores as needed
- moved function db_local from _global to _unique_cfe, only used there to open with parameter
- updated functions GCS_*_pts() to return integer with very high number if there is an error; improved error handling
- merged in #2025-02-09
- update all s_tmp entries for Boarding Loc to have MCHP=true (were inconsistent before)
2025-02-09
Changes collectors need to know about:
- added HSC-JK3 as a new boarding loc in S Cognos Units table and S tmp table
2025-02-06
rolled out Ttenbergen 12:56, 6 February 2025 (CST)
Changes collectors don't need to know about:
- Sub Dx_Checker() - 2x changed DoCmd.RunCommand acCmdSaveRecord back to Form_View.Dirty = False
2025-02-05
rolled out Ttenbergen 10:02, 5 February 2025 (CST)
Changes collectors don't need to know about:
- reverted a change to form CCI_Component_Chooser that caused error when picking a component
- reverted a change to function CADT_populate that caused error when clicking "Unit End DtTm" to populate Dispo_DtTm.
2025-01-28
rolled out Ttenbergen 13:19, 4 February 2025 (CST)
Changes collectors need to know about:
- added new Cognos entry for SBGH-L2CC
Changes collectors don't need to know about:
- Adding background functionality for Project Overstay2
- Module Overstay2 - code to generate the score with current dataset
- updated query L_ICD10_Charlson_agepts - it was still using Arrive DtTm and now uses created_AdmitDtTm query. Ttenbergen 10:39, 28 January 2025 (CST)
- updated Charlson_score_function to use a variant for ID, and updated it so it will work with either D_ID or Pat_ID (ie will work for CCMDB or CFE). Ttenbergen 12:15, 28 January 2025 (CST)
- added some functionality to be able to use code and queries in both CCMDB and CFE:
- Module Global_
- Const DB_ID to set CFE / CCMDB
- Function ID_name() to give "Pat_ID" for CCMDB and "D_ID" for CFE
- Function ID_query(ID) to expand into appropriate query strings for the two DBs based on DB_ID
- Function Charlson_score_function() to use ID_query()
- updated ExistsTable() with cleaner code
- added sub handle_err()
- added public constants minage and maxage to make sure we are always using the same
- Module Global_
- updated Function Validate_DOB() to use same minage/maxage and CCMDB_Age()
- replaced all "<form name>.Dirty = False" with "DoCmd.RunCommand acCmdSaveRecord" since that is more reliable
- found that after_update events had got disconnected for fields DOB, Sex, Record on form_view; this means that it would have been possible to run the complete check, pass it, then enter a value that should fail, and not have the complete unchecked; re-connected them
- added new Cognos entries:
- s_Cognos_Services table:
- GH Palliative Care / Home Care
- GH Medicine / Other ALC
- GH Surgery / Home Care
- GH Surgery / Panel Appr PCH
- GH Surgery / Panel in Process
- s_Cognos_Units table:
- SBGH-Outpt-B2IP
- SBGH-L2CC
- SBGH-zB2IP-Closed
- s_tmp table:
- SBGH-L2CC
- s_Cognos_Services table:
2025-01-20
rolled out Lisa Kaita 19:38, 20 January 2025 (CST)
Changes collectors need to know about:
- deactivated the allied health care project in the S tmp
2025-01-08
rolled out Ttenbergen 15:06, 8 January 2025 (CST)
Changes collectors don't need to know about:
- updated query check_tmp_BedHeld to also flag if record has Dispo="AMA (left against medical advice)" but no BedHeldEnd DtTm entry
- soft checks like query check_CCI_each_count_vs_LOS were being triggered last in the error checks, meaning that they would overrule hard checks that also triggered.
- changed the order of cross checks in Public Sub Dx_Checker() to do soft ones first so that hard ones would not be overwritten by soft ones
- this would have affected queries that, on this date, matched the query underlying the following list (data on wiki changes so if you look in the future this might be different)
| _pageName | Status | Firmness |
|---|---|---|
| Function long LOS() | needs review | soft check |
| Link suspect mismatch pre inpt ours incomplete query | implemented | soft check |
| Link suspect not same visitAdmitDtTm query | implemented | soft check |
| PL Diff Phin SameLN FN DOB | implemented | soft check |
| PL SamePHIN Site Diff chart | implemented | soft check |
| Query check CCI each count vs LOS | needs review | soft check |
| Query check CCI TISS discontinuous ETT | implemented | soft check |
| Query check ICD10 ESRD and AKI only if transplant | implemented | soft check |
| Query check ICD10 trach has trach but no TISS | implemented | soft check |
| Query check long transfer delay | needs review | soft check |
| Query check pt from ER | implemented | soft check |
| Query s tmp Boarding Loc ER delay reasonable | implemented | soft check |