In Veeva Safety Signal, you can create safety views of the Signal View type to use Signal Case Series. A Signal Case Series includes a set list of Cases to ensure the data does not change for all collaborating users. Some Case series views may be available in your Vault.
After completing the configurations in this article, you must configure Signal Calculations and Signal Product Profiles for Case series.
About Signal Case Series
Signal Case Series is a static list of Case versions that does not change over time. You can use Case series for consistent signal detection and analysis for multiple sources and then visualize this information using Workbench Dashboards.
About Active MedDRA Identification
When creating Signal Case Series, Vault can identify the MedDRA Version using the active MedDRA dictionary version in your Vault at the time of the data sync from Safety. Vault displays this data in the configuration summary file for Signal Calculations.
About Case Series Filtering by Reporting Period
You can open a Workbench Dashboard for Signal Case Series directly from a Signal Reporting Period. This provides a broader analysis by allowing you to view all Cases associated with all Case series within a reporting period.
About Direct Links to Case Series Dashboards from Statistical Data
You can navigate directly to a default Workbench Dashboard for a Signal Case Series from the Case count fields on a Statistical Data record. Vault also supports dashboard linking for Picklist and Yes/No-type fields.
Note: The Signal Case Series must be associated with a Signal Reporting Period, a Signal Data Source, and a Case Series Field Name.
Configuration Overview
Configuring your Vault to use Signal Case Series involves the following steps:
- Configure object layouts
- Configure the Statistical Data object
- Configure the Open Case Series in Workbench Dashboard action
- Create safety views for Signal Case Series
- Assign the Case Version Key on Principal Views
- Configure user & Admin permissions
Note: Depending on your Vault’s creation date and which features are currently enabled and configured, some of the steps described in this article may be unavailable or already complete in your Vault.
Configuring Object Layouts
You must configure the following object layouts:
- Workbench View
- Signal Case Series
- Signal Calculation
- Signal Calculations Setting
- Signal Calculation Run
- Signal Product Profile
Configuring the Workbench View Object Layouts
To update the Workbench View object layouts to support Case series on safety views:
- Navigate to the Signal View object type layout and configure the following:
- In the Details section, add the Signal Case Series Enabled field.
- In the View Columns section, edit the default columns to include:
- Signal Case Series Key
- Case Version Key
- Navigate to the Principal View object type layout and in the View Columns section, edit the default columns to include Case Version Key.
Creating the Signal Case Series Object Layout
Create a Signal Case Series object layout with the label Signal Case Series Layout. Then, add the MedDRA Version field to the Signal Case Series object layout to support active MedDRA version identification.
Configuring the Signal Calculation Object Layout
To update the Signal Calculation object layout:
- In the Details section, add the Case Series View field to support Case series-enabled safety views when running Signal Calculations.
- Create a layout rule to hide the Case Series View field for advanced Signal Calculations with the following configuration:
- Label: Enter
Hide Case Series View - Description: Enter
Hide Case Series View for advanced calculations - If this Layout Rule Expression is True: Enter
query_type__v != 'sql__v' - Apply the following display effects: Select Hide > Fields > Case Series View
- Label: Enter
Configuring the Signal Calculations Setting Object Layout
To update the Signal Calculations Setting object layout, in the Signal Calculations section, add the Case Series View field to support Case series-enabled safety views when running Signal Calculations.
Configuring the Signal Calculation Run Object Layout
To update the Signal Calculation Run object layout, in the Details section, add the Case Series Result ID field to support Case series-enabled safety views when running Signal Calculations.
Configuring the Signal Product Profile Object Layout
To update the Signal Product Profile object layout, in the Details section, add the Default Workbench Dashboard field to support analyzing Signal Case Series data using dashboards.
Configuring the Statistical Data Object
To support opening a Workbench Dashboard for Signal Case Series directly from a Statistical Data field, on the Statistical Data object, select a field for which you want to configure dashboard linking (for example, Cumulative Fatal). Then, for the Control Binding field, select Signal Case Series Link. Control binding supports Number, Picklist, and Yes/No-type fields. Update control binding for all applicable Statistical Data fields.
Configuring the Open Case Series in Workbench Dashboard Action
To configure the Open Case Series in Workbench Dashboard action for Signal Case Series visualization and analysis:
- Assign the Open Case Series in Workbench Dashboard action to the Signal Reporting Period object and add the action as a user action to the Complete and Ready states of the Signal Reporting Period object lifecycle.
- Assign the Open Case Series in Workbench Dashboard action to the Statistical Data object and add the action as a user action to the Complete, In Progress, and Ready states of the Statistical Data object lifecycle. We recommend configuring the action so that it appears only when the Statistical Data record contains at least one Case count or when the Listed field is populated. To do this, add the user action to the applicable states with the following rule:
- Condition Type: Select Formula evaluates to TRUE
- If this formula is True: Enter
(cumulative_all_count__v > 0) || (new_all_count__v > 0) || Not(IsBlank(listed__v)) - Allow the following actions: Select Open Case Series in Workbench Dashboard
- Action Label: Enter
Open Case Series in Workbench Dashboard
Creating Safety Views for Signal Case Series
This section provides examples on how to create Signal Case Series views to obtain the following data:
- New Case counts
- Cumulative Case counts
- Cases with adverse events evaluated as listed or unlisted
To create a Signal View to use Signal Case Series:
- Navigate to Business Admin > Objects > Workbench Views.
- Select Create.
- In the Create Workbench View dialog, select Signal View and then select Continue.
- Complete the details and SQL information about the respective Signal View using the following table and then select Save:
| Signal View | Name | API Name | Description | SQL |
|---|---|---|---|---|
| Signal Case Series - New Counts | PV Case Series - New Counts | Enter a unique name for this view, for example, signal_case_series_new_counts__c. |
Case Series for Product-Event Combinations from the PV Product Family-Event New Counts View | SELECTfilter.case_version_id, filter.product_family_id, filter.pt_code, TRUE AS is_all, filter.is_fatal, filter.is_serious, filter.is_postmarket_spontaneousFROM${pv_filterview_interval_pec_for_product__c} filter |
| Signal Case Series - Cumulative Counts | PV Case Series - Cumulative Counts | Enter a unique name for this view, for example, signal_case_series_cumulative_counts__c. |
Case Series for Product-Event Combinations from the PV Product Family-Event Cumulative Counts View | SELECTfilter.case_version_id, filter.product_family_id, filter.pt_code, TRUE AS is_all, filter.is_fatal, filter.is_serious, filter.is_postmarket_spontaneousFROM${pv_filterview_cumulative_pec_for_product__c} filter |
| Signal Case Series - Listed | PV Case Series - Listed | Enter a unique name for this view, for example, signal_case_series_listed__c. |
Case Series for Product-Event Combinations from the PV Product Family-Event Listed View | SELECTfilter.case_version_id, filter.product_family_id, filter.pt_code, TRUE AS filter.is_listedFROM${pv_filterview_interval_pec_for_product__c} filter |
Vault sets the Signal Case Series Enabled checkbox after you configure the View Columns section for the Signal Case Series. Next, add dependent views and view columns.
Adding Dependent Views
To add a dependent view, expand the Dependent Views section and select Create. Use the following table to add the respective dependent view:
| Signal View | Dependent View |
|---|---|
| Signal Case Series - New Counts | The dependent view should match that of the corresponding Case count view, for example, PV Filter View - Interval Product-Events for a Product Family. |
| Signal Case Series - Cumulative Counts | The dependent view should match that of the corresponding Case count view, for example, PV Filter View - Cumulative Product-Events for a Product Family. |
| Signal Case Series - Listed | The dependent view should match that of the corresponding Case count view, for example, PV Filter View - Interval Product-Events for a Product Family. |
Adding View Columns
To populate the View Columns section:
- In the View Columns section, select Create.
- Use the tables below to create the necessary view columns for the applicable Signal Views.
- Select Save.
To delete a field, select the Actions menu next to the field and then select Delete.
The following table describes the view columns for the Signal Case Series - New Counts and Signal Case Series - Cumulative Counts views:
| Name | API Name | Column Type | Safety Object Reference | Safety Object Constraint | Signal Case Series Key | Case Version Key |
|---|---|---|---|---|---|---|
| Case Version ID | Enter the API Name of the view column. This value must match the name of the column returned by the SQL query. | Text | Optional: The Safety Object Reference and Safety Object Constraint fields allow you to restrict the values that appear when filtering on this object, for example, restricting the Controlled Vocabulary object to display only Drug Roles. Enter the API Name of the object associated with this view column field. | Optional: The Safety Object Reference and Safety Object Constraint fields allow you to restrict the values that appear when filtering on this object, for example, restricting the Controlled Vocabulary object to display only Drug Roles. Enter VQL to configure a reference constraint to restrict the object values. | N/A | Yes |
| Is All | Yes/No | Enter a Signal Case Series Key. The Signal Case Series Key must match the API Name of the Statistical Data field. This field ensures Vault maps the correct data from the Signal Case Series view when users create a Statistical Data record. | N/A | |||
| Is Fatal | Yes/No | |||||
| Is Postmarket Spontaneous | Yes/No | |||||
| Is Serious | Yes/No | |||||
| Product Family ID | Text | |||||
| PT Code | Text |
The following table describes the view columns for the Signal Case Series - Listed view:
| Name | API Name | Column Type | Safety Object Reference | Safety Object Constraint | Signal Case Series Key | Case Version Key |
|---|---|---|---|---|---|---|
| Case Version ID | Enter the API Name of the view column. This value must match the name of the column returned by the SQL query. | Text | Optional: The Safety Object Reference and Safety Object Constraint fields allow you to restrict the values that appear when filtering on this object, for example, restricting the Controlled Vocabulary object to display only Drug Roles. Enter the API Name of the object associated with this view column field. | Optional: The Safety Object Reference and Safety Object Constraint fields allow you to restrict the values that appear when filtering on this object, for example, restricting the Controlled Vocabulary object to display only Drug Roles. Enter VQL to configure a reference constraint to restrict the object values. | N/A | Yes |
| Is Listed | Yes/No | Enter a Signal Case Series Key. The Signal Case Series Key must match the API Name of the Statistical Data field. This field ensures Vault maps the correct data from the Signal Case Series view when users create a Statistical Data record. | N/A | |||
| Product Family ID | Text | |||||
| PT Code | Text |
Note: When you populate the Signal Case Series Key for all view columns and assign the Case Version ID view column as the Case Version Key, Vault automatically sets the Signal Case Series Enabled checkbox.
Assigning the Case Version Key on Principal Views
For Vault to execute your configured Signal Views using Signal Case Series, for each associated Principal View, you must assign the Case Version Key to the Case Version ID view column.
Configuring User & Admin Permissions
You must ensure users and Admins have the appropriate read and create permissions to access the appropriate objects and fields in addition to the permissions outlined below:
| Permission Set | Object | Object Permissions |
|---|---|---|
| [Applicable Admin permission set] | Signal Product Profile |
|
| Signal Case Series |
|
|
| Workbench Dashboard |
|
|
| [Applicable user permission set] | Signal Product Profile |
|
| Workbench Dashboard |
|