SPARCRequest v1.6.5 + SPARCFulfillment 2.1.5 New Features

SPARCRequest Version 1.6.5 New Features

1. Adding the New BSD3 License to GitHub

Our up-to-date BSD3 License is on the GitHub under the SPARCRequest and SPARCFulfillment repositories.

1. (SPARCRequest) "About SPARC Request" Button is Now Configurable

The "About SPARCRequest" button on the SPARCRequest home page is now configurable for Open Source community. For MUSC local instance, we have linked it to our SCTR SPARC webpage; Other institutions can still turn on the popup window.

1. (SPARCRequest) Fixed Step 2B: Visit Calendar Move Visit Button Bugs

We fixed the bugs related to the "Move Visit" button on Step 2B (Visit Calendar), and improved the function of the button. In the new version, the user picks the desired position for a chosen visit, and then the chosen visit will be inserted into the selected position; the positions of other visits will be adjusted accordingly.

1. (SPARCRequest) Navigation Arrows disabled

The links on the navigation arrows on the top section of each page of SPARCRequest have been removed to increase the processing speed for bigger requests.

1. (SPARCRequest) Step 5: Submission Confirmation Button Language Change

The language on the SPARCRequest submission confirmation page has now been changed to "Go to Dashboard".

1. (SPARCRequest) Added Shopping Cart Warning Popup when Deleting an Existing Service

When a user goes back into a study/project to edit an already submitted request and click the "X" signs in the shopping cart, a warning popup message now shows up as the confirmation of deleting service(s) (which will lead to irreversibly deleting the corresponding service(s) from the protocol).

1. (SPARCRequest) Fixed Protocol Upload Documents Bug

Some user(s) experienced a bug during Step 3 (Shared Documents & Notes page), which was caused by the structural change in SPARCCatalog during the lifetime of that study/project that was being edited. In this new release, we have fixed the bug.

1. (SPARCRequest) "Create an Account" Button is now Configurable

We deleted the "Non-MUSC User" button on the SPARCRequest homepage to prepare for the new process for the MUSC affiliated NetID registration, and the button, as well as the context on the button, is now configurable for Open Source community.

1. (SPARCRequest) Hovering Effect Added for All Buttons

Button reaction features have been added to SPARCRequest. All the clickable buttons are now highlighted when the mouse hovers over them as a user-friendly improvement (see example below).

1. (SPARCRequest & SPARCCatalog) Description Added for Cores

Upon requests from users, we built the functionality for adding description language for cores.

1. (SPARCCatalog) Checkpoint Added to Price Import Scripts

For the pricing import scripts, checkpoint have been added to double-check that the values in the "calculated" and "override" fields for the Federal Rate, Corporate Rate, Other Rate, and Member Rate are smaller than the Service Rate (full rate). When a pricing map does not pass the checkpoint successfully, it is exported onto an excel spreadsheet for the catalog manager to review and fix the issue.

1. (SPARCCatalog) Display Pricing to Cents

In SPARCCatalog, the pricing now accurately reflected by two decimal places after dollar, even when the digit for cent is 0. This change is reflected in both the "Pricing" tab and the "Subsidy Information" tab.

1. (SPARCRequest, Dashboard & SPARCAdmin) Holding Service Request Statuses for Re-submissions

When a user re-submit a Study/Project by going through "Edit Original" or "Edit" button and to edit an existing request, it was causing status changes (back to "Submitted") for other service providers who did not want to make the change. In this new release, the re-submissions will not affect the current status of other services that are already under different statuses.
We also adjusted the behavior of the "Get Cost Estimate" button and its impact on the statuses, so that users can get a cost estimate and still come back later to the same study and still able to submit it to start services. We also fixed a bug to make the "get cost estimate" time stamp shows correctly in SPARCAdmin.

1. (SPARCRequest, SPARCDashboard, & SPARCAdmin) Fixed Research Nexus Status Lock

When a request for SCTR Research Nexus is under certain statuses (such as "Active", "In Admin Review", "On Hold", etc), and a user tries to modify the same request, he/she will get an error message to prevent the editing, so that it doesn't affect the Nexus fulfillment process.

This lock mechanism was not working for some Nexus services. We have fixed the bug that caused it, and now it works on every service under the Research Nexus. If a Nexus request is under any statuses except for "Daft", "Get a Cost Estimate", "Submitted", and "Awaiting Requester Response", the user will not able to edit.

1. (SPARCAdmin) Admin Fulfillment Time Input Reconfiguration

The Admin fulfillment section (in SPARCAdmin Fulfillment tab) has been reconfigured so that the Administrator has to choose a "Timeframe" for his/her fulfillment to be able to enter the amount of the time for each fulfillment to prevent empty entries and to increase the accuracy of the Admin Time .

1. (SPARCDashboard) Consolidated Request Reconfiguration

When clicking the "Export Consolidated View" button, there is now a filtering mechanism for statuses so that any unsaved draft request is not showing in the Consolidate Request report.

1. (SPARCDashboard) Default to Keep All Tabs Closed

Instead of opening the first study/project on your dashboard every time, the default display is now changed to keep all the decks closed.

1. (SPARCRequest, SPARCDashboard & SPARCAdmin) Show Statuses on the Study Calendar

On the study calendar for SPARCRequest, SPARCDashboard, and SPARCAdmin modules, now the statuses of each service is showing (as the status that the corresponding sub-service-request).
SPARCRequest

SPARCDashboard

SPARCAdmin

1. (SPARCReport) Protocol Report Reconfiguration

In this new release, we have revamped the Protocol Report in the following aspects:
1). Remove the status filters;
2). Always display the Institution, Provider, Program, and Core columns;
3). Added the columns for names and emails of the Primary Coordinator(s) and Business Manager(s);
4). Added Protocol Title, Funding Source/Potential Funding Source, and Sponsor Name columns.

1. (SPARCReport) Service Request Report Reconfiguration

Now this report always shows which institution, provider, program, and core the service requests belong to. Also, the "Protocol Short Title" column was added to the report and the sequence of the columns adjusted.

1. (SPARCReport) New Admin Fulfillment Time Report

A new type of canned report has been added - "Admin Time" report. This report outputs information related to the Admin turnaround time and fulfillment time for requested services (as shown below), which were entered in the SPARCAdmin module under the "Fulfillment" Tab.

1. (SPARCReport) Fixed Service Pricing Report Bug

The bugs for the Service Pricing report in the SPARCReport module were fixed, and now the report can be run for any chosen time point; If the listed service(s) didn't have a pricing map for the chosen date yet, the corresponding pricing will show as "N/A".









SPARCFulfillment Version 2.1.5 New Features

1. (SPARCFulfillment) Homepage Columns Customization

The columns on the SPARCFulfillment homepage now holds the most recent chosen columns from the same computer, so that the user doesn't have to re-select the preferred displayed columns every time.

1. (SPARCFulfillment) Protocol Filter Dropdown List Reconfiguration for Reports

For all the reports in SPARCFulfillment, the protocol(s) multiple choice dropdown list has been reconfigured, so that the checkmarks for the chosen protocol(s) will always display no matter how long the titles of the chosen protocols are; And the user can choose to "Select All" or "Deselect All" protocols if needed.

1. (SPARCFulfillment) Display Current User on Navigation Bar

In this new release, functionality has been added so that the person currently logged in is always displayed on the navigation bar next to the "back" button.

1. (SPARCFulfillment) Notes Indicator Developed

Notes indicator has been added to show clinical providers whether this are notes attached to the fulfillment entries: if the icon has a white background, it means there is no note yet; If the icon has a blue background, notes already exist.

1. (SPARCFulfillment) Change Report Filter Default Display to "All Protocols"

We have changed the language of the default display of the Protocol(s) filter for relevant reports in SPARCFulfillment to "All Protocols" to reduce confusion.

1. (SPARCFulfillment) Fixed Sorting by Date for Study Level Activities, Completed Visits, and Documents

In the new version of SPARCFfulfillment, the "sort/display by date" function has been reconfigured to fix previous bugs. Now all the sections that utilize date sorting, such as Study Level Activities, Completed Visit list, and Documents are all sorting/displayed by date correctly.




"Study Level Activities" Section

"Completed Visits" List

Documents/Reports Page

1. (SPARCFulfillment) Fixed Visit Completed Date Bug

We have fixed the bug related to the visit completed date, which was causing it not to auto-update on the list of completed visits when the clinical provider(s) changes the completed date.

1. (SPARCFulfillment) Change Default Settings for Position when Adding a Visit or Custom Visit

The required field "Insert into Position" is now defaulted to "Nothing Selected" when a user click "Add Visit" on the Study Calendar or for Individual Patient, instead of default to "Add as last", so that the user is more aware of where the newly added visit is positioned at.
Also, a "*" sign has been added next to "Insert into Position" label to indicate that is required.

1. (SPARCFulfillment) Fixed the Bug of Wrong Header End Date in Reports

We fixed the bug that was causing the "end date" in the header section of the SPARCFulfillment reports with end date filter (Invoice report, Auditing report, Project summary report) pulling one day after the actual chosen end date (i.e., showing 4/1/15 instead of the chosen 3/31/15).

1. (SPARCFulfillment) Total Cost Rows Alignment Adjusted for Invoice Report

We adjusted the alignment of the total cost rows in the invoice report to clarify what data the total costs are calculated upon.

1. (SPARCFulfillment) Fixed the bug with Deleting All Procedures in a Visit

In the new release, we have fixed the bug that was causing the deleted procedures re-appear when the clinical provider deletes all the services for a visit under the participant tracker and refresh the page.

1. (SPARCFulfillment) Status Dropdown List Reconfiguration

For the status dropdown list on the homepage, the following improvements have been made:
1) The default status is now "All" when the homepage loads.
2) "Get a Quote" has changed to "Get a Cost Estimate."
3) Statuses have been re-ordered on the dropdown list so they follow the Alphabetical order.


List of Programming Changes with Links to GitHub
SPARCRequest v1.6.5:

• Refactor protocols controller new action View commit
• Fixed Epic bug when changing a study to project in SPARCAdmin View commit
• Holding SSR Statuses for Re-submissions View commit
• Make "About SPARCRequest" button configurable View commit
• Make Description available to Cores View commit
• (SPARCReport) Protocol Report Reconfiguration View commit
• Consolidating duplicate code in layouts View commit
• Fixed Epic Admin Portal bug View commit
• Updated BSD3 license file View commit
• Hide 'draft' and 'first_draft' SSRs from consolidate request View commit
• Fixed validation on inactive studies View commit
• "Go to Dashboard" Text change View commit
• Epic validation bug View commit
• Remove arrow step links  View commit
• Popup dialog for deleting services from submitted requests View commit
• "Get a cost estimate" button no longer sets the SR submitted_at date View commit
• Green suite View commit
• Refactored associated survey spec View commit
• Refactoring documents page to fix bug related to changing split/notify View commit
• Added status to Consolidated Request View commit
• Added fields to protocols report  View commit
• Migrations for changing defaults View commit
• Fixed epic answer bug View commit
• Added SSR ID into survey link View commit
• Added status to SPARCRequest consolidated view View commit
• Added hover effect to buttons View commit
• (Dashboard) stop auto opening protocols View commit
• (SPARCRequest) Outside User create account button configurable View commit
• (Dashboard) Fixed inactive study bug View commit
• (SPARCCatalog) Fixed pricing map bug View commit
• Add service status to SPARCAdmin View commit
• Needed to use helper method to display status correctly View commit
• Updating a Few Configuration Options View commit
• (SPARCReport) Service Pricing Report display "N/A" in pricing columns for services that do not have a pricing map for the specified date View commit
• (SPARCReport) Admin time unit cleanup and input reconfiguration View commit
• Reconfigured setup_protocol class to return Epic services Boolean View commit
• (SPARCCatalog) Fixed max dollar cap bug View commit

SPARCFulfillment v2.1.5:

• Date Picker Modifications View commit
• Time Zone Reconfiguration for Incomplete Visit View commit
• Completed Visits Sorting Fix View commit
• Added BSD3 license txt file View commit
• Fixed Deleting All Procedures Bug View commit
• Customized homepage columns: bootstrap table cookie View commit
• Fixed identity views reports tab spec View commit
• Report Time Zone Display Fix View commit
• Refactor multiple line items controller View commit
• Fulfillment invoice report cost column alignment View commit
• Fixed Custom Date Sorter View commit