Mifos User Documentation Portal
  • Overview and Background
    • History and Background
    • Mifos Vision, Mission & Values
    • Who Mifos is For
    • How Mifos is Used
    • The Mifos Stack
      • Overview
    • Mifos v/s Fineract
    • Community app v/s Webapps
  • General Contributing Guidelines
    • Upstream Development Approach
      • Contribution Process
      • The Apache Way
    • Contributors Guide
    • Contribution Guidelines: Android Project
    • Contribution Guidelines: Web Project
  • Getting Started
    • Getting started with Git & Github
    • Postman integration with Gitbook for testing
    • Testing framework-Web
    • Testing framework-Android
    • Mifos CI/CD tools and instructions
  • External 3rd Apps
    • Pentaho Reporting Plugin
    • Payment Hub
  • MifosX
    • Overview
    • User Manual
      • How to Use This Manual
      • For All Users
        • General Navigation
          • Sign In Page
          • Welcome Page
          • Dashboard Page
          • List Page
          • Menu Page
          • Form Page
          • Clients-Groups-Centers Navigation
          • Navigation Tool
          • Global Search
          • Loan Product and Accounting with Mifos
        • Reports
          • Standard Reports Shipped in Mifos X
          • Standard Reports Field Descriptions
          • Custom Reports
            • Creating Simple Pentaho Report and Embedding it to Mifos X
          • XBRL Reporting
      • For Administrators (Mifos X Platform)
        • Initial System Set Up
        • Administration
          • Users
          • Organization
            • Manage Offices
            • Currency Configuration
            • Manage Holidays
            • Manage Funds
            • Manage Employees
            • Bulk Loan Reassignment
            • Standing Instructions History
            • Teller / Cashier Management
            • Fund Mapping
            • Working Days
            • Password preferences
            • Payment type
            • Loan Provisioning Criteria
            • SMS Campaigns
            • Message Gateway Configuration
            • Daily Teller Cash Management
            • Entity Data Table Checks
          • System
            • Manage Data Tables
            • Audit Trails
            • Manage Codes
            • Manage Reports
            • Manage Roles and Permissions
            • Manage Scheduler Jobs
            • Configure Maker-Checker Tasks
            • Global Configuration
            • Manage Hooks
              • Steps for creating sms bridge
            • Account Number Preferences
            • Entity To Entity Mapping
              • External Services
          • Products
            • Loan Products
              • Loan Product Fields
                • Accounting Loan Product Fields
                • Configuring and Disbursing of Top-Up Loan
                • Declining Balance Interest Calculation
                • Enabling Floating Rate
                • Enabling Variable Installments
                • Flat interest calculation
                • Loan Product Fields—Additional Fields for Loans with Variable Terms based on Loan Cycle
                • Recalculate Interest
                • Tranche Loan Fields
              • Setting up Minimum Days between Disbursal and First Repayment
              • Product Mix
            • Charges
            • Floating Rate
            • Savings Products
              • Saving Product Fields
                • Accounting Saving Product Fields
            • Fixed Deposit Products
              • Fixed Deposit Product Fields
                • Accounting Fixed and Recurring Deposit Product Fields
              • Interest rate chart with amount range
            • Recurring Deposit
              • Recurring Deposit Product Fields
            • Interest Calculations for Deposit Products
            • Overdraft Product
            • Share products
              • Dividends
            • Manage Tax configuration
          • Templates
          • mifos dropdown
        • Clients, Groups and Centers
          • Manage Clients
            • Client Life Cycle Statuses
            • Client Relationship Management
          • Manage Groups
          • Manage Centers
        • Accounting
          • Chart of Accounts - General Ledger Setup
            • Default COA sql script
          • Accounts linked to Financial Activities
          • Migrate opening balances (Office-wise)
          • Accounting Rules
          • Provisioning Entries
          • Print General Ledger Listing
          • How To Enter GL Opening Balance
        • Configure Notifications
      • For Operational Users (Mifos X Web App)
        • Accounting operations
          • Add Journal Entries
          • Searching Accounting Transactions
          • Frequent Postings
          • Advanced Accounting Rules
          • Closing Entries
          • Accruals
        • Accounts and Transactions
          • Cash Transaction Processing
          • Deposit Accounts
            • Mifos X Saving Accounts
              • How to Activate a Saving Account
              • How to Add a Charge to a Saving Account
              • How to Approve a Saving Account Application
              • How to Calculate Interest for a Saving Account
              • How to Close a Saving Account
              • How to Create a Saving Account Application
                • Saving Account Fields
              • How to create overdraft account (Draft)
              • How to Delete a Saving Account Application
              • How to Make a Deposit to a Saving Account
              • How to Make a Withdrawal from a Saving Account
              • How to Modify a Saving Account Application
              • How to Post Interest to a Saving Account
              • How to Reject a Saving Account Application
              • How to Transfer funds from a Saving Account
              • How to Withdraw a Saving Account Application
            • Standing Instructions
              • How to Set up a Standing Instruction
                • Standing Instruction Form Fields
            • Term Deposit Accounts (Fixed Deposit / Recurring Deposit)
              • How to Activate a Term Deposit Account
              • How to Add a Charge to a Term Deposit Account
              • How to Approve a Term Deposit Account Application
              • How to Calculate Interest for a Term Deposit Account
              • How to Create a Term Deposit Account Application
                • Term Deposit Account Fields
              • How to Delete a Term Deposit Account Application
              • How to Make a Deposit to a Recurring Term Deposit Account
              • How to Modify a Term Deposit Account Application
              • How to Post Interest to a Term Deposit Account
              • How to Reject a Term Deposit Account Application
              • How to Withdraw a Term Deposit Account Application
            • Creating Recurring Deposit Account:
          • Loan Accounts
            • How to Create a Loan Account Application
              • Loan Account Fields
            • How to Make Repayments on a Client Loan Account
            • Track Loan Performance History
            • How to Approve a Loan Account Application
            • How to Add a Charge to a Loan Account
            • How to Modify a Loan Account Application
            • How to Assign a Loan Officer
            • How to Reject a Loan Account Application
            • How to Withdraw a Loan Account Application
            • How to Delete a Loan Account Application
            • How to Add Collateral to a Loan Account
            • How to Add/Remove/Modify a Guarantor to a Loan Account
            • How to Manage Loan Account Disbursement
            • How to Make Repayments on a Group Loan Account
            • Using collection sheet or other payment types for making payments
            • How to Waive Interest for a Loan Account
            • How to Write-off a Loan Account
            • How to Close a Loan Account as Rescheduled
            • How to Close a Loan Account
            • Making Prepay of the loan
            • How to Prepay a Loan Account
            • How To Create Group Loan Account
            • How to Process Bulk JLG Loan Application
            • How to generate - Loan transactions report
            • How to reschedule loan
            • How to provide floating rates
            • How to provide variable installments
            • How to create new loan - Interest Recalculation
            • Tranche loan process
            • Loan with term vary based on loan cycle
            • How to Place Guarantee Funds On-Hold?
          • Overdraft account
          • Saving Accounts
            • How To Create Group Saving Account
          • Share Accounts
        • Checker Inbox & Tasks
      • Side Bar - Features
        • Checker inbox and tasks
        • Collection sheet
        • Help.
        • Individual collection sheet
        • Keyboard short-cuts
        • Navigation
      • Others - mifos dropdown
        • Help
        • Profile
        • Settings
          • Date format
          • Language
        • Signout
      • Data Import Tool
        • Getting started with - Data Import Tool
        • Installing Data Import Tool
      • Glossary of Terms
      • Index
      • Reporting Documentation
      • Mobile Money Tool
    • User Space
      • New Feature Request Content
      • Recommended System Requirement
      • MifosX Overview
      • Installation guide
        • Upgrading Mifosx
        • Install MifosX on Windows
        • Install MifosX on Linux
        • Install MifosX on AWS
      • Release Notes
        • Release 1 and Features List
        • Release 2 and Features List
      • User Manual
        • How to Use This Manual
        • For All Users
          • General Navigation
            • Sign In Page
        • For Administrators
          • Initial System Set Up
        • For Operationals
      • Roadmap
      • Frequently Asked Questions (FAQs)
      • Demo Server Details
    • Developer Space
      • Setting Up Dev Environment
        • Setting up Frontend - community-app
      • Setting up MifosX from latest builds
      • Contributors Guide
      • Customising MifosX
      • Additional features
        • Data import tool
        • SMS campaigns
        • Pentaho reports
      • How Mifosx works
      • Adding a new tenant to MifosX instance
      • Using REST client for testing
      • API documentation
      • Scaling MifosX
      • Upgrading MifosX
      • Troubleshooting guide
  • Core Banking & Embedded Finance
    • Core Banking
      • Overview
    • Embedded Finance
      • Overview
  • Application Framework
    • Payment Hub EE
  • Main Platforms
    • Fineract 1.x
      • Apache Fineract
      • Apache Fineract Client
    • Fineract CN
      • Overview
      • User Manual
  • Staff UI Platforms
    • Fineract 1.x
      • Community-App
      • Web-App
      • Web Self-Service App
        • Online Banking App 2.0 User Manual
          • Developer Environment Setup for Online Banking App 2.0
      • Mobile Field Officer Applications
        • Android Client
          • User Manual
    • Fineract CN
      • Digital Bank User Interface
      • Mobile Field Officer Applications
        • Fineract CN Mobile
  • Customer UI Platforms
    • Fineract 1.x
      • Mobile Banking
        • Mifos Mobile
      • Mobile Wallets
      • Online Banking
    • Fineract CN
      • Mobile Banking
        • Fineract CN Mobile
        • Mifos Mobile CN
      • Mobile Wallets
      • Online Banking
  • Ancillary Tools
    • Fineract 1.x
      • Message Gateway
      • Mifos Passcode
      • PPI Vision
      • DevOps Tooling
      • Fineract Android SDK
      • MifosX Admin
      • Mifos ChatBot
      • Data Import Tool
    • Fineract CN
      • Fineract CN Containers
      • Fineract CN Terraform
  • Payment and Process Orchestration
    • Fineract 1.x
      • Payment Hub
      • Fineract Pentaho
    • Fineract CN
      • Staff Interfaces
        • Digital Bank UI
      • Customer Interfaces
        • Fineract CN Mobile
        • Mifos Mobile CN
        • Fineract CN Mobile
      • Ancillary Tools
        • Fineract CN Terraform
        • Fineract CN Containers
    • Payment Hub EE
Powered by GitBook
On this page
  • How to create Entity Data Table Checks
  • Creating Client Entity Data Table

Was this helpful?

  1. MifosX
  2. User Manual
  3. For Administrators (Mifos X Platform)
  4. Administration
  5. Organization

Entity Data Table Checks

PreviousDaily Teller Cash ManagementNextSystem

Last updated 5 years ago

Was this helpful?

Entity Data Table Check is a new feature added to check few Custom details during certain actions that need to be done by making use of Custom Data Tables. For instance you need to check the existing Bank Account of the client before the creation of client. Then you can create your own Custom Data Table with column Existing Bank Account and check the details before the creation of client.

How to create Entity Data Table Checks

Step 1: From the main screen, click on then Organization from the drop down list. This will launch the menu. Select Entity Data Table Checks.

This will launch the Entity Data Table Checks page.

Field description

Field

Description

Entity (mandatory)

This field describes which entity will undergo Entity Data Table Checks. Only four entities are supported with Entity Data Table Check and they are Client, Group, Loan and Saving Account.

Status (mandatory)

This field describes when the specified entity should undergo Entity Data Table Checks. The status is not same for all entity and the statuses are create, approve, activate, write_off, withdrawn, rejected and close.

Data Table (mandatory)

This field describes what need to be checked. These are custom data tables which are created in the manage table. Based on the Custom Data Table created, the additional screens are designed for the specified Entity during specified Status. All the columns given in the custom data table are displayed as fields in the additional screens created.

Product

This field is enabled only for Loan and Saving Account entity. All the Loan Products are captured in the drop-down for Loan entity and all the Save product will be captured in the drop-down for Saving Account entity.

  • Any number of Entity Data Table Checks can be created for all the four entities.

Creating Client Entity Data Table

Navigate to the Entity Data Table Checks page and then click the +Create Entity Data-Table Check button which will launch a pop-up box. Look through the previous section of this page to get details on how to navigate to the page.

From the Entity field, select Client from the drop-down menu.

For Client entity, only three statuses are provided.

Drop-down values

Description

CREATE

During the creation of Client, the Entity Data Table Checks are enabled

ACTIVATE

During the activation of Client, the Entity Data Table Checks are enabled

CLOSE

While closing the Client, the Entity Data Table Checks are enabled

The Data Tables which are created are captured in the Data Table drop-down.

>>Create Client

This is a create client screen with additional wizard consisting Client Bank Details and Family Details. Only CREATE status will consist of wizards. For other status, additional tabs will be created.

After clicking on proceed, the current screen navigates to the next page.

>>Create Client>> Create Bank Details

This is an additional wizard created for Client entity and CREATE status with Client Bank Details data table as custom data table. Bank Account Number and the Bank Branch are the columns created in this custom data table. After clicking on proceed the current screen navigates to the next page.

>>Create Client>> Create Bank Details>> Family Details

This is an additional wizard created for Client entity and CREATE status with Family Details data table as custom data table. Members and the Occupation are the columns created in this custom data table. Only after completing all the wizard screens the page will allow you to submit the Application.

If you are not providing the required details (only if the field is mandatory) then an error message is shown.

Step 2.2: Creating Entity Data Table Checks for Group Entity

  • Group Entity has the following Status

Drop-down values

Description

CREATE

During the creation of Client, the Entity Data Table Checks are enabled

ACTIVATE

During the activation of Client, the Entity Data Table Checks are enabled

CLOSE

While closing the Client, the Entity Data Table Checks are enabled

  • The data tables which are created are captured in the data table drop-down.

  • To create custom data table navigate to Admin>>System>>Manage Data Tables>>Create Data Tables.

  • Instance 1: A data table has been created for the activation of a Group and the custom data table name is "Group Details". Wizard is not facilitated for status other than create. Hence in the screen below, we can see a tab named by "Group Details" with Add button. Clicking on the Add button will navigate to the Group Details page.

  • As shown in the GroupDetails screen, the fields are captured based on the custom data table created by you.

  • If we are not provided the data to the custom data table based field and if we try to activate the Group, then an error message is shown as in the screen below

Instance 2: A data table has been created for the Creation of Group and the custom data table name is "GroupBankDetails". Since the status is create the wizard come into picture. Hence in the screen below, we can see the wizard named by "GroupBankDetails" .

As shown in the GroupBankDetails screen, the fields are captured based on the custom data table created by us

Step 2.3: Creating Entity Data Table Checks for the Loan Entity

  • Loan Entity has 6 Statuses as that of Client. i.e.,

Dropdown Values

Description

CREATE

During the creation of Loan the Entity Data Table Checks are enabled

APPROVE

During the Approval of Loan the Entity Data Table Checks are enabled

ACTIVATE

During the Activation of Loan the Entity Data Table Checks are enabled

WITHDRAWN

During the Withdrawal of Loan the Entity Data Table Checks are enabled

REJECTED

During the Rejection of Loan the Entity Data Table Checks are enabled

WRITE_OFF

During the Write_off of Loan the Entity Data Table Checks are enabled

  • The data tables which are created are captured in the data table drop-down.

  • To create custom data table, navigate to Admin>>System>>Manage Data Tables>>Create Data Tables.

  • For loan entity an extra field is added i.e., Product. This field is visible only if the Loan products are already created.

  • Instance 1: A data table has been created for approval of loan and the custom data table name is "LoanDetails". Wizard is not facilitated for status other than create. Hence in the screen below, we can see a tab named by "LoanDetails" with Add button. Clicking on the Add button will navigate to the LoanDetails page.

  • As shown in the LoanDetails screen, the fields are captured based on the custom data table created by us.

  • If we are not providing the data to the custom data table based field and if we try to approve the loan, then an error message is shown as in the screen below:

Instance 2: A data table has been created for the creation of loan account and the custom data table name is "FamilyAnnualIncome". Since the status is create the wizard comes into picture. Hence in the screen below, we can see the wizard named by "FamilyAnnualIncome".

As shown in the FamilyAnnualIncome, the fields are captured based on the custom data table created by us.

Step 2.4: Creating Entity Data Table Checks for Saving Account entity

  • Saving Account Entity has 6 Statuses as that of Client. i.e.,

Drop-down Values

Description

CREATE

During the creation of Saving Account the Entity Data Table Checks are enabled

APPROVE

During the Approval of Saving Account the Entity Data Table Checks are enabled

ACTIVATE

During the Activation of Saving Account the Entity Data Table Checks are enabled

WITHDRAWN

During the Withdrawal of Saving Account the Entity Data Table Checks are enabled

REJECTED

During the Rejection of Saving Account the Entity Data Table Checks are enabled

CLOSE

While Closing the Saving Account the Entity Data Table Checks are enabled

  • The data tables which are created in the manage tables are captured in the data table drop-down.

  • To create custom data table navigate to Admin>>System>>Manage Data Tables>>Create Data Tables.

  • For loan entity an extra field is added i.e., Product. This field is visible only if the Saving products are already created.

  • Instance 1: For an instance a data table has been created for activation for saving account and the custom data table name is "SavingDetails". Wizard is not facilitated for status other than create. Hence in the screen below, we can see a tab named by "SavingDetails" with Add button. Clicking on the Add button will navigate to the SavingDetails page.

  • As shown in the SavingDetails screen, the fields are captured based on the custom data table created by us.

  • If we are not providing the data to the custom data table based field and if we try to activate the Saving account, then an error message is shown as in the screen below.

  • Instance 2: A data table has been created for the creation of saving account and the custom data table name is "AdditionalAccount". Since the status is create the wizard comes into picture. Hence in the screen below, we can see the wizard named by "AdditionalAccount" .

As shown in the AdditionalAccount screen, the fields are captured based on the custom data table created by us.

  • Wizard is supported only for the creation of Client/Group/Loan/Saving Account. It is not supported for other statuses such as activate/approve/write-off/rejected/close/withdrawal. Instead statuses such as activate/approve/write-off/rejected/close/withdrawal are supported by a tab.

Step 2: Click the button which will launch a pop-up box;

To create a Custom Data Table, select Admin from the top of the screen and choose System from the drop-down menu. Select and click the +Create Data Table button. After creating a Data Table, you will find it listed in the Data Table drop-down menu:

For the created Entity Data Table Check, their respective pages are affected. For instance, an "Entity Data Table Check" for clients has been created for CREATE status. So the create client page consists of wizards as shown below. Here, two "Entity Data Table Checks" are created for create client via wizard i.e., Client Bank Details and Family Details. And their respective fields are created based on the data tables created in page.

Hence "Entity Data Table Check" is required for enhancing the existing entity details or any additional verification during certain actions like disbursing the loan, activating the Saving Account, creation of client etc. Video link for Entity Data table checks:

Manage Data Tables
Manage Data Tables
https://youtu.be/c77h61AJEQ0
Admin
Organization