This following contains example scenarios for isolating ARM loans for monitoring, analysis, or outreach purposes. Each scenario includes a sample Cortex Code input and the corresponding SQL example.
Scenario: ARM Loans by Origination Date
Use this scenario to identify adjustable-rate mortgage (ARM) loans originated within a specified time period, including key loan terms and rate adjustment details for additional context.
Cortex Code input:
Write an SQL query that returns ARM loans in [insert state here] where the lien contract date is between April 1, 2019 and today, the loan type is ARM, and the adjustable rate index is missing or null. Include loan details, rate information, and basic property characteristics, and sort results by contract date.
SQL example:
SELECT
address,
city,
property_type,
year_built,
bedrooms,
bathrooms_total,
hc_value_estimate,
lien1_loan_type,
lien1_contract_date,
lien1_amount,
lien1_loan_term,
lien1_interest_rate_used,
lien1_adjustable_rate_index,
lien1_adjustable_rate_change_date,
lien1_lender_type
FROM
XXX
WHERE
lien1_loan_type ILIKE 'ARM'
AND lien1_adjustable_rate_index IS NULL
AND lien1_contract_date >= '2019-04-01'
AND lien1_contract_date <= CURRENT_DATE
ORDER BY
lien1_contract_date;