**Source URL:** https://safety.veevavault.help/en/lr/1118845/index.md

# Create Workbench PMDA Postmarket Aggregate Reports

Safety Workbench provides Pharmaceuticals and Medical Devices Agency (PMDA) Postmarket report authoring and table generation capabilities. The Vault Safety PMDA Postmarket report adheres to the PMDA Guide to Electronic Reporting of Adverse Drug Reactions and Infectious Diseases.

The following table summarizes the Workbench PMDA Postmarket tabulations that Safety Workbench generates:

|Tabulation|Masking Support?|
|--- |--- |
|[_J-NUPR Line Listing Form 7-2_][26]|No|
|[_J-PSR Cumulative Tabulation of Adverse Events Form 3_][27]|No|
|[_J-PSR Line Listing of Adverse Events Form 4_][28]|No|
|[_Case Series Report_][19]|No|
|[_Open Cases Report_][20]|No|

## Prerequisites
To generate Workbench PMDA aggregate reports:
* Your Admin must configure the [PMDA Postmarket Workbench Report Set][1] 
* Your Admin must grant you permissions to view and prepare aggregate reports
* Depending on your business process, your Admin may: 
   * Configure a <a href="/en/lr/01198/#datasheet-types">_Datasheet_</a> for each _Study Product_, _Study_, or _Product_ with a list of expected adverse events in order to classify adverse events as _Listed_ or _Unlisted_ in Workbench PMDA reports
   * Configure custom <a href="/en/lr/774151/#pmda-templates">Workbench PMDA Postmarket Workbench Report Set templates</a> for your organization

## Overview
To generate a Workbench PMDA aggregate report:
1. [Create a _Workbench Report Set_][1] to combine the desired PMDA _Workbench Report Definitions_ into a single record.
2. [Specify the required PMDA filters][3] on the _Workbench Report Set_.
3. [Generate then run the PMDA _Workbench Reports_][4] from the _Workbench Report Set_.

To learn how Vault maps data to each Workbench PMDA report, see [PMDA Table Generation Data Mapping][5].

## Create a PMDA Postmarket Workbench Report Set {#create-workbench-report-set}
To create a PMDA _Workbench Report Set_:
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. In the _Reports to Generate_ section, add a <a href="/en/lr/826869/#add-workbench-report-definitions">_Workbench Report Definition_</a> to the _Workbench Report Set_ for each PMDA report you want to include.

 <div class="note-border alert-info">
  <div class="alert alert-info" role="alert">
    <div><i class="far fa-info-circle"></i></div>
    <div class="alert-text">
      <p><strong>Note</strong>: When your Admin configures Workbench PMDA Aggregate Reports, they <a href="/en/lr/1118818/#create-workbench-report-definitions">create a <em>Workbench Report Definition</em></a> for each unmasked report. If your <em>Workbench Report Set</em> does not contain the expected PMDA reports, contact your Admin for assistance.</p>
    </div>
  </div>
</div>



**Result**

Vault sets the lifecycle state of the _Workbench Report Set_ to _Draft_.

### PMDA Postmarket Filter Section Fields {#filter-section-fields}
You can specify the following fields for a PMDA Postmarket Workbench Report Set:

<table>
    <thead>
        <tr>
            <th>Field</th>
            <th>Description</th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <td><a id="date-filter"><em>Date Filter</em></a></td>
            <td>
                <p>
                    You can run reports with individual date filters, as well as in a report set. 
                </p>
                <p>
                    Select the date filter(s) from the following:
                </p>
                <ul>
                    <li>J-PSR Previous Interval 1 (earliest)</li>
                    <li>J-PSR Previous Interval 2</li>
                    <li>J-PSR Previous Interval 3</li>
                    <li>J-PSR Previous Interval 4</li>
                    <li>J-PSR Previous Interval 5</li>
                    <li>J-PSR Previous Interval 6</li>
                    <li>J-PSR Previous Interval 7</li>
                    <li>J-PSR Previous Interval 8</li>
                    <li>J-PSR Previous Interval 9</li>
                    <li>J-NUPR / J-PSR Current Interval</li>
                </ul>
            </td>
        </tr>
        <tr>
            <td><em>Case Completed</em></td>
            <td>
                <p>
                    Select whether the <em>Case</em> is open or completed from the drop-down menu to filter the report.
                </p>
                <p>
                    Consider the following:
                </p>
                <ul>
                    <li>
                        The <strong>Completed</strong> option includes <em>Cases</em> in the following states:
                        <ul>
                            <li>Approved (<code>approved_state__v</code>)</li>
                            <li>Closed (<code>closed_state__v</code>)</li>
                            <li>Superseded (<code>superseded_state__v</code>)</li>
                        </ul>
                    </li>
                    <li>The <strong>Open</strong> option includes any <em>Case</em> in a state not defined as completed, including any custom lifecycle states.</li>
                    <li>If you leave this field blank, the report filters for all <em>Cases</em> regardless of their state.</li>
                </ul>
            </td>
        </tr>
        <tr>
            <td><a id="aggregate-reporting-group"><em>Aggregate Reporting Group</em></a></td>
            <td>
                <p>
                    Select an <a href="/en/lr/873342/"><em>Aggregate Reporting Group</em></a> from the drop-down, or use the <strong>Advanced Search</strong> (<img class="inline" src="https://platform.veevavault.help/assets/images/icon-binoculars.png" alt="Binoculars Icon" style="" />) icon to use filters and refine your search.
                </p>
                <p>
                    Vault considers the following <em>Cases</em> eligible for inclusion in the generated reports:
                </p>
                <ul>
                    <li><em>Cases</em> with a <em>Product</em> in the <em>Aggregate Reporting Group</em></li>
                    <li><em>Cases</em> with a <em>Product Registration</em> in the <em>Aggregate Reporting Group</em></li>
                </ul>
            </td>
        </tr>
    </tbody>
</table>

## Generate Workbench PMDA Postmarket Tabulations {#generate-run-workbench-tabulations}
Review and verify the report settings. Once you have confirmed the report details are correct, use the <a href="/en/lr/860557/">Generate Aggregate Report Tabulations</a> action to generate PMDA Postmarket report tables.

## PMDA Postmarket Table Generation Data Mapping {#table-generation-data-mapping}
Safety Workbench populates aggregate report tables using Cases within the reporting period specified on the PMDA Postmarket report, and the aggregate reporting group configured on the associated <a href="/en/lr/873342/">Aggregate Reporting Group</a>. The following sections describe how Safety Workbench generates PMDA Postmarket tabulations: 

* [J-NUPR Line Listing Form 7-2][26]
* [J-PSR Cumulative Tabulation of Adverse Events Form 3][27]
* [J-PSR Line Listing of Adverse Events Form 4][28]

### J-NUPR Line Listing Form 7-2 {#nupr-form-7-2}

Vault generates the J-NUPR Line Listing Form 7-2 by default for PMDA Postmarket aggregate reports.

<a href="https://platform.veevavault.help/assets/images/saf-japan-post-market-nupr.png" data-lightbox="saf-japan-post-market-nupr.png" data-title="" data-alt="NUPR Line Listing Form 7-2">
  <img class="docimage" src="https://platform.veevavault.help/assets/images/saf-japan-post-market-nupr.png" alt="NUPR Line Listing Form 7-2" style=""  />
</a>

#### Table Constraints

Vault filters Cases to include in the J-NUPR Line Listing Form 7-2 using the following constraints:

##### <a id="not-supressed"></a>Case Not Suppressed

The Case <strong>Suppress Submission</strong> field must be set to <strong>No</strong> or blank (not suppressed).
<br>`case_version__v.suppress_submission__v ≠ Yes`

##### Case Product or Product Registration in Aggregate Reporting Group
A _Case_ must have a _Product_ or _Product Registration_ that is a member of the _Aggregate Reporting Group_.
* `case_version__vr.case_product__v IN aggregate_reporting_group__vr.aggregate_reporting_group_join__vr.product__v`
* `case_version__vr.case_product__v.product_registration__v.registration_number__v IN aggregate_reporting_group__vr.aggregate_reporting_group_join__vr.product_registration__v`

##### Case Data in Interval Reporting Period
The date of a _Case_ must be within the _J-NUPR / J-PSR Current Interval Range_. 
`DATE ≥ nupr_jpsr_current_report_interval__v.data_period_start__v` **AND**
`DATE ≤ nupr_jpsr_current_report_interval__v.data_period_end__v`
**WHERE** `DATE` selected is the _Local Awareness Date_.

If there are multiple versions of the _Case_ within the reporting period, only the most recent _Case_ version within the reporting period is listed.

##### Case Lifecycle State  
The latest _Case_ version within the reporting period must be in a state specified in the _Case Completed_ filter.
`case_version__v.state__v CONTAINS pmda_post_market__v.states_to_include__v`

Consider the following:
* _Cases_ in the following states are always omitted and cannot be selected in the _States to Include_ field:
    * Nullified (`nullified_state__v`)
    * Voided (`voided_state__v`)
* The **Completed** option includes *Cases* in the following states:
      * Approved (`approved_state__v`)
      * Closed (`closed_state__v`)
      * Superseded (`superseded_state__v`)
    * The **Open** option includes any _Case_ in a state not defined as completed, including any custom lifecycle states.
    * If you leave this field blank, the report filters for all _Cases_ regardless of their state.

##### Localized Case

A Case must have a Japan localized version to be included.

`case_version__v.reporter_country__v = Japan`

##### <a id="case-product-drug-roles-to-include"></a>Case Product in Drug Roles to Include

Only include Case Products in the listing where **Drug Role** is "Suspect" or "Interacting".

##### Postmarket Cases

Only include Cases that are considered postmarket.

The `case_product_registration__v.registration_type_cv__v` E2B code is one of the following: (1, 2, 5, 6, 7)

##### Special Report Classification

Exclude Cases with a **Special Report Classification** of "Research Report" or "Safety Measure".

`case_version__v.special_report_classification__v IN (safety_measure_report__v, research_report__v)`

##### Unexpected Adverse Events

Include only events that meet all of the following criteria:
* The event is non-serious (`localized_case_adverse_event__v.seriousness__v = Blank`)
* The event is Unexpected (`localized_case_assessment__v.expected__v != yes`)
* The event is related to the product in the report (**Causality Established** is set to Yes or Blank for at least one Assessment Result)
* The event is reportable (`localized_case_adverse_event__v. special_adverse_event__v != "Non-reportable Event"`)

#### Table Mapping

**Sorting**: Rows are in order of Event (PT) alphabetically, then by Adverse Event Onset Date (earliest first). Events with a blank Onset Date are listed last.

<table>
  <thead>
    <tr>
      <th>Number</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon1.png" alt="1" style="" /></td>
      <td>Case # (番号)</td>
      <td>
        The Case Number<br>
        <code>case_version__v.case_number__v</code>
      </td>
    </tr>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon2.png" alt="2" style="" /></td>
      <td>Event (PT) (基本語)</td>
      <td>
        The Localized MedDRA Preferred Term Event in Japanese (from the local MedDRA version)
      </td>
    </tr>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon3.png" alt="3" style="" /></td>
      <td>MedDRA Code (MedDRAコード)</td>
      <td>
        The MedDRA Preferred Term Code
      </td>
    </tr>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon4.png" alt="4" style="" /></td>
      <td>Gender (性別)</td>
      <td>
        The sex on the <em>Case</em><br>
        If the field is blank, "不明" (Unknown in Japanese) is displayed.
      </td>
    </tr>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon5.png" alt="5" style="" /></td>
      <td>Age (年齢)</td>
      <td>
        The normalized Age (in years) on the Case<br>
        If age is not populated on the case, the report will display Age Group. <br>
        If Age Group is not populated, it will display "不明" (Unknown in Japanese).
      </td>
    </tr>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon6.png" alt="6" style="" /></td>
      <td>Onset Date (副作用等発現 年月日)</td>
      <td>
        The Onset Date of the Case Adverse Event, as entered in the <strong>Date of Onset</strong> field on the Case Adverse Event in the format "YYYY年MM月DD日" <br>
        If the field is blank, "不明" (Unknown in Japanese) is displayed.
      </td>
    </tr>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon7.png" alt="7" style="" /></td>
      <td>Outcome (転帰)</td>
      <td>
        The Outcome of the Case Adverse Event<br>
        The value selected in the <strong>Case Adverse Event Outcome</strong> field.
      </td>
    </tr>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon8.png" alt="8" style="" /></td>
      <td>Report Type (報告の 種類)</td>
      <td>
        The Case Report Type<br>
        The value selected in the <strong>Case Report Type</strong> field.
      </td>
    </tr>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon9.png" alt="9" style="" /></td>
      <td>Remarks (備考)</td>
      <td>
        <p>
            Up to three items are displayed in this column:
        </p>
        <ol>
          <li>
              The Product Name (<code>case_product__v.product_registration__v.trade_name__v</code>) or Product Registration (<code>case_product_registration__v. product_registration__v</code>)
          </li>
          <li>
              The Destination Case ID, if it exists, for the Product Registration (<code>transmission__v.destination_case_id__v</code> for the <code>product_registration__v</code>)
          </li>
        </ol>
      </td>
    </tr>
  </tbody>
</table>

### J-PSR Cumulative Tabulation of Adverse Events Form 3 {#j-psr-form-3}

The following image map shows how Vault generates the J-PSR Cumulative Tabulation of Adverse Events Form 3 table.

<a href="https://platform.veevavault.help/assets/images/saf-jpsr-cum-tab-ae-form3.png" data-lightbox="saf-jpsr-cum-tab-ae-form3.png" data-title="" data-alt="J-PSR Cumulative Tabulation of Adverse Events Form 3">
  <img class="docimage" src="https://platform.veevavault.help/assets/images/saf-jpsr-cum-tab-ae-form3.png" alt="J-PSR Cumulative Tabulation of Adverse Events Form 3" style=""  />
</a>

#### Table Constraints

Vault filters Cases to include in the J-PSR Cumulative Tabulation of Adverse Events Form 3 using the following constraints:

##### <a id="not-supressed"></a>Case Not Suppressed

The Case <strong>Suppress Submission</strong> field must be set to <strong>No</strong> or blank (not suppressed).
<br>`case_version__v.suppress_submission__v ≠ Yes`

##### Case Product or Product Registration in Aggregate Reporting Group
A _Case_ must have a _Product_ or _Product Registration_ that is a member of the _Aggregate Reporting Group_.
* `case_version__vr.case_product__v IN aggregate_reporting_group__vr.aggregate_reporting_group_join__vr.product__v`
* `case_version__vr.case_product__v.product_registration__v.registration_number__v IN aggregate_reporting_group__vr.aggregate_reporting_group_join__vr.product_registration__v`

##### Case Data in Interval Reporting Period

The _Case_ date must fall within the defined aggregate report interval reporting periods. 

<code>earliest(aggregate_report_intervals__v) &le; DATE &le; aggregate_report_intervals__v.latest(interval_end_date__v)</code>

Where <code>DATE</code> 
Local Awareness Date: <code>Data Period Start Date &le; localized_case__v.local_awareness_date__v &le; Data Period End Date</code>

##### Configuring Report Intervals

When defining reporting periods, Vault evaluates the interval records based on the following rules:

**Required Current Interval:** You must enter at least one interval in the _J-NUPR / J-PSR Current Interval Range_ field. Vault always treats this entry as the latest (most recent) interval.

**Optional Historical Intervals:** If the report requires a broader data window, you can configure up to nine additional historical intervals using the _Previous J-PSR Interval 1_ through _Previous J-PSR Interval 9_ fields.

**Sequential Entry:** Interval dates must be entered sequentially based on the total number of periods being reported.

**Example:** If you are running a report across three total intervals, you must populate dates in _Previous J-PSR Interval 1_, _Previous J-PSR Interval 2_, and the _J-NUPR / J-PSR Current Interval Range_.

If there are multiple versions of the _Case_ among all the reporting intervals, Vault lists only the most recent _Case_ version.

##### Case Lifecycle State  
The latest _Case_ version within the reporting period must be in a state specified in the _Case Completed_ filter.
`case_version__v.state__v CONTAINS pmda_post_market__v.states_to_include__v`

Consider the following:
* _Cases_ in the following states are always omitted and cannot be selected in the _States to Include_ field:
    * Nullified (`nullified_state__v`)
    * Voided (`voided_state__v`)
* The **Completed** option includes *Cases* in the following states:
      * Approved (`approved_state__v`)
      * Closed (`closed_state__v`)
      * Superseded (`superseded_state__v`)
    * The **Open** option includes any _Case_ in a state not defined as completed, including any custom lifecycle states.
    * If you leave this field blank, the report filters for all _Cases_ regardless of their state.

##### Localized Case

A Case must have a Japan localized version to be included.

`case_version__v.reporter_country__v = Japan`

##### <a id="case-product-drug-roles-to-include"></a>Case Product in Drug Roles to Include

Only include Case Products in the listing where **Drug Role** is "Suspect" or "Interacting".

##### Postmarket Cases

Only include Cases that are considered postmarket.

The `case_product_registration__v.registration_type_cv__v` E2B code is one of the following: (1, 2, 5, 6, 7)

##### Special Report Classification

Exclude Cases with a **Special Report Classification** of "Research Report" or "Safety Measure".

`case_version__v.special_report_classification__v IN (safety_measure_report__v, research_report__v)`

##### Blind Setting

For Study Cases, only unblinded data is included in the report.

If your Admin has configured your Vault to <a href="/en/lr/691317/">isolate blinded clinical trial information</a>, the <em>Blinding Type</em> on the Japan Case Product Registration must be set to Unblinded, Open, or blank.

`case_product_registration__v.blinding_type__v != Blinded`

##### Serious, Related Adverse Events

All _Adverse Events_ that are Serious and Related are included. In addition, events that meet all of the following criteria are included:

* The _Localized Case Adverse Event_ is Serious (<code>localized_case_adverse_event__v.seriousness__v = !Blank</code>)
* The event is related to the _Product_ in the report (_Causality Established_ is set to Yes or Blank for at least one _Assessment Result_)
* The event is reportable (<code>localized_case_adverse_event__v.special_adverse_event__v != "Non-reportable Event"</code>)

A _Case_ must have a _Product_ or _Product Registration_ that is a member of the <a href="/en/lr/873342/">_Aggregate Reporting Group_</a>:

* <code>case_version__vr.case_product__v IN aggregate_reporting_group__vr.aggregate_reporting_group_join__vr.product__v</code>
* <code>case_version__vr.case_product__v.product_registration__v.registration_number__v IN aggregate_reporting_group__vr.aggregate_reporting_group_join__vr.product_registration__v</code>

Vault excludes _Adverse Events_ with no _Assessment_ or _Assessment Result_ records.

##### Reporting Interval Assignments

Vault includes _Cases_ within a reporting interval when the applicable _Case_ date (_Local Awareness Date_) is on or between the _Interval Start Date_ and _Interval End Date_ on the _Interval Dates_ filter.

For example, the PMDA allows three different methods for handling cases with multiple versions. The following example is the method where only the latest version is reported:

* **Interval 1:** January 1 &ndash; March 31
* **Interval 2:** April 1 &ndash; June 30

If a _Case_ has two versions with different _Local Awareness Dates_:

* Version 1 falls into Interval 1
* Version 2 falls into Interval 2

**Result:** Only Version 2 will be included, and it will only appear in Interval 2. Version 1 is excluded so the case is not counted twice.

_Cases_ that do not fall into any reporting intervals will be dropped.

#### Table Mapping

**Sorting**: Rows are in order of Event (SOC) alphabetically, then Event (PT) alphabetically. Each reporting interval appears in a separate column.

<table>
  <thead>
    <tr>
      <th>Number</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon1.png" alt="1" style="" /></td>
      <td>Event (SOC) (器官別大分類)</td>
      <td>The Localized MedDRA System Organ Class (SOC) affected by the Adverse Event in Japanese (from the local MedDRA version)</td>
    </tr>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon2.png" alt="2" style="" /></td>
      <td>Event (PT) (基本語)</td>
      <td>
        The Localized MedDRA Preferred Term Event in Japanese (from the local MedDRA version)
      </td>
    </tr>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon3.png" alt="3" style="" /></td>
      <td>The Number of Adverse Events Reported (副作用・感染症の症例報告を行った症例数)</td>
      <td><p>The number of reported Adverse Events for that reporting interval.</p>
      <p>A report can include mulitple reporting intervals.</p>
      <p>The reporting interval dates are included in the column headers of the report.</p>
      </td>
    </tr>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon4.png" alt="4" style="" /></td>
      <td>Unknown (不明 )</td>
      <td><p>The number of reported Cases that do not fall within the dates of any reporting interval on the report.</p>
      <p>This column appears only when the report interval dates have been set up incorrectly.</p></td>
    </tr>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon5.png" alt="5" style="" /></td>
      <td>Total During Reexamination Period (再審査期間中の合計)</td>
      <td>The total number of Cases for the reexamination period for each row on the report.</td>
    </tr>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon6.png" alt="6" style="" /></td>
      <td>Remarks (備考)</td>
      <td><p>Up to two items are displayed in this column:</p>
      <ol>
      <li>The Product Name (<code>case_product__v.product_registration__v.trade_name__v</code>) or Product Registration (<code>case_product_registration__v. product_registration__v</code>)</li>
      <li>The Destination ID, if it exists (<code>transmission__v.destination_case_id__v</code>)</li>
      </ol>
      </td>
    </tr>
  </tbody>
</table>

### J-PSR Line Listing of Adverse Events Form 4 {#j-psr-form-4}

The following image map shows how Vault generates the J-PSR Line Listing of Adverse Events Form 4 table.

<a href="https://platform.veevavault.help/assets/images/saf-jpsr-line-list-ae-form4.png" data-lightbox="saf-jpsr-line-list-ae-form4.png" data-title="" data-alt="J-PSR Line Listing of Adverse Events Form 4">
  <img class="docimage" src="https://platform.veevavault.help/assets/images/saf-jpsr-line-list-ae-form4.png" alt="J-PSR Line Listing of Adverse Events Form 4" style=""  />
</a>

#### Table Constraints

Vault filters Cases to include in the J-PSR Cumulative Tabulation of Adverse Events Form 4 using the following constraints:

##### <a id="not-supressed"></a>Case Not Suppressed

The Case <strong>Suppress Submission</strong> field must be set to <strong>No</strong> or blank (not suppressed).
<br>`case_version__v.suppress_submission__v ≠ Yes`

##### Case Product or Product Registration in Aggregate Reporting Group
A _Case_ must have a _Product_ or _Product Registration_ that is a member of the <a href="/en/lr/873342/">_Aggregate Reporting Group_</a>.
* `case_version__vr.case_product__v IN aggregate_reporting_group__vr.aggregate_reporting_group_join__vr.product__v`
* `case_version__vr.case_product__v.product_registration__v.registration_number__v IN aggregate_reporting_group__vr.aggregate_reporting_group_join__vr.product_registration__v`

##### Case Data in Interval Reporting Period

The _Case_ date must fall within the defined aggregate report interval reporting periods. 

<code>earliest(aggregate_report_intervals__v) &le; DATE &le; aggregate_report_intervals__v.latest(interval_end_date__v)</code>

Where <code>DATE</code> 
Local Awareness Date: <code>Data Period Start Date &le; localized_case__v.local_awareness_date__v &le; Data Period End Date</code>

##### Configuring Report Intervals

When defining reporting periods, Vault evaluates the interval records based on the following rules:

**Required Current Interval:** You must enter at least one interval in the _J-NUPR / J-PSR Current Interval Range_ field. Vault always treats this entry as the latest (most recent) interval.

**Optional Historical Intervals:** If the report requires a broader data window, you can configure up to nine additional historical intervals using the _Previous J-PSR Interval 1_ through _Previous J-PSR Interval 9_ fields.

**Sequential Entry:** Interval dates must be entered sequentially based on the total number of periods being reported.

**Example:** If you are running a report across three total intervals, you must populate dates in _Previous J-PSR Interval 1_, _Previous J-PSR Interval 2_, and the _J-NUPR / J-PSR Current Interval Range_.

If there are multiple versions of the _Case_ among all the reporting intervals, Vault lists only the most recent _Case_ version.

##### Case Lifecycle State  
The latest _Case_ version within the reporting period must be in a state specified in the _Case Completed_ filter.
`case_version__v.state__v CONTAINS pmda_post_market__v.states_to_include__v`

Consider the following:
* _Cases_ in the following states are always omitted and cannot be selected in the _States to Include_ field:
    * Nullified (`nullified_state__v`)
    * Voided (`voided_state__v`)
* The **Completed** option includes *Cases* in the following states:
      * Approved (`approved_state__v`)
      * Closed (`closed_state__v`)
      * Superseded (`superseded_state__v`)
    * The **Open** option includes any _Case_ in a state not defined as completed, including any custom lifecycle states.
    * If you leave this field blank, the report filters for all _Cases_ regardless of their state.

##### Localized Case

A Case must have a Japan localized version to be included.

`case_version__v.reporter_country__v = Japan`

##### <a id="case-product-drug-roles-to-include"></a>Case Product in Drug Roles to Include

Only include Case Products in the listing where **Drug Role** is "Suspect" or "Interacting".

##### Postmarket Cases

Only include Cases that are considered postmarket.

The `case_product_registration__v.registration_type_cv__v` E2B code is one of the following: (1, 2, 5, 6, 7)

##### Special Report Classification

Exclude Cases with a **Special Report Classification** of "Research Report" or "Safety Measure".

`case_version__v.special_report_classification__v IN (safety_measure_report__v, research_report__v)`

##### Blind Setting

For Study Cases, only unblinded data is included in the report.

If your Admin has configured your Vault to <a href="/en/lr/691317/">isolate blinded clinical trial information</a>, the <em>Blinding Type</em> on the Japan Case Product Registration must be set to Unblinded, Open, or blank.

`case_product_registration__v.blinding_type__v != Blinded`

##### Serious, Related Adverse Events

All _Adverse Events_ that are Serious and Related are included. In addition, events that meet all of the following criteria are included:

* The _Localized Case Adverse Event_ is Serious (<code>localized_case_adverse_event__v.seriousness__v = !Blank</code>)
* The event is related to the _Product_ in the report (_Causality Established_ is set to Yes or Blank for at least one _Assessment Result_)
* The event is reportable (<code>localized_case_adverse_event__v.special_adverse_event__v != "Non-reportable Event"</code>)

A _Case_ must have a _Product_ or _Product Registration_ that is a member of the <a href="/en/lr/873342/">_Aggregate Reporting Group_</a>:

* <code>case_version__vr.case_product__v IN aggregate_reporting_group__vr.aggregate_reporting_group_join__vr.product__v</code>
* <code>case_version__vr.case_product__v.product_registration__v.registration_number__v IN aggregate_reporting_group__vr.aggregate_reporting_group_join__vr.product_registration__v</code>

Vault excludes _Adverse Events_ with no _Assessment_ or _Assessment Result_ records.

##### Reporting Interval Assignments

Vault includes _Cases_ within a reporting interval when the applicable _Case_ date (_Local Awareness Date_) is on or between the _Interval Start Date_ and _Interval End Date_ on the _Interval Dates_ filter.

For example, the PMDA allows three different methods for handling cases with multiple versions. The following example is the method where only the latest version is reported:

* **Interval 1:** January 1 &ndash; March 31
* **Interval 2:** April 1 &ndash; June 30

If a _Case_ has two versions with different _Local Awareness Dates_:

* Version 1 falls into Interval 1
* Version 2 falls into Interval 2

**Result:** Only Version 2 will be included, and it will only appear in Interval 2. Version 1 is excluded so the case is not counted twice.

_Cases_ that do not fall into any reporting intervals will be dropped.

#### Table Mapping

**Sorting**: Rows are in order of reporting interval (earliest first), Event (SOC) alphabetically, Event (PT) alphabetically, New Info Date (earliest first), and then Case Number. If the New Info Date is blank, Vault references the Case Receipt Date (earliest first).

Each Reporting Interval heading appears on a separate line. If an interval has no Event PTs, Vault adds the following note:「該当なし」("N/A" in Japanese).

<table>
  <thead>
    <tr>
      <th>Number</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon1.png" alt="1" style="" /></td>
      <td>Reporting Cycle # (番号)</td>
      <td>The name of the reporting interval on the Interval Dates record.<br>
      <code>aggregate_intervals__vr.name__v</code></td>
    </tr>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon2.png" alt="2" style="" /></td>
      <td>Event (SOC) (器官別大分類)</td>
      <td>
        The Localized MedDRA System Organ Class (SOC) affected by the Adverse Event in Japanese (from the local MedDRA version).
      </td>
    </tr>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon3.png" alt="3" style="" /></td>
      <td>Event (PT) (基本語)</td>
      <td><p>The Localized MedDRA Preferred Term Event in Japanese (from the local MedDRA version).</p>
      <p>An asterisk (*) is prepended to unexpected Adverse Events.</p>
      </td>
    </tr>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon4.png" alt="4" style="" /></td>
      <td>Gender (性別)</td>
      <td><p>The sex on the <em>Case</em>.</p>
      <p>If the field is blank, Vault populates "不明" (Unknown in Japanese).</p></td>
    </tr>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon5.png" alt="5" style="" /></td>
      <td>Age (年齢)</td>
      <td><p>The normalized Age (in years) on the Case.</p>
      <p>If age is not populated on the Case, the report displays Age Group.</p>
      <p>If the field is blank, Vault populates "不明" (Unknown in Japanese).</p></td>
    </tr>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon6.png" alt="6" style="" /></td>
      <td>Onset Date (副作用等発現 年月日)</td>
      <td><p>The Onset Date of the Case Adverse Event, as entered in the <em>Date of Onset</em> field on the Case Adverse Event in the format "YYYY年MM月DD日".</p>
      <p>If the field is blank, Vault populates "不明" (Unknown in Japanese).</p>
      </td>
    </tr>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon7.png" alt="7" style="" /></td>
      <td>Outcome (転帰)</td>
      <td><p>The Outcome of the Case Adverse Event.</p>
      <p>The value in the <em>Case Adverse Event Outcome</em> field.</p>
      <p>If the field is blank, Vault populates "不明" (Unknown in Japanese).</p>
      </td>
    </tr>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon8.png" alt="8" style="" /></td>
      <td>Infection or Adverse Event (副作用・感染症の区分)</td>
      <td><p>Vault references the Localized Case Adverse Event to populate this data. If the <em>Special Adverse Event</em> field is set to "Infection", Vault populates 感染症 (Infection in Japanese).</p>
      <p>Otherwise, Vault populates 副作用  (Adverse Event in Japanese).</p>
      </td>
    </tr>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon9.png" alt="9" style="" /></td>
      <td>Report Type (報告の 種類)</td>
      <td><p>The Case Report Type.</p>
      <p>The value in the <em>Report Type</em> field.</p>
      </td>
    </tr>
    <tr>
      <td style="text-align: center"><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon10.png" alt="10" style="" /></td>
      <td>PMDA ACK # (識別番号)</td>
      <td>The Destination ID on the Transmission.</td>
    </tr>
  </tbody>
</table>

### Case Series Report {#case-series-report}
The Case Series Report acts as a log file for all of the Cases included across all PMDA line listings and tabulations. Vault generates the Case Series Report in the following structure:

<a href="https://platform.veevavault.help/assets/images/saf-pmda-case-series.png" data-lightbox="saf-pmda-case-series.png" data-title="Sample Workbench PMDA Case Series Report" data-alt="Sample Workbench PMDA Case Series Report">
  <img class="docimage" src="https://platform.veevavault.help/assets/images/saf-pmda-case-series.png" alt="Sample Workbench PMDA Case Series Report" style=""  />
</a>

<div class="note-border alert-info">
  <div class="alert alert-info" role="alert">
    <div><i class="far fa-info-circle"></i></div>
    <div class="alert-text">
      <p><strong>Note</strong>: To aid in understanding how Vault maps Case Series Report data to PMDA files, the following table includes both descriptions and Vault object and field names.</p>
    </div>
  </div>
</div>



<table>
    <thead>
        <tr>
            <th>Reference Image Number</th>
            <th>PMDA Report Field Name</th>
            <th>Description</th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <td><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon1.png" alt="Reference Image 1" style="" /></td>
            <td><strong>Case Number</strong></td>
            <td>
                <p>Vault maps the <em>Case Number</em> on the <em>Case</em>.</p>
                <p><code>case_number__v.id</code></p>
            </td>
        </tr>
        <tr>
            <td><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon2.png" alt="Reference Image 2" style="" /></td>
            <td><strong>Case Name</strong></td>
            <td>
                <p>Vault maps the <em>Name</em> on the <em>Case</em>.</p>
                <p><code>case_version__v.name__v</code></p>
            </td>
        </tr>
        <tr>
            <td><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon3.png" alt="Reference Image 3" style="" /></td>
            <td><strong>Report Type</strong></td>
            <td>
                <p>Vault maps the <em>Report Type</em> on the <em>Case</em>.</p>
                <p><code>case_version__v.report_type__v &gt; localized_controlled_vocabulary__v.name__v</code></p>
            </td>
        </tr>
        <tr>
            <td><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon4.png" alt="Reference Image 4" style="" /></td>
            <td><strong>Local Awareness Date</strong></td>
            <td>
                <p>Vault maps the <em>Local Awareness Date</em> on the <em>Case</em>.</p>
                <p><code>localized_case__v &gt; local_awareness_date__v</code></p>
            </td>
        </tr>
        <tr>
            <td><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon5.png" alt="Reference Image 5" style="" /></td>
            <td><strong>Case Completed</strong></td>
            <td>
                <p>Vault maps whether the <em>Case</em> is Open or Completed on the <em>Case</em>.</p>
                <p><code>If completed__v then 'Completed' else 'Open'</code></p>
            </td>
        </tr>
         <tr>
            <td><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon6.png" alt="Reference Image 6" style="" /></td>
            <td><strong>Eligible for J-NUPR</strong></td>
            <td>
                <p>Vault maps if the <em>Case</em> has a valid event for J-NUPR.</p>
            </td>
        </tr>
         <tr>
            <td><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon7.png" alt="Reference Image 7" style="" /></td>
            <td><strong>Eligible for J-PSR</strong></td>
            <td>
                <p>Vault maps if the <em>Case</em> has a valid event for J-PSR.</p>
            </td>
        </tr>
    </tbody>
</table>

<div class="note-border alert-info">
  <div class="alert alert-info" role="alert">
    <div><i class="far fa-info-circle"></i></div>
    <div class="alert-text">
      <p><strong>Note</strong>: Vault excludes <em>Cases</em> that contain the following field values:</p>
<ul>
    <li>A <em>Lifecycle State</em> value of <em>Nullified</em> or <em>Voided</em></li>
    <li>A <em>Suppress Submission</em> value of <em>Yes</em></li>
</ul>
    </div>
  </div>
</div>

    

### Open Cases Report {#open-cases-report}
The Open Cases Report is an operational report intended to help you identify open _Cases_ that may need to be closed before PMDA submission. It contains a log of all _Cases_ that would be included in at least one PMDA tabulation were they in the _Closed_, _Approved_, or _Superseded_ lifecycle state.

Vault generates the Open Cases Report in the following structure:

<a href="https://platform.veevavault.help/assets/images/saf-pmda-open-case.png" data-lightbox="saf-pmda-open-case.png" data-title="Sample Workbench  PMDA Open Cases Report" data-alt="Sample Workbench PMDA Open Cases Report">
  <img class="docimage" src="https://platform.veevavault.help/assets/images/saf-pmda-open-case.png" alt="Sample Workbench PMDA Open Cases Report" style=""  />
</a>

<div class="note-border alert-info">
  <div class="alert alert-info" role="alert">
    <div><i class="far fa-info-circle"></i></div>
    <div class="alert-text">
      <p><strong>Note</strong>: To aid in understanding how Vault maps Open Cases Report data to PMDA files, the following table includes both descriptions and Vault object and field names.</p>
    </div>
  </div>
</div>



<table>
    <thead>
        <tr>
            <th>Reference Image Number</th>
            <th>PMDA Report Field Name</th>
            <th>Description</th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <td><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon1.png" alt="Reference Image 1" style="" /></td>
            <td><strong>Case Number</strong></td>
            <td>
                <p>Vault maps the <em>Case Number</em> on the <em>Case</em>.</p>
                <p><code>case_number__v.id</code></p>
            </td>
        </tr>
        <tr>
            <td><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon2.png" alt="Reference Image 2" style="" /></td>
            <td><strong>Case Name</strong></td>
            <td>
                <p>Vault maps the <em>Name</em> on the <em>Case</em>.</p>
                <p><code>case_version__v.name__v</code></p>
            </td>
        </tr>
                <tr>
            <td><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon3.png" alt="Reference Image 3" style="" /></td>
            <td><strong>Eligible for J-NUPR</strong></td>
            <td>
                <p>Vault maps if the <em>Case</em> has a valid event for J-NUPR.</p>
            </td>
        </tr>
         <tr>
            <td><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon4.png" alt="Reference Image 4" style="" /></td>
            <td><strong>Eligible for J-PSR</strong></td>
            <td>
                <p>Vault maps if the <em>Case</em> has a valid event for J-PSR.</p>
            </td>
        </tr>
        <tr>
            <td><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon5.png" alt="Reference Image 5" style="" /></td>
            <td><strong>Local Awareness Date</strong></td>
            <td>
                <p>Vault maps the <em>Local Awareness Date</em> on the <em>Case</em>.</p>
                <p><code>localized_case__v &gt; local_awareness_date__v</code></p>
            </td>
        </tr>
            <tr>
            <td><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon6.png" alt="Reference Image 6" style="" /></td>
            <td><strong>Locked By Department</strong></td>
            <td>
                <p>Vault maps the <em>Department</em> value of the <em>Locked By</em> user on the <em>Case</em>.</p>
                <p><code>case_version__v.locked_by_department__v.name__v</code></p>
            </td>
        </tr>
           <tr>
            <td><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon7.png" alt="Reference Image 7" style="" /></td>
            <td><strong>Locked By User</strong></td>
            <td>
                <p>Vault maps the <em>Name</em> value of the <em>Locked By</em> user on the <em>Case</em>.</p>
                <p><code>case_version__v.locked_by_user__v.name__v</code></p>
            </td>
        </tr>
        <tr>
            <td><img class="inline" src="https://platform.veevavault.help/assets/images/saf-icon8.png" alt="Reference Image 8" style="" /></td>
            <td><strong>Report Type</strong></td>
            <td>
                <p>Vault maps the <em>Report Type</em> on the <em>Case</em>.</p>
                <p><code>case_version__v.report_type__v &gt; localized_controlled_vocabulary__v.name__v</code></p>
            </td>
        </tr>
    </tbody>
</table>

[1]: #create-workbench-report-set
[2]: #specify-workbench-report-set-filters
[3]: #filter-section-fields
[4]: #generate-run-workbench-tabulations
[5]: #table-generation-data-mapping
[6]: #inclusion-criteria-for-all
[7]: #report-study-type-inclusion-scenarios
[8]: #cumulative-tabulation-sae
[9]: #tabulation-sae-inclusion-criteria
[10]: #interval-line-listing-sar
[11]: #line-listing-sar-inclusion-criteria
[12]: #line-listing-sar-investigational-relatedness
[13]: #cumulative-tabulation-sar
[14]: #tabulation-sar-inclusion-criteria
[15]: #tabulation-sar-investigational-relatedness
[16]: #list-subjects-who-died
[17]: #list-subjects-inclusion-criteria
[18]: #death-occurred
[19]: #case-series-report
[20]: #open-cases-report
[21]: #open-cases-inclusion-criteria
[22]: #data-period-start
[23]: #datasheet-active-date
[24]: #aggregate-reporting-group
[25]: #sae-tab-count
[26]: #nupr-form-7-2
[27]: #j-psr-form-3
[28]: #j-psr-form-4