Created
April 28, 2015 13:10
-
-
Save hvillero/c64dd02a8b6f59f97d15 to your computer and use it in GitHub Desktop.
Finished in 8 minutes 51 seconds (files took 42.82 seconds to load) 937 examples, 71 failures, 1 pending
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Failures: | |
| 1) LoansController (while signed in) show action Loan Level Assumptions validates load loan property units (count) and cash_flow_analysis income line items | |
| Failure/Error: expect((value['value'].to_f / @loan_property_units).round(2)).to eq(value['per_unit'].to_f.round(2)) | |
| expected: 0.0 | |
| got: 44001387.67 | |
| (compared using ==) | |
| # ./spec/controllers/loans_controller_spec.rb:197:in `(root)' | |
| # ./spec/controllers/loans_controller_spec.rb:195:in `(root)' | |
| # ./spec/controllers/loans_controller_spec.rb:193:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 2) LoansController (while signed in) show action Loan Level Assumptions validates cash_flow_analysis expenses lines | |
| Failure/Error: expect((value['value'].to_f / @loan_property_units).round(2)).to eq(value['per_unit'].to_f.round(2)) | |
| expected: 0.0 | |
| got: 4861774.04 | |
| (compared using ==) | |
| # ./spec/controllers/loans_controller_spec.rb:212:in `(root)' | |
| # ./spec/controllers/loans_controller_spec.rb:210:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 3) LoansController (while signed in) show action Loan Level Assumptions validates cash_flow_analysis capilat lines | |
| Failure/Error: expect((value['value'].to_f / @loan_property_units).round(2)).to eq(value['per_unit'].to_f.round(2)) | |
| expected: 0.0 | |
| got: 586501.0 | |
| (compared using ==) | |
| # ./spec/controllers/loans_controller_spec.rb:226:in `(root)' | |
| # ./spec/controllers/loans_controller_spec.rb:224:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 4) LoansController (while signed in) show action loan info sub-window successfully calculates Balance at Maturity/Unit | |
| Failure/Error: expect(response.body).to have_content('$138,533') | |
| expected to find text "$138,533" in "TraderTool :: Loan Detail BACM 2007-3 Presidential Towers inbox (24) About Help First40 Last40 Logout Change Password Previous Exports Close About Fairview Trader Tool Ver. 20141112_pre_search_grouping Last update April 27 2015 Application optimized for Google Chrome Best viewed in a 1920 x 1080 or higher resolution. SCRUBBED, VERIFIED, AND RE-UNDERWRITTEN CMBS LOANS, BACKED BY 50+ COMMERCIAL REAL ESTATE EXPERTS AT YOUR BECK AND CALL. CMBS.com, Inc. is the provider of the CMBS Data www.fairviewres.com Close Help For assistance, please contact Fairview Real Estate Solutions CEO, Ron Rossi, at: rrossi@fairviewres.com or 1.800.786.9365. overview deal strats loan strats loans export Close Export Presets All Bloomberg Basic Trepp New Category Bloomberg Loan Periodic Note Securitization Trepp Fields Select All % ASER Recaptured ASER Applied To ASER Computation Method ASER Recovery ActualPaymentDate Advn Collateral Id CumulativeASERAmount CumulativeAccruedUnpaidAdvanceInterest CurrentEndingScheduledBalance Cut Off Date Deal Name (Trepp) Deal Name (Bloomberg) Deal Name Default Anchor Date Default Lag Default Loss Severity Default Months To Recover Default Rate (Trepp) Default Rate (Bloomberg) Default Rec Fee Default Servicer Advances Default Severity Default Timing Default Type Default When FV_ReconciledValueBase Loan Name Loan Number LoanStatus MaturityDate Note Date OtherExpenseAdvanceOutstanding Override Type PostUWColorCD_F PreUWColorCD_F ProjectedLoss ProjectedSeverityPct ProjectedSeverityPctOfDeal Prospectus Loan ID ReconciledValue TotalPIAdvanceOutstanding TotalReserveBalance TrendingColorCD_F Trepp Loan ID Trustee Loan Id (Trepp) Trustee Loan Id (Bloomberg) UPBCurrent Export Preset Name Save Save Export Exporting... Close Message Successfully exported. We're sorry, but the item failed to be exported. Loan Info Loan Comments Close Add to Portfolio Customers Create a new Portfolio Portfolios Add to Portfolio Saving... Please Select a Portfolio Close Message Item has been successfully added. We're sorry, but the item failed to be added. Presidential Towers ... Save To Portfolio Trustee ID 10072492 UW/Trend Colors Prospectus ID 1 Projected Loss ($) / Severity $0 / 0.00% Original UPB $325,000,000 Projected Loss Timing -- Current UPB $325,000,000 Current Loan Status Perform Additional Debt Amount $0 Crossed Loan Group Whole Loan Balance $325,000,000 % of Trust 12.86% Total Reserves $87,992 Current Interest Rate 5.39% Realized Loss to Date $0 Scheduled P&I $1,483,709 Call Protection Paid Through Date 04/01/2015 Hyper-AM Flag No Loan Term 120 Hyper-AM Date Amort/Interest Only / 120 Default, Payoffs, Advances Maturity Date 05/01/2017 Balance at Maturity $325,000,000 Balance at Maturity/Unit -- Loan/Property Info The original funding amount was $325.0M with 120 month IO loan, maturing on 5/1/2017. The Presidential Towers is a 2,346 unit high-rise apartment complex consisting of four interconnected 50-story buildings built between 1983 and 1986. Property is located in the CBD of Chicago, IL. Unit mix includes 782 studio units, 1,380 1BR/1BA and 184 2BR/2BA. Physical occupancy of 94% as of 2Q13. The loan is current and not on the Watchlist. Color Trend UW recommends that this deal loan status color remain GREEN. UW also recommends consideration for refinancing. Projected Loss None Value and Coverage Ratios Base Case Income Value is $628.1M ($267,713/unit) using 2013 Income and Expenses + 3% and 4.75% cap rate. Stated Value was not utilized as the Income value and loan coverages reflect sufficient value for no loss. Reconciled Value of $628.1M ($267,713/unit) based on the Income Value. LTV of 51.8%, DSCR of 1.68x and Debt Yield of 9.18%. Cash Flows NCF for the property has ranged from $21.0M in 2011 to $30.8M in 2013, trending upwards in past three years. Property has performed well in past two years with DSCR above 1.54x. Property Info # of Properties 0 Address City, State, Zip , Type Subtype - MSA Units Unit of Measure Year Built Year Renovated N/A Current Occupancy Occupancy Date Allocated Loan Amount Allocated Loan Amount % Property List Valuation Fairview Client DIRECT CAP VALUE NOI Value NCF Value NOI $30,419,054 $30,419,054 NCF $29,832,554 $29,832,554 Cap Rate 4.75% 4.75% Inc. Producing value $628,053,771 $628,053,771 Value/Unit $628,053,771 $628,053,771 VALUE PER UNIT MEASURE Value/Unit $628,053,771 $628,053,771 Unit Type Value $628,053,771 $628,053,771 Implied Cap Rate 4.75% 4.75% RECONCILED VALUE Reconciled Value $628,053,771 $628,053,771 Value/Unit $628,053,771 $628,053,771 Implied Cap Rate 4.75% 4.75% LTV 51.75% 51.75% APPRAISED VALUE Most Recent Appraised Value $500,000,000 Most Recent Appraised Value/Unit $213,129 Most Recent Appraisal Date 03/14/2007 Most Recent Appraisal LTV 65.00% Appraisal Value at Origination $500,000,000 Appraisal Value/Unit at Origination $213,129 Appraisal Date at Origination 03/14/2007 Appraisal LTV at Origination 65.00% Assumptions Assumptions Reconciled Value FV Base $628,053,771 New Save Run //<![CDATA[ var active_loan_level_assumption = false; //]]> var before_get_out = function(){ if(window.unsaved_assumptions && window.unsaved_assumptions.length > 0){ return 'You have unsaved Assumptions. Would you like to save these before leaving the page?'; } }; // popup window prompting user to save or abandon unsaved assumptions $(document).ready(function(){ $(window).bind('beforeunload', before_get_out); }); Cash Flow Analysis Category 2011 Annual $/Unit 2012 Annual $/Unit 2013 Annual $/Unit 2014 Annual $/Unit Fairview UW $/Unit Client UW $/Unit Variance Occupancy - 94.0% 93.0% 93.0% - - Income Contract Rent $36,206,477 - $41,062,735 - $41,306,793 - $46,416,410 - $44,001,387 - $44,001,387 - 0% Vacancy and Credit Loss -$3,710,160 - -$2,874,638 - $0 - -$2,907,450 - -$3,131,799 - -$3,131,799 - 0% Parking Income $2,730,495 - $2,858,294 - $3,007,770 - $3,210,499 - $3,013,175 - $3,013,175 - 0% Laundry Income $317,492 - $395,490 - $0 - $400,065 - $397,171 - $397,171 - 0% Other Income $2,100,886 - $2,501,056 - $3,741,933 - $3,735,134 - $2,960,803 - $2,960,803 - 0% Effective Gross Income $37,645,190 - $43,942,937 - $48,056,496 - $50,854,658 - $47,240,736 - $47,240,736 - 0% Expenses Payroll and Benefits $4,233,637 - $4,442,168 - $4,846,484 - $4,788,913 - $4,861,773 - $4,861,773 - 0% Advertising and Marketing $684,562 - $647,412 - $672,035 - $981,803 - $684,906 - $684,906 - 0% General & Administrative $1,486,466 - $1,497,136 - $609,156 - $1,493,980 - $1,450,765 - $1,450,765 - 0% Management Fee $1,882,260 - $2,197,147 - $1,441,695 - $1,525,640 - $1,889,629 - $1,889,629 - 0% Professional Legal $311,858 - $99,087 - $0 - $37,569 - $52,211 - $52,211 - 0% Real Estate Taxes $2,146,593 - $1,865,801 - $1,735,564 - $4,397,831 - $2,009,348 - $2,009,348 - 0% Repairs and Maintenance $2,033,568 - $2,142,449 - $7,693,858 - $2,063,114 - $2,164,055 - $2,164,055 - 0% Utilities $3,015,149 - $2,723,569 - $0 - $3,817,662 - $3,104,899 - $3,104,899 - 0% Insurance $310,936 - $387,584 - $586,500 - $586,500 - $604,095 - $604,095 - 0% Total Operating Expenses $16,105,029 - $16,002,353 - $17,585,292 - $19,693,012 - $16,821,682 - $16,821,682 - 0% Net Operating Income $21,540,161 - $27,940,584 - $30,471,204 - $31,161,646 - $30,419,054 - $30,419,054 - 0% Capital Capital Items $527,850 - $527,850 - $527,850 - $527,850 - $586,500 - $586,500 - 0% Net Cash Flow $21,012,311 - $27,412,734 - $29,943,354 - $30,633,796 - $29,832,554 - $29,832,554 - 0% NOI DSCR 1.21x 1.57x 1.71x 1.75x 1.71x 1.71x NCF DSCR 1.18x 1.54x 1.68x 1.72x 1.68x 1.68x NOI Debt Yield 6.63% 8.60% 9.38% 9.59% 9.36% 9.36% NCF Debt Yield 6.47% 8.43% 9.21% 9.43% 9.18% 9.18% $('body').on('click','td *',function(){ //console.log($(this).get(0).nodeName + '.'+ $(this).attr('class') + 'was clicked'); var expanded_spans = $('.treegrid-expander.treegrid-expander-expanded'), collapsed_spans = $('.treegrid-expander.treegrid-expander-collasped'); if(expanded_spans.length > 0 && $(this).parents('.sticky_table').hasClass('tree-collapsed')) { $(this).parents('.sticky_table').toggleClass('tree-collapsed treegrid-expanded'); } else if(expanded_spans.length === 0 && $(this).parents('.sticky_table').hasClass('tree-expanded')) { $(this).parents('.sticky_table').toggleClass('tree-collapsed treegrid-expanded'); } }); $(document).foundation(); (function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= '//www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-P9TJXS');" | |
| # ./spec/controllers/loans_controller_spec.rb:257:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 5) LoansController (while signed in) on property_info action successfully visits the page with out portfolio_id | |
| Failure/Error: get :property_info, dwidSecuritization: dim_securitization.dwidSecuritization, dwidNote: dim_note.dwidNote, dwidProperty: property_id | |
| ActionView::Template::Error: | |
| undefined method `[]' for nil:NilClass | |
| # ./app/views/loans/_property_info_rows.html.erb:4:in `_app_views_loans__property_info_rows_html_erb___1122110800_67670' | |
| # ./app/controllers/loans_controller.rb:353:in `property_info' | |
| # ./app/controllers/loans_controller.rb:352:in `property_info' | |
| # ./spec/controllers/loans_controller_spec.rb:428:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 6) LoansController (while signed in) on property_info action successfully visits the page with portfolio_id | |
| Failure/Error: get :property_info, dwidSecuritization: dim_securitization.dwidSecuritization, portfolio_id: portfolio.id, dwidNote: dim_note.dwidNote, dwidProperty: property_id | |
| ActionView::Template::Error: | |
| undefined method `[]' for nil:NilClass | |
| # ./app/views/loans/_property_info_rows.html.erb:4:in `_app_views_loans__property_info_rows_html_erb___1122110800_67670' | |
| # ./app/controllers/loans_controller.rb:353:in `property_info' | |
| # ./app/controllers/loans_controller.rb:352:in `property_info' | |
| # ./spec/controllers/loans_controller_spec.rb:434:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 7) SearchController search for SecuritizationName assigns search data | |
| Failure/Error: expect(@assigns['search_data'].first['SecuritizationName']).to eq(@securitization_name) | |
| NoMethodError: | |
| undefined method `[]' for nil:NilClass | |
| # ./spec/controllers/search_controller_spec.rb:55:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 8) SearchController search for SecuritizationName assigns search totals | |
| Failure/Error: expect(@assigns['search_totals']).to have_key('property_count') | |
| expected #has_key?("property_count") to return true, got false | |
| # ./spec/controllers/search_controller_spec.rb:68:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 9) SearchController search for NoteName assigns search data | |
| Failure/Error: expect(@assigns['search_data'].first['NoteName']).to eq(@loan_name) | |
| NoMethodError: | |
| undefined method `[]' for nil:NilClass | |
| # ./spec/controllers/search_controller_spec.rb:87:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 10) portfolio modal allows a user to add a new portfolio | |
| Failure/Error: find(".new-portfolio-input-container input").set "test portfolio" | |
| Capybara::ElementNotFound: | |
| Unable to find css ".new-portfolio-input-container input" | |
| # ./spec/features/portfolio_modal_spec.rb:54:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 11) Elasticsearchable search cache DimSecuritization SecuritizationName matches | |
| Failure/Error: expect(es_result).to eq(ar_result) | |
| expected: ["1166 AOTA 2002-1166", "1166 AOTA 2002-C5", "1166 AOTA 2005-C6", "1211AOTA 2000-1211", "1251 Ave 1999-XL1251", "1301 AOTA 2000-1301", "1345 AOTA & PAP FB 2005-1", "1345 AOTA 2000-XL", "1345 FUNDING LLC", "277 Park 1997-C1", "280 Park Ave Trust 2001-XL280", "2GCT 2000 RIG1", "767 Fifth Avenue 2003-C6", "ACMF 1997-C1", "ACR 2013-FL1", "ACR 2014-FL2", "ACRE 2010-ARTA", "ACT 2005-RR", "AETNA 1995-C5", "AFLF 1999-A", "ALLIED 1998-1", "AMC-AMC", "AMRESCO 1997-C1", "AMRESCO SBA 1999-1", "AMSI 2000-2 <ABS>", "ANTHRACITE 2002-2", "ARCap 2003-1", "ARCap 2004-1", "ARCap 2004-RR3", "ARCap 2005-1", "ARCap 2005-RR5", "ARCap 2006-RR7", "ASC 1995-MD4", "ASC 1996-D2", "ASC 1996-MD6", "ASC 1997-MD7", "ASFS 1993-2", "ASFS 1994-C2", "ASFS 1995-C1", "AVM 1998-1", "AVMT 2013-AVM", "Allied Remic 2004", "American Southwest financial 1994-C2", "American Tower Trust 2007-1", "Annapolis Mall 2000-C1B", "Anteros ELOC-6", "Anthracite 2004-HY1", "Anthracite CDO II 2002-WGL1", "Anthracite CDO III 2004", "Artesia 1998-C1", "BACM 2000-1", "BACM 2000-2", "BACM 2001-1", "BACM 2001-PB1", "BACM 2002-2", "BACM 2002-2 (trust-only)", "BACM 2002-PB2", "BACM 2003-1", "BACM 2003-1 (trust-only)", "BACM 2003-2", "BACM 2004-1", "BACM 2004-2", "BACM 2004-3", "BACM 2004-4", "BACM 2004-5", "BACM 2004-6", "BACM 2004-BBA4", "BACM 2005-1", "BACM 2005-2", "BACM 2005-3", "BACM 2005-4", "BACM 2005-5", "BACM 2005-6", "BACM 2006-1", "BACM 2006-2", "BACM 2006-277 Park Avenue", "BACM 2006-3", "BACM 2006-4", "BACM 2006-5", "BACM 2006-6", "BACM 2007-1", "BACM 2007-2", "BACM 2007-3", "BACM 2007-4", "BACM 2007-5", "BACM 2008-1", "BACM 2008-LS1", "BALL 2001-1166", "BALL 2001-7WTC", "BALL 2001-FM", "BALL 2002-FLT1", "BALL 2002-FLT2", "BALL 2003-BBA2", "BALL 2004-BBA4", "BALL 2005-BBA6", "BALL 2005-BOCA", "BALL 2005-ESH", "BALL 2005-MIB1", "BALL 2006-BIX1", "BALL 2006-LAQ", "BALL 2007-BMB1", "BALL 2009-FDG", "BAMLL 2011-FSHN", "BAMLL 2012-CLRN", "BAMLL 2012-OSI", "BAMLL 2012-PARK", "BAMLL 2013-DSMZ", "BAMLL 2013-DSNY", "BAMLL 2013-WBRK", "BAMLL 2014-520M", "BAMLL 2014-ICTS", "BAMLL 2014-IP", "BARS 2010-SBA1", "BASNI 2003-RT", "BASNI 2003-RT (trust-only)", "BASST 2002-X1", "BAYC 2006-3A", "BAYC 2006-SP1", "BAYC 2007-5A", "BAYC 2007-6A", "BAYC 2007-CD1A", "BBCMS 2013-TYSN", "BBCMS 2014-BXO", "BBUBS 2012-SHOW", "BBUBS 2012-TFT", "BH Finance LLC 2000 A Pools V-IX", "BH Trust 2001-A Pools I & II", "BHMS 2014-ATLS", "BHMS 2014-MZ", "BKBCMT 1997-C1", "BLCP 2014-CLRN", "BLX Funding Trust I", "BOA FUNB 2001-3", "BSCMS 1999-CLF1", "BSCMS 1999-WYN1", "BSCMS 2000-LCON", "BSCMS 2000-WF1", "BSCMS 2000-WF2", "BSCMS 2001-EPR", "BSCMS 2001-TOP2", "BSCMS 2001-TOP4", "BSCMS 2001-W1", "BSCMS 2002-FL1", "BSCMS 2002-HOME", "BSCMS 2002-PBW1", "BSCMS 2002-TOP6", "BSCMS 2002-TOP8", "BSCMS 2003-BBA1", "BSCMS 2003-GMZ1", "BSCMS 2003-PWR2", "BSCMS 2003-PWR2 (trust-only)", "BSCMS 2003-TOP10", "BSCMS 2003-TOP12", "BSCMS 2003-WEST", "BSCMS 2003-WEST (trust-only)", "BSCMS 2004-BBA3", "BSCMS 2004-BBA5", "BSCMS 2004-ESA", "BSCMS 2004-HS2", "BSCMS 2004-PWR4", "BSCMS 2004-PWR5", "BSCMS 2004-PWR6", "BSCMS 2004-TOP14", "BSCMS 2004-TOP16", "BSCMS 2005-LXR1", "BSCMS 2005-PWR10", "BSCMS 2005-PWR7", "BSCMS 2005-PWR8", "BSCMS 2005-PWR9", "BSCMS 2005-TOP20", "BSCMS 2006-BBA7", "BSCMS 2006-PWR11", "BSCMS 2006-PWR12", "BSCMS 2006-PWR13", "BSCMS 2006-PWR14", "BSCMS 2006-TOP22", "BSCMS 2006-TOP24", "BSCMS 2007-BBA8", "BSCMS 2007-PWR15", "BSCMS 2007-PWR18 (don't use)", "BSCMS 2007-TOP26", "BSCMSI 1998-C1", "BSCMSI 1999-C1", "BSCMSI 1999-WF2", "BSCMSI 2004-PWR3", "BSCMSI 2005-TOP18", "BSCMSI 2007-PWR16", "BSCMSI 2007-PWR17", "BSCMSI 2007-PWR18", "BSCMSI 2007-TOP26 preliminary", "BSCMSI 2007-TOP28", "BSDB 2005-AFR1", "BSSBC 2006-1", "BTC 1997-S1", "BTRT 1999-S1", "BWAY 2013-1515", "BancAmerica 2000-WSF1", "BancOne/FCCC-CMLT 2000-C1", "Bank One 2000-1 (RMBS)", "Bank One 2000-2 (RMBS)", "Barclays Capital Terra LNR 1", "Bear Starns ALT A 2006-2", "Bear Stearns ALT A 2004-11", "Beckman Coulter 2000-A", "Bedford Capital Trust 2001-1", "Business Loan Express 2002-1", "Business Loan Express 2003-1", "Business Loan Express 2003-2", "Business Loan Express 2005-1", "Business Loan Express 2006-1", "CAH 2014-1", "CAH 2014-2", "CAISSE 1999", "CALW 2002-CALW", "CALWEST 2003-1", "CAMC 2002-CAM2", "CAP GT6", "CAPCO 1998-D7", "CAPCO Mtg Pass Thru 1998-C7", "CAR 2002-DB4", "CAREY 2002-1", "CBAMC 1993-C1", "CBM 1996-1", "CCA1-2", "CCA1-3", "CCI 2005-1", "CCIC 2002-CCL1", "CCIC 2002-CL1 - private", "CCIC 2003-WEM", "CCIC 2006-1A", "CCIC 2006-WEM", "CCMOT 2012-1", "CCMOT 2013-2", "CCMS 1996-1", "CCMS 1996-2", "CCMS 1997-1", "CCMS 1997-2", "CCMS 1998-1", "CCMS 1998-2", "CCMS 1998-SN1", "CCMS 1999-1", "CCMSC 1999-2", "CCMSC 2000-1", "CCMSC 2000-2", "CCMSC 2000-3", "CCMSC 2000-FL1", "CCMSC 2001-245", "CCT 2000-CCT", "CD 2005-CD1", "CD 2006-CD2", "CD 2006-CD3", "CD 2007-CD4", "CD 2007-CD5", "CDCMT 2002-FX1", "CDCSC 1999-FL1", "CDCSC 2004-CM", "CDO 1", "CDO 2", "CFAB 2000-2 <ABS>", "CFCRE 2011-C1", "CFCRE 2011-C2", "CFT 1999-1", "CFT 2000-1", "CGBAM 2013-BREH", "CGBAM 2014-HD", "CGCMT 2004-C1", "CGCMT 2004-C1private", "CGCMT 2004-C2", "CGCMT 2004-FL1", "CGCMT 2005-C3", "CGCMT 2006-C4", "CGCMT 2006-C5", "CGCMT 2006-FL2", "CGCMT 2007-C6", "CGCMT 2007-FL3", "CGCMT 2008-C7", "CGCMT 2012-GC8", "CGCMT 2013-375P", "CGCMT 2013-GC11", "CGCMT 2013-GC15", "CGCMT 2013-GC17", "CGCMT 2013-SMP", "CGCMT 2014-388G", "CGCMT 2014-GC19", "CGCMT 2014-GC21", "CGCMT 2014-GC23", "CGCMT 2014-GC25", "CGMT 2005-EMG", "CGRBS 2013-VINO5", "CGWF 2013-RKWH", "CIRPT 1996-A", "CLAC 1994-1", "CLAS 1997-1", "CLF 1997-CTL1", "CLMT 2008-LS1", "CLRT 2006-1", "CLRT 2007-2", "CMAC 1996-C1", "CMAC 1996-C2", "CMAC 1997-ML1", "CMAC 1998-C1", "CMAC 1998-C2", "CMAC 1999-C1", "CMAT 1999-C1", "CMAT 1999-C2", "CMLBC 2001-CMLB-1", "CNL 1998-1", "CNL 2000-A", "CNLF 1999-1", "COBALT 2006-C1", "COBALT 2007-C2", "COBALT 2007-C3", "COMM 1999-1", "COMM 2000-C1", "COMM 2000-C1 (prered)", "COMM 2000-FL1", "COMM 2000-FL2", "COMM 2000-FL2 (Hartford)", "COMM 2000-FL3", "COMM 2001-C1", "COMM 2001-CITI", "COMM 2001-FL4", "COMM 2001-FL5", "COMM 2001-J1", "COMM 2001-J2", "COMM 2002-FL6", "COMM 2002-FL7", "COMM 2002-WFA", "COMM 2003-FL8", "COMM 2003-FL9", "COMM 2003-J2R", "COMM 2003-LNB1", "COMM 2003-LNB1 (trust-only)", "COMM 2004-CNL", "COMM 2004-HTL1", "COMM 2004-LNB2", "COMM 2004-LNB3", "COMM 2004-LNB4", "COMM 2004-RS1", "COMM 2005-C6", "COMM 2005-FL10", "COMM 2005-FL11", "COMM 2005-LNP5", "COMM 2006-C7", "COMM 2006-C8", "COMM 2006-CD2", "COMM 2006-CNL", "COMM 2006-FL12", "COMM 2007-C9", "COMM 2007-FL14", "COMM 2007-MF1", "COMM 2009-K3", "COMM 2010-C1", "COMM 2011-FL1", "COMM 2011-THL", "COMM 2012-9W57", "COMM 2012-CR1", "COMM 2012-CR2", "COMM 2012-CR3", "COMM 2012-CR4", "COMM 2012-CR5", "COMM 2012-FL2", "COMM 2012-LC4", "COMM 2012-LTRT", "COMM 2012-MVP", "COMM 2013-300P", "COMM 2013-CCR13", "COMM 2013-CCRE10", "COMM 2013-CCRE11", "COMM 2013-CCRE12", "COMM 2013-CCRE6", "COMM 2013-CCRE7", "COMM 2013-CCRE8", "COMM 2013-CCRE9", "COMM 2013-GAM", "COMM 2013-LC13", "COMM 2013-LC6", "COMM 2013-SFS", "COMM 2013-WWP", "COMM 2014-277P", "COMM 2014-BBG", "COMM 2014-CCRE14", "COMM 2014-CCRE15", "COMM 2014-CCRE16", "COMM 2014-CCRE17", "COMM 2014-CCRE18", "COMM 2014-CCRE19", "COMM 2014-CCRE20", "COMM 2014-FL4", "COMM 2014-GRCE", "COMM 2014-LC15", "COMM 2014-LC17", "COMM 2014-TWC", "COMM 2014-UBS2", "COMM 2014-UBS3", "COMM 2014-UBS4", "COMM 2014-UBS5", "COMM 2014-UBS6", "CONSECO 1989-1", "CR 2000-ZC2", "CREST 2003-1", "CREST 2003-2", "CREST 2004-1", "CREST CLARENDON ST. 2002-1", "CREST CLARENDON ST. 2002-1 REIT", "CREST Exeter Solar 2004-1", "CREST TEST 20031-1", "CRFCM 2004-1", "CRIIMI 1996-C1", "CRIIMI 1998-1", "CRIIMI MAE Class D Trust", "CSCMT 2006-C3", "CSCMT 2006-C5", "CSCMT 2007-C1", "CSCMT 2007-C2", "CSCMT 2007-C3", "CSCMT 2007-C3A", "CSCMT 2007-C4", "CSCMT 2007-C5", "CSCMT 2007-TFL1", "CSCMT 2007-TFL2", "CSCMT 2008-C1", "CSFB 1993-M1", "CSFB 1994-1", "CSFB 1994-CFB1", "CSFB 1995-AEW1", "CSFB 1995-M1", "CSFB 1995-MBL1", "CSFB 1995-WF1", "CSFB 1995-WF1 Private", "CSFB 1997-C1", "CSFB 1997-C2", "CSFB 1997-PS1", "CSFB 1997-SPICE", "CSFB 1998-C1", "CSFB 1998-C2", "CSFB 1998-FL1", "CSFB 1998-FL1 Private", "CSFB 1998-FL2", "CSFB 1998-FL2Private", "CSFB 1998-PS2", "CSFB 1999-C1", "CSFB 1999-P1", "CSFB 1999-P1 Private", "CSFB 1999-PS3", "CSFB 2000-4", "CSFB 2000-C1", "CSFB 2000-FL1", "CSFB 2001-CF2", "CSFB 2001-CF2 (trust-only)", "CSFB 2001-CK1", "CSFB 2001-CK3", "CSFB 2001-CK6", "CSFB 2001-CKN5", "CSFB 2001-CP4", "CSFB 2001-FL1", "CSFB 2001-FL2", "CSFB 2001-LCCA", "CSFB 2001-SPG1", "CSFB 2001-TFL1", "CSFB 2002-CKN2", "CSFB 2002-CKP1", "CSFB 2002-CKS4", "CSFB 2002-CP3", "CSFB 2002-CP5", "CSFB 2002-FL1", "CSFB 2002-FL1 (private)", "CSFB 2002-FL2", "CSFB 2002-TFL1", "CSFB 2003 CPN1", "CSFB 2003-C3", "CSFB 2003-C4", "CSFB 2003-C5", "CSFB 2003-CK2", "CSFB 2003-CK2 (trust-only)", "CSFB 2003-TFL1", "CSFB 2003-TFL2", "CSFB 2004-C1", "CSFB 2004-C2", "CSFB 2004-C3", "CSFB 2004-C4", "CSFB 2004-C5", "CSFB 2004-FL1", "CSFB 2004-HC1", "CSFB 2004-TFL1", "CSFB 2004-TFL2", "CSFB 2005-C1", "CSFB 2005-C2", "CSFB 2005-C3", "CSFB 2005-C4", "CSFB 2005-C5", "CSFB 2005-C6", "CSFB 2005-CND1", "CSFB 2005-CND1 Private", "CSFB 2005-CND2", "CSFB 2005-TFL1", "CSFB 2005-TFL2", "CSFB 2005-TFL3", "CSFB 2006-OMA", "CSMC 2006-C1", "CSMC 2006-C2", "CSMC 2006-C4", "CSMC 2006-K1", "CSMC 2006-TFL1", "CSMC 2006-TFL2", "CSMC 2014-ICE", "CSMC 2014-SURF", "CSMS 2006-HC1", "CWL 2000-2 <ABS>", "CWL 2000-3 <ABS>", "CalSTRS Trust 2002-C6", "Century City Mortgage Trust 1999-C2A", "Chandler Fashion Center A/B Note", "Charlotte Gateway Village LLC 2001", "Chrysler 2001-C3A", "Commercial Asset Holdings", "Cornerstone Titan 2005-1", "Cornerstone Titan 2005-2", "Cornerstone Titan 2006-1", "Cornerstone Titan 2007-1", "Crest Dartmouth 2003-1", "DANMALL 1994-1", "DB Stratgeic HoteLaSalle 2004", "DBCCR 2014-ARCP", "DBUBS 2011-LC1", "DBUBS 2011-LC2", "DBUBS 2011-LC3", "DDR 2009-1", "DEFAULT TESTING", "DEL 2013-HDC", "DEL 2013-HDMZ", "DLB1", "DLB2", "DLJ 1993-MF12", "DLJ 1993-MF17", "DLJ 1994-MF11", "DLJ 1994-MF4", "DLJ 1995-CF2", "DLJ 1996-CF1", "DLJ 1996-CF2", "DLJ 1997-CF1", "DLJ 1997-CF2", "DLJ 1998-CF1", "DLJ 1998-CF2", "DLJ 1998-CG1", "DLJ 1998-STF1", "DLJ 1998-STF2", "DLJ 1999-CG1", "DLJ 1999-CG2", "DLJ 1999-CG3", "DLJ 2000-CF1", "DLJCMC 1999-STF1", "DLJCMC 2000-CKP1", "DLJCMC 2000-STF1", "DMAR 2009-K4", "DMARC 1998-C2", "DRSLT 1993-K1", "DRSLT 1994-K2", "DRT 1999-1", "DRT 2000-1", "DUKE 2000 DW-1", "Dadeland Mall Trust 2002-C2A", "Daiwa 1993-2", "Danbury Fair Mall", "Deutsche Mortgage Series 1998-C1", "ECC 1997", "ECLIPSE 2005-1", "ECLIPSE 2005-2", "ECLIPSE 2005-3", "ECLIPSE 2005-4", "ECLIPSE 2006-1", "ECLIPSE 2006-2", "ECLIPSE 2006-3", "ECLIPSE 2006-4", "ECLIPSE 2007-1", "ECLIPSE 2007-2", "ELAS 1996", "EMAC 1998-1", "EMAC 1999-1", "EMAC 2000-1", "EPT 2003-EPR", "EQTY 2014-INNS", "EQTY 2014-MZ", "ESA 2010-ESH", "Emerald Funding PLC", "Eric Testing", "European Loan Conduit No 1 BV", "European Loan Conduit No 2 BV", "Example TIAA", "FADLLC 2001-1", "FB 2005-1", "FBMT 2012-FBLU", "FCCM 1994-1", "FDIC 2011-C1", "FDIC 2012-C1", "FFCA 1996-C1", "FFCA 1997-1", "FFCA 1998-1", "FFCA 1999-1", "FFCA 1999-2", "FFCA 2000-1", "FFL LLC 1999-1", "FFL LLC 2000-1", "FFL LLC 2001-1", "FFL LLC 2003-1", "FHLMC 2171", "FLT 1998-1", "FMAC 1998-B", "FMAC 1998-C", "FMC Real Estate CDO 2005-1", "FNA 2009-M1", "FNA 2009-M2", "FNA 2010-M1", "FNA 2010-M3", "FNA 2010-M4", "FNGT 1996-T3", "FNGT 2000-T5", "FNGT 2001-T11", "FNGT 2001-T2", "FNGT 2001-T6", "FNGT 2002-T3", "FNGT 2003-T1", "FNGT 2003-T5", "FNGT 2004-T7", "FNMA 1995-M1", "FNMA 1995-M2", "FNMA 1995-M3", "FNMA 1996-M3", "FNMA 1996-M4", "FNMA 1996-M5", "FNMA 1996-M6", "FNMA 1996-M7", "FNMA 1997-M1", "FNMA 1997-M2", "FNMA 1997-M3", "FNMA 1997-M4", "FNMA 1997-M5", "FNMA 1997-M6", "FNMA 1997-M8", "FNMA 1998-49", "FNMA 1998-73", "FNMA 1998-M1", "FNMA 1998-M4", "FNMA 1998-M5", "FNMA 1998-M6", "FNMA 1998-M7", "FNMA 1999-M3", "FNMA 1999-M4", "FNMA 1999-M5", "FNMA 1999-M6", "FNMA 2000-7", "FNMA 2000-M1", "FNMA 2000-M2", "FNMA 2001-Liquid", "FNMA 2001-M2", "FNMA 2001-T6", "FNMA 2002-M2", "FNMA 2002-M3", "FNMA 2003-M2", "FNMA 2004-M1", "FNMA DUS PL", "FOR 2002 GSA2", "FORTRESS 1999-PC1", "FREMF 2010-K5", "FREMF 2010-K6", "FREMF 2010-K7", "FREMF 2010-K8", "FREMF 2010-K9", "FREMF 2010-KSCT", "FREMF 2011-K10", "FREMF 2011-K11", "FREMF 2011-K12", "FREMF 2011-K13", "FREMF 2011-K14", "FREMF 2011-K15", "FREMF 2011-K16", "FREMF 2011-K701", "FREMF 2011-K702", "FREMF 2011-K703", "FREMF 2011-K704", "FREMF 2011-KAIV", "FREMF 2012-K17", "FREMF 2012-K18", "FREMF 2012-K19", "FREMF 2012-K20", "FREMF 2012-K21", "FREMF 2012-K23", "FREMF 2012-K501", "FREMF 2012-K705", "FREMF 2012-K706", "FREMF 2012-K707", "FREMF 2012-K708", "FREMF 2012-K709", "FREMF 2012-K710", "FREMF 2012-K711", "FREMF 2012-KF01", "FREMF 2012-KP01", "FREMF 2013-K24", "FREMF 2013-K25", "FREMF 2013-K26", "FREMF 2013-K27", "FREMF 2013-K28", "FREMF 2013-K29", "FREMF 2013-K30", "FREMF 2013-K31", "FREMF 2013-K32", "FREMF 2013-K33", "FREMF 2013-K34", "FREMF 2013-K35", "FREMF 2013-K502", "FREMF 2013-K712", "FREMF 2013-K713", "FREMF 2013-KF02", "FREMF 2013-KGRP", "FREMF 2013-KS01", "FREMF 2013-KSMC", "FREMF 2014-K36", "FREMF 2014-K37", "FREMF 2014-K38", "FREMF 2014-K714", "FREMF 2014-K715", "FREMF 2014-KF03", "FREMF 2014-KS02", "FTST 2000-4TS", "FTST 2006-4TS", "FUBOA 2001-C1", "FUCMT 1999-C1", "FULB 1997-C1", "FULB 1997-C2", "FULBBA 1998-C2", "FUNB 1999-C4", "FUNB 2000-C1", "FUNB 2000-C2", "FUNB 2001-C2", "FUNB 2001-C3", "FUNB 2001-C4", "FUNB 2002-C1", "FUNB-CMB 1999-C2", "Falcon Trust 2002-SMU", "Falcon Trust 2003-SMU2", "Fashion Valley Mall Trust 2002-C1A", "Fleet Street Finance One", "Forest Finance PLC", "G-Force 2001-1", "G-Force 2002-1", "G-Force 2003-1", "G-Force 2005-RR", "G-Force 2005-RR2", "G3 2002-WL1", "G3 2003-LM1", "G3 2003-TRW1", "GCCFC 2000-ZC-1", "GCCFC 2001-FL1", "GCCFC 2002-C1", "GCCFC 2003-C1", "GCCFC 2003-C2", "GCCFC 2003-FL1", "GCCFC 2004-FL2", "GCCFC 2004-GG1", "GCCFC 2005-FL3", "GCCFC 2005-GG3", "GCCFC 2005-GG5", "GCCFC 2006-FL4", "GCCFC 2006-GG7", "GCCFC 2007-GG11", "GCCFC 2007-GG9", "GCMT 2006-RR1", "GCMT 2007-RR2", "GE 1999-FL1", "GE 2005-C1", "GE 2005-C3", "GE Subway Series 1998", "GECCMC 2000-1", "GECCMC 2001-1", "GECCMC 2001-2", "GECCMC 2002-2", "GECCMC 2002-3", "GECCMC 2003-C1", "GECMC 2001-3", "GECMC 2002-1", "GECMC 2003-C2", "GECMC 2004-C1", "GECMC 2004-C2", "GECMC 2004-C3", "GECMC 2005-C2", "GECMC 2005-C4", "GECMC 2006-C1", "GECMC 2007-C1", "GECMF 1998-1", "GFCM 2003-1", "GGP 2001-GGP1", "GGP HOMART 1999-C1", "GGPAM 1999-C1", "GGPIVH 1999-C1", "GLT 1999-1", "GMAC 1996-C1", "GMAC 1996-C2", "GMAC 1997-C1", "GMAC 1997-C2", "GMAC 1998-C1", "GMAC 1998-C2", "GMAC 1999-C1", "GMAC 1999-C2", "GMAC 1999-C3", "GMAC 1999-CTL1", "GMAC 1999-FL1", "GMAC 2000-C1", "GMAC 2000-C2", "GMAC 2000-C3", "GMAC 2000-FL-A", "GMAC 2000-FL-B", "GMAC 2000-FL-E", "GMAC 2000-FL-F", "GMAC 2000-FL1", "GMAC 2001-C1", "GMAC 2001-C2", "GMAC 2001-C3", "GMAC 2001-FL1", "GMAC 2001-FLA", "GMAC 2001-WH1", "GMAC 2001-WTC", "GMAC 2002-C1", "GMAC 2002-C2", "GMAC 2002-C3", "GMAC 2002-FL1", "GMAC 2002-LT", "GMAC 2003-1DE", "GMAC 2003-C1", "GMAC 2003-C2", "GMAC 2003-C3", "GMAC 2003-C3 AFR B Notes", "GMAC 2003-FL1", "GMAC 2004-C1", "GMAC 2004-C1 (trust-only)", "GMAC 2005-C1", "GMAC 2005-LUX", "GMAC 2006-C1", "GMAC Healthfund I 1999-1", "GMACC 2004-C2", "GMACC 2004-C3", "GMACCM 1999-1", "GMACCM 1999-2", "GMACCM 1999-A", "GMACCM 1999-B", "GMACCM 1999-C", "GMACCM 1999-D", "GMACCM 1999-E", "GMACCM 1999-F", "GMACCM 1999-G", "GMACN 2002-FTLS", "GMACN 2002-MEAD", "GMACN 2002-WPAB", "GMACN 2003-BRAG", "GMACN 2003-CAMP", "GMACN 2003-EARL", "GMACN 2003-KIRT", "GMACN 2003-PRES", "GMACN 2003-STEW", "GMACN 2003-WOOD", "GMACN 2004-BUCk", "GMACN 2004-DETR", "GMACN 2004-FTLS", "GMACN 2004-PNDA", "GMACN 2004-POKA", "GMCMC 2002-FL1", "GMPT 1999-C1", "GNMA 2001-12", "GNMA 2001-16", "GNMA 2001-34", "GNR 2001-44", "GNR 2002-25", "GNR 2002-26", "GNR 2002-35", "GNR 2002-37", "GNR 2002-53", "GNR 2002-61", "GNR 2002-62", "GNR 2002-81", "GNR 2002-83", "GNR 2002-85", "GNR 2002-89", "GNR 2002-9", "GNR 2002-91", "GNR 2002-94", "GNR 2003-108", "GNR 2003-109", "GNR 2003-16", "GNR 2003-17", "GNR 2003-22", "GNR 2003-36", "GNR 2003-43", "GNR 2003-47", "GNR 2003-49", "GNR 2003-5", "GNR 2003-59", "GNR 2003-64", "GNR 2003-73", "GNR 2003-87", "GNR 2004-10", "GNR 2004-103", "GNR 2004-108", "GNR 2004-20", "GNR 2004-23", "GNR 2004-43", "GNR 2004-45", "GNR 2004-50", "GNR 2004-57", "GNR 2004-6", "GNR 2004-67", "GNR 2004-77", "GNR 2004-84", "GNR 2004-97", "GNR 2005-09", "GNR 2005-10", "GNR 2005-12", "GNR 2005-2", "GNR 2005-29", "GNR 2005-32", "GNR 2005-34", "GNR 2005-42", "GNR 2005-50", "GNR 2005-52", "GNR 2005-59", "GNR 2005-67", "GNR 2005-76", "GNR 2005-79", "GNR 2005-87", "GNR 2005-89", "GNR 2005-90", "GNR 2006-15", "GNR 2006-18", "GNR 2006-19", "GNR 2006-3", "GNR 2006-30", "GNR 2006-31", "GNR 2006-39", "GNR 2006-42", "GNR 2006-46", "GNR 2006-5", "GNR 2006-51", "GNR 2006-55", "GNR 2006-6", "GNR 2006-63", "GNR 2006-66", "GNR 2006-68", "GNR 2006-8", "GNR 2006-9", "GNR 2007-12", "GNR 2007-13", "GNR 2007-15", "GNR 2007-34", "GNR 2007-39", "GNR 2007-4", "GNR 2007-46", "GNR 2007-52", "GNR 2007-55", "GNR 2007-69", "GNR 2007-75", "GNR 2007-77", "GNR 2008-14", "GNR 2008-22", "GNR 2008-24", "GNR 2008-28", "GNR 2008-39", "GNR 2008-45", "GNR 2008-48", "GNR 2008-52", "GNR 2008-59", "GNR 2008-78", "GNR 2008-8", "GNR 2008-80", "GNR 2008-86", "GNR 2008-90", "GNR 2008-92", "GNR 2009-105", "GNR 2009-111", "GNR 2009-114", "GNR 2009-115", "GNR 2009-119", "GNR 2009-19", "GNR 2009-27", "GNR 2009-3", "GNR 2009-30", "GNR 2009-37", "GNR 2009-39", "GNR 2009-4", "GNR 2009-49", "GNR 2009-5", "GNR 2009-51", "GNR 2009-60", "GNR 2009-63", "GNR 2009-7", "GNR 2009-71", "GNR 2009-80", "GNR 2009-86", "GNR 2009-90", "GNR 2009-99", "GNR 2010-100", "GNR 2010-13", "GNR 2010-16", "GNR 2010-18", "GNR 2010-22", "GNR 2010-28", "GNR 2010-36", "GNR 2010-40", "GNR 2010-48", "GNR 2010-49", "GNR 2010-52", "GNR 2010-63", "GNR 2010-65", "GNR 2010-66", "GNR 2010-71", "GNR 2010-72", "GNR 2010-74", "GNR 2010-83", "GNR 2010-96", "GNR 2010-97", "GPMH 2000-3 <ABS>", "GPORT3MM", "GPPT 2014-GPP", "GS 2006-CC1", "GSMS 1997-GL1", "GSMS 1998-GLII", "GSMS 1998-GSFLI", "GSMS 1999-GSII", "GSMS 2001-1285", "GSMS 2001-GL3", "GSMS 2004-GG2", "GSMS 2006-CC1", "GSMS 2006-FL8", "GSMS 2006-GG8", "GSMS 2006-RR3", "GSMS 2007-GG10", "GSMS 2010-C1", "GSMS 2010-C2", "GSMS 2011-GC3", "GSMS 2011-GC5", "GSMS 2012-ALOHA", "GSMS 2012-BWTR", "GSMS 2012-GC6", "GSMS 2012-GCJ7", "GSMS 2012-GCJ9", "GSMS 2012-SHOP", "GSMS 2012-TMSQ", "GSMS 2013-G1", "GSMS 2013-GC10", "GSMS 2013-GC12", "GSMS 2013-GC13", "GSMS 2013-GC16", "GSMS 2013-GCJ14", "GSMS 2013-KING", "GSMS 2013-KYO", "GSMS 2013-NYC5", "GSMS 2013-PEMB", "GSMS 2014-GC18", "GSMS 2014-GC20", "GSMS 2014-GC22", "GSMS 2014-GC24", "GSMS 2014-GC26", "GSMS 2014-NEW", "GSMSC 2002-FLV", "GSMSC 2011-ALF", "GSMSCII 1996-PL", "GSMSCII 1998-C1", "GSMSCII 1999-C1", "GSMSCII 1999-TOP", "GSMSCII 2000-GSFLIII", "GSMSCII 2001-LIB", "GSMSCII 2001-ROCK", "GSMSCII 2002-GSFL5", "GSMSCII 2003-C1", "GSMSCII 2003-GSFL VI", "GSMSCII 2004-C1", "GSMSCII 2005-GG4", "GSMSCII 2005-ROCK", "GSMSCII 2006-GG6", "GSMSCII 2007-EOP", "GSMT2 2001-FL4", "GSTAR 2002-1", "GSTAR 2002-2", "GTP 2007-1A", "GWING 2001-WH1", "Gallery at Harborplace 2000-C5C", "Global Signal Series 2006-1", "Green Capital I Limited", "H/2 German American Master Trust 2006", "HHPT 2000-HLT", "HILT 2013-HLF", "HILT 2013-HLT", "HLTN 2014-ORL", "HMAC 1999-PH1", "HMAC 2000-PH1", "HVBMC 2003-FL1", "Hartford (Fortis)", "Hartford 2001", "Heritage mortgage securities PIC FL notes due 2010", "Hometown Commercial Capital 2006-1", "Hometown Commercial Capital 2007-1", "ICCMAC 1999-1", "ICOT 2013-IRV", "IDCT 2001-C5", "IDCT 2001=C5 don''t use", "IFUND 2001-A", "IFUND 2010-1", "IFUND 2014-1", "IHSFR 2013-SFR1", "IMPAC 1998-C1", "IMSCI 2011-1", "IMSCI 2012-2", "IMSCI 2013-3", "IMSCI 2013-4", "IPS 2003-1", "IPS 2005-1", "Imser Securitisations 2 srl", "Iolaus ELOC-15", "JER CDO 2002-1", "JGPS 2002", "JPM 1995-C1", "JPM 1996-C2", "JPM 1996-C3", "JPM 1997-C4", "JPM 1997-C5", "JPM 1997-C5 Private 2", "JPM 1997-SPTL-C1", "JPM 1998-C6", "JPM 1999-C7", "JPM 1999-C8", "JPMBB 2013-C12", "JPMBB 2013-C14", "JPMBB 2013-C15", "JPMBB 2013-C17", "JPMBB 2014-C18", "JPMBB 2014-C19", "JPMBB 2014-C21", "JPMBB 2014-C22", "JPMBB 2014-C23", "JPMBB 2014-C24", "JPMBB 2014-C25", "JPMC 1999-PLS1", "JPMC 2000-C10", "JPMC 2000-C9", "JPMC 2000-FL1", "JPMC 2001-FL1", "JPMCC 2001-C1", "JPMCC 2001-CIBC1", "JPMCC 2001-CIBC2", "JPMCC 2001-CIBC3", "JPMCC 2001-CIBC3 (trust-only)", "JPMCC 2001-KP1", "JPMCC 2002-C1", "JPMCC 2002-C2", "JPMCC 2002-C2 (Trust Only)", "JPMCC 2002-C3", "JPMCC 2002-CIBC4", "JPMCC 2002-CIBC5", "JPMCC 2002-CIBC5 (trust-only)", "JPMCC 2003-C1", "JPMCC 2003-C1 (Evaluation)", "JPMCC 2003-C1 (trust-only)", "JPMCC 2003-CIBC6", "JPMCC 2003-CIBC6 (trust-only)", "JPMCC 2003-CIBC7", "JPMCC 2003-CIBC7 (trust-only)", "JPMCC 2003-LN1", "JPMCC 2003-LN1 (trust-only)", "JPMCC 2003-ML1", "JPMCC 2003-PM1", "JPMCC 2004-C1", "JPMCC 2004-C2", "JPMCC 2004-C3", "JPMCC 2004-CIBC10", "JPMCC 2004-CIBC8", "JPMCC 2004-CIBC8 (trust-only)", "JPMCC 2004-CIBC9", "JPMCC 2004-FL1", "JPMCC 2004-LN2", "JPMCC 2004-PNC1", "JPMCC 2005-CIBC11", "JPMCC 2005-CIBC12", "JPMCC 2005-CIBC13", "JPMCC 2005-FL1", "JPMCC 2005-LDP1", "JPMCC 2005-LDP2", "JPMCC 2005-LDP3", "JPMCC 2005-LDP4", "JPMCC 2005-LDP5", "JPMCC 2005-PRKS", "JPMCC 2006-CIBC14", "JPMCC 2006-CIBC15", "JPMCC 2006-CIBC16", "JPMCC 2006-CIBC17", "JPMCC 2006-FL1", "JPMCC 2006-FL2", "JPMCC 2006-LDP6", "JPMCC 2006-LDP7", "JPMCC 2006-LDP8", "JPMCC 2006-LDP9", "JPMCC 2006-RR1", "JPMCC 2007-C1", "JPMCC 2007-CIBC18", "JPMCC 2007-CIBC19", "JPMCC 2007-CIBC20", "JPMCC 2007-FL1", "JPMCC 2007-LDP10", "JPMCC 2007-LDP11", "JPMCC 2007-LDP12", "JPMCC 2008-C2", "JPMCC 2009-IWST", "JPMCC 2010-C1", "JPMCC 2010-C2", "JPMCC 2010-CNTR", "JPMCC 2011-C3", "JPMCC 2011-C4", "JPMCC 2011-C5", "JPMCC 2011-CCHP", "JPMCC 2011-FL1", "JPMCC 2011-PLSD", "JPMCC 2012-C6", "JPMCC 2012-C8", "JPMCC 2012-CBX", "JPMCC 2012-FL2", "JPMCC 2012-HSBC", "JPMCC 2012-LC9", "JPMCC 2012-WLDN", "JPMCC 2013-ALC", "JPMCC 2013-BOCA", "JPMCC 2013-C10", "JPMCC 2013-C13", "JPMCC 2013-C16", "JPMCC 2013-ESH", "JPMCC 2013-ESH MZ", "JPMCC 2013-JWMZ", "JPMCC 2013-JWRZ", "JPMCC 2013-LC11", "JPMCC 2014-C20", "JPMCC 2014-DSTY", "JPMCC 2014-FBLU", "JPMCC 2014-FL4", "JPMCC 2014-FL5", "JPMCC 2014-FL6", "JPMCC 2014-INN", "JPMCCM 2002-FL1", "JPMCCM 2003-FL1", "JPMCCM 2003-FL2", "JPMCCM 2005-CIBC12", "JPMCCMSC 2001-A", "JPMCCMSC 2001-KP", "JPMCCMSC 2001-KP (trust-only)", "Japan office capital I Limited", "KEY 2007-SL1", "KMART 1997-1", "KPAC 1993 M3", "KPAC 1994-M1", "KRTOC 1996-1", "KSL 2003-1", "KSMC 1995-1", "LABS 1994-C2", "LASL 2005-MF1", "LASL 2006-MF2", "LASL 2006-MF3", "LASL 2006-MF4", "LASL 2007-MF5", "LBCC 1995-C2", "LBCC 1996-C2", "LBCMT 1997-LL1", "LBCMT 1998-C1", "LBCMT 1998-C4", "LBCMT 1999-C1", "LBCMT 1999-C2", "LBCMT 1999-C2A", "LBCMT 1999-C2B", "LBCMT 2007-C3", "LBFRC 2000 LLF-C7", "LBFRC 2001 LLF-C4", "LBFRC 2002-LLF", "LBFRC 2003-C2", "LBFRC 2003-C4", "LBFRC 2004-LLF C5", "LBFRC 2005-LLF C4", "LBFRC 2006-CCL", "LBFRC 2006-LLF C5", "LBFRC 2007-LLF C5", "LBSBC 2005-1A", "LBSBC 2005-2A", "LBSBC 2006-1A", "LBSBC 2006-2A", "LBSBC 2006-3A", "LBSBC 2007-1A", "LBSBC 2007-2A", "LBSBC 2007-3A", "LBUBS 2000-C3", "LBUBS 2000-C4", "LBUBS 2000-C5", "LBUBS 2001-C2", "LBUBS 2001-C2 (Allied)", "LBUBS 2001-C3", "LBUBS 2001-C7", "LBUBS 2001-C7A", "LBUBS 2001-WM", "LBUBS 2002-C1", "LBUBS 2002-C2", "LBUBS 2002-C2 (trust-only)", "LBUBS 2002-C4", "LBUBS 2002-C4 (trust-only)", "LBUBS 2002-C7", "LBUBS 2003-C1", "LBUBS 2003-C3", "LBUBS 2003-C3 (trust-only)", "LBUBS 2003-C5", "LBUBS 2003-C5 (trust-only)", "LBUBS 2003-C7", "LBUBS 2003-C7 (trust-only)", "LBUBS 2003-C8", "LBUBS 2004-C1", "LBUBS 2004-C1 (trust-only)", "LBUBS 2004-C1(Hancock)", "LBUBS 2004-C2", "LBUBS 2004-C2 (trust-only)", "LBUBS 2004-C4", "LBUBS 2004-C6", "LBUBS 2004-C7", "LBUBS 2004-C8", "LBUBS 2005-C1", "LBUBS 2005-C2", "LBUBS 2005-C3", "LBUBS 2005-C5", "LBUBS 2005-C7", "LBUBS 2006-C1", "LBUBS 2006-C3", "LBUBS 2006-C4", "LBUBS 2006-C6", "LBUBS 2006-C7", "LBUBS 2007-C1", "LBUBS 2007-C2", "LBUBS 2007-C6", "LBUBS 2007-C7", "LBUBS 2008-C1", "LCCM 2013-GCP", "LCCM 2014-909", "LEAFS 2002-1", "LM 2003-2", "LM 2003-20", "LMFC 1995-C1", "LNR CDO 2003-1", "LNR CDO 2005-1", "LNR CDO IV 2006", "LNR CFL 2004-1", "LNSTR 2011-1", "LPTSI 1994A (FHLMC1762)", "LTTI 1998-I", "Lehman One Lincoln Street 2004-C3", "MAMT 1998-1", "MANSFIELD TRUST 2001-1", "MART 1999-1", "MAT 2013-650M", "MCAP", "MCAP 2005-1", "MCAP 2014-1", "MCAP-2006", "MCAPSALE11", "MCFI 1994-MC1", "MCFI 1995-MC1", "MCFI 1996-MC1", "MCFI 1996-MC2", "MCFI 1997-MC1", "MCFI 1997-MC2", "MCFI 1998-MC1", "MCFI 1998-MC2", "MCFI 1998-MC3", "METLIFE 01/30/2004", "METLIFE 01/31/2003", "METLIFE 02/28/2003", "METLIFE 03/31/2003", "METLIFE 04/30/2003", "METLIFE 05/31/2003", "METLIFE 07/31/2003", "METLIFE 10/31/2002", "METLIFE 11/30/2002", "METLIFE 12/31/2002", "METLIFE 4/30/2002", "METLIFE 8/31/2002", "METLIFE 9/30/2002", "MEZZ 2004-C1", "MEZZ 2004-C2", "MEZZ 2005-C3", "MEZZ 2006-C4", "MEZZ 2007-C5", "MIDL 1996-C1", "MIDL 1996-C2", "MLCFC 2006-1", "MLCFC 2006-2", "MLCFC 2006-3", "MLCFC 2006-4", "MLCFC 2007-5", "MLCFC 2007-6", "MLCFC 2007-7", "MLCFC 2007-8", "MLCFC 2007-9", "MLFA 1998-CAN1", "MLFA 1999-CAN2", "MLFA 2000-CAN3", "MLFA 2000-CAN4", "MLFA 2001-CAN5", "MLFA 2001-CAN6", "MLFA 2001-LBC", "MLFA 2002-CAN7", "MLFA 2002-CAN8", "MLFA 2003-CAN10", "MLFA 2003-CAN11", "MLFA 2003-CAN9", "MLFA 2004-CAN12", "MLFA 2004-CAN14", "MLFA 2005-CAN15", "MLFA 2005-CAN16", "MLFA 2005-CAN17", "MLFA 2006-CAN18", "MLFA 2006-CAN19", "MLFA 2006-CAN20", "MLFA 2007-CA21", "MLFA 2007-CAN21", "MLFA 2007-CAN22", "MLFA 2007-CAN23", "MLFT 2006-1", "MLIC 1996-1", "MLMI 1994-C1", "MLMI 1994-M1", "MLMI 1995-C1", "MLMI 1995-C2", "MLMI 1995-C3", "MLMI 1996-C1", "MLMI 1996-C2", "MLMI 1997-C1", "MLMI 1997-C2", "MLMI 1997-SD1", "MLMI 1998 ASP1 Underlying", "MLMI 1998-ASP1", "MLMI 1998-C1-CTL", "MLMI 1998-C1-CTL F10", "MLMI 1998-C1-CTL F15", "MLMI 1998-C1-CTL F20", "MLMI 1998-C1-CTL F25", "MLMI 1998-C1-CTL F30", "MLMI 1998-C1-CTL F35", "MLMI 1998-C1-CTL F40", "MLMI 1998-C1-CTL F45", "MLMI 1998-C1-CTL F50", "MLMI 1998-C2", "MLMI 1998-C3", "MLMI 1998-H1", "MLMI 1999-1STT", "MLMI 1999-C1", "MLMI 1999-FL1", "MLMI 2001-HRPT", "MLMI 2005-GGP1", "MLMI 2008-LAQ", "MLMLI 2001-OPRY", "MLMT 2002-MW1", "MLMT 2003-KEY1", "MLMT 2003-KEY1 (trust-only)", "MLMT 2003-LHP", "MLMT 2004-BPC1", "MLMT 2004-KEY2", "MLMT 2004-MKB1", "MLMT 2005-CIP1", "MLMT 2005-CKI1", "MLMT 2005-LC1", "MLMT 2005-MCP1", "MLMT 2005-MKB2", "MLMT 2006-C1", "MLMT 2006-C2", "MLMT 2007-C1", "MLMT 2008-C1", "MOAC 2000-1", "MOTEL 2012-MTL6", "MSAC 2000-1 <ABS>", "MSAT 2005-RR4", "MSBAM 2012-C5", "MSBAM 2012-C6", "MSBAM 2012-CKSV", "MSBAM 2013-C10", "MSBAM 2013-C11", "MSBAM 2013-C12", "MSBAM 2013-C13", "MSBAM 2013-C7", "MSBAM 2013-C8", "MSBAM 2013-C9", "MSBAM 2014-C14", "MSBAM 2014-C15", "MSBAM 2014-C16", "MSBAM 2014-C17", "MSBAM 2014-C18", "MSBAM 2014-C19", "MSC 2000 HG", "MSC 2005-RR6", "MSC 2011-C1", "MSC 2011-C2", "MSC 2011-C3", "MSC 2012-C4", "MSC 2012-STAR", "MSC 2013-ALTM", "MSC 2013-WLSR", "MSC 2014-150E", "MSCI 1995 HF1", "MSCI 1995-GAL-1", "MSCI 1996-BKU1", "MSCI 1996-BKU1 (private)", "MSCI 1996-C1", "MSCI 1996-MBL1", "MSCI 1996-WF1", "MSCI 1997-ALIC", "MSCI 1997-ALICprivate", "MSCI 1997-C1", "MSCI 1997-FF1", "MSCI 1997-HF1", "MSCI 1997-LB1", "MSCI 1997-RR", "MSCI 1997-WF1", "MSCI 1997-XL1", "MSCI 1998-CF1", "MSCI 1998-HF1", "MSCI 1998-HF2", "MSCI 1998-WF1", "MSCI 1998-WF2", "MSCI 1998-XL1", "MSCI 1998-XL2", "MSCI 1999-CAM1", "MSCI 1999-FNV1", "MSCI 1999-HMT", "MSCI 1999-LIFE1", "MSCI 1999-RM1", "MSCI 1999-WF1", "MSCI 1999-WF1 P Collura", "MSCI 1999-XL1NYP", "MSCI 2000-LIFE1", "MSCI 2000-LIFE2", "MSCI 2003-IQ4", "MSCI 2003-IQ5", "MSCI 2003-IQ6", "MSCI 2003-KIDS", "MSCI 2003-MM", "MSCI 2003-TOP11", "MSCI 2003-XLF", "MSCI 2004-HQ3", "MSCI 2004-HQ3 (senior only)", "MSCI 2004-HQ4", "MSCI 2004-IQ7", "MSCI 2004-IQ8", "MSCI 2004-RR", "MSCI 2004-RR2", "MSCI 2004-TOP13", "MSCI 2004-TOP15", "MSCI 2004-TOP15 (trust-only)", "MSCI 2004-XLF", "MSCI 2005-HQ5", "MSCI 2005-HQ6", "MSCI 2005-HQ7", "MSCI 2005-IQ10", "MSCI 2005-IQ9", "MSCI 2005-TOP17", "MSCI 2005-TOP19", "MSCI 2005-XLF", "MSCI 2006-HQ10", "MSCI 2006-HQ13", "MSCI 2006-HQ8", "MSCI 2006-HQ9", "MSCI 2006-IQ11", "MSCI 2006-IQ12", "MSCI 2006-TOP21", "MSCI 2006-TOP23", "MSCI 2006-XLF", "MSCI 2007-HQ11", "MSCI 2007-HQ12", "MSCI 2007-HQ13", "MSCI 2007-IQ13", "MSCI 2007-IQ14", "MSCI 2007-IQ15", "MSCI 2007-IQ16", "MSCI 2007-TOP25", "MSCI 2007-TOP27", "MSCI 2007-XLF", "MSCI 2007-XLF9", "MSCI 2008-TOP29", "MSCI Broadgate", "MSDCWI 2003-F1", "MSDWC 2000 XLF", "MSDWC 2000-1345", "MSDWC 2000-F1 UNDER", "MSDWC 2000-HLT", "MSDWC 2000-PRIN", "MSDWC 2001-280", "MSDWC 2001-DFM", "MSDWC 2001-IQ", "MSDWC 2001-PGM under", "MSDWC 2001-PPM", "MSDWC 2001-TOP1", "MSDWC 2001-TOP3", "MSDWC 2001-TOP5", "MSDWC 2001-XL 280", "MSDWC 2001-XLF", "MSDWC 2001-XLPGM", "MSDWC 2002-IQ3", "MSDWC 2002-TOP7", "MSDWC 2002-XLF", "MSDWC 2003-F1", "MSDWC 2003-TOP9 Raul", "MSDWCI 2001-FRM", "MSDWCI 2001-SGM", "MSDWCI 2002-HQ", "MSDWCI 2002-IQ2", "MSDWCI 2002-WF", "MSDWCI 2003 TOP11 ljr", "MSDWCI 2003-HQ2", "MSDWCI 2003-TOP9", "MSDWCI 2003-TOP9 (jason)", "MSDWOT 2000-F1", "Mach One 2004-1", "Madison Square 2004-1", "Marathon MLMI 980C1 Series 2006-1", "Marquee 2004-1", "MassMutualFNMA", "Meristar 1999-C1", "Merrill Lynch 1996-WFP-B", "Merrill Lynch 1996-WFP-D", "Merrill Lynch 2000 BMCC", "Merrill Lynch 2002-BC2P", "Merrill Lynch 2002-FED", "Morganberry 1996-1", "N-45 2000-1", "N-45 2000-2", "N-45 2001-1", "N-45 2002-1", "N-45 2003-1", "N-45 2003-2", "N-45 2003-3", "N-STAR Real Estate CDO 2004", "N-STAR Real Estate CDO I LTD.", "N45 2003-1", "NACC 1993-1", "NASC 1994-C3", "NASC 1994-MD1", "NASC 1994-TC1", "NASC 1994-TC2", "NASC 1995-D1", "NASC 1995-MD3", "NASC 1995-MD4", "NASC 1996-D2", "NASC 1996-D3", "NASC 1996-MD5", "NASC 1996-MD6", "NASC 1997-D4", "NASC 1997-D5", "NASC 1997-MD7", "NASC 1998-D6", "NATIONWIDE 2007", "NBCM 1996 DMC", "NFC 1996-1", "NFC 1996-1 (Ken Doiron)", "NFC 1998-1", "NFC 1998-2", "NFC 1999-1", "NFC 1999-2", "NFC 1999-LTL-1", "NFC 1999-SL", "NHEL20002", "NLF 2005-1", "NLF 2005-DT", "NLY 2014-FL1", "NRF 2012-1", "NSTAR-Test", "NWMCT 2000-1", "Nishant iz da CRAZIEST!", "Non-Securitized Loans", "Nortel Networks 2001-1", "North First Credit Lease 2001-CTL1", "OAKDALE 1994-1", "OBP 2010-OBP", "OCMI 1995-1", "OLCMT 2004-C3", "OMFC 1996", "OPERA NO 3", "OPERA No 1", "OPT 2001-HRPTA", "PCMT 2003-PWR1", "PFL-LLC 1999-A", "PGFC 1996", "PHFC 2003-CTF", "PMAC 1995-M1", "PMAC 1995-M2", "PMAC 1996-M1", "PMAC 1999-C1", "PMLI 1996-PML", "PNCMA 2000-C1", "PNCMA 2001-C1", "PNCMAC 1999-CM1", "PNCMAC 2000-C2", "PRU 1995-C2", "PRU 2001-C1", "PSA (private)", "PSSFC 1995-C1", "PSSFC 1998-1", "PSSFC 1998-C1", "PSSFC 1999-C2", "PSSFC 1999-NRF1", "PSSFC 2000-C1", "Pan-European Industrial Properties IV", "Park Square 2000-C5B", "Pinnacle 2004-2", "Portfolio Green German GMBH", "Prima Capital CDO 2005-1", "Protective Comml Mtg Fasit 1997-1", "Protective Finance REMIC 2007-PL", "Pru-HTG 2000-C1", "Pru-HTG 2000-C1(private)", "Pure Mortgages 2004", "QICC 1997-1", "RAIT 2014-FL2", "RAITF 2013-FL1", "RAMP 2004-RS10", "RAMP 2005-HI3", "RAMP 2006-RS2", "RBS 2013-SMV", "RBSCF 2010-MB1", "RBSCF 2013-GSP", "REALT 2004-1", "REALT 2005-1", "REALT 2005-2", "REALT 2006-1", "REALT 2006-2", "REALT 2006-3", "REALT 2007-1", "REALT 2007-2", "REALT 2007-3", "REALT 2014-1", "REGULAR DEAL 1", "REGULAR DEAL 2", "RMF 1995-1", "RMF 1997-1", "ROLLINGTESTDEAL", "RSO 2013-CRE1", "RTC 1992-C1", "RTC 1992-C2", "RTC 1992-C8", "Real Estate Capital 2004 No. 2", "Real Estate Capital 5 Plantation Place", "Real Estate Capital VI (Alburn Rec Ltd)", "Rite Aid 1999-1", "SASC 1993-C1", "SASC 1994-C1", "SASC 1995-C1", "SASC 1995-C4", "SASC 1996-C3", "SASC 1996-CFL", "SASC 1997-C1", "SASC 1998-C2", "SASC 1998-C3", "SASC 1999-C3", "SASC 2000-C2", "SASC 2001-C8", "SBA CMBS 2005-1", "SBA CMBS 2006-1", "SBM7 2002-KEY2", "SBM7 2003-CDC", "SBMS 1996-C1", "SBMS 1997-TZH", "SBMS 1999-C1", "SBMS 2000-C1", "SBMS 2000-C2", "SBMS 2000-C2 PR", "SBMS 2000-C3", "SBMS 2000-FL1", "SBMS 2001-C1", "SBMS 2001-C2", "SBMS 2001-MM", "SBMS-VII 2000-NL1", "SBMS7 2002-A", "SBMS7 2002-CDC", "SBMS7 2002-CDC (Test A/B)", "SBMSVII 2001-CDC", "SBY 2014-1", "SCG 2013-FV1", "SCG 2013-SRP1", "SCHOONER TRUST 2004-CCF1", "SCHOONER TRUST 2004-CF2", "SCHOONER TRUST 2005-3", "SCHOONER TRUST 2005-4", "SCHOONER TRUST 2006-5", "SCHOONER TRUST 2006-6", "SCHOONER TRUST 2007-7", "SCHOONER TRUST 2007-8", "SCM 1997", "SDT 2001-C6", "SETS Trust No. 2007-1", "SETS Trust No. 2007-2", "SFS 1997-1", "SHC 2003-1", "SHCI 1999-C1", "SHCI 2001-C1", "SLCMT 1997-C1", "SMAFC 1998-C1", "SMP 2000-1", "SMP 2003-1", "SMSC 1994-M1", "SMSC 1995-M1", "SOV 2007-C1", "SPARC 2001-CF1", "SPTLA 1996-C1", "STARS 2000-1", "STARS 2002-1", "STARS 2003-1", "STORE 2014-1", "STRIPS III 2003-1", "STRWD 1999-C1", "Solar 2002-1 (DO NOT USE)", "Solar Trust 2000-1", "Solar Trust 2000-1 (w/YM)", "Solar Trust 2001-1", "Solar Trust 2002-1", "Solar Trust 2003-CC1", "Southbury Credit Lease 1999-CTL1", "Summit (Evaluation)", "SunAmerica Mortgage Trust 1999-C2B", "TAGGP 1997", "TAT 2001-C1", "TEST securitization", "TIAA 2001-C1", "TIAA 2007-C4", "TIAA CDO 2002-1", "TIAA CDO 2003-1", "TIAA Example 2", "TIAA-RCMT 1999-1", "TIAAS 2007-C4", "TMSBT 1999-1", "TMSQ 2014-1500", "TRIZE 2001-TZH", "TVO 1994-1", "Talisman-1", "Talisman-2", "Talisman-3", "Talisman-4", "Talisman-5", "Talisman-6", "Talisman-7", "Tarus CMBS 2006-1", "Tarus CMBS 2006-2", "Terwin Mortage 2005-10HE", "Tharaldson Preferred Equity", "TimberStar 2006-1", "Tital Europe 2006-1", "Tital Europe 2006-2", "Tital Europe 2006-3", "Tital Europe 2006-4", "Tital Europe 2006-5", "Tital Europe 2007-1", "Tital Europe 2007-2", "Tital Europe 2007-3", "Tower 2004-1", "Tuckahoe 2001-CTL1", "UBS 2012-WRM", "UBS IOP Repurchase Facility 2006", "UBSA 2002-C1A", "UBSBB 2012-C2", "UBSBB 2012-C3", "UBSBB 2012-C4", "UBSBB 2013-C5", "UBSBB 2013-C6", "UBSC 2011-C1", "UBSCM 2012-C1", "UBSCMT 2007-FL1", "UCMS 2007-1", "VNDO 2012-6AVE", "VNDO 2013-PENN", "VNO 2000-VNO", "VNO 2010-VNO", "Vanilla Waterfall", "Ventas 2001-Ventas", "WAMU 2001-C1", "WAMU 2003-C1", "WAMU 2005-C1", "WAS 1996-M1", "WBCMT 2002-C1", "WBCMT 2002-C2", "WBCMT 2002-WHALE1", "WBCMT 2003-C3", "WBCMT 2003-C4", "WBCMT 2003-C5", "WBCMT 2003-C6", "WBCMT 2003-C7", "WBCMT 2003-C8", "WBCMT 2003-C9", "WBCMT 2003-WHALE2", "WBCMT 2004 WHALE III", "WBCMT 2004-C10", "WBCMT 2004-C11", "WBCMT 2004-C12", "WBCMT 2004-C14", "WBCMT 2004-C15", "WBCMT 2004-WHALE 4", "WBCMT 2005-C16", "WBCMT 2005-C17", "WBCMT 2005-C18", "WBCMT 2005-C19", "WBCMT 2005-C20", "WBCMT 2005-C21", "WBCMT 2005-C22", "WBCMT 2005-WHALE 5", "WBCMT 2005-WHALE6", "WBCMT 2006-C23", "WBCMT 2006-C24", "WBCMT 2006-C25", "WBCMT 2006-C26", "WBCMT 2006-C27", "WBCMT 2006-C28", "WBCMT 2006-C29", "WBCMT 2006-WHALE7", "WBCMT 2007-C30", "WBCMT 2007-C31", "WBCMT 2007-C32", "WBCMT 2007-C33", "WBCMT 2007-C34", "WBCMT 2007-ESH", "WBCMT 2007-WHALE 8", "WFCM 2010-C1", "WFCM 2011-BXR", "WFCM 2012-LC5", "WFCM 2013-120B", "WFCM 2013-BTC", "WFCM 2013-LC12", "WFCM 2014-LC18", "WFCMT 2014-LC16", "WFLD 2014-MONT", "WFP 1996-WFP-D", "WFRBS 2011-C2", "WFRBS 2011-C3", "WFRBS 2011-C4", "WFRBS 2011-C5", "WFRBS 2012-C10", "WFRBS 2012-C6", "WFRBS 2012-C7", "WFRBS 2012-C8", "WFRBS 2012-C9", "WFRBS 2013-C11", "WFRBS 2013-C12", "WFRBS 2013-C13", "WFRBS 2013-C14", "WFRBS 2013-C15", "WFRBS 2013-C16", "WFRBS 2013-C17", "WFRBS 2013-C18", "WFRBS 2013-UBS1", "WFRBS 2014-C19", "WFRBS 2014-C20", "WFRBS 2014-C21", "WFRBS 2014-C22", "WFRBS 2014-C23", "WFRBS 2014-C24", "WFRBS 2014-C25", "WFRBS 2014-LC14", "WGL 2002-1", "WINDERMERE II", "WINDERMERE II CMBS", "WMCMS 2006-SL1", "WMCMS 2007-SL2", "WMCMS 2007-SL3", "WMMM 2001-1RR", "WSFC 2003-1", "WSFC 2003-2", "WTC7 2012-7WTC", "WVMT 2011-SBC2", "Walnut/Lehman Credit Lease", "Westfield Valley Fair 2002-C4A", "Westfield West County 2003-C3A", "Westin River 2001", "White Tower 2006-3", "White Tower 2007-1", "Windermere IX CMBS", "Windermere VII", "Windermere VIII", "Windermere X", "Windermere XI", "Windermere XiV", "Windermere private Placement I", "amrescotest", "gnr2004010kps"] | |
| got: [] | |
| (compared using ==) | |
| # ./spec/integrations/elasticsearchable_cache_spec.rb:18:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 12) Elasticsearchable search cache DimSecuritization vintage matches | |
| Failure/Error: expect(es_result).to eq(ar_result) | |
| expected: [1989, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2030] | |
| got: [] | |
| (compared using ==) | |
| # ./spec/integrations/elasticsearchable_cache_spec.rb:38:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 13) Elasticsearchable search cache DimProperty states match | |
| Failure/Error: expect(es_states).to eq ar_states | |
| expected: ["AB", "AK", "AL", "AR", "AZ", "BC", "CA", "CO", "CT", "DC", "DE", "FL", "GA", "HI", "IA", "ID", "IL", "IN", "KS", "KY", "LA", "MA", "MB", "MD", "ME", "MI", "MN", "MO", "MS", "MT", "NB", "NC", "ND", "NE", "NF", "NH", "NJ", "NM", "NS", "NV", "NY", "OH", "OK", "ON", "OR", "OT", "PA", "PE", "PR", "QC", "RI", "SC", "SD", "SK", "TN", "TX", "UT", "VA", "VT", "WA", "WI", "WV", "WY"] | |
| got: [] | |
| (compared using ==) | |
| # ./spec/integrations/elasticsearchable_cache_spec.rb:53:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 14) Elasticsearchable search cache DimProperty PropertyTypeMajor matches | |
| Failure/Error: expect(es_result).to eq ar_result | |
| expected: ["Healthcare", "Hospitality", "Industrial", "Mixed Use", "Mobile Home Park", "Multifamily", "Office", "Other", "Retail", "Self-Storage"] | |
| got: [] | |
| (compared using ==) | |
| # ./spec/integrations/elasticsearchable_cache_spec.rb:68:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 15) Elasticsearchable search cache DimProperty PropertyTypeMinor matches | |
| Failure/Error: expect(es_result).to eq ar_result | |
| expected: ["hc - assisted living", "ht - extended stay", "ht - full service", "ht - limited service", "in - flex", "in - manufacturing", "in - warehouse", "mf - cooperative", "mf - garden", "mf - high rise", "mf - low income housing", "mf - mid rise", "mf - senior housing", "mf - student housing", "mhp - general rural", "mhp - general suburban", "mhp - rv park", "mu - industrial-office", "mu - multifamily-retail", "mu - office-retail", "mu - retail-multifamily", "mu - retail-self storage", "of - cbd", "of - medical", "of - research & development", "of - suburban office", "of - urban office", "ot - land", "ot - parking", "r - factory outlet", "r - neighborhood center", "r - neighborhood center inline space", "r - power/lifestyle center", "r - power/lifestyle center inline space", "r - regional mall", "r - single tenant big box", "r - single tenant retail", "r - strip/convenience", "r - strip/convenience shadow anchored", "r - super regional mall", "ss - both", "ss - climate controlled", "ss - non-climate controlled"] | |
| got: [] | |
| (compared using ==) | |
| # ./spec/integrations/elasticsearchable_cache_spec.rb:84:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 16) Elasticsearchable search cache FactNote LoanStatus matches | |
| Failure/Error: expect(es_result).to eq(ar_result) | |
| expected: ["Defeased", "Del 30", "Del 30 ss", "Del 30(w)", "Del 60", "Del 60 ss", "Del 60(w)", "Del 90", "Del 90+ ss", "Del 90+(w)", "Del >12 mo ss", "Grace", "Grace(w)", "In Foreclosure", "Late", "Late(w)", "Matured", "Matured Non Performing(w)", "Partially Defeased", "Perform", "Perform(w)", "REO", "Repaid", "Special"] | |
| got: [] | |
| (compared using ==) | |
| # ./spec/integrations/elasticsearchable_cache_spec.rb:97:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 17) Elasticsearchable index structure mappings should match defined properties | |
| Failure/Error: expect(_mappings.keys).to include(_key) | |
| expected ["PropertyTypeMajor", "PropertyTypeMinor", "StandardizedBalance", "UPBCurrent"] to include "dwidProperty" | |
| # ./spec/integrations/elasticsearchable_spec.rb:27:in `(root)' | |
| # ./spec/integrations/elasticsearchable_spec.rb:26:in `(root)' | |
| # ./spec/integrations/elasticsearchable_spec.rb:19:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 18) Elasticsearchable Search UX/UI Search results should be sorted StandardizedBalance_sum DESC | |
| Failure/Error: expect(search_results[0].size).to be > 0, "Search for SecuritizationName: #{shelf} yields no results" | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:149:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 19) Elasticsearchable ActiveRecord/Elasticsearch data validation Search for StandardizedBalance 0, NoteName | |
| Failure/Error: expect(es_results.results.total).to be > 0, 'Search for StandardizedBalance: 0, NoteName: Center yields no results' | |
| Search for StandardizedBalance: 0, NoteName: Center yields no results | |
| # ./spec/integrations/elasticsearchable_spec.rb:163:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 20) Elasticsearchable ActiveRecord/Elasticsearch data validation Search for State (partial token) | |
| Failure/Error: expect(es_results[0].size).to be > 0, "Search for State: 'u' yields no results" | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:179:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 21) Elasticsearchable ActiveRecord/Elasticsearch data validation Search property and loan counts match (grain 1) match SecuritizationsController#show issuance and current | |
| Failure/Error: expect(es_results[0].size).to be > 0, "Search for SecuritizationName: #{securitization_name}, Include0UPB:true yields no results" | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:199:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 22) Elasticsearchable ActiveRecord/Elasticsearch data validation Search for StandardizedBalance > 0 | |
| Failure/Error: expect(es_total).to be > 0 | |
| expected: > 0 | |
| got: 0 | |
| # ./spec/integrations/elasticsearchable_spec.rb:231:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 23) Elasticsearchable ActiveRecord/Elasticsearch data validation Elasticsearch index sizes match SQL counts | |
| Failure/Error: expect(es_size).to be > 0 | |
| expected: > 0 | |
| got: 0 | |
| # ./spec/integrations/elasticsearchable_spec.rb:257:in `(root)' | |
| # ./spec/integrations/elasticsearchable_spec.rb:243:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 24) Elasticsearchable ActiveRecord/Elasticsearch data validation Securitization's properties are searchable | |
| Failure/Error: expect(dim_property_search.response.hits.total).to be > 0 | |
| expected: > 0 | |
| got: 0 | |
| # ./spec/integrations/elasticsearchable_spec.rb:283:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 25) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on Cusip, SecuritizationName | |
| Failure/Error: expect(search_results[0].size).to eq(1), "Search for SecuritizationName: #{dim_securitization_securitization_name}, Cusip: #{cusip} results size is not 1" | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:300:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 26) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName | |
| Failure/Error: es_size = described_class.new(params).search[0].size | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:310:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 27) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on Securitization (partial token) | |
| Failure/Error: es_size = es_results[0].size | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:331:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 28) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, NoteName | |
| Failure/Error: es_size = search_results[0].size | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:357:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 29) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, NoteDate (range) | |
| Failure/Error: expect(search_results[0].size).to be > 0, "Search for SecuritizationName: #{shelf}, NoteDateStart: #{_date}, NoteDateEnd: #{_date}, Include0UPB:true yields no results" | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:383:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 30) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, NoteDate | |
| Failure/Error: es_size = search_results[0].size | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:413:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 31) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, LoanStatus | |
| Failure/Error: es_size = search_results[0].size | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:474:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 32) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, LoanStatus (token, not direct match) | |
| Failure/Error: es_size = search_results[0].size | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:497:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 33) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, PropertyTypeMajor | |
| Failure/Error: expect(search_results[0].size).to be > 0, "Search for SecuritizationName: #{dim_securitization_securitization_name}, PropertyTypeMajor: Mobile Home Park, Include0UPB:true yields no results" | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:520:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 34) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, PropertyTypeMajor (partial) | |
| Failure/Error: expect(search_results[0].size).to be > 0, "Search for SecuritizationName: #{dim_securitization_securitization_name}, PropertyTypeMajor: park, Include0UPB:true yields no results" | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:544:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 35) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, PropertyTypeMinor | |
| Failure/Error: expect(search_results[0].size).to be > 0, "Search for SecuritizationName: #{dim_securitization_securitization_name}, PropertyTypeMinor: MHP - General Suburban, Include0UPB:true yields no results" | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:567:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 36) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, PropertyTypeMinor (partial) | |
| Failure/Error: expect(search_results[0].size).to be > 0, "Search for SecuritizationName: #{shelf}, PropertyTypeMinor: medical, Include0UPB:true yields no results" | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:590:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 37) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, State (defeased excluded) | |
| Failure/Error: expect(search_results[0].size).to be > 0, "Search for SecuritizationName: #{shelf}, State: NY, Include0UPB:true does not yield results" | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:649:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 38) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, City, State | |
| Failure/Error: expect(search_results[0].size).to be > 0, "Search for SecuritizationName: #{shelf}, City: nashua, State: nh, Include0UPB:true yields no results" | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:665:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 39) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, Vintage, NoteName, NoteDateStart, NoteDateEnd, LoanStatus, PropertyTypeMajor, PropertyName, StreetAddress, City, State | |
| Failure/Error: es_size = search_results[0].size | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:698:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 40) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, Vintage, NoteName, NoteDate, LoanStatus, PropertyTypeMajor, City, State | |
| Failure/Error: es_size = search_results[0].size | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:750:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 41) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, NoteName, State, and TennantName | |
| Failure/Error: expect(es_search_results[0].size).to be > 0, "Search for SecuritizationName: #{shelf}, State: #{property_state}, TennantName: #{tenant_name}, NoteName: #{note_name}, Include0UPB:true yields no results" | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:830:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 42) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, State, and TennantName | |
| Failure/Error: expect(ar_size).to eq(es_data.size), "Search for SecuritizationName: #{shelf}, LoanStatus!=Defeased, TennantName: #{tenant_name}, State: #{property_state} counts do not match SQL: [es: #{es_data.size}, sql: #{ar_size}]" | |
| Search for SecuritizationName: BACM, LoanStatus!=Defeased, TennantName: walgreens, State: TN counts do not match SQL: [es: 0, sql: 2] | |
| # ./spec/integrations/elasticsearchable_spec.rb:884:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 43) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, TennantName | |
| Failure/Error: expect(ar_size).to eq(es_size), "Search for SecuritizationName: #{shelf}, TennantName: #{tenant_name} counts do not match SQL: [es: #{es_size}, sql: #{ar_size}]" | |
| Search for SecuritizationName: BACM, TennantName: walgreens counts do not match SQL: [es: 0, sql: 61] | |
| # ./spec/integrations/elasticsearchable_spec.rb:913:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 44) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on Securitization, FactRentRoll | |
| Failure/Error: expect(ar_dwidSecuritizations.size).to eq(es_dwidSecuritizations.size), "Search SecuritizationName: #{shelf} joining FactRentRoll counts do not match SQL [es: #{es_dwidSecuritizations.size}, sql: #{ar_dwidSecuritizations.size}]" | |
| Search SecuritizationName: BACM joining FactRentRoll counts do not match SQL [es: 0, sql: 17131] | |
| # ./spec/integrations/elasticsearchable_spec.rb:935:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 45) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on ZipCode | |
| Failure/Error: expect(search_results[0].size).to be > 0, 'Search for ZipCode: 95687, Include0UPB:true yields no results' | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:947:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 46) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on Securitization, StreetAddress | |
| Failure/Error: expect(search_results[0].size).to be > 0, 'Search for SecuritizationName: BACM, StreetAddress: pacific, Include0UPB:true yields no results' | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:984:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 47) Elasticsearchable ActiveRecord/Elasticsearch data validation Search PropertyName | |
| Failure/Error: expect(search_results[0].size).to be > 0, 'Search for PropertyName: kindercare, Include0UPB:true yields no results' | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:1021:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 48) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on TennantName | |
| Failure/Error: expect(es_search_results[0].size).to be > 0, "Search for TennantName: #{tenant_name}, Include0UPB:true yields no results" | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:1059:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 49) Elasticsearchable ActiveRecord/Elasticsearch data validation Aggregate counts for SecuritizationName, State | |
| Failure/Error: es_property_count = search_results[1]['property_count'] | |
| NoMethodError: | |
| undefined method `[]' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:1112:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 50) Elasticsearchable ActiveRecord/Elasticsearch data validation Aggregate counts for search grain 1, include 0 UPB | |
| Failure/Error: es_size = search_results[1]['loan_count'] | |
| NoMethodError: | |
| undefined method `[]' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:1175:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 51) Elasticsearchable ActiveRecord/Elasticsearch data validation Aggregate counts for search grain 1, exclude 0 UPB | |
| Failure/Error: expect(search_results[0].size).to be > 0, "Search for SecuritizationName: #{securitization_name}, Include0UPB:false yields no results" | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:1228:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 52) Elasticsearchable ActiveRecord/Elasticsearch data validation Aggregate counts for search grain 2, include/exclude 0 UPB | |
| Failure/Error: expect(search_results[0].size).to be > 0, 'Search for SecuritizationName: bacm 2005-4, NoteName: old, Include0UPB:true does not yield results' | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:1271:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 53) Elasticsearchable ActiveRecord/Elasticsearch data validation Aggregate counts for search grain 3, include 0 UPB | |
| Failure/Error: expect(search_results[0].size).to be > 0, "Search for SecuritizationName: #{securitization_name}, PropertyTypeMajor: Other, State: NY, Include0UPB:true yields no results" | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:1309:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 54) Elasticsearchable ActiveRecord/Elasticsearch data validation Aggregate counts for search grain 3, exclude 0 UPB | |
| Failure/Error: expect(search_results[0].size).to be > 0, "Search for SecuritizationName: #{securitization_name}, PropertyTypeMajor: Other, State: NY, Include0UPB:false does not yield results" | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:1362:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 55) Elasticsearchable ActiveRecord/Elasticsearch data validation Aggregate counts for search grain 4, include/exclude 0 UPB | |
| Failure/Error: expect(search_results[0].size).to be > 0, 'Search for SecuritizationName: bacm, TennantName: walgreens, Include0UPB:true yields no results' | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:1419:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 56) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, NoteName, LoanStatus, State (group/sum StandardizedBalance) | |
| Failure/Error: expect(search_results[0].size).to be > 0, 'Search for SecuritizationName: BACM, NoteName: building, LoanStatus: Perform(w), State: NY, Include0UPB:true yields no results' | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:1456:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 57) Elasticsearchable ActiveRecord/Elasticsearch data validation Property counts for SecuritizationName, State; include/exclude 0 UPB | |
| Failure/Error: expect(search_results[0].size).to be > 0, "Search for SecuritizationName: #{deal_name_with_0_upb}, State: NY, Include0UPB:true yields no results" | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:1505:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 58) Elasticsearchable ActiveRecord/Elasticsearch data validation Property counts for SecuritizationName, State; include/exclude 0 UPB; version 2 | |
| Failure/Error: expect(search_results[0].size).to be > 0, 'Search for SecuritizationName: BACM 2005-1, State: NY, Include0UPB:true does not yield results' | |
| NoMethodError: | |
| undefined method `size' for nil:NilClass | |
| # ./spec/integrations/elasticsearchable_spec.rb:1530:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 59) FactSecuritization methods #weighted_average_maturity returns a hash of results for a securitization: Current Crossed Loan Count is greater than or equal to at issuance | |
| Failure/Error: expect(weighted_average_maturity[:current]).to be >= weighted_average_maturity[:issuance] | |
| expected: >= #<BigDecimal:685d7d93,'105.34',5(8)> | |
| got: #<BigDecimal:51df736c,'25.8',3(4)> | |
| # ./spec/models/fact_securitization_spec.rb:103:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 60) CashFlow#get_prior_op_statements returns cash flow line items with prior op statement descriptions | |
| Failure/Error: expect(cash_flow.get_prior_op_statements(cash_flows).size).to eq(219) | |
| expected: 219 | |
| got: 212 | |
| (compared using ==) | |
| # ./spec/services/cash_flow_spec.rb:398:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 61) CashFlow#get_latest_op_statements returns cash flow line items with latest op statement descriptions | |
| Failure/Error: expect(cash_flow.get_latest_op_statements(cash_flows).size).to eq(216) | |
| expected: 216 | |
| got: 210 | |
| (compared using ==) | |
| # ./spec/services/cash_flow_spec.rb:409:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 62) CashFlow#get_occupancy_key returns occupancy key: 'MostRecentPhysicalOccupancy' when the period name is 'LatestAmt' | |
| Failure/Error: expect(cash_flow.get_occupancy_key('LatestAmt', prior_op_statements, latest_op_statements)).to eq('MostRecentPhysicalOccupancy') | |
| expected: "MostRecentPhysicalOccupancy" | |
| got: nil | |
| (compared using ==) | |
| # ./spec/services/cash_flow_spec.rb:440:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 63) CashFlow#get_year_label returns year label corresponding to value in the 'Latest_OpStmntTypeDsc' column when the period name is 'LatestAmt' | |
| Failure/Error: expect(cash_flow.get_year_label('LatestAmt', prior_op_statements, latest_op_statements)).to eq('Year to Date') | |
| expected: "Year to Date" | |
| got: nil | |
| (compared using ==) | |
| # ./spec/services/cash_flow_spec.rb:462:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 64) CashFlow#get_historical_occupancy_keys_array returns an array of historical occupancy keys | |
| Failure/Error: expect(cash_flow.get_historical_occupancy_keys_array(period_names, prior_op_statements, latest_op_statements)).to eq(historical_occupancy_keys) | |
| expected: [nil, "SecondPrecedingFiscalYearPhysicalOccupancy", "PrecedingFiscalYearPhysicalOccupancy", "MostRecentPhysicalOccupancy"] | |
| got: [nil, nil, "SecondPrecedingFiscalYearPhysicalOccupancy", "PrecedingFiscalYearPhysicalOccupancy"] | |
| (compared using ==) | |
| Diff: | |
| @@ -1,5 +1,5 @@ | |
| [nil, | |
| + nil, | |
| "SecondPrecedingFiscalYearPhysicalOccupancy", | |
| - "PrecedingFiscalYearPhysicalOccupancy", | |
| - "MostRecentPhysicalOccupancy"] | |
| + "PrecedingFiscalYearPhysicalOccupancy"] | |
| # ./spec/services/cash_flow_spec.rb:527:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 65) CashFlow#get_historical_year_labels_array returns an array of historical year labels | |
| Failure/Error: expect(cash_flow.get_historical_year_labels_array(period_names, prior_op_statements, latest_op_statements)).to eq(historical_year_labels) | |
| expected: ["Annual", "Annual", "Annual", "YTD"] | |
| got: ["Annual", "Annual", "Annual", "Annual"] | |
| (compared using ==) | |
| # ./spec/services/cash_flow_spec.rb:544:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 66) CashFlow#get_historical_start_dates_array returns an array of historical statement start dates | |
| Failure/Error: expect(cash_flow.get_historical_start_dates_array(cash_flows, statement_start_dates).to_s).to eq(historical_start_dates) | |
| expected: "[Sat, 01 Jan 2011 00:00:00 UTC +00:00, Sun, 01 Jan 2012 00:00:00 UTC +00:00, Tue, 01 Jan 2013 00:00:00 UTC +00:00, Wed, 01 Jan 2014 00:00:00 UTC +00:00]" | |
| got: "[Fri, 01 Jan 2010 00:00:00 UTC +00:00, Sat, 01 Jan 2011 00:00:00 UTC +00:00, Sun, 01 Jan 2012 00:00:00 UTC +00:00, Tue, 01 Jan 2013 00:00:00 UTC +00:00]" | |
| (compared using ==) | |
| # ./spec/services/cash_flow_spec.rb:562:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 67) CashFlow#get_historical_end_dates_array returns an array of historical statement end dates | |
| Failure/Error: expect(cash_flow.get_historical_end_dates_array(cash_flows, statement_end_dates).to_s).to eq(historical_end_dates) | |
| expected: "[Sat, 31 Dec 2011 00:00:00 UTC +00:00, Mon, 31 Dec 2012 00:00:00 UTC +00:00, Tue, 31 Dec 2013 00:00:00 UTC +00:00, Tue, 30 Sep 2014 00:00:00 UTC +00:00]" | |
| got: "[Fri, 31 Dec 2010 00:00:00 UTC +00:00, Sat, 31 Dec 2011 00:00:00 UTC +00:00, Mon, 31 Dec 2012 00:00:00 UTC +00:00, Tue, 31 Dec 2013 00:00:00 UTC +00:00]" | |
| (compared using ==) | |
| # ./spec/services/cash_flow_spec.rb:580:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 68) DealStratsClientBucket moves loans on Client LTV buckets when loan level assumption changes from less than 110% to more than 110% bucket | |
| Failure/Error: expect(deal_strats_client_bucket.strats_ltv[:client][:gt110p][:loans]).to eq(14) | |
| expected: 14 | |
| got: 13 | |
| (compared using ==) | |
| # ./spec/services/deal_strats_client_bucket_spec.rb:77:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 69) DealStratsClientBucket moves loans on Client DSCR buckets when loan level assumption changes from [0.75x - 1.00x] to [ > 0.75x] bucket | |
| Failure/Error: expect(deal_strats_client_bucket.strats_dscr[:client][:lt0_75x][:loans]).to eq(9) | |
| expected: 9 | |
| got: 8 | |
| (compared using ==) | |
| # ./spec/services/deal_strats_client_bucket_spec.rb:154:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 70) DealStratsClientBucket moves loans on Client Debt Yield buckets when loan level assumption changes from [6.0% - 7.0%] to [ < 6.0%] bucket | |
| Failure/Error: expect(deal_strats_client_bucket.strats_debt_yield[:client][:lt6p][:loans]).to eq(16) | |
| expected: 16 | |
| got: 15 | |
| (compared using ==) | |
| # ./spec/services/deal_strats_client_bucket_spec.rb:231:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| 71) PortfolioRefreshWorker#on_error testing private methods #create_loan_list_from_search_data to be an array | |
| Failure/Error: let(:create_loan_list_from_search_data) { new_refresher.send(:create_loan_list_from_search_data, run_elasticsearch_with_params[0]) } | |
| NoMethodError: | |
| undefined method `each' for nil:NilClass | |
| # ./lib/portfolio_refresh_worker.rb:73:in `create_loan_list_from_search_data' | |
| # ./spec/services/portfolio_refresh_worker_spec.rb:21:in `create_loan_list_from_search_data' | |
| # ./spec/services/portfolio_refresh_worker_spec.rb:49:in `(root)' | |
| # ./spec/rails_helper.rb:67:in `(root)' | |
| Finished in 8 minutes 51 seconds (files took 42.82 seconds to load) | |
| 937 examples, 71 failures, 1 pending |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment