Search and Maintain Upload Files

Use the SI Scan (Model SI Scan) utilities to generate Excel reports based on existing model settlement instruction data. Modify these reports in Excel and then 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 SI Scan Upload Guide.

Creating and Updating Reports

You can create an export and update model instructions.

1. Generate reports using the SI Scan (Model SI Scan) utility.
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.

Validating a File

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 (you must use all capital letters).
   3. Existing—Select a category from the drop-down 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 results grid displays information about each upload file.

Results Grid Columns

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

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:

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: 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 dData 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 ALERT database, please try again: There was a problem connecting to the database.