PPI Functional Spec
Release |
Leila E |
Current Owners |
Kay Chau |
Status (Draft, In Review, Approved) |
In Review |
Contents:
Introduction
PPI as it is in Mifos is difficult to use and does not meet all the needs of an MFI who using PPI. We need to implement the feature in Mifos so that it is more flexible, and provides the reporting capabilities to do analysis. For Leila E, we must meet our Cisco commitments.
User Stories
Priority |
User Stories |
Section in FR |
---|---|---|
P1 |
3.1 |
|
P1 |
3.2 |
|
P1 |
3.2 |
|
P1 |
3.3 |
|
P1 |
3.3 |
|
P1 |
3.3 |
|
P1 |
3.7 |
|
P1 |
3.2 |
|
P1 |
3.6 |
|
P1 |
3.6 |
|
P1 |
3.6 |
|
P2 |
3.8 |
|
P2 |
3.8 |
Goals
- Provide a way for MFI's to collect PPI survey data from clients entered into Mifos
- When data is entered into Mifos, it is part of a workflow to collect information from clients
- Ability to do analysis on scores and likelihoods of clients
- 1 data dump will be available
- Ability to select which PPI surveys are available for the MFI
Non-Goals
The following items will not be addressed in this release:
- View clients' scores and likelihoods directly in Mifos (can be run in report)
- Ability for anyone other than the Mifos product team to provide the PPI surveys in Mifos.
Definitions and Terminology
Term |
Definitions |
---|---|
User |
User of system |
- Mandatory fields will be preceded by "*" (an asterisk)
- Links are italicized
- Buttons are Button
Related Documents
Use Cases
Access PPI's
Actors
- Administrator
Preconditions
- Mifos is shipped with several PPI's
- Mifos has been upgraded to version with this PPI.
Basic Flow
- Administrator is able to view a directory of all shipped PPI's here - Past Releases. Administrator selects the one(s) relevant to their MFI, and copies it into the QG directory to be picked up.
Post-conditions
- Under Activate QG, the dropdown includes the PPI's the Administrator has copied over.
Activate India PPI
Actors
- Administrator
Preconditions
- Mifos is shipped with India PPI 2005.
- Mifos has been upgraded to version with this PPI.
- Mifos Administrator has copied the PPI India 2005 manually to the correct directory (part of Upgrade notes)
Basic Flow
- Administrator navigates to Activate Question Groups in Admin section of Mifos.
- Administrator is able to select "India PPI Survey 2005" from a list of available QG's and chooses to activate.
- Mifos activates "India PPI Survey 2005".
Post-conditions
- Under "View Question Groups" will be a QG called "India PPI Survey 2005" with the questions and answer choices. The survey is automatically assigned to the Create Client workflow.
- When a Loan Officer enters in clients' answers to a PPI, he is able to select India PPI 2005 as the version he wants to enter.
Change where the PPI questions are asked
PPI Administrator wants the PPI questions to be asked during Close Client, not Create Client
- Administrator navigates to View Question Groups, and selects PPI India 2005.
- Administrator edits the QG, and edits the Applies To: to be Close Client, and removes Create Client. Administrator saves the new QG.
OR
- Mifos Administrator changes the PPI India 2005 XML file directly to have Close Client instead of Create Client as the <applies to> tag. Administrator restarts Mifos.
- Mifos Administrator logs onto Mifos, and follows the Activate PPI Survey and activates the new survey. They also inactivate the old one.
Post-conditions
- The PPI Survey is now available only when a client's status is being changed to Closed. It is not displayed during Client Creation.
Have PPI questions asked in more than one flow
PPI Administrator wants the PPI questions to be asked during both Create Client, and when opening a new Loan account for the client.
- Administrator navigates to View Question Groups, and selects PPI India 2005.
- Administrator edits the QG, and edits the Applies To: to be Create Client and Create Loan. Administrator saves the QG.
Post-conditions
- The PPI Survey is now available during Client Creation and Loan Creation.
Inactivate PPI
A new survey has come out, and the Administrator needs to inactivate the old one
- Administrator navigates to View Question Groups, and selects the old Survey.
- Administrator edits the QG, and chooses to make it Inactive. Administrator saves the QG.
Post-conditions
- The old survey is now inactive. It does not appear anywhere in Mifos.
- For clients who had used the old survey, it is still possible to run reports based on the old survey.
Validations
Save PPI Answers
Actors
- Loan Officer
Preconditions
- PPI India 2005 has been activated and applied to the Create Client workflow.
Basic Flow
- Loan Officer navigates to create a new client, and under Additional Information, the PPI Survey questions are displayed. Loan Officer selects the right answer choices and saves the client information.
Post-conditions
- Client has PPI Survey data saved, and the data is ready for reporting.
Save another set of PPI Answers
Actors
- Loan Officer
Preconditions
- PPI India 2005 has been applied to both Create Client and Close Client workflows. Client's PPI data was collected during client creation.
Basic Flow
- Client is leaving the MFI. Loan Officer would like to conduct an exit survey. Loan Officer navigates to Close the Client, and PPI Questions are displayed. Loan Officer saves the latest answers.
Post-conditions
- Report can be run to take both PPI scores from Client creation and Close Client. The scores are separate and accurate.
Update Incorrect Answers Captured with a PPI Survey
Actors
- Loan Officer
Preconditions
- PPI India 2005 has been filled out for a client. One of the answers captured was incorrect.
Basic Flow
- Loan Officer navigates to where the wrong answer was captured for the client. Loan Officer is able to view the answers already captured, and clicks on Edit to edit the answers.
- Loan Officer saves the correct answers.
Post-conditions
- Reports only take the latest version of this data saved. Old data is retained but is not used for reporting the score.
Update Incorrect Questions/Answer Choices with a specific PPI Survey Version
Example: PPI India Survey 2005 was published, and is shipped with Mifos. However, a couple of months later, it turns out one of the questions and/or answer choices was incorrect and needs to be updated.
Actors
- PPI Administrator
Basic Flow
- Mifos Team updates the PPI India Survey 2005 QG that was shipped with Mifos with a new version with new question/answers.
- Mifos is upgraded at the MFI.
- Mifos Administrator locates the new XML file with the updated Survey questions and answer choices, and copies to the QG directory for activation.
- Administrator navigates to View Question Groups, and inactivates the old QG with the incorrect questions and/or answers.
- Administrator then navigates to Activate QG and activates the new India PPI 2005. (Is there an indicator that this is different?)
- Administrator navigates to View Question Groups again, and edits the new PPI Survey to have all the properties he wants (workflows to apply to, editable answers, etc)
Post-conditions
- Loan Officer can now see updated survey questions and/or answers for entering PPI surveys.
- Old surveys need to be invalidated?
Update Incorrect Answers' Point Values with a specific PPI Survey Version
Example: PPI India Survey 2005 was published, and is shipped with Mifos. However, a couple of months later, it turns out one of the points associated with an answer choice was incorrect. The Scoring associated with the survey needs to be updated to reflect this.
Actors
- PPI Administrator
Basic Flow
- Mifos Team updates the Mifos PPI Scoring and Likelihood Lookup Tool with the NEW scoring. Mifos BI is updated and released.
- Mifos BI is upgraded at the MFI.
- PPI continues to be collected.
Post-conditions
- All reports run on surveys taken with this particular version, should now use the new Scoring to calculate score.
- No changes to UI
Update Incorrect Lookup Table(s) with a specific PPI Survey Version
Example: PPI India Survey 2005 was published, and is shipped with Mifos. However, a couple of months later, it turns out the lookup table was INCORRECT for the NPL. The values need to be updated.
Actors
- PPI Administrator
Basic Flow
- Mifos Team updates the Mifos PPI Scoring and Likelihood Lookup Tool with the NEW Lookup tables. Mifos BI is updated and released.
- Mifos BI is upgraded at the MFI.
- PPI continues to be collected.
Post-conditions
- All reports run on surveys taken with this particular version, should now have the updated likelihood data.
- No changes to UI
Update NEW PPI Survey version
Example: PPI India Survey 2005 was published, and is shipped with Mifos. In 2007, a new PPI India Survey comes out. It can have different questions, answers, scoring, and/or lookup tables. These all need to be updated. However, all surveys taken before 2007 should still use old Scoring and Lookup Tables.
Actors
- PPI Administrator
Basic Flow
- Mifos Team delivers new PPI India Survey 2007 with updated Survey questions and answers, Scoring, and/or Lookup Tables.
- Mifos and Mifos BI is upgraded at the MFI.
- PPI Administrator follows the Access PPI's and then Activate PPI use case and activates PPI India Survey 2007. They also inactivate PPI India Survey 2005.
Post-conditions
- Reports run should map to correct survey version date. If a report is run from 2005 to 2009, for likelihoods under $1/day, and that band is not available in 2005, then the report should throw an error.
- No changes to UI
View PPI Score and Likelihoods
Actors
- PPI Administrator
Basic Flow
- PPI Administrator logs onto Pentaho, and selects to run PPI Data Dump Report.
- PPI Administrator selects the dates to run the data dump for, and runs the Report.
- Data Dump Report in Excel is displayed.
Post-conditions
Functional Requirements
Pre-shipped PPI Surveys
FR # |
Pri |
Description |
Comments/Mockups |
---|---|---|---|
1.1 |
P1 |
Mifos will ship with a set of XML files that are the latest PPI surveys for each country available. These are in the Mifos Question Group format. |
|
1.2 |
P1 |
See XML template here - |
|
1.3 |
P1 |
Each file will have survey questions and answer choices associated with the PPI Survey. |
Bug fixed to allow longer question titles |
1.4 |
P1 |
In addition, there will also be a field to enter the Date of Survey Taken. |
|
1.5 |
P1 |
Each survey is also by default applied to the "Create Client" workflow. |
|
Activate PPI
FR # |
Pri |
Description |
Comments/Mockups |
---|---|---|---|
2.1 |
P1 |
PPI Surveys are not active by default. Mifos Administrator must copy the relevant PPI survey files and place them in the QG directory in Mifos in order for them to be available for activation. |
|
2.2 |
P1 |
Administrator can navigate to Activate Question Group link and view a dropdown of Question Groups available. PPI Surveys will be prefixed with "PPI". All PPI surveys available will be listed. |
|
2.3 |
P1 |
Administrator can choose a PPI Survey they want to activate, and click Submit. |
|
2.4 |
P1 |
Afterward, Administrator can view the QG is available in "View Question Groups". Once it is activated, the PPI Survey is active and automatically in the Create Client workflow. |
|
2.5 |
P1 |
Administrator can edit a PPI Survey QG to change and update multiple workflows the PPI Survey applies to. |
|
2.6 |
P1 |
Administrator can change the order of questions asked in a PPI Survey. This has no effect on the score. |
|
2.7 |
P1 |
Administrator can inactivate a PPI Survey by changing Status to Inactive when editing the PPI Survey. |
We will encourage MFI's to inactivate old/wrong surveys first before activating a new/updated PPI survey to avoid confusion on which version to use. See FR Section 7 for more details |
2.8 |
P1 |
By default, all questions in the PPI QG are mandatory. This can be changed by the MFI but it is not recommended. If any question is not answered, then we do not expect the survey to be scored |
|
2.9 |
P1 |
The PPI questions themselves are locked - IE, an Administrator has no way through the Mifos UI to edit the question or answer text. This should only be handled outside of Mifos and through updates to Mifos. |
|
|
|
Issue MIFOS-4078 : It is possible to re-activate the same PPI QG. A new QG is created with the same title but the questions are re-used. |
|
Save PPI Answers
FR # |
Pri |
Description |
Comments/Mockups |
---|---|---|---|
3.1 |
P1 |
PPI QG's are displayed in the workflow(s) it is applied to. Mifos User can enter in answers to questions and they are saved. |
|
3.2 |
P1 |
IF the PPI QG has been marked as "Can be edited" then this means a Mifos user can return to the survey already taken, and edit the answers. This scenario should only be used for correcting wrong answers. |
|
3.3 |
P1 |
If a new survey has been taken for the client, then the Mifos user should open a new unanswered survey for the client - this can be done using the View Entity workflows (similar to surveys today) |
|
3.4 |
P1 |
If a PPI survey is applied to more than one flow, then each new survey taken should yield a distinct PPI score. These can be seen in reports. |
|
3.5 |
P1 |
One behavior to note is - if the PPI QG is applied to the Create Client workflow for example, and the Loan officer does not know all answers to mandatory questions in QG's applied to that workflow, they cannot save any answers. They must return to the Create Client workflow only when they know all answers to mandatory questions. This is the same as previous behavior for Additional Fields in entities. |
|
Mifos PPI Scoring and Lookup Tool
FR # |
Pri |
Description |
Comments/Mockups |
---|---|---|---|
4.1 |
P1 |
Mifos BI will ship with a PPI Scoring and Lookup Tool (ETL) that maps PPI Surveys to Scoring and Likelihood Tables associated with them. PPI Surveys are identified by name and version (i.e. PPI India 2005.1). |
|
4.2 |
P1 |
The versions of scores and lookup tables will be mapped to the Survey version in Mifos. |
|
4.3 |
P1 |
Each question is identified by an internal short name that will be able to be mapped to the PPI Scoring and Lookup Tool for point values. |
|
4.4 |
P1 |
Versioning for each survey and scoring and lookups are by year then by minor version. For example, A Survey might be PPI India 2009.01 |
|
4.5 |
P1 |
MFI must have both Mifos Leila E Release, and Mifos BI 1.0 Beta installed to have the Mifos PPI Scoring and Lookup Tool work correctly. |
|
How to Score and Look up Likelihoods
FR # |
Pri |
Description |
Comments/Mockups |
---|---|---|---|
5.1 |
P1 |
Each survey has 10 questions. Each question has some answer choices. Each answer choice has a point value. For any single survey taken, sum up points associated with each answer choice chosen. Total is the PPI Score for that particular score. |
|
5.2 |
P1 |
If a survey is not completely filled out (this should be not be possible in Mifos, all questions should be marked mandatory), then there should be no score returned, and the survey is invalid. |
|
5.3 |
P1 |
With the PPI Score, the client's likelihood under or above several poverty lines can be looked up using the associated Lookup Tables. There will be a different set of lookup tables associated with each PPI Survey. These tables can also change from version to version. |
|
Correction of PPI Surveys (Questions, Answer Choices, Point Values, and Lookup Tables)
FR # |
Pri |
Description |
Comments/Mockups |
---|---|---|---|
6.1 |
P1 |
If a question or answer choice was incorrect in a survey recently released, Mifos will bundle with a new QG with the correct questions and answer choices. Upon upgrade to this version of Mifos. the Mifos administrator can inactivate the old incorrect survey, and activate the new one. |
|
6.2 |
P1 |
All surveys taken previously with the wrong questions and answer choices should be invalidated |
|
6.3 |
P1 |
If a point value associated with an answer choice for a PPI Survey needs to be corrected, the Mifos PPI Scoring Tool must be updated so that the new point value is taken when calculating the PPI Score. All reports run for the PPI Survey taken with this version must now use the updated point value(s) to calculate the PPI Score. |
|
6.4 |
P1 |
If a lookup table associated with a PPI Survey was incorrect, the Mifos PPI Scoring and Lookup Tool will be updated with the correct lookup tables. All reports run will use the correct lookups. |
|
New Versions
FR # |
Pri |
Description |
Comments/Mockups |
|
---|---|---|---|---|
7.1 |
P1 |
When a new version of PPI comes out, Mifos must have the new QG and Mifos BI must be upgraded with the new ETL's. It might be only necessary to upgrade the Mifos BI solution, depending on if there were any fundamental changes in Mifos for PPI. |
|
|
7.2 |
P2 |
In a future release, we should implement this so that the roll-out is easier for the MFI. |
|
Reports
FR # |
Pri |
Description |
Comments/Mockups |
---|---|---|---|
8.1 |
P1 |
A simple data dump will be provided in Mifos BI 1.0 with scores and likelihoods of all clients. |
See attachment - Example PPI reporting - Data Dump tab |
8.2 |
P1 |
For reporting, the ETL updates the D/W daily at a certain time. That means updated scores are only available after the job runs. The timing of the job can be configured. |
|
Deprecate Old Functionality
Options |
Pros |
Cons |
Cloud Customer Experience |
Existing Customer Experience |
Work TBD |
---|---|---|---|---|---|
|
|
|
|
|
|
2) Remove old PPI settings completely, but keep data saved. |
Old PPI is not there anymore. |
Existing customers have to migrate old PPI data over to QG's first |
Just look at new spec for how to use |
They must migrate old PPI over and train staff on new PPI |
Remove old settings. |
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? |
Yes |
Permission for PPI needed to activate PPI, permission with QG needed to edit the QG the Survey questions are in, and LO need to have rights to edit information for their clients or loan accounts depending on where in the Mifos workflow the PPI Surveys are active. |
Does the office hierarchy affect use of this feature? |
Yes |
LO's can only enter data from PPI Surveys for clients in their hierachy |
Are you using any existing permissions to control this feature? |
Yes |
We should be using existing permissions to control this |
Are you adding any new permissions or changing existing permission to control this feature? |
Yes |
We added a new Activate Question Group permission. |
Are you using any existing activities to control this feature? |
Yes |
Question Groups have been implemented |
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? |
-- |
Admin will have all permissions |
Impacts to System
Impacts to System |
Yes/No |
Comments |
---|---|---|
Does this feature affect Bulk Loan Creation? How? |
No |
There are no QG's in this workflow |
Does this feature affect Collection Sheet Entry? How? |
No |
|
Does this feature affect Redo Loans? |
No |
|
Does this feature affect Undo Loans? |
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 |
|
Is there currency or other numeric data ? If so does it require any special handling or validation? |
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? |
Yes |
This should already been done by the QG implementation |
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? |
No |
|
Does the feature require adding any new reports? |
Yes |
See Reports FR above |
Performance
Performance |
Yes/No |
Comments |
---|---|---|
Will the feature be a high use-case scenario? |
Yes |
|
Will the feature have potential for high concurrency? |
No |
|
Does the feature include complex UI or data gathering logic that will be used by a significant portion of the user base? |
Yes |
|
Does the feature contain risks of database connection timeout or JSP page timeout? |
No |
|
Will the feature contain any bulk insert/update/delete transactions? |
? |
|
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? |
? |
|
Does the feature affect existing batch jobs or require adding any new batch jobs? |
? |
|
Setup and Installation
New Installations
New Installations |
Yes/No |
Comments |
---|---|---|
Will the feature include demo data? |
No |
|
Does the feature require any data to be gathered at setup runtime? |
Yes |
Surveys must be pre-shipped |
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? |
Yes? |
GK |
Will customers lose data or will the way existing data is stored change significantly? |
Yes |
Migration for GK |
Will another feature, workflow or portion of the data model be deprecated as a result of this new feature? |
Yes |
|
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 |
|
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 |
|
Does this feature require Sys Admin work to set up for clients? |
Yes |
Pentaho and Mifos must be set up |
Configuration
Configuration |
Yes/No |
Comments |
---|---|---|
Does this feature require changes to configuration files? |
? |
|
If so, is this feature enabled or disabled by default? |
? |
|