SME Loan API Specification - v2.1.1

Version Control

Version
Date
Author
Comments
2.0.024 Jul 2017Open Banking Open Data API Team

This is the baseline version.

2.1.021 Aug 2017Open Banking Open Data API Team

This release incorporates all known issues with 2.0.0 up to 18 Aug 2017. Please see the release notes for details.

2.1.112 Oct 2017Open Banking Open Data API Team

For SME Loans, this release is identical to v2.1.0 API. Please see the 2.1.0  release notes for details. The MIG is from v2.2  (as recommended by PMG)

Overview

This specification includes all relevant artefacts for the Open Data Business SME Unsecured Loans (SME) API Specification.

Currently, price comparison websites have to obtain their SME Business Loan product data either via bank proprietary APIs, via information collected by dedicated data capture agencies or via "screen scraping" (i.e. capturing product web page information and writing scripts to extract relevant data). This work is complex and prone to error, so having a standard API would make the data capture side much easier and allow more third party providers to provide applications that could target particular consumer markets.

This endpoint can contain multiple brands owned by a particular banking group. Each brand can own multiple SME Unsecured Loan products.

Loan

This section covers SME Unsecured Loan attributes that will change only under rare circumstances (see CoreProduct section for additional attributes that will be updated regularly). 

The following information can be provided:-

  • Product Name i.e. the name marketed to the consumers.
  • Identification is the unique id created by the financial institution to internally define the product
  • Segment - allows specification of the type of product e.g. basic, regular, premium

MarketingState

Within our design, we have a concept of a "marketing state" for the product. This concept is required because for any "On Sale" SME Unsecured Loan product:-

  1. The loan may provide a different offering to the SME loan holder the longer that they hold the product - covered by StateTenureLength & StateTenurePeriod in the example below.
  2. The financial institution can change any of the Loan attributes that are marketed over time - covered by FirstMarketedDate and LastMarketedDate in the example below.

We'll illustrate this with the following example. 

CMA9Bank has an SME Unsecured Loan product that was first advertised and marketed on 1/1/2017 and has the following features currently:-

  1. If the accountholder takes the product, they are offered a promotional interest rate of 3% for 1st 9 months, then 5% for next 12 months and then it reverts back to the standard variable rate (e.g. 14.9%).

The original marketing states can be shown as follows:-

Identification

PredecessorID

MarketingState

FirstMarketedDate

 LastMarketedDate

StateTenureLength

StateTenurePeriod

Notes 

CP1
Promotional1/1/201731/12/9999 9 MonthOn taking out the loan the initial promotional offer lasts 9 months. Attached to this state will be the original initial promotional interest rate information.
CP2CP1Promotional1/1/201731/12/9999  12 Month9 months into the loan duration, the customer will receive a 2nd promotional offer lasting 12 months
CR1CP2Regular1/1/201731/12/9999   After the 2nd promotional period has expired, the accountholder will be moved to the regular interest rate.

On 17th July, CMA9Bank are going to change the offer, so that only 0.3% is paid in the 1st 9 months. The marketing states on 16th July will look like this:-

Identification

PredecessorID

MarketingState

FirstMarketedDate

 LastMarketedDate

StateTenureLength 

StateTenurePeriod

Notes 

CP1
Promotional1/1/2017 16/7/2017 9 MonthOn taking out the loan the initial promotional offer lasts 9 months. Attached to this state will be the original initial promotional interest rate information.
CP2CP1Promotional1/1/201731/12/9999  12 Month9 months into the loan duration, the customer will receive a 2nd promotional offer lasting 12 months
CR1CP2Regular1/1/201731/12/9999   After the 2nd promotional period has expired, the accountholder will be moved to the regular interest rate.
CP3
Promotional 17/7/2017  31/12/9999 9Month On taking out the loan the initial promotional offer lasts 9 months. Attached to this, will be the revised initial promotional offer interest rate information.

And on the 17th July, the marketing states will look like this:-

Identification

PredecessorID

MarketingState

FirstMarketedDate

LastMarketedDate

StateTenureLength 

StateTenurePeriod

Notes 

CP2CP3Promotional1/1/201731/12/9999  12 Month9 months after the account has been opened, the customer will receive a 2nd promotional offer lasting 12 months
CR1CP2Regular1/1/201731/12/9999   After the 2nd promotional period has expired, the accountholder will be moved to the regular interest rate.
CP3 Promotional 17/7/2017  31/12/9999 9Month On taking out the loan the initial promotional offer lasts 9 months. Attached to this, will be the revised initial promotional offer interest rate information.

Notes:

  1. PredecessorID is used to sequence the creditinterest states offered to the customer when they take out the Loan, it does not record change history.
  2. FirstMarketedDate and LastMarkedDate cover the period when the particular marketing state was advertised to the customer.
  3. CMA9 Banks only have to provide information for current (and known future, if they wish) marketing states. There is no open data requirement to provide an audit history of all marketing states that ever applied to the Loan. When the future marketing state becomes the current marketing state, the original marketing state information no longer needs to be published.
  4. When CP1 Marketing state is replaced by CP3 Marketing state, the PredecessorID in CP2 will also need to be updated to point to CP3, as shown.
  5. The Identification column is simply for internal bank use. The ID column is required so that we can sequence states.

Core Product

This sections includes information that can change relatively often. Information to be provided includes:-

  • Product URL allows a link to the financial institution's website where more detail about the product can be found
  • URL to the product's terms & conditions
  • Sales Access Channels cover all of the channels by which a customer can be sold a BCA 
  • Servicing Access Channels cover all of the channels by which a customer can receive service for their BCA. Note: This covers servicing of all aspects of the BCA. Some aspects may not be serviceable via certain channels.
  • MonthlyCharge covers any monthly servicing charge that a financial institution may make to a BCA accountholder

Loan Interest

In this section, information about the interest rates that are payable by the SME to the Lender are listed. This section contains headline Representative APR info to be used on comparison websites.

Interest rates are typically standard variable rates, with rates potentially changing during the course of the product lifecycle. In addition to the 'Regular' standard variable rates, some Loan products also provide for more attractive 'Promotional' interest rates which are fixed for a relatively short duration. (see MarketingState section above as to how to represent these). 

Loan Repayment

This section allows information to be provided about loan repayment and related fees/charges. Common fees and charges include:-

  1. Early repayment charges

  2. Overpayments with/without extra charges

  3. Interest applicable

  4. Loan setup/arrangement fee

  5. Legal cost fee

  6. Late Payment Fee

  7. BorrowingItem (Return Fees)

Eligibility

In this section, criteria such as residency and trading history restrictions that are necessary for taking out an SME Unsecured Loan product are provided. 

Note: eligibility criteria for features & benefits are treated in that section itself (see below). 

Features & Benefits

In this section, information about any inherent product features or value-added benefits (whether they're charged or not) can be captured.

Benefits can also be grouped together e.g. if a package of benefits is supplied. For any benefits group, benefit details may be individually added or notes simply added to the benefits group. 

For a benefits group or for individual benefits, any eligibility criteria required to obtain that benefit can be specified as notes.

Other Fees & Charges 

Key Fees & Charges that a customer has to pay can be specified in the Core Product, Loan Repayment and Features & Benefits sections (see above).

The long tail of additional fees & charges that are not associated to either of these areas can be specified in this section.

Specification

The following UML Class Diagram provides the hierarchical structure of the message in a graphical form, which is easier to digest.


  • Data Dictionary - provides detailed descriptions for each field in the message specification along with the associated code lists, constraints and other technical details such as cardinality, any pattern constraints, min, max length etc.
  • Swagger - the API specification written using the Swagger API specification format (some known issues which will be fixed in v2.1.0).

Compliance Report

Message Implementation Guide

Purpose

The message implementation guide (MIG) is designed to assist the implementers of the messaging specification by providing worked examples as to how the message fields should be completed in different scenarios.

The intention is that this will better ensure consistency. This guide should be read alongside the data dictionary which provides fuller information about the rules, constraints and guidelines that should be adhered to when populating the fields.

We are choosing different accounts based on how fully they test each section of the design.

OtherFeesAndCharges isn’t covered by the use cases due to these currently being bank proprietary fees/charged and not standardised currently. Key standardised Fees and Charges covering overdraft and benefits are covered in the relevant examples stated above, however.

Format Notation

The format that we use in this document for field value assignment is:-

[] enclose a set of field values.

Where there are multiple records for a particular field, we depict this as [<record 1 value1>,< record 1 value2>…<recordn valuen>], whilst where we are showing that there is 1 field value in 1 record, and another field value in a 2nd record, I depict this as [<record1 value1>],[<record 2 value 1>],[<record 3 value 3>]

, seperates individual field values within a field value set.

“ surrounds a text or date field value.


Implementation Notes

Before implementing the message standard, it is very useful browsing the current market leading price comparison websites (e.g. https://www.moneysupermarket.com/business-finance/business-lending/medium-to-long-term-business-loans/http://www.knowyourmoney.co.uk/business-loans/  to understand how implementation of our standard by the CMA9 banks would help to more easily facilitate provision of information used on those sites.

Currently, price comparison websites have to obtain their  SME Loan product data either via bank proprietary APIs, via information collected by dedicated data capture agencies or via "screen scraping" (i.e. capturing product web page information and writing scripts to extract relevant data). This work is complex and prone to error, so having a standard API would make the data capture side much easier and allow more third party providers to provide applications that could target particular consumer markets.


 SME Loan v2.2 Top Level Design

Section NumberField NameCardinalityValue(s)
1BrandName1..1"Santander UK"
 How I can supply fixed and variable core product details??

Section NumberField NameCardinalityValue(s)
1BrandName1..1

“Lloyds Bank plc”

2Name1..1“Base Rate Loan”
2Identification1..1“Base RateLoan123”
2Segment1..1“Business”
3Identification1..1“R1”
3PredecessorID0..1[][“P1”]
MarketingState1..1“Regular”
FirstMarketedDate0..1“1/1/1990”
3LastMarketedDate0..1“31/12/9999”
3StateTenureLength0..1 3
StateTenurePeriod0..1 “Years”
Notes 0..*"Base Rate Loan is a flexible finance option that can be tailored to suit your short or long-term financial goals. It is linked to the Bank of England bank rate so the interest rate that you pay will change as the bank rate changes, resulting in your monthly repayments increasing or decreasing"
ProductURL1..1 http://www.lloydsbank.com/business/retail-business/loans-and-financing/loans/base-rate-business-loan.asp?WT.ac=RBB_Loans_Base_FOM”
TcsAndCsURL1..1 http://www.lloydsbank.com/business/retail-business/loans-and-financing/loans/base-rate-business-loan.asp?WT.ac=RBB_Loans_Base_FOM#tab-row-4”
SalesAccessChannels1..*[“Branch”,”Online”]
4ServicingAccessChannels1..*[“Branch”,”Online”,”Post”,”Phone”]
EarlyPaymentFeeApplicable 1..1 "Y"
OverPaymentFeeApplicable1..1"Y"
LoanApplicationFeeChargeType1..1”ChargedIrrespectiveOfLoanApproval”
OverpaymentAllowedIndicator0..1 “Y”
FullEarlyRepaymentAllowedIndicator0..1 “Y”
Notes 
 


Example: Lloyds Base Rate Loan

http://www.lloydsbank.com/business/retail-business/loans-and-finance.asp

 How I can publish Whole/Tiered APR and No arrangement Fee?

Section NumberField NameCardinalityValue(s)
1Notes

2TierBandMethod1..1

“Whole”

2Identification0..1"1"
CalculationMethod1..1 [“Compound”,”SimpleInterest”]
Notes
 
3Identification0..1 "1"
TierValueMinAmount1..10
TierValueMaxAmount1..125000
TierValueMinTerm1..112 
3MinTermPeriod1..1“Month”
TierValueMaxTerm1..110 
3MaxTermPeriod1..1“Year” 
FixedVariableInterestRateType1..1“Fixed”
3RepAPR1..1 “7.4”
LoanProviderInterestRateType0..1“Gross”
OtherLoanProviderInterestType  
3LoanProviderInterestRate0..1 7.1
Notes
 

Example: HSBC Small Business Loan

http://www.business.hsbc.uk/en-gb/finance-and-borrowing/credit-and-lending/small-business-loan

 How I can publish tiered APR and tiered arrangement Fee?

Section NumberField NameCardinalityValue(s)
1Notes

2TierBandMethod1..1

“Tiered”

2Identification0..1"1"
CalculationMethod1..1 [“Compound”,”SimpleInterest”]
Notes
 
3Identification0..1 "1"
TierValueMinAmount1..1[0],[50001], [10001],[15001],[20001]
TierValueMaxAmount1..1[50000], [10000], [15000],[20000], [25000]
TierValueMinTerm1..11
3MinTermPeriod1..1“Year”
TierValueMaxTerm1..110 
3MaxTermPeriod1..1“Year” 
FixedVariableInterestRateType1..1 “Variable”
3RepAPR1..1“7.4”
LoanProviderInterestRateType0..1 “LinkedBaseRate”
OtherLoanProviderInterestType  
3LoanProviderInterestRate 
Notes
 

Example: Lloyds  Base Rate Loan

http://www.lloydsbank.com/business/retail-business/loans-and-financing/loans/base-rate-business-loan.asp?WT.ac=RBB_Loans_Base_FOM#tab-row-3

 How I can publish tiered APR and tiered arrangement Fee? Continued..

Section NumberField NameCardinalityValue(s)
1FeeType1..*“Arrangement Fee”
1OtherFeeType

1MinMaxType1..1“Minimum”
FeeCapOccurrence  
FeeCapAmount0..1250
1CappingPeriod0..1 “OnOpening”
1Notes
 
FeeType1..1“Arrangement Fee”
OtherFeeType  
NegotiableIndicator  
FeeAmount0..1[100], [175], [250]
FeeRate0..1[1.5], [1.0]
2FeeRateType0..1“Gross”
OtherFeeRateType  
ApplicationFrequency1..1“OnOpening” 
OtherApplicationFrequency  
CalculationFrequency1..1“OnOpening” 
2OtherCalculationFrequency  
Notes
 

Example: Lloyds Fixed Rate Loan

 What if I wish to prepay(i.e. Overpay) the loan?

Section NumberField NameCardinalityValue(s)
1RepaymentType0..1“CapitalAndInterest”
1OtherRepaymentType

1RepaymentFrequency0..1“Monthly”,” Quarterly”
1OtherRepaymentFrequency

1AmountType0..1“CapitalAndInterest”
1OtherAmountType  
1Notes
 
2MaxHolidayLength0..13
MaxHolidayPeriod0..1“Month”
Notes  
FeeType1..1“PrepaymentFee”
OtherFeeType  
NegotiableIndicator  
3FeeAmount  
FeeRate0..11
3FeeRateType0..1“Gross”
3OtherFeeRateType  
3ApplicationFrequency1..1“PerOccurrence”
3OtherApplicationFrequency  
3CalculationFrequency1..1“PerOccurrence”
OtherCalculationFrequency  
Notes 0..* "Minimum 1% of sum repaid”


Example: HSBC Flexible Business Loan

http://www.business.hsbc.uk/en-gb/finance-and-borrowing/credit-and-lending/small-business-loan

www.business.hsbc.uk/-/media/library/business-uk/.../business-banking-pricelist.pdfCached

 What if I wish to repay the loan early?

Section NumberField NameCardinalityValue(s)
1RepaymentType0..1“EarlyRepayment”
1OtherRepaymentType

1RepaymentFrequency0..1“Monthly”,” Quarterly”
1OtherRepaymentFrequency

1AmountType0..1  “BalanceToDate”
1OtherAmountType  
1Notes
 
2MaxHolidayLength0..1  3
MaxHolidayPeriod0..1  “Month”
Notes
 
FeeType1..1  “EarlyRepayment”
OtherFeeType  
NegotiableIndicator  
3FeeAmount  
FeeRate0..1  1
3FeeRateType0..1  “Gross”
3OtherFeeRateType  
3ApplicationFrequency1..1  “OnClosing”
3OtherApplicationFrequency  
3CalculationFrequency1..1 “OnClosing”
OtherCalculationFrequency  
Notes0..* “1% of the amount prepaid, multiplied by the number of full years remaining”


Example: HSBC Flexible Business Loan

http://www.business.hsbc.uk/en-gb/finance-and-borrowing/credit-and-lending/small-business-loan

 What if I wish to restrict who can apply for the account?

Section NumberField NameCardinalityValue(s)
 1MinimumAge0..1 18 
 1

MaximumAge

  
 1Notes
 
2ResidencyType0..1"Owner"
2OtherResidencyType  
2ResidencyIncluded1..*"GB"
Notes
 
3TradingType0..1 [“PreviousBankruptcyAllowed”][“PreviousCCJs”]
MinMaxType   
Amount  
Indicator0..1 [False][False]
Textual  
3Period   
3Notes
 
LegalStructure   
4OtherLegalStructure  
4Notes 
 
URL   
5Notes 
 
ScoringType  
Notes0..*“You must agree to a credit check as part of the application and this will determine whether or not you're accepted and the credit limit that we can offer.”

Example: RBS Business Loan

https://www.business.rbs.co.uk/business/business-lending-at-royal-bank/applying-online-sole-trader.html

Eligibility requirements
•Require the loan for business use
•Apply for a minimum of £1,000
•Be a sole trader, partner or director with authority to borrow on behalf of your business
•Be aged 18 or over
•You are not currently declared as bankrupt, received a County Court Judgement (CCJ) or Court Decree.

 What about Key “Other Fees And Charges”?

Section NumberField NameCardinalityValue(s)
1FeeType1..*“MissedPaymentFee”
1OtherFeeType

1FeeMinMaxType1..1“Minimum”
FeeCapOccurrence  
1FeeCapAmount  
CappingPeriod  
Notes
 
2FeeCategory  
FeeType 1..1  “LatePayment”
2OtherFeeType  
NegotiableIndicator  
FeeAmount  
2FeeRate  
2FeeRateType   
2OtherFeeRateType  
2ApplicationFrequency 1..1 “Monthly”
2OtherApplicationFrequency  
CalculationFrequency 1..1 “Monthly”
Notes  

Example: GOV.UK:Late commercial payments: charging interest and debt recovery

https://www.gov.uk/late-commercial-payments-interest-debt-recovery/charging-interest-commercial-debt