![]() |
|
|
|
|
Change By:
|
johnwoodlock
(04/Sep/12 7:42 PM)
|
|
Description:
|
Vishwas, I'm still working on this and will be updating through-out day.
For now, if you are ready for this task, you can start based on the following:
1) We want to implement that "m_office has 1 to many relationship to m_staff"
So, add new field office_id not null to m_staff and add foreign key relationship
2) We want to implement that "m_staff has 1 to many relationship to m_loan"
This relationship supports the loan officer that is dealing with the loan, so we want to name the supporting field accordingly i.e. there may be other relationships from loan to staff meaning other things afterwards.
So, add new field loan_officer_id to m_loan (allow null as not all MFI's use loan officers) and add foreign key relationship
Note that this is a change from mifos which has this 'same relationship' from personnel to customer (client). Linking to loan allows different loan programs to be run by different loan officers where the clients overlap.
3)
some fields
add is_loan_officer tinyint(1) not null default 0 to m_staff. This is a boolean field. We know that 'employees' may play different roles and that the system will want to interact with more than this one role but decided against implementing a "m_staff_roles" type table as we felt it would be overkill so we'd like to do a boolean field for each 'role system is interest in' - so far this is only loan officer. Note, role here is not the same as the m_role we use for system users and their permissions.
Thats it for now.
As usual, with your background working in the area if you can add to the 'modelling' ideas we'd welcome it. More relationships and fields will, of course, follow.
Out of Scope For This Task
--------------------------
Link between m_staff and m_appuser (pretend they are not linked for now)
'history' tables that track staff movement between offices and situations such as loan officer reassignments.
|
|
|
|
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
