MASTER LIST OF PUBLIC LIMITED COMPANIES

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