Data table

Name and address data of the companies can be seen on this area, moreover the indicator data which are the bases of filtering. The following fields can be found in this window:

• ID number: Identifying number of the company, 8 characters
• NACE code: Main activity code of the company (branch code), 4 characters (naming see on the Company's properties).
• GFO: Code of the company's economic activity, 3 characters (naming see on the Company's properties).
• County: County code according to the head quarters (area code) 2 characters.
  Note: the above mentioned 4 fields form the so called "statistical number", which is 17 characters long.
• Name: The entire name of the company recorded in the HCSO (Hungarian Central Statistical Office) database, all capitals, maximum 116 characters long.
• Zip code: Postal code according to the head quarters.
• Head quarter: maximum 20 characters, in case of Budapest address with district number.
• Street, house no.: maximum 40 characters.
• Staff category: The company staff category code, 2 characters (naming see on the Company's properties).
• Revenue category: Revenue category code of the company, 1 character (naming see on the Company's properties).
• Date of formation: Date of the company's formation.

This window is the key screen of application. Here can be created the set of filtering criteria by which the relevant companies we want to see. We can filter for several conditions at the same time: altogether 9 criteria. These criteria are the following:

Substring in the name
Date of formation
County according to the head quarters
Settlement according to the head quarters
Main activity code (NACE-code)
Manufactured product code (according to BTO)
Revenue category
Staff number category
Management (economic) form code

Logic of filtering is simple: conditions within one criteria related by "or", criteria with each other related by "and" connection. If user traces for example Baranya and Fejér counties and 1-4 staff categories, it means that we are looking for the firms based in Baranya or Fejér  and have 1-4 persons employed.

Selection happens in 2 ways: in case of 5 criteria with the help of check box and edit box, in case of the other 4 criteria a separate window serves for tracing the values of the condition.

Important: the following principle is valid for all criteria: if in a given criteria there is no condition traced, than any kind of relevant company gets into the result set.

Let's see the 9 points in more detailed:

1. Substring in the name
Only companies which name contains this string anywhere, gets into the result set.

2. Date of formation
The check box and edit box under it are to be used only if companies founded in a certain interval are searched for. The interval can be given by years and quarters.

3. County according to the head quarter
Selection of the counties by check box in the first "tab" of the window. Budapest is here as the twentieth county beyond the 19 administrative counties.

4. Settlement according to the head quarter
The list box can be found in the first "tab" of the window, which the selected settlement names are taken into. Selection can be initiated by pressing the "Settlements" button above the box. Maximum 30 settlements can be selected. Important: the program does not control the logical connection between the selected settlements and traced counties. For example if the user selects only Tolna county and Debrecen, since the 2 respect is in "and" connection, none of the companies will meet this criteria. It is important to emphasise that districts of Budapest are listed as separate settlements in the Settlements file (i.e.: XIII. DISTRICT, BUDAPEST). So when the user want to select all companies in Budapest, than he should not select this criteria, but criteria County according to head quarter shown in point 1. (in case of Budapest county code is "01")! About the way of selection see page Multiple-element selection via/through window .

Moreover it has to be noted that in the information panels in windows of Companies (filtered file) and Registered filters the settlement code can be seen, not the name of the head quarters. This code is a 4 characters number used by Central Statistical Office which helps to detect the settlement definitely. Be careful: settlement code is not the same as the postal code!

5. Main activity code (NACE-code)
It can be initiated with the button "NACE-code" found on the second "tab" of the window. In this case it displays Activities  window. Returning from the selection the selected activity names go into the list box near the button. Maximum 30 activities can be selected. About the way of selection see page Multiple-element selection via/through window .

6. Product codes (according to BTO)
This criteria differs from the others a little bit. In the register of HCSO data can be found definitely for the other 6 criteria. Every company head quarters has a definite address, so it belongs to a county and settlement, main activity code, management (economic) form (LTD., Deposit company or anything else), staff number category etc are define and obligatory data. However we cannot talk about manufactured products in all cases, only in case of producer companies, and on the other hand the register of the HCSO does not record products manufactured by the companies. HCSO has data only from certain data collections. These data collections however not overall, but representative, so there is no exact data about every companies. Other problem is, that even if there is any data, it is possible that the company does not contribute to the publishing of its products. In this case of course these data cannot be registered into the Company-Code-Register CD. When setting the filtering criteria, please apply this criteria carefully, since for example for a given product the program does not find any company at all, however it does not mean that none of the companies produces the given product.

Selection can be initiated by the "BTO" press-button on the second "tab" of the window. Such a way we go to the  Products  window. Returning from the selection, names of the selected products go into the list box near the button. Maximum 15 products can be selected. About the way of selection see page Multiple-element selection via/through window .

7. Revenue categories
Categories are selected with check box in the third "tab" of the window. In the names near the boxes the category is given only in text format, in the data table in the main window of the program and in case of export to file only the code itself is written. That is the reason why it is useful to know the meaning of the codes (the same is true for the next described staff category and managenet form code also). Revenue categories can be found here .

8. Staff categories
Similary to revenue categories, selection happens with checkbox on the third "tab" of the window. Category codes can be read here .

9. Management form code (GFO)
It can be initiated with the "GFO" button on the third "tab" of the window. Names of the selected management forms are taken into the list box. Maximum 30 elements can be selected. About the way of selection see page Multiple-element selection via/through window  .

Revenue categories
0:  Unknown
1:  0 - 20 million HUF
2:  21 - 50 million HUF
3:  51 - 300 million HUF
4:  301 - 500 million HUF
5:  501 - 700 million HUF
6:  701 - 1000 million HUF
7:  1001 - 2500 million HUF
8:  2501 - 4000 million HUF
9:  more than 4001 million HUF´

Staff categories
00: unknown
10: 0 person
11: 1 person
12: 2 person
15: 3 - 4 person
22: 5 - 9 persons
30: 10 - 19 persons
40: 20 - 49 persons
50: 50 - 99 persons
61: 100 - 149 persons
62: 150 - 199 persons
70: 200 - 249 persons
81: 250 - 299 persons
82: 300 - 499 persons
91: 500 - 999 persons
93: 1000 - 1999 persons
94: 2000 - 4999 persons
95: more than 5000 persons

Sample: http://www.listas-de-mail.es/Company_Code_Register.txt