Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

  • Some UI/mockups and wording may change, functionality will remain the same.

Setup and Installation

New Installations

New Installations

Yes/No

Comments

Does this feature require both Mifos Business Intelligence Suite and Mifos Product? 

 NO

 

Does this feature require special work for hosting?  (sys admin) 

 NO

 

Backward Compatibility and Upgrades

Backward Compatibility and Upgrades

Yes/No

Comments

Is there any data conversion that needs to be done as part of an upgrade?

 NO

 

Will customers lose data or will the way existing data is stored change significantly?

 NO

 

Will another feature, workflow or portion of the data model be deprecated as a result of this new feature?

 NO

 

Will existing role permissions be changed or impacted by this feature? If so provide details in the security section.

 NO

 

Will existing customers need to learn a new UI process or change the way they use the system as a result of this new feature?

 YES

 They will need to enter the client cash flow and also enter the loan installment amounts.

Hosting Support

Hosting Support

Yes/No

Comments

If different user groups are using the same database, are there concerns over the sharing of data related to the feature?

 NO

 

Are there expected to be performance related issues with having many customers sharing the same hardware in support of this feature?

 NO

 

Configuration

Configuration

Yes/No

Comments

Does this feature require changes to configuration files?

 Yes

 

If so, is this feature enabled or disabled by default? 

 Yes

Enabled only for Declining Balance interest type 

Are existing configuration properties used to control this feature?  If yes, which ones?

 No

 

Are new configuration properties added for this feature?

Yes 

Minimum allowed cashflow warning threshold.
Maximum allowed cashflow warning threshold.

Minimum allowed Repayment Capacity.
Maximum allowed Repayment Capacity.

Minimum allowed Indebtedness Rate.
Maximum allowed Indebtedness Rate.

Key Functional Areas Impacted

...

This will prompt the user with an error message suggesting that the client's indebtedness rate is greater than the permissible limit.

Example 2 - Repayment Capacity

Panel

Repayment Capacity=[(Total revenues-Total expenses)+Loan Amount]*100 / Sum of Installments amount

During loan product definition, the Repayment Capacity limit has been set as 150. 

Lets assume a Rs.1000 loan is being applied for.

On the cash flow screen during loan creation, the user enters the monthly revenue and expenses.

Lets assume that the sum of all expenses enteres is Rs.5000 and the sum of all revenues entered is 10000.

Also lets assume the sum of all installment amounts is 1500.

Therefore the Repayment Capacity will be 400.

On the review schedule page, the user will be allowed to go ahead with loan creation as the calculated repayment capacity is over the required minimum repayment capacity of 150.

Repayment Schedule generation

Consider the following example to better understand the schedule generation for variable installment loans.

...

Collection sheet can be used the same way as other loan types.  No additional development work is required to be done in this area. 

Other Standard Considerations

Security

Security (Permissions, Roles, and Data Scope)

Yes/No

Comments

Does the user need to be in a particular user hierarchy to use this feature?

 NO

 

Does the office hierarchy affect use of this feature?

NO 

 

Are you using any existing permissions to control this feature?

 NO

 

Are you adding any new permissions or changing existing permission to control this feature?

 NO

 

Are you using any existing activities to control this feature?

 NO

 

Are you adding any new activities or changing existing activities to control this feature?

 NO

 

Are there any special considerations for upgrade scenarios? What will be the default value for new permissions?

 NO

 

What will be the default values for default roles in a new installation?

 NA

 

Impacts to System

Impacts to System

Yes/No

Comments

Does this feature affect Bulk Loan Creation? How?

 NO

 

Does this feature affect Collection Sheet Entry? How?

 NO

 

Does this feature affect Redo Loans?

 YES

During Redo loan, the gap between installments will decide the interest calculation. Due dates can be edited during Redo Loan for Variable installment loans. Cash flow comparison will not be done during Loan Redo.  

Does this feature affect Reverse Loans?

 No

 

Is this feature affected by Holidays?

 No

 

Globalization/Localization

Globalization/Localization

Yes/No

Comments

Will this feature support users localizing data that they enter?

 YES

 

Does this feature involve any date/time related data, and if so how should conversions be handled?

 YES

Date pickers are added for convenience. String translations are done so that localizations do not effect the storage of dates. 

Is there currency or other numeric data ? If so does it require any special handling or validation?  Is there a need for mult-currency?  (Loan Accounts)

 NO

 

Logging

Change Log

Change Log

Yes/No

Comments

Do changes to the data that is collected or stored by the new feature have to be fully logged by the system?

 NO

 

Does the administrator configuring the system need the ability to turn on or off logging for this feature?

NO 

 

Is the feature currently logged but the structure of the logged records changing?

 NO

 

Reporting

Provide any relevant information about reporting requirements for the new features and answer the questions below, providing detail to explain any particular area when necessary.

Reporting

Yes/No

Comments

Does the feature affect any existing reports?

Yes

Collection Sheet Report? 

Does the feature require adding any new reports?

 NO

 

Performance

Performance

Yes/No

Comments

Will the feature be a high use-case scenario?

 Yes

 

Will the feature have potential for high concurrency?

 

 

Does the feature include complex UI or data gathering logic that will be used by a significant portion of the user base?

 NO

 But it does include complex UI to be handled by professionals adept and trained with this feature.

Does the feature contain risks of database connection timeout?

 NO

 

Will the feature contain any bulk insert/update/delete transactions?

 NO

 

Will the feature contain any caching mechanisms or cache refreshing mechanisms?

 NO

 

Could the feature result in a large amount of data being sent to the client or between the database and web server?

 NO

 

Would users on a low bandwidth connection likely face issues with a part of this feature?

 NO

 

Does the feature affect existing batch jobs or require adding any new batch jobs?

 NO