| key |
id |
string* |
= |
composite key |
| link |
batch |
Batch* |
= |
The batch that provided the data |
| link |
batchRun |
BatchRun* |
= |
The batchRun that provided the data |
|
changeDatetime |
dateTime |
|
Last modification date and time of a physical row |
| link |
crePropertyId |
PropDetails |
= |
Unique identifier for the property |
|
lenderName |
string |
|
Mortgage lender that funded the loan and signed the mortgage documents |
|
mortgageAmount |
decimal |
|
Value of the mortgage supplied by the lender to the mortgagor |
| filter_list |
mortgageDate |
date |
=< >= |
Date on which the mortgage was issued |
|
mortgageId |
string |
|
S&P unique identifier for the mortgage |
|
mortgageInterestRate |
decimal |
|
Interest rate charged by the lender to the mortgagor |
|
mortgageLoanType |
string |
|
Mortgage loan type such as FHA, SBA or conventional |
| filter_list |
mortgageMaturityDate |
date |
=< >= |
Date on which the mortgage reaches maturity |
|
mortgageMaturityYear |
long |
|
Year in which the mortgage reaches maturity |
| filter_list |
mortgagePosition |
long |
= |
Mortgage Position |
|
mortgagePropCount |
long |
|
Number of properties to which the mortgage is associated |
|
mortgagePropValueAssessed |
long |
|
Aggregate assessed value of all properties to which the mortgage is associated |
|
mortgagePurpose |
string |
|
Purpose of the mortgage transaction. Examples include first mortgage, loan consolidation and cash out first mortgage. |
|
mortgageRateType |
string |
|
Type of interest rates applied to mortgage loans |
|
mortgageRecDate |
string |
|
Date on which the mortgage was recorded by the county or city |
|
mortgageSellerCarryback |
boolean |
|
Indicates the mortgage is a seller carryback |
|
mortgageType |
string |
|
Types of mortgages on properties such as purchase, refinance or junior |
|
privatePartyLoan |
boolean |
|
Indicates the lender is a private party |