ETL not picking up Loan Officer leaving one branch and joining another
----------------------------------------------------------------------
Key: MIFOSBI-313
URL: http://mifosforge.jira.com/browse/MIFOSBI-313
Project: mifos business intelligence
Issue Type: Bug
Affects Versions: Mifos BI 1.2
Reporter: johnwoodlock
Assignee: johnwoodlock
Priority: Major
Mifos no longer creates personnel_movement entries. Don't know when this
started. Guess is 2.1.x
The personnel_movement table was used by ETL to pick up loan officers going to
new branches. ETL fell over for Digamber prod because some loan officers had
moved branch. The ETL thought this new branch was the 'first' branch and fell
over because of date created problem. Even if it didn't fall over it wouldn't
have recorded the loan officer branch movements correctly and LO reports would
likely be wrong.
Probably not worth fixing mifos. The same info is recorded on the mifos audit
table 'change_log/change_log_detail' but that has the problem of recording
changes by the branch name rather than the branch id so problems can occur when
branch name is edited.
So, think this will need an ETL upgrade for full fix. Can get ETL to run
through with a data fix to allow non LO reports to be viewed.
So, data fix requiredd? and/or full fix required (Binny/Kay).
If full fix done think I'd put some better 'lookup logic in' to reduce chance
of problems and clear message about where problem is before running the main
ETL code.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
