Description Field name Char/Num Type sample
1 2 FHLBNY Assigned Customer Number FHLBNY Sub-account Code 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 Balloon Flag Last Maturity Date 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 ARM Plan Code Hybrid RATETYPE HYARM Num Num 00 000
18 19 20 Current Interest Rate Interest Collection Code ARM Index Code RATE ICOLCODE INDEX Num Char Char 05.75 1 001
21 Lookback Days LOOKBK_DAYS Num 45
22 23 Sign for Negative Margin Gross Margin NEGAMSGN MARGIN Char Num 05.00
24 Periodic Interest Rate Cap PERCAP Num 02.00
25 26 27 28 29 30 31 32 33 Periodic Interest Rate Floor Periodic Payment Cap Interest Rate Ceiling Interest Rate FloorRate Adjustment Frequency Interest Rate Change Date Change Teaser Flag Lifetime Lifetime Interest Payment Adjustment Frequency Next Payment ARM Date Next PERFLOOR PAYCAP LIFECAP FLOOR RFREQ PFREQ NRADATE NPADATE TEASER Num Num Num Num Num Num Date Date Char 02.00 02.00 02.00 02.00 02 02 02282003 02282003 N
* four digit field add * two digit field add leading leading zero's as required zero's as required
* two digit field add * four digit field add leading leading zero's as zero's as required 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 All rates should be in add leading * three digit field add number format with zero's as required leading zero's as required two decimal places
* two digit field add leading zero's as required
All rates should be in number format All rates should be in with two decimal number format with two places decimal places
All rates should be in number All rates should be in number format with format with two decimal two decimal 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 field add * two digit field leading add leading zero's as zero's as required required
34 35 36 37 38 39 40 First Rate Change Date at Next Reset Date Amortization Flag Interest Rate Negative Negative AmortizationARM Convertibility Code Flag Code Cap Participation Investor FRADATE NEXTRATE NEGAM NEGAMCAP ARMCONVERT PARTFLAG INVSTR 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 PParticipationSecond Mortgage Code Code / Subprime Flag Document Custody Code Participation & I Payment Interest Rate Purpose Loan Jumbo Documentation Level PEROWNED_CHAR PARTBAL PPANDI PRATE SECONDLOANPURP 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 Sign for Escrow Balance Escrow Balance Periodic Payment (PITI) Total Servicer CodeServicer Rating ESCBALSGN ESCBAL TPANDI SERVICER SRATE Char Num Num Char Char 100.00 1000.00 1
55 56 57 58 59 Gross Service Fee Subservicing Fee Modification or Restriction Code Capitalization Code MI Insurer Code SFEE SUBSFEE MODRES CAPCODE PMICODE Num Num Char Num Num 0.00 0.00 N 0 00
60 MI Percent PMIPER Num 00.00
61 62 63 64 65 Lender Paid MI MI Waived Flag of Months Currentlytimes 30 days delinquent Number Number of Delinquent Delinquency History LENDR_PDMI MIFLAGDELQ TIMES30 PAYHIST Num Char Num Num Char 07.25 N 00 00 000000000000
66 67 68 69 70 71 72 73 74 75 76 Foreclosure Flag Flag Property Type Code Property Street Number Property Street Name Property City Property County Code Property State Code Property Zip Bankruptcy FHLBNY Owner Occupancy Code Project Name FCLOSR_FLAG BNKRPT_FLAG OWNOCC PROJNAME SBPROPTYPE ST_NUM ST_NAME CITY COUNTY STATE ZIP Char Char Char Char Char Char Char Char Char Char Char N N SF P 1500-75 Main Avenue New York 1 NY 08765
77 78 79 Property + 4 Zip CMSA Code MSA-PMSA Code ZIP_4 CMSA_CODE MSA_PMSA Char Char Char 0004 00 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 * two digit field be in number add leading format with two zero's as required decimal places
All rates should be in number format with two decimal places
* two digit field add leading zero's as * two digit field add required leading zero's as required
* twelve digit field add leading zero's as required. See CAMS Mortgage Data Format
* five digit field add leading zero's as required
* four digit field add leading zero's as required
* two digit field add * four digit field leading zero's add leading zero's as required as 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 86 87 88 89 90 91 92 93 Number of Units Sold Current LTV Original LTV Appraised Value Appraised Value Date Purchase Price Date of Purchase Number of Tenants Current Occupancy Ratio UNITS_SOLD CLTV OLTV APPVAL APPVALDATE PURPRICE PURDATE TENANTS OCCRATIO Num Num Num Num Date Num Date Num Num 000015 80.00 80.00 100.00 02282003 100.00 02282003 0001 01.00
94 95 96 97 Current Occupancy Ratio Date Occupy > 1/3 Space Single Tenant Total Square Footage Total Acreage OCCRDATE STOCC SQRFT ACREAGE Date Char Num Num 02282003 N 00000300 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 SPE FlagMortgagor Last Name Mortgagor UNLOC_DATE DUESALE DUEENCUMGRND_LEASE RECOURSE AMOR_RATE SPE_FLAG L_NAME Date Char Char Char Char Char Char Char 02282003 N N N N N N Johnson
* fifteen digit field * fifteen digit field add leading zero's add leading zero's as required as required
* three digit field * six digit field add add leading leading zero's as zero's 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 All rates should be in leading zero's as number format with two required 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 in number format with two decimal places
All rates should be in number format with two decimal places
07/20/07
ID: COL-122
121 122 123 125 126 127 128 129 130 Mortgagor First Name Mortgagor Middle Name Suffix Mailing Street Number Mailing City Mailing StateMailing Zip Mailing + 4 Zip Mortgagor Name Mailing Street Name F_NAME M_NAMESUFF_NAME MST_NUM MST_NAME MCITY MSTATE MZIP MZIP_4 Char Char Char Char Char Char Char Char Char Albert S. Sr. 22000 Main Avenue NY NY 01000 1111
131 132 133 134 135 136 137 138 139 140 141 142 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 Mortgagor Self-employed Flag IncomeCurrent Credit Score Mortgagor Monthly Mortgagor's Mortgagor's Source of Current Credit Scoreof Current Credit Score Mortgagor's Date Mortgagor's Previous Credit Score Mortgagor's Source of Previous Credit Score Previous Co-Mortgagor 1 First Name 1 Name Suffix Underwriting Ratio Underwriting Ratio Loan Origination Date Mortgagor's DateCo-Mortgagor 1 Last NameCo-Mortgagor of Credit Score Co-Mortgagor 1 Middle 1 2 Original Loan AmountFirst Payment Date P & I Payment Term Original Interest Rate Original Original Original Index Value Principal Payment Frequency Indicator End of Draw Period HELOC Program Description Maximum Loan Amount Customer Lien Original Loan Balance of Senior Lien of Senior Lien Sequence Indicator Loan Balance Current Amortization PeriodPayment Due Date Identification Number Next Begin Date Mortgage SELF_EMP INCOME MTG_CCSCOR SRC_CCSCOR CCSCORDATE MTG_PCSCOR SRC_PCSCOR PCSCORDATE C1_LNAME C1_FNAME C1_SUFF_NAME C1_MNAME UWRATIO1 UWRATIO2 ORIGDATE ORIGBAL FPDATE OPANDI ORIGTERM ORATE OINDEX PPAYFREQ HELOCPD MAXLOAN DRAWDATE LIENINDIC OBALSLIEN CBALSLIEN AMOZDATE NPAYDATE MERS Char Num Num Char Date Char Char Date Char Char Char Char Num Num Date Num Date Num Num Num Num Num Char Num Date Char Num Num Date Num N 1000.00 0650 01 02282003 0650 01 02282003 Johnson Albert Scott Jr. 000.00 000.00 02282003 1000.00 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