Standard Uploads

You can upload the following data to ALERT:

  • Model information, including market-specific settlement instructions
  • Account-specific settlement instructions

Use the SI Scan (Model SI Scan) and Data Search (Model SI Data) utilities to generate Excel reports based on existing model settlement instruction data. Modify these reports in Excel, and upload the updated model settlement information on this page.

As you upload changed data and submit it to the database, ALERT validates it against a set of validation rules. After a successful data upload, the system generates alerts notifying the appropriate parties about the changes.

For full details on filling out the templates and for information about validation, see the ALERT Plus Guide for Global and Regional Custodians.

Creating Reports and Filling out the Templates

You can generate updates reports using the scan and data search utilities, then modify the data in these reports and upload to ALERT.

To create reports:

  1. Use the following scans to generate upload files:
    1. Account SI Scan
    2. Model SI Scan
  2. Update the data you want to change. Enter the PSET BIC, avoiding use of ISO country codes.

  3. Change the value in the Action column to U.

    Caution
    Do not delete columns, remove headers, or modify the RefID or Status columns

Uploading Data from the Completed Templates

Prior to uploading a file, validate its contents.

  1. Click Upload New File.
  2. Enter a file name in the File Name field or browse to the upload file.

  3. Select the type of data to upload from the Data type drop-down list.

    The data types available for selection are based on your upload permissions.

  4. Select a Category:
    1. None
    2. New: Enter a textual category description using capital letters.
    3. Existing: Select a category from the dropdown list.

  5. Click Validate.

    ALERT validates the file format and performs a rules (business, syntax, and semantics) validation. The upload file appears in the Items in Queue list. The Status column indicates whether the file passed the format and rules validation.

Reviewing Uploads

The columns in the results grid display information about the each upload file.

Table 1  Results Grid Columns
Column Name Description
Upload ID An ALERT-generated processing ID.
Status The ALERT file processing status. All items that are Failed/Partial (in red) require further action from your institution.
File name Contains links to copies of the original upload files.
Data Type

The type of data in the upload file, which can include:

  • Model Settlement Instructions
  • Account Settlement Instructions
Date/Time Submitted The date/time of file submission for validation.
Date/Time Created The in date/time when ALERT accepted (created) the file and put it in the queue pending validation.
Validation/Submission Errors Contains links to error files. These files contain a copy of the original upload file that includes original data submitted, as well as validation errors for each failing row.
User ID The User ID (ALERT user name) that initiated the upload.
Category The name of the file upload category, or None if there was no associated category.

Filtering the List

ALERT displays 300 rows of data in the upload grid. Select a filter to view specific upload files. The available filters include:

Table 2  Filtering the List
All Displays all upload files.
Pending Displays pending upload files. If the status is Validating, data validation is in process. If the status is Submitting, the file is currently uploading. Click the link in the File Name column to open a copy of the original file.
Complete Displays files that successfully uploaded. Click the link in the File Name column to open a copy of the original file.
Failed/Partial

Displays files that did not upload successfully, or ones that only partially uploaded. Click the respective links in the Validation Upload Errors column to open a copy of the original file and the error file.

The Status column indicates the nature of the problems encountered::

  • Validated with Errors, Ready to Submit: The validation is complete, but includes errors.
  • Validation Complete, Ready to Submit: The validation is complete and there are no errors. ALERT is awaiting user action before uploading the file.
  • Submission Pending Data Authentication: The submitted upload file is in the Data Authentication queue and is pending Data Authentication.
  • Failed/Partial, Submitted with Errors: The upload/submit process of a file with errors is complete.
  • Failed, Rejected during Data Authentication: The data approver and/or authorizer rejected the data. After viewing rejected data, upload a new file with the appropriate corrections.
  • Failed to connect to Omgeo database, please try again: There was a problem connecting to the database.