New Features in 19R3.4
Custom Listings, Import Error Logs, and more...
Release Date: February 21, 2020
We are pleased to bring you the following new features in this week's release. See a summary of feature enablement for this release below.
Vault Data Workbench
The following are new features for the Vault Data Workbench application, the Vault CDMS solution for data cleaning and reporting.
Custom Data Listings
With this release, users can now create custom data listings. Data Workbench uses data listings to generate complex clinical data reports across a study. Users can create a CQL query to return the clinical data they want to review, view the results, and save that query as a custom listing. Users can also assign a category to their custom listings to categorize them based upon their organization’s business practices. They can choose to share their listing with others, or mark it as a private listing. Any private listings display in Listings > Private Listings, while all public custom listings and core listings are listed in Listings > Public Listings.
As part of this enhancement, we relabeled My Listings as Private Listings.
Custom listings enable users to create and save complex reports based on various slices of clinical data across both EDC and 3rd party data. Users can save these listings privately, share them publicly, and categorize them according to business practices.
The ability to create custom listings is available automatically with this release. Users can create a custom listing by modifying an existing listing and then using Save As.
Specify Data Types for Imported Items
When importing third party data into Data Workbench, a user can choose to include meta information for each column to describe the item’s data type. The manifest file allow for an item to be defined using the following data types:
If the manifest file doesn’t specify a data type for a column, Data Workbench treats it as text by default. The manifest file can also define additional properties for an Item by data type, such as Length and Precision for float-type items, or Date Format for Date- and DateTime-type items.
By specifying metadata for data Items in the import package, users can ensure that data is consumed and treated appropriately into Core Listings within Data Workbench.
This feature is available automatically in all vaults containing the Data Workbench application.
Data Import Error Logging
When an import of third party data into Data Workbench fails, Data Workbench now records those errors and saves them to the FTP directory for review. The log includes the following for each error: Package Name (the name of the ZIP file), Study, Source, File Name (the name of the individual CSV file that caused the error), Row (the row number of the error in the CSV file), an error message, the date of the import attempt, and IDs for the job and error.
Users who initiate data import via FTP are now able to review errors and correct them independently, without having to contact the Vault CDMS Product Team for additional assistance.
This feature is available automatically in all vaults containing the Data Workbench application. Users will see the error log upon their next failed import attempt.
Role Management & Security
Features in this section are enhancements to the Role Management area and Study Roles, security and access control in Vault CDMS, and user management.
Access to Data Workbench Controlled by Workbench Tab Access
With this release, we added the new Workbench Tab permission to Tools > Role Management. This permission controls the ability to access the Workbench tab and run or schedule the Workbench Export job.
In vaults where Role by Study is enabled, this permission provides all necessary access to Data Workbench. In vaults using profile-based security, users must have both the Tabs: Workbench and API: All API permissions.
The new permission is available automatically in vaults where Role by Study is enabled. A user administrator can assign it to custom Study Roles right away. In vaults using profile-based security, an administrator can configure a custom security profile.
Feature Enablement Summary
|Role Management & Security|
|Access to Data Workbench Controlled by Workbench Tab Access||Auto-on||All|
|Vault Data Workbench|
|Custom Data Listings||Auto-on||Data Workbench|
|Specify Data Types for Imported Items||Auto-on||Data Workbench|
|Data Import Error Logging||Auto-on||Data Workbench|
See the following explanations for feature enablement options:
|Auto-on||Automatically activated and no configuration is required before using the feature; note that in some cases, a new feature is dependent on another feature that must be enabled or configured.|
|Study Feature Flag||This feature is available by configuration within the Study Configuration object (or similar).|
|By Study Build||The configuration options for this feature are available automatically in Studio or EDC Tools, but you must configure them within your Study for those options to apply.|
|Support||On/off option controlled by Support.|