Texas Capital WarehouseNOW Sample eGuide

Manual Entry Field Name

Spreadsheet Field Name (not in column order)

Data Description

Allowed Values

Value Definition

Loan Terms Original Note Amount*

orig_upb* orig_rate*

New Loan Amount

xxxxxx.xx

Do not use $

Note Rate*

Interest Rate aka Note Rate

xx.xxx

Ex: 6.125% = 6.125

Term to Maturity*

original_term

Loan Term in months (i.e. 180 or 360)

Closing Date*

origination_date amortization_code

Date of the promissory note

mm/dd/yyyy

Amortization Code

Amortization type

AR BL FX IO

Adjustable Rate Mortgage Balloon Payment Mortgage

Fixed Rate Mortgage Interest Only Payment Mortgage Ex: 36.00% = 36.00 Home Equity/Cash-out Refinance

Debt Service Ratio

debt_service_ratio

Borrower's total debt-to-income ratio xx.xx

Purpose

purpose_code

HE

P R

Purchase Refinance Streamline

SR

Doc. Level

doc_level_code

Loan documentation level

A F R

Alternative Documentation

Full Documentation

Reduced Documentation Ex: 95% = 95.00 or 95 Ex: 95% = 95.00 or 95

Current LTV* Current CLTV* Property Type*

curr_ltv curr_cltv

Loan to Value

xx.xx xx.xx

Combined Loan to Value

property_type_code

CNDO COOP

Condo Co-op Duplex

DPLX FPLX MAN

Fourplex

Manufactured Single Family

SFR

TPLX

Triplex 1st Lien 2nd Lien

Lien*

lien_position

1 2

Occupancy Code*

occupancy_code*

OC NO

Owner-Occupied

Non-owner occupied

SH

Second Home

Investor Investor*

investor_code*

TCB code for client linked investors

Investor Codes Vary HOLD NOTE

Mandatory and Pools

pool_id

Pool ID

Pool ID # for pooled collateral

Commit Expiration*

inv_commit_expire_date Commitment expiration date

mm/dd/yyyy

89

10.01.2015 Version 4.0 – Client User Guide