This following contains example scenarios for targeting loans originated by specific lenders that may present refinance or outreach opportunities. Each scenario includes a sample Cortex Code input and the corresponding SQL example.
Scenario: Competitor Loan Targeting by Interest Rate
Use this scenario to identify loans originated by a specific lender where the interest rate is above a defined threshold, which may indicate refinance or competitive outreach opportunities.
Cortex Code input:
Write an SQL query that identifies loans in [insert state here] originated by [competitor name] where the interest rate is greater than 7%. Include loan details, property information, and borrower occupancy indicators, and sort results by highest interest rate.
SQL example:
SELECT
address,
city,
lien1_loan_type,
lien1_interest_rate_used,
lien1_loan_term,
lien1_amount,
lien1_contract_date,
lien1_lender_name,
property_type,
last_close_price,
deed_market_value_price,
owner_occupied_yn
FROM
XXXX
WHERE
lien1_lender_name ILIKE '%competitor name%'
AND lien1_interest_rate_used > 7.0
AND NOT lien1_interest_rate_used IS NULL
ORDER BY
lien1_interest_rate_used DESC;