Cyril
For getting MODULE #1 started, we gave you a Master
List of Companies consisting of both "Limited" and "Private
Ltd" companies. Some 14000 + records. This was compiled from KOMPASS -
1993 directory.
Although
most of the companies mentioned here are "irrelevant" for us, we had
to have some Master - List to start Module 1.
As each
resume gets entered into Module 1, the "relevant" companies list will
grow.
Independent of this, for the last, 4/6 weeks, we
have been trying to compile a
MASTER LIST OF (PUBLIC) LIMITED COMPANIES from
various source - documents.
These sources are listed in Annex : (A)
We are not using all of these sources, but I have
listed these to emphasize that there could be many - many sources.
How would such a MASTER LIST help?
What can we do with it?
I have shown this in Annex : (B)
This is self - explanatory.
Because of the multiple "uses" envisaged in Annex (B), the CORPORATE
DATABASE shown in Annexure, has a lot of "fields", for more than the
Master List given to you for Module #1.
For the moment, even the current list (of Limited
companies) being compiled has only
. Company Name
. Company Address (HO address)
But, we cannot compile a "new" corp.
database every 3 months, as we discover a "new" use for it !
It would be highly desirable, if we can, right now,
devise a database "structure" which would take care.
of our needs for the foreseeable future. Then, in
such a structure, we may go on adding more & more data in on "incremental"
manner, as when, we get hold of such data.
This is the same concept as in the case of our
NON - MEMBER EXECUTIVE DATABASE.
Companies can also be "Members" (i.e.
clients) or "Non - Members" (i.e. Potential Clients)
We, most certainly need to create such a MASTER
CORPORATE DATABASE for our module #2 (Order Execution). And we must start creating this MASTER right
now, so that it is ready by the time you are ready to install Module #2. Without this, we will simply not be able
to implement Module 2.
I would, therefore, request you to take up on a
priority basis, the design of the database struck & make it available to
sajida, so that she can start creating such a database and keep it ready within
2/3 months.
While developing the data - entry software (for
MASTER CORPORATE DATABASE), please ensure that whatever data entry we have
already done can be directly migrate to the new structure and that we do NOT
have to re - key in all the fields. This
is very important.
For this purpose, you may even depute Lind say to
examine the existing database structures of several corp. databases which are
floating around in our network.
Then there is also a question .
Can we directly migrate to our MASTER, company
databases from
. Explore India CD
. CII floppy
. KOMPASS - 1996 CD
. (Available from Hongkong For $1000)
. Kothari CD (expected in 3/4 months)
. TATA PRESS, GETIT, SELPAGE Directories
. "Capex / PROWESS" online databases from
CMIE (Annual subscription of Rs. 40,000 / 50,000 each)
. Databases being offered by VIPUL ZAVERI
. MTNL Phone Directory CD
. VSNL e - Mail directory floppies (60,000
addresses which we recently obtained & trying to get 300,000) This contains
3000/ 4000 Public Limited Companies.
Our aim should be to obviate/ eliminate manual data
entry wherever such data (even in a truncated manner) is already available on electronic media.
cc : Nirmit / Sajida
PUBLIC LIMITED COMPANIES MASTER LIST
(Companies ending with “LIMITED / LTD")
SOURCES FOR COMPILATION
1. KOMPASS Directory (Printed) 1993
2. KOMPASS CD - ROM (Printed) 1996
3. Stock Exchange Directories (for all stock
exchanges)
4. Directories such as KOTHARI/ IRIS
5. Membership Directories of various Professional
Bodies such as
.
Chambers of Commerce (city wise)
. CII /
FICCI / ASSOCHAM / NASSCOM
. Institution
of Engineers
.
Institution of Plant Mars/ Personnel Mgrs/ Ind. Eng
. CA/
CS Directories.
6. Annual Reports
7. Quarterly / Annual Financial Results Advts.
8. Product Advts.
9. Job Advts. (Print Media)
10. Job Advts. (Posted on our website)
11. "Explore India" CD
12. CMIE / DART/ DSJ / MATRIX INFORMER/
13. INFOINDIA (INDIA INFOLINE Web site)
14. Indian web search Engines (Khoj - 123 India
etc).
15. Y 3P Executive - resume database
16. Conference / seminar Participant Lists
17. Mobile Phones/ Credit Cards/ Air - Hotel
Reservations
18. Corporate Profiles/ Industry Profiles
19.
Telephone Directories Yellow Pages
h.c.parekh
