SQL dump JECFA

Affiliates: 5 $ — how to earn
Pay with:
i agree with "Terms for Customers"
Sold: 0
Refunds: 0

Uploaded: 24.01.2010
Content: okpd.rar (659,28 kB)

Description

SQL dump JECFA SQL dump JECFA

National Classification PRODUCT BY ECONOMIC ACTIVITY. (SQL dump)

This guide is a systematic list of goods and services, developed on the basis of the Russian Classification of products by economic activity (JECFA), which is part of the national standardization system of the Russian Federation.

The archive sql dump format name.sql (UTF-8)

Additional information

Information about the National Classification.
The basis for the development of the Russian Classification of products by economic activity are the Federal Target Program "Development of the state statistics of Russia in 2007-2011", approved by the Government of the Russian Federation dated October 2, 2006 № 595 and Decree of the Government of the Russian Federation dated November 10, 2003 № 677 "On the national classifications of technical, economic and social information in the economic and social field" (as amended on August 4, 2005 № 493).

Adopted and put into effect
Order of the Federal Agency for Technical Regulation and Metrology of November 22, 2007 № 329-st
for the period from 1 January 2008 to 1 January 2011 without the abolition of the all-Russian classifier of production OK 005-93, Parts II and III All-Russian qualifier of kinds of economic activities, products and services OK 004-93, and All-Russian qualifier OK 002-93 services to the population.

The JECFA used a hierarchical classification method and consistent coding. The code consists of 2 - 9 numeric characters, and its structure can be represented as follows:

XX class
XX.X subclass
HH.HH group
HH.HH.H subgroup
HH.HH.HH views
HH.HH.HH.HH0 category
HH.HH.HH.HHH Subcategory

To ensure compliance with code words JECFA and CPA 2002 between the second and the third, fourth and fifth characters of code a dot. In the presence of additional JECFA compared with levels of CPA 2002 division point is placed between the sixth and seventh characters of the code. By analogy with the CPA 2002 in the JECFA includes sections and subsections with preservation of their lettering.

Example:
-
- Dump the data in the table `okpd`
-

INSERT INTO `okpd` (` okpd_id`, `uid`,` parent_uid`, `title`,` description`) VALUES (38683, 'A', '0', 'Agriculture, hunting and forestry', ' ');
INSERT INTO `okpd` (` okpd_id`, `uid`,` parent_uid`, `title`,` description`) VALUES (38684, 'AA', 'A', 'Agriculture, hunting and forestry', ' ');
INSERT INTO `okpd` (` okpd_id`, `uid`,` parent_uid`, `title`,` description`) VALUES (38685, '01', 'AA', 'Products and services of Agriculture and hunting', '' );
INSERT INTO `okpd` (` okpd_id`, `uid`,` parent_uid`, `title`,` description`) VALUES (38686, '01 .1 ',' 01 ',' Culture of agricultural, vegetable and horticultural products', '' );
INSERT INTO `okpd` (` okpd_id`, `uid`,` parent_uid`, `title`,` description`) VALUES (38687, '01 .11 ', '01 .1', 'Culture of cereals and other crops, agricultural, not included in other grouping ',' ');
INSERT INTO `okpd` (` okpd_id`, `uid`,` parent_uid`, `title`,` description`) VALUES (38688, '01 .11.1 ''01 .11', 'Grain-crops', '');
INSERT INTO `okpd` (` okpd_id`, `uid`,` parent_uid`, `title`,` description`) VALUES (38689, '01 .11.11 ', '01 .11.1' 'Durum wheat', '') ;
INSERT INTO `okpd` (` okpd_id`, `uid`,` parent_uid`, `title`,` description`) VALUES (38690, .11.11.110 '01 ', '01 .11.11', 'hard winter wheat', '' );
INSERT INTO `okpd` (` okpd_id`, `uid`,` parent_uid`, `title`,` description`) VALUES (38691, .11.11.111 '01 ''01 .11.11.110', 'hard winter wheat grain' ' ');
INSERT INTO `okpd` (` okpd_id`, `uid`,` parent_uid`, `title`,` description`) VALUES (38692, .11.11.112 '01 ''01 .11.11.110', 'Seeds of winter durum wheat', ' ');
INSERT INTO `okpd` (` okpd_id`, `uid`,` parent_uid`, `title`,` description`) VALUES (38693, .11.11.120 '01 ', '01 .11.11', 'Spring wheat solid', '' );

Feedback

0
No feedback yet.
Period
1 month 3 months 12 months
0 0 0
0 0 0
In order to counter copyright infringement and property rights, we ask you to immediately inform us at support@plati.market the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)