Set Up Decision Matrices to Determine the Maximum Eligible Amount for a Secured Loan
Set up decision matrices and then build an expression set to automate the calculation of the maximum eligible amount for a secured loan.
Required Editions
| Available in: Lightning Experience |
| Available in: Professional, Enterprise, and Unlimited Editions |
| User Permissions Needed | |
|---|---|
| To create, update, and delete decision matrices and expression sets: | Rule Engine Designer |
| To use decision tables in Business Rules Engine: | Rules Engine Runtime |
-
To determine the maximum eligible amount for a secured loan based on credit score, create a
decision matrix.
If you already created the decision matrix to determine the credit score category, you can skip this step.
-
To determine the maximum eligible amount for a secured loan based on the requested term in
months, create another decision matrix.
- Enter Requested Term Category as the name of the decision matrix
-
Create two columns with these settings.
Column Header Header Type Data Type RequestedTerm Input Number Range RequestedTermCategory Output Text -
Add these sample rows and values.
RequestedTerm RequestedTermCategory 0 Short 36 Medium 100 Long You can add more rows and values to suit your business needs.
- Save your changes and activate the decision matrix.
-
To determine the maximum eligible amount for a secured loan based on the applicant's annual
income, create another decision matrix.
- Enter Annual Income Category as the name of the decision matrix.
-
Create two columns with these settings.
Column Header Header Type Data Type AnnualIncome Input Number Range AnnualIncomeCategory Output Text -
Add these sample rows and values.
AnnualIncome AnnualIncomeCategory 0 Low 500000 Medium 150000 High You can add more rows and values to suit your business needs.
- Save your changes and activate the decision matrix.
-
To determine the maximum eligible amount for a secured loan based on the applicant’s age,
create another decision matrix.
- Enter Age Category as the name of the decision matrix.
-
Create two columns with these settings.
Column Header Header Type Data Type Age Input Number Range AgeCategory Output Text -
Add these sample rows and values.
Age AgeCategory 18 Young 32 Middle-Aged 60 Senior Citizen You can add more rows and values to suit your business needs.
- Save your changes and activate the decision matrix.
-
To determine the maximum eligible amount for a secured loan based on credit score category,
requested term category, income type, risk category, age category, employment type, loan type,
PIN code, product name, debt to income ratio, income to expense ratio, and loan to value ratio,
create another decision matrix.
- Enter Secured Loan Eligibility Amount as the name of the decision matrix.
-
Create these columns with these settings.
Column Header Header Type Data Type CreditScoreCategory Input Text EmploymentType Input Text IncomeType Input Text RiskCategory Input Text LoanType Input Text ProductName Input Text RequestedTermCategory Input Text Pincode Input Number AgeCategory Input Text TotalDebtToIncomePercent Input Number Range TotalLoanToValuePercent Input Number Range TotalIncomeToExpenseRatio Input Number Range TotalCollateralValue Input Currency MaximumEligibleAmount Output Currency -
Add rows and values based on your business needs.
Here's a sample decision matrix.
- Save your changes and activate the decision matrix.
Note- Make sure that your users populate the debt to income and income to expense ratios manually in the application form to determine the maximum eligibility amount.
- Make sure that you map the table’s output variables to the resources from the expression set version. See Variable Mapping in Lookup Tables.
After you create the decision matrices, reference them from the Determine Secured Loan Maximum Eligible Amount expression set. The FetchAmounttSecuredloans expression set action in the DigitalLendingIndiaGetEligiblityAmount integration procedure calls this expression set to determine the maximum eligibility amount for a secured loan. The DigitalLendingIndiaGetEligiblityAmount integration procedure is referenced in the DigitalLendingIndiaGetMaximumEligiblityAmount Omniscript.


