Learn about PADER aggregate reports in Safety Workbench and how to generate them.

About Workbench PADERs

Safety Workbench provides U.S. Periodic Adverse Drug Experience Report (PADER) authoring and table generation capabilities. All generated Workbench PADER aggregate reports are unmasked.

The following table summarizes the PADER tabulations that Safety Workbench generates:

Tabulation Description
15 Day and Non-15 Day Summary Reports This report prints the number of Case Adverse Events that match report criteria. Vault generates tables for both initial reports and follow-up reports.
Summary of ADR from Postmarketing Sources This report prints the number of Case Adverse Events that match report criteria.
Interval Line Listings This report prints the Case listing that matches report criteria. Vault categorizes Case listings by initial and follow-up reports, seriousness, listedness, and whether the report was expedited.
Cases Submitted Under Other NDAs This report prints the Case listing that matches report criteria.

This report is a summary listing of the Adverse Events in which the drug or biological Product was listed as one (1) of the suspect Products, but the report was filed to another New Drug Application (NDA), Abbreviated New Drug Application (ANDA), or Biologic License Application (BLA) held by the applicant.
Malfunction Line Listing For Cases that contain combination products with a Device product type that has malfunctioned, this report prints a listing of device constituent malfunctions.
Line Listing Summary for Combination Products This report is a summary listing of Cases that contain combination products with a Device product type that has malfunctioned.
Malfunction Tabulation For Cases that contain combination products with a Device product type that has malfunctioned, this report prints the number of Case Adverse Events that match report criteria.

You can choose to include or exclude nullified and voided Cases in Workbench PADER aggregate reports.

Safety Workbench allows you to generate, run, and download multiple Workbench aggregate reports at once. If this option is relevant to your organization’s business processes, see Manage Workbench Report Sets.

Prerequisites

To generate Workbench PADERs, you must contact Veeva Support and consider the following prerequisites:

  • Your Admin must configure Workbench PADER aggregate reports.
  • Your Admin must grant you permissions to view and prepare aggregate reports. Typically, these permissions are reserved for the Aggregate Report Writer role.
  • Your Admin must configure US-based local product Datasheets that list expected adverse events for the reporting family Product. Workbench uses product Datasheets to classify adverse events as Labeled or Unlabeled in Workbench PADER tables.
  • To generate table data from Study-type Cases, your Admin must configure the appropriate Study Products.
  • A Case must have a Transmission record with a Transmission Date.

Create a Workbench PADER

Create a Workbench PADER aggregate report and specify the report parameters.

Add a Workbench PADER Report Set

To create a Workbench PADER:

  1. Navigate to Workbench > Report Sets.
  2. Select Create.
  3. On the Create Workbench Report Set page, enter a name for the report.
  4. Select Save or Save + Create to save the Workbench Report Set and create another.
  5. See Manage Workbench Report Sets for information on adding Workbench Report Definitions and filters to the report set. Then, see the section below for completing the required filters for the Workbench PADER.

When you create a Workbench Report Set, Vault sets the lifecycle state to Draft.

Specify Workbench PADER Filters

After adding Workbench Report Definitions to the Workbench PADER report set and selecting Refresh in the Filters section, required filters appear in the Filters section. Specify values for the following filters:

  • Aggregate Reporting Group: Select an Aggregate Reporting Group configured for aggregate reporting from the drop-down or use the Advanced Search (advanced-search) icon to use filters and refine your search. To learn more about Aggregate Reporting Groups, see Configure Workbench PADER Aggregate Reports.
  • Transmission > Generation Date: Enter the start and end date for the reporting period. Vault uses the Cases within the reporting period to generate table data. Cases are included when the Case Transmission is within the reporting period.

Generate and Run Workbench PADER Reports

Review and verify the Workbench PADER report set. Once you have confirmed the report set details are correct, see Manage Workbench Report Sets for information on generating and running reports.

Workbench PADER Table Generation Data Mapping

Workbench populates aggregate report tables using Cases within the reporting period specified on the Workbench PADER and the product registrations configured on the associated Aggregate Reporting Group.

The following sections describe how Workbench generates PADER tabulations:

15-Day and Non-15-Day Summary Reports

Case-Based Report: This report prints the number of Cases that match report criteria, using the primary Case Adverse Event to categorize the Case into the appropriate column.

Vault generates the 15-Day and Non-15-Day Summary Reports table for both initial and follow-up reports. The following image displays the Summary of 15-Day and Non-15-Day Alerts table, which includes both initial and follow-up reports:

workbench-pader-summary-of-15-and-non-15-day-alert-table

Table Constraints

Vault filters Cases to include in the Workbench PADER 15-Day and Non-15-Day Summary Reports using the following constraints:

Case Not Suppressed

The Suppress Submission field on the Case must be set to No or blank (not suppressed).

case_version__v.suppress_submission__v ≠ Yes

FDA Transmission in Reporting Period

Vault finds Cases submitted to the FDA within the reporting period.

Cases must have an associated Transmission that meets the following conditions:

  • The Transmission Destination is FDA.
    case_version__v.transmission__v.destination__v = fda__v
  • The Transmission Date is within the interval reporting period specified in the Workbench PADER report set.
    transmission__v.transmission_date__v >= transmission_generation.filter_start_range AND transmission__v.transmission_date__v <= transmission_generation.filter_end_range
  • The Transmission is in the E2B ACK Accepted or Completed lifecycle state, and the Transmission lifecycle state type is not Deleted.
    case_version__v.transmission__v.state__v = (e2b_ack_accepted_state__v OR completed_state__v) AND case_version__v.transmission__v.state__v.statetype__v != Deleted
  • The registration on the Transmission record matches that listed in the Aggregate Reporting Group.
    case_version__v.transmission__v.reportable_product_registration__v = aggregate_reporting_group__v.product_registration__v

The report lists only the latest version of the Case transmitted to the FDA within the reporting period.

Suspect, Interacting, or Drug Not Administered Product in Aggregate Reporting Group

A Case Product must meet the following conditions:

  • The Product Registration field must link to a Product Registration record added as a member of the Aggregate Reporting Group.
    case_version__vr.case_product__v.product_registration__v IN aggregate_reporting_group__vr.aggregate_reporting_group_join__vr.product_registrations__v
  • The Drug Role field must be set to Suspect (E2B code=1), Interacting (E2B code=3), or Drug Not Administered (E2B code=4).
    case_product__v.drug_role__v.controlled_vocabulary__v.e2b_code__v = 1 OR 3 OR 4
Initial vs. Follow-Up Report

To determine whether Cases should be listed in initial or follow-up reports, Vault evaluates the Transmission Reason (transmission_reason__v) field on FDA Transmissions within the reporting period using the following logic:

  • Initial reports: When there is at least one (1) FDA Transmission within the reporting period with the Transmission Reason set to one (1) of the following:
    • Initial
    • A custom Transmission Reason Controlled Vocabulary where the E2B code is set to I (initial)
      transmission__v.reason__v.controlled_vocabulary__v.e2b_code__v = I
  • Follow-up reports: When all FDA Transmissions within the reporting period have the Transmission Reason set to one (1) of the following:
    • Amendment
    • Follow-Up
    • A custom Transmission Reason Controlled Vocabulary where the E2B code is not set to I (initial) or 1 (nullification)
      transmission__v.reason__v.controlled_vocabulary__v.e2b_code__v ≠ I OR 1

Table Mapping

Sorting: Cases are sorted in ascending order by Worldwide UID (WWUID).

Number Name Description
1 No. of Solicited Reports - Study The number of Cases that match one (1) of the following scenarios:
Scenario Report Type Study Type Literature
1
  • Any
2
  • No or blank
COUNT IF
(case_version_v.report_type__v.controlled_vocabulary__v.e2b_code__v = 2
AND case_version__v.study_product_reason__v.controlled_vocabulary__v.e2b_code__v = 1)
OR
(case_version_v.report_type__v.controlled_vocabulary__v.e2b_code__v = 2
AND case_version_v.report_type__v.controlled_vocabulary__v.literature__v ≠ Yes
AND case_version__v.study_product_reason__v = blank)
2 No. of Solicited Reports - Other The number of Cases that match one (1) of the following scenarios:
Scenario Report Type Study Type Literature
1
  • Any
2
  • Yes
COUNT IF
(case_version_v.report_type__v.controlled_vocabulary__v.e2b_code__v = 2
AND case_version__v.study_product_reason__v.controlled_vocabulary__v.e2b_code__v = 2 or 3)
OR
(case_version_v.report_type__v.controlled_vocabulary__v.e2b_code__v = 2
AND case_version_v.report_type__v.controlled_vocabulary__v.literature__v = Yes
AND case_version__v.study_product_reason__v = blank)
3 No. of Spontaneous Reports

The number of Cases with the Case > Report Type set to one (1) of the following:

  • Spontaneous
  • Literature (Spontaneous)
  • Other
  • Not Available
  • A custom Report Type with an E2B code of 1, 3, 4, or null (blank)
    case_version_v.report_type__v.controlled_vocabulary__v.e2b_code__v ≠ 2
4 Serious, Unlabeled, Non-Fatal (initial and follow-up)

The sum of Cases with primary adverse events that meet the following criteria:

  • Cases with one (1) or more FDA Transmissions within the reporting period where the Local Expedited Criteria field is set to Yes or is blank.
    case_version__v.transmission__v.case_expedited__v = Yes OR Blank
  • Serious (non-fatal): The Case Adverse Event > Seriousness field is set to a value, but the fatal criteria are not met.
    case_adverse_event__v.seriousness__v ≠ EMPTY
  • Unlabeled: Vault looks for an Expected value of No in the following priority order:
    1. Case Assessment Expectedness where the Country is set to United States or another country in the FDA's jurisdiction
    2. The Expectedness field on the primary Case Assessment
    3. The Case Expectedness field
    (case_assessment__v.case_assessment_expectedness__v.expected__v = No
    AND
    case_assessment_expectedness__v.country__v.agency__v = fda__v)
    ELSE
    (case_assessment__v.expectedness__v = No
    WHERE
    case_assessment__v.rank__v = 1)
    ELSE
    (case_version__v.expected__v = No)
5 Serious, Unlabeled, Fatal (initial and follow-up)

The sum of Cases with primary adverse events that meet the following criteria:

  • Cases with one (1) or more FDA Transmissions within the reporting period where the Local Expedited Criteria field is set to Yes or is blank.
    case_version__v.transmission__v.case_expedited__v = Yes OR Blank
  • Meets one (1) of the following conditions to indicate a death occurred:
    • The Date of Death field on the Case is populated.
      case_version__v.dod_normalized__v ≠ Blank
    • The Seriousness field on any Case Adverse Event contains Results in Death.
      case_adverse_event__v.seriousness__v = results_in_death__v
    • The Outcome field on any Case Adverse Event contains Fatal.
      case_adverse_event__v.outcome__v = fatal
    • Any Case Adverse Event has a coded event under the MedDRA HLT of 10011907 (Death and Sudden Death).
      case_adverse_event__v.event_meddra__v.meddra__v.hlt_code__v = 10011907
    • The Autopsy field on the Case is set to Yes.
      case_version__v.autopsy_value__v = Yes
6 Serious, Labeled (initial and follow-up)

The sum of Cases with primary Case Adverse Events that meet the following criteria:

  • Serious: The Case Adverse Event > Seriousness field is populated.
    case_adverse_event__v.seriousness__v ≠ EMPTY
  • Labeled: Vault looks for an Expected value of Yes in the following priority order:
    1. Case Assessment Expectedness where the Country is set to United States or another country in the FDA's jurisdiction
    2. The Expectedness field on the primary Case Assessment
    3. The Case Expectedness field
    (case_assessment__v.case_assessment_expectedness__v.expected__v = Yes
    AND
    case_assessment_expectedness__v.country__v.agency__v = fda__v)
    ELSE
    (case_assessment__v.expectedness__v = Yes
    WHERE
    case_assessment__v.rank__v = 1)
    ELSE
    (case_version__v.expected__v = Yes)
7 Serious, Unlabeled, Not Related (initial and follow-up)

The sum of Cases with primary Case Adverse Events that meet the following criteria:

  • Serious: The Case Adverse Event > Seriousness field is populated.
    case_adverse_event__v.seriousness__v ≠ EMPTY
  • Unlabeled: Vault looks for an Expected value of No in the following priority order:
    1. Case Assessment Expectedness where the Country is set to United States or another country in the FDA's jurisdiction
    2. The Expectedness field on the primary Case Assessment
    3. The Case Expectedness field
    (case_assessment__v.case_assessment_expectedness__v.expected__v = No
    AND
    case_assessment_expectedness__v.country__v.agency__v = fda__v)
    ELSE
    (case_assessment__v.expectedness__v = No
    WHERE
    case_assessment__v.rank__v = 1)
    ELSE
    (case_version__v.expected__v = No)
  • Not Related: The Causality Established field in at least two (2) primary Assessment Results is set to No, including one (1) company assessment and one (1) reporter's assessment.
    (case_assessment__v.case_assessment_result__v.causality_established__v = No
    where primary__v = True
    and source_type__v.e2b_code__v = 1 [Investigator],
    5 [Health Care Professional], or 6 [Non-Health Care Professional])
    OR
    (case_assessment__v.case_assessment_result__v.causality_established__v = No
    where primary__v = True
    and source_type__v.e2b_code__v = 2 [Sponsor] or 4 [MAH])
8 Non Serious, Labeled (initial and follow-up)

The sum of Cases with primary Case Adverse Events that meet the following criteria:

  • Non Serious: The Case Adverse Event > Seriousness field is blank.
    case_adverse_event__v.seriousness__v = EMPTY
  • Labeled: Vault looks for an Expected value of Yes in the following priority order:
    1. Case Assessment Expectedness where the Country is set to United States or another country in the FDA's jurisdiction
    2. The Expectedness field on the primary Case Assessment
    3. The Case Expectedness field
    (case_assessment__v.case_assessment_expectedness__v.expected__v = Yes
    AND
    case_assessment_expectedness__v.country__v.agency__v = fda__v)
    ELSE
    (case_assessment__v.expectedness__v = Yes
    WHERE
    case_assessment__v.rank__v = 1)
    ELSE
    (case_version__v.expected__v = Yes)
9 Non Serious, Unlabeled (initial and follow-up)

The sum of Cases with primary Case Adverse Events that meet the following criteria:

  • Non Serious: The Case Adverse Event > Seriousness field is blank.
    case_adverse_event__v.seriousness__v = EMPTY
  • Unlabeled: Vault looks for an Expected value of No in the following priority order:
    1. Case Assessment Expectedness where the Country is set to United States or another country in the FDA's jurisdiction
    2. The Expectedness field on the primary Case Assessment
    3. The Case Expectedness field
    (case_assessment__v.case_assessment_expectedness__v.expected__v = No
    AND
    case_assessment_expectedness__v.country__v.agency__v = fda__v)
    ELSE
    (case_assessment__v.expectedness__v = No
    WHERE
    case_assessment__v.rank__v = 1)
    ELSE
    (case_version__v.expected__v = No)

Summary of ADR from Postmarketing Sources

Event-Based Report: This report prints the number of Case Adverse Events that match report criteria.

The following image displays the Workbench PADER Summary of ADR from Postmarketing Sources report:

workbench-pader-summary-of-15-and-non-15-day-alert-table

Table Constraints

Vault filters Cases to include in the Workbench PADER Summary of Adverse Drug Reactions from Postmarketing Sources using the following constraints:

Case Not Suppressed

The Suppress Submission field on the Case must be set to No or blank (not suppressed).
case_version__v.suppress_submission__v ≠ Yes

FDA Transmission in Reporting Period

Vault finds Cases submitted to the FDA within the reporting period.

Cases must have an associated Transmission that meets the following conditions:

  • The Transmission Destination is FDA.
    case_version__v.transmission__v.destination__v = fda__v
  • The Transmission Date is within the interval reporting period specified in the Workbench PADER report set.
    transmission__v.transmission_date__v >= transmission_generation.filter_start_range AND transmission__v.transmission_date__v <= transmission_generation.filter_end_range
  • The Transmission is in the E2B ACK Accepted or Completed lifecycle state, and the Transmission lifecycle state type is not Deleted.
    case_version__v.transmission__v.state__v = (e2b_ack_accepted_state__v OR completed_state__v) AND case_version__v.transmission__v.state__v.statetype__v != Deleted
  • The registration on the Transmission record matches that listed in the Aggregate Reporting Group.
    case_version__v.transmission__v.reportable_product_registration__v = aggregate_reporting_group__v.product_registration__v

The report lists only the latest version of the Case transmitted to the FDA within the reporting period.

Suspect, Interacting, or Drug Not Administered Product in Aggregate Reporting Group

A Case Product must meet the following conditions:

  • The Product Registration field must link to a Product Registration record added as a member of the Aggregate Reporting Group.
    case_version__vr.case_product__v.product_registration__v IN aggregate_reporting_group__vr.aggregate_reporting_group_join__vr.product_registrations__v
  • The Drug Role field must be set to Suspect (E2B code=1), Interacting (E2B code=3), or Drug Not Administered (E2B code=4).
    case_product__v.drug_role__v.controlled_vocabulary__v.e2b_code__v = 1 OR 3 OR 4

Table Mapping

Sorting: Cases are sorted in ascending order, first by UID and then by Worldwide UID.

Number Name Description
1 SOC The MedDRA System Organ Class (SOC) for the Case Adverse Event. The sum of all adverse events under this SOC is listed under each column.
event_meddra__v.soc_term__v
2 Preferred Term The MedDRA Preferred Term (PT) coded on the Case Adverse Event, grouped by the MedDRA SOC.
case_adverse_event__v.event_meddra__v.pt_term__v
3 Domestic The sum of adverse events where the Case Adverse Event > Event Country field is set to a Country where the Agency field is set to FDA.
case_adverse_event__v.event_country__v.agency__v = fda__v
4 Foreign The sum of adverse events where the Case Adverse Event > Event Country field is set to a Country where the Agency field is not set to FDA.
case_adverse_event__v.event_country__v.agency__v ≠ fda__v
5 Serious, Unlabeled

Primary adverse events that meet the following criteria:

  • Serious: The Case Adverse Event > Seriousness field is populated.
    case_adverse_event__v.seriousness__v ≠ EMPTY
  • Unlabeled: One (1) of the following conditions must be met on the Case Assessment for the Case Adverse Event:
    • If local product Datasheets are configured, the Case Assessment Expectedness records under the Case Assessment must meet the following criteria:
      • A Case Assessment Expectedness record must exist with the Expected field set to No.
      • The local Datasheet used to calculate the Case Assessment Expectedness must specify FDA as the Agency on the Country.
    • If no local Datasheets within the FDA's jurisdiction are configured, Vault evaluates the Case Assessment for each adverse event. The Case Assessment > Expected field must be set to No or blank to be considered Unlabeled.
    (case_assessment__v.case_assessment_expectedness__v.expected__v = No
    AND
    case_assessment_expectedness__v.country__v.agency__v = fda__v)
    ELSE
    (case_assessment__v.expectedness__v = No or Blank)
6 Serious, Labeled

Primary adverse events that meet the following criteria:

  • Serious: The Case Adverse Event > Seriousness field is populated.
    case_adverse_event__v.seriousness__v ≠ EMPTY
  • Labeled: One (1) of the following conditions must be met on the Case Assessment for the Case Adverse Event:
    • If local product Datasheets are configured, the Case Assessment Expectedness records under the Case Assessment must meet the following criteria:
      • A Case Assessment Expectedness record must exist with the Expected field set to Yes.
      • The local Datasheet used to calculate the Case Assessment Expectedness must specify FDA as the Agency on the Country.
    • If no local Datasheets within the FDA's jurisdiction are configured, Vault evaluates the Case Assessment for each adverse event. The Case Assessment > Expected field must be set to Yes to be considered Labeled.
    (case_assessment__v.case_assessment_expectedness__v.expected__v = Yes
    AND
    case_assessment_expectedness__v.country__v.agency__v = fda__v)
    ELSE
    (case_assessment__v.expectedness__v = Yes)
7 Non Serious Unlabeled

Primary adverse events that meet the following criteria:

  • Non Serious: The Case Adverse Event > Seriousness field is blank.
    case_adverse_event__v.seriousness__v = EMPTY
  • Unlabeled: One (1) of the following conditions must be met on the Case Assessment for the Case Adverse Event:
    • If local product Datasheets are configured, the Case Assessment Expectedness records under the Case Assessment must meet the following criteria:
      • A Case Assessment Expectedness record must exist with the Expected field set to No.
      • The local Datasheet used to calculate the Case Assessment Expectedness must specify FDA as the Agency on the Country.
    • If no local Datasheets within the FDA's jurisdiction are configured, Vault evaluates the Case Assessment for each adverse event. The Case Assessment > Expected field must be set to No or blank to be considered Unlabeled.
    (case_assessment__v.case_assessment_expectedness__v.expected__v = No
    AND
    case_assessment_expectedness__v.country__v.agency__v = fda__v)
    ELSE
    (case_assessment__v.expectedness__v = No or Blank)
8 Non Serious Labeled

Primary adverse events that meet the following criteria:

  • Non Serious: The Case Adverse Event > Seriousness field is blank.
    case_adverse_event__v.seriousness__v = EMPTY
  • Labeled: One (1) of the following conditions must be met on the Case Assessment for the Case Adverse Event:
    • If local product Datasheets are configured, the Case Assessment Expectedness records under the Case Assessment must meet the following criteria:
      • A Case Assessment Expectedness record must exist with the Expected field set to Yes.
      • The local Datasheet used to calculate the Case Assessment Expectedness must specify FDA as the Agency on the Country.
    • If no local Datasheets within the FDA's jurisdiction are configured, Vault evaluates the Case Assessment for each adverse event. The Case Assessment > Expected field must be set to Yes to be considered Labeled.
    (case_assessment__v.case_assessment_expectedness__v.expected__v = Yes
    AND
    case_assessment_expectedness__v.country__v.agency__v = fda__v)
    ELSE
    (case_assessment__v.expectedness__v = Yes)
9 Subtotal The subtotal sum of adverse events for each MedDRA SOC and PT, within domestic or foreign jurisdiction.
10 Total The total sum of domestic and foreign adverse events for each MedDRA SOC and PT.
11 Grand Total The total sum of all adverse events.

Interval Line Listings

Case-Based Report: This report prints the number of Cases that match report criteria.

Workbench generates Interval Line Listing tables for both initial and follow-up reports.

The following image displays the Workbench PADER Interval Line Listing, which includes both initial and follow-up reports.

workbench-pader-interval-line-listing

Table Constraints

Vault filters Cases to include in the Workbench PADER Interval Line Listings using the following constraints:

Case Not Suppressed

The Suppress Submission field on the Case must be set to No or blank (not suppressed).

case_version__v.suppress_submission__v ≠ Yes

FDA Transmission in Reporting Period

Vault finds Cases submitted to the FDA within the reporting period.

Cases must have an associated Transmission that meets the following conditions:

  • The Transmission Destination is FDA.
    case_version__v.transmission__v.destination__v = fda__v
  • The Transmission Date is within the interval reporting period specified in the Workbench PADER report set.
    transmission__v.transmission_date__v >= transmission_generation.filter_start_range AND transmission__v.transmission_date__v <= transmission_generation.filter_end_range
  • The Transmission is in the E2B ACK Accepted or Completed lifecycle state, and the Transmission lifecycle state type is not Deleted.
    case_version__v.transmission__v.state__v = (e2b_ack_accepted_state__v OR completed_state__v) AND case_version__v.transmission__v.state__v.statetype__v != Deleted
  • The registration on the Transmission record matches that listed in the Aggregate Reporting Group.
    case_version__v.transmission__v.reportable_product_registration__v = aggregate_reporting_group__v.product_registration__v

The report lists only the latest version of the Case transmitted to the FDA within the reporting period.

Suspect, Interacting, or Drug Not Administered Product in Aggregate Reporting Group

A Case Product must meet the following conditions:

  • The Product Registration field must link to a Product Registration record added as a member of the Aggregate Reporting Group.
    case_version__vr.case_product__v.product_registration__v IN aggregate_reporting_group__vr.aggregate_reporting_group_join__vr.product_registrations__v
  • The Drug Role field must be set to Suspect (E2B code=1), Interacting (E2B code=3), or Drug Not Administered (E2B code=4).
    case_product__v.drug_role__v.controlled_vocabulary__v.e2b_code__v = 1 OR 3 OR 4
Initial vs. Follow-Up Report

To determine whether Cases should be listed in initial or follow-up reports, Vault evaluates the Transmission Reason (transmission_reason__v) field on FDA Transmissions within the reporting period using the following logic:

  • Initial reports: When there is at least one (1) FDA Transmission within the reporting period with the Transmission Reason set to one (1) of the following:
    • Initial
    • A custom Transmission Reason Controlled Vocabulary where the E2B code is set to I (initial)
      transmission__v.reason__v.controlled_vocabulary__v.e2b_code__v = I
  • Follow-up reports: When all FDA Transmissions within the reporting period have the Transmission Reason set to one (1) of the following:
    • Amendment
    • Follow-Up
    • A custom Transmission Reason Controlled Vocabulary where the E2B code is not set to I (initial) or 1 (nullification)
      transmission__v.reason__v.controlled_vocabulary__v.e2b_code__v ≠ I OR 1

For each Case included in the report, the Workbench PADER Interval Line Listings displays all Case Adverse Events.

Table Mapping

Number Name Description
1 Manufacturer's Report Number Vault maps this value from the Case > UID field.
case_version__v.uid__v
2 Report Type The Report Type of the Case.
case_version__v.report_type__v
3 Expedited

Whether the Case was expedited.

Vault sets the value to Exp (expedited) if one (1) or more FDA Transmissions within the reporting period have the Local Expedited Criteria field set to Yes or blank.
case_version__v.transmission__v.case_expedited__v = Yes OR Blank

Vault sets the value to Non-Exp (non-expedited) if all FDA Transmissions within the reporting period have the Local Expedited Criteria field set to No.
case_version__v.transmission__v.case_expedited__v = No

4 Initial/Follow-up

Whether the Case is an initial or follow-up Case.

Vault sets the value to Initial if at least one (1) eligible Transmission for any Case version in the reporting period has a Transmission Reason where the E2B code is set to I (initial).
case_version__v.transmission__v.case_expedited__v = Yes OR Blank

Otherwise, Vault sets the value to Follow-up.

5 Domestic/Foreign

Whether the Case is domestic or foreign.

Vault sets the value to Domestic if the primary adverse event's Event Country field is set to a Country where the Agency field is set to FDA.
case_adverse_event__v.event_country__v.agency__v = fda__v

Vault sets the value to Foreign if the primary adverse event's Event Country field is set to a Country where the Agency field is not set to FDA.
case_adverse_event__v.event_country__v.agency__v ≠ fda__v

6 Seriousness

Whether the Case is serious or non-serious.

Vault sets the value to S (serious) if the primary Case Adverse Event is populated with a value.
case_adverse_event__v.seriousness__v ≠ EMPTY

Otherwise, Vault sets the value to NS (non-serious).

7 Listedness

Whether the Case is listed or unlisted.

Vault sets the value to L (listed) if the primary Case Adverse Event is expected. Vault looks for an Expected value in the following priority order:

  1. Case Assessment Expectedness where Country is set to United States, or another country in the FDA's jurisdiction
  2. The Expectedness field on the primary Case Assessment
  3. The Case Expectedness field
(case_assessment__v.case_assessment_expectedness__v.expected__v
AND
case_assessment_expectedness__v.country__v.agency__v = fda__v)
ELSE
(case_assessment__v.expectedness__v
WHERE
case_assessment__v.rank__v = 1)
ELSE
(case_version__v.expected__v)

Otherwise, Vault sets the value to UL (unlisted).

8 Adverse Experience Reported Term (MedDRA)

Both the reported name and the MedDRA Preferred Term (PT) for the adverse events.
(IF event_reported_english__v ≠ BLANK
THEN case_adverse_event.event_reported_english__v
ELSE case_adverse_event.event_reported__v)
(event_meddra__v.PT)

Vault orders the adverse events by rank, blank values ranking last.

9 Receipt/New Info Date

Vault maps this value from the New Info Date field on the Case. If the New Info Date is blank, Vault maps this value from the Case Receipt date.
IF not blank(case_version__v.new_info_idate__v)
ELSE
case_version__v.receipt_date__v

10 Transmission Generation Date Vault populates this field with all Transmission Dates for Case Transmissions that meet the following criteria:
  • The Transmission lifecycle state is either ACK Accepted or Completed.
    transmission__v.state__v = {E2B ACK Accepted | Completed}
  • The Transmission Reason field is set to one (1) of the following:
    • Initial
    • Follow-up
    • Amendment
    • A custom Transmission Reason Controlled Vocabulary where the E2B code is set to I (initial), F (follow-up) or 2 (amendment)
      transmission__v.transmission_reason__v = {I, F, OR 2}
11 Transmission Type

Vault determines the Transmission Type using the Transmission Reason and Local Expedited Criteria fields on Transmissions associated with the Case. For each Transmission date listed in the Transmission Generation Date column, Vault displays one (1) of the following:

  • Exp Initial (expedited initial)
  • Exp Follow-up (expedited follow-up)
  • Non-Exp Initial (non-expedited initial)
  • Non-Exp Follow-up (non-expedited follow-up)


Vault determines a Case is expedited if one (1) or more FDA Transmissions within the reporting period have the Local Expedited Criteria field set to Yes or blank.
case_version__v.transmission__v.case_expedited__v = Yes OR Blank
Otherwise, Vault determines the Case is not expedited if all FDA Transmissions within the reporting period have the Local Expedited Criteria field set to No.
case_version__v.transmission__v.case_expedited__v = No
Vault displays the values in the same order as the Transmission Generation Date values.


Vault determines a Case is an initial Case if at least one (1) FDA Transmission within the reporting period has the Transmission Reason set to one (1) of the following:

  • Initial
  • A custom Transmission Reason Controlled Vocabulary where the E2B code is set to I (initial).
    transmission__v.reason__v.controlled_vocabulary__v.e2b_code__v = I

Otherwise, Vault determines the Case is a follow-up Case if all FDA Transmissions within the reporting period have the Transmission Reason set to one (1) of the following:

  • Amendment
  • Follow-Up
  • A custom Transmission Reason Controlled Vocabulary where the E2B code is not set to I (initial) or 1 (nullification).
    transmission__v.reason__v.controlled_vocabulary__v.e2b_code__v ≠ I OR 1

12 Nullified/Voided

Vault displays this column only if you choose the report version that includes nullified Cases.

Vault sets the value to Nullified or Voided if the Case is in the Nullified or Voided lifecycle state, respectively.
case_version__v_state

Otherwise, Vault leaves this value blank.

Cases Submitted Under Other NDAs

Case-Based Report: This report lists the Cases that match report criteria.

The Cases Submitted Under Other NDAs report is a Case line listing in which the drug or biological Product was listed as one (1) of the suspect Products on the Case, but the Case was submitted to the FDA under another New Drug Application (NDA), Abbreviated New Drug Application (ANDA), or Biologic License Application (BLA) held by the applicant.

If at least one (1) reportable Product Registration on the FDA Transmission for the Case matches that of the Aggregate Reporting Group, Vault includes this Case in one (1) of the following reports:

If the reportable Product Registration on the FDA Transmission for the Case does not match that of an Aggregate Reporting Group, Vault includes the Case in the Cases Submitted Under Other NDAs report. For more information about how Vault identifies Cases as submitted under another NDA, ANDA, or BLA, see Configure Workbench PADER Aggregate Reports.

workbench-pader-cases-submitted-under-other-ndas

Table Constraints

Vault filters Cases to include in the Cases Submitted Under Other NDAs report using the following constraints:

Case Not Suppressed

The Suppress Submission field on the Case must be set to No or blank (not suppressed).

case_version__v.suppress_submission__v ≠ Yes

FDA Transmission in Reporting Period

Vault finds Cases submitted to the FDA within the reporting period.

Cases must have an associated Transmission that meets the following conditions:

  • The Transmission Destination is FDA.
    case_version__v.transmission__v.destination__v = fda__v
  • The Transmission Date is within the interval reporting period specified in the Workbench PADER report set.
    transmission__v.transmission_date__v >= transmission_generation.filter_start_range AND transmission__v.transmission_date__v <= transmission_generation.filter_end_range
  • The Transmission is in the E2B ACK Accepted or Completed lifecycle state, and the Transmission lifecycle state type is not Deleted.
    case_version__v.transmission__v.state__v = (e2b_ack_accepted_state__v OR completed_state__v) AND case_version__v.transmission__v.state__v.statetype__v != Deleted
  • The registration on the Transmission record does not match that listed in the Aggregate Reporting Group.
    case_version__v.transmission__v.reportable_product_registration__v != aggregate_reporting_group__v.product_registration__v

The report lists only the latest version of the Case transmitted to the FDA within the reporting period.

Suspect, Interacting, or Drug Not Administered Product in Aggregate Reporting Group

A Case Product must meet the following conditions:

  • The Product Registration field must link to a Product Registration record added as a member of the Aggregate Reporting Group.
    case_version__vr.case_product__v.product_registration__v IN aggregate_reporting_group__vr.aggregate_reporting_group_join__vr.product_registrations__v
  • The Drug Role field must be set to Suspect (E2B code=1), Interacting (E2B code=3), or Drug Not Administered (E2B code=4).
    case_product__v.drug_role__v.controlled_vocabulary__v.e2b_code__v = 1 OR 3 OR 4

Table Mapping

Sorting: Cases are sorted in ascending order, first by UID and then by Worldwide UID.

Number Name Description
1 Case WWID/UID Vault maps these values from the following fields:
  • WWID: Case > Worldwide UID
    case_version__v.worldwide_uid__v
  • UID: Case > UID
    case_version__v.uid__v
2 Generic Name The name of each suspect or interacting Case Product.
case_version__v.case_product__v.product_name__v
AND drug_role__v = Suspect OR Interacting
3 Event Reported (MedDRA) The MedDRA PT of each Case Adverse Event, sorted by the primary event first.
case_adverse_event__v.event_meddra__v.pt_term__v
4 Registration No. The value from the Registration Number field on the Product Registration associated with the Case Product.
case_product__v.product_registration__v.registration_number__v
5 Registration Type The value from the Registration Type field on the Product Registration associated with the Case Product.
case_product__v.product_registration__v.registration_type__v
6 Receipt/New Info Date Vault maps this value from the New Info Date field on the Case. If the New Info Date is blank, Vault maps this value from the Case Receipt date.
IF not blank(case_version__v.new_info_idate__v)
ELSE
case_version__v.receipt_date__v
7 Transmission Generation Date Vault populates this field with the most recent Transmission Date for a Case Transmission that meets the following criteria:
  • The Transmission lifecycle state is either ACK Accepted or Completed.
    transmission__v.state__v = {E2B ACK Accepted | Completed}
  • The Transmission Reason field is set to one (1) of the following:
    • Initial
    • Follow-up
    • Amendment
    • A custom Transmission Reason Controlled Vocabulary where the E2B code is set to I (initial), F (follow-up) or 2 (amendment)
      transmission__v.transmission_reason__v = {I, F, OR 2}
8 Transmission Type

Vault determines the Transmission Type using the Transmission Reason and Local Expedited Criteria fields on Transmissions associated with the Case. Vault populates this field with one (1) of the following values:

  • Expedited Initial
  • Expedited Follow-up
  • Non-Expedited Initial
  • Non-Expedited Follow-up


Vault determines a Case is expedited if one (1) or more FDA Transmissions within the reporting period have the Local Expedited Criteria field set to Yes or blank.
case_version__v.transmission__v.case_expedited__v = Yes OR Blank
Otherwise, Vault determines the Case is not expedited if all FDA Transmissions within the reporting period have the Local Expedited Criteria field set to No.
case_version__v.transmission__v.case_expedited__v = No


Vault determines a Case is an initial Case if at least one (1) FDA Transmission within the reporting period has the Transmission Reason set to one (1) of the following:

  • Initial
  • A custom Transmission Reason Controlled Vocabulary where the E2B code is set to I (initial)
    transmission__v.reason__v.controlled_vocabulary__v.e2b_code__v = I

Otherwise, Vault determines the Case is a follow-up Case if all FDA Transmissions within the reporting period have the Transmission Reason set to one (1) of the following:

  • Amendment
  • Follow-Up
  • A custom Transmission Reason Controlled Vocabulary where the E2B code is not set to I (initial) or 1 (nullification)
    transmission__v.reason__v.controlled_vocabulary__v.e2b_code__v ≠ I OR 1

Combination Product Reports

Workbench PADERs include Cases with combination products. If the combination product contains a device constituent that has malfunctioned and the combination product is in the Aggregate Reporting Group and on the FDA Transmission, the Case is eligible for the following PADERs:

See Manage Combination Products for more information about combination products and their constituents.

Malfunction Line Listing

Case-Based Report: This report lists the Cases that match report criteria.

The following image displays the Malfunction Line Listing table:

workbench-pader-malfunction-line-listing

Table Constraints

Vault filters Cases to include in the PADER Malfunction Line Listing using the following constraints:

Case Not Suppressed

The Suppress Submission field on the Case must be set to No or blank (not suppressed).
case_version__v.suppress_submission__v ≠ Yes

FDA Transmission in Reporting Period

Vault filters by the Transmission Date to find Cases submitted to the FDA within the reporting period.

Cases must have an associated Transmission that meets the following conditions:

  • The Transmission Destination is FDA.
    case_version__v.transmission__v.destination__v = fda__v
  • The Transmission Date is within the interval reporting period specified in the Workbench PADER report set.
    transmission__v.transmission_date__v >= transmission_generation.filter_start_range AND transmission__v.transmission_date__v <= transmission_generation.filter_end_range
  • The Transmission is in the E2B ACK Accepted or Completed lifecycle state, and the Transmission lifecycle state type is not Deleted.
    case_version__v.transmission__v.state__v = (e2b_ack_accepted_state__v OR completed_state__v) AND case_version__v.transmission__v.state__v.statetype__v != Deleted
  • The registration on the Transmission record matches that listed in the Aggregate Reporting Group.
    case_version__v.transmission__v.reportable_product_registration__v = aggregate_reporting_group__v.product_registration__v

The report lists only the latest version of the Case transmitted to the FDA within the reporting period.

Suspect, Interacting, or Drug Not Administered Product in Aggregate Reporting Group

A Case Product must meet the following conditions:

  • The Combination Product Registration field of a combination product must link to a Product Registration record added as a member of the Aggregate Reporting Group.
    case_version__vr.case_product__v.combination_product_registration__v IN aggregate_reporting_group__vr.aggregate_reporting_group_join__vr.product_registrations__v
  • The Combination Product Registration field of a combination product is on the FDA Transmission.
    case_version__vr.case_product__v.combination_product_registration__v = transmission__v.reportable_product_registrations__v
  • The combination product contains at least one (1) device constituent, and the device constituent has a malfunction (Malfunction is set to Yes).
    Case_version__vr.case_product__v.malfunction__v = Yes WHERE Case_version__vr.case_product__v.product_type__v = Device
  • The Drug Role field must be set to Suspect (E2B code=1), Interacting (E2B code=3), or Drug Not Administered (E2B code=4).
    case_product__v.drug_role__v.controlled_vocabulary__v.e2b_code__v = 1 OR 3 OR 4
Initial vs. Follow-Up Report

To determine whether Cases should be listed in initial or follow-up reports, Vault evaluates the Transmission Reason (transmission_reason__v) field on FDA Transmissions within the reporting period using the following logic:

  • Initial reports: When there is at least one (1) FDA Transmission within the reporting period with the Transmission Reason set to one (1) of the following:
    • Initial
    • A custom Transmission Reason Controlled Vocabulary where the E2B code is set to I (initial)
      transmission__v.reason__v.controlled_vocabulary__v.e2b_code__v = I
  • Follow-up reports: When all FDA Transmissions within the reporting period have the Transmission Reason set to one (1) of the following:
    • Amendment
    • Follow-Up
    • A custom Transmission Reason Controlled Vocabulary where the E2B code is not set to I (initial) or 1 (nullification)
      transmission__v.reason__v.controlled_vocabulary__v.e2b_code__v ≠ I OR 1
Table Mapping

Sorting: Cases are sorted in ascending order, first by Combination Submission Type and then by Manufacturer’s Report Number.

Number Name Description
1 Manufacturer's Report Number Vault maps this value from the Case > UID field.
case_version__v.uid__v
2 Combination Submission Type

Vault maps this value from the Transmission > FDA Report Type.
transmission__v.fda_report_type__v

If the FDA Report Type is 5-Day, Vault sets the value to 5-Day.

Otherwise, Vault sets the value to Other Reportable Malfunction.

3 Report Type The Report Type of the Case.
case_version__v.report_type__v
4 Expedited

Whether the Case was expedited.

Vault sets the value to Exp (expedited) if one (1) or more FDA Transmissions within the reporting period have the Local Expedited Criteria field set to Yes or blank.
case_version__v.transmission__v.case_expedited__v = Yes OR Blank

Vault sets the value to Non-Exp (non-expedited) if all FDA Transmissions within the reporting period have the Local Expedited Criteria field set to No.
case_version__v.transmission__v.case_expedited__v = No

5 Initial/Follow-up

Whether the Case is an initial or follow-up Case.

Vault sets the value to Initial if at least one (1) eligible Transmission for any Case version in the reporting period has a Transmission Reason where the E2B code is set to I (initial).
case_version__v.transmission__v.case_expedited__v = Yes OR Blank

Otherwise, Vault sets the value to Follow-up.

6 Domestic/Foreign

Whether the Case is domestic or foreign.

Vault sets the value to Domestic if the primary adverse event's Event Country field is set to a Country where the Agency field is set to FDA.
case_adverse_event__v.event_country__v.agency__v = fda__v

Vault sets the value to Foreign if the primary adverse event's Event Country field is set to a Country where the Agency field is not set to FDA.
case_adverse_event__v.event_country__v.agency__v ≠ fda__v

7 Seriousness

Whether the Case is serious or non-serious.

Vault sets the value to S (serious) if the primary Case Adverse Event is populated with a value.
case_adverse_event__v.seriousness__v ≠ EMPTY

Otherwise, Vault sets the value to NS (non-serious).

8 Listedness

Whether the Case is listed or unlisted.

Vault sets the value to L (listed) if the primary Case Adverse Event is expected. Vault looks for an Expected value in the following priority order:

  1. Case Assessment Expectedness where Country is set to United States, or another country in the FDA's jurisdiction
  2. The Expectedness field on the primary Case Assessment
  3. The Case Expectedness field
(case_assessment__v.case_assessment_expectedness__v.expected__v
AND
case_assessment_expectedness__v.country__v.agency__v = fda__v)
ELSE
(case_assessment__v.expectedness__v
WHERE
case_assessment__v.rank__v = 1)
ELSE
(case_version__v.expected__v)

Otherwise, Vault sets the value to UL (unlisted).

9 Adverse Experience Reported Term (MedDRA)

Both the reported name and the MedDRA Preferred Term (PT) for the adverse events.
(IF event_reported_english__v ≠ BLANK
THEN case_adverse_event.event_reported_english__v
ELSE case_adverse_event.event_reported__v)
(event_meddra__v.PT)

Vault orders the adverse events by rank, blank values ranking last.

10 Device Problem (Code)

The FDA Device Code: Case product > Device Problem > Device Code> Level x Code, where "x" is the product term level (either 1, 2, or 3).
case_product__v.device_problem__vr.device_code__v.level "x" code

Vault sets the value using the following logic:

  • If the Case Product contains an FDA Device Code of level 3, level 2, or level 1, Vault sets the value to this term and code.
  • If the Case product > Device Problem field is blank, Vault sets the value to -.
  • If a Case has more than one (1) device with a device problem, Vault lists all the Device Codes from the Case.

11 Receipt/New Info Date

Vault maps this value from the New Info Date field on the Case. If the New Info Date is blank, Vault maps this value from the Case Receipt date.
IF not blank(case_version__v.new_info_idate__v)
ELSE
case_version__v.receipt_date__v

12 Transmission Generation Date Vault populates this field with all Transmission Dates for Case Transmissions that meet the following criteria:
  • The Transmission lifecycle state is either ACK Accepted or Completed.
    transmission__v.state__v = {E2B ACK Accepted | Completed}
  • The Transmission Reason field is set to one (1) of the following:
    • Initial
    • Follow-up
    • Amendment
    • A custom Transmission Reason Controlled Vocabulary where the E2B code is set to I (initial), F (follow-up) or 2 (amendment)
      transmission__v.transmission_reason__v = {I, F, OR 2}
13 Transmission Type

Vault determines the Transmission Type using the Transmission Reason and Local Expedited Criteria fields on Transmissions associated with the Case. For each Transmission date listed in the Transmission Generation Date column, Vault displays one (1) of the following:

  • Exp Initial (expedited initial)
  • Exp Follow-up (expedited follow-up)
  • Non-Exp Initial (non-expedited initial)
  • Non-Exp Follow-up (non-expedited follow-up)


Vault determines a Case is expedited if one (1) or more FDA Transmissions within the reporting period have the Local Expedited Criteria field set to Yes or blank.
case_version__v.transmission__v.case_expedited__v = Yes OR Blank
Otherwise, Vault determines the Case is not expedited if all FDA Transmissions within the reporting period have the Local Expedited Criteria field set to No.
case_version__v.transmission__v.case_expedited__v = No
Vault displays the values in the same order as the Transmission Generation Date values.


Vault determines a Case is an initial Case if at least one (1) FDA Transmission within the reporting period has the Transmission Reason set to one (1) of the following:

  • Initial
  • A custom Transmission Reason Controlled Vocabulary where the E2B code is set to I (initial).
    transmission__v.reason__v.controlled_vocabulary__v.e2b_code__v = I

Otherwise, Vault determines the Case is a follow-up Case if all FDA Transmissions within the reporting period have the Transmission Reason set to one (1) of the following:

  • Amendment
  • Follow-Up
  • A custom Transmission Reason Controlled Vocabulary where the E2B code is not set to I (initial) or 1 (nullification).
    transmission__v.reason__v.controlled_vocabulary__v.e2b_code__v ≠ I OR 1

14 Nullified/Voided

Vault displays this column only if you choose the report version that includes nullified Cases.

Vault sets the value to Nullified or Voided if the Case is in the Nullified or Voided lifecycle state, respectively.
case_version__v_state

Otherwise, Vault leaves this value blank.

How Vault Determines Expectedness

Vault sets the Expectedness field on a Case. To determine whether an Adverse Event is expected for combination products with a device constituent, Vault looks at the non-device constituent and finds all Expectedness records on Case Assessments that meet the following criteria:

  • Is attached to a Registration record of a combination product.
  • Lists a country that is supported by the FDA.
  • Has a datasheet registration that matches the registration in the Aggregate Reporting Group.

If at least one (1) record has the Expected field set to No or blank, Vault determines an Adverse Event is unexpected.

How Vault Determines Listedness

Vault sets the Listedness field on a Case. For combination products with a device constituent, Vault determines an Adverse Event is listed if the non-device constituent in the Aggregate Reporting Group is associated with an unexpected Adverse Event.

Line Listing Summary for Combination Products

Case-Based Report: This report lists the Cases that match report criteria.

The Case count in this report will match the Malfunction Line Listing report.

The following image displays the Line Listing Summary for Combination Products table:

workbench-pader-line-listing-combo-products

Table Constraints

Vault filters Cases to include in the PADER Line Listing Summary for Combination Products using the following constraints:

Case Not Suppressed

The Suppress Submission field on the Case must be set to No or blank (not suppressed).
case_version__v.suppress_submission__v ≠ Yes

FDA Transmission in Reporting Period

Vault filters by the Transmission Date to find Cases submitted to the FDA within the reporting period.

Cases must have an associated Transmission that meets the following conditions:

  • The Transmission Destination is FDA.
    case_version__v.transmission__v.destination__v = fda__v
  • The Transmission Date is within the interval reporting period specified in the Workbench PADER report set.
    transmission__v.transmission_date__v >= transmission_generation.filter_start_range AND transmission__v.transmission_date__v <= transmission_generation.filter_end_range
  • The Transmission is in the E2B ACK Accepted or Completed lifecycle state, and the Transmission lifecycle state type is not Deleted.
    case_version__v.transmission__v.state__v = (e2b_ack_accepted_state__v OR completed_state__v) AND case_version__v.transmission__v.state__v.statetype__v != Deleted
  • The registration on the Transmission record matches that listed in the Aggregate Reporting Group.
    case_version__v.transmission__v.reportable_product_registration__v = aggregate_reporting_group__v.product_registration__v

The report lists only the latest version of the Case transmitted to the FDA within the reporting period.

Suspect, Interacting, or Drug Not Administered Product in Aggregate Reporting Group

A Case Product must meet the following conditions:

  • The Product Registration field of a combination product must link to a Product Registration record added as a member of the Aggregate Reporting Group.
    case_version__vr.case_product__v.combination_product_registration__v IN aggregate_reporting_group__vr.aggregate_reporting_group_join__vr.product_registrations__v
  • The Product Registration field of a combination product is on the FDA Transmission.
    case_version__vr.case_product__v.combination_product_registration__v = transmission__v.reportable_product_registrations__v
  • The combination product contains at least one (1) device constituent, and the device constituent has a malfunction (Malfunction is set to Yes).
    Case_version__vr.case_product__v.malfunction__v = Yes WHERE Case_version__vr.case_product__v.product_type__v = Device
  • The Drug Role field must be set to Suspect (E2B code=1), Interacting (E2B code=3), or Drug Not Administered (E2B code=4).
    case_product__v.drug_role__v.controlled_vocabulary__v.e2b_code__v = 1 OR 3 OR 4
Initial vs. Follow-Up Report

To determine whether Cases should be listed in initial or follow-up reports, Vault evaluates the Transmission Reason (transmission_reason__v) field on FDA Transmissions within the reporting period using the following logic:

  • Initial reports: When there is at least one (1) FDA Transmission within the reporting period with the Transmission Reason set to one (1) of the following:
    • Initial
    • A custom Transmission Reason Controlled Vocabulary where the E2B code is set to I (initial)
      transmission__v.reason__v.controlled_vocabulary__v.e2b_code__v = I
  • Follow-up reports: When all FDA Transmissions within the reporting period have the Transmission Reason set to one (1) of the following:
    • Amendment
    • Follow-Up
    • A custom Transmission Reason Controlled Vocabulary where the E2B code is not set to I (initial) or 1 (nullification)
      transmission__v.reason__v.controlled_vocabulary__v.e2b_code__v ≠ I OR 1
Table Mapping
Number Name Description
1 Combination Submission Type

Vault maps this value from the Transmission > FDA Report Type.
transmission__v.fda_report_type__v

If the FDA Report Type is 5-Day, Vault sets the value to 5-Day.

Otherwise, Vault sets the value to Other Reportable Malfunction.

2 ICSR Initial/Follow-up

Cases in the Initial category include an initial Transmission in the report interval.

Cases in the Initial with Follow-up category include an initial Transmission and at least one (1) follow-up Transmission in the report interval. This is a subset of the Initial category.

Cases in the Follow-up category do not include any initial Transmissions in the report interval.

3 Submission Count

For the Initial, Initial with Follow-up, and Follow-up categories, Vault counts the number of Submissions for Cases in each category.

4 Case Count

For the Initial, Initial with Follow-up, and Follow-up categories, Vault counts the number of Cases in each category.

Malfunction Tabulation

Event-Based Report: This report prints the number of Case Adverse Events that match report criteria.

The following image displays the Malfunction Tabulation: workbench-pader-malfunction-tabulation

Table Constraints

Vault filters Cases to include in the PADER Malfunction Tabulation using the following constraints:

Case Not Suppressed

The Suppress Submission field on the Case must be set to No or blank (not suppressed).
case_version__v.suppress_submission__v ≠ Yes

FDA Transmission in Reporting Period

Vault filters by the Transmission Date to find Cases submitted to the FDA within the reporting period.

Cases must have an associated Transmission that meets the following conditions:

  • The Transmission Destination is FDA.
    case_version__v.transmission__v.destination__v = fda__v
  • The Transmission Date is within the interval reporting period specified in the Workbench PADER report set.
    transmission__v.transmission_date__v >= transmission_generation.filter_start_range AND transmission__v.transmission_date__v <= transmission_generation.filter_end_range
  • The Transmission is in the E2B ACK Accepted or Completed lifecycle state, and the Transmission lifecycle state type is not Deleted.
    case_version__v.transmission__v.state__v = (e2b_ack_accepted_state__v OR completed_state__v) AND case_version__v.transmission__v.state__v.statetype__v != Deleted
  • The registration on the Transmission record matches that listed in the Aggregate Reporting Group.
    case_version__v.transmission__v.reportable_product_registration__v = aggregate_reporting_group__v.product_registration__v

The report lists only the latest version of the Case transmitted to the FDA within the reporting period.

Suspect, Interacting, or Drug Not Administered Product in Aggregate Reporting Group

A Case Product must meet the following conditions:

  • The Product Registration field of a combination product must link to a Product Registration record added as a member of the Aggregate Reporting Group.
    case_version__vr.case_product__v.combination_product_registration__v IN aggregate_reporting_group__vr.aggregate_reporting_group_join__vr.product_registrations__v
  • The Product Registration field of a combination product is on the FDA Transmission.
    case_version__vr.case_product__v.combination_product_registration__v = transmission__v.reportable_product_registrations__v
  • The combination product contains at least one (1) device constituent, and the device constituent has a malfunction (Malfunction is set to Yes).
    Case_version__vr.case_product__v.malfunction__v = Yes WHERE Case_version__vr.case_product__v.product_type__v = Device
  • The Drug Role field must be set to Suspect (E2B code=1), Interacting (E2B code=3), or Drug Not Administered (E2B code=4).
    case_product__v.drug_role__v.controlled_vocabulary__v.e2b_code__v = 1 OR 3 OR 4
Table Mapping

Sorting: Cases are sorted in ascending order, first by SOC and then by PT.

Number Name Description
1 SOC The MedDRA System Organ Class (SOC) for the Case Adverse Event. The sum of all adverse events under this SOC is listed under each column.
event_meddra__v.soc_term__v
2 PT The MedDRA Preferred Term (PT) coded on the Case Adverse Event, grouped by the MedDRA SOC.
case_adverse_event__v.event_meddra__v.pt_term__v
3 Serious Labeled The sum of adverse events that meet the following criteria:
  • Serious: The Case Adverse Event > Seriousness field is populated.
    case_adverse_event__v.seriousness__v ≠ EMPTY
  • Labeled: Vault looks for an Expected value of Yes in the following priority order:
    1. Case Assessment Expectedness where the Country is set to United States, or another country in the FDA's jurisdiction
    2. The Expectedness field on the primary Case Assessment
    3. The Case Expectedness field
    (case_assessment__v.case_assessment_expectedness__v.expected__v = Yes
    AND
    case_assessment_expectedness__v.country__v.agency__v = fda__v)
    ELSE
    (case_assessment__v.expectedness__v = Yes
    WHERE
    case_assessment__v.rank__v = 1)
    ELSE
    (case_version__v.expected__v = Yes)
4 Serious Unlabeled The sum of adverse events that meet the following criteria:
  • Serious: The Case Adverse Event > Seriousness field is populated.
    case_adverse_event__v.seriousness__v ≠ EMPTY
  • Unlabeled: One (1) of the following conditions must be met on the Case Assessment for the Case Adverse Event:
    • If local product Datasheets are configured, the Case Assessment Expectedness records under the Case Assessment must meet the following criteria:
      • A Case Assessment Expectedness record must exist with the Expected field set to No.
      • The local Datasheet used to calculate the Case Assessment Expectedness must specify FDA as the Agency on the Country.
    • If no local Datasheets within the FDA's jurisdiction are configured, Vault evaluates the Case Assessment for each adverse event. The Case Assessment > Expected field must be set to No or blank to be considered Unlabeled.
    • (case_assessment__v.case_assessment_expectedness__v.expected__v = No
      AND
      case_assessment_expectedness__v.country__v.agency__v = fda__v)
      ELSE
      (case_assessment__v.expectedness__v = No or Blank)
5 Non-Serious Labeled The sum of adverse events that meet the following criteria:
  • Non-Serious: The Case Adverse Event > Seriousness field is blank.
    case_adverse_event__v.seriousness__v = EMPTY
  • Labeled: Vault looks for an Expected value of Yes in the following priority order:
    1. Case Assessment Expectedness where the Country is set to United States, or another country in the FDA's jurisdiction
    2. The Expectedness field on the primary Case Assessment
    3. The Case Expectedness field
    (case_assessment__v.case_assessment_expectedness__v.expected__v = Yes
    AND
    case_assessment_expectedness__v.country__v.agency__v = fda__v)
    ELSE
    (case_assessment__v.expectedness__v = Yes
    WHERE
    case_assessment__v.rank__v = 1)
    ELSE
    (case_version__v.expected__v = Yes)
6 Non-Serious Unlabeled The sum of adverse events that meet the following criteria:
  • Non-Serious: The Case Adverse Event > Seriousness field is blank.
    case_adverse_event__v.seriousness__v = EMPTY
  • Unlabeled: One (1) of the following conditions must be met on the Case Assessment for the Case Adverse Event:
    • If local product Datasheets are configured, the Case Assessment Expectedness records under the Case Assessment must meet the following criteria:
      • A Case Assessment Expectedness record must exist with the Expected field set to No.
      • The local Datasheet used to calculate the Case Assessment Expectedness must specify FDA as the Agency on the Country.
    • If no local Datasheets within the FDA's jurisdiction are configured, Vault evaluates the Case Assessment for each adverse event. The Case Assessment > Expected field must be set to No or blank to be considered Unlabeled.
    • (case_assessment__v.case_assessment_expectedness__v.expected__v = No
      AND
      case_assessment_expectedness__v.country__v.agency__v = fda__v)
      ELSE
      (case_assessment__v.expectedness__v = No or Blank)
7 Total Events The total sum of adverse events for each MedDRA SOC and PT.
8 Total Cases The total sum of Cases for each MedDRA SOC and PT.