SPARCRequest Version 3.10.0

MUSC Release Date: 11/28/2022         OS Release Date: 12/13/2022

finISHED

Page Index:

1. (SPARCRequest) Remove CTSAsearch content

The statement describing SPARCRequest services being listed in the CTSAsearch platform has been removed from SPARCRequest homepage, as this listing is no longer active.

Previous	Current

Previous	Current
Open

2. (SPARCRequest) Update Language in Search Bar to Provide Clear Instructions

The language in the SPARCRequest Home Page Catalog search bar has been updated with clearer instructions to search for a service, as well as a tooltip about what can be searched for in the field.

3. (SPARCRequest) Change New Request Question

The ‘new request’ pop-up screen question when first adding services to the cart has been updated to read as a single question: Is this a request for a new SPARC Study or Project? The ‘No or unsure’ on-screen button instructions users to go to Dashboard if the request is for an existing study OR if the user is not sure whether a study exists. Visiting the Dashboard will default the search criteria to ‘All Protocols’ to better facilitate a study search.

4. (SPARCRequest) Service Provider Email Missing First Paragraph Bug Fix

Additional work has been done to correct the bug causing occasional absence of the first paragraph in submission email to the service providers' emails.

5. (SPARCRequest and SPARCDashboard) Remove Ability to Delete Service Requests Already in Fulfillment

A new feature has been implemented to prevent deleting a service request’s last service from the SPARCRequest shopping cart when the service request has been pushed to fulfillment. This functionality has been implemented to preserve consistency in records between SPARCRequest and SPARCFulfillment.

6. (SPARCRequest & SPARCDashboard) Page Loading Indicator Increased

The size of the loading bar has been increased to better indicate when the page is loading.

7. (SPARCRequest & SPARCDashboard) New Document Permission Error

An error preventing new documents uploaded into SPARCRequest or SPARCDashboard when a user tried to click on the uploaded document has been resolved.

8. (SPARCRequest and SPARCDashboard) Move Epic User API Error to MSTeams

Epic API User errors webhooks (alerts for development team) have to been moved from Slack to MSTeams due to phasing out Slack communication.

9. (SPARCRequest Step 2 and SPARCDashboard) Epic Question 1 Rewording

When a study indicates it will be published in Epic within Study Details, the resulting question #1 has been updated for consistency with current IRB terminology and EPIC instructions for Alias Medical Records and de-identification of study participants.

10. (SPARCRequest Step 2 and SPARCDashboard) Epic Question 4 and Notes update

To maintain consistency with recently updated EPIC research header banner terminology, the SPARC study Epic question #4 has been to read "Is it appropriate to display the yellow "Research Participant” advisory for all study participants?". Subsequent notes have been updated to read “yellow advisory' as well.

11. (SPARCRequest Step 2 & SPARCDashboard) Add protocol short title length validation message

Previously, when a study short title field was too long it prevented users from saving but did not inform users of the issue. An on-screen message has been added, noting when the short title is too long.

12. (SPARCRequest Step 2 & SPARCDashboard) EPIC Q1 Displays with blank RMID Errors

Previously in Edit Study Details, the Epic study question automatically displayed a response when the page was saved as a Human Subjects study without an RMID number entered. This function has been removed as it was previously included as a prompt to complete the Epic study question, and the system will continue requesting required information in these sections.

13. (SPARCRequest Step 2 and SPARCDashboard) List External Organizations collaborating on a Study

The ability to identify external institutions/organizations involved with a study has been added. A new ‘External Organizations’ section within ‘Other Study Details’ captures these collaborations when creating or editing a study. Current data collected for these external collaborators include Organization Name, Organization Type and Comments. This feature functions similarly to adding multiple IRB Records on the study.

14. (SPARCRequest Step 3 and SPARCDashboard Admin Edit) Previous/Next Arrows added to Edit Billing Quantities Window

Arrow have been added to navigate back and forth between visits in the “Edit Billing Quantities” pop up window in the Quantity/Billings of the SPARC calendar. As a user moves from one visit to the next, it automatically saves any changes to the R/T values for a service visit.

15. (SPARCRequest Step 3 and SPARCDashboard) Ability to Collapse/Expand Service Request Display

Functionality has been added that allows users to collapse/expand service requests for clinical & non-clinical services, making on-page viewing and navigation easier.

16. (SPARCRequest Step 4 and SPARCDashboard) Ability to download multiple documents

Users are now able to batch download several documents at the same time into a zip file.

17. (SPARCRequest Step 4 and SPARCDashboard) Ability to change document access for multiple documents

Users are now able to select multiple documents at time to batch edit service providers granted document access.

18. (SPARCRequest Step 4 and SPARCDashboard) Add Optional "Version Date" Field to Documents

Users have the option to add a version date to a document, as well as display a version date column.

19. (SPARCRequest, SPARCDashboard and SPARCAdmin) Authorized User and User Profile Form Bug (LA Cats Contribution)

Bug fix that prevented saving authorized user and user profile updates when 'Other' Credentials was selected without entering anything in the 'Please Specify' textbox.

20. (SPARCDashboard) Coverage Analysis Report: Remove # of Subjects Column

The “# of Subjects” column has been removed from the Coverage Analysis report, as this service-level information is not needed in this report and caused unnecessary re-signing with edits.

21. (SPARCDashboard) Protocol Merges Column Header Naming Change

The dashboard column header “Historical Protocol Merges” name has been changed to “Merged Protocol ID(s)” be better define the column.

22. (SPARCDashboard) Add Protocol Submission Date Column (LA Cats Contribution)

A “Submitted On” column has been added to the Request Table on protocol’s Dashboard homepage to indicate the latest submission date for a particular service request.

23. (SPARCDashboard) Remove Tooltip Blocking Message Recipient Names

The pop-up tool tip now disappears after clicking the message button, only appearing when hovering over the button with the mouse.

24. (SPARCDashboard) Retain Protocol eIRB Data with Protocol Merges

A bug has been fixed that prevented eIRB Pro#s from remaining on the final protocol during merges.

25. (SPARCDashboard) Search for merged protocols

A bug has been fixed that prevented users from searching for protocol IDs that have been merged.

26. (SPARCDashboard) Notification Email Links Directly to the Message

When a user gets a SPARC message notification email, the SPARCDashboard link in the email will take the user directly to the notification message.

27. (SPARCDashboard) Cost Analysis Report Column Name Updates

The Cost Analysis Report column names “Quantity Type”, “Service Rate” and “Your Cost” now appear consistently in the report, synchronizing the terms with SPARC data and other SPARCRequest canned reports.

28. (SPARCDashboard) Protocol Merge Duplicative Affiliations Error (LA Cats Contribution)

An error has been corrected that prevented accessing Study Information when merging protocols that has the same selections in the Affiliations, Collaborations & Memberships section.

29. (SPARCDashboard and SPARCForm) Add Form Submitter and Date (LA Cats Contribution)

SPARCDashboard now displays submitted ‘By’ and submission ‘Date’ columns on the Form Submissions table to better assist service providers with managing this information and associating it with the SPARCForms Module.

30. (SPARCReport) Admin Time Report: Update Title of 'Service Request Status' Column

The “Service Request Status” column title in the Admin Time report has been changed to “Status” to maintain consistency among SPARC reports.

31. (SPARCReport) Add Protocol Merges Report

A new Protocol Merges Report has been added to SPARCReport to these types of actions.

32. (SPARCForms) Allow Integer Decimals

Number field within forms will now allow integer decimals instead of requiring the data to be a whole number.

33. (SPARCAdmin) Use Reserved Attribute for Permissible Values

Enhanced administrator’s ability to manage permissible values in SPARCAdmin. Updates include disabling edits for values that should not be changed, identifying in views and column data which values are reserved and recording the reserved data for applicable values.

34. (SPARCAdmin) Add New User Data Columns (LA CaTs Contribution)

A user's affiliated institution and login information has been added to the SPARCAdmin Users page to improve user management within this module.

35. (SPARCAdmin) Add Demographic Information to User Profiles (LA CaTs Contribution)

Four “personal” demographics attributes (gender, age_group, ethnicity, race) have been added as permissible values in the SPARCAdmin module. This information may be available on user’s profile for edits, if included per institution.

36. (SPARCAdmin) Fee Agreement Report Optional (LA CaTs Contribution)

The Fee Agreement Report is now configurable in the SPARCAdmin module, making it optional for display within SPARCDashboard.

37. (SPARCAdmin) Add Copyright Language as a New Setting

The ability for site administrators to update the SPARC website copyright information in the footer has been added to SPARCAdmin.

38. (SPARCFunding) Unable to export button data

Bug has been fixed that prevented downloading SPARCFunding module application data.

39. (SPARC Code Base) Update Copyright Year

The year range in the copyright language within the SPARCRequest repository has been updated to end with year 2022.

40. (SPARC Code) Firefox Icon broken in SPARC modules webpage footer

A broken link causing the Firefox browser icon in the footer of SPARCRequest, SPARCDashboard, SPARCReport, SPARCForms, SPARCAdmin, SPARCFunding modules homepages has been fixed.

41. (SPARC Data Structure) Combine Funding Source and Potential Funding Data

To optimize funding source data reported in SPARCRequest Step 2 and SPARCDashboard Study Details, funding and potential funding source and start dates have been combined into one data field. User will continue selecting proposal funding status of ‘potential’ or ‘funded’. Funding Source will no longer distinguish between ‘potential' or ‘funding’. Funding Start Date will no longer distinguish between ‘funding’ or ‘est funding’. Existing, affected data has been transferred to the combined fields.

42. (SPARC Maintenance) Remove Surveyor Specs

Work has begun to remove surveyor specs that were randomly failing on Travis CI and passing when ran locally, making makes them useless in development. SPARC test instance initiates these removals, with monitoring to be done to assess removing more in the future.

43. (SPARC Security) GitHub Security Alerts (LA Cats Contribution)

Previously, the following dependabot alerts were received from GitHub:

1. [HIGH Severity Action Pack CVE-2022-23633]

2. [HIGH Severity Active Storage CVE-2022-21831]

3. [HIGH Severity Action Pack CVE-2022-22577]

4. [HIGH Severity Action View tag helpers CVE-2022-27777]

By upgrading rails and dependencies to 5.2.8 these detected vulnerabilities have been addressed.

43. (SPARC Security) High Security Vulnerability in Active Record (LA Cats Contribution)

The following security alert was received from GitHub:

1. CEV-2022-32224

It has been addressed by acknowledging the issue and noting coders that are not impacted.

1. Run rake study_type_questions_version_3_text_change to edit the study type question.

2. Run update_permissible_values.rake to update permissible value's reserved status.

3. Run rake data:import_settings to add new settings and bundle exec rake import_permissible_values to add new permissible values"

4. Run rake update_study_type_question_text to update the text of one of the questions in the database

5. Run delete_potential_funding_values.rake to delete the no longer needed potential_funding_source permissible values.

6. Run rake update_study_question_16_text to update the text of one of the epic questions.

7. Update SPARCAdmin ‘setting.epic_user_api_error_teams_webhook’ for MSTeams URL

SPARCRequest v3.10.0

• Add external_organizations

• Add external_organizations option

• Add Associated Organizations on Protocol Information Form

• Adding the copyright year as a setting

• Replace input with span to fix double checkbox bug

• Fix SPARCFunding Document Download export button bug with refactors

• Human subjects driven logic for epic questions bug

• Multi-select documents checkbox issue fix

• Fix Service Request Status & Email Issue

• Remove ability to delete service request in fulfillment

• Filter protocols default radio fix

• Combine Funding Source and Potential Funding Source

• Cost analysis report - update column titles on clinical services with visits

• Quick bug fix where gender_other field not be shown when gender is removed from demographic setting

• Update copyright year to 2022

• CTSAsearch link removed

• Fix HTML text display

• Fix Epic user error handling error

• Max Length Validation Added to Protocol attribute 'short_title'

• Change document version column to be optional

• modify identity display_gender method

• Change language and default radio

• Fix protocol merge affiliation bug and create rake task to clean up affiliation duplicate

• Delete surveyor 'user_edits_options_field' feature test

• Update column labels on Cost Analysis report

• Add ‘Submitted On’ Column for Service Requests

• Add optional reserved column for permissible values table

• update Epic question 1

• Fix Epic question 1

• added new notifications for teams

• Add Version to Documents

• Additional changes to batch document access

• Updating Epic question and notes

• Update Epic question 4

• Fix Epic question 4

• Update reserved status for certain permissible values

• Update column labels on Cost Analysis report

• Fixing batch download issues

• Batch download additional changes

• Fixing Protocol Merge Issues

• Batch document access

• Update service search instructions

• Fix bug with dashboard merged protocol search

• Add configurable demographics attributes to profile

• Fix missing credential other error message bug

• Multi select documents and download into zip

• Notification email linking to notification message

• Make Fee Agreement Report Configurable

• Small Fixes

• Adding manually fold display of ssr

• Adding back and forth arrows to edit billing quantities window

• Fixing Travis

• Protocol merge to include non master pro number

• Allowing integer decimals

• Add the 'By' and 'Date' columns to the Form Submissions table on SPAR…

• Admin Users Page Add New Columns

• Fixing Protocol Merge Report Bug

• Spec Fixes #2860 & Spec Fixes #2861

• Message Button Tooltip Blocking Contact Names