TILT FieldName Catalogue
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFG
1
Catalogue of all FIELDS
2
MFTransparency TILT 2.0 System
3
Field NameINSTPRODFEESAMPLEPRICEDescription & Comments
4
CORE INFO
5
UniqueInstCodexMain identifier for Inst Table - Country Code, InstNum, VersionNum.
6
UniqueProdCodexxMain identifier for PROD and FEE Tables - Country Code, InstNum, VersionNum, ProdNum
7
UniqueSampleCodexMain identifier for SAMPLE Table - Country Code, InstNum, VersionNum, ProdNum, SampleRecNum
8
SampleCodexMain identifier for PRICE Table - Country Code, InstNum, VersionNum, ProdNum, SampleNum, VariationNum
9
InstitutionNamexFull legal name of the institution
10
InstAbbrevxxxxA shorter form name, used in all tables in report. Must be a UNIQUE abbreviation compared to all other MFIs in the database
11
ProductNamexxFull name of the product, as given by the MFI
12
ProdNamexFull name of the product, as given by the MFI
13
ProductNameENGxConvert the name to English if in other language
14
ProdAbbrevxProduct name shorted to no more than 12 characaters, used for display in limited-space areas of website
15
CountryNamexName of the Country where the MFI is located
16
CountryCodexxxxxA standardized two-digit country code
17
ProdSortxxA useful re-ordering of the UniqueProdCode to sort by Product-Then-Version rather than Version-then-Product
18
ProdSortCodexA useful re-ordering of the UniqueProdCode to sort by Product-Then-Version rather than Version-then-Product
19
InstNumxxxxxUnique code, starts with 001 in each country
20
VersionNumxxxxxUnique code for each time data is submitted
21
ProdNumxxxxUnique code, starts with 01 for each institution. Retired products can disappear from new versions of refreshing
22
SampleNumxTagged to Sample number in SAMP table
23
VariationNumxIs 1 if only one price run for each sample; otherwise it counts up
24
GNIPerCapitaxUsed to convert all loan amounts to "% GNI/Capita"
25
NatlCurrencyxCode for the national currency.
26
ProdCurrencyxxxCode for the currency used in that loan product
27
ExchangeRatexxExchange rate on day of approval, units of local currency to buy US$1
28
29
STATUS OF INFO
30
InfoStatusxxxxChoices are:
* Current (latest info);
* Archive (previously published info);
* Declined (INST Table only: never completed FIRST submission, if an MFI fails to refresh, no new version is created).
Old data is determined by the AgeOfData field, not by this InfoStatus field
31
ProdStatusxShows current product status at time of record collection-
* Active
* LowVolume
* Rejected
* (Retired is not possible because there is no record in PROD for retired products)
32
MinClientProductxIndicates "Y" if less than 50 active clients, and product is marked LowVolume
33
DormantProductxIndicates "Y" if less than 10 new loans disbursed in past 9 months, and product is marked LowVolume
34
MFISubmitAnywayx N/A if not a LowVolume product; "Y" if the MFI requests to submit data anyway for a LowVolume product; "N" if they opt not to
35
LatestInfoxxxxxUsed to mark the latest published info. Records with "x" are latest info and all belong to the same "version"
36
InfoUnchangedxIndicates "X" if all "essential" data points are unchanged since last version (loan amount, price info, etc)
37
NotPublicInfoxxxxxUsed to mark any PRIVATE records. Records with "x" are PRIVATE
38
DateDCTCreatedxThe date the DCT was created; used for the folder-name of that version, eg, V01-20130301
39
WhoSavedCSVxName of the logged-in person when the CSVs were generated
40
DateJoinedxDate of the first data approval
41
ApprovedByxName of MFI person approving the submitted data
42
DateApprovedxxxxDate the DCT was approved. The same DateApproved is used for ALL records in ALL tables associated with that version.
43
DCTVersionxShows the version of the Data Collection Tool (DCT) used
44
45
INSTITUTION INFO.
46
InstTypexxText description of the Institutional type
47
ProfitStatusx.For-Profit, Non-Profit
48
RegulatedInstx.If marked with "x" this is a regulated institution
49
YearEstablishedx.four-digit year code of the year the MFI was established
50
AgeYearsxCalculated from YearEstablished to DateApproved of the current version record. These figures do not get updated in older records, so show the age at the time the data was submitted
51
MixCodexStaff look up the MIX ID Code and enter it here
52
MixURLxStaff look up the URL and enter it here
53
MixYearxMost recent year of MIX data
54
55
PUBLIC CONTACT INFO
56
WebsitexInstitution's website address
57
Address1xInstitution's head office address - line 1
58
Address2xInstitution's head office address - line 2
59
CityxInstitution's head office address - city
60
ProvincexInstitution's head office address - region
61
PostalCodexInstitution's head office address - postal code
62
63
PRODUCT INFO
64
ProductDescripxBrief description of the product
65
ProductDescripENGxBrief description of the product translated into English
66
ProdContractFileNamexName of the contract PDF
67
ProdContractEditedFileNamexName of the edited contract PDF
68
Region-Specific Criterial
69
RBIAssetxOnly for India
70
71
SCALE AND TARGET GROUP
72
DateOfScaleStatsxDate of the portfolio and client numbers
73
NumBranchesxNumber of active branches operated by the MFI
74
NumProductsxNumber of products input by the MFI, since initial data submission, including retired products
75
NumActProdsxNumber of active products (retired products not included, but LowVolume products are included)
76
Client Stats
77
TotalNumClientsxTotal number of borrowers for the institution.
78
SumProductClientsxSums number of borrowers input for each product in the PROD table
79
ProductClientsxxTotal number of clients for this loan product
80
PercTotalClientsxCalculated as ProductClients / SumProductClients
81
ProdRankClntxRank from high to low by number of clients
82
TotalPercFemalexPercent females for the institution. If 10, 30, 50, 70, or 90, then MFI selected the quintile range (eg, 30 means they selected "between 20% and 40%)
83
TotalPercUrbanxPercent urban for the institution. If 10, 30, 50, 70, or 90, then MFI selected the quintile range (eg, 30 means they selected "between 20% and 40%)
84
ProdPercFemalexPercent females from the product client figure. If 10, 30, 50, 70, or 90, then MFI selected the quintile range (eg, 30 means they selected "between 20% and 40%)
85
ProdPercUrbanxPercent urban from the product client figure. If 10, 30, 50, 70, or 90, then MFI selected the quintile range (eg, 30 means they selected "between 20% and 40%)
86
Portfolio Stats
87
TotalPortfolioxTotal portfolio for the institution, entered in currency of the loan product. This is difficult to get for just MICRO-credit, so some times it will be ALL their credit products.
88
TotalPortfolioUSDxCoverted to US$ at indicated exchange rate
89
SumProdPortUSDxAdds ProdPorfolioUSD figures for all products (Note: We don't just add their TotalPortfolio figures, because those can be in multiple currencies)
90
PercProdPortxCalculation of ProdPortfolioUSD / TotalPortfolioUSD
91
ProdPortfolioxPorfolio for the product, entered in local currency
92
ProdPortfolioUSDxCoverted to US$ at indicated exchange rate
93
PercTotPortxcalculated as ProdPortfolioUSD / SumProdPortUSD, to cross-check the data entered
94
OverallAvgLoanBalUSDxCalculated as TotalPortfolioUSD / TotalNumClients
95
OverallAvgLoanBalGNIxCalculated as OverallAvgLoanBalUSD/GNIPerCapita
96
ProdAvgLoanBalxCalculated as ProdPortfolio / ProductClients
97
ProdAvgLoanBalUS$xCalculated as ProdPortfolioUSD / ProductClients
98
ProdAvgLoanBalGNIx
99
Client Estimates by Loan Size
100
Loading...
Main menu