============================================================================= Run Date: OCT 26, 2023 Designation: WEBP*1*33 Package : WEBP - PATIENT CENTERED MANAGEMENT Priority: Mandatory Version : 1 SEQ #32 Status: Released Compliance Date: NOV 26, 2023 ============================================================================= Subject: PCMM WEB DEFECT AND LATENCY REMEDIATION III Category: - Informational Description: ============ The purpose of the patch is to remediate some latency issues with the PCMM web application. There are a total of 10 items addressed in the patch, including 2 defects and 8 adaptive maintenance items. Defects: -------- 1. INC28708488 PCMM MEM Sta 614 | MEM PACT 07 Station number changed to 614GC 2. INC28638828 - Prevent code from throwing exception on revert if there is no explicit position assignments Adaptive Maintenance: --------------------- 1. List All Teams action in the Main Menu to be re-ordered AFTER Search All Teams 2. List All Teams: Filter Inactive Teams 3. Team Details: Front Loading Data Reduction 4. Position Details: Front Loading Data Reduction 5. List All Teams Query Optimization 6. Remove "substring" from queries' "where..." and "join...on" clauses to prevent whole table scans caused by substring. 7. Remove "upper" and "lower" from queries' "where..." and "join...on" clauses to prevent whole table scans caused by substring. 8. Remove "coalesce" from "where." and "join...on" clauses to prevent whole table scans caused by coalesce. (40%) Patch Components: ----------------- Files & Fields Associated: File Name (Number) Field Name (Number) New/Modified/Deleted ------------------ ------------------- -------------------- N/A Forms Associated: Form Name File Number New/Modified/Deleted --------- ----------- -------------------- N/A Mail Groups Associated: Mail Group Name New/Modified/Deleted --------------- -------------------- N/A Options Associated: Option Name Type New/Modified/Deleted ----------- ---- -------------------- N/A Protocols Associated: Protocol Name New/Modified/Deleted ------------- -------------------- N/A Security Keys Associated: Security Key Name ----------------- N/A Templates Associated: Template Name Type File Name (Number) New/Modified/Deleted ------------- ---- ------------------ -------------------- N/A Remote Procedures Associated: Remote Procedure Name New/Modified/Deleted --------------------- -------------------- N/A Parameter Definitions Associated: Parameter Name New/Modified/Deleted -------------- -------------------- N/A Additional Information: ----------------------- N/A New Service Requests (NSRs): N/A Patient Safety Issues (PSIs): N/A Defect Tracking System Ticket(s) & Overview: -------------------------------------------- 1. INC28708488 PCMM MEM Sta 614 | MEM PACT 07 Station number changed to 614GC Problem: -------- While unassigning MEM PACT 07's AA, this created a capacity overage and when closing the team and saving that action. The team's station changed from Memphis 614 to Marshall County 614GC. Somehow these actions did not change my station to 614, but apparently remained at 614GC. Resolution: ----------- Changed code not enable change of team station if fetch of assigned patients failed (previously only checked if assigned patients list was empty). 2. INC28638828 - Prevent code from throwing exception on revert if there is no explicit position assignments Problem: -------- Prevent code from throwing exception on revert if there is no explicit position assignments Resolution: ----------- Added code to check that position assignments list is not empty before fetching first record in the list. Adaptive Maintenance Tracking System Ticket(s) & Overview: ---------------------------------------------------------- 1. List All Teams action in the Main Menu to be re-ordered AFTER Search All Teams Problem: -------- As a PCMM user, I want the List All Teams action in the Main Menu to be re-ordered AFTER Search All Teams so that the most used functionality in the menu is at the top of the list. Resolution: ----------- Changed the React app to display the 'List All Teams' menu option second. 2. List All Teams: Filter Inactive Teams Problem: -------- As a PCMM user, I want the "List All Teams" screen to display only active Teams and filter out inactive teams, similar to the "Position List" screen. Resolution: ---------- Changed React and Java code in order to filter queries based on status of the teams, including setting the default load to 'Active.' Changing to display all teams causes a reload of the data, which should reduce initial load for users decreasing the latency. 3. Team Details: Front Loading Data Reduction Problem: -------- As a PCMM user, I want the "Team Details" screen accordion expansion options to only load the related data when the accordion action is expanded or radio button is chosen so that reduce the burden of front loading data which is not needed by the AEU. Resolution: ---------- View Patient Assignments was identified as a query that was expensive for loading times, and so React functionality was changed to not load on the initial display and also separate loading within the accordion between 'Current Assignments' and 'Historical Assignments' to only load necessary data. 4. Position Details: Front Loading Data Reduction Problem: -------- As a PCMM user, I want the "Position Details" screen accordion expansion options to only load the related data when the accordion action is expanded or radio button is chosen to reduce the burden of front loading data which is not needed by the AEU. Resolution: ---------- View Patient Assignments was identified as a query that was expensive for loading times, and so React functionality was changed to not load on the initial display and also separate loading within the accordion between 'Current Assignments' and 'Historical Assignments' to only load necessary data. 5. List All Teams Query Optimization Problem: -------- As a developer, I want to decrease the loading time of List All Teams by grouping more of the initial query items together in a larger query rather than many different ones. Resolution: ---------- Findings from analysis showed that the query for List All Teams was putting unnecessary strain on the database to fill in minor gaps. Changes were made to consolidate the disparate queries into one larger query which should execute much faster. 6. Remove "substring" from queries' "where..." and "join...on" clauses to prevent whole table scans caused by substring. Problem: -------- As a developer, I want to change java queries including "substring" to use SQL-friendly language to reduce unintended latency experienced while running it. Resolution: ---------- Discussions with SQA experts yielded knowledge that some SQL queries in the Java codebase were triggering unnecessary and unintended strain on the database. Code was changed to achieve the objective of the code while using SQL-friendly architecture. 7. Remove "upper" and "lower" from queries' "where..." and "join...on" clauses to prevent whole table scans caused by substring. Problem: -------- As a developer, I want to change java queries including "upper" and "lower" to use SQL-friendly language to reduce unintended latency experienced while running it. Resolution: ---------- Discussions with SQA experts yielded knowledge that some SQL queries in the Java codebase were triggering unnecessary and unintended strain on the database. Code was changed to achieve the objective of the code while using SQL-friendly architecture. 8. Remove "coalesce" from "where." and "join...on" clauses to prevent whole table scans caused by coalesce. (40%) Problem: -------- As a developer, I want to change java queries including "coalesce" to use SQL-friendly language to reduce unintended latency experienced while running it. Resolution: ---------- Discussions with SQA experts yielded knowledge that some SQL queries in the Java codebase were triggering unnecessary and unintended strain on the database. Code was changed to achieve the objective of the code while using SQL-friendly architecture. Test Sites: ----------- Memphis VA Medical Center (Memphis, TN) VA Montana Health Care System (Ft. Harrison, Miles City) Software and Documentation Retrieval Instructions: -------------------------------------------------- PCMM Web patch, WEBP*1*33, is a centrally managed web-based application and will be implemented and deployed to a central web server. Sites do not need to download any file for the patch installation. Documentation describing the new functionality is included in this release. Documentation can be found on the VA Software Documentation Library at: https://www.domain.ext/vdl/. Documentation can also be obtained at https://download.vista.domain.ext/index.html/SOFTWARE. Documentation Title File Name --------------------------------------------------------------------- Deployment, Installation Back-Out, WEBP_1.0_33_DIBRG.DOCX and Rollback Guide WEBP_1.0_33_DIBRG.PDF --------------------------------------------------------------------- PCMM Web Version Description WEBP_1.0-33_VDD.DOCX Document WEBP_1.0-33_VDD.PDF Other Software Files: --------------------- This release also includes other software files. Other software files can be obtained by accessing the URL: https://download.vista.domain.ext/index.html/SOFTWARE File Name Description --------------------------------------------------------- PCMMR_EAR-1.33.03.EAR Installation file PCMMR_UNATTENDED_EAR-1.31.03.EAR Installation file cissUserManagement-1.31.02.EAR Installation file Patch Installation: =================== PCMM Web patch, WEBP*1*33, is a centrally managed web-based application and will be implemented and deployed to a central web server. No installation is required by sites. Pre/Post Installation overview: --------------------------------------- N/A. Pre-Installation Instructions: ------------------------------ Installation Instructions: ------------------------- ****************************************************************** ** PLEASE NOTE: THERE IS NO INSTALLATION FOR THIS PATCH. ** ****************************************************************** This informational patch, WEBP*1.0*33, is for PCMM Web. Installation is done on a centralized server. Please refer to the WEBP_1.0_33_DIBRG.PDF for more details. Post-Installation Instructions: ----------------------------- N/A Back-Out Plan: -------------------------- Backout plan is provided as part of deployment guide detailed in the Deployment, Installation Back-Out, and Rollback Guide (WEBP_1.0_33_DIBRG.PDF). Routine Information: ==================== No routines included. ============================================================================= User Information: Entered By : Date Entered : OCT 03, 2023 Completed By: Date Completed: OCT 23, 2023 Released By : Date Released : OCT 26, 2023 ============================================================================= Packman Mail Message: ===================== No routines included