About the Re-REMIC Database

The Re-REMIC Database captures the initial terms of all rated resecuritizations of CMBS. It excludes deals structured as collateralized debt obligations, which are detailed in the Real Estate CDO Database, a online compilation also maintained by Commercial Mortgage Alert.

Criteria for the Re-REMIC Database

Rated by at least one major agency.

Under the control of a trustee.

 

Creremic.xls Data Fields

CODE: The code is a unique, eight-digit number that can be used to link the different modules of the Re-REMIC Database. The first four digits represent the year and the next four represent a unique number (for example: 20010108).

ISSUER: The name of the issuing entity, exactly as it is shown on the prospectus.

SERIES: The series name of the offering, exactly as it is shown on the prospectus.

AMOUNT: The sum of the original face amount of all classes (in millions of dollars). For issues that aren't denominated in U.S. dollars, the amount shown is the dollar equivalent.

CLOSING: The closing date. This is usually the settlement date of the issue.

PRICING: The date when final pricing for all or most of the entire issue was completed.

SELLER: The party deemed to be the primary beneficiary of the transaction.

SBT: Seller/borrower type. A code that describes the party that was deemed to be the primary beneficiary of the transaction:

B

Bank/thrift

D

Developer/real estate firm

E

Investment group

F

Finance/mortgage company

G

Government entity

I

Insurer

P

Pension fund

R

RTC/FDIC

S

Securitization program

T

REIT

W

Investment bank

Y

Retailer

Z

Other

BOOKRNR1/BOOKRNR2: The broker-dealer that ran the books and coordinated distribution of the securities. If there are two joint bookrunners on a deal, the BOOKRNR2 field is also used. For two bookrunners to be listed, the prospectus cover must clearly state that specific underwriters are "joint bookrunners" or "co-bookrunners." If three or more firms are identified as bookrunners, only the first two firms will appear in the BOOKRNR1 and BOOKRNR2 fields.

TRUSTEE: The trustee hired to hold the bond collateral for the benefit of investors.

CERTADMIN: The certificate administrator.

COUNSELUW: The underwriter counsel.

COUNSELISS: The issuer counsel.

RM/RS/RF/RD/RO: An "x" in one of these fields indicates that some or all of the deal's classes were rated by Moody's, S&P, Fitch, DBRS/Duff or another agency.

OFF: Offering type, that is, the method of securities distribution:

A

Rule 144A

I

Outside U.S.

P

Private placement

S

SEC-registered

DENT: Country of denomination (blank if U.S.)

DENT/AMT: Amount in denomination (blank if U.S. dollars)

DIS: Region where distributed:

A

Asia (except Japan)

C

Canada

E

Europe

F

Africa

J

Japan

K

Australia

L

Latin America

M

Mideast

U

U.S.

FRQ: The frequency of interest and/or principal payments:

M

Monthly

Q

Quarterly

S

Semi-annual

#CERT: Total number of CMBS certificates in the collateral pool.

#DEAL: Total number of unique CMBS transactions represented in the collateral pool.

CRATE: The rate type of the collateral certificates:

A

Floating-rate

F

Fixed-rate

X

Mixed

NRATE: The rate type of the notes:

A

Floating-rate

F

Fixed-rate

X

Mixed

LOCATION: Identifies states/countries with at least 10% of the underlying real estate collateral.

REGION/COL: Region of collateral:

A

Asia (except Japan)

C

Canada

E

Europe

F

Africa

J

Japan

K

Australia

L

Latin America

M

Mideast

U

U.S.

COUNTRY/COL: Country where collateral is located.

CreremicCol.xls Data Fields

CODE: The code is a unique, eight-digit number that can be used to link together the different modules of the Re-REMIC Database. The first four digits represent the year and the next four represent a unique number (for example: 20010108).

PRICING: The date when final pricing for all or most of the entire issue was completed.

ISSUER: The name of the issuing entity, exactly as it is shown on the prospectus.

SERIES: The series name of the offering, exactly as it is shown on the prospectus.

AMOUNT: The sum of the original face amount of all classes (in millions of dollars). For issues that aren't denominated in U.S. dollars, the amount shown is the dollar equivalent.

COL_DEAL: CMBS offering included in the collateral pool.

COL_CLASS: Tranches contributed to the collateral pool.

COL_AMT: Portion of the tranche contributed to the collateral pool, in US dollars.

COL_CODE: The collateral's CMA Code.

 

CreremicPrice.xls Data Fields

CODE: The code is a unique, eight-digit number that can be used to link together the different modules of the Re-REMIC Database. The first four digits represent the year and the next four represent a unique number (for example: 20010108).

CLASS: The tranche identifier.

AMOUNT: The original face amount of the class (in millions of dollars). For classes that aren't denominated in U.S. dollars, the amount shown is the dollar equivalent.

NOTAMT: The notional amount of the class (in millions of dollars). For classes that aren't denominated in U.S. dollars, the amount shown is the dollar equivalent.

DEN: Country of denomination (blank if U.S.).

DEN/AMT: Amount in denomination (blank if U.S. dollars).

RATINGM: Initial rating assigned by Moody's.

RATINGS: Initial rating assigned by S&P.

RATINGF: Initial rating assigned by Fitch.

RATINGD: Initial rating assigned by DBRS.

SUB%: Percent subordination.

COUPON: Coupon rate -- the initial annual pay rate. For fixed-rate classes, the coupon is stated as a percentage. For floating-rate classes, it is the stated margin in basis points over a certain benchmark rate.

PRICE: Initial price per $100 of bonds.

CBE: Corporate bond equivalent yield, which allows investors to compare all fixed-income securities to corporate bonds, which pay interest semi-annually and are based on a 360-day year.

MATURE: The final rated maturity date for the class.

LIFE: The weighted average expected retirement date of each class of securities (in years).

SPREAD: The difference, in basis points, between the initial yield and a benchmark rate, usually Treasury securities or Libor.

BENCH: The benchmark rate used to price the notes.

RATE: Coupon rate structure on the securities:

A

Floating-rate

F

Fixed-rate

 

About the CMBS Database

The CMBS Database captures the initial terms of all rated securities collateralized by commercial and multi-family properties. It covers issues from the inception of the CMBS market in the mid-1980s through the end of the last week.

Click here to read more.