File Layouts

General Information

This page contains general information about the CTSLink/SecuritiesLink services and the file types you will find here, respectively. In addition to the general information files you will find several files which describe the layout and the field definitions of the data files found throughout the site, where applicable.

Downloading

The default behavior for any file on this site is to open when clicked on with the left mouse button. This means that clicking on a file name or icon will open that file in your browser or other software registered for that file type such as a .PDF file opening Acrobat Reader and a .XLS file opening Excel. To download a file rather than opening it, right click on the file and select "Save Target As" or "Save Link As" from the pop-up menu.

Zip Downloading is also available on our website. This feature allows the download of multiple files at a time to your system. To use this feature check mark any file using the small boxes next to the file type icons and click the Zip Download button. Note: If you select historical files for bulk downloading they will be placed in subdirectories on your individual PC/system hard drive using the naming convention /Ryyyymm.

File Descriptions - MBS

Short descriptions of each of the types of files available here are given below:

File Layouts - MBS

The following files contain the layouts for the various data files available on this service. These files detail the field names and their locations in the file.

BSI File Layout

BSI File - Code Translations

ECF/Series Level Collateral File Layout

ECF/Series Level External Collateral File Parser

Shelf File Layout

Shelf File Parser

ECF/Series/Shelf Collateral File - Code Translations

Factor File Layout

Trustee File Layout

Archived File Layouts

Liquidated Losses Layout

File Layouts - CMBS

The following file layouts are as set by the Commercial Real Estate Finance Council (CREFC).

CREFC Loan Periodic File Layout

CREFC Bond File Layout

CREFC Collateral File Layout

CREFC Property File Layout

CREFC Loan Set Up File Layout

File Types

The following types of files are in general usage on these sites. Your browser may effect how they respond when you click on them, however the expected response is described below.

Text files are viewable directly in your browser. If you want to save these reports to your local system use the file downloading instructions above.

Microsoft Excel spreadsheet files. Your browser should prompt you to save them to a local directory. This format is usually compatible with most systems and data can be imported easily.

Many of the documents on this site are in the Adobe Acrobat PDF format. Adobe provides a reader for multiple systems, which you can obtain for free at their site. Complete installation instructions may be found on the Adobe site.

CSV files are Text files that are provided in a "comma separated values" format. These files can be easily imported into most systems.

ZIP is a compressed file format widely supported on PC and UNIX platforms. If you do not have a ZIP decompression utility on your PC, contact us for help on where to find one.

Text files that are provided in a fixed width format. These files can be easily imported into most systems.