Purpose

The purpose of this document is to provide new functionality, enhancements as well as bug fixes for the 4.7 release of the Life Sciences Analytics Cloud (LSAC).

Acronyms & Definitions

Term

Definition

LSAC

Life Sciences Analytics Cloud

CI

Clinical Insights

OI

Operations Insights

RACT

Risk Assessment & Categorization Tool

RBQM

Risk Based Quality Management

OOTB/OTB

Out of Box/Out of the Box

SSO

Single Sign On

MSF

Master Study Filter

SCE

Smart Clinical Explorer (CI dashboard)

DM

Demographics

CRA

Clinical Research Associate

CSV

Comma Separated Values

UI

User Interface

CQS Schema

Database with tables containing data related to OI, CI, and RBQM.

AE

Adverse Events

USDM

Unified Study Data Model

CTCAE Grading

Common Terminology Criteria for Adverse Events (Grade refers to the severity of AE)

KPI

Key Performance Indicator

eCRF

Electronic Case Report Form

ST

Solid Tumors tab in SCE

MH

Medical History tab in SCE 

AWSAmazon Web Services
DCSaama's Data Center

Scope

The scope of the 4.7 release of LSAC includes new features/functionality as well as bug fixes and known issues. This document also ensures that release 4.7 has been validated as per Saama’s validation process (Product Validation CSV Procedure).

Release Notes

As part of the LSAC 4.7 release, the new features and enhancements are listed below. These will be deployed on Saama's DC and AWS.


This release, LSAC v4.7, focuses on several enhancements across the LSAC analytics. Calculation logic has been enhanced across some CI and OI widgets. Certain OI Listings have been enhanced. The Infographics/Summary Cards section, which is part of the CI dashboards, has been improvised. Date and Time logic, on some widgets, has been enhanced for better understanding. The Smart Suggestions module has been supplemented with new suggestions in the Vital Signs & Laboratory Tests domain. 


The features/enhancements are categorized and briefly discussed below for better understanding and assimilation. 


  • Operation Insights

                     

The Operations Insights application provides timely, targeted analytics to enable executives, study managers, and CRAs to monitor and optimize key operational metrics across a portfolio of clinical studies for functional domains such as Enrollment, Subject Compliance, and Site Productivity.


Enhancement! Calculation Logic update for Enrollment Rate and Cumulative Enrollment in Line Chart


Enrollment Rate calculation and Cumulative Enrollment calculation in the Line Chart will stop at the date where ‘Last Patient In’ milestone is achieved. The following dashboards, in the given focus areas, are benefited by the change.


OI dashboards

Study

Study Summary dashboard | Enrollment Dashboard - Study | Site Activation Dashboard - Study | Quality Measures Dashboard - Study | Site Performance - Study | Safety Summary Dashboard - Study

 

Site

Site Summary dashboard | Site Cross Study Performance | Enrollment Rates – Listing | Subject Enrollment Rate – Site

 

Country

Subject Enrollment Rate - Country

 

Portfolio

Portfolio Summary Dashboard - Study | Executive Summary – Study

 

Subject Enrollment Folder

Subject Enrollment Rate - Study

 

RBQM

Oversight Scorecard



Enhancement! Column additions & UI updates to the ‘Subject Visit Tracker’ widget


The following updates have been made to the Subject Visit Tracker widget:

  1. The unscheduled visits in the Subject Tracker widget, now appear with scheduled visits, in the order that they are conducted in, in the Visit Name column in the CSV file download.
  2. The CSV download will be visibly aligned with the UI configuration settings applied to the columns of the Subject Visit Tracker widget table.
  3. The subject visit data will appear in expanded form for the first active site of the selected study. Users can expand other sites to view site data and then click Collapse All to collapse/close all the site records. Collapse All button is greyed when all site records are closed/collapsed.
  4. The date captured for various events like Enrollment, Screening, Consented, Randomization, and Visit Conduct will be displayed in the format of the time zone it is seen in.
  5. Three new columns, namely, Site Name, PI Name, and PI Email have been added to the Subject Visit Tracker widget table.
  6. The icons for single and multiple unscheduled visits have been changed.

                   

Enhancement! Complete milestone names in Executive Summary dashboard – Portfolio


The data in multiple Parquet files is loaded in discrete portions, which are subsequently persisted in a temporary table. These individual segments are then amalgamated and persisted in the main table.

  1. Complete names of milestone labels are available in tooltip in Study Details table in Study tab when user hovers over the Info icon that is next to the column name.
  2. Complete names of milestone labels are available in tooltip in Country Details table in Country tab when user hovers on the Info icon that is next to the column name.


Enhancement! Open Filter Panes on Dashboards


The filter panes will be displayed on the left side, by default, when the dashboard is opened/loaded. This setting is applicable to all dashboards except to the following OI dashboards:


OI dashboards

Study

AE Against Study Baseline - Study | Monitoring Visits Past Due - Study| Drug Accountability by Status - Study | Query Rate by eCRF - Study

 

Site Productivity

Data Entry Rate – Study | Query Rate – Study | Issue Resolution – Study | Open & Answered Queries by Age - Study

 

Portfolio

Portfolio Summary

 

Site

Site Summary | Open and Answered Queries by Age

 

Data Quality

Missing Data per Visit – Study

 

Subject Compliance

Primary Endpoint Data Entry Rate - Study


Enhancement! Site Performance dashboard


There is visibility of sites with KPI value as ‘zero’ in the existing widgets (charts and tables) of the Site Performance dashboard.


Enhancement! Addition of columns & UI updates on ‘Actual and Planned Monthly Enrollment’.


The following enhancements have been done to the Actual and Planned Monthly Enrollment widget:

  1. The widget has been renamed to 'Actual and Planned Enrollment'.
  2. The following metrics have been added to this widget:
    1. Planned Enrollment (Cumulative)
    2. Actual Enrollment (Cumulative)
    3. Enrollment %
  3. Existing rows will be renamed as Planned Enrollment (Monthly) and Actual Enrollment (Monthly).
  4. Cumulative Actual Enrollment will stop showing when the Last Patient In date is identified for the study. The date column will be highlighted with color and an Info icon will show the milestone label and date in the tooltip.


Enhancement! Addition of new columns to Listings relevant to Subject Visit Compliance


Three new columns, namely, PI Name, PI Email, and Subject Status have been added to the following listings accessible in OOTB listing and in KPI Studio Listings. PI Name and Subject Status are also added to the multi-select local filter pane of the following listings.

  1. Subject Visit - Listing - Site
  2. Latest Subject Visit - Listing - Subject
  3. Subject Visit - Listing - KPI Studio
  4. Latest Subject Visit - Listing - KPI Studio


Enhancement! Updates in AE Count logic for counting AEs from Consent Date.


The AE Count logic has been enhanced to count AEs from Consent Date. The following dashboards have benefited from the change:


OI dashboards

Study

Safety Summary dashboard | Site Performance – Study 

 

Site

Adverse Events – Listing | AE Rates – Listing | Site Summary | Site Cross Study Performance - Site

 

Study/Country/Site

AE Terms by Relative Study Week | AE Against Study Baseline | AE Rates per Subject Days

 

Portfolio

Portfolio Summary

 

RBQM

Oversight Scorecard


Enhancement! Reordering of Infographics in Study Summary dashboard – Study


Study ID and Medical Indication are now added to the Infographics section in Study Summary dashboard and the infographics information is ordered as follows:

  1. Study Name
  2. Study ID
  3. Therapeutic Area (Newly added)
  4. Medical Indication (Newly added)
  5. Phase
  6. Study Start Date
  7. Study End Date

Enhancement! Change in the Subject Days calculation logic


The minimum date logic, as part of the Days Calculation, has been updated and has been applied across the following dashboards for harmonization in data deliverance.


OI dashboards

Site

AE Rate per Subject Days | Query Rate - Site | PD Rates – Listing | Open Query Rates – Listing | Query Rate by eCRF - Site | AE Terms by Relative Study Week - Site

 

Site Productivity

Query Site Summary – Listing | Query Rate - Study

 

Country

AE Rate per Subject Days - Country | Query Rate - Country | AE Terms by Relative Study Week - Country | Query Rate by eCRF - Country

 

Study

Query Rate by eCRF - Study | AE Terms by Relative Study Week - Study

 

Subject 

Subject Days by Subject – Listing

 

RBQM

Oversight Scorecard


Enhancement! Change in the Subject Days calculation logic


Logic for count of subjects with screen failure by different reasons in the Screen Failure by Reason – Study/Country/Site is enhanced as per the logic in Enrollment dashboard – Study.


The details of the requirements are available in Requirement Specification Document (Reference Document ID: , v12.0)


  • Clinical Insights

         

The Clinical Insights application enhances your analytics capabilities for more accurate data review and better decision making. Clinical Insights removes the lag time between the data requests and data availability by eliminating manual work, removing data management complexity, and presenting intuitive patient and cohort level dashboards.


Enhancement! Calculation/Title Updates on SCE Summary Cards


Summary cards, in the following domains of the SCE dashboard, have undergone a calculation and/or title update.


Summary Card

Title Update

Logic Update

CM tab

Total Count of Distinct CMs

Y

 

Total Count of Subjects with CMs

Y

Y

CM with Highest Subjects

Y

Y

Count of Ongoing CMs

Y

Y

Count of Subjects with Ongoing CMs

Y

Y

MH tab

Distinct MH Coded Term

Y

 

Total Count of Subjects with Medical History

Y

Y

Top MH Coded Term

Y

Y

Ongoing MH

Y

Y

AE tab

Subject with AEs

Y

Y

Treatment Emergent AEs

Y

Y

Subjects with Serious Related AEs

Y

Y

Related AE Casualty

Y

Y

Serious AEs

Y

 

Ongoing AEs

Y

Y



Enhancement! Removal of Summary Cards – SCE dashboard


The following summary cards, from various domains of the SCE dashboard, have been removed.


Sr. No.

Summary Card

AE tab

1

SAE to AE Ratio

2

Adverse Events of Special Interest

3

Top SOC with Highest AEs

4

Site with Highest Study Drug Related AE

5

SAE with Highest Count

6

AE with Highest Count

7

Site with Highest SAEs

8

Site with least subjects with AEs

CM tab

1

Percentage of subjects with CM

2

CMs without Medical Indication

3

Average CM Count

4

Site with highest subjects using CM

5

Most frequent CM Indications

6

Site with Highest CM Count

MH tab

1

Percentage of Subjects with Medical History

2

Count of Subjects for Top MH Body System

3

Average MH per Subject

4

Site with highest number of subjects with MH

5

Subjects without Medical History

6

Ongoing Subjects with MH

           


Enhancement! Rearrangement of Summary Cards in SCE dashboard


Summary cards in the AE, MH, and CM tab (domain) of the SCE dashboard have been rearranged based on the Study/Event level categorization.


Enhancement! Updates on the AE Subject Count table


The label ‘Randomized Subjects’, in the AE Subject Count table, has been changed to read as ‘Enrolled/Randomized Subjects’ and column logic has been enhanced to handle scenarios when randomized subjects are not present in the study.


Enhancement! Updates to the Adverse Event Listing 


The updates to the Adverse Event Listing, present in the AE tab of SCE dashboard, are listed as follows:

  1. The existing 'rpt_ae' logic has been updated to display the correct count of records in the Adverse Event Listing.
  2. New column, namely, 'AE End Day' has been added.
  3. Column logic has been updated to retrieve the CTCAE grading from the USDM table and not from the PLO layer.

 

Enhancement! Time display updates to Adverse Event OOTB Listing


The Start/End Time columns, in the Adverse Event OOTB Listing, show the user-configured time value.


Enhancement! Enhanced performance of ‘Adverse Event – Toxicity Profile: Study’ dashboard.


The performance of the Adverse Event – Toxicity Profile dashboard in the focus area Study has been enhanced as per the NFR requirements.


Enhancement! Error fixes on CQS Schema


The ‘endpoints valid’ warnings have been fixed on ‘Edit CQS Schema’.


Enhancement! Column addition to USDM layer


A new column ‘AETRTEM’ has been added to the AE table in the USDM schema.


Enhancement! Column headers to CM table & MH table


The column labels have been updated in the Concomitant Medication table and in the Medical History table, present in the CM tab & MH tab respectively of the SCE dashboard.


Enhancement! Calculation Logic Update in PLO layers


The minimum date logic, as part of the Days Calculation, has been updated and has been applied across the following dashboards for harmonization in data deliverance.


CI dashboards

Study

Adverse Event – Toxicity Profile | Adverse Event Reporting Delay

 

Safety 

AE Terms by Relative Study Week – Study / Country / Site

 

Patient Profile 

Subject Event Log | Graphical Patient Profile – Exposure | Graphical Patient Profile – Labs | Lab Spaghetti Plot – Absolute Value | Subject Progression | SCE – DM tab – Patient Story | SCE – Lab tab – Lab Spaghetti Plot – Absolute Value | SCE – Solid Tumors tab – Change from Baseline SOD Chart | SCE – Solid Tumors tab – Disease Response Assessment Chart | SCE – Solid Tumors tab – Disease Response and Clinical Classification Listing


Enhancement! Updates in AE Count logic for counting AEs


The AE Count logic has been enhanced to count AEs with complete subject start date. The following dashboards have benefited from the change:


CI dashboards

Study/Country/Site

AE Rate per Subject Days

 

Study

AE Toxicity Profile | Adverse Events Reporting Delay

 

Patient Profile

Subject Event Log | Subject Progression | Smart Clinical Explorer


Enhancement! Removal of metrics 


The following metrics, associated with baseline deviation, have been removed. These are:

  1. The metric '%Change from Baseline' has been removed from Labs tab in the SCE dashboard - Patient Profile.
  2. The dashboard 'Lab Spaghetti Plot: Baseline Deviation' - Patient Profile has been removed.

Enhancement! Logic Update on Demographic Listing – SCE 


To show correct data under Demographic Listing, that is in the DM tab of SCE, the query/logic has been updated to capture screening data based on the field ‘vsseq’ value for each subject & vstest in the VS table. 


Enhancement! Correct count of records in Solid Tumors tab


Code fix has been done to show the correct count of records in the Disease Response & Clinical Classification Listing widget table and in the summary cards: Subject with Progressive Disease and Subjects with New Lesion in the Solid Tumors tab of SCE.


Enhancement! Correct count & percentage of subjects in Medical History table


Code fix has been done to show the correct count and percentage of subjects in the Medical History table present in the MH tab of SCE.


Enhancement! Units for Weight, Height, and BMI


The values of weight, height and BMI will be accompanied with their corresponding units in the Demographic Listing, present in the DM tab of SCE. The column header BMI will show as Body Mass Index. 


Enhancement! Negative values on X-axis (Relative Study Days)


The X-axis (Relative Study Days) of the Patient Story widget, in the DM tab of SCE, will be able to show negative values as per the available data.


Enhancement! Open Filter Panes on Dashboards


The filter panes will be displayed on the left side of the dashboard, by default, when the dashboard is opened/loaded. This setting is applicable to all dashboards except to the following CI dashboards:


CI dashboards

Safety

Hy’s Law Dashboard | AE Rate per Subject Days – Study | AE Terms by Relative Study Week – Study | Alt v/s Bili 

 

Compliance

Protocol Deviations per Subject per Visit - Study


  • Smart Suggestions

       

Smart Suggestions AI tool increases the potential to make insightful decisions based on suggestions generated using AI ML which is a much time-saver as it speeds up the data analysis by 60-70 percent for medical monitors.

Smart Suggestions has been implemented on the SCE dashboard in Clinical Insights (Patient Profile). The objective here is to identify and capture succinct unique patterns in clinical data and to be able to detect risk factors in the early phases of the study. To analyze and extract meaningful information from complex clinical data, a powerful computing tool is necessary.


New! New smart suggestions.


New smart suggestions, in the following domains, have been introduced to:

  1. Identify severe propagation in Vital Signs measurement.
  2. Detecting Outliers in Vital Signs & Lab Tests.

Enhancement! Improved sentence structure in Smart Suggestions.


The sentence structure of existing smart suggestions has been improved.


  • Security Testing

       

Enhancement! Security Risks addressed in Operations Insights


Vulnerabilities or security risks have been addressed for the following dashboards under Operations Insights in LSAC Analytics:


OI dashboards

Study

Subject Visit Compliance - Study | Site Performance - Study| Site Activation Dashboard - Study | Enrollment Dashboard - Study | Safety Summary Dashboard - Study |Quality Measures Dashboard – Study | Data Metrics Dashboard – Study

 

Site

Site Summary | Site Cross Study Performance 

 

Study/Country/Site

 

Subject Visit Compliance with Schedule | AE Against Study Baseline | Data Entry Rate | Query Rate | Monitoring Visits Past Due | Consent Failure Rate | Subject Count by Latest Scheduled Visit

 

Portfolio

Executive Summary – Overview/Study/Country | Portfolio Summary

 

RBQM

Oversight Scorecard


Enhancement! Security Risks addressed in Clinical Insights.


Vulnerabilities or security risks have been addressed for the following dashboards under Clinical Insights in LSAC Analytics:


CI dashboards

Patient Profile

Smart Clinical Explorer

 

Safety

Adverse Event – Listing

 

Study

Adverse Event – Toxicity Profile

AI Across SCE dashboard (Focus)

Smart Suggestions

Known Bugs/De-Scoped Functionalities/Limitation

Below is the list of Deferred bugs from the Current and Past releases: 


ID #

JIRA Description

Impact & Justification

Product Release No.

COM-11450

The CM data points seen in the pop-up by hovering over the Subject ID, in Patient Story widget in DM tab of SCE, shows value as 1, despite there being multiple CM data points.

Deferred. 

This is a not a bug. It is a product enhancement and was not part of the initial requirement. The change requires logic update in X-axis to respond to time variation in the current widget.

Severity: Low.

LSAC v4.7

As mentioned in the Quality Summary Report, LSAC-QSR-4.6 (AWS + DC), there are no deferred issues from LSAC v4.6.

Bug Fixes

Below is the list of Resolved Issues from this release: 


ID #

JIRA Description

Resolution

Operations Insights

COM-10798

The Help icon when clicked, in Missing SDV Listing in OI, is displaying an error message as Access Denied.

Resolved. The Help icon is working as expected and does not throw any error message when clicked upon.

COM-10477Widget labelling is not consistent in Enrollment dashboard - Study (Study focus).Resolved. The widget labelling has been improvised to make it consistent.

COM-10951

The Site Performance dashboard is not loading in Analytics.

Resolved. The Site Performance dashboard is working as expected.

COM-10802Count for ‘I/E Criteria not met’, in Screen Failures by Reason widget in OI, is not matching with the count seen in DB.  Resolved. The count, displayed in UI, has been made consistent with the DB for the Screen Failures by Reason widget.
COM-10661The Country filter value in the Country tab of Executive Summary dashboard is carried over to the next customer account.Resolved. The carry over of filter values does not occur when client accounts are switched over.
COM-10662The bars and data markers on the Site Activation & Enrollment Over Time widget turn grey on pinch and zoom functionality. The defect found in Site Activation dashboard – Study (Study focus), Enrollment dashboard – Study (Study focus), Executive Summary – Study tab (Portfolio).Resolved. The bars and data markers are working as expected on zoom and pinch in functionality.
COM-11062The Site Summary card, in Executive Summary – Study tab, is showing Active States, on click, and not Active Sites.Resolved. The Site Summary card is showing the correct and expected values.

COM-11455

The milestone view seen in the Study tab of Executive Summary is not correct and seems to be duplicated.

Resolved. The milestone view is displaying the milestone information correctly.

Clinical Insights

COM-9796

The DSTERM does not appear for one particular subject in the Subject Progression dashboard under Patient Profile.

Resolved. The DSTERM is visible for the particular subject in question.

Other Bug Fixes in LSAC Analytics

Other Bug Fixes in LSAC Analytics

The Subject Screened summary card, in the Enrollment dashboard – Study, is not showing the correct finding.

Resolved. The Subject Screened summary card in the Enrollment dashboard – Study is working is showing the correct results.

The Race pie chart in the SCE dashboard, is not showing values for the following races: Black or African American, and White.

Resolved. The Race pie chart is working as expected and is showing values for all the races included in the CI application.

For a specific study, the Patient Story widget icons, in the SCE dashboard – DM, are overlapped and not clearly visible.

Resolved. The Patient Story widget icons, in the SCE dashboard – DM tab, are working as expected.

The CSV export of the Subject Status Tracker widget, in the Enrollment dashboard, is not capturing the Subject ID column.

Resolved. The CSV export of the Subject Status Tracker widget, in the Enrollment dashboard, is working as expected.

The Safety Summary dashboard – Study in OI is not able to load or to be executed when selected.

Resolved. The Safety Summary dashboard – Study is loading/executing when selected.

All records are not displayed in FormID in the Query Rate by eCRF – Study/Country/Site dashboard. This issue is at the site level.

Resolved. The count of records shown in the bar chart is consistent with the record rows visible in the Form ID, at site level, in the Query Rate by eCRF – Study/Country/Site dashboard.

References


Sr. No.

Document Name

Document ID

1

Project Change Request and Impact Analysis – LSAC v4.7

CR-LSAC-016

2

LSAC 4.7 - Quality Plan

LSAC-QP-4.7 (AWS+DC)

3

Requirement Specification Document - LSAC

FSQ-LSAC-4.7.0-DC+AWS

4

LSAC 4.7 - Quality Summary Report

LSAC-QSR-4.7 (AWS+DC)

5Product Validation CSV Procedure1378


Technical Support

Customers can submit issues via our support portal (support.saama.com) or calling the support line (866) 619-9995 during normal business hours. For any other query customers can contact us on the email address: support@saama.com

Annexure

Not Applicable.