Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Moving clients/groups can only be done if no active accounts exists for that client (all accounts must be closed).  Except for clients with no group membership... moving to another branch puts them on-hold and the loan officer is removed and has to be reassigned.

Requirement

Test

Result

handle Handle moving a client from one group to another in the same center.

Group: group dw1 1 - 0003-000000002
client: xfer to gr in center xxx - 0003-000000017
Savings account: savings product 1 # 000100000000036 
transfer to:  group dw1 2

Pass. client Client entry added to reflect new group. and  savings entry added to link to new client entry.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

ff

...

Handle moving a client from one group to another in the same branch

...

Group: group dw1 1 - 0003-000000002
client: xfer to gr in same branch xxx - 0003-000000023
loan prod 2 # 000100000000044
transfer to: BO 1 / center 2 / group 1 for center 2

...

...

Pass.

...

Client entry added to reflect new group. and  loan entry added to link to new client entry.

...

Handle moving a client from one group to another in a different branch

...

Group: group dw1 1 - 0003-000000002
client: xfer to gr in different branch xxx - 0003-000000024
savings product 1 # 000100000000046 
transfer to: br2 / br2 center 1 / br2 group

...

1

Pass.

...

 Client entry added to reflect new group. and  savings entry added to link to new client entry.

Handle removing group membership from a client.

client: client remove group membership xxx  0003-000000050
loan: loan prod 1 # 000100000000091 
moved to 'sturty' loan officer

Fail.  The data is ETL's but the outcome looks as if the client had not group membership from the start.  Problem is a difficulty in picking up a new client that was a group member and then has membership removed because it looks like a client that was w/o group membership from the start.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Requirement - to do
The ETL should handle removing group membership from a client.
Test
client: client remove group membership xxx  0003-000000050
loan: loan prod 1 # 000100000000091 
moved to 'sturty' loan officer
&
remove group membership xxx 0003-000000054
Test
Fail.  Hard to pick up a client that was a group member and then has membership removed because it looks like a client that was w/o group membership from the start.  Would be same from group except you can't remove a group from center membership???
Result
Fail.  client and loan not versioned.  Current value (no group) given to all. need to pick up on. all one change log.
field_name old_value new_value
'groupFlag' 1 0
'Group Name' the group name -
Requirement

The ETL should handle moving client with no group membership to another branch.
Test
Client: client w/o gr memb xfer to branch xxx 0003-000000045
Client Savings: savings product 1 # 000100000000082
Result
Pass.  Client and savings account show application of 'Loan Officer Assigned', 'Branch membership' and 'Status' changes associated with a branch membership change. Lo is nulled out, client status is changed to 'on hold'.
Requirement 
The ETL should handle a client with no group membership becoming a group member.
Client: client add back to group hierarchy after xxx 0003-000000051
Savings: savings product 1 # 000100000000093 
Result
Pass.  
Requirement
The ETL should handle a Loan Officer change for a client with no group membership.
Test
Client: client w/o grp memb hier LO change xxx 0003-000000044
Client Savings: savings product 2 # 000100000000080 
changed 'smith' to 'xxx'
Result
Pass. Client and Savings entries as expected.  As LO change was done on same day as client and savings creation...  the LO change is treated as if it happened before the client active status and before the savings account was created (because changes on the same day are appled in order of new, hierarchy then status changes and centers are processed before groups before clients before accounts)
Groups
Requirement
The ETL should handle a Loan Officer change for a group with no hierarchy.
Test
Group: group w/o center hier LO change 0003-000000042 
Group Savings: group savings product # 000100000000076
Client: client for group w/o center hier LO change xxx 0003-000000043
Client Loan: loan prod 1 # 000100000000078 
changed 'smith' to 'xxx'
Result
Pass. Group, client and account entries as expected.  As LO change was done on same day as group, client and account creation... the LO change is treated as if it happened before the group active status and before the client and accounts were created (because changes on the same day are appled in order of new, hierarchy then status changes and centers are processed before groups before clients before accounts)
Requirement
The ETL should handle moving group with no hierarchy from one branch to another
BUG should audit like moving a client to another branch  but doesnt
Group: group w/o center hier xfer branch 0003-000000046 
Group savings: group savings product # 000100000000084
Client: client of group w/o center hier xfer branch xxx 0003-000000047
Client Loan: loan prod 1 # 000100000000086 
field_name old_value new_value
'Status'
'Loan Officer Assigned' old lo -
'Branch membership' old branch new branch
so can't pick up these changes
but is handled in the ETL code if its fixed.
Requirement
The ETL should handle center change for a group to center in same branch
Group: group for change to center in same branch 0003-000000056 
Savings: group savings product # 000100000000100 
Result
Pass. 
Requirement
The ETL should handle center change for a group to center in different branch
Group: group for change to center in diff branch 0003-000000057 
Savings: group savings product # 000100000000102 
Result
Pass. but mifos BUG changing of status to on-hold not audited.
Requirement - to do
The ETL should handle adding a group hierarchy back to a center
This looks to be covered. do one more test on diff days.
Test
Group: group going back to a center hier 0003-000000052 
Savings: group savings product # 000100000000095 
fail. it thinks it was part of the hierarchy all the time...
Centers
Requirement
The ETL should handle a Loan Officer change for a center
Test
Center: center with a LO change 0003-000000032
Center Savings: center savings # 000100000000067 
Group: group for center LO change 0003-000000033 
Group Savings: group savings product # 000100000000064
Client: client for center LO change xxx 0003-000000034
Client Loan: loan prod 1 # 000100000000066 
Result
Pass. center, group & client customer entries good and associated accounts good.ff

Transaction Tests

Requirement

Test

Result