Clearwater Analytics Data Requirements Mortgage Loans

Clearwater Data Requirements – Mortgage Loans Please contact your Clearwater representative to answer any questions regarding these guidelines.

File Transmission Requirements Please download the Clearwater Data Transmission Requirements for details on transmission options

Data Requirements for Mortgage Loans The following table contains the full range of data fields used by Clearwater. The fields listed are critical to reconciliation and must be supplied before the data can be processed. All fields are requested and required field are notated. Please provide as much data as available to ensure accurate reporting. The left two tables comprise of the data needed on a daily basis, while the right table is data only needed at the time of implementation (Initial Load). Transactions Account Number *†‡ As of Date *†‡ Identifier *†‡ Security Type *†‡ Cancel/Rebook Indicator Counterparty ‡ Currency †‡ Current Units †‡ Description of Activity †‡ Entry/Trade Date †‡ Original Units †‡ Proceeds †‡ Reversed/Canceled Transaction ID Settle/Post Date †‡ Trade Price †‡ Transaction ID Transaction Type †‡

Holdings Account Number *†‡ As of Date *†‡ Identifier *†‡ Security Type *†‡ Accrual Day Count †‡ Accrued Interest Start Date †‡ Amortization Type ‡ Amount Of Loan Outstanding Average Interest Rate ‡ City ‡ Construction Loan Issues ‡ Construction Loan Out of Balance ‡ Convexity

Initial Load Account Number *†‡ As of Date *†‡ Identifier *†‡ Security Type *†‡ Accrual Day Count †‡ Accrued Interest Start Date †‡ Accrued Balance (dollars) as of Load Date ‡ Amortization Type ‡ Amount Of Loan Outstanding Average Interest Rate ‡ Book Value as of Load Date †‡ Cash Flow Schedule †‡ City ‡

Coupon Rate †‡ Credit Enhancement ‡ Currency †‡ Current Units †‡ Days Past Due ‡ Description †‡ Due and Unpaid Taxes ‡

Construction Loan Issues ‡ Construction Loan Out of Balance ‡ Counterparty ‡ Coupon Rate †‡ Credit Enhancement ‡ Currency †‡ Current Units as of Acquisition Date †‡

Duration Farm Loan sub Property Type ‡ Guaranteed ‡ Interest Past Due (By Days) ‡ Involuntary Reserve ‡

Current Units as of Load Date †‡ Days Past Due ‡ Description †‡ Due and Unpaid Taxes ‡ Factor/Paydown Schedule †‡

1

Transactions

Holdings Issue Date †‡ Issuer †‡ Land Loan ‡ Last Appraisal Date ‡ Last Quarter Property Value ‡ Last Restructure Date ‡ Legal Entity Identifier ‡ Market Price †‡ Market Value †‡ Market Yield Maturity Date †‡ Mortgage Status ‡ Mortgage Type ‡ Next Coupon Reset Date NOI 1 Year ‡ NOI 2 year ‡ NOI Current ‡ Original Amount of Loan ‡ Original Property Value ‡ Original Units †‡ Origination Date ‡ Payment Frequency †‡ Postal Code ‡ Property Type ‡ Senior Debt ‡ State ‡ Total Property Principal ‡ Type of Loan Value of Land and Buildings ‡

Initial Load Farm Loan sub Property Type ‡ Guaranteed ‡ Interest Past Due (By Days) ‡ Involuntary Reserve ‡ Issue Date †‡ Issuer †‡ Land Loan ‡ Last Appraisal Date ‡ Last Quarter Property Value ‡ Last Restructure Date ‡ Legal Entity Identifier ‡ Market Price as of Load Date †‡ Market Value as of Load Date †‡ Maturity Date †‡ Mortgage Status ‡ Mortgage Type ‡ Next Coupon Reset Date NOI 1 Year ‡ NOI 2 year ‡ NOI Current ‡ Original Amount of Loan ‡ Original Entry/Trade Date †‡ Original Proceeds on Trade †‡ Original Property Value ‡ Original Settle/Post Date †‡ Original Trade Price †‡ Original Units as of Acquisition Date †‡ Original Units as of Load Date †‡ Origination Date ‡ Payment Frequency †‡ Postal Code ‡ Property Type ‡ Senior Debt ‡ State ‡ Total Property Principal ‡ Type of Loan Value of Land and Buildings ‡

* Required for all files and should match between all files † Required for reporting ‡ Required for NAIC statements

2