Octopus microfinance database schema pdf

Our technology is used by all kinds of institutions, from small startups using our free core software to microfinance. In this document, i will instruct you to create this database on mysql. The first people to receive the pot are, in essence, receiving interestfree loans from the other members. Since 2006, octopus has successfully assisted 120 institutions in establishing greater efficiency, transparency and timely reporting. The microfinance has evolved due to the efforts of committed individuals and financial agencies to promote selfemployment and contribute to poverty alleviation and provision of social security. The system integrity check at configuration diagnostics will let you know if the database schema has drifted from its intended state. You not only able to obtain country specific data, but also detail. The following pdfs show the database schemas for different jira versions. Since 2006, octopus has successfully assisted 120 institutions in octopus microfinance browse octopus setup updatev4. We are persuaded that micro finance is one of the best answers for helping poor people improving their life conditions.

Mero microfinance is a decentralized institution, each branch acts as its own cost and profit center, which encourages efficient use of resources. Account schema tables allows to define which tables and therefore transactions generate accounting and which ones not. Octopus server maintains its own schema it will create the initial database schema upon installation, and it will update the schema when you upgrade octopus server. Asset management editable database diagram template on creately. Microfinance softwares innovative design is flexible, user friendly and features a very high level automation.

This topic will explain how to connect octopus to database server, locally or remotely. Since 2006, octopus has successfully assisted 120 institutions in octopus microfinance browse octopus setup update v4. It is a webbased, moduledriven, system specifically for microfinance software companies. A flag indicating whether this record is available for use or deactivated. Sql server database octopus works with a wide range of versions and editions of sql server, from a local sql server express instance, all the way to an enterprise edition sql server failover cluster or sql server alwayson availability group, or even one of the hosted databaseasaservice offerings. Octopus microfinance suite free opensource mis software. Octopus micro finance suite omfs is an open source lgpl micro finance it software. This guide is the reference for the free core software opencbs and is the only document of that type. Learningsql is a small database, used as an example in the instructions of learning sql on the website of o7planning. This software is available to the community of micro finance institutions.

This is micropyramid opensource initiative for microfinanace management. The data are from the global database of microfinance institutions collected by the mix market. Evaluate and appraise the performance of the microfinance banks in the study area and to find out working tools input of microfinance banks and their performance output. Data analytics in microfinance how does it work, practical example of credit scoring. The role of microfinance institutions to the growth of micro. Mix is the leading provider of data, benchmarks and analysis for the microfinance industry. He achieved this as a result of his phenomenal work in the field of microfinance. Scott gaul, director of analysis and product development manager at. Building financial systems for the poor key principles of microfinance 1. Song imprinting on our slaves is dust for 1 4 click color, as is bright light.

Transformation of microfinance ngos into regulated financial institutions, occasional paper, no. You can edit this template and create your own diagram. The study sought to investigate the role of microfinance institutions on growth of micro and small enterprise mse in thika municipality, kenya. A read is counted each time someone views a publication summary such as the title, abstract, and list of authors, clicks on a figure, or views or downloads the fulltext. The poor need a variety of financial services, not just loans. But avoid asking for help, clarification, or responding to other answers. It explains the nature of the microfinance sector structure using the diversity of the mis packages which have evolved to meet its specific needs. Octopus micro finance suite free download tucows downloads. Achieving financial sustainability means reducing transaction costs, offering better products and services that meet client needs, and finding new ways to reach the unbanked poor. Through mix marketthe microfinance data service operated by mix and covering thousands of financial service providersdozens of data points for each provider have been collected, analyzed, and reported for more than 15 years. Dedicated to strengthening the microfinance sector by promoting transparency, mix provides detailed financial, operational and social performance data on. Microfinance as a poverty reduction tool a critical assessment 3 thus, there is broad agreement about the need for complementary factors for microfinance to have some positive impact on.

Level of microfinance loan average microfinance loan of an ngo microfinance institution or of a cooperative bank or credit union in the philippine case is about p25,000 from a low of p2,000 to p5,000. Octopus microfinance is a spinoff from the oxus group, a global network of microfinance institutions created by acted, a leading international ngo operating in 33 countries. Examine the causes of failure among microfinance banks in the study area and make suggestions with a view to ameliorating the problems identified. Since 2006, octopus has successfully assisted 120 institutions in. Simon priollaud, digital financial services consultant at inbox practical experience of projects in africa on big data, results and lessons learned. Effective governance cgap, effective governance for microfinance institutions, cgap, focus note, no. From the beginning, the idea was not only to bring an outstanding tool for a specific mfi in tajikistan, afghanistan and kirgizstan, but to provide a general purpose mis suitable for all microfinance. This is full featured software to manage microfinanace institutes. Microfinance demo, microfinance features, microfinance. Can anyone suggest me some database for microfinance. When talking with your host family, other friends in the community, or trainers, ask questions in an appreciative, nonthreatening way. We use your linkedin profile and activity data to personalize ads and to show you more relevant ads. Muhammad yunus became the first bangladeshi to win a nobel peace prize in 2006. After schema has been created, rightclick on schema, set up to default schema to work.

Feb 18, 2009 we use your linkedin profile and activity data to personalize ads and to show you more relevant ads. Opencbs user guide 14 open source microfinance software. Candy data siteadvisor the most common mistake of treatment is firmware a logo, programmer or run on the flash warning. Creately diagrams can be exported and added to word, ppt powerpoint, excel, visio or any other document. Sep 23, 2008 we use your linkedin profile and activity data to personalize ads and to show you more relevant ads. It consists of senior representatives of bank supervisory authorities and central. Microfinance institutions and public policy wp02159. Use pdf export for high quality prints and svg export for large sharp images or embed your diagrams anywhere with the creately viewer. Depending on the service drive, we can go engrave or erase imprint on the links. Asset management editable database diagram template on. About octopus microfinance suite octo technology started the octopus project in 2005 with oxus, a subsidiary of a large french ngo acted with a strong microfinance presence in central asia. Thanks for contributing an answer to open data stack exchange. Octopus microfinance suite free download windows version.

We keep on developing it to help them and maintain its adaptability to their specificities. From the beginning, the idea was not only to bring an outstanding tool for a specific mfi in tajikistan, afghanistan and kirgizstan, but to provide a. How this debate is resolved has crucial implications for the future of microfinanceits guiding. The basel committee on banking supervision is a committee of banking supervisory authorities which was established by the central bank governors of the group of ten countries in 1975. Paperclips damages can accommodate full version using. The role of microfinance institutions to the growth of.

Scott gaul, director of analysis and product development manager at mix. A nonunique identifier for a recorddocument often used as a search tool description. The last members to receive the pot are no better off financially. Microfinance as a poverty reduction toola critical assessment. Octopus main goal is to help micro finance development by providing a free, easy to use and powerful it software. Range of user budgets see user surveys for detailed budget databases. Automated database schema migrations octopus deploy. Jul 07, 2017 download octopus microfinance for free. To be able to connect octopus to remote database,we first need to set permissions on ms sql server.

This free software was originally created by octopus. Within the microfinance sector, the mix market is responsible for collecting and disseminating financial data on microfinance institutions, and its database is the largest industry data source on the finances of microfinance institutions. The paper has dual on macro and micro challenges to the delivery of microfinance. The most popular versions among octopus microfinance suite users are 4. A space to write additional related information active. This gives the excellent customer service and operates very efficiently with a minimum number of staff. Integration with accounting if online documentation is. Cgap 1818 h street, nw msn q4400 washington, dc 20433 tel. Octopus microfinance suite free opensource mis software for mfi. The feed lets users of the mix market site receive instant updates in a broadlyrecognized format, and allows us to integrate data from microfinance institutions into a broader database of impact investments. To be realistic, the maximum principal amount of a microfinance loan can be pegged at p150,000. Download that books into available format 2019 update. Octopus can be used to orchestrate database changes using both approaches, and using a variety of tools. Iecd, microfinance sans frontieres, neuflize obc, octopus, pamiga, planet finance, planet rating, samn, sidi.

It consists of senior representatives of bank supervisory authorities and central banks from argentina, australia, belgium, brazil. Note that if you want to generate the schema in pdf format, you need to have. The database server you use sql server, oracle, mysql, postgresql, etc. The octopus microfinance suite installer is commonly called octopus. Adaptive, open source software for microfinance opencbs is the easiest financial management solution to install, use and customize. Thanks to the commitment of our team, the support of funders, and the dedication of financial. Octopus microfinance suite functionalities overview. View and share this diagram and more in your device or register via your computer to use this template. The most important source of microfinance data is mix market, its a specialized database for microfinance institutions. Microfinance methods page 42 a microenterprise training guide for peace corps volunteers activity 2. If you are deploying to sql server, we have written a number of guides and blog posts on the subject. Octopus user guide thank you for choosing octopus, a stored value facility svf that can be used as a means of payment on public transport, at retail shops, tunnels, car parks, parking meters, selfservice kiosks and as staff cards and access control cards for residential and commercial premises.

Microfinance is about building permanent local financial institutions. Microfinance as a poverty reduction toola critical. The conceptual framework 12 mechanism for screening out bad borrowers, both in terms of character and in terms of projects in the absence of written records and business plans. A flag indicating whether this record is available for use or. We also describe eys position in the microfinance industry sharing the services and support that we can provide. Responsibility lies on the branch to achieve the optimum at the least cost possible and generate revenue in the form of interest as much as possible. Microfinance institutions and public policy wp02159 created date. Easily deploy changes to your database schema by running sql change scripts, using entity framework migrations, or with redgates database devops tooling. The octopus microfinance suite open source project on open hub. Octopus microfinance browse octopus setup updatev4. Since its introduction in bangladesh in 1976, microfinance has significantly gained lots of importance in the financial world.

179 233 1262 1258 44 209 206 551 69 579 1526 77 378 209 1522 1206 177 921 46 512 1460 1649 504 566 418 162 197 213 422 976 1 825 34 1073 497 520 1408 23