Upload Replacement Securities to the EDITREPLACESEC Table

Upload Replacement Securities to the EDITREPLACESEC Table

The EDITREPLACESEC table defines replacement securities for UMA and SMA models. A new utility UPLOADREPLACESEC has been created to take an input file and load replacement securities to the EDITREPLACESEC table. The utility will update replacement security information only, not the original security nor replacement security percentage %.

The new UPLOADREPLACESEC utility can be run from the WHAT NEXT prompt or via batch. The function will prompt the user to enter the path and file name.

The input file should be available in the user's directory to process successfully. The file should be in CSV format and contain the following fields:

• Model type SMA or UMA
• Model code Can be up to 6 characters
• Original security TICKER symbol of the original security
• Replacement security TICKER symbol of the replacement security

For example:

The utility will generate a report called "REPLACESECLOG.PRT." The report will include a record count of the total records on file, a record count of what was and was not loaded, and the records that were loaded.