[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mifos-developer
Subject:    Re: [Mifos-developer] Explanation of Loan Offering table
From:       "Priscilla Dosiou" <pdosiou () grameenfoundation ! org>
Date:       2007-10-26 18:43:52
Message-ID: 9DD845C1ED0D5D40B4B56DF5A4B1EB0E0214FE6B () gfmail ! gfusa ! org
[Download RAW message or body]

Hello Elaine, 
Welcome to Mifos!  

> I was wondering if anyone can provide any descriptive documentation of
> this - i.e. what each of the fields means, how it is used in the
system
> and how changing a value in such a field would affect the functioning
of
> the system and the calculation of loan repayments.

The functional specification is the best place to find this information
- there is a comprehensive table that gives descriptions of each product
attribute.  The relevant pages are here
http://www.mifos.org/knowledge/functional-specs/product-definition 

Cheers, 
Priscilla 

-----Original Message-----
From: mifos-developer-bounces@lists.sourceforge.net
[mailto:mifos-developer-bounces@lists.sourceforge.net] On Behalf Of
Elaine Baker
Sent: Thursday, October 25, 2007 6:24 AM
To: mifos-developer@lists.sourceforge.net
Subject: [Mifos-developer] Explanation of Loan Offering table

Hello

My name is Elaine Baker and I work as a systems analyst in the
University
Computing Centre in Dar es Salaam, Tanzania.  We are currently
evaluating
MIFOS as a possible software for use by microfinance organisations here
in
Tanzania.

Bart pointed me to
http://build.mifos.org/schema/tables/loan_offering.html
 which is a list of fields and relationships of the loan offering table.

This is a key table of interest for us as it shows how flexible MIFOS
can
be - i.e. all the different types of loans and repayment schemes which
could be made available.

I was wondering if anyone can provide any descriptive documentation of
this - i.e. what each of the fields means, how it is used in the system
and how changing a value in such a field would affect the functioning of
the system and the calculation of loan repayments.

Such documentation will help us assess the flexibility and adaptability
of
MIFOS to different types of loan products.

Best wishes
Elaine Baker

University Computing Centre Ltd
P.O.Box 35062
Dar es Salaam

Telephone: +255 22 2410645
Fax:       +255 22 2410690
Email:     ebaker@uccmail.co.tz

Hi,

If you have specific questions about the tables, please go ahead and
pose
them to the listserv.  As you'll see it's quite an open forum, a
free-for-all.  The schema spy output is quite good: 
http://build.mifos.org/schema/tables/loan_offering.html  Are you writing
code to interface with or pull reports from the table?  Or trying to
evaluate the functionality to see if it suits some purpose?



Cheers,
Bart




------------------------------------------------------------------------
--------

From: Elaine Baker [mailto:ebaker@uccmail.co.tz]
Sent: Thursday, October 18, 2007 2:35 PM
To: Bart Berning (Consultant)
Subject: RE: [Mifos-developer] Data model diagrams?



Hi Bart



Thanks for your reply.  I am on the MIFOS functional list serve but not
on
the developer one - perhaps I will join it just now.



This list of tables is a first step but it would be great to have a
narrative description highlighting the most important tables and fields
and what they are used for, like an overview of the structure.  I would
especially like to know which table(s) contain the data on the structure
of the loan products and what the different fields in these tables mean.



Best wishes

Elaine



University Computing Centre Ltd

P.O.Box 35062

Dar es Salaam



Telephone: +255 22 2410645

Fax: +255 22 2410690

Email: ebaker@uccmail.co.tz

-----Original Message-----
From: Bart Berning (Consultant) [mailto:bberning@grameenfoundation.org]
Sent: 17 October 2007 23:05
To: Elaine Baker
Subject: FW: [Mifos-developer] Data model diagrams?



Hi Elaine, I'm not sure if you're on the mifos-developer listserv,
there's
been some positive action about data model diagrams today, have a look
if
you get a chance!



Bart




------------------------------------------------------------------------
--------

From: mifos-developer-bounces@lists.sourceforge.net
[mailto:mifos-developer-bounces@lists.sourceforge.net] On Behalf Of Amy
Bensinger (Contractor)
Sent: Wednesday, October 17, 2007 7:52 PM
To: Developer
Cc: mifos-developer-bounces@lists.sourceforge.net
Subject: Re: [Mifos-developer] Data model diagrams?



Rephrasing  Ofer:



The diagram @  http://build.mifos.org/schema/  is fairly recent and
eventually will be up-to-date, as well as automated to stay up-to-date.



The only downside of schema spy is that it doesn't format the whole
diagram to be suitable for printing, though it seems that the software
that Bart mentioned would also be very laborious to do so.



I have found this diagram useful thus far-just proceed with a bit of
caution until it's "officially" released.








------------------------------------------------------------------------
--------

From: mifos-developer-bounces@lists.sourceforge.net
[mailto:mifos-developer-bounces@lists.sourceforge.net] On Behalf Of Amy
Bensinger (Contractor)
Sent: Wednesday, October 17, 2007 9:23 PM
To: Developer
Cc: mifos-developer-bounces@lists.sourceforge.net
Subject: Re: [Mifos-developer] Data model diagrams?



Actually, we have something available, but it's not quite ready.
Ofer-any
comment?




------------------------------------------------------------------------
--------

From: mifos-developer-bounces@lists.sourceforge.net
[mailto:mifos-developer-bounces@lists.sourceforge.net] On Behalf Of
Senthil K Ramachandran
Sent: Wednesday, October 17, 2007 7:48 PM
To: Developer
Cc: Developer; mifos-developer-bounces@lists.sourceforge.net
Subject: Re: [Mifos-developer] Data model diagrams?




Hi Brat/Dion,

Hopefully MySql workbench will help to an extent with respect to data
model reverse engineering.

Regards,

Senthil Kumar R
IBM India Pvt Ltd
FSS - Core Banking Team
Bangalore
Mobile +919900103849

"Dion Dodgen" <dion.dodgen@sadalbari.com>
Sent by: mifos-developer-bounces@lists.sourceforge.net

17/10/2007 18:47

Please respond to
Developer <mifos-developer@lists.sourceforge.net>


 To
 Developer <mifos-developer@lists.sourceforge.net>

cc


Subject
 Re: [Mifos-developer] Data model diagrams?













Hi Bart,

It's around 17MB. I don't mind giving the datamodel diagram creation a
whirl as I'm in need of them at the moment.

Where can I share them if successful? I would presume under
....../mifos/documents.

Thanks
Dion

On 10/17/07, Bart Berning (Consultant) <bberning@grameenfoundation.org>
wrote:
> Has anyone generated, or would anyone volunteer to generate data model
> diagrams of the mifos database?
>
>
>
> These diagrams would be helpful understanding Mifos, doing data
> migrations, etc., and are requested fairly often.
>
>
>
> I've heard SQirreL SQL Client can generate DB data models easily.
> http://squirrel-sql.sourceforge.net/  If it's not too colossal I'll
> download and try it in the next week.  If you've already beaten me to
> it, please share your experience and outcome!
>
>
>
> Cheers,
>
> Bart
>
>
>
> Nairobi
>
>

------------------------------------------------------------------------
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/


------------------------------------------------------------------------
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/



[prev in list] [next in list] [prev in thread] [next in thread]