Interest Rate Template

Description Field name Char/Num Type sample 1 2 FHLBNY Assigned CustomerFHLBNY Sub-account Code Number CUST_NO SUBACCT Num Num 0009 01 3 FHLBNY Sub-type Code SUBTYPE Char RSMTG 4 FHLBNY Portfolio Code PRTFLCODE Num 0010* 5 Pledge Code PLEDGE Num 01 6 7 Data "As Of" Date Loan Number ASOFDATE LOANID Date Num 02282003 000000123456789 8 Note Type Code LOANTYPE Num 01 9 10 11 12 Current Loan Balance Paid Installment Date Last Maturity Date Balloon Flag CURBAL PTDATE MTDATE BALLOON Num Date Date Char 1000.00 02282003 02282003 N 13 14 Current P & I Payment Payment Type Code PANDI PAYTYPE Num Num 1000.00 2 15 Payment Frequency Indicator PAYFREQ Num 12 16 17 ARM / FRM Plan Code Hybrid ARM Plan Code RATETYPE HYARM Num Num 00 000 18 Current Interest Rate RATE Num 05.75 19 Interest Collection Code ICOLCODE Char 1 20 ARM Index Code INDEX Char 001 21 Lookback Days LOOKBK_DAYS Num 45 22 Sign for Negative Margin NEGAMSGN Char - 23 Gross Margin MARGIN Num 05.00 24 Periodic Interest Rate Cap PERCAP Num 02.00 25 Periodic Interest Rate Floor PERFLOOR Num 02.00 26 27 28 29 30 31 32 33 Periodic Payment Cap Interest Rate Ceiling Interest Rate Floor Rate Adjustment Frequency Interest Rate Change Date Change Teaser Flag Lifetime Lifetime Interest Payment Adjustment Frequency Next Payment Next ARM Date PAYCAP LIFECAP FLOOR RFREQ PFREQ NRADATE NPADATE TEASER Num Num Num Num Num Date Date Char 02.00 02.00 02.00 02 02 02282003 02282003 N * four digit field add leading * two digit field add leading zero's as required zero's as required * four digit field add leading zero's as required * two digit field add leading zero's as required * fifteen digit field add leading zero's as required * two digit field add leading zero's as required * two digit field add leading zero's as required * two digit field add leading zero's as * three digit field add required leading zero's as required All rates should be in number format with two decimal places * two digit field add leading zero's as required All rates should be in number format All rates should be in number All rates should be in number with two decimal format with two decimal format with two decimal places places places All rates should be in number format with two decimal places All rates should be in number format with two decimal places * two digit All rates should be field add in number format * two digit field add leading with two decimal leading zero's as zero's as required places required 34 35 36 37 38 39 40 First Rate Change Date Interest Rate at Next Reset Date Amortization Flag Negative Negative Amortization Cap Convertibility Code Flag Code ARM Participation Investor ARMCONVERT PARTFLAG INVSTR FRADATE NEXTRATE NEGAM NEGAMCAP Date Num Char Num Char Char Char 02282003 05.00 N 111.10 N N N 41 42 43 44 45 46 47 48 49 Percent of Loan Retained by Customer Participation Loan Balance P Participation Second Mortgage Code Jumbo / Subprime Flag Participation & I Payment Interest Rate Purpose Code Loan Documentation Level Custody Code Document PEROWNED_CHAR PARTBAL PPANDI PRATE SECOND LOANPURP JUMBO_SUB DOCULEV DOC_CUS_CODE Num Num Num Num Char Num Char Char Num 100.00 100.00 100.00 05.00 1 01 C F 01 50 51 52 53 54 Negative SignEscrow Balance Periodic Payment (PITI) for EscrowTotal Balance Servicer Code Servicer Rating ESCBALSGN ESCBAL TPANDI SERVICER SRATE Char Num Num Char Char 100.00 1000.00 1 55 56 57 58 Gross Service Fee Subservicing Fee Modification or Restriction Code Code Capitalization SFEE SUBSFEE MODRES CAPCODE Num Num Char Num 0.00 0.00 N 0 59 MI Insurer Code PMICODE Num 00 60 MI Percent PMIPER Num 00.00 61 Lender Paid MI LENDR_PDMI Num 07.25 62 63 64 65 MI Waived Flag of Months Currently times 30 days delinquent Number Number of Delinquent Delinquency History MIFLAG DELQ TIMES30 PAYHIST Char Num Num Char N 00 00 000000000000 66 67 68 69 70 71 Foreclosure Flag Flag PropertyOccupancy Code Bankruptcy FHLBNY Owner Type Code Name Project Property Street Number FCLOSR_FLAGSBPROPTYPE BNKRPT_FLAG OWNOCC PROJNAME ST_NUM Char Char Char Char Char Char N N SF P 1500-75 72 Property Street Name ST_NAME Char Main Avenue 73 74 Property City Property County Code CITY COUNTY Char Char New York 1 75 Property State Code STATE Char NY 76 Property Zip ZIP Char 08765 77 Property + 4 Zip ZIP_4 Char 0004 78 CMSA Code CMSA_CODE Char 00 79 MSA-PMSA Code MSA_PMSA Char 0000 All rates should be in number format with two decimal places All rates should be in number format with two decimal places * two digit field add leading zero's as required * two digit field add leading zero's as required All rates should be All rates should * two digit field add in number format be in number leading zero's as with two decimal format with two required places decimal places * two digit field add leading zero's as required * twelve digit field add leading zero's as required. See CAMS * two digit field add leading Mortgage Data zero's as required Format * five digit field add leading zero's as required * four digit field add leading zero's as required * two digit field add leading * four digit field add zero's as leading zero's as required required 80 Book BOOK Char 000000000000001 81 82 83 Page Year Built Unit Type PAGE YEAR_BUILT UNITTYPE Char Char Char 000000000000001 2003 A 84 Number of Units UNITS Num 013 85 Number of Units Sold UNITS_SOLD Num 000015 86 87 88 Current LTV Original LTV Appraised Value CLTV OLTV APPVAL Num Num Num 80.00 80.00 100.00 89 90 Appraised Value Date Purchase Price APPVALDATE PURPRICE Date Num 02282003 100.00 91 92 Date of Purchase Number of Tenants PURDATE TENANTS Date Num 02282003 0001 93 Current Occupancy Ratio OCCRATIO Num 01.00 94 95 96 Current Occupancy Ratio Date Occupy > 1/3 Space Single Tenant Total Square Footage OCCRDATE STOCC SQRFT Date Char Num 02282003 N 00000300 97 Total Acreage ACREAGE Num 00000300 98 Current DSCR CDSCR Num 01.00 99 100 Current DSCR Date Original DSCR CDSCRDATE ODSCR Date Num 02282003 01.00 101 102 Original DSCR Date Current NOI ODSCRDATE CNOI Date Num 02282003 1000.00 103 104 Current NOI Date Original NOI CNOIDATE ONOI Date Num 02282003 1000.00 105 106 107 108 Original NOI Date Current Revenue Current Revenue Date Subordinate Financing Flag ONOIDATE CREV CREVDATE SFINFLAG Date Num Date Char 02282003 1000.00 02282003 N 109 Total LTV TLTV Num 01.00 110 Total DSCR TDSCR Num 01.00 111 112 Total DSCR Date Prepayment Restriction Type TDSCRDATE PRE_RTYPE Date Char 02282003 N 113 114 115 116 117 118 119 120 Unlock Date Due on Sale Due on Encumbrance Groundlease RecourseRate of Amortization Mortgagor SPE Flag Mortgagor Last Name R AMOR_RATE SPE_FLAG L_NAME UNLOC_DATE DUESALE DUEENCUM GRND_LEASE ECOURSE Date Char Char Char Char Char Char Char 02282003 N N N N N N Johnson * fifteen digit field add leading zero's as required * fifteen digit field add leading zero's as required * three digit field * six digit field add add leading zero's leading zero's as as required required All rates should be in number format with two decimal places All rates should be in number format with two decimal places * four digit field add leading zero's as required All rates should be in number format with two decimal places * eight digit field add leading zero's as required * eight digit field add leading zero's as required All rates should be in number format with two decimal places All rates should be in number format with two decimal places All rates should be All rates should be in number format in number format with two decimal with two decimal places places 07/20/07 ID: COL-122 121 122 123 Mortgagor First Name MortgagorMortgagor Name Suffix Middle Name F_NAMEM_NAME SUFF_NAME Char Char Char Albert S. Sr. 125 126 127 128 129 Mailing Street Number Mailing City Mailing State Mailing Zip Mailing Street Name MST_NUM MST_NAMEMCITY MSTATE MZIP Char Char Char Char Char 22000 Main Avenue NY NY 01000 130 Mailing + 4 Zip MZIP_4 Char 1111 131 132 133 134 135 136 137 138 139 140 141 142 Mortgagor Self-employed Monthly Income Current Credit Score Mortgagor Flag Mortgagor's Mortgagor's Source of Current Credit Score of Current Credit Score Mortgagor's Date Mortgagor's Previous Credit ScoreMortgagor's Source of Previous Credit Date of Previous Credit Score 1Co-Mortgagor 1Name Suffix Mortgagor's Score Co-Mortgagor 1 LastCo-MortgagorName Co-Mortgagor First 1 Middle Name Name SELF_EMP INCOME MTG_CCSCOR SRC_CCSCOR CCSCORDATE MTG_PCSCOR SRC_PCSCOR PCSCORDATE C1_LNAME C1_FNAME C1_MNAME C1_SUFF_NAME Char Num Num Char Date Char Char Date Char Char Char Char N 1000.00 0650 01 02282003 0650 01 02282003 Johnson Albert Scott Jr. 187 188 189 190 Underwriting Ratio 1 nderwriting Ratio 2 oan Origination DateOriginal Loan Amount U L UWRATIO1 UWRATIO2 ORIGDATE ORIGBAL Num Num Date Num 000.00 000.00 02282003 1000.00 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 First Payment Date P & I Payment Term Original Interest Rate Original Original Original Index Value Principal Payment Frequency Indicator End of Draw Period HELOC Program DescriptionAmount Maximum Loan Customer Lien Sequence Indicator Original Loan Balance of Senior Lien of Senior Lien Current Loan Balance Amortization Period Begin Date Date Identification Number Next Payment Due Mortgage FPDATE OPANDI ORIGTERM ORATE OINDEX PPAYFREQ HELOCPD MAXLOAN DRAWDATE LIENINDIC OBALSLIEN CBALSLIEN AMOZDATE NPAYDATE MERS Date Num Num Num Num Num Char Num Date Char Num Num Date Num 02282003 1000.00 300 05.00 05.00 12 0001 1000.00 02282003 1 1000.00 1000.00 02282003 02282003 0000001234567891011 * five digit field add leading zero's as required * four digit field add leading zero's as required All rates should be in number format with two decimal places All rates should be in number format with two decimal places * two digit field add leading zero's as required * eighteen digit field add leading zero's as required