cmbs_get_loans
Fetch one registered CMBS deal's loans, collateral, and latest performance.
Description
Fetch one registered CMBS deal's loans, collateral, and latest performance.
data.loans is in prospectus loan-ID order: numeric asset IDs sort
numerically, followed by occurrence sequence. Each loan includes origin
terms/indicators, filed-order properties with location, valuation,
occupancy, NOI/NCF, and DSCR, plus its latest available performance
period with balances, payment status, and servicing fields. Exact
decimals serialize as strings. Numeric objects carry unit, currency
where monetary, accession_number, and that document's as_of; loan,
property, and period records also carry their own accession/as-of lineage.
A resolvable property includes geography with geo_key, level,
name, resolution, state_geo_key, county_geo_key/county_name,
and cbsa_geo_key/cbsa_name. Resolution zip means an exact ZCTA
match; state means the ZIP was absent or unmatched and the filed state
supplied the fallback. The key is omitted when location evidence is
unresolved or ZIP and state conflict. The county is the ZCTA's dominant
county by Census land-area overlap, and its CBSA follows OMB delineation.
Use the pivot keys with other geography-aware tools—for example, take
cbsa_geo_key and call re_search_series(geo_key=...).
This is deliberately per-deal, not cross-deal search, and returns only
the latest period. Full history is future cmbs_get_loan_history work.
The default limit is 25 and maximum is 100. Pass next_cursor back
until has_more is false. Errors are bad_parameter for malformed
filters/cursors, unknown_entity for an unregistered deal (with up to
five suggestions), and out_of_coverage for a registered deal whose
EX-102 loans are not ingested. Filters with no matches succeed with an
empty list.
Example: cmbs_get_loans(deal="Benchmark 2020-B20 Mortgage Trust", property_type="OF", state="IL", limit=25).
Parameters
Input schema advertised to MCP clients and mirrored by the REST query string.
| Name | Type | Required | Default | Constraints | Description |
|---|---|---|---|---|---|
| deal | string | Yes | — | min length 1 | Exact registered trust name (case-insensitive) or all-digits CIK. Use cmbs_search_deals first when the exact deal identity is unknown. |
| property_type | string | null | No | null | min length 1 | Optional case-insensitive exact SEC propertyTypeCode on any collateral property. SEC codes: CH=cooperative housing, HC=healthcare, IN=industrial, LO=lodging, MF=multifamily, MH=mobile home park, MU=mixed use, OF=office, RT=retail, SE=securities, SS=self storage, WH=warehouse, ZZ=missing information, 98=other. |
| state | string | null | No | null | min length 2, max length 2 | Optional 2-letter state or territory code, matched against any collateral property (case-insensitive). When property_type is also set, both filters must match the same property. |
| payment_status | string | null | No | null | min length 1 | Optional case-insensitive exact latest-period SEC paymentStatusLoanCode: 0=current, 1=30–59 days delinquent, 2=60–89 days delinquent, 3=90+ days delinquent, 4=performing matured balloon, 5=non-performing matured balloon, A=not received but within grace or not yet due, B=late but under 30 days. |
| limit | integer | No | 25 | min 1, max 100 | Prospectus loan-ID-order rows per page (1–100). |
| cursor | string | null | No | null | — | Opaque pagination.next_cursor from the previous response; keep deal and filters constant while paging. |
Provenance
Sources behind every value this tool returns.
- sec-edgar-abs-ex102U.S. Securities and Exchange Commission (EDGAR)