CCMDB.accdb Change Log 2020: Difference between revisions

Change for next version:

=== future update ===

* [[Cognos Integrator forms not returning to the line you were on when you close Patient Viewer]]

{{TT |  

clear out code and wiki for [[Cognos Admitter]] and [[Cognos Discharger]] }}

* changed cross check functions that are now only relevant in cases of [[Processes around changing a PatientFollow assignment]])

* removed the buttons that opened [[Cognos Admitter]] and [[Cognos Discharger]]

* updated [[Cognos2_Ender_Service_formQuery]] to match the existing record properly, it was looking at end time when it should have looked at start time. [[User:Ttenbergen|Ttenbergen]] 12:23, 2020 December 14 (CST)

* made the links to [[Cognos Admitter]] and [[Cognos Discharger]] much smaller on [[Main Form (CCMDB.accdb)|Main Form]] in preparation for phasing these out. If I don't hear from people I will phase those out after 2020-12-06

* '''updated [[Query check_minimal_data_set_incomplete]] to no longer check for [[Arrive DtTm]] - this will not be available for pts still in the ER, and we would rather include them than wait until they leave ER'''

* added sorting buttons for (Project/Item) and (Date/Time) the tmp list in [[Patient Viewer Tab Cognos ADT]]/[[Patient Viewer Tab Cognos ADT2]]

* Removed "SBGH Internal Med / Oncology" from Cognos lists (set excluded field to true) - see [[Definition_of_a_Medicine_Service_admission#Special_cases_-_Exclusion_STB_Oncology_patients]]

* updated [[Cognos2 sub Units FormQuery query]] to include Boarding Loc as per [[s_Cognos_Units table]]

* Excluded the following services from [[Cognos Admitter]]

* added BoardingLoc column to [[s_Cognos_Units table]] to fill fields properly from [[Patient Viewer Tab Cognos ADT]] and [[Patient Viewer Tab Cognos ADT2]]

* updated [[S dispo table]] to have proper service_type for the new [[GRA_CC]] and [[HSC_CC]] entries (only used by Julie) Ttenbergen 13:22, 2020 November 12 (CST)

* updated the [["Make Service" button]] and [["Make loc" button]] in [[Patient Viewer Tab Cognos ADT]] to work again, recent change had broken them Ttenbergen 13:02, 2020 November 9 (CST)

* updated [[Query s_tmp_Boarding_Loc_date_item]] to no longer flag boarding locations that start before [[Accept DtTm]]; we will need to fine tune instructions and cross checks for that. Ttenbergen 16:39, 2020 November 6 (CST)

* updated the tmp listing in [[Patient Viewer Tab Cognos ADT]] so the item dropdown also includes items for service and transfer ready dttm. It makes for a much longer list, but since the page now includes all of those, it only makes sense for them to be there.

* excluding several other services from [[Cognos Admitter]]; see exclude column in [[s_Cognos_Services table]]; will re-include them again if they are needed e.g. to get a pt to show for the SICUs - Ttenbergen 09:25, 2020 November 4 (CST)

* updated [["Make loc" button]]  to delete the automated "no location entered" line. Ttenbergen 09:48, 2020 November 5 (CST)

* updated [[Cognos_import_processor query]] to use new "exclude" field in [[s_Cognos_Services table]] instead of verbatim exclusions

* excluded "GH Medicine-ClinAs / Clinical Assessment", "HSC Medicine-ClinAs / General", "SBGH Medicine-ClinAs / General" services from Cognos Admitter list (updated [[Cognos_integrator query]])

* fix to [[Patient Viewer Tab Cognos ADT]] listing to include some records that were missing at beginning of stay:  updated [[Cognos integrator query]] calculated value to change [[EPR Admit DtTm]] to [[Accept DtTm]], new code is  

* dx correction: retiring [[Langerhans' cell histiocytosis (Histiocytosis X, Eosinophilic granulomatosis)]], which should be collected as [[Malignancy (clonal disorder) of blood or lymphoid tissue, NOS]] instead

* in [[Cognos Admitter]], changed the "Accept DtTm equiv" field to instead show the Service Start DtTm needed for [[Service tmp entry]]. It had already almost been that, but only shown when from ER. Now it will always show the dttm. Ttenbergen 18:13, 2020 October 21 (CDT)

* Added [[Accept DtTm]] display to the top of the [[Patient Viewer]]; stripped out the year part of it to save space; the full date is still listed in the Dispo tab

* on [[Patient Viewer Tab Cognos ADT]]:  

* in [[Cognos Admitter]], removed the "Attending Provider" field

* changed [[Cognos_integrator query]] to:

* added "SubserviceDesc_Prior" to [[Cognos Patient viewer tab FormQuery query]]

* removed Attending Provider in [[Cognos Admitter FormQuery query]]

** added [[HSC_Med]], [[STB_Med]], [[GRA_CC]], [[HSC_CC]], [[STB_CC]] to [[s_dispo table]] and [[s_locations_allowed_collection table]]

** [[Query check CCI Date]], [[Query check ICD10 date]]: changed start limit from [[Arrive DtTm]] to [[Accept DtTm]] since we now collect data on pts starting at ER arrival, and the EMIP distinction is going away.

* retired cross checks:  

** change CCI and dx date cross checks to accept time in ER after process changes.

* updated [[Cognos Admitter FormQuery query]]; it was excluding new records for previously deleted patients, now it doesn't Ttenbergen 09:57, 2020 October 14 (CDT)

* Added IPAdmitDtm to [[Cognos integrator query]] and [[Cognos Admitter FormQuery query]]

* Changed laptop filter in [[Cognos Admitter FormQuery query]] to compare to IPAdmitDtm if AsgnUnitStartDtm_Current is not available so EMIPs will be included. Ttenbergen 11:21, 2020 October 9 (CDT)

* Tweak to [[Cognos Admitter]] ([[Cognos_Admitter_FormQuery query]]) to properly limit to the last two digits for [[PatientFollow Project]]/[[s_PatientFollow_distribution table]]

* Tweaking [[Cognos Admitter]] to work with [[PatientFollow Project]]

* updated [[Cognos Admitter]] ([[Cognos_Admitter_FormQuery query]]) to reduce clutter; please keep an eye on this to make sure this doesn't also hide scenarios where patient should be listed. Ttenbergen 22:45, 2020 October 8 (CDT)

* changed [[Cognos_Admitter_FormQuery query]] to use the new filtering by hospital instead of the old

* tweaked [[Cognos Admit filter table]] to hide delete patients from GRA Med Ttenbergen 10:01, 2020 October 8 (CDT)

* tweak to [[Cognos Admit filter table]] to fix listing for [[PatientFollow Project]] at GRA Ttenbergen 09:24, 2020 October 8 (CDT)

* updated [[Cognos_integrator query]] to list the inpatient discharge data if no current unit end date is available. This will provide a [[Dispo_DtTm]] for [[EMIP]]s in [[Cognos EPR Report]] components. Ttenbergen 17:48, 2020 October 6 (CDT)

* implemented [[PatientFollow Project]] filtering of [["Mine! Mine!" button]] for HSC Medicine --Ttenbergen 19:21, 2020 October 6 (CDT)

* updated [[Cognos Admitter FormQuery query]] to use [[S_PatientFollow_distribution table]] Ttenbergen 19:21, 2020 October 6 (CDT)

** added [["EMIP" button]] (next to [["Mine! Mine!" button]] to [[Cognos Admitter]])

** changed "+" button in [[Cognos Admitter]] so it will automatically populate the [[Service/Location field]]

** in [[Sub CognosImport]], increased "waitspan" to 120, ie if the email has not arrived it will try again for 120 instead of 60 min.

** updated [[Cognos processed table]], [[Cognos integrator query]] and [[Cognos Admitter FormQuery query]] to include "IsEMIP" field

** updated [[Cognos import processor query]] to include "IsEMIP" field as IsEMIP: [AsgnUnit_Current] Like "*Emergency*" And Nz([AsgnUnit_Next])="" And Not IsNull([IPDischargeDtm])

* tweaks to [[New Pt Serial helper form]] / [[Cognos Admitter]] to improve default populating of location, which was often blank before.

* updated [[Sub CognosImport]] to allow for the automation of [[Cognos data import]] to move to Pagasa's PC. Ttenbergen 22:21, 2020 August 27 (CDT)

* updated [[Cognos integrator query]] to include EMIPs properly, they were not being included because they don't have a unit arrive date, so comparing them with entries on the excluded list also excluded them. Ttenbergen 10:11, 2020 August 21 (CDT)

** you can click it in [[Patient Viewer Tab Cognos ADT]] to populate

** since I wasn't able to determine from data which pts are from ER, so it won't populate automatically from [[Cognos Admitter]] any more  

* 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.

* 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]]

* [[Cognos Discharger]]

** 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]]

* in [[Cognos Admitter]], tweaked how the "+" button works to only apply [[Accept DtTm]] when appropriate. Ttenbergen 11:34, 2020 August 5 (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

* added "s_Cognos_Services_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.

* 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.

* [[Cognos Admitter]]

* 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]]

* in [[Cognos_Admitter]]

** changed "Service Start" to [[Accept_DtTm_Equiv]]

* updated [[Sub CognosImport]] to start an email to collector about units that are not yet translated.

** [[Cognos_import_processor query]]

** [[Cognos_processed table]]

** [[Cognos_integrator query]]

* 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]]

* added query to the [["Mine! Mine!" button]] for [[Laptop identifier]]s G7, G8 in preparation for piloting [[PatientFollow Project]] at Grace Medicine Ttenbergen 22:23, 2020 July 23 (CDT)

* 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)

* 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

* 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

* updated [[s_Cognos_Units 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)

* [[Cognos Discharger]]

* [[Cognos Admitter]]

* [[Patient Viewer Tab Cognos ADT]]

* changed [[Cognos Admitter]]

* in [[Patient Viewer Tab Cognos ADT]]

* in [[Cognos Admitter]]

** fixed sorting by [[Accept DtTm]] and [[Arrive DtTm]]

* in [[Cognos Discharger]]

* [[Cognos Admitter]]

* [[Cognos Admitter]]

* [[Cognos Admitter]] -

* [[Patient Viewer Tab Cognos ADT]]

** [["Make loc" button]] will now delete the "no borrow" line if there is one.

* 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

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

** 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! '''

* in [[Patient Viewer Tab Cognos ADT]]:  

** changed order of Cognos records to be listed by Unit Start Dtm (~ our [[Arrive DtTm]]), descending

* in [[Cognos Admitter]]

* in [[Cognos Discharger]]

* in [[Patient Viewer Tab Cognos ADT]]:  

* in [[Cognos Admitter]]

* cross checks for [[Boarding Loc]]:  

* changed [[Cognos Admitter]]

** added [[Cognos_Admitter#"Mine! Mine!" button]] for better filtering

* in [[Cognos Admitter]]:  

** 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]]

** 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.

* in [[Cognos Admitter]]:

* in [[Patient Viewer Tab Cognos ADT]]: made all Dtm fields military time

* 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)

** added [[HSC_B2_C]]

* update to [[Cognos Admitter]] to include ICCS (include program "surgery"

* Additions, updates and tweaks to [[Cognos Admitter]] and [[Cognos Discharger]] and [[Patient Viewer Tab Cognos ADT]]

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

*** [[GRA_PACU]]

* 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)

** added [[Cognos_import table]] and [[Cognos_import_processor query]] Ttenbergen 15:02, 2020 April 3 (CDT)

* added [[Cognos_import table]] and [[Cognos_import_processor query]] Ttenbergen 15:02, 2020 April 3 (CDT)

* removed [[Gastrointestinal (GI) tract, chemical burn]] and [[Electrical injury]] from [[Category:Trauma]] since we would not want to enforce mechanisms on these.  

* 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.

* tweaks to [[EPR Reports Integrator]] as discussed with Michelle

[[Category: Change Logs CCMDB]]