Import an Inbox Item

Vault Safety can import XML files in E2B(R2) or (R3) format and from Intake API to create Inbox Items.

About Inbox Item E2B Import

When you create an Inbox Item from an E2B XML file, Vault Safety maps each E2B data element to populate the associated Vault Safety field. Because Inbox Items do not contain all Case fields, certain data does not appear until you promote the Inbox Item to a Case.

E2B Case Import Data Mapping describes how Vault Safety maps E2B data to a Case.

The following list outlines how you can import E2B files to create Inbox Items:

• Receive an E2B Transmission through an AS2 Gateway or Intake API
• Trigger the Create Inbox Item from Document action from an E2B document in the Vault library
  You can upload a single E2B file, a batch XML file (multi-E2B), or a ZIP file containing multiple E2B(R2) or (R3) compliant XML files.
  You can upload up to 1000 E2Bs in a multi-E2B and ZIP file.

Once you create an Inbox Item from an E2B file, the system generates a CSV rendition of this E2B file.

Prerequisites

Consider the following prerequisites for importing an Inbox Item from an E2B file:

• For Vaults originally deployed in 21R1 or earlier, your Admin must Enable E2B Import to Inbox Item.
• The XML document in E2B format or the ZIP file with multiple XML E2Bs must already be in the Vault Library and the system must be finished generating a viewable rendition of the document.
  The XML document or the ZIP file must be uploaded using the Case > Source > Adverse Event Report classification and be in the New state in order to import the Inbox Item.
  Adding Documents provides instructions on adding documents to the library.
• The system library must contain the appropriate Organization, Product, and Study records. Otherwise, the system cannot properly map information to these records.
• To automatically code MedDRA terms when the E2B file contains reported medical terms with no MedDRA code, your Vault must have an active Central MedDRA dictionary.
  • To use automation to code reported terms that aren’t an exact match to the MedDRA dictionary or your MedDRA Synonym List, your Admin must enable Smart MedDRA Coding
• Your Vault must have the Allow Attachments option enabled for the Case > Source > Adverse Event Report document type in the Admin area.

Import an E2B Inbox Item

1. Go to the document in the Vault Library.
   The Create Inbox Item action is only available for the latest document version. The user action does not appear for older versions.
2. Verify that the following document fields are populated:
   • Organization: (Required) Select the Organization that will process the Inbox Item and Case.
   • Receipt Date: (Optional) Select the receipt date. The system snapshots this field to the Inbox Item New Info Date. If you don’t specify this field, the system sets it to the current date, by default.
   • Report Type: (Optional) If not specified in the E2B data, select the report type. If you don’t specify this field, the system sets the Report Type to Spontaneous on the Inbox Item by default.
     The system uses the values in these fields to automatically populate the corresponding fields on the resulting Inbox Item and Case. If you don’t see the Receipt Date or Report Type fields, contact your Admin to add these fields.
3. Ensure the system has finished generating a viewable rendition of the document.
   About Auto-Generated Viewable Renditions provides more information about viewable renditions.
4. Once the viewable rendition is complete, expand the All Actions menu, and then select the Create Inbox Item icon ().

Result

The system imports the document to create an Inbox Item. Once created, the document Inbox Item field links to the Inbox Item.

The system also does the following:

• Adds a link to the Inbound Transmission.
• Generates a CSV rendition of the E2B source data.
• For multi-E2B files, links the single-Case documents in the parent XML file under the Relationship > Single-Case Document section and the parent XML file under the Relationship > Multi-Case Document section in each single-Case Vault Document.

Learn how Case intake and Case promotion consider Inbox Items with Combination Products.

Case Access Groups

When an Inbox Item is generated from an E2B file, the system populates the Case Access Group field on the document. The Case Access Group is inherited from the associated Inbox Item and is read-only.

To view the Case Access Group for a document, go to the Document Information pane, expand the Case Information section, and check the Case Access Group field.

Manage Automated Case Promotion for E2B Imported Inbox Items

You can enable automated Case promotion when you upload E2B documents, whether it’s a single file, multi-E2B file, or a ZIP file containing multiple E2Bs. On the right panel in the General section, you must specify the following fields:

• Enable Auto Promote: Yes
• Non-Serious Merge Method: Select a merge method for Non-Serious Cases.
• Serious Merge Method: Select a merge method for Serious Cases.

Import E2B Inbox Items from a Zip File

You can create Inbox Items from a ZIP file containing multiple E2Bs.
Go to the ZIP file in the Library, expand the All Actions menu, and select Create Inbox Item from Doc.

Result

The system imports each file individually as a document and creates an Inbox Item from each document.

The system also does the following:

• Adds a link on the documents to the associated Inbox Item and Inbound Transmission from the Inbox Item field and Inbound Transmission field, respectively.
• Generates a CSV rendition of the E2B source data for each document.
• Links the single-Case documents in the parent ZIP file under the Relationship > Single-Case Document section and the parent ZIP file under the Relationship > Multi-Case Document section in each single-Case Vault Document.

The system successfully processes the ZIP file if it is valid:

• Each E2B file cannot exceed 25 MB.
• The number of E2B files in the ZIP file cannot exceed 1000.
• Each E2B file must be an XML document.
• The ZIP file cannot contain multi-E2Bs.
• The E2B files must be in the root (top-level directory) of the ZIP file or must be in a root folder in the file.

If the ZIP file contains any non-E2B files, only the E2Bs will be imported and the system will log a warning for the non-E2B files.
If the system is unable to process the ZIP file, an error message will appear with the error details and the appropriate next steps. You can manually resolve the issues and upload the file again.

About the CSV Renditions of Imported E2B Files

The system generates a CSV rendition of the E2B file once you create an Inbox Item from this E2B. The rendition can be generated for E2B(R2) and (R3) files (for example, through manual upload, AS2 gateway, or API).

You can access the CSV file in two (2) ways:

• If the Sender-Based Inbound Validation feature is enabled, go to the respective Inbox Item’s Inbound Validation Result section.
• If the Sender-Based Inbound Validation feature is not enabled, go to the E2B document in the Library. Select the Document Files icon () on the right panel. The CSV rendition is available in the Attachments section.

The CSV file contains E2B source data in a readable format. The following is an example snippet of a CSV file:

Note the considerations for CSV renditions:

• Elements that do not exist in the ICH E2B(R2) or (R3) guidelines are not included in the file.
• Embedded files for E2B(R2) are not supported.
• If the CSV rendition fails to generate, the E2B file will also fail to import.
• When viewing the rendition using your web-browser, long blocks of text (for example, case narratives) are truncated to around one-third of the page. The complete text block will be available in the downloaded CSV file.

About Multi-Case Tabular Data Import

With the Safety Inbox Loader, there are two (2) import options using pre-defined mapping:

• Import a multi-Case CSV file to Inbox Item.
• Import a multi-CSV ZIP file to Inbox Item. You can also include tabular data files with a TXT extension within the ZIP as it follows the same convention as CSV.

Each multi-Case file can include up to 1,000 Cases.

This feature allows you to extract multiple Cases and child records from CSV files to create multiple Inbox Items at once using the Create Inbox Item action.

Prerequisites

Before you can use this feature, your Admin must:

• Enable Safety Inbox Loader Multi-Case Tabular Data Import
• Manage Safety Inbox Loader Multi-Case Tabular Data Import

Prepare a Multi-Case File

Before you can upload the file, the multi-Case CSV or ZIP file must meet certain criteria to pass system validation. Ensure the following have been met:

• No files are empty.
• Each CSV contains at least one (1) record (at least one row of Case data).
• Each CSV contains at least one (1) column that is mapped to a Case ID (either Worldwide UID (WWUID) or External System UID).
• Each CSV must be sorted by Case ID.
• The number of rows per CSV does not exceed 100,000.
• The number of Cases per multi-Case file does not exceed 1,000.
• Each file contains unique column headers (except for the Case ID and Record ID columns).
• The ZIP file does not contain more than 50 CSV files.
• The CSV file size is equal to or less than 100 MB.
• The ZIP file size is equal to or less than 50 MB.
• The file list separator is a comma, semicolon, or a pipe character ( | ).
• The file character encoding is UTF-8, EUC-KR, or ISO-8859-1 (VAERS only).
• The date is in one of the following formats:
  • yyyy-MM-dd'T'HH:mm:ss.SSSXXX
  • (VAERS) MM/dd/yyyy'T'HH:mm:ss.SSSXXX
  • (KAERS) yyyyMMdd'T'HH:mm:ss.SSSXXX

Additionally, the CSV file must conform to the Safety Case field properties. For example, text field values must adhere to the maximum number of characters. See Inbox Item Data Entry Validation for more information on field criteria.

Prepare a Multi-Case File for VAERS

In addition to the criteria in the previous section, a CSV file for VAERS symptoms must follow a given format:

The VAERS format allows up to five (5) symptoms per row. Subsequent symptoms should continue in a new row with the same VAERS ID.

The column names must also follow the SYMPTOM# and SYMPTOMVERSION# naming convention. For example, “SYMPTOM1” and “SYMPTOMVERSION1”. The system maps the VAERS data to Inbox Item records based on the naming convention. For example, SYMPTOM1 and SYMPTOM2 data are mapped to two (2) different records.

Create Inbox Items from a Multi-Case File

Once the CSV or ZIP file has been prepared, see Adding Documents to learn how to upload the file to your Vault. Ensure the document type is set to Case > Source > Adverse Event Report, and the Tabular Data Format field is populated.

After uploading the file, select the Create Inbox Item action. If any of the criteria in the previous section are not met, an error message appears and the document moves to the Error state. If uploading a ZIP file, the system unzips the file into individual CSV documents and performs validation on each.

Multi-Case File Import Validation

After running the Create Inbox Item action, the system validates the following:

• The files’ encoding matches the Tabular Data Format’s Encoding field value, if specified. If the encoding differs or is blank, the system defaults to UTF-8.
• If the Case Contact type is not specified, the system imports the Case Contact data to the Reporter object type.
• If the Country on the selected Tabular Data Format is specified, the system maps to the Event Country and Reporter Country fields on the Inbox Item. Otherwise, these fields are populated with the source file data based on the mapping.

The following system validation applies to ZIP file import:

• The selected Tabular Data Format must contain a source file mapping to the Case (case_version__v) object. Otherwise, the system does not import the Vault document and moves it to the Error state.
• If a CSV file is specified as a source file for the selected Tabular Data Format, it must exist in the ZIP file being imported. Otherwise, the system does not import the Vault document and moves it to the Error state.
• If CSV files are specified as source files for the selected Tabular Data Format, the system only validates these files during ZIP import and will ignore all other files present. If unspecified CSV files are present in the ZIP being imported, the system logs this as a Global Warning in the Import Log.

For more information on configuring Tabular Data Formats and Tabular Source Files, see Manage Safety Inbox Loader Multi-Case Tabular Data Import.

The system also detects any duplicate records (rows) for Case Products, Dosages, Indications, and Adverse Events for a given Case ID and keeps only one (1) copy.

Multi-Case File Import Mapping

If validation is successful, this action creates a Vault Document for each unique Case ID with the Case > Source > Adverse Event Report classification. When importing a ZIP file, if multiple column headers across different CSV files have the same record ID and are mapped to the same object and field, the system groups this data in the same record (if not duplicates). Similarly, the system groups parent and child record data together if the parent ID column header is mapped to the parent object and field as well as to the child object.

Next, for each single-Case document, the system creates an Inbox Item and imports the data to the Inbox Item fields based on the selected Tabular Data Format. Imported data includes standard fields and the following supported objects:

• Case
• Case Adverse Event
• Case Assessment
• Case Assessment Result
• Case Drug History
  This object is also supported for Cases of Parental Information object type.
• Case Drug History Substance
  This object is not supported for Cases of Parental Information object type.
• Case Medical History
  This object is also supported for Cases of Parental Information object type.
• Case Product
• Case Product Dosage
• Case Product Indication
• Case Product Substance
• Case Test Results
• Reporter Case Contact

The system ignores unsupported objects and fields. Download the list of fields that are not supported.

For more information on how to configure field import mapping from the tabular data to the Inbox Item, see Manage Safety Inbox Loader Multi-Case Tabular Data Import.

On the Inbox Item, the system sets the Intake Method to Import and the Intake Format to Tabular Data. You can use these fields to filter the Inbox Items and to create Inbox Views.

Upon import completion, the system attaches an import log to each multi-Case CSV source file and you receive a Vault notification and an email. The system also links the single-Case Vault Documents in the parent multi-Case files under the Relationship > Single-Case Document section and the parent multi-Case file under the Relationship > Multi-Case Document section in each single-Case Vault Document.

The Multi-Case Import Log

If your Admin allowed attachments for the Case > Source > Adverse Event Report document type, the system generates a multi-Case import log and attaches it to the CSV file after creating the Inbox Items. You can find this log in the Document Files section of the respective source multi-Case CSV file.

The report includes the status of the import:

• Success: All Cases were imported successfully.
• Import Errors: Not all Cases were imported successfully.
• Failure: No Cases were imported.

The report also includes the following warnings and errors:

Warning/Error	Description
Global Warnings	"Global" issues affect more than one Case record.
Global Errors	These scenarios include: Single-Case document creation failure. Single-Case Vault Document creation failure. Data extraction from the CSV file failure.
Single-Case Warnings	These scenarios include: When multiple values are specified for one Case field for the same Case ID. When the date format is not supported.
Single-Case Errors	If validation errors occur for a single Case, the import process continues for the other Cases. The system includes an error message in the import log for the Cases that failed to import.

About Inbox Item Intake API Import

For more information about Inbox Items received through the Intake API, see Access Imported Inbox Items from Intake API.

Imported MedDRA

If your Vault has an active MedDRA dictionary, the system auto-codes MedDRA terms when the imported file contains reported medical terms with no MedDRA code.

If your Admin has configured your Vault for Smart MedDRA Coding, MedDRA coding is enhanced through AI and automation. When enabled, the feature supports coding reported terms that are not an exact match to the active MedDRA dictionary or your MedDRA Synonym list. For example, Smart MedDRA Coding offers suggestions for misspelled terms, abbreviations, ambiguous information, multiple reported terms, and more. For more information, see Code MedDRA Terms.

Case MedDRA Version

When a Case is imported to an Inbox Item, the Case MedDRA Version is set by the Vault’s active MedDRA Version.

Import Non-Current MedDRA Terms

The centralized MedDRA dictionary supports auto-coding of non-current terms during E2B or API import. This capability exists for all MedDRA-supported languages except Japanese.

The tag is displayed when the E2B or API MedDRA Version is not in sync with the Case MedDRA Version or if the coded term is non-current.

When you import an E2B or API file that contains current terms from an older MedDRA Version (for example, 18.0) than the oldest MedDRA Version supported in MedDRA central, the system will attempt to code the term if it exists. The Imported Case will display a tag next to the coded term.

Local Inbox Item Import

Local Case import is available for Inbox Items imported from E2B and Intake API.

When a Case is imported to an Inbox Item, the system looks at the Localization. If the Localization Type is local, the system maps the localized data from the source to the corresponding localized Inbox Item fields.

Prerequisites

Your Admin must first enable local Case Import before you can use this feature.

Local Import MedDRA Autocode

Vault Safety can autocode the following fields upon import if the local Case is imported without a MedDRA code and is in a non-English MedDRA language:

• Products section: Indication
• Medical Events section: Event (Reported)

The system also snapshots an LLT English term to the English text field.

Upon Case promotion, the system maps the Inbox Item localized values to the Case and copies these values to the generated Localized Case.

Additional Resources

Upon local import, Inbox Item text fields can be translated to English using Amazon Translate. For more information, see:

• Perform Local Language to English Intake
• Enable the Auto-Translation Framework for Localized Intake and Case Submissions

If your Admin has selected the enable auto-set Inbox Item Localization by Reporter Country checkbox and the Inbox Item has a primary Reporter-type Case Contact, the Localization field on the Inbox Item is automatically set based on the Reporter Country. For more information, see the Inbox Item Field Reference.

Verify an Imported Inbox Item

Upon E2B or API import, Vault Safety automatically verifies the Inbox Item records and sections. Records and sections with no validation errors are marked as Verified.

If there are validation errors, you can manually update the Inbox Item and verify the records.

To verify the results of the import, view the Vault notification, and then verify the data on the Inbox Item.

Vault Notification

When an Inbox Item has been created from a document, the system provides the results of the import by logging a notification on the Home tab and sending an email.

If there are any issues mapping data from an E2B file, the notification includes a warning message explaining the affected E2B data element and value. For API import issues, the system also includes a warning message. If a mapping issue occurs, manually enter the information on the Inbox Item.

Verify an Inbox Item

To modify sections that the system has already verified, select Edit. Otherwise, complete the following steps to edit or manually verify sections:

1. Go to the Inbox Item that you want to verify.
2. After confirming the Inbox Item is a valid Case, select the Promote to Case action. If there is any invalid data, a window appears and lists the affected sections.
3. Navigate to each section to correct the invalid data. For the Case Contact, Product, and Event sections, the system displays the number of records with invalid data in the top right of the section.
4. Review and correct the field validation errors in the respective section or record. Use the following actions to correct and verify the data:
   • To edit a field or address suggestions, select Edit.
   • To remove a section, select Delete.
   • To mark a section as verified, select Verify.

You can enter additional data and add records while you verify the Inbox Item. Inbox Item Field Reference provides more information.

Import Suggestions

While importing Inbox Items, Vault Safety generates suggestions to assist with processing the Inbox Item.

The system clearly identifies suggestions with a lightbulb icon, along with their confidence level and rationale to make verification easy.

Vault Safety can generate the following suggestions:

• Drug Role for Case Products
• Rank for Case Products
• Event Country for Medical Events
• Priority
  See the Inbox Item Priority Auto-Calculation section below to learn more about how priority is suggested.

Inbox Item Priority Auto-Calculation

Cases should be processed in a timely manner based on their priority. When there is a high volume of Cases, it is crucial to determine Case priority quickly.

The system auto-calculates and suggests the priority for new Inbox Items based on the adverse event seriousness provided in the source data. The following table outlines how the system assigns priority:

Priority Level	Seriousness
P1	Results in Death Life Threatening
P2	Caused/Prolonged Hospitalization Disabling/Incapacitating Congenital Anomaly Birth Defect Other Medically Important Conditions
P3	Not Serious Seriousness information was not found

Edit an Inbox Item Priority

The user can verify the suggested priority while verifying the data in the Inbox Item. They can also change the priority.

1. In the Inbox tab, select the Inbox Item you want to verify, and then expand the Details section.
2. In the Priority field, select the dropdown menu, and then select the new priority for the Inbox Item.
   

Result

The Inbox Item is assigned a new priority.

The user can display Inbox Items with a higher priority by filtering for these items. See Filter and Sort Inbox Items for more information.

Import Source Data Pane

When an Inbox Item is imported from an E2B file or integration with an upstream system, the Source Data pane shows the field values mapped from the file:

The Source Data pane displays both short text and long text for structured data.

If any imported values map to inactive records, the values are displayed in the Source Data pane but are not populated in the corresponding Inbox Item field.