CCMDB.accdb Change Log 2020

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.

Versions

Change for next version:

future update

pop-up hints on Pharmacy screen - need to deal with, emailing ICU Task Team

• SMW

• Cargo

• Categories

2020-08-12-2

not rolled yet Ttenbergen 10:03, 2020 August 12 (CDT)

• re-enabled the requerying for cognos forms. Ttenbergen 10:03, 2020 August 12 (CDT)
• tweaked the Accept_Dtm_equiv field in Cognos to show a date if the ER Discharge time is with in 5 minutes of Unit start Dtm; I had assumed these would be actually equal, but at least at some sites they are not. This may need to be tweaked to > 5 min later; Collectors, please let me know if some who should have Accept DtTm still don't!

2020-08-12

not rolled out yet Ttenbergen 09:31, 2020 August 12 (CDT)

• disabled incomplete update to code that was rolled out with Cognos Data. Ttenbergen 09:31, 2020 August 12 (CDT)

2020-08-07-2

was rolled out with latest Cognos Data this morning Ttenbergen 09:31, 2020 August 12 (CDT)

• tweaked Patient Viewer Tab Cognos ADT so posting the end dtm will refresh the cognos list, since it might cut off the tail end of the list if there are multiple records for this pt.

2020-08-07

not rolled yet Ttenbergen 10:07, 2020 August 7 (CDT)

• excluded impossible time combinations from Cognos Discharger, Cognos Discharger FormQuery query
• excluded impossible time combinations from Patient Viewer Tab Cognos ADT, Cognos Patient viewer tab FormQuery query
• made available HSC_HOBS Ttenbergen 13:46, 2020 August 7 (CDT)

2020-08-06-2

rolled out Ttenbergen 07:48, 2020 August 7 (CDT)

• Cognos Discharger
  • changed default setting filter
  • added "already entered" field to Cognos Discharger FormQuery query, Cognos Discharger as part of working out Using Cognos Report Integrator to keep track of patients
  • deleted field "not_yet_dispo" - had added that initially, but it would not have included Boarding Locs, so needed to update; it also had not been used anywhere yet.

2020-08-06

rolled out Ttenbergen 10:14, 2020 August 6 (CDT)

• fixed "Previous entry" button, wasn't actually doing anything yetTtenbergen 10:14, 2020 August 6 (CDT)

2020-08-05-2

not rolled yet Ttenbergen 14:33, 2020 August 5 (CDT)

• inactivated "GRA_N5a" and "s_locations_allowed_collection" in S dispo table,

2020-08-05-1

rolled out Ttenbergen 11:38, 2020 August 5 (CDT)

• in Cognos Admitter, tweaked how the "+" button works to only apply Accept DtTm when appropriate. Ttenbergen 11:34, 2020 August 5 (CDT)

2020-08-05

rolled out

• made all currently collected locations available for both GRA Med Laptops.

2020-08-04

rolled out Ttenbergen 08:22, 2020 August 5 (CDT)

• added "Previous entry" button to Main Form (CCMDB.accdb) to call up Previous_entry form for all deleted records still on the laptop. Ttenbergen 20:29, 2020 August 4 (CDT)
• updated Sub CognosImport to do the checking for email and saving of attachment automatically.
• tweaked Cognos_import_processor query to fix whether Accept_DtTm_Equiv gets populated

2020-07-30

rolled out Ttenbergen 21:57, 2020 July 30 (CDT)

• Added HSC_HOBS for when B2 moves there 2020-08-07
• changed Disorder of skin or subcutaneous tissues, NOS to no longer be a potential infection, use Infection of skin or subcutaneous (soft) tissue, NOS instead Ttenbergen 11:56, 2020 July 30 (CDT)
• added Cognos_SubServices_additions_needed query and included it in Sub CognosImport to start an email if there is anything on it Ttenbergen 16:43, 2020 July 30 (CDT)
• tweaked Cognos Admitter FormQuery query; it was excluding some records where the subservice can't be (or hasn't yet been) clearly designated as either medicine or critical care program, or as a specific hospital.
• added Laptop identifier to "generate email" button Ttenbergen 21:41, 2020 July 30 (CDT)
• fixed Cognos Admitter
  • to actually use Accept_DtTm_Equiv that was added two versions ago but never set up right.
  • to trigger a requery in Patient Viewer after it finishes populating a copied record (otherwise the Patient Viewer Tab Cognos ADT doesn't show data correctly.

2020-07-29

rolled out Ttenbergen 10:55, 2020 July 29 (CDT)

• Cognos Admitter
  • "+" button for previously deleted patients should no longer be grayed out (removed conditional formatting rule "[recordstatus]="deleted"" that made new record entry grayed out for patients that had been previously deleted) - if there are still patients you can't enter, please email me with details Ttenbergen 10:52, 2020 July 29 (CDT)
  • added a button at the right end of the line that will open Previous_entry form
• made Previous_entry form which show previous entries of a patient (deleted or still active) Ttenbergen 09:37, 2020 July 29 (CDT)

2020-07-24

rolled out Ttenbergen 21:25, 2020 July 28 (CDT)

Changes collectors will probably want to know about:

• renamed "Decubitus (pressure) ulcer, Stage IV (involves bone)" to Decubitus (pressure) ulcer, Stage IV (involves muscle, tendon, or bone)
• for Cognos data in general, added the concept of Accept_DtTm_Equiv, and changed most places where service start dtm had been used to this; see Accept_DtTm_Equiv for more info
• in Patient Viewer Tab Cognos ADT
  • changed "Service Start" to Accept_DtTm_Equiv
  • changed position of the lines in teh bottom section with the Cognos data so that the service info is at the top, and the unit info at the

bottom, to be consistent with the layout at the top

• • changed default sort order to AsgnUnit_StartDtm (Cognos counterpart of Arrive_DtTm)
• in Cognos_Admitter
  • changed "Service Start" to Accept_DtTm_Equiv

Changes collectors probably don't care about:

• updated Sub CognosImport to start an email to collector about units that are not yet translated.
• added field "IPAdmitDtm" to
  • Cognos_import_processor query
  • Cognos_processed table
  • Cognos_integrator query
• added field "isER" to Cognos_dispo_translator table
• added Accept_DtTm_Equiv to
  • Cognos_integrator query
  • Cognos_Admitter_FormQuery query
  • Cognos_Patient_viewer_tab_FormQuery query
• changed forms to use new Accept_DtTm_Equiv
  • Cognos_Admitter
  • Patient Viewer Tab Cognos ADT

• deleted unused "query Cognos_FormQuery", cognos_tmp table

2020-07-23

rolled out Ttenbergen 23:03, 2020 July 23 (CDT) Changes collectors will want to know about:

• Main Form (CCMDB.accdb)
  • changed groupings and alignments of buttons to better reflect what goes together
  • added wiki links on to all components of that form
• Settings (CCMBD.mdb) - added wiki links on to all components
• added query to the "Mine! Mine!" button for Laptop identifiers G7, G8 in preparation for piloting PatientFollow Project at Grace Medicine Ttenbergen 22:23, 2020 July 23 (CDT)
  • G7 will filter to "LastTwo >= 0 AND LastTwo <= 49"
  • G8 will filter to "LastTwo >= 50 AND LastTwo <= 99"

Changes collectors might not care about:

• changed the "MR copy-paste" button to open the query in read-only mode. Turns out it was possible to accidentally delete a bunch of records by cutting instead of copying in that list. Ttenbergen 15:02, 2020 July 23 (CDT)
• correction to query check_ICD10_Comorbids_Dx_present, it wasn't triggering when no comorbids had been entered Ttenbergen 22:45, 2020 July 23 (CDT)

2020-07-13

rolled out Ttenbergen 18:36, 2020 July 13 (CDT)

• tweak to Patient Viewer Tab Cognos ADT - error when populating from previous unit with location that can't be Pre-admit Inpatient Institution; now gives specific message
• tweak to tmp edit form; form will now not open unless both project and item have been entered (it was giving errors for some projects when both values are not entered together)Ttenbergen 17:10, 2020 July 13 (CDT)

2020-07-08

rolled out Ttenbergen 07:25, 2020 July 9 (CDT)

• retired STB_A7_B from the s_dispo table after email from Pam that last record from there has been processed.
• edited query Cognos_Admitter_FormQuery which drives the list for Cognos Admitter - it was wrongly excluding some patients who already had a record on the laptop
• removed gray-out condition "Nz([Dispo_DtTm],#2999-12-31#)<[AsgnUnitStartDtm_Current]" from the "+" button in Cognos Admitter; this may cause records to be listed with a plus that should not be, but I will need to figure that out another time

2020-07-02

rolled out Ttenbergen 16:53, 2020 July 2 (CDT)

• fixed New Pt Serial helper form - a previous change had stopped the default populating of the service location field; also added a check to make sure the field is not blank, since a blank field was causing non-descript errors

2020-06-29-2

rolled out Ttenbergen 07:07, 2020 July 2 (CDT) Changes Collectors will want to know about:

• added Other specified infectious agents as the cause of diseases classified by other ICD10 code to S ICD10 table

Changes collectors probably don't care about:

• updated Cognos_dispo_translator table to improve automatic detection of equivalent units in Cognos Admitter, Cognos Discharger and Patient Viewer Tab Cognos ADT
• created Cognos_dispo_translator_additions_needed query and updated Sub CognosImport to run it on import to ensure new asgnUnits showing up in Cognos get equivalents assigned as appropriate Ttenbergen 20:15, 2020 June 30 (CDT)

2020-06-29

rolled out Ttenbergen 14:16, 2020 June 30 (CDT)

• Changed New_Pt_Serial_helper form to always use the next higher Pat_ID/Serial for whole laptop (one pool) rather than per location (see Facilitated Management of Serial numbers)
• Cognos Discharger
  • hiding sent, deleted and patients (not yet those who have dispo and dispo dttm as some of that is helpful to track incomplete patients)
  • added ToLoc summary
• Cognos Admitter
  • updated so excluded patients are actually excluded, this was not working in most recent version
• Patient Viewer Tab Cognos ADT
  • added To(summary) field
  • changed equiv previous so it populates pre-admit inpt location in addition to previous location (easier to delete where not correct than to add manually)

2020-06-29

rolled out Ttenbergen 23:04, 2020 June 29 (CDT) Changes collectors probably want to know about:

• TISS form audit is over, disabled
• changed Cognos Admitter
  • no longer include the color legends box in ctrl-f find (a search would have included the text in it and so would not have properly found a patient with a last name equal to any parts of the words in the legend - changed the color legend to "disabled" to fix)
  • changed the buttons to be "O" for open and "+" for adding a new record; this was necessary because sometimes something needs to be added to an existing record, and sometimes a new record needs to be added, so single button wasn't good enough
• renamed the "view excludeds" button to "View exclusions" button

Changes collectors probably don't want to think about:

• changed tmp form so it doesn't do a full re-query after entering something; this meant having to click on dropdowns twice or more.

2020-06-25

rolled out Ttenbergen 07:14, 2020 June 26 (CDT) Changes collectors will want to know about:

• in s_ICD10 table
  • "Fetal alcohol syndrome (applies to baby, not mom)" changed to Fetal alcohol syndrome (Allan has updated wiki)
  • added Effects of starvation

2020-06-19

rolled out Ttenbergen 13:40, 2020 June 19 (CDT)

• in Cognos Discharger
  • fixed the binoc button, it was still looking for the old field name

2020-06-18-3

rolled out Ttenbergen 07:49, 2020 June 19 (CDT)

• in Patient Viewer Tab Cognos ADT
  • changed the query that provides data for this to eliminate duplication
• in Cognos Admitter
  • added Service Location as requested during meeting
  • fixed sorting by Accept DtTm and Arrive DtTm
  • added sorting by Unit Start Dtm, Service Start Dtm
• in Cognos Discharger
  • added sorting for Dispo DtTm, Unit End Dtm

2020-06-18-2

rolled out Ttenbergen 11:51, 2020 June 18 (CDT)

• Cognos EPR Report (ie affects all Cognos data)
  • fixed a problem in the general patient list that would have excluded patients who don't have a unit end date
• Cognos Admitter
  • confirmed that filter-by-service and filter-by-unit would show patients who are not entered yet
  • limit list so it only shows the first Attending, rather than showing a line each time attending changes
  • fixed a problem in the general patient list that would have excluded patients who don't have a unit end date

2020-06-18

rolled out Ttenbergen 10:03, 2020 June 18 (CDT)

• Cognos Admitter
  • filtered list for program and hospital
  • fixed filter-by-service error "Enter Parameter Value"

2020-06-17

rolled out Ttenbergen 12:12, 2020 June 17 (CDT)

• S ICD10 table - changed "Necrotizing vasculopathy/vasculitis, NOS " to Vasculopathy/vasculitis, NOS
• Cognos Admitter -
  • fixed service and unit filter dropdowns that were broken by most recent update
  • fixed button colouring that indicates status
• Patient Viewer Tab Cognos ADT
  • fixed cross populating for previous and next location
  • "Make B Loc" button will now delete the "no borrow" line if there is one.

2020-06-12

rolled out Ttenbergen 08:49, 2020 June 17 (CDT)

• in Cognos_dispo_translator table: changed "GH-3North" from "GRA Ward" to "GRA_N3"
• made GRA_N5 available for G8 laptop
• updated how "Mine! Mine!" button works - it now uses filter values stored in Cognos_Admit_filter table
• changed "exclude" button on Cognos Admitter to populate the Unit start Dtm rather than the Service Start dtm
• major re-work of underlying queries:
  • Cognos_Import_processor
  • Cognos_Integrator (replaces Cognos_Arrive_Identifier and includes functionality that was previously re-implemented in several _FormQueries)

An earlier version introduced Cognos_SubServices table but didn't document this

2020-06-11-2

rolled out Ttenbergen 09:09, 2020 June 12 (CDT)

• in s_dispo table / S locations allowed collection table:
  • changed dropdown location for STB_E6_B on S5
  • changed "ward" column for STB E6 C to "E6_C" as requested by Julie
  • inactivated "STB_E6aB" and STB_E6_C
• Cognos in general:
  • the concept of previous location in Cognos is confusing because they treat ER fundamentally different than wards/units. Made a field "FromLoc" that tries to make sense of this; set this to list anyone who doesn't have a previous unit as coming from ER. These will show up in Cognos Admitter and Patient Viewer Tab Cognos ADT. Please let me know if you find some where this is wrong!
  • changed listings for unit and service end dtms so they are blank when they are filled with today's date only to avoid nulls; If you still see today dates without times for service or unit end dtms, let me know
• in Patient Viewer Tab Cognos ADT:
  • changed filter for Cognos records listed here to only include those with same Visit Admit DtTm field; this will still list more than needed, but at least will exclude previous or later admissions from this view.
  • changed order of Cognos records to be listed by Unit Start Dtm (~ our Arrive DtTm), descending
• in Cognos Admitter
  • added from location (which is not really same as previous location)
  • fixed patient filter functionality so it filters to and un-filters from properly when clicking on patient name
• in Cognos Discharger
  • fixed filter to list pt if either Service or Unit have end dtm (before it missed a bunch)
  • made default sort order by unit end dtm, descending

2020-06-11

rolled out Ttenbergen 10:56, 2020 June 11 (CDT)

• made STB_E6_B available for collection for Laptop_identifier S5

2020-06-09-3

was rolled out with newest cognos data this morning Ttenbergen 10:56, 2020 June 11 (CDT)

• inactivated tmp entries for IICU consult
• in Patient Viewer Tab Cognos ADT:
  • changed the Cognos listing to not use black-and-white alternate colours

2020-06-09-2

rolled outTtenbergen 14:05, 2020 June 9 (CDT)

• TISS form audit - added option "no error or one item wrong on the day'"

2020-06-09

rolling updates for this morning

• tweaked the filter for discharger that looks for presence of end time

2020-06-05-3

not rolled yet Ttenbergen 16:03, 2020 June 5 (CDT)

• made inactive the following in s_dispo table and removed from S locations allowed collection table since no longer used
  • HSC_H4H_a
  • HSC_H4H_b
  • HSC_H4H_d
  • HSC_H4H_h
  • HSC_H4H
  • HSC_EMIP_a
  • HSC_EMIP_b
  • HSC_EMIP_d
  • HSC_EMIP_h
  • STB_EMIPa
  • STB_EMIPd
• made available in allowed collections:
  • GRA_S3 for G8 laptop
• made STB_E5d unavailable - removed from allowed and inactivated in dispo
• made STB_E5 available for S4 laptop (old d laptop)

2020-06-05-3

rolled out Ttenbergen 15:25, 2020 June 5 (CDT)

• fixed corruption in query L_Log_ownerCheck_maker

2020-06-05-2

rolled out Ttenbergen 15:25, 2020 June 5 (CDT) (10 min before) Changes collectors probably don't care about:

• cleaning up s_dispo table and s_locations_allowed_collection table, see 2020-06 s dispo table cleanup for details
• recovered the s_AllDiagnoses table, S_Pathogens table - turns out they are still needed for MCHP Export.accdb and CFE

2020-06-05

rolled out Ttenbergen 10:00, 2020 June 5 (CDT)

• fix password on close error that started this morning - did Importing CCMDB.accdb into a new .accdb

Changes collectors probably don't care about:

• deleted old s_AllDiagnoses table, S_Pathogens table

2020-06-04-2

rolled out Ttenbergen 07:57, 2020 June 5 (CDT)

• in Cognos Admitter
  • added "view excludeds" button
  • set up sorting for unit arrival dtm

2020-06-04

rolled out Ttenbergen 13:41, 2020 June 4 (CDT)

• added additional options for new instructions for TISS form audit Ttenbergen 13:37, 2020 June 4 (CDT)

2020-06-03-2

rolled out Ttenbergen 17:18, 2020 June 3 (CDT)

• cross checks for Boarding Loc:
  • query s_tmp_Boarding_Loc_date_item
  • query s_tmp_Boarding_Loc_no_borrow_but_entry

2020-06-03

rolled out Ttenbergen 15:32, 2020 June 3 (CDT) Changes collectors should know about:

• fixed "set previous location to pre-admit" button in Patient Viewer Tab Dispo that was broken by most recent update Ttenbergen 08:51, 2020 June 3 (CDT)
• changed Cognos Admitter
  • now only enters PHIN for MB patients
  • added a filter for a specific patient
  • (added query Cognos_has_matching_Boarding_Loc to query Cognos_Admitter_FormQuery)
  • added Cognos_Admitter#"Mine! Mine!" button for better filtering

Changes collectors probably don't care about:

• fixed previously disabled code that disallows additions on from_open for patient viewer to prevent accidental scrolling off screen
• excluded L_tmp from "Delete Sent Patients" button so Cognos Report Integrator can compare against old Boarding Loc entries

2020-06-02

rolled out Ttenbergen 22:23, 2020 June 2 (CDT)

• removed Query check ICD10 ESRD vs AP ARF since the definitions are not the same Ttenbergen 20:36, 2020 June 2 (CDT)

• for Cognos in general: changed how HSC B2 is treated by Cognos tools to make it match that ward

• in Cognos Admitter:
  • changed the filter to not exclude sent and deleted patients from the list
  • made separate query field for "deleted"
  • changed the button background conditional format so it's dark gray for deleted records
  • changed the binoc button so it adds the unit arrival dtm to EPR Admit DtTm field

• in Patient Viewer Tab Cognos ADT
  • changed to also populate EPR Admit DtTm field when the unit arrive dtm field is clicked to copy the contents to Arrive DtTm
  • added "set previous location to pre-admit" button
  • removed EPR Admit DtTm field from Patient Viewer Tab Dispo, now only visible in Patient Viewer Tab Cognos ADT where it is relevant to make sense of new Cognos lines for that pt.

Changes collectors don't need to know about:

• deleted "HSC D2 C" from s_dispo table - it is not used in any complete or incomplete record so we don't need to keep it.

2020-05-29

rolled out Ttenbergen 14:42, 2020 May 29 (CDT)

• fixed HSC_D5 for Boarding Loc, I accidentally set it so it can only be seen at STB
• in Cognos Admitter:
  • made name column and admit dttm columns sortable
  • added filter option for unit
  • fixed link to wiki from this form
• in Patient Viewer Tab Cognos ADT: made all Dtm fields military time

2020-05-28

rolled out Ttenbergen 16:35, 2020 May 28 (CDT)

• added HSC_D5 to Boarding Loc
• changed sort order for Cognos Admitter to sort by chart present, then unit (new), then chart, then service start time; I can tweak the default further, talk to me, and I can also add sorting options to headings (again, tell me which)
• changed Cognos Visit Admit DtTm to derive from their HospEntryDtm, not their inpatient startDtTm

2020-05-27-5

rolled out Ttenbergen 23:00, 2020 May 27 (CDT)

• s_dispo table changes for 2020-05 HSC COVID unit transition
  • changed HSC_D4_P to HSC_D4
  • changed HSC_D4_C Ward column to say D4_C (collectors will see nothing of this one)
  • added HSC_B2_C
  • made no change to HSC_WRS3 - it was on Julie's list but all black so assume not change needed.

2020-05-27-4

rolled out Ttenbergen 14:20, 2020 May 27 (CDT)

• added "SBGH-ICCS" and "SBGH CCUO" to Cognos_dispo_translator table
  • we don't have any "SBGH CCUO" in our Cognos data yet so are likely not getting the ACCU data yet; following up with Cognos people on this.
• doing the changes to the Category:Awaiting/delayed transfer codes I claimed to have done yesterday

2020-05-27-3

rolled out Ttenbergen 10:35, 2020 May 27 (CDT)

• fixing the EPR Integrator Null error - updated query 'sL_EPR_Logs_FormQuery' do deal with Nulls, no idea why that wouldn't have come up before.
• fix to query 'Cognos_Admitter_FormQuery'

2020-05-27-2

rolled out Ttenbergen Ttenbergen 10:15, 2020 May 27 (CDT)

• update to Cognos Admitter to include ICCS (include program "surgery"

2020-05-27

rolled out Ttenbergen

• various fixes to last night's roll-out

2020-05-26

rolled out Ttenbergen 00:08, 2020 May 27 (CDT) Changes collectors need to know about:

• made available the entries for TISS form audit
• in s_ICD10 table, changed
  • Z75.1 Awaiting/delayed transfer to other acute care facility in Winnipeg (from "Awaiting/delayed transfer to other acute care facility")
  • Z75.1x Awaiting/delayed transfer to any other care facility outside Winnipeg other than home or LTC/PCH (from "Awaiting/delayed transfer to other care facility NOS")
  • Z75.4 Awaiting/delayed transfer to long-term care/PCH inside or outside of Winnipeg (from "Awaiting/delayed transfer to long-term care/PCH")
  • Z75.8 Awaiting/delayed transfer to lower acuity site in Winnipeg other than home or LTC/PCH (includes transitional care facilities) (from "Awaiting/delayed transfer to transitional care facility")
• Additions, updates and tweaks to Cognos Admitter and Cognos Discharger and Patient Viewer Tab Cognos ADT
• Removed "Cognos Integrator" button since the three above will take its place; I still have to clean up much wiki for that.

Changes collectors probably don't care about:

• removed old table "s_como draws from s_allDx & L_settings via query" which never contained data and was just there as an explanation
• updated query send_set_oLog_to_sent to work right with Laptop identifier being part of D_IDs now; it wasn't allowing sending when same site and service location are being used at same time on different laptops

2020-05-22

rolled out Ttenbergen 07:49, 2020 May 25 (CDT) Changes collectors don't need to know about:

• changed send process to use goto rather than resume on send_check_centralized_is_owner error Ttenbergen 07:49, 2020 May 25 (CDT)

2020-05-21

was rolled out this morning at 07:45 Ttenbergen 07:49, 2020 May 25 (CDT)

Changes Collectors should care about:

• Cognos Report Integrator - added the Patient Viewer Tab Cognos ADT; this will be used together with some other forms I am still working on

Changes collectors might care about:

• made visible the dispo wizard/filter button for the dispo field; this is the same as the buttons for the pre-admit inpt location and previous location; button has been there for long time but for some reason was invisible

Changes collectors probably don't care about:

• removed invisible legacy items from Patient viewer: R Filter, Overstay button,
• removed legacy code for Comfort Care, QA_Infection and QA_Septic_Shock

2020-05-14

rolled out Ttenbergen 16:17, 2020 May 20 (CDT)

• in s_dispo table:
  • inactivated "HSC D2 C" , it was never used
  • changed "Site" column to show hospital for the various Transitional Care units in town
• updated Service/Location dropdown order as per collector request Ttenbergen 14:15, 2020 May 20 (CDT)
• updated Check Inf Infection with implied pathogen must not have a pathogen combined code to work correctly if one the conflicting codes is a Category:Double duty pathogen

2020-05-06

rolled out Ttenbergen 17:07, 2020 May 6 (CDT)

• further work on Cognos Report Integrator but need futher tweaks to the data I received.
• Project Accept Loc Park:
  • added following:
    • CON - UC
    • OAK - UC
    • VIC - UC
  • deactivated the following:
    • CON - ER
    • OAK - ER

2020-04-28

rolled out Ttenbergen 12:46, 2020 April 28 (CDT)

• in s_locations_allowed_collection table
  • for s4, removed STB_E6dB, STB_B5d, STB_IMCd
  • for s4/s5/s6, added/confirmed presence of STB_IMCU

2020-04-27

rolled out Ttenbergen 16:36, 2020 April 27 (CDT)

• added ability to enter as Pre-admit Inpatient Institution for a bunch of the new COVID locations, I forgot when I first set them up Ttenbergen 16:14, 2020 April 27 (CDT)

2020-04-26

rolled out Ttenbergen 20:56, 2020 April 26 (CDT) Changes collectors will want to know about:

• The following change should make sending a lot quicker, so if you notice that there is probably nothing wrong:
  • updated Query send_check_centralized_is_owner and its component query L_Log_ownerCheck_maker

2020-04-17-1

rolled out Ttenbergen 13:48, 2020 April 24 (CDT)

• set the MCHP field to true for Boarding Loc, Project Borrow arrive and H1N1 in s_tmp table.
• set Previous Location field to allowed in S_dispo table for a bunch of the new locations that were added recently; missed it because those fields in the table were set to hidden.

2020-04-17

rolled out Ttenbergen 10:23, 2020 April 17 (CDT)

• for 2020-03 GRA COVID unit transition:
  • fixed availability of GRA_5N in S tmp table

2020-04-16-1

rolled out Ttenbergen 23:30, 2020 April 16 (CDT)

• for 2020-04 HSC COVID unit transition:
  • to S tmp table for Boarding Loc, HSC_H4H_P to HSC_H4H
• more work on Cognos Report Integrator; there is some test data in there from the morning of Apr 16, so whoever wants to play with it a bit to test it is welcome to. Please provide any feedback at Cognos Report Integrator.

2020-04-16

rolled out Ttenbergen 12:47, 2020 April 16 (CDT)

• for 2020-04 HSC COVID unit transition:
  • to S tmp table for Boarding Loc, added:
    • HSC_H4H_P

2020-04-15-1

rolled out Ttenbergen 12:28, 2020 April 16 (CDT)

• for 2020-03 GRA COVID unit transition:
  • to s_dispo table / S locations allowed collection table, added:
    • GRA_PACU
  • to S tmp table for Boarding Loc, added:
    • GRA_5N

2020-04-15

rolled out Ttenbergen 11:27, 2020 April 15 (CDT)

• fixed number generator for "Add Patient with Serial Helper" button
• tweaked wording for question during sending that asks if you are connected to a network cable to "Is your laptop or docking station physically connected to a network cable?"; hopefully it's clear now, if not please suggest further wording change.
• tweaked availability of service locations

2020-04-14

rolled out Ttenbergen 21:20, 2020 April 14 (CDT)

• tweaked Function Regional_server_connected() to work right when trying to send while disconnected from regional server
• 2020-03 GRA COVID unit transition:
  • added GRA_2S to S dispo table
  • added GRA 5S C and GRA_2S to s_locations_allowed_collection table

2020-04-09-1

rolled out Ttenbergen 14:24, 2020 April 14 (CDT)

Changes collectors probably won't care about:

• cleaned out all use of query check_dispo_lower_acuity_than_location and function Transfer_Ready_DtTm_vs_Location_vs_Dispo since we agreed that there would no longer be distinctions between CTUs and NTUs in how we collect and report.
• fixed fall-out from spring cleaning
  • restored query check_pt_from_ER

2020-04-09

rolled out Ttenbergen 13:47, 2020 April 9 (CDT)

Changes collectors probably don't need to know:

• removed Overstay button and code relating to it; this got rid of a lot of code, queries etc but should have no effect on collectors
• another tweak to STB_E6_C in S dispo table
• fixed an overflow bug when adding a new patient that was introduced by the send changes in recent updateTtenbergen 13:45, 2020 April 9 (CDT)

2020-04-08

rolled out Ttenbergen 21:33, 2020 April 8 (CDT)

• tweaked s_dispo table re COVID ward moves as per email from Julie, just naming tweaks for columns not visible to collectors.

2020-04-06

rolled out Ttenbergen 12:02, 2020 April 8 (CDT)

Things collectors should know about:

• added to s_dispo table to accommodate COVID ward moves:
  • 2020-04 HSC COVID unit transition - please discuss questions about this there
    • "HSC D2 C"
    • HSC_B2
    • HSC_MS3
    • HSC_A7_MI
    • HSC_A7_SI
    • HSC_H7_MI
    • HSC_H7_SI
  • 2020-03 GRA COVID unit transition - please discuss questions about this there
    • GRA 5S C
• tons of tweaking to the routines that make a new record to clean up an old mess I came across that stopped some changes we are working on; should not have any visible effect but if making new records acts up, let me know. Ttenbergen 23:33, 2020 April 7 (CDT)

Things collectors don't need to know:

• work on Cognos Report Integrator Ttenbergen 14:11, 2020 April 3 (CDT)
• changed s_dispo table
  • STB_E6_C Center = from 221 to 226 (only affects Julie's reports)

2020-04-06

rolled out Ttenbergen 23:51, 2020 April 6 (CDT)

• added all HSC Med locations to all HSC Med laptop in S locations allowed collection table to allow following of patients as they are moved around. Ttenbergen 15:19, 2020 April 7 (CDT)

2020-04-05

rolled out Ttenbergen 23:51, 2020 April 6 (CDT)

• added STB_IMCU to S5 laptop in S locations allowed collection table

2020-04-03-2

rolled out Ttenbergen 23:24, 2020 April 5 (CDT)

• work on Cognos Report Integrator Ttenbergen 14:11, 2020 April 3 (CDT)
  • added Cognos_import table and Cognos_import_processor query Ttenbergen 15:02, 2020 April 3 (CDT)
  • added several other Cognos* components that are not working or documented yet. Ttenbergen 23:26, 2020 April 5 (CDT)
• Made changes for ICUotherService in s_tmp table
  • added (for HSC)
    • SICU under MICU
    • MICU under SICU
  • removed (from STB)
    • CICU under MICU
    • CICU under ACCU

2020-04-03-1

only provided to specific people for testing for now

• starting work on Cognos Report Integrator Ttenbergen 14:11, 2020 April 3 (CDT)
• added Cognos_import table and Cognos_import_processor query Ttenbergen 15:02, 2020 April 3 (CDT)
• tweak to fix spelling problem in prev version Ttenbergen 15:03, 2020 April 3 (CDT)

2020-04-03

only provided to specific people for testing for now

• added a step to sending where user confirms whether they are connected to LAN cable or docking station; wifi will no longer be disabled during sending unless people are docked or tethered. Ttenbergen 10:09, 2020 April 3 (CDT)

2020-04-01

rolled out Ttenbergen 16:05, 2020 April 1 (CDT)

• renamed "" to COVID-19 (SARS-COV-2) in S ICD10 table

2020-03-29

rolled out Ttenbergen 12:21, 2020 March 30 (CDT)

• In s_tmp table changed Boarding Loc entry "STB_E6_P" to "STB_E6_B" for consistency

2020-03-29

rolled out Ttenbergen 23:54, 2020 March 29 (CDT)

• changes required for 2020-03 STB COVID unit transition
  • renamed "STB_E6" to STB_E6_B
    • STB_E6a --> STB_E6aB
    • STB_E6b --> STB_E6bB
    • STB_E6d --> STB_E6dB
  • added
    • STB_E6_C
    • STB_A7_B
  • in s_locations_allowed_collection table, added entries for STB Laptop identifiers for new and changed locations
  • In s_tmp table:
    • we add Boarding Loc entry "STB_E6_P" that will stay active only during this transition.

2020-03-24

rolled out Ttenbergen 14:40, 2020 March 24 (CDT)

• added the following to S tmp table for Boarding Loc for 2020-03 HSC COVID unit transition:
  • HSC_D5_P
  • HSC_D4_P

2020-03-23

was rolled

• re-did name changes as per 2020-03-20 since I overwrote them with what Julie sent.

2020-03-20

rolled out Ttenbergen 14:55, 2020 March 22 (CDT)

• added link to Drugs Collected to the Pharmacy screen Ttenbergen 09:34, 2020 March 20 (CDT)
• changed names of the following in s_dispo table because the longer version was breaking sending:
  • HSC_D4_pre_COVID to HSC_D4_P
  • HSC_D5_Pre_COVID to HSC_D5_P
  • HSC_D4_COVID to HSC_D4_C
• updated various columns in S_dispo table as per email from Julie

2020-03-19

rolled out Ttenbergen 22:33, 2020 March 19 (CDT)

• Changes Collectors will want to know about:
  • changes for 2020-03 HSC COVID unit transition
    • in s_dispo table:
      • renamed "HSC_D4" to HSC_D4_pre_COVID
      • added HSC_D4_COVID

• Behind the scenes changes that are probably not interesting to collectors:
  • changes for 2020-03 HSC COVID unit transition
    • edited s_locations_allowed_collection table to allow the new locations to be collected
    • edited queries for use on H4 laptop
      • COV_L_Log_int (use H4 laptop locations)
      • COV_1L_Log_twinner (blank the Accept and Arrive DtTms)
      • ran on H4 laptop Sub Location_Twinner()

2020-03-18

rolled out Ttenbergen 00:37, 2020 March 19 (CDT)

• Changes Collectors will want to know about:
  • Facilitated Management of Serial numbers - added "Add Patient with Serial Helper" button
  • changes for 2020-03 HSC COVID unit transition
    • in s_dispo table:
      • added HSC_WRS3
      • renamed "HSC_D5" to HSC_D5_Pre_COVID
      • added HSC_D5

• Behind the scenes changes that are probably not interesting to collectors:
  • changes for 2020-03 HSC COVID unit transition
    • edited s_locations_allowed_collection table to allow the new locations to be collected
    • added Sub Location_Twinner() and some COV_* queries to automatically twin records

2020-03-17

rolled out Ttenbergen 11:49, 2020 March 18 (CDT)

• Changes collectors probably want to know about
  • added COVID-19 (SARS-COV-2) to S ICD10 table (don't use Coronavirus for current outbreak)
  • changed "Resistance to antimicrobials, anti-mycobacterial agent" to Resistance to antimicrobials, classic anti-mycobacterial agent in S ICD10 table
  • retired Imprisonment/incarceration in S ICD10 table

2020-03-16

rolled out Ttenbergen 09:45, 2020 March 16 (CDT)

• reset testing sending

2020-03-15

rolled out Ttenbergen 23:49, 2020 March 15 (CDT)

• updated delete queries to work properly with new Laptop identifier

2020-03-12

Rolled out Ttenbergen 10:05, 2020 March 12 (CDT)

• removed Gastrointestinal (GI) tract, chemical burn and Electrical injury from since we would not want to enforce mechanisms on these.
• did a Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb Ttenbergen 10:04, 2020 March 12 (CDT)

2020-03-11

rolled out Ttenbergen 10:02, 2020 March 11 (CDT)

• updated Query check_ICD10_only_1_stage_of_renal_failure to allow collection of different stages of CKD into different Dx Types Ttenbergen 09:59, 2020 March 11 (CDT)

2020-03-05

rolled out Ttenbergen 14:03, 2020 March 5 (CST)

• updated more tables for Laptop identifier
  • s_laptops table
  • S PatientFollow distribution table
• in S dispo table, deactivated CON_MICU, OAK_MICU

2020-03-03

not rolled yet Ttenbergen 15:04, 2020 March 3 (CST)

Partial roll-out to only Michelle (H4) and Iris (H5) Ttenbergen 12:57, 2020 March 4 (CST)

• deleted ancient s_locations_local table that would have been unused since the 2016 location changes
• in Main Form (CCMDB.accdb), changed the entry at the top right to show the laptop identifier rather than the old laptop location
• deleted old query 111
• Update of D ID to include a laptop identifier - added Laptop identifier to D_ID:
  • query Send_Centralized_1L_Log_update - no update needed or done
  • query send_Centralized_1L_Log__intermediate - new D_ID format
  • query Send_Centralized_L_Pharm_Flowsheet__intermediate - new D_ID format
  • query Send_Centralized_L_TmpV2__intermediate - new D_ID format
  • query Send_Centralized_L_ICD10__intermediate - new D_ID format
  • query Send_Centralized_1L_Log_append - now draws from ...intermediate
  • queries Send_Centralized_*_delete - confirmed no update needed or done
  • queries Send_Centralized_*_update - confirmed no update needed or done
  • queries Send_Centralized_*_append - confirmed no update needed or done
  • query send_PHI - new D_ID format
• cleanup
  • deleted query Send_Centralized_L_CCI__intermediate that was remnant from early CCI setup
  • deleted query Send_Centralized_L_Labs_Flowsheet__intermediate
  • deleted query Send_Centralized_L_Labs_Flowsheet_append
  • deleted query Send_Centralized_L_Labs_Flowsheet_delete
  • deleted query Send_Centralized_L_Labs_Flowsheet_update
  • deleted query L Labs total
  • deleted query Send_Centralized_L_Dxs__intermediate
  • deleted query Send_Centralized_L_Como__intermediate
  • deleted query Send_Centralized_L_CCI_deleteSend_Centralized_L_Como_delete
  • deleted query Send_Centralized_L_Como_delete
  • deleted query Send_Centralized_L_Dxs_delete
  • deleted query Send_Centralized_L_CCI_update
  • deleted query Send_Centralized_L_Como_update
  • deleted query Send_Centralized_L_Dxs_update
  • deleted query Send_Centralized_L_CCI_append
  • deleted query Send_Centralized_L_Como_append
  • deleted query Send_Centralized_L_Dxs_append

2020-03-01

rolled out Ttenbergen 15:03, 2020 March 3 (CST)

• changes to s_locations_allowed_collection table to accommodate new Laptop identifier
• updated query s_serviceLocation_local to use the new function Laptop_identifier() instead of the old Hosp() Loc() combination
• deleted form "s_locations_allowed_collection" which was likely automatically and accidentally added at some point, but isn't used
• changed sending function to start using laptop location for PHI file names
• changed function Global.LaptopLocation to Global.Laptop_identifier for consistency with new setup and to make sure things break loudly if something is forgotten. Ttenbergen 17:06, 2020 March 1 (CST)
• upsdated S laptops table Ttenbergen 14:12, 2020 March 2 (CST)
• removed button to access s_dispo chooser - it was never fully implemented, and isn't working, and no one has complained about it since it was set up in 2016, so I guess the functionality is not needed.

2020-02-27

This wasn't rolled out so much as it will be introduced as I change laptops to the new Laptop identifier. Done by Fri 2020-02-28

• changed sending functionality to use A Info table field_name "Laptop_Identifier" for file path for sending. Ttenbergen 09:35, 2020 February 27 (CST)

2020-02-23

rolled out Ttenbergen 20:37, 2020 February 23 (CST)

• in S_ICD10 table
  • changed "Gastritis, hemorragic" to Gastritis, hemorrhagic 16:19, 2020 February 23 (CST)
  • added Cognitive impairment, NOS Ttenbergen 17:10, 2020 February 23 (CST)

2020-01-31

rolled out Ttenbergen 16:58, 2020 February 3 (CST)

• added entry for Nephrostomy placement to s_CCI_Categories_Collection_Mode table (forgot on original addition)
• deleted query check_ICD10_ESRD_vs_ARF and code calling it since it's no longer feasible - some ESRD can have AKI

2020-01-28

Rolled out. Ttenbergen 13:05, 2020 January 30 (CST)

• Added Other and unspecified symptoms and signs involving the nervous and musculoskeletal systems to S ICD10 table
• Since we moved to Boarding Loc, disabling the following fields we are no longer using.
  • Project Borrow arrive - no longer automatically entered or available in drop-downs from S tmp table
  • Off ward field - field made invisible in Dispo tab

2020-01-23

rolled out Ttenbergen

• added Nephrostomy placement to s_CCI_Picklist table and s_CCI_Categories table
• added (D) Pericardium to s_CCI 1 table

2020-01-15

rolled out Ttenbergen 09:43, 2020 January 16 (CST)

• removed trauma categories from Rib fracture(s) due to CPR - it's iatrogenic, so not a trauma and no mechanism required.
• added Resistance to carbapenem antibiotics
• tweaks to EPR Reports Integrator as discussed with Michelle

2020-01-02

rolled out Ttenbergen 09:57, 2020 January 2 (CST)

• removed the temporary query that changes lowercase incompletes to uppercase Ttenbergen 09:57, 2020 January 2 (CST)

2019-...

• see CCMDB.accdb Change Log 2019