CCMDB.accdb Change Log 2020: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
 
(104 intermediate revisions by the same user not shown)
Line 3: Line 3:


== Versions ==
== Versions ==
Change for next version:
=== 2021 ===
See [[CCMDB.accdb Change Log 2021]]


=== future update ===
=== 2020-12-31 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 19:56, 2021 January 1 (CST)


'''To do'''
Changes collectors need to know about:
* need to find out if I can remove [[STB_CC]] ie if it is not in CFE
* [[CE]]: tweaked query that had some troubleshooting code left in it
* excluded services from [[CSS]]:
** HSC Internal Med / Respiratory
** HSC Oncology/Bone marrow transplant now excluded
** HSC Oncology/radiation now excluded
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* NONE
 
=== 2020-12-24 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 16:06, 2020 December 31 (CST)
 
Changes collectors need to know about:
* [[CSS]]:
** excluded from the list
*** services that have already been entered with that service and time
*** services that fall outside of the admission dttm range of a matched record.
** added profile start dttm and dispo dttm to make it easier to see which existing record an un-entered service is related to
** '''added a [[Cognos2_Service_Starter#W.2B_toggle | "W+" toggle''']] to filter to white pluses, ie service listings for pts who do not currently have any records on this laptop
* [[Patient Viewer Tab Cognos ADT2]]:
** '''added a [[Patient copier button]] [[image:Patient Copy button.png]]''' to make it easier to enter a new profile if a record was opened from [[CSS]] only to find that the pt had left your unit and then returned
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* added ClientVisitGUID field field to [[Cognos2_Services table]], [[Cognos2_Units table]], [[Cognos2_OneTime table]]
* updated to add the ClientVisitGUID field: [[Cognos2_import_Cognos2_OneTime query]], [[Cognos3_import_Cognos2_Services query]], [[Cognos3_import_Cognos2_Units query]]
 
=== 2020-12-23-1 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 10:08, 2020 December 24 (CST)
 
Changes collectors need to know about:
* NONE
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* excluded STB from checks until 2020-03-31 because their current change in PatientFollow means they would get tons of errors
** [[Check function preAdmit NE Location]]
** [[Check function previous NE Location]]
** [[Check function location NE dispo]]
 
=== 2020-12-23 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 12:39, 2020 December 23 (CST)
 
Changes collectors need to know about:
* NONE
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* added Cognos importer button to [[CSS]] as a backup so someone else can import Cognos as needed; no process for this yet
* changed cross check functions that are now only relevant in cases of [[Processes around changing a PatientFollow assignment]])
** [[Check function preAdmit NE Location]]
** [[Check function previous NE Location]]
** [[Check function location NE dispo]]
 
=== 2020-12-17 ===
was rolled out, not sure when exactly [[User:Ttenbergen|Ttenbergen]] 11:11, 2020 December 23 (CST)
 
Changes collectors need to know about:
* [[CSS]] - there were two buttons to view excludeds; the one on the top works and is still there, the second one just under the column labels ("view excluded chart-service records") didn't work. We don't need two, so I removed that one
* [[Patient Viewer Tab CCI Pick]] - added a secondary sort order so records won't be random after the primary sort to the CCI and px_date sorting buttons. Before this, sorting/grouping CCI items would have led to random date sort. With this change, sorting by item will secondary sort by date, and sorting by date will secondary sort by item.
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* restored "GRA - ER" entry in [[s_dispo table]], had accidentally got deleted
 
=== 2020-12-15 ===
rolled last night...
 
Changes collectors need to know about:
* marked "GH Surgery / ACSS" as excluded in [[S Cognos Services table]] at the request of GRA CC collectors [[User:Ttenbergen|Ttenbergen]] 15:52, 2020 December 15 (CST)
* changed [[Boarding Loc]], [[S dispo table]], [[S Cognos Units table]] for [[Change of GRA location names from "our" names to EPR/Cognos names]]
* [[Parked in ER]]: inactivated in [[S dispo table]] the entries that had become legacy some time ago: "GRA - ER (parked)", "HSC - ER (parked)", "STB - ER (parked)" [[User:Ttenbergen|Ttenbergen]] 20:59, 2020 December 15 (CST)
* added hover hint and description for the "TISS" filter button in [[Patient Viewer Tab CCI Pick]]
* made [[Accept Loc Park]] inactive [[User:Ttenbergen|Ttenbergen]] 09:22, 2020 December 16 (CST)
* added a "CCI" button to [[Patient Viewer Tab CCI Pick]] to help with [[Change to collect TISS data in CCI Picklist]] by filtering only to CCI items (ie to hide the TISS ones)
* fixed "set previous location to pre-admit" button on [[Patient Viewer Tab Cognos ADT2]], it was not doing anything
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* [[Cognos2 Ender]] - somehow in one of the last versions, this started to include records that had already been sent; updated query so previously sent records will no longer be included. [[User:Ttenbergen|Ttenbergen]] 15:45, 2020 December 16 (CST)
 
=== 2020-12-14-3 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 15:51, 2020 December 15 (CST)
Changes collectors need to know about:
* added to [[Service tmp entry]] list:
** "SBGH Critical Care / Medicine"
** "HSC Surgery / Trauma"
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* removed the size "restore" I had added to the closing of the patient viewer (after adding that viewer should maximize) - will need to see if removing it causes as many complaints...
* fixed bug in [[Cognos2 Ender]] where clicking binocs to open a pt would give a Pat_ID error.
 
=== 2020-12-14-2 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 14:02, 2020 December 14 (CST)
 
Changes collectors need to know about:
* added [[Prone positioning]] to [[CCI Picklist]]
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* further tweaked Cognos2_Ender_Service_formQuery to match the existing record properly, it was matching by item when it should only match by end dttm
 
===2020-12-14===
rolled out [[User:Ttenbergen|Ttenbergen]] 13:12, 2020 December 14 (CST)
 
Changes collectors need to know about:
* removed the buttons that opened ''Cognos Admitter'' and ''Cognos Discharger''
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* 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)
 
=== 2020-12-09 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 18:52, 2020 December 10 (CST)
 
* Changes collectors need to know about:
** tweaked the size of some fields in [[Patient Viewer]] so the whole thing, maximized, will fit on the screen without scrolling (Thanks to Pam for flagging this! ) [[User:Ttenbergen|Ttenbergen]] 17:26, 2020 December 9 (CST)
 
* Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
** added locations for [[Change of GRA location names from "our" names to EPR/Cognos names]]; change not scheduled yet
** removed a refresh in "close with updates" button on patient viewer that wasn't necessary and that was causing [[Sorting in PatientList breaks when some Cognos Entries are done]]
 
=== 2020-12-04 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 10:46, 2020 December 4 (CST)


=== 2020-11-27 ===
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
not rolled out yet [[User:Ttenbergen|Ttenbergen]] 22:19, 2020 November 26 (CST)
* fixed error for TISS40 button


'''To do'''
=== 2020-12-02 ===
* find out if I can remove [[STB_CC]] ie if it is not in CFE
rolled out [[User:Ttenbergen|Ttenbergen]] 12:15, 2020 December 3 (CST)
* [[Cognos Integrator forms not returning to the line you were on when you close Patient Viewer]]


Changes collectors need to know about:
Changes collectors need to know about:
* 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
* [[Change to collect TISS data in CCI Picklist]]
** added buttons for remaining TISS items to [[Patient Viewer Tab CCI Pick]]; made invisible buttons for items not currently collected
** retired the CCI Picklist entries for items on [[TISS Item List] not currently collected
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
*
*


Changes collectors probably don't care about:
=== 2020-12-01-1 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 22:54, 2020 December 1 (CST)
 
Changes collectors need to know about:
* updated [[Patient Viewer Tab Cognos ADT2]] to show any unit and service info available for that admission (used to just show those during the admission) so any possible previous and next service will be available for [[Previous Location]] and [[Dispo]] (didn't automate entering any of that, but at least it's visible
** lines during this admission will be green, lines outside this admission will be an unsaturated red. [[User:Ttenbergen|Ttenbergen]] 22:48, 2020 December 1 (CST)
* updated [[Cognos2 Ender]] so it will no longer wrongly show service entries that would have been part of a previous or future profile for the same pt. [[User:Ttenbergen|Ttenbergen]] 22:48, 2020 December 1 (CST)
* updated [[Patient Viewer Tab Tmp]] - using either of the two sorting buttons was making it impossible to enter new lines
 
=== 2020-12-01 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 11:02, 2020 December 1 (CST)
 
Changes collectors need to know about:
* [[Change to collect TISS data in CCI Picklist]]:
** added a TISS filtering button to [[Patient Viewer Tab CCI Pick]]
** added buttons 12-21
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated [[s_locations_allowed_collection table]] so all STB ICU laptops can now enter all STB ICU [[Service Location]]s
 
=== 2020-11-30 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 19:59, 2020 November 30 (CST)
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* fixed [[Query s tmp Boarding Loc date item]] to eliminate false positives, no idea where those suddenly came from. [[User:Ttenbergen|Ttenbergen]] 19:56, 2020 November 30 (CST)
 
=== 2020-11-27 ===
was it rolled out? I have no idea... if not it will roll with the next version.
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* made new TISS items on [[L CCI Picklist subform]] invisible for Medicine laptops [[User:Ttenbergen|Ttenbergen]] 09:52, 2020 November 30 (CST)
* made new TISS items on [[L CCI Picklist subform]] invisible for Medicine laptops [[User:Ttenbergen|Ttenbergen]] 09:52, 2020 November 30 (CST)
* updated [[Cognos2 Unit Starter]] to include units just before the beginning and just after the end of the currently listed admission; the previous filter would have not shown them if an arrive or dispo dttm had already been entered. [[User:Ttenbergen|Ttenbergen]] 10:57, 2020 November 30 (CST)


=== 2020-11-26 ===
=== 2020-11-26 ===
Line 27: Line 180:


Changes collectors need to know about:
Changes collectors need to know about:
* '''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'''
* '''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 more buttons (1-12) to test for [[Change to collect TISS data in CCI Picklist]], please comment there to tell if this works
* added more buttons (1-12) to test for [[Change to collect TISS data in CCI Picklist]], please comment there to tell if this works
* updated [[Cognos2 Ender]] to exclude some extra lines that should not have been listed  
* updated [[Cognos2 Ender]] to exclude some extra lines that should not have been listed  
* Updated the Service End DtTm field in [[Patient Viewer Tab Cognos ADT2]] to populate [[Dispo DtTm]] when clicked; e.g. for EMIPs where you can’t use the Unit End DtTm because they have no unit entry
* Updated the Service End DtTm field in [[Patient Viewer Tab Cognos ADT2]] to populate [[Dispo DtTm]] when clicked; e.g. for EMIPs where you can’t use the Unit End DtTm because they have no unit entry
* Updated the refreshing function that runs when closing [[Patient Viewer]] to refresh the new [[Cognos2]] lists, so that the new status is reflected on the lists (different colour in [[Cognos2 Service Starter]], and off the list in [[Cognos2 Unit Starter]] and [[Cognos2 Ender]])
* Updated the refreshing function that runs when closing [[Patient Viewer]] to refresh the new [[Cognos2]] lists, so that the new status is reflected on the lists (different colour in [[Cognos2 Service Starter]], and off the list in [[Cognos2 Unit Starter]] and [[Cognos2 Ender]])
* added sorting buttons for (Project/Item) and (Date/Time) the tmp list in [[Patient Viewer Tab Cognos ADT]]/[[Patient Viewer Tab Cognos ADT2]]
* 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]]
* Removed "SBGH Internal Med / Oncology" from Cognos lists (set excluded field to true) - see [[Definition_of_a_Medicine_Laptop_Admission#Special_cases_-_Exclusion_STB_Oncology_patients]]


=== 2020-11-25 ===
=== 2020-11-25 ===
Line 56: Line 209:


Changes collectors probably don't care about:  
Changes collectors probably don't care about:  
* updated [[Cognos2 sub Units FormQuery query]] to include Boarding Loc as per [[s_Cognos_Units table]]
* updated Cognos2 sub Units FormQuery query to include Boarding Loc as per [[s_Cognos_Units table]]


=== 2020-11-24-1 ===
=== 2020-11-24-1 ===
Line 83: Line 236:
** see [[Processes around changing a PatientFollow assignment]] for transition plan  
** see [[Processes around changing a PatientFollow assignment]] for transition plan  


* Excluded the following services from [[Cognos Admitter]]
* Excluded the following services from ''Cognos Admitter''
**GH Critical Care / Clinical Assessment
**GH Critical Care / Clinical Assessment
**GH Internal Med / Clinical Assessment
**GH Internal Med / Clinical Assessment
Line 107: Line 260:
* added MISI column to [[s_Cognos_Services table]] to break to MICU, SICU, CICU, ACCU
* added MISI column to [[s_Cognos_Services table]] to break to MICU, SICU, CICU, ACCU
* update Cognos2_matcher in order to properly filter by patientFollow model
* update Cognos2_matcher in order to properly filter by patientFollow model
* added BoardingLoc column to [[s_Cognos_Units table]] to fill fields properly from [[Patient Viewer Tab Cognos ADT]] and [[Patient Viewer Tab Cognos ADT2]]
* added BoardingLoc column to [[s_Cognos_Units table]] to fill fields properly from Patient Viewer Tab Cognos ADT and [[Patient Viewer Tab Cognos ADT2]]


=== 2020-11-17 ===
=== 2020-11-17 ===
Line 129: Line 282:


Changes collectors probably don't care about:
Changes collectors probably don't care about:
* 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 [[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)


=== 2020-11-09 ===
=== 2020-11-09 ===
Line 135: Line 288:


Changes collectors should know about:
Changes collectors should know about:
* 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 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)
* added "HSC Critical Care / Trauma" to allowed entries for [[Service tmp entry]] Ttenbergen 14:47, 2020 November 9 (CST)
* added "HSC Critical Care / Trauma" to allowed entries for [[Service tmp entry]] Ttenbergen 14:47, 2020 November 9 (CST)


Line 147: Line 300:
** HSC - ICU boarding
** HSC - ICU boarding
** STB - ICU boarding
** STB - ICU boarding
* 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 [[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)


Changes collectors probably don't care about:
Changes collectors probably don't care about:
Line 180: Line 333:
rolled Ttenbergen 15:03, 2020 November 5 (CST)
rolled Ttenbergen 15:03, 2020 November 5 (CST)
Changes collectors should care about:
Changes collectors should care about:
* 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.
* 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.
* code required to move to [[CCMDB data.mdb Change Log#2020-11-05]]
* code required to move to [[CCMDB data.mdb Change Log#2020-11-05]]


Line 189: Line 342:
rolled out Ttenbergen 13:00, 2020 November 5 (CST)
rolled out Ttenbergen 13:00, 2020 November 5 (CST)
Changes Collectors should care about
Changes Collectors should care about
* 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)
* 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)
* changed project field of tmp subform in Cognos ADT tab to be a dropdown with options Boarding Loc, Service, Transfer Ready DtTm
* changed project field of tmp subform in Cognos ADT tab to be a dropdown with options Boarding Loc, Service, Transfer Ready DtTm
* updated [["Make loc" button]]  to delete the automated "no location entered" line. Ttenbergen 09:48, 2020 November 5 (CST)
* updated [["make loc" button]]  to delete the automated "no location entered" line. Ttenbergen 09:48, 2020 November 5 (CST)


[[Cognos2]] stuff (this isn't visible to collectors yet, coming soon
[[Cognos2]] stuff (this isn't visible to collectors yet, coming soon
Line 204: Line 357:
* updated and renamed "Cognos dispo translator additions needed query" to [[s_Cognos_Units_additions_needed query]]
* updated and renamed "Cognos dispo translator additions needed query" to [[s_Cognos_Units_additions_needed query]]
* updated and renamed "Cognos_SubServices_additions_needed" to [[s_Cognos_Services_additions_needed query]]
* updated and renamed "Cognos_SubServices_additions_needed" to [[s_Cognos_Services_additions_needed query]]
* updated [[Cognos_import_processor query]] to use new "exclude" field in [[s_Cognos_Services table]] instead of verbatim exclusions
* updated ''Cognos import processor query'' to use new "exclude" field in [[s_Cognos_Services table]] instead of verbatim exclusions


=== 2020-10-28-2 ===
=== 2020-10-28-2 ===
Line 211: Line 364:
Changes Collectors should care about
Changes Collectors should care about
* restored "no borrow" for [[Boarding Loc]]; it will eventually go away but needs to be available until old patients have been discharged
* restored "no borrow" for [[Boarding Loc]]; it will eventually go away but needs to be available until old patients have been discharged
* excluded "GH Medicine-ClinAs / Clinical Assessment", "HSC Medicine-ClinAs / General", "SBGH Medicine-ClinAs / General" services from Cognos Admitter list (updated [[Cognos_integrator query]])
* excluded "GH Medicine-ClinAs / Clinical Assessment", "HSC Medicine-ClinAs / General", "SBGH Medicine-ClinAs / General" services from Cognos Admitter list (updated ''Cognos_integrator query'')


Changes Collectors probably don't care about
Changes Collectors probably don't care about
Line 226: Line 379:


Changes collectors probably don't need to know about:  
Changes collectors probably don't need to know about:  
* 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  
* 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  
<pre>
<pre>
impossible_date_combination:   
impossible_date_combination:   
Line 241: Line 394:
**MSC_Med --> 210
**MSC_Med --> 210
**STB_Med --> 220
**STB_Med --> 220
* 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
* 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
* made [[Boarding Loc]] "GRA_ER" available for GRA critical care laptop, it had been limited to med laptop accidentally when we reconciled the duplicate for that at GRA
* made [[Boarding Loc]] "GRA_ER" available for GRA critical care laptop, it had been limited to med laptop accidentally when we reconciled the duplicate for that at GRA
* confirmed that [[query s_tmp_Boarding_Loc_date_item]] is correct to not allow boarding loc entry for home location for Med; if patients are entered with e.g. HSC_Med then this doesn't happen.
* confirmed that [[query s_tmp_Boarding_Loc_date_item]] is correct to not allow boarding loc entry for home location for Med; if patients are entered with e.g. HSC_Med then this doesn't happen.
Line 263: Line 416:
** added filters so boarding locations that are only applicable to Med or only to CC will only be visible on those programs' laptops; if I filtered them too aggressively and am now hiding boarding locs you need let me know. Ttenbergen 14:24, 2020 October 21 (CDT)
** added filters so boarding locations that are only applicable to Med or only to CC will only be visible on those programs' laptops; if I filtered them too aggressively and am now hiding boarding locs you need let me know. Ttenbergen 14:24, 2020 October 21 (CDT)
* [[Maltreatment]] - code added to [[s_ICD10 table]], [[s_ICD10_Categories table]]
* [[Maltreatment]] - code added to [[s_ICD10 table]], [[s_ICD10_Categories table]]
* 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)
* 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)


=== 2020-10-21 ===
=== 2020-10-21 ===
Line 274: Line 427:


Changes collectors probably care about:
Changes collectors probably care about:
* 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
* 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]]:  
* on Patient Viewer Tab Cognos ADT:  
** made some fonts smaller to list more lines; I can reverse this, just really trying to fit more on that screen
** made some fonts smaller to list more lines; I can reverse this, just really trying to fit more on that screen
** changed '''top part of tab'''
** changed '''top part of tab'''
Line 290: Line 443:
*** removed [[Visit Admit DtTm field]] from here - the Cognos section will only list a row if it has the same Visit admit DtTm, so this will always show the same thing, so useless; the actual Visit Admit DtTm of the record is still shown in the top section
*** removed [[Visit Admit DtTm field]] from here - the Cognos section will only list a row if it has the same Visit admit DtTm, so this will always show the same thing, so useless; the actual Visit Admit DtTm of the record is still shown in the top section
*** remoevd the "chart matched" entry because it would always show this chart, so useless
*** remoevd the "chart matched" entry because it would always show this chart, so useless
* in [[Cognos Admitter]], removed the "Attending Provider" field
* in ''Cognos Admitter'', removed the "Attending Provider" field


Changes collectors probably don't care about:  
Changes collectors probably don't care about:  
* removed duplicate entry for "STB_E6_B" for [[Boarding Loc]] in [[S tmp table]] Ttenbergen 15:07, 2020 October 20 (CDT)
* removed duplicate entry for "STB_E6_B" for [[Boarding Loc]] in [[S tmp table]] Ttenbergen 15:07, 2020 October 20 (CDT)
* changed [[Cognos_integrator query]] to:
* changed ''Cognos_integrator query'' to:
** no longer list "attending provider", and no longer list extra lines for when this changes Ttenbergen 23:24, 2020 October 20 (CDT)
** no longer list "attending provider", and no longer list extra lines for when this changes Ttenbergen 23:24, 2020 October 20 (CDT)
** added "SubserviceDesc_Prior", no idea why that wasn't in there before Ttenbergen 23:36, 2020 October 20 (CDT)
** added "SubserviceDesc_Prior", no idea why that wasn't in there before Ttenbergen 23:36, 2020 October 20 (CDT)
* added "SubserviceDesc_Prior" to [[Cognos Patient viewer tab FormQuery query]]
* added "SubserviceDesc_Prior" to ''Cognos Patient viewer tab FormQuery query''
* removed Attending Provider in [[Cognos Admitter FormQuery query]]
* removed Attending Provider in ''Cognos Admitter FormQuery query''


=== 2020-10-19 ===
=== 2020-10-19 ===
Line 327: Line 480:
Changes collectors will want to know about. No really, you need to know about these or you will be correcting entries!
Changes collectors will want to know about. No really, you need to know about these or you will be correcting entries!
* Changes for [[Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry]]:  
* Changes for [[Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry]]:  
** added [[HSC_Med]], [[STB_Med]], [[GRA_CC]], [[HSC_CC]], [[STB_CC]] to [[s_dispo table]] and [[s_locations_allowed_collection table]]
** added [[HSC_Med]], [[STB_Med]], [[GRA_CC]], ''HSC_CC'', [[STB_CC]] to [[s_dispo table]] and [[s_locations_allowed_collection table]]
** added "Transfer Ready DtTm" to [[S tmp table]] to implement [[Transfer Ready DtTm tmp entry]]
** added "Transfer Ready DtTm" to [[S tmp table]] to implement [[Transfer Ready DtTm tmp entry]]
** added "Service" entries to [[s_tmp table]] to implement [[Service tmp entry]]
** added "Service" entries to [[s_tmp table]] to implement [[Service tmp entry]]
** [[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.
** [[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.


Changes collectors don't need to know about
Changes collectors don't need to know about
Line 352: Line 505:
=== 2020-10-14 ===
=== 2020-10-14 ===
rolled out Ttenbergen 10:05, 2020 October 14 (CDT)
rolled out Ttenbergen 10:05, 2020 October 14 (CDT)
* 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)
* 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)


=== 2020-10-13 ===
=== 2020-10-13 ===
Line 363: Line 516:
rolled Ttenbergen 11:59, 2020 October 9 (CDT)
rolled Ttenbergen 11:59, 2020 October 9 (CDT)
Changes collectors probably don't care about...  
Changes collectors probably don't care about...  
* Added IPAdmitDtm to [[Cognos integrator query]] and [[Cognos Admitter FormQuery query]]
* 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)
* 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)


=== 2020-10-09-2 ===
=== 2020-10-09-2 ===
Line 372: Line 525:
=== 2020-10-09 ===
=== 2020-10-09 ===
rolled out Ttenbergen 09:54, 2020 October 9 (CDT)
rolled out Ttenbergen 09:54, 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]]
* Tweak to ''Cognos Admitter'' (Cognos_Admitter_FormQuery query) to properly limit to the last two digits for [[PatientFollow Project]]/[[s_PatientFollow_distribution table]]


=== 2020-10-08-2 ===
=== 2020-10-08-2 ===
rolled out Ttenbergen 00:23, 2020 October 9 (CDT)
rolled out Ttenbergen 00:23, 2020 October 9 (CDT)
* Tweaking [[Cognos Admitter]] to work with [[PatientFollow Project]]
* 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)
* 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)
** to no longer include deleted records
** to no longer include deleted records
** only include records as designated to be collected by collector as per  (for sites not using this yet, that will mean all patients as before)
** only include records as designated to be collected by collector as per  (for sites not using this yet, that will mean all patients as before)
Line 396: Line 549:
* chagned structure of [[S laptops table]] to include hosp field
* chagned structure of [[S laptops table]] to include hosp field
* changed structure of [[s_PatientFollow_distribution table]] to no longer include hosp field
* changed structure of [[s_PatientFollow_distribution table]] to no longer include hosp field
* changed [[Cognos_Admitter_FormQuery query]] to use the new filtering by hospital instead of the old
* changed Cognos_Admitter_FormQuery query to use the new filtering by hospital instead of the old


=== 2020-10-08-1 ===
=== 2020-10-08-1 ===
rolled out Ttenbergen 13:55, 2020 October 8 (CDT)
rolled out Ttenbergen 13:55, 2020 October 8 (CDT)
* tweaked [[Cognos Admit filter table]] to hide delete patients from GRA Med Ttenbergen 10:01, 2020 October 8 (CDT)
* tweaked Cognos Admit filter table to hide delete patients from GRA Med Ttenbergen 10:01, 2020 October 8 (CDT)
* re-imported Cognos data since I rolled out a version with old data accidentally. Ttenbergen 13:55, 2020 October 8 (CDT)
* re-imported Cognos data since I rolled out a version with old data accidentally. Ttenbergen 13:55, 2020 October 8 (CDT)


=== 2020-10-08 ===
=== 2020-10-08 ===
rolled out Ttenbergen 09:27, 2020 October 8 (CDT)
rolled out Ttenbergen 09:27, 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)
* tweak to Cognos Admit filter table to fix listing for [[PatientFollow Project]] at GRA Ttenbergen 09:24, 2020 October 8 (CDT)


=== 2020-10-07 ===
=== 2020-10-07 ===
Line 415: Line 568:
Changes collectors should care about:  
Changes collectors should care about:  
* updated colour for GRA_S3 in [[S dispo table]] as requested by GRA Med collectors Ttenbergen 14:17, 2020 October 1 (CDT)
* updated colour for GRA_S3 in [[S dispo table]] as requested by GRA Med collectors Ttenbergen 14:17, 2020 October 1 (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)
* 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)
* implemented [[PatientFollow Project]] filtering of "Mine! Mine!" button for HSC Medicine --Ttenbergen 19:21, 2020 October 6 (CDT)
* changed the [[PatientFollow Project]] filter of GRA Med to use the same model as well, had initially set up a simplified version but that would not have worked to ever change distribution by date. Ttenbergen 21:58, 2020 October 6 (CDT)
* changed the [[PatientFollow Project]] filter of GRA Med to use the same model as well, had initially set up a simplified version but that would not have worked to ever change distribution by date. Ttenbergen 21:58, 2020 October 6 (CDT)


Line 422: Line 575:
* deleted old undocumented queries "patientFollow_copy_L_Log" and "patientFollow_copy_L_ICD10" Ttenbergen 18:40, 2020 October 6 (CDT)
* deleted old undocumented queries "patientFollow_copy_L_Log" and "patientFollow_copy_L_ICD10" Ttenbergen 18:40, 2020 October 6 (CDT)
* updated [[S PatientFollow distribution table]] with Patient_follow distribution split for GRA and HSC Ttenbergen 19:21, 2020 October 6 (CDT)
* updated [[S PatientFollow distribution table]] with Patient_follow distribution split for GRA and HSC 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)
* updated ''Cognos Admitter FormQuery query'' to use [[S_PatientFollow_distribution table]] Ttenbergen 19:21, 2020 October 6 (CDT)


=== 2020-09-24 ===
=== 2020-09-24 ===
Line 434: Line 587:
** retired [[Tobacco use/abuse, chronic]]
** retired [[Tobacco use/abuse, chronic]]
** changed order of service locations dropdowns for G7 and G8 latops in [[s_locations_allowed_collection table]]
** changed order of service locations dropdowns for G7 and G8 latops in [[s_locations_allowed_collection table]]
** added [["EMIP" button]] (next to [["Mine! Mine!" button]] to [[Cognos Admitter]])
** 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]]
** changed "+" button in ''Cognos Admitter'' so it will automatically populate the [[Service/Location field]]


* Changes collectors probably don't care about:
* Changes collectors probably don't care about:
** reverted to version 2020-08-28-02 because current one required password on close
** reverted to version 2020-08-28-02 because current one required password on close
** re-did: checked off ACTIVE for HSC A3S stepdown in [[s_dispo table]]
** re-did: checked off ACTIVE for HSC A3S stepdown in [[s_dispo table]]
** in [[Sub CognosImport]], increased "waitspan" to 120, ie if the email has not arrived it will try again for 120 instead of 60 min.
** in [[Function 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_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])
** updated ''Cognos import processor query'' to include "IsEMIP" field as IsEMIP: [AsgnUnit_Current] Like "*Emergency*" And Nz([AsgnUnit_Next])="" And Not IsNull([IPDischargeDtm])


=== 2020-09-01 ===
=== 2020-09-01 ===
Line 451: Line 604:
was rolled out last night Ttenbergen 09:27, 2020 August 31 (CDT)
was rolled out last night Ttenbergen 09:27, 2020 August 31 (CDT)
* tweaks to the function that requeries open forms when Cognos-related data is updated or entered.  
* tweaks to the function that requeries open forms when Cognos-related data is updated or entered.  
* tweaks to [[New Pt Serial helper form]] / [[Cognos Admitter]] to improve default populating of location, which was often blank before.
* tweaks to [[New Pt Serial helper form]] / ''Cognos Admitter'' to improve default populating of location, which was often blank before.


=== 2020-08-27 ===
=== 2020-08-27 ===
Line 457: Line 610:
Changes Collectors probably don't care about  
Changes Collectors probably don't care about  
* Drs Office for [[Accept Loc Park]]: updated [[Check Accept Loc Park|query s_tmp_Accept_Log_Park_tmp_no_prev]] to accept this new value
* Drs Office for [[Accept Loc Park]]: updated [[Check Accept Loc Park|query s_tmp_Accept_Log_Park_tmp_no_prev]] to accept this new value
* 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 [[Function CognosImport]] to allow for the automation of [[Cognos data import]] to move to Pagasa's PC. Ttenbergen 22:21, 2020 August 27 (CDT)


=== 2020-08-24 ===
=== 2020-08-24 ===
Line 466: Line 619:
rolled out Ttenbergen 10:15, 2020 August 21 (CDT)
rolled out Ttenbergen 10:15, 2020 August 21 (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)
* 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)


=== 2020-08-17 ===
=== 2020-08-17 ===
Line 511: Line 664:
* tweaked the Accept_Dtm_equiv field in Cognos:  
* tweaked the Accept_Dtm_equiv field in Cognos:  
** it will now always show the IPAdmit_Dtm
** it will now always show the IPAdmit_Dtm
** you can click it in [[Patient Viewer Tab Cognos ADT]] to populate
** 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  
** 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 the forms updating that happens after certain cognos transactions to return to the same spot on the form to also restore same sort and filter Ttenbergen 15:14, 2020 August 12 (CDT)
* tweaked the forms updating that happens after certain cognos transactions to return to the same spot on the form to also restore same sort and filter Ttenbergen 15:14, 2020 August 12 (CDT)
* tweaked Cognos data importer to only look for a file from within the last 24hrs, so it picks the right one if there are several in the inbox. Ttenbergen 15:50, 2020 August 12 (CDT)
* tweaked Cognos data importer to only look for a file from within the last 24hrs, so it picks the right one if there are several in the inbox. Ttenbergen 15:50, 2020 August 12 (CDT)
Line 527: Line 680:
=== 2020-08-07-2 ===
=== 2020-08-07-2 ===
was rolled out with latest Cognos Data this morning Ttenbergen 09:31, 2020 August 12 (CDT)
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.
* 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 ===
=== 2020-08-07 ===
not rolled yet Ttenbergen 10:07, 2020 August 7 (CDT)
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 ''Cognos Discharger'', Cognos Discharger FormQuery query
* excluded impossible time combinations from [[Patient Viewer Tab Cognos ADT]], [[Cognos Patient viewer tab 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)
* made available [[HSC_HOBS]] Ttenbergen 13:46, 2020 August 7 (CDT)


=== 2020-08-06-2 ===
=== 2020-08-06-2 ===
rolled out Ttenbergen 07:48, 2020 August 7 (CDT)
rolled out Ttenbergen 07:48, 2020 August 7 (CDT)
* [[Cognos Discharger]]
* ''Cognos Discharger''
** changed default setting filter
** 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]]
** 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.
** 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.


Line 552: Line 705:
=== 2020-08-05-1 ===
=== 2020-08-05-1 ===
rolled out Ttenbergen 11:38, 2020 August 5 (CDT)
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)
* 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 ===
=== 2020-08-05 ===
Line 561: Line 714:
rolled out Ttenbergen 08:22, 2020 August 5 (CDT)
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)
* 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.  
* updated [[Function 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
* tweaked ''Cognos import processor query'' to fix whether "Accept_DtTm_Equiv" gets populated


=== 2020-07-30 ===
=== 2020-07-30 ===
Line 568: Line 721:
* Added [[HSC_HOBS]] for when B2 moves there 2020-08-07
* 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)
* 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 "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)
* added "s_Cognos_Services_additions_needed query" and included it in [[Function 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.
* 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)
* added [[Laptop identifier]] to [["generate email" button]] Ttenbergen 21:41, 2020 July 30 (CDT)
* fixed [[Cognos Admitter]]
* fixed ''Cognos Admitter''
** to actually use [[Accept_DtTm_Equiv]] that was added two versions ago but never set up right.  
** 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.
** 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 ===
=== 2020-07-29 ===
rolled out Ttenbergen 10:55, 2020 July 29 (CDT)
rolled out Ttenbergen 10:55, 2020 July 29 (CDT)
* [[Cognos Admitter]]
* ''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)
** '''"+" 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]]
** added a button at the right end of the line that will open [[Previous_entry form]]
Line 587: Line 740:
Changes collectors will probably want to know about:  
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)]]
* 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
* 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]]
* in Patient Viewer Tab Cognos ADT
** changed "Service Start" to [[Accept_DtTm_Equiv]]
** 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  
** 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
bottom, to be consistent with the layout at the top
** changed default sort order to AsgnUnit_StartDtm (Cognos counterpart of Arrive_DtTm)
** changed default sort order to AsgnUnit_StartDtm (Cognos counterpart of Arrive_DtTm)
* in [[Cognos_Admitter]]
* in Cognos_Admitter
** changed "Service Start" to [[Accept_DtTm_Equiv]]
** changed "Service Start" to "Accept_DtTm_Equiv"


Changes collectors probably don't care about:
Changes collectors probably don't care about:
* updated [[Sub CognosImport]] to start an email to collector about units that are not yet translated.
* updated [[Function CognosImport]] to start an email to collector about units that are not yet translated.
* added field "IPAdmitDtm" to  
* added field "IPAdmitDtm" to  
** [[Cognos_import_processor query]]
** ''Cognos import processor query''
** [[Cognos_processed table]]
** ''Cognos_processed table''
** [[Cognos_integrator query]]
** ''Cognos_integrator query''
* added field "isER" to [[s_Cognos_Units table]]
* added field "isER" to [[s_Cognos_Units table]]
* added [[Accept_DtTm_Equiv]] to  
* added "Accept_DtTm_Equiv" to  
** [[Cognos_integrator query]]
** ''Cognos_integrator query''
** [[Cognos_Admitter_FormQuery query]]
** Cognos_Admitter_FormQuery query
** [[Cognos_Patient_viewer_tab_FormQuery query]]
** ''Cognos Patient viewer tab FormQuery query''
* changed forms to use new [[Accept_DtTm_Equiv]]
* changed forms to use new "Accept_DtTm_Equiv"
** [[Cognos_Admitter]]
** Cognos_Admitter
** [[Patient Viewer Tab Cognos ADT]]
** Patient Viewer Tab Cognos ADT


* deleted unused "query Cognos_FormQuery", cognos_tmp table
* deleted unused "query Cognos_FormQuery", cognos_tmp table
Line 620: Line 773:
** added wiki links on to all components of that form
** added wiki links on to all components of that form
* [[Settings (CCMBD.mdb)]] - added wiki links on to all components
* [[Settings (CCMBD.mdb)]] - added wiki links on to all components
* 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)
* 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)
** G7 will filter to "LastTwo >= 0 AND LastTwo <= 49"
** G7 will filter to "LastTwo >= 0 AND LastTwo <= 49"
** G8 will filter to "LastTwo >= 50 AND LastTwo <= 99"
** G8 will filter to "LastTwo >= 50 AND LastTwo <= 99"
Changes collectors might not care about:  
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)
* 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)
* 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 ===
=== 2020-07-13 ===
rolled out Ttenbergen 18:36, 2020 July 13 (CDT)
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 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)
* 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)


Line 635: Line 788:
rolled out Ttenbergen 07:25, 2020 July 9 (CDT)
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.
* 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
* 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
* 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 ===
=== 2020-07-02 ===
Line 647: Line 800:
* added [[Other specified infectious agents as the cause of diseases classified by other ICD10 code]] to [[S ICD10 table]]
* 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:  
Changes collectors probably don't care about:  
* updated [[s_Cognos_Units table]] to improve automatic detection of equivalent units in [[Cognos Admitter]], [[Cognos Discharger]] and [[Patient Viewer Tab Cognos ADT]]
* 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)
* created "Cognos_dispo_translator_additions_needed query" and updated [[Function 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 ===
=== 2020-06-29 ===
rolled out Ttenbergen 14:16, 2020 June 30 (CDT)
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]])
* 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]]
* ''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)
** 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
** added ToLoc summary
* [[Cognos Admitter]]
* ''Cognos Admitter''
** updated so excluded patients are actually excluded, this was not working in most recent version
** updated so excluded patients are actually excluded, this was not working in most recent version
* [[Patient Viewer Tab Cognos ADT]]
* Patient Viewer Tab Cognos ADT
** added To(summary) field
** 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)
** 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)
Line 666: Line 819:
Changes collectors probably want to know about:  
Changes collectors probably want to know about:  
* [[TISS form audit]] is over, disabled
* [[TISS form audit]] is over, disabled
* changed [[Cognos Admitter]]
* 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)
** 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
** 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
Line 688: Line 841:
=== 2020-06-18-3 ===
=== 2020-06-18-3 ===
rolled out Ttenbergen 07:49, 2020 June 19 (CDT)
rolled out Ttenbergen 07:49, 2020 June 19 (CDT)
* in [[Patient Viewer Tab Cognos ADT]]
* in Patient Viewer Tab Cognos ADT
** changed the query that provides data for this to eliminate duplication
** changed the query that provides data for this to eliminate duplication
* in [[Cognos Admitter]]
* in ''Cognos Admitter''
** added Service Location as requested during meeting
** added Service Location as requested during meeting
** fixed sorting by [[Accept DtTm]] and [[Arrive DtTm]]
** fixed sorting by Accept DtTm and Arrive DtTm
** added sorting by Unit Start Dtm, Service Start Dtm
** added sorting by Unit Start Dtm, Service Start Dtm
* in [[Cognos Discharger]]
* in ''Cognos Discharger''
** added sorting for [[Dispo DtTm]], Unit End Dtm
** added sorting for [[Dispo DtTm]], Unit End Dtm


Line 701: Line 854:
* [[Cognos EPR Report]] (ie affects all Cognos data)
* [[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
** fixed a problem in the general patient list that would have excluded patients who don't have a unit end date
* [[Cognos Admitter]]
* ''Cognos Admitter''
** confirmed that filter-by-service and filter-by-unit would show patients who are not entered yet
** 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
** limit list so it only shows the first Attending, rather than showing a line each time attending changes
Line 708: Line 861:
=== 2020-06-18 ===
=== 2020-06-18 ===
rolled out Ttenbergen 10:03, 2020 June 18 (CDT)
rolled out Ttenbergen 10:03, 2020 June 18 (CDT)
* [[Cognos Admitter]]
* ''Cognos Admitter''
** filtered list for program and hospital
** filtered list for program and hospital
** fixed filter-by-service error "Enter Parameter Value"
** fixed filter-by-service error "Enter Parameter Value"
Line 715: Line 868:
rolled out Ttenbergen 12:12, 2020 June 17 (CDT)
rolled out Ttenbergen 12:12, 2020 June 17 (CDT)
* [[S ICD10 table]] - changed "Necrotizing vasculopathy/vasculitis, NOS " to [[Vasculopathy/vasculitis, NOS]]
* [[S ICD10 table]] - changed "Necrotizing vasculopathy/vasculitis, NOS " to [[Vasculopathy/vasculitis, NOS]]
* [[Cognos Admitter]] -
* ''Cognos Admitter'' -
** fixed service and unit filter dropdowns that were broken by most recent update
** fixed service and unit filter dropdowns that were broken by most recent update
** fixed button colouring that indicates status
** fixed button colouring that indicates status
* [[Patient Viewer Tab Cognos ADT]]
* Patient Viewer Tab Cognos ADT  
** fixed cross populating for previous and next location
** fixed cross populating for previous and next location
** [["Make loc" button]] will now delete the "no borrow" line if there is one.
** [["make loc" button]] will now delete the "no borrow" line if there is one.


=== 2020-06-12 ===
=== 2020-06-12 ===
Line 727: Line 880:
* in [[s_Cognos_Units table]]: changed "GH-3North" from "GRA Ward" to "GRA_N3"
* in [[s_Cognos_Units table]]: changed "GH-3North" from "GRA Ward" to "GRA_N3"
* made [[GRA_N5]] available for G8 laptop
* made [[GRA_N5]] available for G8 laptop
* updated how [["Mine! Mine!" button]] works - it now uses filter values stored in [[Cognos_Admit_filter table]]
* 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
* changed [["exclude" button]] on ''Cognos Admitter'' to populate the Unit start Dtm rather than the Service Start dtm
* major re-work of underlying queries:  
* major re-work of underlying queries:  
** Cognos_Import_processor
** Cognos_Import_processor
** Cognos_Integrator (replaces Cognos_Arrive_Identifier and includes functionality that was previously re-implemented in several _FormQueries)
** 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
An earlier version introduced ''Cognos_SubServices table'' but didn't document this


=== 2020-06-11-2 ===
=== 2020-06-11-2 ===
Line 741: Line 894:
** inactivated "STB_E6aB" and [[STB_E6_C]]
** inactivated "STB_E6aB" and [[STB_E6_C]]
* Cognos in general:  
* 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! '''
** 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'''
** 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]]:  
* 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 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
** changed order of Cognos records to be listed by Unit Start Dtm (~ our Arrive DtTm), descending
* in [[Cognos Admitter]]
* in ''Cognos Admitter''
** added from location (which is not really same as previous location)
** 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
** fixed patient filter functionality so it filters to and un-filters from properly when clicking on patient name
* in [[Cognos Discharger]]
* in ''Cognos Discharger''
** fixed filter to list pt if either Service or Unit have end dtm (before it missed a bunch)
** 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
** made default sort order by unit end dtm, descending
Line 760: Line 913:
was rolled out with newest cognos data this morning Ttenbergen 10:56, 2020 June 11 (CDT)
was rolled out with newest cognos data this morning Ttenbergen 10:56, 2020 June 11 (CDT)
* inactivated tmp entries for [[IICU consult]]
* inactivated tmp entries for [[IICU consult]]
* in [[Patient Viewer Tab Cognos ADT]]:  
* in Patient Viewer Tab Cognos ADT:  
** changed the Cognos listing to not use black-and-white alternate colours
** changed the Cognos listing to not use black-and-white alternate colours


Line 808: Line 961:
===2020-06-04-2===
===2020-06-04-2===
rolled out Ttenbergen 07:57, 2020 June 5 (CDT)
rolled out Ttenbergen 07:57, 2020 June 5 (CDT)
* in [[Cognos Admitter]]
* in ''Cognos Admitter''
** added "view excludeds" button
** added "view excludeds" button
** set up sorting for unit arrival dtm
** set up sorting for unit arrival dtm
Line 826: Line 979:
Changes collectors should know about:
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)
* 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]]
* changed ''Cognos Admitter''
** now only enters [[PHIN]] for MB patients
** now only enters [[PHIN]] for MB patients
** added a filter for a specific patient
** added a filter for a specific patient
** (added query Cognos_has_matching_Boarding_Loc to query Cognos_Admitter_FormQuery)  
** (added query Cognos_has_matching_Boarding_Loc to query Cognos_Admitter_FormQuery)  
** added [[Cognos_Admitter#"Mine! Mine!" button]] for better filtering
** added ''"Mine! Mine!" button' for better filtering


Changes collectors probably don't care about:  
Changes collectors probably don't care about:  
Line 842: Line 995:
* for Cognos in general: changed how [[HSC B2]] is treated by Cognos tools to make it match that ward
* for Cognos in general: changed how [[HSC B2]] is treated by Cognos tools to make it match that ward


* in [[Cognos Admitter]]:  
* in ''Cognos Admitter'':  
** changed the filter to not exclude sent and deleted patients from the list
** changed the filter to not exclude sent and deleted patients from the list
** made separate query field for "deleted"  
** made separate query field for "deleted"  
** changed the button background conditional format so it's dark gray for deleted records
** 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]]
** changed the binoc button so it adds the unit arrival dtm to ''EPR Admit DtTm field''


* in [[Patient Viewer Tab Cognos ADT]]
* 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]]
** 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]]  
** 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.
** 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:  
Changes collectors don't need to know about:  
Line 859: Line 1,012:
rolled out Ttenbergen 14:42, 2020 May 29 (CDT)
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
* fixed [[HSC_D5]] for [[Boarding Loc]], I accidentally set it so it can only be seen at STB
* in [[Cognos Admitter]]:
* in ''Cognos Admitter'':
** made name column and admit dttm columns sortable  
** made name column and admit dttm columns sortable  
** added filter option for unit
** added filter option for unit
** fixed link to wiki from this form
** fixed link to wiki from this form
* in [[Patient Viewer Tab Cognos ADT]]: made all Dtm fields military time
* in Patient Viewer Tab Cognos ADT: made all Dtm fields military time


=== 2020-05-28===
=== 2020-05-28===
rolled out Ttenbergen 16:35, 2020 May 28 (CDT)
rolled out Ttenbergen 16:35, 2020 May 28 (CDT)
* added [[HSC_D5]] to [[Boarding Loc]]
* 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 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
* changed Cognos Visit Admit DtTm to derive from their HospEntryDtm, not their inpatient startDtTm


Line 876: Line 1,029:
** changed "HSC_D4_P" to [[HSC_D4]]
** changed "HSC_D4_P" to [[HSC_D4]]
** changed [[HSC_D4_C]] Ward column to say D4_C (collectors will see nothing of this one)
** changed [[HSC_D4_C]] Ward column to say D4_C (collectors will see nothing of this one)
** added [[HSC_B2_C]]
** added "HSC_B2_C"
** made no change to [[HSC_WRS3]] - it was on Julie's list but all black so assume not change needed.
** made no change to [[HSC_WRS3]] - it was on Julie's list but all black so assume not change needed.


Line 892: Line 1,045:
=== 2020-05-27-2 ===
=== 2020-05-27-2 ===
rolled out Ttenbergen Ttenbergen 10:15, 2020 May 27 (CDT)
rolled out Ttenbergen Ttenbergen 10:15, 2020 May 27 (CDT)
* update to [[Cognos Admitter]] to include ICCS (include program "surgery"
* update to ''Cognos Admitter'' to include ICCS (include program "surgery"


=== 2020-05-27 ===
=== 2020-05-27 ===
Line 907: Line 1,060:
**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.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")
**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]]
* 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.  
* Removed "Cognos Integrator" button since the three above will take its place; I still have to clean up much wiki for that.  


Line 923: Line 1,076:


Changes Collectors should care about:  
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
* [[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:  
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
* 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
Line 993: Line 1,146:
* for [[2020 GRA COVID unit transition]]:
* for [[2020 GRA COVID unit transition]]:
** to [[s_dispo table]] / [[S locations allowed collection table]], added:  
** to [[s_dispo table]] / [[S locations allowed collection table]], added:  
*** [[GRA_PACU]]
*** [[GH-Recovery Room]]
** to [[S tmp table]] for [[Boarding Loc]], added:  
** to [[S tmp table]] for [[Boarding Loc]], added:  
*** GRA_5N
*** GRA_5N
Line 1,064: Line 1,217:
rolled out Ttenbergen 23:24, 2020 April 5 (CDT)
rolled out Ttenbergen 23:24, 2020 April 5 (CDT)
* work on [[Cognos Report Integrator]] Ttenbergen 14:11, 2020 April 3 (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 ''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)
** 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]]
* Made changes for [[ICUotherService]] in [[s_tmp table]]
Line 1,077: Line 1,230:
only provided to specific people for testing for now  
only provided to specific people for testing for now  
* starting work on [[Cognos Report Integrator]] Ttenbergen 14:11, 2020 April 3 (CDT)
* 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)
* 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)
* tweak to fix spelling problem in prev version Ttenbergen 15:03, 2020 April 3 (CDT)


Line 1,173: Line 1,326:
=== 2020-03-12 ===
=== 2020-03-12 ===
Rolled out Ttenbergen 10:05, 2020 March 12 (CDT)
Rolled out Ttenbergen 10:05, 2020 March 12 (CDT)
* removed [[Gastrointestinal (GI) tract, chemical burn]] and [[Electrical injury]] from [[Category:Trauma]] since we would not want to enforce mechanisms on these.  
* removed [[Gastrointestinal (GI) tract, chemical burn]] and [[Electrical injury]] from [[:Category:Trauma]] 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)
* did a [[Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb]] Ttenbergen 10:04, 2020 March 12 (CDT)


Line 1,233: Line 1,386:
* 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)
* 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)
* 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.
* 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 ===
=== 2020-02-27 ===
Line 1,266: Line 1,419:
* removed trauma categories from [[Rib fracture(s) due to CPR]] - it's iatrogenic, so not a trauma and no mechanism required.
* 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]]
* added [[Resistance to carbapenem antibiotics]]
* tweaks to [[EPR Reports Integrator]] as discussed with Michelle
* tweaks to ''EPR Reports Integrator'' as discussed with Michelle


=== 2020-01-02 ===
=== 2020-01-02 ===

Latest revision as of 09:50, 2023 May 18

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

2021

See CCMDB.accdb Change Log 2021

2020-12-31

rolled out Ttenbergen 19:56, 2021 January 1 (CST)

Changes collectors need to know about:

  • CE: tweaked query that had some troubleshooting code left in it
  • excluded services from CSS:
    • HSC Internal Med / Respiratory
    • HSC Oncology/Bone marrow transplant now excluded
    • HSC Oncology/radiation now excluded

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

  • NONE

2020-12-24

rolled out Ttenbergen 16:06, 2020 December 31 (CST)

Changes collectors need to know about:

  • CSS:
    • excluded from the list
      • services that have already been entered with that service and time
      • services that fall outside of the admission dttm range of a matched record.
    • added profile start dttm and dispo dttm to make it easier to see which existing record an un-entered service is related to
    • added a "W+" toggle to filter to white pluses, ie service listings for pts who do not currently have any records on this laptop
  • Patient Viewer Tab Cognos ADT2:
    • added a Patient copier button to make it easier to enter a new profile if a record was opened from CSS only to find that the pt had left your unit and then returned

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

2020-12-23-1

rolled out Ttenbergen 10:08, 2020 December 24 (CST)

Changes collectors need to know about:

  • NONE

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

2020-12-23

rolled out Ttenbergen 12:39, 2020 December 23 (CST)

Changes collectors need to know about:

  • NONE

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

2020-12-17

was rolled out, not sure when exactly Ttenbergen 11:11, 2020 December 23 (CST)

Changes collectors need to know about:

  • CSS - there were two buttons to view excludeds; the one on the top works and is still there, the second one just under the column labels ("view excluded chart-service records") didn't work. We don't need two, so I removed that one
  • Patient Viewer Tab CCI Pick - added a secondary sort order so records won't be random after the primary sort to the CCI and px_date sorting buttons. Before this, sorting/grouping CCI items would have led to random date sort. With this change, sorting by item will secondary sort by date, and sorting by date will secondary sort by item.

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

  • restored "GRA - ER" entry in s_dispo table, had accidentally got deleted

2020-12-15

rolled last night...

Changes collectors need to know about:

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

  • Cognos2 Ender - somehow in one of the last versions, this started to include records that had already been sent; updated query so previously sent records will no longer be included. Ttenbergen 15:45, 2020 December 16 (CST)

2020-12-14-3

rolled out Ttenbergen 15:51, 2020 December 15 (CST) Changes collectors need to know about:

  • added to Service tmp entry list:
    • "SBGH Critical Care / Medicine"
    • "HSC Surgery / Trauma"

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

  • removed the size "restore" I had added to the closing of the patient viewer (after adding that viewer should maximize) - will need to see if removing it causes as many complaints...
  • fixed bug in Cognos2 Ender where clicking binocs to open a pt would give a Pat_ID error.

2020-12-14-2

rolled out Ttenbergen 14:02, 2020 December 14 (CST)

Changes collectors need to know about:

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

  • further tweaked Cognos2_Ender_Service_formQuery to match the existing record properly, it was matching by item when it should only match by end dttm

2020-12-14

rolled out Ttenbergen 13:12, 2020 December 14 (CST)

Changes collectors need to know about:

  • removed the buttons that opened Cognos Admitter and Cognos Discharger

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

  • 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. Ttenbergen 12:23, 2020 December 14 (CST)

2020-12-09

rolled out Ttenbergen 18:52, 2020 December 10 (CST)

  • Changes collectors need to know about:
    • tweaked the size of some fields in Patient Viewer so the whole thing, maximized, will fit on the screen without scrolling (Thanks to Pam for flagging this! ) Ttenbergen 17:26, 2020 December 9 (CST)

2020-12-04

rolled out Ttenbergen 10:46, 2020 December 4 (CST)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

  • fixed error for TISS40 button

2020-12-02

rolled out Ttenbergen 12:15, 2020 December 3 (CST)

Changes collectors need to know about:

  • made the links to Cognos Admitter and Cognos Discharger much smaller on Main Form in preparation for phasing these out. If I don't hear from people I will phase those out after 2020-12-06
  • Change to collect TISS data in CCI Picklist
    • added buttons for remaining TISS items to Patient Viewer Tab CCI Pick; made invisible buttons for items not currently collected
    • retired the CCI Picklist entries for items on [[TISS Item List] not currently collected

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

2020-12-01-1

rolled out Ttenbergen 22:54, 2020 December 1 (CST)

Changes collectors need to know about:

  • updated Patient Viewer Tab Cognos ADT2 to show any unit and service info available for that admission (used to just show those during the admission) so any possible previous and next service will be available for Previous Location and Dispo (didn't automate entering any of that, but at least it's visible
    • lines during this admission will be green, lines outside this admission will be an unsaturated red. Ttenbergen 22:48, 2020 December 1 (CST)
  • updated Cognos2 Ender so it will no longer wrongly show service entries that would have been part of a previous or future profile for the same pt. Ttenbergen 22:48, 2020 December 1 (CST)
  • updated Patient Viewer Tab Tmp - using either of the two sorting buttons was making it impossible to enter new lines

2020-12-01

rolled out Ttenbergen 11:02, 2020 December 1 (CST)

Changes collectors need to know about:

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

2020-11-30

rolled out Ttenbergen 19:59, 2020 November 30 (CST)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

2020-11-27

was it rolled out? I have no idea... if not it will roll with the next version.

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

  • made new TISS items on L CCI Picklist subform invisible for Medicine laptops Ttenbergen 09:52, 2020 November 30 (CST)
  • updated Cognos2 Unit Starter to include units just before the beginning and just after the end of the currently listed admission; the previous filter would have not shown them if an arrive or dispo dttm had already been entered. Ttenbergen 10:57, 2020 November 30 (CST)

2020-11-26

rolled out Ttenbergen 22:19, 2020 November 26 (CST)

Changes collectors need to know about:

2020-11-25

rolled out Ttenbergen 15:46, 2020 November 26 (CST)

Changes collectors will want to know about:

Changes collectors probably don't care about:

2020-11-24-2

rolled out Ttenbergen 21:46, 2020 November 24 (CST)

Changes collectors will want to know about:

Changes collectors probably don't care about:

2020-11-24-1

rolled out Ttenbergen 09:53, 2020 November 24 (CST)

Changes collectors will want to know about:

  • Fixed problem in tmp tab that was introduced in recent version

2020-11-24

rolled out Ttenbergen 09:40, 2020 November 24 (CST)

Changes collectors will want to know about:

2020-11-23

rolled out Ttenbergen 22:21, 2020 November 23 (CST)

Changes collectors will want to know about:

  • Excluded the following services from Cognos Admitter
    • GH Critical Care / Clinical Assessment
    • GH Internal Med / Clinical Assessment

2020-11-20

rolled out Ttenbergen 10:33, 2020 November 23 (CST)

Changes collectors will want to know about:

2020-11-19

rolled out Ttenbergen 00:46, 2020 November 20 (CST)

Changes collectors will want to know about:

Changes collectors probably don't care about:

2020-11-17

Reverted to previous version because of many errors on collector laptops probably caused by my laptop being upgraded to Access 64 bit

2020-11-16

rolled out Ttenbergen 21:42, 2020 November 16 (CST)

Changes collectors should know about:

Changes collectors probably don't care about:

  • Tina now has Access 64-bit; this should make no difference to collectors but wanted to track a time stamp for it in case strange things start to happen
  • added column "BoardingLoc" to table S Cognos Units table to help better automatically populate the Boarding Loc entries

2020-11-09-2

was rolled out, not sure when

Changes collectors should know about:

Changes collectors probably don't care about:

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

2020-11-09

rolled out Ttenbergen 14:47, 2020 November 9 (CST)

Changes collectors should know about:

  • 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)
  • added "HSC Critical Care / Trauma" to allowed entries for Service tmp entry Ttenbergen 14:47, 2020 November 9 (CST)

2020-11-06-2

rolled out Ttenbergen 09:55, 2020 November 9 (CST)

Changes collectors should know about:

Changes collectors probably don't care about:

2020-11-06

rolled out Ttenbergen 13:57, 2020 November 6 (CST)

Changes collectors should know about:

  • fixed problem where pt entered from Cognos didn't get entered right
  • fixed problem where there was an error after entering through Cognos Admitter
  • updated default entries for new patient form so they autopopulate for STB_CICU and STB_ACCU

Changes collectors probably don't care about:

  • restored the form_view.dirty = false that had been accidentally deleted and was causing pt info to not be added right.

2020-11-05-2

rolled out Ttenbergen 23:36, 2020 November 5 (CST) Changes collectors should know about:

Changes collectors probably don't care about:

2020-11-05

rolled Ttenbergen 15:03, 2020 November 5 (CST) Changes collectors should care about:

  • 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.
  • code required to move to CCMDB data.mdb Change Log#2020-11-05

Changes collectors probably don't care about:

2020-11-04

rolled out Ttenbergen 13:00, 2020 November 5 (CST) Changes Collectors should care about

  • 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)
  • changed project field of tmp subform in Cognos ADT tab to be a dropdown with options Boarding Loc, Service, Transfer Ready DtTm
  • updated "make loc" button to delete the automated "no location entered" line. Ttenbergen 09:48, 2020 November 5 (CST)

Cognos2 stuff (this isn't visible to collectors yet, coming soon

Changes Collectors probably don't care about

2020-10-28-2

rolled out Ttenbergen 09:32, 2020 November 3 (CST)

Changes Collectors should care about

  • restored "no borrow" for Boarding Loc; it will eventually go away but needs to be available until old patients have been discharged
  • excluded "GH Medicine-ClinAs / Clinical Assessment", "HSC Medicine-ClinAs / General", "SBGH Medicine-ClinAs / General" services from Cognos Admitter list (updated Cognos_integrator query)

Changes Collectors probably don't care about

2020-10-28

rolled out Ttenbergen 15:22, 2020 October 28 (CDT)

  • made STB_CC inactive in s_dispo table - we thought it was needed initially, but now realize it's not. Ttenbergen 11:52, 2020 October 28 (CDT)
  • changed New Pt Serial helper form to use new generic locations instead of old specific ones Ttenbergen 13:21, 2020 October 28 (CDT)

confirm if form_new_pt_helper_list still needed and clean it up


Changes collectors probably don't need to know about:

  • 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
impossible_date_combination:  
Nz([AsgnUnitStartDtm_Current],#2999-12-31#)<Nz(Nz([Accept_DtTm],[Arrive_DtTm]),#1900-01-01#) Or 
Nz([AsgnUnitEndDtm_Current],Nz([AsgnUnitStartDtm_Current],#1900-01-01#))>Nz([Dispo_DtTm],#2999-12-31#)

2020-10-26

rolled out Ttenbergen 09:59, 2020 October 28 (CDT)

  • changes to center field in S dispo table for new _cc and _med entries as per request from Julie, email:
    • GRA_CC --> 131
    • GRA_Med --> 230
    • HSC_CC --> 110
    • MSC_Med --> 210
    • STB_Med --> 220
  • 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
  • made Boarding Loc "GRA_ER" available for GRA critical care laptop, it had been limited to med laptop accidentally when we reconciled the duplicate for that at GRA
  • confirmed that query s_tmp_Boarding_Loc_date_item is correct to not allow boarding loc entry for home location for Med; if patients are entered with e.g. HSC_Med then this doesn't happen.

2020-10-22

rolled out Ttenbergen 14:03, 2020 October 23 (CDT)

2020-10-21-1

rolled out Ttenbergen 21:11, 2020 October 21 (CDT)

2020-10-21

rolled Ttenbergen 11:44, 2020 October 21 (CDT)

  • re-imported yesterday's Cognos data since the ETL failed for today
  • ran re-compile to get rid of that error when opening Cognos Admitter

2020-10-20

rolled out Ttenbergen 00:23, 2020 October 21 (CDT)

Changes collectors probably care about:

  • 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:
    • made some fonts smaller to list more lines; I can reverse this, just really trying to fit more on that screen
    • changed top part of tab
      • removed the Province field from this screen; this is automatically populated from Cognos, but I have not heard anything about it being populated wrong; the field is still visible on the Patient Viewer Tab Dispo.
      • rearranged remaining items to fit in a less tall area
    • changed the tmp listing part of tab
    • changed Cognos part of tab
      • made this part of the tab taller
      • added "Make Service" button
      • removed the "attending provider" field and changed the query to no longer show extra lines for these
      • removed Visit Admit DtTm field from here - the Cognos section will only list a row if it has the same Visit admit DtTm, so this will always show the same thing, so useless; the actual Visit Admit DtTm of the record is still shown in the top section
      • remoevd the "chart matched" entry because it would always show this chart, so useless
  • in Cognos Admitter, removed the "Attending Provider" field

Changes collectors probably don't care about:

  • removed duplicate entry for "STB_E6_B" for Boarding Loc in S tmp table Ttenbergen 15:07, 2020 October 20 (CDT)
  • changed Cognos_integrator query to:
    • no longer list "attending provider", and no longer list extra lines for when this changes Ttenbergen 23:24, 2020 October 20 (CDT)
    • added "SubserviceDesc_Prior", no idea why that wasn't in there before Ttenbergen 23:36, 2020 October 20 (CDT)
  • added "SubserviceDesc_Prior" to Cognos Patient viewer tab FormQuery query
  • removed Attending Provider in Cognos Admitter FormQuery query

2020-10-19

rolled out Ttenbergen 11:44, 2020 October 19 (CDT)

2020-10-16-3

rolled out Ttenbergen 16:43, 2020 October 16 (CDT)

2020-10-16-2

rolled out Ttenbergen 13:26, 2020 October 16 (CDT)

2020-10-16-1

not rolled yet Ttenbergen 12:47, 2020 October 16 (CDT)

2020-10-16

Rolled out Ttenbergen 11:58, 2020 October 16 (CDT)

  • fixed error that came up when exiting the old Transfer Ready DtTm field after an edit; the field is defunct, but should still not give an error like that. Changed the error to instead direct to the new method of entering this. Ttenbergen 08:49, 2020 October 16 (CDT)
  • added specific Medicine location entries for Boarding Loc Ttenbergen 11:54, 2020 October 16 (CDT)

2020-10-15

rolled out Ttenbergen 01:44, 2020 October 16 (CDT)

Changes collectors will want to know about. No really, you need to know about these or you will be correcting entries!

Changes collectors don't need to know about

  • To Do:
    • change CCI and dx date cross checks to accept time in ER after process changes.

2020-10-14-3

rolled out Ttenbergen 14:26, 2020 October 14 (CDT)

2020-10-14-2

rolled out Ttenbergen 11:08, 2020 October 14 (CDT)

2020-10-14

rolled out Ttenbergen 10:05, 2020 October 14 (CDT)

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

2020-10-13

was rolled out with earlier version number (ie number not updated) Ttenbergen 23:29, 2020 October 13 (CDT)

  • recompiled to get rid of hidden stop-point during Cognos import
  • added GRA_Med to S dispo table Ttenbergen 18:03, 2020 October 13 (CDT)
  • added GRA_N5, GRA_N3, GRA_B3 to S tmp table for Boarding Loc Ttenbergen 23:27, 2020 October 13 (CDT)

2020-10-09-3

rolled Ttenbergen 11:59, 2020 October 9 (CDT) Changes collectors probably don't care about...

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

2020-10-09-2

rolled Ttenbergen 10:50, 2020 October 9 (CDT)

2020-10-09

rolled out Ttenbergen 09:54, 2020 October 9 (CDT)

2020-10-08-2

rolled out Ttenbergen 00:23, 2020 October 9 (CDT)

  • 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)
    • to no longer include deleted records
    • only include records as designated to be collected by collector as per (for sites not using this yet, that will mean all patients as before)

Changes collectors probably don't care about

2020-10-08-1

rolled out Ttenbergen 13:55, 2020 October 8 (CDT)

  • tweaked Cognos Admit filter table to hide delete patients from GRA Med Ttenbergen 10:01, 2020 October 8 (CDT)
  • re-imported Cognos data since I rolled out a version with old data accidentally. Ttenbergen 13:55, 2020 October 8 (CDT)

2020-10-08

rolled out Ttenbergen 09:27, 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)

2020-10-07

rolled out Ttenbergen 09:37, 2020 October 7 (CDT)

  • the PatientFollow Project distribution at the GRA was backward, fixed Ttenbergen 09:37, 2020 October 7 (CDT)

2020-10-01

rolled out Ttenbergen 22:38, 2020 October 6 (CDT) Changes collectors should care about:

  • updated colour for GRA_S3 in S dispo table as requested by GRA Med collectors Ttenbergen 14:17, 2020 October 1 (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 EMIPs 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)
  • changed the PatientFollow Project filter of GRA Med to use the same model as well, had initially set up a simplified version but that would not have worked to ever change distribution by date. Ttenbergen 21:58, 2020 October 6 (CDT)

Changes collectors probably don't care about:

  • deleted old undocumented queries "patientFollow_copy_L_Log" and "patientFollow_copy_L_ICD10" Ttenbergen 18:40, 2020 October 6 (CDT)
  • updated S PatientFollow distribution table with Patient_follow distribution split for GRA and HSC 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)

2020-09-24

rolled out Ttenbergen 09:56, 2020 September 24 (CDT)

  • For some reason option "Doctor's office" for Accept Loc Park in s_tmp table had been changed to "Doctors office". This caused errors, so retired the "Doctors" version and re-added a "Doctor's" entry.

2020-09-23

rolled out Ttenbergen 17:39, 2020 September 23 (CDT) accidentally overwrote v2020-09-22 so re-doing it.

  • Changes collectors probably don't care about:
    • reverted to version 2020-08-28-02 because current one required password on close
    • re-did: checked off ACTIVE for HSC A3S stepdown in s_dispo table
    • in Function 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])

2020-09-01

rolled out! Trish Ostryzniuk 15:05, 2020 September 1 (CDT)

  • s_dispo table, checked off ACTIVE for HSC A3S stepdown.

2020-08-27-2

was rolled out last night Ttenbergen 09:27, 2020 August 31 (CDT)

  • tweaks to the function that requeries open forms when Cognos-related data is updated or entered.
  • tweaks to New Pt Serial helper form / Cognos Admitter to improve default populating of location, which was often blank before.

2020-08-27

rolled out earlier this morning Changes Collectors probably don't care about

2020-08-24

rolled out Ttenbergen 08:58, 2020 August 25 (CDT)

2020-08-21

rolled out Ttenbergen 10:15, 2020 August 21 (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)

2020-08-17

not rolled yet Ttenbergen 07:56, 2020 August 17 (CDT)

to do: deferred delivery, troubleshoot why it sets time to 2 hours in future.

2020-08-16

rolled out Ttenbergen 18:12, 2020 August 16 (CDT)

  • re-imported old send functions since the new ones break things:
    • send_Centralized_1L_Log__intermediate
    • Send_Centralized_L_CCI_Component__intermediate
    • Send_Centralized_L_CCI_Picklist__intermediate
    • Send_Centralized_L_ICD10__intermediate
    • Send_Centralized_L_Pharm_Flowsheet__intermediate
    • Send_Centralized_L_TmpV2__intermediate
    • send_PHI

2020-08-14

rolled out Ttenbergen 12:34, 2020 August 14 (CDT)

  • updated Function make_D_ID to not use new version at all yet, date tbd Ttenbergen 12:34, 2020 August 14 (CDT)

2020-08-13

rolled out with new data this morning Ttenbergen 12:34, 2020 August 14 (CDT) Changes collectors probably don't need to know about

  • minor tweak to how exclude button works.
  • cognos importer
    • tweaked how it finds the most recent email from Chastity, the date part of the filter was wrong syntax
    • fixed automatic sending of email to collectors
  • Update of D ID exclude service/location
    • updated Function make_D_ID wrongly to start using new format for all after Aug 10
    • updated send_* queries that use this:
      • send_Centralized_1L_Log__intermediate
      • Send_Centralized_L_CCI_Component__intermediate
      • Send_Centralized_L_CCI_Picklist__intermediate
      • Send_Centralized_L_ICD10__intermediate
      • Send_Centralized_L_Pharm_Flowsheet__intermediate
      • Send_Centralized_L_TmpV2__intermediate
      • send_PHI
  • deleted old test query Send_Centralized_1L_Log_update_tester since it wouldn't open properly when trying to change it Ttenbergen 16:48, 2020 August 13 (CDT)

2020-08-12-4

rolled out Ttenbergen 16:11, 2020 August 12 (CDT)

  • tweaked the Accept_Dtm_equiv field in Cognos:
    • it will now always show the IPAdmit_Dtm
    • 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 the forms updating that happens after certain cognos transactions to return to the same spot on the form to also restore same sort and filter Ttenbergen 15:14, 2020 August 12 (CDT)
  • tweaked Cognos data importer to only look for a file from within the last 24hrs, so it picks the right one if there are several in the inbox. Ttenbergen 15:50, 2020 August 12 (CDT)

2020-08-12-2

rolled out Ttenbergen 10:43, 2020 August 12 (CDT)

  • re-enabled the requerying for cognos forms. Ttenbergen 10:03, 2020 August 12 (CDT) and fixed the attempt to come back to the same line. Ttenbergen 10:42, 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)

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)

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 "s_Cognos_Services_additions_needed query" and included it in Function 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 Function 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 s_Cognos_Units 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:

Changes collectors probably don't care about:

  • 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 Function 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:

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

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

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)

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
  • 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:

2020-06-05

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

Changes collectors probably don't care about:

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)

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 "Mine! Mine!" button' for better filtering

Changes collectors probably don't care about:

2020-06-02

rolled out Ttenbergen 22:23, 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)

2020-05-27-4

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

  • added "SBGH-ICCS" and "SBGH CCUO" to s_Cognos_Units 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:

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:

2020-05-14

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

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)

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:

2020-04-17-1

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

2020-04-17

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

2020-04-16-1

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

2020-04-16

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

2020-04-15-1

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

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)

2020-04-09-1

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

Changes collectors probably won't care about:

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:
  • 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:

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)

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)

2020-03-29

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

2020-03-29

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

2020-03-24

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

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)

2020-03-19

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

  • Behind the scenes changes that are probably not interesting to collectors:

2020-03-18

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

2020-03-17

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

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)

2020-03-12

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

2020-03-11

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

2020-03-05

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

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)

2020-01-31

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

2020-01-28

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

2020-01-23

rolled out Ttenbergen

2020-01-15

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

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