Title: Message Title
|
|
|
|
Implementation details :
Adding script to insert 'fundType' code name to m_code table.
Introducing new column in m_loan table called 'fund_type_cv_id' is the foreign key which capture m_code_value primary key data and another column funding_date which capture the date of funding.
Creating new table called m_fund_loan_mapping_history which has fields loan_id, fund_id, fund_type_cv_id, start_date, end_date to capture the history of fund, fundType associated with loan.
In new/edit loan application 'Fund type' eg.. hypothication, buyout, etc...
and 'Funding date' will be added, both fields are optional.
When 'fundType' is associated with loan and 'fundingDate' is not entered then current date is stored in 'funding_date' field in m_loan table.
When first time combination of 'fund', 'fundType' associate with loan while create/edit at that time 'loan_id', 'fund_id', 'fund_type_cv_id', 'start_date' is captured in m_loan_fund_mapping_history.
Whenever 'fund' or 'fundType' or both changes then 'loan_id', 'fund_id', 'fund_type_cv_id', 'end_date' is captured in m_loan_fund_mapping_history.
To associate loan a/c's fetch loan a/c's based on the parameters like loan status, product, office, loan outstanding percentage, loan outstanding amount e.t.c.
Then 'fund' and 'fundType' is associated with loans in bulk fashion.
|
|
|
|
|
|
|
|
------------------------------------------------------------------------------
Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
MIFOSX-908
