Loans data model diagrams

The entities in the entity-relationship diagrams on this page derived from the FIBO Q3-2023 LOANS ontologies.

The diagram shows the structure of the FIB-DM packages, which is the same as the FIBO structure of ontologies. Loans General entities define business content applicable to all types of loan, whereas Loan-Specific packages model content for Cards, Student– and Consumer loans.

A diagram showing the hierarchy of Loan packages in the FIBO Data Model.
FIB-DM LOANS packages

The E/R diagrams in the gallery depict the entities in the four packages. You can click on a gallery diagram to open the scalable vector graphic (SVG) in a new browser tab.

Supertypes and relationships reused for other business areas (e.g., Bonds) are defined in Foundation, Business Entities, and Finance Business & Commerce.

Loans General

The package for data model objects derived from the Loans ontology module. This ontology is the top-level, and most fundamental ontology for the LOAN module, extending the Debt ontology to define concepts common to all loans. It includes the primary obligations to fund the loan and to pay it back according to payment schedules. Kinds of loans covered in this ontology include open and closed end, secured and unsecured.

Debt, Foundation, and other FIB-DM packages provide the Associative Entities connecting “island” entities like the Payment Schedule in this package diagram to the Loan.

Cards

The Card Accounts package diagram depicts the entities derived from the FIBO Cards ontology.

This ontology defines revolving credit account-related concepts that are specific to credit and debit cards. Note that it does not differentiate between consumer and commercial/corporate cards and is capable of representing either.

Consumer Loans

The consumer loans ontology defines concepts specific to loans offered only to consumers rather than organizations, primarily for personal, family, or household purposes.
A Consumer Loan breaks down into subtypes: unsecured and Secured Consumer Loans, currently Car and Home loans. The Consumer Loan has a Borrower, typically restricted to individuals. The Loan is collateralized by Physical Collateral (the car or house,) defined in the Finance, Business & Commerce/Debt & Equity package. An asset Pool, defined in the Asset Backed Securities package may have the Loan as a Constituent.

Student Loans

Student Loans can be Regulated, where the lender is a government entity or non-profit, or private, without any special regulations. The loan has a Borrower, the student. An Asset-Backed Securities Pool, defined in the Debt package, may have the Student Loan as a Constituent.


Entity Definitions

The table lists the Name, Code, and Definitions of the entities in the data model diagrams. The stereotype Associative Entity, in blue, derived from FIBO object properties.

NameCodeDefinitionStereotype
Closed End Creditfibo-loan-ln-ln:ClosedEndCreditCredit agreement in which the loan principal cannot be increased after funds are dispersed in full when the loan closes
Collateralized Loanfibo-loan-ln-ln:CollateralizedLoanSecured loan that is secured with cash or other acceptable collateral (real property, securities or other assets) provided by the borrower as specified in the collateral agreement
Comakerfibo-loan-ln-ln:ComakerParty that signs a borrower’s promissory note, providing additional security and potentially improving the quality of the debt
Combined Loan To Value Ratiofibo-loan-ln-ln:CombinedLoanToValueRatioRatio of the total amount of debt that is secured by the asset(s) and the appraised value of the asset(s) securing the financing
Guaranteed Loanfibo-loan-ln-ln:GuaranteedLoanLoan that is secured with respect to repayment of principal and interest by guaranty
has Costfibo-loan-ln-ln:hasCostHas amount payable for principal, interest, fees or other expensesAssociative Entity
has Credit Limitfibo-loan-ln-ln:hasCreditLimitSpecifies the maximum amount of funds that may be borrowed (e.g. for line of credit)Associative Entity
has First Rate Change Termfibo-loan-ln-ln:hasFirstRateChangeTermSpecifies a period of time in months after origination during which the interest rate cannot changeAssociative Entity
has Individual Paymentfibo-loan-ln-ln:hasIndividualPaymentLinks an actual payment of principal, interest, and other related amounts to the overall payment history for an accountAssociative Entity
has Loan Balancefibo-loan-ln-ln:hasLoanBalanceIndicates the balance with respect to the principal on the loan as of some dateAssociative Entity
has Payment Historyfibo-loan-ln-ln:hasPaymentHistoryRelates a credit agreement, loan, or commitment to any history of payments that have been made by the borrower up to the point that payment history is requestedAssociative Entity
has Pre Payment Penalty Termfibo-loan-ln-ln:hasPrePaymentPenaltyTermRelates a loan to a period of time in months after which there is no prepayment penaltyAssociative Entity
has Principal Amountfibo-loan-ln-ln:hasPrincipalAmountIndicates the notional amount of the contractAssociative Entity
has Scheduled Unpaid Balancefibo-loan-ln-ln:hasScheduledUnpaidBalanceIndicates what the balance should be after a scheduled payment is made according to contract termsAssociative Entity
has Total Closing Costsfibo-loan-ln-ln:hasTotalClosingCostsIndicates the total the amount paid at the closing of a real estate transaction, i.e., at the time when the title to the property is conveyed (transferred) to the buyerAssociative Entity
has Total Points And Feesfibo-loan-ln-ln:hasTotalPointsAndFeesIndicates a form of pre-paid interest, charged by the lender as an alternative to charging a higher rate of interest on the mortgage loanAssociative Entity
Individual Payment Transactionfibo-loan-ln-ln:IndividualPaymentTransactionActual payment of principal, interest, fees, or other related amounts towards fulfillment of a debt obligation
is Serviced Byfibo-loan-ln-ln:isServicedByRelates a loan to the financial service provider that services itAssociative Entity
Lender Lien Positionfibo-loan-ln-ln:LenderLienPositionClassifier indicating whether the lender has the primary lien position with respect to an asset used as collateral for the loan
Loanfibo-loan-ln-ln:LoanDebt instrument whereby one party extends money or credit to another party (or parties) with the understanding that the borrowed money will be repaid according to the terms of the contract
Loan Payment Schedulefibo-loan-ln-ln:LoanPaymentScheduleRegular payment schedule associated with a given loan-specific account
Loan Principalfibo-loan-ln-ln:LoanPrincipalNotional value of the loan that must be paid at or before maturity
Loan Specific Customer Accountfibo-loan-ln-ln:LoanSpecificCustomerAccountAccount held by the borrower associated with a specific loan
Loan To Value Ratiofibo-loan-ln-ln:LoanToValueRatioRatio, expressed as a percentage, between the principal amount of the loan and the appraised value of the asset securing the financing
Open End Creditfibo-loan-ln-ln:OpenEndCreditCredit agreement that may be extended up to an agreed credit limit and paid down at any time within the period of the line, if any, and on which interest is charged only on the outstanding balance
Ownership Interestfibo-loan-ln-ln:OwnershipInterestClassifier indicating the nature of the applicant’s or borrower’s ownership or leasehold interest in an asset used as collateral for the loan
Payment Historyfibo-loan-ln-ln:PaymentHistoryRecord of actual payments of principal, interest, and other related amounts made by a borrower to a lender or servicer in order to fulfill their re-payment obligation
Prepayment Termsfibo-loan-ln-ln:PrepaymentTermsPrincipal repayment terms related to payment of the loan prior to maturity
Secured Loanfibo-loan-ln-ln:SecuredLoanLoan in which the borrower pledges some asset via a security agreement as collateral for the loan, or that is secured via third-party guarantee
Security Agreementfibo-loan-ln-ln:SecurityAgreementAgreement between parties that contains information about their relative duties and rights regarding the disposition of a specified asset used as collateral
Servicerfibo-loan-ln-ln:ServicerParty that collects principal and interest payments on behalf of the lender
Unsecured Loanfibo-loan-ln-ln:UnsecuredLoanLoan granted based on the strength of the borrower’s credit history or reputation in the community
Consumer Loanfibo-loan-spc-cns:ConsumerLoanLoan to one or more individuals for household, family, or other personal expenditures, excluding mortgages and student loans
Home Equity Line Of Creditfibo-loan-spc-cns:HomeEquityLineOfCreditLine of credit granted to a homeowner secured by the equity value in a borrower’s home or other property
Motor Vehicle Loanfibo-loan-spc-cns:MotorVehicleLoanCollateralized, simple-interest loan that is repaid in monthly installments over a period of typically three to five years, for the purpose of purchasing a vehicle
Secured Consumer Loanfibo-loan-spc-cns:SecuredConsumerLoanLoan to one or more individuals for household, family, or other personal expenditures in which the borrower pledges some asset via a security agreement as collateral for the loan, or that is secured via third-party guarantee
Unsecured Consumer Loanfibo-loan-spc-cns:UnsecuredConsumerLoanLoan to one or more individuals for household, family, or other personal expenditures granted based on the strength of the borrower’s credit history or reputation in the community
Card Accountfibo-loan-spc-crd:CardAccountAccount whose terms and conditions are defined in a card agreement that is represented by a payment card
Card Authentication Valuefibo-loan-spc-crd:CardAuthenticationValueCard verification value specifically for JCB payment cards
Card Authentication Value2fibo-loan-spc-crd:CardAuthenticationValue2Card verification value specifically for JCB payment cards
Card Expiration Datefibo-loan-spc-crd:CardExpirationDateDate on which a given payment card expires
Cardholderfibo-loan-spc-crd:CardholderAccount holder to whom a payment card is issued
Card Identification Numberfibo-loan-spc-crd:CardIdentificationNumberCard verification value specifically for American Express and Discover payment cards
Card Productfibo-loan-spc-crd:CardProductFinancial product involving the issuance of credit, debit, or other payment cards
Card Security Codefibo-loan-spc-crd:CardSecurityCodeCard verification value specifically for American Express payment cards
Card Validation Codefibo-loan-spc-crd:CardValidationCodeCard verification code specifically for Mastercard payment cards
Card Validation Code2fibo-loan-spc-crd:CardValidationCode2Card verification value specifically for Mastercard payment cards
Card Verification Code Valuefibo-loan-spc-crd:CardVerificationCodeValueCode that specifies either (1) magnetic-stripe data, or (2) printed security features that are used to protect data integrity and limit alteration, counterfeiting and fraud generally
Card Verification Valuefibo-loan-spc-crd:CardVerificationValueCard verification value specifically for Visa and Discover payment cards
Card Verification Value2fibo-loan-spc-crd:CardVerificationValue2Card verification value specifically for Visa payment cards
Commercial Credit Card Agreementfibo-loan-spc-crd:CommercialCreditCardAgreementCredit card agreement for a card issued to, or in conjunction with, a formal organization, such as a small business, middle market business, local, state, or national government, or large corporation
Consumer Credit Card Agreementfibo-loan-spc-crd:ConsumerCreditCardAgreementCredit card agreement for a card issued for household, family, or other personal expenditures that is accessed by a borrower’s use of a credit card
Credit Cardfibo-loan-spc-crd:CreditCardCard issued by a financial service provider that enables the cardholder to borrow funds
Credit Card Accountfibo-loan-spc-crd:CreditCardAccountCard account whose terms and conditions are defined in a credit card agreement that is represented by a credit card
Credit Card Agreementfibo-loan-spc-crd:CreditCardAgreementAccount-specific credit facility that specifies the terms and conditions under which the credit card is offered to the cardholder by the issuer
Credit Card Networkfibo-loan-spc-crd:CreditCardNetworkClassifier for the network that authorizes, processes, and sets the terms of credit card transactions, as well as transfers payments between shoppers, merchants, and their banks
Credit Card Productfibo-loan-spc-crd:CreditCardProductCard product allowing the holder to purchase goods or services on credit
Debit Cardfibo-loan-spc-crd:DebitCardPayment card issued by a financial service provider that enables the cardholder to access funds in a demand deposit account
Debit Card Accountfibo-loan-spc-crd:DebitCardAccountCard account that is represented by a one or more debit cards
Debit Card Productfibo-loan-spc-crd:DebitCardProductCard product card typically provided by a depository institution allowing the holder to transfer money electronically to another account when making a purchase
has Card Verification Codefibo-loan-spc-crd:hasCardVerificationCodeLinks a credit card to either: (1) magnetic-stripe data, or (2) printed security features that are used to protect data integrity and limit alteration, counterfeiting and fraud generallyAssociative Entity
has Credit Card Networkfibo-loan-spc-crd:hasCreditCardNetworkIndicates the underlying network for credit card productAssociative Entity
has Primary Account Numberfibo-loan-spc-crd:hasPrimaryAccountNumberSpecifies the account number displayed on the face of the cardAssociative Entity
Issuing Financial Institutionfibo-loan-spc-crd:IssuingFinancialInstitutionIssuer and financial services provider that issues payment cards or performs, facilitates, or supports issuing services including but not limited to issuing banks and issuing processors
Magnetic Stripe Verification Code Valuefibo-loan-spc-crd:MagneticStripeVerificationCodeValueCard verification code on a card’s magnetic stripe that uses secure cryptographic processes to protect data integrity on the stripe, and reveals any alteration or counterfeiting
Payment Cardfibo-loan-spc-crd:PaymentCardLegal document issued by a financial services provider that enables the cardholder to access the funds in the customer’s designated bank accounts, or through a credit account and make payments by electronic funds transfer and access automated teller machines (ATMs)
Payment Card Agreementfibo-loan-spc-crd:PaymentCardAgreementAccount-specific credit agreement that specifies the terms and conditions under which the payment card is offered to the cardholder by the issuer
Primary Card Account Numberfibo-loan-spc-crd:PrimaryCardAccountNumberComposite identifier of 14 or 16 digits embossed on a bank or payment card and encoded in the card’s magnetic strip
Smart Cardfibo-loan-spc-crd:SmartCardPayment card that has integrated circuits embedded within it
Three Digit Verification Code Valuefibo-loan-spc-crd:ThreeDigitVerificationCodeValueCard verification code that is the rightmost three-digit value printed in the signature panel area on the back of the card
uses Currencyfibo-loan-spc-crd:usesCurrencyIndicates the currency defined for the credit card productAssociative Entity
Private Student Loanfibo-loan-spc-stu:PrivateStudentLoanStudent loan that is not considered a government-backed / regulated loan
Regulated Student Loanfibo-loan-spc-stu:RegulatedStudentLoanStudent loan (1) whose lender is a government agency or instrumentality, and/or (2) that is treated uniquely due to tax regulations
Student Loanfibo-loan-spc-stu:StudentLoanLoan provided for the purposes of education, allowing students and parents/guardians to borrow money for college