The alerts can be in the form of email, RTAM, or database updates. The use case covers the basic usage of RulePoint objects and a high-level flow based on the proposed rules.

The use cases employ the following objects to implement a solution for evaluating the loan eligibility criteria:

SQL Source. Connects to a database and executes SQL queries or commands to create RulePoint events. The SQL source publishes an event for each row returned from an SQL query.
SQL Responder. Responds to events by connecting to a database and executing SQL commands.
SQL Analytic. Runs an SQL query or command against a target database to enrich the data to provide additional information during rule processing that is not available in the event data.
Custom Analytic. Analyzes data within a system and implements a data processing function. The custom analytic takes data in day format and returns the data in years format.
Advanced Rules. The Detect and Respond Query Language (DRQL) syntax of RulePoint that consists of the WHEN, WITH, and THEN clauses that define the rule.
Topics. Categorizes events and their properties. When RulePoint receives an event, RulePoint identifies its properties and values and categorizes it under a specific topic.

The following loan processing use cases are represented in this document:

Decide loan eligibility based on applicant salary and all availed loans
Decide loan eligibility based on applicant age and repayment tenure
Decide loan eligibility based on applicant salary and collateral security
Decide loan eligibility based on the net salaried income of a couple

The high-level workflow for each of the use case involves the SQL sources that retrieve data from the SQL tables of a database and store it as RulePoint topics. The use cases represented in this document use different SQL sources, such as customer_financial_info_source, customer_personal_info_source, customer_family_info_source, and customer_loan_request_info_source to send information to the corresponding RulePoint topics. The RulePoint topics identify the event properties and values and group them under a specific topic. The value of each field in the table corresponds to the value in the property.

Based on the type of evaluation configured, the advanced rules pick the information from the topics and process them. The processing is based on the proposed rules. Rules evaluate whether the customer is eligible for the loan, and sends this information to the corresponding tables using the SQL responders. BPM picks up the data from the tables for further processing.